APPS.AP_AI_TABLE_HANDLER_PKG dependencies on AP_INVOICES_ALL

Line 26: FROM ap_invoices_all

22:
23: debug_info := 'Count for same vendor_id and invoice_num';
24: SELECT count(1)
25: INTO dummy_a
26: FROM ap_invoices_all
27: WHERE invoice_num = p_INVOICE_NUM
28: AND vendor_id = p_VENDOR_ID
29: AND org_id = p_ORG_ID -- Bug 5407785
30: AND ((p_ROWID is null) OR

Line 243: SELECT rowid FROM ap_invoices_all

239: )
240: IS
241:
242: CURSOR C IS
243: SELECT rowid FROM ap_invoices_all
244: WHERE invoice_id = p_Invoice_Id;
245:
246: CURSOR C2 IS
247: SELECT ap_invoices_s.nextval FROM sys.dual;

Line 275: debug_info := 'Insert into ap_invoices_all';

271: debug_info := 'hello Close cursor C2';
272: CLOSE C2;
273: END IF;
274:
275: debug_info := 'Insert into ap_invoices_all';
276:
277: INSERT INTO ap_invoices_all(
278: invoice_id,
279: last_update_date,

Line 277: INSERT INTO ap_invoices_all(

273: END IF;
274:
275: debug_info := 'Insert into ap_invoices_all';
276:
277: INSERT INTO ap_invoices_all(
278: invoice_id,
279: last_update_date,
280: last_updated_by,
281: vendor_id,

Line 826: UPDATE ap_invoices_all

822: p_ORG_ID, -- Bug 5407785
823: current_calling_sequence);
824:
825: debug_info := 'Update ap_invoices';
826: UPDATE ap_invoices_all
827: SET
828: invoice_id = p_Invoice_Id,
829: last_update_date = p_Last_Update_Date,
830: last_updated_by = p_Last_Updated_By,

Line 992: FROM ap_invoices_all

988: END IF;
989:
990: SELECT invoice_id
991: INTO l_invoice_id
992: FROM ap_invoices_all
993: WHERE rowid = p_rowid;
994:
995: --Bug 4539462 DBI logging
996: AP_DBI_PKG.Maintain_DBI_Summary

Line 1140: DELETE FROM ap_invoices_all

1136:
1137: --End of 7388641 --
1138:
1139: debug_info := 'Delete from ap_invoices';
1140: DELETE FROM ap_invoices_all
1141: WHERE rowid = p_Rowid;
1142:
1143: --Bug 4539462 DBI logging
1144: AP_DBI_PKG.Maintain_DBI_Summary