DBA Data[Home] [Help]

APPS.AP_INVOICE_DISTRIBUTIONS_PKG dependencies on AP_DBI_PKG

Line 727: l_dbi_key_value_list ap_dbi_pkg.r_dbi_key_value_arr;

723: i BINARY_INTEGER := 0;
724: current_calling_sequence VARCHAR2(2000);
725: debug_info VARCHAR2(100);
726: --Bug 4539462 DBI logging
727: l_dbi_key_value_list ap_dbi_pkg.r_dbi_key_value_arr;
728: l_calling_module varchar2(30); --bug7014798
729:
730:
731: l_country_code VARCHAR2(20); --bug 9169915

Line 1180: AP_DBI_PKG.Maintain_DBI_Summary

1176: BULK COLLECT INTO l_dbi_key_value_list
1177: FROM ap_invoice_distributions
1178: WHERE invoice_id = X_invoice_id;
1179:
1180: AP_DBI_PKG.Maintain_DBI_Summary
1181: (p_table_name => 'AP_INVOICE_DISTRIBUTIONS',
1182: p_operation => 'I',
1183: p_key_value1 => X_invoice_id,
1184: p_key_value_list => l_dbi_key_value_list,

Line 1351: l_key_value_list ap_dbi_pkg.r_dbi_key_value_arr; -- bug 9772522

1347: l_errmsg Varchar2(1300);
1348: current_calling_sequence VARCHAR2(2000);
1349: debug_info VARCHAR2(100);
1350: debug_context VARCHAR2(2000);
1351: l_key_value_list ap_dbi_pkg.r_dbi_key_value_arr; -- bug 9772522
1352: l_line_number
1353: ap_invoice_lines.line_number%TYPE;
1354: l_rounded_dist_id
1355: ap_invoice_distributions.invoice_distribution_id%type;

Line 1359: l_dbi_key_value_list ap_dbi_pkg.r_dbi_key_value_arr;

1355: ap_invoice_distributions.invoice_distribution_id%type;
1356: l_round_amt_exists BOOLEAN := FALSE;
1357: l_rounded_amt NUMBER;
1358: --Bug 4539462 DBI logging
1359: l_dbi_key_value_list ap_dbi_pkg.r_dbi_key_value_arr;
1360: l_org_id ap_invoices_all.org_id%type;
1361:
1362: l_base_amt NUMBER; --6892789
1363: l_modified_dist_rounding_amt NUMBER; --6892789

Line 1581: AP_DBI_PKG.Maintain_DBI_Summary

1577: RETURNING invoice_distribution_id
1578: BULK COLLECT INTO l_dbi_key_value_list;
1579:
1580: --Bug 4539462 DBI logging
1581: AP_DBI_PKG.Maintain_DBI_Summary
1582: (p_table_name => 'AP_INVOICE_DISTRIBUTIONS',
1583: p_operation => 'U',
1584: p_key_value1 => X_invoice_id,
1585: p_key_value_list => l_dbi_key_value_list,