eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_AI_TABLE_HANDLER_PKG dependencies on AP_INVOICES

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 247: SELECT ap_invoices_s.nextval FROM sys.dual;

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;
248:
249: current_calling_sequence VARCHAR2(2000);
250: debug_info VARCHAR2(100);
251: BEGIN

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 624: (p_table_name => 'AP_INVOICES',

620: CLOSE C;
621:
622: --Bug 4539462 DBI logging
623: AP_DBI_PKG.Maintain_DBI_Summary
624: (p_table_name => 'AP_INVOICES',
625: p_operation => 'I',
626: p_key_value1 => p_invoice_id,
627: p_calling_sequence => current_calling_sequence);
628:

Line 825: debug_info := 'Update ap_invoices';

821: p_VENDOR_ID,
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,

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 997: (p_table_name => 'AP_INVOICES',

993: WHERE rowid = p_rowid;
994:
995: --Bug 4539462 DBI logging
996: AP_DBI_PKG.Maintain_DBI_Summary
997: (p_table_name => 'AP_INVOICES',
998: p_operation => 'U',
999: p_key_value1 => P_invoice_id,
1000: p_calling_sequence => current_calling_sequence);
1001:

Line 1031: l_invoice_type_lookup_code AP_INVOICES.INVOICE_TYPE_LOOKUP_CODE%TYPE;

1027: debug_info VARCHAR2(100);
1028: l_key_value_list gl_ca_utility_pkg.r_key_value_arr;
1029:
1030: /*Start of 7388641*/
1031: l_invoice_type_lookup_code AP_INVOICES.INVOICE_TYPE_LOOKUP_CODE%TYPE;
1032: l_return_status_service VARCHAR2(50);
1033: l_msg_count NUMBER;
1034: l_msg_data VARCHAR2(100);
1035: l_transaction_rec ZX_API_PUB.TRANSACTION_REC_TYPE;

Line 1055: FROM ap_invoices

1051:
1052: /*7388641 also selecting invoice_type_lookup_code*/
1053: SELECT invoice_id,invoice_type_lookup_code
1054: INTO l_invoice_id,l_invoice_type_lookup_code
1055: FROM ap_invoices
1056: WHERE rowid = p_rowid;
1057:
1058: -- Delete attachments
1059: debug_info := 'Delete from fnd_attachments';

Line 1061: 'AP_INVOICES',

1057:
1058: -- Delete attachments
1059: debug_info := 'Delete from fnd_attachments';
1060: fnd_attached_documents2_pkg.delete_attachments(
1061: 'AP_INVOICES',
1062: l_invoice_id);
1063:
1064: -- Delete from the child entities
1065: -- debug_info := 'Delete from child entity - jg_zz_invoice_info';

Line 1100: l_transaction_rec.entity_code := 'AP_INVOICES';

1096:
1097: debug_info := 'Before deleting data in Tax tables taking required data';
1098:
1099: l_transaction_rec.application_id := 200;
1100: l_transaction_rec.entity_code := 'AP_INVOICES';
1101: l_transaction_rec.trx_id := l_invoice_id;
1102:
1103: l_success := AP_ETAX_UTILITY_PKG.Get_Event_Class_Code(
1104: P_Invoice_Type_Lookup_Code => l_invoice_type_lookup_code,

Line 1139: debug_info := 'Delete from ap_invoices';

1135: x_msg_data => l_msg_data); --out parameter
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

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

Line 1145: (p_table_name => 'AP_INVOICES',

1141: WHERE rowid = p_Rowid;
1142:
1143: --Bug 4539462 DBI logging
1144: AP_DBI_PKG.Maintain_DBI_Summary
1145: (p_table_name => 'AP_INVOICES',
1146: p_operation => 'D',
1147: p_key_value1 => l_invoice_id,
1148: p_calling_sequence => current_calling_sequence);
1149: