[Home] [Help]
15: Modified the object to remove literals from DML statements and CURSORS.
16: As part OF R12 Initiative Inventory conversion the OPM code is commented
17:
18: 09-Dec-2005 4866533 Added by Lakshmi Gopalsami Version 120.3
19: Added WHO columns in insert to jai_po_rep_prrg_t
20:
21:
22: 01/11/2006 SACSETHI for bug 5228046, File version 120.4
23: Forward porting the change in 11i bug 5365523 (Additional CVD Enhancement).
47: p_error_message OUT NOCOPY varchar2
48: ) IS
49:
50: cursor c_get_run_no is
51: select JAI_PO_REP_PRRG_T_RUNNO_S.nextval
52: from dual;
53:
54: cursor c_inv_select_cursor is /*Signature change of cursor by nprahsar for bug # 7225946*/ --rchandan for bug#4428980
55: select invoice_id, invoice_num, org_id, vendor_id, vendor_site_id, invoice_date,
313:
314: S.No Date Author and Details
315: 1 14/06/2004 Created by Aparajita for bug#3633078. Version#115.0.
316:
317: This procedure populates temporary table JAI_PO_REP_PRRG_T,
318: to be used by the purchase register report.
319:
320: Depending on the input parameter, all invoices are selected.
321: Taxes that have been already brought over to payable invoice
672: /* Modified the following insert statement to insert VAT amounts for bug#5096880, Ramesh.B.K, 23/03/2006 */
673: -- Date 24-Nov-2006 Forward porting Bug 5671126 added by Balaji
674: -- insert into the temp table with all the values.
675:
676: insert into JAI_PO_REP_PRRG_T
677: (
678: run_no,
679: org_id,
680: vendor_id,