Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Updating collection based on report wwv_flow.g_f01(

lilhelpAug 19 2010 — edited Aug 23 2010
Hello all,
I have a page in my app which contains 3 standard reports based in a collection. There is a main report and from there you drill down to the other report, and from there you can drill down to another(3rd report) I am trying to update a collection member based on a lov. I am not sure how to insert the value from the lov in the 3rd report.


select seq_id
INTO CURR_SEQ_ID
from apex_collections
where collection_name = 'ARGYLL_INVOICES'
and c001 || c002 = :P12_EPSB_JE_HEAD_LINE_NUM;

apex_collection.update_member_attribute (p_collection_name=> 'ARGYLL_INVOICES',
p_seq=> CURR_SEQ_ID,p_attr_number =>17,p_attr_value=>'EDMO');

This works fine but of course it is hardcoded. I would like to use the wwv_flow.g_f01 api call but I cannot get it to work with my very rudimentary understanding of this api call.

apex_collection.update_member_attribute (p_collection_name=> 'ARGYLL_INVOICES',
p_seq=> CURR_SEQ_ID,p_attr_number =>17,p_attr_value=>wwv_flow.g_f01(some reference here);


Any guidance would be most appreciated.

Thanks
This post has been answered by 510477 on Aug 19 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 20 2010
Added on Aug 19 2010
10 comments
1,781 views