APPS.IGS_FI_PRC_APINT dependencies on AP_INVOICES_INTERFACE

Line 1221: || Purpose : Procedure for creating a record in the AP_INVOICES_INTERFACE and

1217: p_gl_cr_ccid PLS_INTEGER) AS
1218: /******************************************************************
1219: || Created By : [email protected]
1220: || Created On : 18-FEB-2003
1221: || Purpose : Procedure for creating a record in the AP_INVOICES_INTERFACE and
1222: || AP_INVOICE_LINES_INTERFACE
1223: || Known limitations, enhancements or remarks :
1224: || Change History :
1225: || Who When What

Line 1230: SELECT AP_INVOICES_INTERFACE_S.NEXTVAL

1226: || abshriva 12-MAy-2006 Bug 5217319: Amount Precision change, added API call to allow correct precison into DB
1227: || (reverse chronological order - newest change first)
1228: ******************************************************************/
1229: CURSOR c_inv_int IS
1230: SELECT AP_INVOICES_INTERFACE_S.NEXTVAL
1231: FROM dual;
1232:
1233: l_n_inv_id ap_invoices_interface.invoice_id%TYPE;
1234: l_v_inv_lkp igs_lookup_values.lookup_code%TYPE;

Line 1233: l_n_inv_id ap_invoices_interface.invoice_id%TYPE;

1229: CURSOR c_inv_int IS
1230: SELECT AP_INVOICES_INTERFACE_S.NEXTVAL
1231: FROM dual;
1232:
1233: l_n_inv_id ap_invoices_interface.invoice_id%TYPE;
1234: l_v_inv_lkp igs_lookup_values.lookup_code%TYPE;
1235: l_n_rfnd_amt NUMBER := 0;
1236: BEGIN
1237:

Line 1238: -- Get the new Invoice Id from the AP_INVOICES_INTERFACE_S sequence

1234: l_v_inv_lkp igs_lookup_values.lookup_code%TYPE;
1235: l_n_rfnd_amt NUMBER := 0;
1236: BEGIN
1237:
1238: -- Get the new Invoice Id from the AP_INVOICES_INTERFACE_S sequence
1239: OPEN c_inv_int;
1240: FETCH c_inv_int INTO l_n_inv_id;
1241: CLOSE c_inv_int;
1242:

Line 1251: -- Create a transaction in AP_INVOICES_INTERFACE

1247: ELSE
1248: l_v_inv_lkp := g_v_standard;
1249: END IF;
1250: l_n_rfnd_amt :=igs_fi_gen_gl.get_formatted_amount(p_n_rfnd_amnt);
1251: -- Create a transaction in AP_INVOICES_INTERFACE
1252: INSERT INTO ap_invoices_interface(invoice_id,
1253: invoice_num,
1254: invoice_type_lookup_code,
1255: invoice_date,

Line 1252: INSERT INTO ap_invoices_interface(invoice_id,

1248: l_v_inv_lkp := g_v_standard;
1249: END IF;
1250: l_n_rfnd_amt :=igs_fi_gen_gl.get_formatted_amount(p_n_rfnd_amnt);
1251: -- Create a transaction in AP_INVOICES_INTERFACE
1252: INSERT INTO ap_invoices_interface(invoice_id,
1253: invoice_num,
1254: invoice_type_lookup_code,
1255: invoice_date,
1256: vendor_id,