Forms :: Clear Block If Value Change?

Dec 28, 2011

I Require to Fetch the Group of Value in Item Block Selected through the User Selected LOV Value in Master.

Through Loop i Fetch the Records in Item Block.

When User Change the Selected LOV Value Require to Clear the Item Block.

BEGIN
FOR NRM IN (SELECT MTRLTYPE,STATUS,
MTRL_NO,MTRL_ID FROM JAWOADMIN)
LOOP
GO_BLOCK('NRMTRL_ITEM');
:NRMTRL_ITEM.NRMTRL_TYPE := NRM.MTRLTYPE;
:NRMTRL_ITEM.REMARKS := NRM.STATUS;
:NRMTRL_ITEM.NRMTRLREF_NO := NRM.MTRL_NO;
:NRMTRL_ITEM.NRMTRLREF_ID := NRM.MTRL_ID;
NEXT_RECORD;
END LOOP;
END;

How to Clear the Block before the above loop.

View 1 Replies


ADVERTISEMENT

Forms :: Clear Specific Block?

Sep 21, 2010

i have 4 blocks in one form.my requirement is this that can i user the clear_block or any other built-in for clear the specific block....

View 2 Replies View Related

Forms :: Clear A Block For Enter Query Mode?

Jan 16, 2012

I am using Forms 6i,Oracle 10g. In a form I created, I have 3 blocks, first is a toolbar type with buttons to save, exit etc., other two are one master and detail data block.

how to get the default Oracle toolbar with the buttons, save, delete etc. I dont get in my form.

When the cursor is inside the detail block and then I click on an EnterQuery button in the first block, how do I clear the detail block, using the on btn press code.

What happens when I click the Enter Query button, is that the cursor and current block becomes the button block and when I run the command ENTER_QUERY, no use.

I need to set the block in which the cursor is to be cleared for query, whether it is master or detail, by pressing the button on the first block.

View 7 Replies View Related

Forms :: Clear Block B Once Click FIND Button

Jul 6, 2011

I am working on form builder 6i.I have FIND widnows and MAIN window.

FIND Window: contains field1 and field2, FIND Button.

block A: Multi record data block on table t1. It contains field1,field2,field3.
block B: non datablock, it contains field4, field5.

If i enter something and click FIND button, it will populate data in Block A.If i put the cursor in any record in block A, and after that put the cursor in Block B, it will populate block B related to Block A record.For this, In Block A--> post record(block level) trigger, i am capturing values in variables.

:GLOBAL.f1:=:BlockA.field1
:GLOBAL.f2:=:BlockB.field2

In Block B--> When-New-Block-instance(Block Level)

select field3, field 4 from t2 where t1=:global.f1 and t2=:global.f2;

and populating data in block B.It's working fine.

REQUIREMENT: If i click the FIND second time, in Block B--> it's retaining previous value. I want to clear the block B once i click the FIND button. I tried to write in POST-BLOCK (Block B-->block level)

CLEAR_BLOCK('NO_VALIDATE');

But it's not working.In which trigger i have to write code to clear block.

View 3 Replies View Related

Forms :: How To Clear Line Records When F11 Is Pressed In Header Block

Sep 4, 2011

I am working in form 6i, EBS 11i. I have below requirement to achieve.

I have header data block A, line control block B. My requirement is, i know that in master detail block, if i press F11 in header block, it will clear the line block, like this, in my case if i press F11 in header data block A, i want to clear the line block B. Is there any way we can achieve this.

View 3 Replies View Related

Forms :: Clear Block Message In Oracle Forms?

Nov 30, 2012

I am creating a form with 3 blocks.

Control block,
Header Block,
Detail Block.

First i have entered a record in the control block.

Then i navigate to header block,entered the first record for Header Block.

Then i navigate to Detail block,entered the first record for detail Block.

then i again navigate to Header Block..

Now the Problem comes....As i am Trying to enter second record for header block,the pop up comes as "Do you want to save the changes".

Condition 1:i dont want that message to appear for every header record i enter.

Condition 2:For every header record i enter,Corresponding detail record would have been entered.i want that detail records to be retained if i am clicking that header record as i have already created relationship for both header block and detail block.

View 1 Replies View Related

Forms :: Change Block Status In Custom.pll?

Mar 9, 2010

I have a requirement to get decrypted value of national_identifier from database and display in Social Security number, when user queries for employee in employee form of HRMS. Also, National_identifier should be in encrypted format in database table always.

To meet above requirement, I am using custom.pll. In WHEN-NEW-BLOCK-INSTANCE I am getting decrypted value of national_identifer from database and assigning it to :person.national_identifier(database block) by using COPY function, so far it is working as expected.

When user query for employee, he/she able to decrypted value. but if user closes the form it is asking 'Do you want to save changes you made' as there is a change in :person.national_identifier.

Do we have any property to reset record/block status to something like unchanged, so we will not get 'Do you want to save changes you made message'.

View 15 Replies View Related

Forms :: How To Programmatically Change Relationship In Master-detail Block

Dec 20, 2012

can we use set_block_property to program to switch multiple relationships. for example

if true then use relationshipA
else relationshipB
end if;

View 9 Replies View Related

Forms :: Change Database Data Block Property At Runtime

Apr 4, 2011

I want to change Database Data Block Property at runtime.

View 4 Replies View Related

Forms :: Change Color In Fields In Form Filled Via Data Block?

Jan 4, 2012

I'm trying to change the attributes on a display where the info is gathered via a routine that fills the data block with info. I've searched and tried using 'set item instance property' in several places within the data block using different triggers but still doesn't work.

No errors are encountered or shown. Attributes aren't changed based on a small test condition.

View 2 Replies View Related

Forms :: How To Clear Record

Feb 13, 2012

In a master and detail relation ship block..When a cursor is placed in the details and enter some thing and giving back space..once value is cleared a empty record is saved in the database with the header values , but in details customer didn't enter anything.

how to clear the detail record in pre insert or when validation ?

View 6 Replies View Related

Forms :: To Clear Form And Execute Procedure In Same Trigger

Sep 13, 2011

I have a problem in my form. In my form there are 4 blocks and in one of the block i have a button. In which i put a code same as below:

BEGIN
IF NAME_IN('SYSTEM.FORM_STATUS') = 'CHANGED'
THEN
CLEAR_FORM(NO_VALIDATE);
END IF;
PROCEDURE ABC;
END;

So as per code i want to clear all the changes in form for current session and want to call the procedure ABC after that. But it is not calling the procedure ABC. And what would i do to perform the same?

View 19 Replies View Related

Difference Between Backup Optimization And Change Tracking Block?

Sep 5, 2012

I am studying about these two technologies and the only difference that I found was that optimization doesn't backup the duplicated archivedlogs.

If both ignore not changed blocks, what is more effective?

The optimization backup also has some tracking file?

View 1 Replies View Related

Backup & Recovery :: How To Determine The Rate Of Block Change

Aug 3, 2011

rdbms:oracle 10gr2
os:windows

with reference to

[URL]......

Quote:
A.2.2 Writing Backup Scripts for Disk and Tape Scenarios

As in the disk-only scenarios, the backup scripts in this section are categorized based on database workload. as stated very clearly it depends on the workload, more precisely the rate of block change. The size of the database can be found out based on formula from

[URL]....

so how would I know the rate of block change in order to know which script is suitable for me? I try to find out the rate of block change for the database based on change tracking file but based on

[URL].....

Quote:

The size of the change tracking file is proportional to the size of the database and the number of enabled threads of redo. The size is not related to the frequency of updates to the database. So how do I determine the rate of change? can the rate of block change based on size of archive logs?

I have the following information with me:

starting from 5/10/2011 0101
ending 5/18/2011 1114

this constitute to 9.5 days

F:
ecover_area>dir/w
1644 File(s) 27,942,770,176 bytes
2 Dir(s) 10,019,270,656 bytes free

average size of each file 27,942,770,176/1644
=16996818.841849148418491484184915

average size of each day's log = 27,942,770,176/9.5
=2941344229.0526315789473684210526
about 3G

If I have a database size of 92G, based on the archive log size of about 3G per day, can I conclude that a change of 3G/92G is considered as few block change?

View 1 Replies View Related

Backup & Recovery :: Block Change Tracking File

Sep 10, 2011

does, block change tracking file is read during incremental level 0 backup?

View 4 Replies View Related

Backup & Recovery :: Enabling Block Change Tracking?

Jun 20, 2012

i want to enable block change tracking as our incremental level1 backup take a lot of time but i have a worry which i found it on oracle support and tha is as follows Database Instance Hang at Database Checkpoint With Block Change Tracking Enabled. [ID 1326886.1]

View 2 Replies View Related

Backup & Recovery :: Block Change Tracking File When It Is Used

Oct 11, 2011

i did such commands

1. RMAN -> backup incremental level 0 database;

2. SQLPLUS -> alter database enable block change tracking using file '/home/oracle/block_change_tracking.tr';

3. RMAN -> backup incremental level 1 cumulative database;

4. RMAN -> backup incremental level 1 cumulative database;

5. RMAN -> backup incremental level 1 cumulative database;

and for such order i noticed that block change tracking file wasn't used for any cumulative backup. for each cumulative backup was done full scan over database.

it was used after i did incremental level 0 backup, and again incremental 1 cumulative.

if i want this feature to be usefull i should enable it before my incremental level 0, or i should do incremental level 0 immediately after i enable it?

View 6 Replies View Related

Forms :: Multi Data Block And Checkbox Field Based On Control Block

Nov 19, 2010

i have multi data block filed. and checkbox field which based on control block...My task is when i check checkbox only one field should enabled and my mouse goes to that field

e.g

item11 item21 item31 chkbox1
item12 item22 item32 chkbox2

Scenario like this :

My item field based on data block and checkbox based on control block,while i checked chkbox1 , only item31 on that current record should be enabled and i changed value only on that field

when i checked chkbox1 , my cursor goes to item31...not item32

View 12 Replies View Related

Forms :: Distribute Master Block Total Amount In Detail Block Line Wise

May 5, 2012

i have a master detail form, In Master block we have one field cheque amount and in Detail block we have field receiveable amount invoice wise. if company paid us a cheque amount we will enter this amount in Master block field Cheque amount and in detail block there will be invoice wise receivable amounts. i want to distribute the cheque amount in detail block invoice wise for example

Cheque amount in master block = 291

Invoice wise receiveable amount is as follows

Invoice No , receivable amount , Received amount

10, 196 , 0
20 , 95 , 0
30 , 54 , 0

Result should be as follows:

Invoice No , receivable amount , Received amount

10, 196, 196
20 , 95 , 95
30 , 54, 0

Received amount field should be distributed according to the receivable amount when recevied amount = cheque amount then remaining will be 0.

View 2 Replies View Related

Forms :: How To Read Values In A Multi Record Control Block Using Pre-insert Trigger (block Level)

Jul 24, 2010

I have a multi record control block (basically a text item displaying 6 records) where user enters values and I want to process the values using pre-insert trigger.

I want to read value in each record and then do some tasks using a pre-insert trigger before I commit the values. To navigate between the records I was using first_record, next_record, clear_record built-ins but it gives errors like "40737-illegalrestricted procedure next_record in pre-insert trigger".

View 3 Replies View Related

Server Administration :: ORA-00607 / Internal Error Occurred While Making A Change To A Data Block

Mar 12, 2010

Error is occurred during the transaction...i.e.

ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [4194], [89], [83], [], [], [], [], []

View 7 Replies View Related

Forms :: First Form Clear Previous Data And Then Populate Data From Table

May 7, 2012

when i press when button pressed trigger, i want first the form will delete all the previous data and then populate the data from the table, that's why i used clear_block first, but this clear_code is not working here. my coding is given below

go_block('show');
clear_block(NO_VALIDATE);
declare
cursor c1 is select *
from qtr_demand order by 1;
begin
[code]..........

View 26 Replies View Related

SQL & PL/SQL :: Clear Data On Column?

Jun 20, 2011

I have one table employer. It has column loginid, password, address, regdate, fullname, identno.

So i want to clear all data before 1 June 2011 in regdate. What command i need to use? I quite new with command prompt.

View 10 Replies View Related

PL/SQL :: How To Clear Runtime Error In Ref Cursor

May 27, 2013

the code as follows

create or replace
procedure Country_sel(key in varchar2)
as
cc Res_RelcountryLan.countrycode%type;
len Res_Language.langname_en%type;
lid Res_Language.langid%type;
ab Res_Language.Abrivation%type;

[code]....

when i am running this code im getting

ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "RASOOL.COUNTRY_SEL", line 11
ORA-06512: at line 6

View 2 Replies View Related

How To Clear Audit Files In Dump In HP-UX

Mar 31, 2013

i got many audit file in a dump it is on hp-ux linux normally in linux i use to give

find -name "*.aud" -mtime +20 -exec rm {} ;

what to give in HP-UX linux ?

View 2 Replies View Related

Forms :: When User Change / Delete Any Record / Row In Forms Data Automatically Move To Other Table

Dec 25, 2011

when a user change or delete any record or row in forms data automatically move to other table because i want to compare old and new record.

View 8 Replies View Related

Application Express :: Checkbox Not Clear Cache

Oct 18, 2013

i have created form with table  page to enter hotel details there is on 6 check box which are not database column .i have create these check box to keep days details when hotel give service .so i have use

LOV FORP1_MON      STATIC2:;1   MONDAYP1_TUE       STATIC2:;2   TUESDAYP1_WED     STATIC2:;3   WEDNESDAYP1_THR       STATIC2:;4  THURSDAYP1_FRI        STATIC2:;5   FRIDAYP1_SAT       STATIC2:;6   SATURDAYP1_SUN       STATIC2:;7   SUNDAY 

i have one more column operating days where i have use computaation to keep operating days.

:P1_MON||:P1_TUS||:P1_WED||:P1_THR||:P1_FRI||:P1_SAT||:P1_SUN 

these 6 check box are used Source used :Only when curren value in session state is nullSource Type : Static Assignment (Value equals source attibute)  Problem are when i create new record then these 6 check box are not clear cache and when i update any record value are not clear cache . i need when i create or update recor then all 6 check box should be null after keep recor. 

View 1 Replies View Related

How To Not Expose Password (clear Text) In Expdp Parfile

Jul 3, 2013

I like to create an expdp parfile that would not expose my password in clear text. 

PARFILE:userid=MyAccountName/$MYPASSWORD  <-----this substitution does not work in a parfiledumpfile=xxxxxlogfile=xxxxtables=xxxx

View 3 Replies View Related

Performance Tuning :: How To Clear Cache For Testing Tuned Code

Jul 4, 2011

i am testing a proc after tuning it but the problem is, it is taking a very very less time which it shouldn't. I know that it is because of the buffer cache and the shared pool. that why i need to clean the cache to retest it.

I cannot bounce the database as other schemas are part of it. so is there any way to clean the cache for that particular schema i.e bouncing any particular schema(i know that the term is not appropriate).

View 4 Replies View Related

Application Express :: Clear Page Cache - All Except Specific Items?

Feb 21, 2013

APEX 4.2.1 On a page with dozens of editable page items, when branching back to the same page on-submit, is there a way to clear cache for all items except a few (key) items? The branch attributes (via the f?p= syntax) support clearing cache for the entire page and setting specific item/value pairs but no support for exclusions.

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved