How to eliminate particular rows in RTF
<?for-each:G_ICODE?><?if: CF_OPENING_QTY !=0 and RECEIPT_QTY !=0 and ISSUE_QTY !=0?>
<?CF_OPENING_QTY?>
<?RECEIPT_QTY?>
<?ISSUE_QTY?>
<?end if?>
<?end for-each?>
How to Call stored procedure from Forms Personalization
Call PLSQL procedure using form Personalization
1. Personalize the form
2. Create an action of type "BuiltIn"
3. BuiltIn Type for Action should be "Execute a Procedure"
4. Argument should be as below
='declare
v_field_value VARCHAR2(200) ;
begin
plsql_package.procedurenameHere ;
end'
or alternately
='declare
p_retcode NUMBER;
P_ERRBUF VARCHAR2(2000);
begin
XXJG_INVOICE_PRINTING(p_retcode, p_errbuf,'''||${item.INV_SUM_FOLDER.INVOICE_ID.value}||''');
end'
Note the syntax, after =, entire declare begin end is within single quote.
Also, there is no semi colon after "end"
You can pass field values as
'''||${item.BLOCKNAME.FIELDNAME.value}||'''
Newer Posts
Older Posts
Home
Subscribe to:
Posts (Atom)