APPS.AP_RETRO_PRICING_PKG dependencies on AP_INVOICES_INTERFACE

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

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

Line 160: INSERT INTO ap_invoices_interface

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

Line 175: AP_INVOICES_INTERFACE_S.nextval,

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

Line 301: ap_invoices_interface aii

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

Line 518: l_group_id AP_INVOICES_INTERFACE.group_id%TYPE;

514: current_calling_sequence VARCHAR2(2000);
515: debug_info VARCHAR2(1000);
516:
517: l_allow_paid_invoice_adjust VARCHAR2(1);
518: l_group_id AP_INVOICES_INTERFACE.group_id%TYPE;
519: l_po_line_loc_id_list id_list_type;
520: l_batch_id NUMBER;
521: l_batch_num NUMBER;
522: l_batch_control_flag VARCHAR2(1) := 'N';

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

623:
624:
625:
626: -----------------------------------------------------------------
627: debug_info := 'Step 2b. Populate AP_INVOICES_INTERFACE';
628: -----------------------------------------------------------------
629: IF p_resubmit_flag <> 'Y' THEN
630:
631: AP_RETRO_PRICING_PKG.insert_ap_inv_interface (

Line 6450: 'AP_INVOICES_INTERFACE',

6446: --
6447: IF l_orig_invoices_valid = 'N' THEN
6448: --
6449: IF (AP_IMPORT_UTILITIES_PKG.insert_rejections(
6450: 'AP_INVOICES_INTERFACE',
6451: p_instruction_rec.invoice_id,
6452: 'ORIGINAL INVOICE NOT VALIDATED',
6453: FND_GLOBAL.user_id,
6454: FND_GLOBAL.login_id,

Line 6495: ('AP_INVOICES_INTERFACE',

6491: --
6492: IF l_orig_invoices_valid = 'N' THEN
6493: --Insert rejections
6494: IF (AP_IMPORT_UTILITIES_PKG.insert_rejections
6495: ('AP_INVOICES_INTERFACE',
6496: p_instruction_rec.invoice_id,
6497: 'ORIGINAL INVOICE HAS A HOLD',
6498: FND_GLOBAL.user_id,
6499: FND_GLOBAL.login_id,

Line 6542: ('AP_INVOICES_INTERFACE',

6538: FND_PROFILE.GET('UNIQUE:SEQ_NUMBERS',l_seq_num_profile);
6539: IF ((l_orig_invoices_valid = 'N') and (l_seq_num_profile = 'A')) THEN
6540: --Insert rejections
6541: IF (AP_IMPORT_UTILITIES_PKG.insert_rejections
6542: ('AP_INVOICES_INTERFACE',
6543: p_instruction_rec.invoice_id,
6544: 'NO SEQUENCE DEFINED FOR PPA',
6545: FND_GLOBAL.user_id,
6546: FND_GLOBAL.login_id,