CUSTOM MENU pl SQL Can I add a parameter entry on the sql block to enter the user manually on the screen.
sample: begin & Ao.srnrep_ck2_utılıty_apı.ınsert_srnt_barkod (& quantity); end;
CUSTOM MENU pl SQL Can I add a parameter entry on the sql block to enter the user manually on the screen.
sample: begin & Ao.srnrep_ck2_utılıty_apı.ınsert_srnt_barkod (& quantity); end;
Oracle Substitution variables are not supported in the Custom Menu PL/SQL block.
It works in the TEST window only.
There is a workaround for this issue. You would need to,
You could set up a custom field and have the user enter the data into it before doing the RMB. The RMB could then read the custom field.
Seems working on APps10 UPD11
DECLARE
p0_ VARCHAR2(32000) := 'START_EVENT'||chr(31)||'40'||chr(30)||'ORDER_NO'||chr(31)||'R42667'||chr(30)||'ONLINE_ORDRSP_PROCESSING'||chr(31)||'FALSE'||chr(30)||'MEDIA_CODE'||chr(31)||'MHS'||chr(30)||'PRINT'||chr(31)||''||chr(30)||'END'||chr(31)||''||chr(30);
cursor c1
is
select distinct s.source_ref1
from renc1app.SHIPMENT_LINE s
where s.shipment_id= &SHIPMENT_ID;
BEGIN
for i in c1
loop
p0_ := 'START_EVENT'||chr(31)||'40'||chr(30)||'ORDER_NO'||chr(31)||i.SOURCE_REF1||chr(30)||'ONLINE_ORDRSP_PROCESSING'||chr(31)||'FALSE'||chr(30)||'MEDIA_CODE'||chr(31)||'MHS'||chr(30)||'PRINT'||chr(31)||''||chr(30)||'END'||chr(31)||''||chr(30);
RENC1APP.Customer_Order_Flow_API.Start_Print_Order_Conf__(p0_ );
end loop;
END;
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.