EBS Customizations (MOSC)

MOSC Banner

Can we call go_record in personalization using builin "Execute a procedure"

edited Sep 18, 2014 5:04AM in EBS Customizations (MOSC) 1 commentAnswered

Hello All,

When I am calling "go_record(<record_number>)" inside a plsql code which is called using Built in "Execute a Procedure" under forms personalization, I am getting error "Identifier GO_RECORD must be declared."

Similar error is coming for GET_GROUP_NUMBER_CELL and also giving error for datatype GROUPCOLUMN.

Can you please help

Regards,

Ganesh

Message was edited by: 1323565 Below is the code called. declare   record_number_column GROUPCOLUMN;   selected_record_count NUMBER; begin   record_number_column := APP_MULTI.GET_GROUP_COL('LINE');   selected_record_count := APP_MULTI.GET_GROUP_COUNT(''LINE'');   FOR i IN 1 .. selected_record_count LOOP     DECLARE       record_number NUMBER;     BEGIN       record_number := GET_GROUP_NUMBER_CELL(record_number_column, i);       GO_RECORD(record_number);       insert into test (a) values('''||${item.LINE.LINE_ID.value}||''');     END;   END LOOP;       commit; end

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center