[Home] [Help]
128: Modified the object to remove literals from DML statements and CURSORS.
129: As part OF R12 Initiative Inventory conversion the OPM code is commented
130:
131: 13 07/12/2005 Hjujjuru for the bug 4866533 File version 120.3
132: added the who columns in the insert into table JAI_PO_REP_PRRG_T
133: Dependencies Due to this bug:-
134: None
135: ----------------------------------------------------------------------------------------------------------------------- */
136:
921: )
922: IS
923:
924: cursor c_get_run_no IS
925: select JAI_PO_REP_PRRG_T_RUNNO_S.nextval
926: from dual;
927:
928: cursor c_inv_select_cursor( c_line_type_lookup_code ap_invoice_distributions_all.line_type_lookup_code%TYPE ) IS --rchandan for bug#4428980
929: select invoice_id, invoice_num, org_id, vendor_id, vendor_site_id, invoice_date,
1157:
1158: S.No Date Author and Details
1159: 1 14/06/2004 Created by Aparajita for bug#3633078. Version#115.0.
1160:
1161: This procedure populates temporary table JAI_PO_REP_PRRG_T,
1162: to be used by the purchase register report.
1163:
1164: Depending on the input parameter, all invoices are selected.
1165: Taxes that have been already brought over to payable invoice
1438: end if;
1439:
1440: v_statement_id:= 19;
1441: -- insert into the temp table with all the values.
1442: insert into JAI_PO_REP_PRRG_T
1443: (
1444: run_no,
1445: org_id,
1446: vendor_id,