[Home] [Help]
130: Modified the object to remove literals from DML statements and CURSORS.
131: As part OF R12 Initiative Inventory conversion the OPM code is commented
132:
133: 13 07/12/2005 Hjujjuru for the bug 4866533 File version 120.3
134: added the who columns in the insert into table JAI_PO_REP_PRRG_T
135: Dependencies Due to this bug:-
136: None
137: 14. 31-MAR-2009 JMEENA for bug#7689858
138: Removed discount_amount_taken from invoice amount and added with payment amount.
963: )
964: IS
965:
966: cursor c_get_run_no IS
967: select JAI_PO_REP_PRRG_T_RUNNO_S.nextval
968: from dual;
969:
970: cursor c_inv_select_cursor( c_line_type_lookup_code ap_invoice_distributions_all.line_type_lookup_code%TYPE ) IS --rchandan for bug#4428980
971: select invoice_id, invoice_num, org_id, vendor_id, vendor_site_id, invoice_date,
1199:
1200: S.No Date Author and Details
1201: 1 14/06/2004 Created by Aparajita for bug#3633078. Version#115.0.
1202:
1203: This procedure populates temporary table JAI_PO_REP_PRRG_T,
1204: to be used by the purchase register report.
1205:
1206: Depending on the input parameter, all invoices are selected.
1207: Taxes that have been already brought over to payable invoice
1480: end if;
1481:
1482: v_statement_id:= 19;
1483: -- insert into the temp table with all the values.
1484: insert into JAI_PO_REP_PRRG_T
1485: (
1486: run_no,
1487: org_id,
1488: vendor_id,