APPS.AP_INTEREST_INVOICE_PKG dependencies on AP_DBI_PKG

Line 924: AP_DBI_PKG.Maintain_DBI_Summary

920: l_remit_to_supplier_site_id,
921: l_relationship_id
922: --End 8249618
923: );
924: AP_DBI_PKG.Maintain_DBI_Summary
925: (p_table_name => 'AP_INVOICES',
926: p_operation => 'I',
927: p_key_value1 => P_Int_Invoice_id,
928: p_calling_sequence => current_calling_sequence);

Line 1275: l_dbi_key_value_list ap_dbi_pkg.r_dbi_key_value_arr;

1271:
1272:
1273:
1274: --Bug 4539462 DBI logging
1275: l_dbi_key_value_list ap_dbi_pkg.r_dbi_key_value_arr;
1276:
1277: -- This cursor has the logic to prorate interest invoice amount across
1278: -- 'ITEM' lines of associated overdue invoice distribution lines.
1279:

Line 1592: AP_DBI_PKG.Maintain_DBI_Summary

1588:
1589:
1590: debug_info := 'Calling DBI Pkg';
1591: --Bug 4539462 DBI logging
1592: AP_DBI_PKG.Maintain_DBI_Summary
1593: (p_table_name => 'AP_INVOICE_DISTRIBUTIONS',
1594: p_operation => 'I',
1595: p_key_value1 => P_int_invoice_id,
1596: p_key_value2 => l_invoice_distribution_id,

Line 1653: AP_DBI_PKG.Maintain_DBI_Summary

1649: RETURNING aid1.invoice_distribution_id
1650: BULK COLLECT INTO l_dbi_key_value_list; -- bug 4539462
1651: */
1652: --Bug 4539462 DBI logging
1653: AP_DBI_PKG.Maintain_DBI_Summary
1654: (p_table_name => 'AP_INVOICE_DISTRIBUTIONS',
1655: p_operation => 'U',
1656: p_key_value1 => p_int_invoice_id,
1657: p_key_value_list => l_dbi_key_value_list,

Line 1777: AP_DBI_PKG.Maintain_DBI_Summary

1773: P_org_id,
1774: P_last_update_login);
1775:
1776: --Bug 4539462 DBI logging
1777: AP_DBI_PKG.Maintain_DBI_Summary
1778: (p_table_name => 'AP_PAYMENT_SCHEDULES',
1779: p_operation => 'I',
1780: p_key_value1 => P_int_invoice_id,
1781: p_key_value2 => 1,

Line 1832: l_dbi_key_value_list1 ap_dbi_pkg.r_dbi_key_value_arr;

1828: l_Debug_Info VARCHAR2(240);
1829: l_Curr_Calling_Sequence VARCHAR2(2000);
1830: l_invoice_distribution_id NUMBER;
1831: --Bug 4539462 DBI logging
1832: l_dbi_key_value_list1 ap_dbi_pkg.r_dbi_key_value_arr;
1833: l_dbi_key_value_list2 ap_dbi_pkg.r_dbi_key_value_arr;
1834:
1835: CURSOR C_Interest_Inv_Cur is
1836: SELECT AID.invoice_id Invoice_Id,

Line 1833: l_dbi_key_value_list2 ap_dbi_pkg.r_dbi_key_value_arr;

1829: l_Curr_Calling_Sequence VARCHAR2(2000);
1830: l_invoice_distribution_id NUMBER;
1831: --Bug 4539462 DBI logging
1832: l_dbi_key_value_list1 ap_dbi_pkg.r_dbi_key_value_arr;
1833: l_dbi_key_value_list2 ap_dbi_pkg.r_dbi_key_value_arr;
1834:
1835: CURSOR C_Interest_Inv_Cur is
1836: SELECT AID.invoice_id Invoice_Id,
1837: AID.dist_code_combination_id Dist_Code_Combination_Id,

Line 1922: AP_DBI_PKG.Maintain_DBI_Summary

1918: RETURN;
1919: END IF;
1920:
1921: --Bug 4539462 DBI logging
1922: AP_DBI_PKG.Maintain_DBI_Summary
1923: (p_table_name => 'AP_PAYMENT_SCHEDULES',
1924: p_operation => 'U',
1925: p_key_value_list => l_dbi_key_value_list1,
1926: p_calling_sequence => l_curr_calling_sequence);

Line 1948: AP_DBI_PKG.Maintain_DBI_Summary

1944: AND AIR.related_invoice_id = AIP.invoice_id)
1945: RETURNING invoice_id
1946: BULK COLLECT INTO l_dbi_key_value_list2;
1947:
1948: AP_DBI_PKG.Maintain_DBI_Summary
1949: (p_table_name => 'AP_INVOICES',
1950: p_operation => 'U',
1951: p_key_value_list => l_dbi_key_value_list2,
1952: p_calling_sequence => l_curr_calling_sequence);