DBA Data[Home] [Help]

APPS.AP_IMPORT_INVOICES_PKG dependencies on AP_SYSTEM_PARAMETERS_ALL

Line 4969: l_base_currency_code ap_system_parameters_all.base_currency_code%TYPE;

4965: current_calling_sequence VARCHAR2(2000);
4966: debug_info VARCHAR2(500);
4967: l_ext_precision NUMBER(2);
4968: --bug 15862708
4969: l_base_currency_code ap_system_parameters_all.base_currency_code%TYPE;
4970: l_set_of_books_id ap_system_parameters_all.set_of_books_id%TYPE;
4971:
4972:
4973:

Line 4970: l_set_of_books_id ap_system_parameters_all.set_of_books_id%TYPE;

4966: debug_info VARCHAR2(500);
4967: l_ext_precision NUMBER(2);
4968: --bug 15862708
4969: l_base_currency_code ap_system_parameters_all.base_currency_code%TYPE;
4970: l_set_of_books_id ap_system_parameters_all.set_of_books_id%TYPE;
4971:
4972:
4973:
4974:

Line 4983: p_set_of_books_id ap_system_parameters_all.set_of_books_id%TYPE;

4979:
4980: l_asset_book_count NUMBER;
4981: --tab_get_info_rec AP_IMPORT_INVOICES_PKG.table_get_info_rec; --bug 15862708
4982:
4983: p_set_of_books_id ap_system_parameters_all.set_of_books_id%TYPE;
4984: p_multi_currency_flag ap_system_parameters_all.multi_currency_flag%TYPE;
4985: p_make_rate_mandatory_flag ap_system_parameters_all.make_rate_mandatory_flag%TYPE;
4986: p_default_exchange_rate_type ap_system_parameters_all.default_exchange_rate_type%TYPE;
4987: p_base_currency_code ap_system_parameters_all.base_currency_code%TYPE;

Line 4984: p_multi_currency_flag ap_system_parameters_all.multi_currency_flag%TYPE;

4980: l_asset_book_count NUMBER;
4981: --tab_get_info_rec AP_IMPORT_INVOICES_PKG.table_get_info_rec; --bug 15862708
4982:
4983: p_set_of_books_id ap_system_parameters_all.set_of_books_id%TYPE;
4984: p_multi_currency_flag ap_system_parameters_all.multi_currency_flag%TYPE;
4985: p_make_rate_mandatory_flag ap_system_parameters_all.make_rate_mandatory_flag%TYPE;
4986: p_default_exchange_rate_type ap_system_parameters_all.default_exchange_rate_type%TYPE;
4987: p_base_currency_code ap_system_parameters_all.base_currency_code%TYPE;
4988: p_batch_control_flag varchar2(2);

Line 4985: p_make_rate_mandatory_flag ap_system_parameters_all.make_rate_mandatory_flag%TYPE;

4981: --tab_get_info_rec AP_IMPORT_INVOICES_PKG.table_get_info_rec; --bug 15862708
4982:
4983: p_set_of_books_id ap_system_parameters_all.set_of_books_id%TYPE;
4984: p_multi_currency_flag ap_system_parameters_all.multi_currency_flag%TYPE;
4985: p_make_rate_mandatory_flag ap_system_parameters_all.make_rate_mandatory_flag%TYPE;
4986: p_default_exchange_rate_type ap_system_parameters_all.default_exchange_rate_type%TYPE;
4987: p_base_currency_code ap_system_parameters_all.base_currency_code%TYPE;
4988: p_batch_control_flag varchar2(2);
4989: p_invoice_currency_code ap_system_parameters_all.invoice_currency_code%TYPE;

Line 4986: p_default_exchange_rate_type ap_system_parameters_all.default_exchange_rate_type%TYPE;

4982:
4983: p_set_of_books_id ap_system_parameters_all.set_of_books_id%TYPE;
4984: p_multi_currency_flag ap_system_parameters_all.multi_currency_flag%TYPE;
4985: p_make_rate_mandatory_flag ap_system_parameters_all.make_rate_mandatory_flag%TYPE;
4986: p_default_exchange_rate_type ap_system_parameters_all.default_exchange_rate_type%TYPE;
4987: p_base_currency_code ap_system_parameters_all.base_currency_code%TYPE;
4988: p_batch_control_flag varchar2(2);
4989: p_invoice_currency_code ap_system_parameters_all.invoice_currency_code%TYPE;
4990: p_base_min_acct_unit number;

Line 4987: p_base_currency_code ap_system_parameters_all.base_currency_code%TYPE;

4983: p_set_of_books_id ap_system_parameters_all.set_of_books_id%TYPE;
4984: p_multi_currency_flag ap_system_parameters_all.multi_currency_flag%TYPE;
4985: p_make_rate_mandatory_flag ap_system_parameters_all.make_rate_mandatory_flag%TYPE;
4986: p_default_exchange_rate_type ap_system_parameters_all.default_exchange_rate_type%TYPE;
4987: p_base_currency_code ap_system_parameters_all.base_currency_code%TYPE;
4988: p_batch_control_flag varchar2(2);
4989: p_invoice_currency_code ap_system_parameters_all.invoice_currency_code%TYPE;
4990: p_base_min_acct_unit number;
4991: p_base_precision number;

Line 4989: p_invoice_currency_code ap_system_parameters_all.invoice_currency_code%TYPE;

4985: p_make_rate_mandatory_flag ap_system_parameters_all.make_rate_mandatory_flag%TYPE;
4986: p_default_exchange_rate_type ap_system_parameters_all.default_exchange_rate_type%TYPE;
4987: p_base_currency_code ap_system_parameters_all.base_currency_code%TYPE;
4988: p_batch_control_flag varchar2(2);
4989: p_invoice_currency_code ap_system_parameters_all.invoice_currency_code%TYPE;
4990: p_base_min_acct_unit number;
4991: p_base_precision number;
4992: p_sequence_numbering varchar2(30);
4993: p_awt_include_tax_amt ap_system_parameters_all.awt_include_tax_amt%TYPE;

Line 4993: p_awt_include_tax_amt ap_system_parameters_all.awt_include_tax_amt%TYPE;

4989: p_invoice_currency_code ap_system_parameters_all.invoice_currency_code%TYPE;
4990: p_base_min_acct_unit number;
4991: p_base_precision number;
4992: p_sequence_numbering varchar2(30);
4993: p_awt_include_tax_amt ap_system_parameters_all.awt_include_tax_amt%TYPE;
4994: pp_gl_date date;
4995: p_transfer_desc_flex_flag ap_system_parameters_all.transfer_desc_flex_flag%TYPE;
4996: p_gl_date_from_receipt_flag ap_system_parameters_all.gl_date_from_receipt_flag%TYPE;
4997: p_purch_encumbrance_flag financials_system_params_all.purch_encumbrance_flag%TYPE;

Line 4995: p_transfer_desc_flex_flag ap_system_parameters_all.transfer_desc_flex_flag%TYPE;

4991: p_base_precision number;
4992: p_sequence_numbering varchar2(30);
4993: p_awt_include_tax_amt ap_system_parameters_all.awt_include_tax_amt%TYPE;
4994: pp_gl_date date;
4995: p_transfer_desc_flex_flag ap_system_parameters_all.transfer_desc_flex_flag%TYPE;
4996: p_gl_date_from_receipt_flag ap_system_parameters_all.gl_date_from_receipt_flag%TYPE;
4997: p_purch_encumbrance_flag financials_system_params_all.purch_encumbrance_flag%TYPE;
4998: p_retainage_ccid financials_system_params_all.retainage_code_combination_id%TYPE;
4999: P_pa_installed varchar2(2);

Line 4996: p_gl_date_from_receipt_flag ap_system_parameters_all.gl_date_from_receipt_flag%TYPE;

4992: p_sequence_numbering varchar2(30);
4993: p_awt_include_tax_amt ap_system_parameters_all.awt_include_tax_amt%TYPE;
4994: pp_gl_date date;
4995: p_transfer_desc_flex_flag ap_system_parameters_all.transfer_desc_flex_flag%TYPE;
4996: p_gl_date_from_receipt_flag ap_system_parameters_all.gl_date_from_receipt_flag%TYPE;
4997: p_purch_encumbrance_flag financials_system_params_all.purch_encumbrance_flag%TYPE;
4998: p_retainage_ccid financials_system_params_all.retainage_code_combination_id%TYPE;
4999: P_pa_installed varchar2(2);
5000: p_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%type;

Line 5001: p_inv_doc_cat_override ap_system_parameters_all.inv_doc_category_override%TYPE;

4997: p_purch_encumbrance_flag financials_system_params_all.purch_encumbrance_flag%TYPE;
4998: p_retainage_ccid financials_system_params_all.retainage_code_combination_id%TYPE;
4999: P_pa_installed varchar2(2);
5000: p_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%type;
5001: p_inv_doc_cat_override ap_system_parameters_all.inv_doc_category_override%TYPE;
5002: p_calc_user_xrate ap_system_parameters_all.calc_user_xrate%TYPE;
5003: p_approval_workflow_flag ap_system_parameters_all.approval_workflow_flag%TYPE;
5004: p_freight_code_combination_id ap_system_parameters_all.freight_code_combination_id%TYPE;
5005: p_allow_interest_invoices ap_system_parameters_all.auto_calculate_interest_flag%TYPE;

Line 5002: p_calc_user_xrate ap_system_parameters_all.calc_user_xrate%TYPE;

4998: p_retainage_ccid financials_system_params_all.retainage_code_combination_id%TYPE;
4999: P_pa_installed varchar2(2);
5000: p_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%type;
5001: p_inv_doc_cat_override ap_system_parameters_all.inv_doc_category_override%TYPE;
5002: p_calc_user_xrate ap_system_parameters_all.calc_user_xrate%TYPE;
5003: p_approval_workflow_flag ap_system_parameters_all.approval_workflow_flag%TYPE;
5004: p_freight_code_combination_id ap_system_parameters_all.freight_code_combination_id%TYPE;
5005: p_allow_interest_invoices ap_system_parameters_all.auto_calculate_interest_flag%TYPE;
5006: p_add_days_settlement_date ap_system_parameters_all.add_days_settlement_date%TYPE;

Line 5003: p_approval_workflow_flag ap_system_parameters_all.approval_workflow_flag%TYPE;

4999: P_pa_installed varchar2(2);
5000: p_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%type;
5001: p_inv_doc_cat_override ap_system_parameters_all.inv_doc_category_override%TYPE;
5002: p_calc_user_xrate ap_system_parameters_all.calc_user_xrate%TYPE;
5003: p_approval_workflow_flag ap_system_parameters_all.approval_workflow_flag%TYPE;
5004: p_freight_code_combination_id ap_system_parameters_all.freight_code_combination_id%TYPE;
5005: p_allow_interest_invoices ap_system_parameters_all.auto_calculate_interest_flag%TYPE;
5006: p_add_days_settlement_date ap_system_parameters_all.add_days_settlement_date%TYPE;
5007: p_disc_is_inv_less_tax_flag ap_system_parameters_all.disc_is_inv_less_tax_flag%TYPE;

Line 5004: p_freight_code_combination_id ap_system_parameters_all.freight_code_combination_id%TYPE;

5000: p_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%type;
5001: p_inv_doc_cat_override ap_system_parameters_all.inv_doc_category_override%TYPE;
5002: p_calc_user_xrate ap_system_parameters_all.calc_user_xrate%TYPE;
5003: p_approval_workflow_flag ap_system_parameters_all.approval_workflow_flag%TYPE;
5004: p_freight_code_combination_id ap_system_parameters_all.freight_code_combination_id%TYPE;
5005: p_allow_interest_invoices ap_system_parameters_all.auto_calculate_interest_flag%TYPE;
5006: p_add_days_settlement_date ap_system_parameters_all.add_days_settlement_date%TYPE;
5007: p_disc_is_inv_less_tax_flag ap_system_parameters_all.disc_is_inv_less_tax_flag%TYPE;
5008: p_asset_book_type varchar2(100);

Line 5005: p_allow_interest_invoices ap_system_parameters_all.auto_calculate_interest_flag%TYPE;

5001: p_inv_doc_cat_override ap_system_parameters_all.inv_doc_category_override%TYPE;
5002: p_calc_user_xrate ap_system_parameters_all.calc_user_xrate%TYPE;
5003: p_approval_workflow_flag ap_system_parameters_all.approval_workflow_flag%TYPE;
5004: p_freight_code_combination_id ap_system_parameters_all.freight_code_combination_id%TYPE;
5005: p_allow_interest_invoices ap_system_parameters_all.auto_calculate_interest_flag%TYPE;
5006: p_add_days_settlement_date ap_system_parameters_all.add_days_settlement_date%TYPE;
5007: p_disc_is_inv_less_tax_flag ap_system_parameters_all.disc_is_inv_less_tax_flag%TYPE;
5008: p_asset_book_type varchar2(100);
5009:

Line 5006: p_add_days_settlement_date ap_system_parameters_all.add_days_settlement_date%TYPE;

5002: p_calc_user_xrate ap_system_parameters_all.calc_user_xrate%TYPE;
5003: p_approval_workflow_flag ap_system_parameters_all.approval_workflow_flag%TYPE;
5004: p_freight_code_combination_id ap_system_parameters_all.freight_code_combination_id%TYPE;
5005: p_allow_interest_invoices ap_system_parameters_all.auto_calculate_interest_flag%TYPE;
5006: p_add_days_settlement_date ap_system_parameters_all.add_days_settlement_date%TYPE;
5007: p_disc_is_inv_less_tax_flag ap_system_parameters_all.disc_is_inv_less_tax_flag%TYPE;
5008: p_asset_book_type varchar2(100);
5009:
5010: BEGIN

Line 5007: p_disc_is_inv_less_tax_flag ap_system_parameters_all.disc_is_inv_less_tax_flag%TYPE;

5003: p_approval_workflow_flag ap_system_parameters_all.approval_workflow_flag%TYPE;
5004: p_freight_code_combination_id ap_system_parameters_all.freight_code_combination_id%TYPE;
5005: p_allow_interest_invoices ap_system_parameters_all.auto_calculate_interest_flag%TYPE;
5006: p_add_days_settlement_date ap_system_parameters_all.add_days_settlement_date%TYPE;
5007: p_disc_is_inv_less_tax_flag ap_system_parameters_all.disc_is_inv_less_tax_flag%TYPE;
5008: p_asset_book_type varchar2(100);
5009:
5010: BEGIN
5011: -- Update the calling sequence

Line 5099: FROM ap_system_parameters_all asp,

5095: p_freight_code_combination_id,
5096: p_allow_interest_invoices,
5097: p_add_days_settlement_date,
5098: p_disc_is_inv_less_tax_flag
5099: FROM ap_system_parameters_all asp,
5100: ap_product_setup aps
5101: WHERE asp.org_id = p_org_id;
5102: exception
5103: when others then