APPS.AP_INTEREST_INVOICE_PKG dependencies on AP_DBI_PKG

Line 966: AP_DBI_PKG.Maintain_DBI_Summary

962: l_remit_to_supplier_site_id,
963: l_relationship_id
964: --End 8249618
965: );
966: AP_DBI_PKG.Maintain_DBI_Summary
967: (p_table_name => 'AP_INVOICES',
968: p_operation => 'I',
969: p_key_value1 => P_Int_Invoice_id,
970: p_calling_sequence => current_calling_sequence);

Line 1317: l_dbi_key_value_list ap_dbi_pkg.r_dbi_key_value_arr;

1313:
1314:
1315:
1316: --Bug 4539462 DBI logging
1317: l_dbi_key_value_list ap_dbi_pkg.r_dbi_key_value_arr;
1318:
1319: -- This cursor has the logic to prorate interest invoice amount across
1320: -- 'ITEM' lines of associated overdue invoice distribution lines.
1321:

Line 1644: AP_DBI_PKG.Maintain_DBI_Summary

1640:
1641:
1642: debug_info := 'Calling DBI Pkg';
1643: --Bug 4539462 DBI logging
1644: AP_DBI_PKG.Maintain_DBI_Summary
1645: (p_table_name => 'AP_INVOICE_DISTRIBUTIONS',
1646: p_operation => 'I',
1647: p_key_value1 => P_int_invoice_id,
1648: p_key_value2 => l_invoice_distribution_id,

Line 1705: AP_DBI_PKG.Maintain_DBI_Summary

1701: RETURNING aid1.invoice_distribution_id
1702: BULK COLLECT INTO l_dbi_key_value_list; -- bug 4539462
1703: */
1704: --Bug 4539462 DBI logging
1705: AP_DBI_PKG.Maintain_DBI_Summary
1706: (p_table_name => 'AP_INVOICE_DISTRIBUTIONS',
1707: p_operation => 'U',
1708: p_key_value1 => p_int_invoice_id,
1709: p_key_value_list => l_dbi_key_value_list,

Line 1873: AP_DBI_PKG.Maintain_DBI_Summary

1869:
1870: -- modified code as per bug 8557334 ends
1871:
1872: --Bug 4539462 DBI logging
1873: AP_DBI_PKG.Maintain_DBI_Summary
1874: (p_table_name => 'AP_PAYMENT_SCHEDULES',
1875: p_operation => 'I',
1876: p_key_value1 => P_int_invoice_id,
1877: p_key_value2 => 1,

Line 1928: l_dbi_key_value_list1 ap_dbi_pkg.r_dbi_key_value_arr;

1924: l_Debug_Info VARCHAR2(240);
1925: l_Curr_Calling_Sequence VARCHAR2(2000);
1926: l_invoice_distribution_id NUMBER;
1927: --Bug 4539462 DBI logging
1928: l_dbi_key_value_list1 ap_dbi_pkg.r_dbi_key_value_arr;
1929: l_dbi_key_value_list2 ap_dbi_pkg.r_dbi_key_value_arr;
1930:
1931: CURSOR C_Interest_Inv_Cur is
1932: SELECT AID.invoice_id Invoice_Id,

Line 1929: l_dbi_key_value_list2 ap_dbi_pkg.r_dbi_key_value_arr;

1925: l_Curr_Calling_Sequence VARCHAR2(2000);
1926: l_invoice_distribution_id NUMBER;
1927: --Bug 4539462 DBI logging
1928: l_dbi_key_value_list1 ap_dbi_pkg.r_dbi_key_value_arr;
1929: l_dbi_key_value_list2 ap_dbi_pkg.r_dbi_key_value_arr;
1930:
1931: CURSOR C_Interest_Inv_Cur is
1932: SELECT AID.invoice_id Invoice_Id,
1933: AID.dist_code_combination_id Dist_Code_Combination_Id,

Line 2018: AP_DBI_PKG.Maintain_DBI_Summary

2014: RETURN;
2015: END IF;
2016:
2017: --Bug 4539462 DBI logging
2018: AP_DBI_PKG.Maintain_DBI_Summary
2019: (p_table_name => 'AP_PAYMENT_SCHEDULES',
2020: p_operation => 'U',
2021: p_key_value_list => l_dbi_key_value_list1,
2022: p_calling_sequence => l_curr_calling_sequence);

Line 2044: AP_DBI_PKG.Maintain_DBI_Summary

2040: AND AIR.related_invoice_id = AIP.invoice_id)
2041: RETURNING invoice_id
2042: BULK COLLECT INTO l_dbi_key_value_list2;
2043:
2044: AP_DBI_PKG.Maintain_DBI_Summary
2045: (p_table_name => 'AP_INVOICES',
2046: p_operation => 'U',
2047: p_key_value_list => l_dbi_key_value_list2,
2048: p_calling_sequence => l_curr_calling_sequence);