| Access Report Through Forms in Apps 11i [message #385518] |
Tue, 10 February 2009 00:09 |
abbas9001
Messages: 20
Registered: April 2008
Location: Hyderabad
|
Junior Member |
|
|
HEllo All,
My requirement is to get the reports data into form i.e. there is an ap check report and i would like to create a new form and call those check report fields into that form.
I am writing the following code
declare
v_plist_id paramlist;
pl_name varchar2(50) := 'rep_params';
begin
v_plist_id := get_parameter_list(pl_name);
--check_param_list (pl_name);
if not id_null(v_plist_id) then
destroy_parameter_list(v_plist_id);
end if;
v_plist_id := create_parameter_list(pl_name);
--add_parameter(v_plist_id, 'P_PAYMENT_BATCH', text_parameter, :block_name.item);
add_parameter(v_plist_id, 'PARAMFORM', text_parameter, 'NO');
add_parameter(v_plist_id, 'DESTYPE', text_parameter,:control.dest_type);
add_parameter(v_plist_id, 'DESNAME', text_parameter,:control.dest_name);
add_parameter(v_plist_id, 'DESFORMAT', text_parameter,:control.dest_format);
add_parameter(v_plist_id, 'F_AC_PAYEE', text_parameter,:control.payee);
run_product(reports, 'XXEGAPGBPCHK', asynchronous, runtime,filesystem, v_plist_id, null);
end;
Please suggest/advise how should i get the data populated into the forms in apps 11i. Its urgent.
Regards,
Abbas
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
