OracleArea51

One of my freind was having a small requirement:
1. Select one row at a time(only one row in Database block)
2. Only selected row should be saved in database, even other non-selected rows has been changed by the user.

For this requirement first thing is to add one checkbox and write one checkbox changed trigger to allow the user to select only one

row, following piece of code will do this:

declare
l_current_record number;
l_last_record number;
begin
l_current_record := :system.trigger_record;
last_record;
l_last_record := :system.cursor_record;
first_record;
for i in 1 .. l_last_record loop
if :system.cursor_record !=  l_current_record then
:item4 := 'N';
end if;
next_record;
end loop;
go_record(l_current_record);
end; 

where item4 is the name of check box, it will be having value "Y", when it is checked and "N" otherwise.

now change the status of Record to "QUERY", if row is not selected and it has been changed by the user.

when-validate-record at block level

IF(:Item4 = 'N')THEN
Set_Record_Property( :System.cursor_record, 'EMP', STATUS, QUERY_STATUS);
END IF; 

Reetesh

Points: 2031

Contact Author | Website :

 

Attachments:

Saving selected row in DB

[ ]

10 Kb

28 Downloads

Related Posts:

• 
  Impelementing NEW_FORM Functionality in Oracle Apps: Closing Parent form and opening Child Form

  I was having one requirement suppose I’m opening form B from Form A, then when form B will be open
  383 days ago

• 
  passing parameters between FORMS

  Let’s suppose that you have two forms named EMPLOYEES and DEPARTMENTS. In the EMPLOYEES form, if y
  387 days ago

• 
  Forms Personalization for Oracle Apps 11i(11.5.10)

    Here is the document to demonstrate the various possibilities of Form Personalization in EBS.It w
  496 days ago

relatedArticles

Set as favorite

Bookmark

Report Article

Hits: 623

Trackback(0)

TrackBack URI for this entry

Comments (2)

Subscribe to this comment's feed

Binuraj said:

	Nice one Hi Reetesh, Nice article... I suppose line 10 should be if :system.cursor_record != l_current_record then
	report abuse vote down vote up

July 27, 2009
Votes: +0

contactriteshsharma said:

	... Hi Binuraj, Thanks a lot for Identifying the error, I have corrected it. Regards, Reetesh Sharma
	report abuse vote down vote up

July 27, 2009
Votes: +0

Write comment

Name

Email

Comment

smaller | bigger

Subscribe via email (registered users only)

I have read and agree to the Terms of Usage.

Add Comment