APPS.AP_RETRO_PRICING_PKG dependencies on AP_INVOICES_INTERFACE

Line 158: debug_info := 'Step 4b.Insert into ap_invoices_interface';

154: l_vendor_name_list;
155: CLOSE vendor;
156: */
157: ---------------------------------------------------------
158: debug_info := 'Step 4b.Insert into ap_invoices_interface';
159: ----------------------------------------------------------
160: FORALL I IN 1 .. l_vendor_id_list.count
161: INSERT INTO ap_invoices_interface
162: (org_id,

Line 161: INSERT INTO ap_invoices_interface

157: ---------------------------------------------------------
158: debug_info := 'Step 4b.Insert into ap_invoices_interface';
159: ----------------------------------------------------------
160: FORALL I IN 1 .. l_vendor_id_list.count
161: INSERT INTO ap_invoices_interface
162: (org_id,
163: invoice_id,
164: source,
165: vendor_id,

Line 176: AP_INVOICES_INTERFACE_S.nextval,

172: last_update_date,
173: last_update_login,
174: request_id)
175: VALUES (p_org_id,
176: AP_INVOICES_INTERFACE_S.nextval,
177: 'PPA',
178: l_vendor_id_list(i),
179: l_vendor_num_list(i),
180: l_vendor_name_list(i),

Line 302: ap_invoices_interface aii

298: po_headers_all ph,
299: po_releases_all pr,
300: po_lines_all pl,
301: po_line_locations_all pll,
302: ap_invoices_interface aii
303: WHERE mo_global.check_access(pd.org_id) = 'Y'
304: AND pd.po_header_id = ph.po_header_id
305: AND pd.po_release_id = pr.po_release_id(+)
306: AND pd.po_line_id = pl.po_line_id

Line 528: l_group_id AP_INVOICES_INTERFACE.group_id%TYPE;

524: current_calling_sequence VARCHAR2(2000);
525: debug_info VARCHAR2(1000);
526:
527: l_allow_paid_invoice_adjust VARCHAR2(1);
528: l_group_id AP_INVOICES_INTERFACE.group_id%TYPE;
529: l_po_line_loc_id_list id_list_type;
530: l_batch_id NUMBER;
531: l_batch_num NUMBER;
532: l_batch_control_flag VARCHAR2(1) := 'N';

Line 637: debug_info := 'Step 2b. Populate AP_INVOICES_INTERFACE';

633:
634:
635:
636: -----------------------------------------------------------------
637: debug_info := 'Step 2b. Populate AP_INVOICES_INTERFACE';
638: -----------------------------------------------------------------
639: IF p_resubmit_flag <> 'Y' THEN
640:
641: AP_RETRO_PRICING_PKG.insert_ap_inv_interface (

Line 6941: 'AP_INVOICES_INTERFACE',

6937: --
6938: IF l_orig_invoices_valid = 'N' THEN
6939: --
6940: IF (AP_IMPORT_UTILITIES_PKG.insert_rejections(
6941: 'AP_INVOICES_INTERFACE',
6942: p_instruction_rec.invoice_id,
6943: 'ORIGINAL INVOICE NOT VALIDATED',
6944: FND_GLOBAL.user_id,
6945: FND_GLOBAL.login_id,

Line 6986: ('AP_INVOICES_INTERFACE',

6982: --
6983: IF l_orig_invoices_valid = 'N' THEN
6984: --Insert rejections
6985: IF (AP_IMPORT_UTILITIES_PKG.insert_rejections
6986: ('AP_INVOICES_INTERFACE',
6987: p_instruction_rec.invoice_id,
6988: 'ORIGINAL INVOICE HAS A HOLD',
6989: FND_GLOBAL.user_id,
6990: FND_GLOBAL.login_id,

Line 7033: ('AP_INVOICES_INTERFACE',

7029: FND_PROFILE.GET('UNIQUE:SEQ_NUMBERS',l_seq_num_profile);
7030: IF ((l_orig_invoices_valid = 'N') and (l_seq_num_profile = 'A')) THEN
7031: --Insert rejections
7032: IF (AP_IMPORT_UTILITIES_PKG.insert_rejections
7033: ('AP_INVOICES_INTERFACE',
7034: p_instruction_rec.invoice_id,
7035: 'NO SEQUENCE DEFINED FOR PPA',
7036: FND_GLOBAL.user_id,
7037: FND_GLOBAL.login_id,