[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).
52: p_error_message OUT NOCOPY varchar2
53: ) IS
54:
55: cursor c_get_run_no is
56: select JAI_PO_REP_PRRG_T_RUNNO_S.nextval
57: from dual;
58:
59: cursor c_inv_select_cursor is /*Signature change of cursor by nprahsar for bug # 7225946*/ --rchandan for bug#4428980
60: select invoice_id, invoice_num, org_id, vendor_id, vendor_site_id, invoice_date,
318:
319: S.No Date Author and Details
320: 1 14/06/2004 Created by Aparajita for bug#3633078. Version#115.0.
321:
322: This procedure populates temporary table JAI_PO_REP_PRRG_T,
323: to be used by the purchase register report.
324:
325: Depending on the input parameter, all invoices are selected.
326: Taxes that have been already brought over to payable invoice
685: /* Modified the following insert statement to insert VAT amounts for bug#5096880, Ramesh.B.K, 23/03/2006 */
686: -- Date 24-Nov-2006 Forward porting Bug 5671126 added by Balaji
687: -- insert into the temp table with all the values.
688:
689: insert into JAI_PO_REP_PRRG_T
690: (
691: run_no,
692: org_id,
693: vendor_id,