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_AID_TABLE_HANDLER_PKG dependencies on AP_INVOICE_DISTRIBUTIONS

Line 22: debug_info := 'Select from ap_invoice_distributions';

18:
19: current_calling_sequence := 'AP_AID_TABLE_HANDLER_PKG.CHECK_UNIQUE<-'||
20: p_Calling_Sequence;
21:
22: debug_info := 'Select from ap_invoice_distributions';
23:
24: SELECT COUNT(1)
25: INTO dummy
26: FROM ap_invoice_distributions

Line 26: FROM ap_invoice_distributions

22: debug_info := 'Select from ap_invoice_distributions';
23:
24: SELECT COUNT(1)
25: INTO dummy
26: FROM ap_invoice_distributions
27: WHERE (invoice_id = p_INVOICE_ID AND
28: invoice_line_number = p_INVOICE_LINE_NUMBER AND
29: distribution_line_number = p_DISTRIBUTION_LINE_NUMBER)
30: AND ((p_ROWID is null) or (rowid <> p_ROWID));

Line 204: FROM AP_INVOICE_DISTRIBUTIONS

200: debug_info VARCHAR2(100);
201: l_dist_match_type VARCHAR2(25);
202: CURSOR C IS
203: SELECT rowid
204: FROM AP_INVOICE_DISTRIBUTIONS
205: WHERE invoice_id = p_Invoice_Id
206: AND distribution_line_number = p_Distribution_Line_Number;
207:
208: CURSOR C2 IS SELECT ap_invoice_distributions_s.nextval FROM sys.dual;

Line 208: CURSOR C2 IS SELECT ap_invoice_distributions_s.nextval FROM sys.dual;

204: FROM AP_INVOICE_DISTRIBUTIONS
205: WHERE invoice_id = p_Invoice_Id
206: AND distribution_line_number = p_Distribution_Line_Number;
207:
208: CURSOR C2 IS SELECT ap_invoice_distributions_s.nextval FROM sys.dual;
209:
210: BEGIN
211:
212: -- Update the calling sequence

Line 248: debug_info := 'Insert into ap_invoice_distributions';

244: ELSE
245: l_dist_match_type := NULL;
246: END IF;
247:
248: debug_info := 'Insert into ap_invoice_distributions';
249:
250: INSERT INTO AP_INVOICE_DISTRIBUTIONS(
251: invoice_id,
252: -- Invoice Lines Project Stage 1

Line 250: INSERT INTO AP_INVOICE_DISTRIBUTIONS(

246: END IF;
247:
248: debug_info := 'Insert into ap_invoice_distributions';
249:
250: INSERT INTO AP_INVOICE_DISTRIBUTIONS(
251: invoice_id,
252: -- Invoice Lines Project Stage 1
253: invoice_line_number,
254: distribution_class,

Line 544: (p_table_name => 'AP_INVOICE_DISTRIBUTIONS',

540: );
541:
542: --Bug 4539462 DBI logging
543: AP_DBI_PKG.Maintain_DBI_Summary
544: (p_table_name => 'AP_INVOICE_DISTRIBUTIONS',
545: p_operation => 'I',
546: p_key_value1 => p_invoice_id,
547: p_key_value2 => p_invoice_distribution_id,
548: p_calling_sequence => current_calling_sequence);

Line 718: debug_info := 'Update ap_invoice_distributions';

714: p_Invoice_Line_Number,
715: p_Distribution_Line_Number,
716: 'AP_AID_TABLE_HANDLER_PKG.Update_Row');
717:
718: debug_info := 'Update ap_invoice_distributions';
719:
720:
721: UPDATE AP_INVOICE_DISTRIBUTIONS
722: SET

Line 721: UPDATE AP_INVOICE_DISTRIBUTIONS

717:
718: debug_info := 'Update ap_invoice_distributions';
719:
720:
721: UPDATE AP_INVOICE_DISTRIBUTIONS
722: SET
723: invoice_id = p_Invoice_Id,
724: invoice_line_number = p_Invoice_Line_Number,
725: distribution_class = p_Distribution_Class,

Line 848: (p_table_name => 'AP_INVOICE_DISTRIBUTIONS',

844: END IF;
845:
846: --Bug 4539462 DBI logging
847: AP_DBI_PKG.Maintain_DBI_Summary
848: (p_table_name => 'AP_INVOICE_DISTRIBUTIONS',
849: p_operation => 'U',
850: p_key_value1 => P_invoice_id,
851: p_key_value2 => l_invoice_distribution_id,
852: p_calling_sequence => current_calling_sequence);

Line 885: FROM ap_invoice_distributions

881: ||p_Calling_Sequence;
882:
883: SELECT invoice_distribution_id, invoice_id
884: INTO l_invoice_distribution_id, l_invoice_id
885: FROM ap_invoice_distributions
886: WHERE rowid = p_Rowid;
887:
888: DELETE FROM AP_INVOICE_DISTRIBUTIONS
889: WHERE rowid = p_Rowid;

Line 888: DELETE FROM AP_INVOICE_DISTRIBUTIONS

884: INTO l_invoice_distribution_id, l_invoice_id
885: FROM ap_invoice_distributions
886: WHERE rowid = p_Rowid;
887:
888: DELETE FROM AP_INVOICE_DISTRIBUTIONS
889: WHERE rowid = p_Rowid;
890:
891: IF (SQL%NOTFOUND) THEN
892: Raise NO_DATA_FOUND;

Line 897: (p_table_name => 'AP_INVOICE_DISTRIBUTIONS',

893: END IF;
894:
895: --Bug 4539462 DBI logging
896: AP_DBI_PKG.Maintain_DBI_Summary
897: (p_table_name => 'AP_INVOICE_DISTRIBUTIONS',
898: p_operation => 'D',
899: p_key_value1 => l_invoice_id,
900: p_key_value2 => l_invoice_distribution_id,
901: p_calling_sequence => current_calling_sequence);