DBA Data[Home] [Help]

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 1188: AP_DBI_PKG.Maintain_DBI_Summary

1184: )
1185: RETURNING payment_num
1186: BULK COLLECT INTO l_dbi_key_value_list;
1187:
1188: AP_DBI_PKG.Maintain_DBI_Summary
1189: (p_table_name => 'AP_PAYMENT_SCHEDULES',
1190: p_operation => 'I',
1191: p_key_value1 => P_invoice_id,
1192: p_key_value_list => l_dbi_key_value_list,

Line 1289: l_dbi_key_value_list1 ap_dbi_pkg.r_dbi_key_value_arr;

1285: l_min_acc_unit_inv_curr fnd_currencies.minimum_accountable_unit%TYPE;
1286: l_precision_inv_curr fnd_currencies.precision%TYPE;
1287: l_hold_flag varchar2(1);
1288: --Bug 4539462 DBI logging
1289: l_dbi_key_value_list1 ap_dbi_pkg.r_dbi_key_value_arr;
1290: l_dbi_key_value_list2 ap_dbi_pkg.r_dbi_key_value_arr;
1291:
1292:
1293: --Bug 7357218 Quick Pay and Dispute Resolution Project

Line 1290: l_dbi_key_value_list2 ap_dbi_pkg.r_dbi_key_value_arr;

1286: l_precision_inv_curr fnd_currencies.precision%TYPE;
1287: l_hold_flag varchar2(1);
1288: --Bug 4539462 DBI logging
1289: l_dbi_key_value_list1 ap_dbi_pkg.r_dbi_key_value_arr;
1290: l_dbi_key_value_list2 ap_dbi_pkg.r_dbi_key_value_arr;
1291:
1292:
1293: --Bug 7357218 Quick Pay and Dispute Resolution Project
1294: --Introduced variables for discount calculation

Line 1474: AP_DBI_PKG.Maintain_DBI_Summary

1470: FROM ap_payment_schedules
1471: WHERE invoice_id = P_invoice_id;
1472:
1473: --Bug 4539462 DBI logging
1474: AP_DBI_PKG.Maintain_DBI_Summary
1475: (p_table_name => 'AP_PAYMENT_SCHEDULES',
1476: p_operation => 'D',
1477: p_key_value1 => P_invoice_id,
1478: p_key_value_list => l_dbi_key_value_list1,

Line 1883: AP_DBI_PKG.Maintain_DBI_Summary

1879: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info); --bug 8991699
1880: END IF;
1881:
1882: --Bug 4539462 DBI logging
1883: AP_DBI_PKG.Maintain_DBI_Summary
1884: (p_table_name => 'AP_PAYMENT_SCHEDULES',
1885: p_operation => 'I',
1886: p_key_value1 => P_invoice_id,
1887: p_key_value2 => l_sequence_num,

Line 2223: AP_DBI_PKG.Maintain_DBI_Summary

2219: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2220: END IF;
2221:
2222: --Bug 4539462 DBI logginG
2223: AP_DBI_PKG.Maintain_DBI_Summary
2224: (p_table_name => 'AP_PAYMENT_SCHEDULES',
2225: p_operation => 'I',
2226: p_key_value1 => P_invoice_id,
2227: p_key_value2 => l_sequence_num,

Line 2289: AP_DBI_PKG.Maintain_DBI_Summary

2285: RETURNING payment_num
2286: BULK COLLECT INTO l_dbi_key_value_list2;
2287:
2288: --Bug 4539462 DBI logging
2289: AP_DBI_PKG.Maintain_DBI_Summary
2290: (p_table_name => 'AP_PAYMENT_SCHEDULES',
2291: p_operation => 'U',
2292: p_key_value1 => P_invoice_id,
2293: p_key_value_list => l_dbi_key_value_list2,