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 542: (p_table_name => 'AP_INVOICE_DISTRIBUTIONS',

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

Line 716: debug_info := 'Update ap_invoice_distributions';

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

Line 719: UPDATE AP_INVOICE_DISTRIBUTIONS

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

Line 846: (p_table_name => 'AP_INVOICE_DISTRIBUTIONS',

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

Line 883: FROM ap_invoice_distributions

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

Line 886: DELETE FROM AP_INVOICE_DISTRIBUTIONS

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

Line 895: (p_table_name => 'AP_INVOICE_DISTRIBUTIONS',

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