Hello all,
I would like to get the code to call a report from forms.
How can i do that.
Also what are the setting that i have to do it on forms fields.
Abbas.
How to Call report from forms
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
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
-
- Posts: 6
- Joined: Thu Mar 12, 2009 6:18 am
- Location: India
Who is online
Users browsing this forum: No registered users and 0 guests