Updating collection based on report wwv_flow.g_f01(
lilhelpAug 19 2010 — edited Aug 23 2010Hello 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