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_CREATE_PAY_SCHEDS_PKG dependencies on AP_DBI_PKG

Line 182: l_dbi_key_value_list ap_dbi_pkg.r_dbi_key_value_arr;

178: l_min_acc_unit_pay_curr fnd_currencies.minimum_accountable_unit%TYPE;
179: l_precision_pay_curr fnd_currencies.precision%TYPE;
180: l_min_acc_unit_inv_curr fnd_currencies.minimum_accountable_unit%TYPE;
181: l_precision_inv_curr fnd_currencies.precision%TYPE;
182: l_dbi_key_value_list ap_dbi_pkg.r_dbi_key_value_arr;
183:
184: l_payment_priority NUMBER; -- Added for Payment Request
185: l_vendor_site_id NUMBER;
186: l_hold_flag varchar2(1);

Line 1144: AP_DBI_PKG.Maintain_DBI_Summary

1140: )
1141: RETURNING payment_num
1142: BULK COLLECT INTO l_dbi_key_value_list;
1143:
1144: AP_DBI_PKG.Maintain_DBI_Summary
1145: (p_table_name => 'AP_PAYMENT_SCHEDULES',
1146: p_operation => 'I',
1147: p_key_value1 => P_invoice_id,
1148: p_key_value_list => l_dbi_key_value_list,

Line 1245: l_dbi_key_value_list1 ap_dbi_pkg.r_dbi_key_value_arr;

1241: l_min_acc_unit_inv_curr fnd_currencies.minimum_accountable_unit%TYPE;
1242: l_precision_inv_curr fnd_currencies.precision%TYPE;
1243: l_hold_flag varchar2(1);
1244: --Bug 4539462 DBI logging
1245: l_dbi_key_value_list1 ap_dbi_pkg.r_dbi_key_value_arr;
1246: l_dbi_key_value_list2 ap_dbi_pkg.r_dbi_key_value_arr;
1247:
1248:
1249: --Bug 7357218 Quick Pay and Dispute Resolution Project

Line 1246: l_dbi_key_value_list2 ap_dbi_pkg.r_dbi_key_value_arr;

1242: l_precision_inv_curr fnd_currencies.precision%TYPE;
1243: l_hold_flag varchar2(1);
1244: --Bug 4539462 DBI logging
1245: l_dbi_key_value_list1 ap_dbi_pkg.r_dbi_key_value_arr;
1246: l_dbi_key_value_list2 ap_dbi_pkg.r_dbi_key_value_arr;
1247:
1248:
1249: --Bug 7357218 Quick Pay and Dispute Resolution Project
1250: --Introduced variables for discount calculation

Line 1416: AP_DBI_PKG.Maintain_DBI_Summary

1412: FROM ap_payment_schedules
1413: WHERE invoice_id = P_invoice_id;
1414:
1415: --Bug 4539462 DBI logging
1416: AP_DBI_PKG.Maintain_DBI_Summary
1417: (p_table_name => 'AP_PAYMENT_SCHEDULES',
1418: p_operation => 'D',
1419: p_key_value1 => P_invoice_id,
1420: p_key_value_list => l_dbi_key_value_list1,

Line 1806: AP_DBI_PKG.Maintain_DBI_Summary

1802: AND ai.recurring_payment_id = arp.recurring_payment_id(+); --bug 5332569
1803:
1804:
1805: --Bug 4539462 DBI logging
1806: AP_DBI_PKG.Maintain_DBI_Summary
1807: (p_table_name => 'AP_PAYMENT_SCHEDULES',
1808: p_operation => 'I',
1809: p_key_value1 => P_invoice_id,
1810: p_key_value2 => l_sequence_num,

Line 2138: AP_DBI_PKG.Maintain_DBI_Summary

2134: AND ai.invoice_id = P_Invoice_Id
2135: AND ai.recurring_payment_id = arp.recurring_payment_id(+);
2136:
2137: --Bug 4539462 DBI logginG
2138: AP_DBI_PKG.Maintain_DBI_Summary
2139: (p_table_name => 'AP_PAYMENT_SCHEDULES',
2140: p_operation => 'I',
2141: p_key_value1 => P_invoice_id,
2142: p_key_value2 => l_sequence_num,

Line 2194: AP_DBI_PKG.Maintain_DBI_Summary

2190: RETURNING payment_num
2191: BULK COLLECT INTO l_dbi_key_value_list2;
2192:
2193: --Bug 4539462 DBI logging
2194: AP_DBI_PKG.Maintain_DBI_Summary
2195: (p_table_name => 'AP_PAYMENT_SCHEDULES',
2196: p_operation => 'U',
2197: p_key_value1 => P_invoice_id,
2198: p_key_value_list => l_dbi_key_value_list2,