DBA Data[Home] [Help]

APPS.AP_MO_CACHE_UTILS dependencies on CE_BANK_ACCOUNTS

Line 99: sp_aba_bank_account_name ce_bank_accounts.bank_account_name%TYPE,

95: --Bug :2809214 MOAC - Supplier Attribute Change Project
96: --fsp_match_option ap_product_setup.match_option%TYPE,
97: fsp_vat_country_code financials_system_parameters.vat_country_code%TYPE,
98: sp_aba_bank_account_id ap_system_parameters.ce_bank_acct_use_id%TYPE,
99: sp_aba_bank_account_name ce_bank_accounts.bank_account_name%TYPE,
100: sp_aba_zero_amounts_allowed ce_bank_accounts.zero_amount_allowed%TYPE,
101: sp_aba_max_outlay ce_bank_accounts.max_outlay%TYPE,
102: sp_aba_max_check_amount ce_bank_accounts.max_check_amount%TYPE,
103: sp_aba_min_check_amount ce_bank_accounts.min_check_amount%TYPE,

Line 100: sp_aba_zero_amounts_allowed ce_bank_accounts.zero_amount_allowed%TYPE,

96: --fsp_match_option ap_product_setup.match_option%TYPE,
97: fsp_vat_country_code financials_system_parameters.vat_country_code%TYPE,
98: sp_aba_bank_account_id ap_system_parameters.ce_bank_acct_use_id%TYPE,
99: sp_aba_bank_account_name ce_bank_accounts.bank_account_name%TYPE,
100: sp_aba_zero_amounts_allowed ce_bank_accounts.zero_amount_allowed%TYPE,
101: sp_aba_max_outlay ce_bank_accounts.max_outlay%TYPE,
102: sp_aba_max_check_amount ce_bank_accounts.max_check_amount%TYPE,
103: sp_aba_min_check_amount ce_bank_accounts.min_check_amount%TYPE,
104: sp_aba_currency_code ce_bank_accounts.currency_code%TYPE,

Line 101: sp_aba_max_outlay ce_bank_accounts.max_outlay%TYPE,

97: fsp_vat_country_code financials_system_parameters.vat_country_code%TYPE,
98: sp_aba_bank_account_id ap_system_parameters.ce_bank_acct_use_id%TYPE,
99: sp_aba_bank_account_name ce_bank_accounts.bank_account_name%TYPE,
100: sp_aba_zero_amounts_allowed ce_bank_accounts.zero_amount_allowed%TYPE,
101: sp_aba_max_outlay ce_bank_accounts.max_outlay%TYPE,
102: sp_aba_max_check_amount ce_bank_accounts.max_check_amount%TYPE,
103: sp_aba_min_check_amount ce_bank_accounts.min_check_amount%TYPE,
104: sp_aba_currency_code ce_bank_accounts.currency_code%TYPE,
105: sp_aba_multi_currency_flag ce_bank_accounts.multi_currency_allowed_flag%TYPE,

Line 102: sp_aba_max_check_amount ce_bank_accounts.max_check_amount%TYPE,

98: sp_aba_bank_account_id ap_system_parameters.ce_bank_acct_use_id%TYPE,
99: sp_aba_bank_account_name ce_bank_accounts.bank_account_name%TYPE,
100: sp_aba_zero_amounts_allowed ce_bank_accounts.zero_amount_allowed%TYPE,
101: sp_aba_max_outlay ce_bank_accounts.max_outlay%TYPE,
102: sp_aba_max_check_amount ce_bank_accounts.max_check_amount%TYPE,
103: sp_aba_min_check_amount ce_bank_accounts.min_check_amount%TYPE,
104: sp_aba_currency_code ce_bank_accounts.currency_code%TYPE,
105: sp_aba_multi_currency_flag ce_bank_accounts.multi_currency_allowed_flag%TYPE,
106: sp_gdct_user_conversion_type gl_daily_conversion_types.user_conversion_type%TYPE,

Line 103: sp_aba_min_check_amount ce_bank_accounts.min_check_amount%TYPE,

99: sp_aba_bank_account_name ce_bank_accounts.bank_account_name%TYPE,
100: sp_aba_zero_amounts_allowed ce_bank_accounts.zero_amount_allowed%TYPE,
101: sp_aba_max_outlay ce_bank_accounts.max_outlay%TYPE,
102: sp_aba_max_check_amount ce_bank_accounts.max_check_amount%TYPE,
103: sp_aba_min_check_amount ce_bank_accounts.min_check_amount%TYPE,
104: sp_aba_currency_code ce_bank_accounts.currency_code%TYPE,
105: sp_aba_multi_currency_flag ce_bank_accounts.multi_currency_allowed_flag%TYPE,
106: sp_gdct_user_conversion_type gl_daily_conversion_types.user_conversion_type%TYPE,
107: mrc_enabled Varchar2(1) ,

Line 104: sp_aba_currency_code ce_bank_accounts.currency_code%TYPE,

100: sp_aba_zero_amounts_allowed ce_bank_accounts.zero_amount_allowed%TYPE,
101: sp_aba_max_outlay ce_bank_accounts.max_outlay%TYPE,
102: sp_aba_max_check_amount ce_bank_accounts.max_check_amount%TYPE,
103: sp_aba_min_check_amount ce_bank_accounts.min_check_amount%TYPE,
104: sp_aba_currency_code ce_bank_accounts.currency_code%TYPE,
105: sp_aba_multi_currency_flag ce_bank_accounts.multi_currency_allowed_flag%TYPE,
106: sp_gdct_user_conversion_type gl_daily_conversion_types.user_conversion_type%TYPE,
107: mrc_enabled Varchar2(1) ,
108: sp_allow_interest_invoices ap_system_parameters.auto_calculate_interest_flag%TYPE,

Line 105: sp_aba_multi_currency_flag ce_bank_accounts.multi_currency_allowed_flag%TYPE,

101: sp_aba_max_outlay ce_bank_accounts.max_outlay%TYPE,
102: sp_aba_max_check_amount ce_bank_accounts.max_check_amount%TYPE,
103: sp_aba_min_check_amount ce_bank_accounts.min_check_amount%TYPE,
104: sp_aba_currency_code ce_bank_accounts.currency_code%TYPE,
105: sp_aba_multi_currency_flag ce_bank_accounts.multi_currency_allowed_flag%TYPE,
106: sp_gdct_user_conversion_type gl_daily_conversion_types.user_conversion_type%TYPE,
107: mrc_enabled Varchar2(1) ,
108: sp_allow_interest_invoices ap_system_parameters.auto_calculate_interest_flag%TYPE,
109: sp_approval_timing ap_system_parameters.approval_timing%TYPE, --Bug4299234

Line 190: TYPE bankaccountnameTable IS TABLE OF ce_bank_accounts.bank_account_name%TYPE;

186: TYPE purchencumbranceflagTable IS TABLE OF financials_system_parameters.purch_encumbrance_flag%TYPE;
187: TYPE inventoryorganizationidTable IS TABLE OF financials_system_parameters.inventory_organization_id%TYPE;
188: TYPE vatcountrycodeTable IS TABLE OF financials_system_parameters.vat_country_code%TYPE;
189: TYPE bankaccountidTable IS TABLE OF ap_system_parameters.ce_bank_acct_use_id%TYPE;
190: TYPE bankaccountnameTable IS TABLE OF ce_bank_accounts.bank_account_name%TYPE;
191: TYPE zeroamountsallowedTable IS TABLE OF ce_bank_accounts.zero_amount_allowed%TYPE;
192: TYPE maxoutlayTable IS TABLE OF ce_bank_accounts.max_outlay%TYPE;
193: TYPE maxcheckamountTable IS TABLE OF ce_bank_accounts.max_check_amount%TYPE;
194: TYPE mincheckamountTable IS TABLE OF ce_bank_accounts.min_check_amount%TYPE;

Line 191: TYPE zeroamountsallowedTable IS TABLE OF ce_bank_accounts.zero_amount_allowed%TYPE;

187: TYPE inventoryorganizationidTable IS TABLE OF financials_system_parameters.inventory_organization_id%TYPE;
188: TYPE vatcountrycodeTable IS TABLE OF financials_system_parameters.vat_country_code%TYPE;
189: TYPE bankaccountidTable IS TABLE OF ap_system_parameters.ce_bank_acct_use_id%TYPE;
190: TYPE bankaccountnameTable IS TABLE OF ce_bank_accounts.bank_account_name%TYPE;
191: TYPE zeroamountsallowedTable IS TABLE OF ce_bank_accounts.zero_amount_allowed%TYPE;
192: TYPE maxoutlayTable IS TABLE OF ce_bank_accounts.max_outlay%TYPE;
193: TYPE maxcheckamountTable IS TABLE OF ce_bank_accounts.max_check_amount%TYPE;
194: TYPE mincheckamountTable IS TABLE OF ce_bank_accounts.min_check_amount%TYPE;
195: TYPE bankcurrencycodeTable IS TABLE OF ce_bank_accounts.currency_code%TYPE;

Line 192: TYPE maxoutlayTable IS TABLE OF ce_bank_accounts.max_outlay%TYPE;

188: TYPE vatcountrycodeTable IS TABLE OF financials_system_parameters.vat_country_code%TYPE;
189: TYPE bankaccountidTable IS TABLE OF ap_system_parameters.ce_bank_acct_use_id%TYPE;
190: TYPE bankaccountnameTable IS TABLE OF ce_bank_accounts.bank_account_name%TYPE;
191: TYPE zeroamountsallowedTable IS TABLE OF ce_bank_accounts.zero_amount_allowed%TYPE;
192: TYPE maxoutlayTable IS TABLE OF ce_bank_accounts.max_outlay%TYPE;
193: TYPE maxcheckamountTable IS TABLE OF ce_bank_accounts.max_check_amount%TYPE;
194: TYPE mincheckamountTable IS TABLE OF ce_bank_accounts.min_check_amount%TYPE;
195: TYPE bankcurrencycodeTable IS TABLE OF ce_bank_accounts.currency_code%TYPE;
196: TYPE bankmulticurrencyflagTable IS TABLE OF ce_bank_accounts.multi_currency_allowed_flag%TYPE;

Line 193: TYPE maxcheckamountTable IS TABLE OF ce_bank_accounts.max_check_amount%TYPE;

189: TYPE bankaccountidTable IS TABLE OF ap_system_parameters.ce_bank_acct_use_id%TYPE;
190: TYPE bankaccountnameTable IS TABLE OF ce_bank_accounts.bank_account_name%TYPE;
191: TYPE zeroamountsallowedTable IS TABLE OF ce_bank_accounts.zero_amount_allowed%TYPE;
192: TYPE maxoutlayTable IS TABLE OF ce_bank_accounts.max_outlay%TYPE;
193: TYPE maxcheckamountTable IS TABLE OF ce_bank_accounts.max_check_amount%TYPE;
194: TYPE mincheckamountTable IS TABLE OF ce_bank_accounts.min_check_amount%TYPE;
195: TYPE bankcurrencycodeTable IS TABLE OF ce_bank_accounts.currency_code%TYPE;
196: TYPE bankmulticurrencyflagTable IS TABLE OF ce_bank_accounts.multi_currency_allowed_flag%TYPE;
197: TYPE userconversiontypeTable IS TABLE OF gl_daily_conversion_types.user_conversion_type%TYPE;

Line 194: TYPE mincheckamountTable IS TABLE OF ce_bank_accounts.min_check_amount%TYPE;

190: TYPE bankaccountnameTable IS TABLE OF ce_bank_accounts.bank_account_name%TYPE;
191: TYPE zeroamountsallowedTable IS TABLE OF ce_bank_accounts.zero_amount_allowed%TYPE;
192: TYPE maxoutlayTable IS TABLE OF ce_bank_accounts.max_outlay%TYPE;
193: TYPE maxcheckamountTable IS TABLE OF ce_bank_accounts.max_check_amount%TYPE;
194: TYPE mincheckamountTable IS TABLE OF ce_bank_accounts.min_check_amount%TYPE;
195: TYPE bankcurrencycodeTable IS TABLE OF ce_bank_accounts.currency_code%TYPE;
196: TYPE bankmulticurrencyflagTable IS TABLE OF ce_bank_accounts.multi_currency_allowed_flag%TYPE;
197: TYPE userconversiontypeTable IS TABLE OF gl_daily_conversion_types.user_conversion_type%TYPE;
198: TYPE mrcenabledtypeTable IS TABLE OF Varchar2(1) INDEX BY BINARY_INTEGER;

Line 195: TYPE bankcurrencycodeTable IS TABLE OF ce_bank_accounts.currency_code%TYPE;

191: TYPE zeroamountsallowedTable IS TABLE OF ce_bank_accounts.zero_amount_allowed%TYPE;
192: TYPE maxoutlayTable IS TABLE OF ce_bank_accounts.max_outlay%TYPE;
193: TYPE maxcheckamountTable IS TABLE OF ce_bank_accounts.max_check_amount%TYPE;
194: TYPE mincheckamountTable IS TABLE OF ce_bank_accounts.min_check_amount%TYPE;
195: TYPE bankcurrencycodeTable IS TABLE OF ce_bank_accounts.currency_code%TYPE;
196: TYPE bankmulticurrencyflagTable IS TABLE OF ce_bank_accounts.multi_currency_allowed_flag%TYPE;
197: TYPE userconversiontypeTable IS TABLE OF gl_daily_conversion_types.user_conversion_type%TYPE;
198: TYPE mrcenabledtypeTable IS TABLE OF Varchar2(1) INDEX BY BINARY_INTEGER;
199: TYPE AllowInterestInvoicesTable IS TABLE OF ap_system_parameters.auto_calculate_interest_flag%TYPE;

Line 196: TYPE bankmulticurrencyflagTable IS TABLE OF ce_bank_accounts.multi_currency_allowed_flag%TYPE;

192: TYPE maxoutlayTable IS TABLE OF ce_bank_accounts.max_outlay%TYPE;
193: TYPE maxcheckamountTable IS TABLE OF ce_bank_accounts.max_check_amount%TYPE;
194: TYPE mincheckamountTable IS TABLE OF ce_bank_accounts.min_check_amount%TYPE;
195: TYPE bankcurrencycodeTable IS TABLE OF ce_bank_accounts.currency_code%TYPE;
196: TYPE bankmulticurrencyflagTable IS TABLE OF ce_bank_accounts.multi_currency_allowed_flag%TYPE;
197: TYPE userconversiontypeTable IS TABLE OF gl_daily_conversion_types.user_conversion_type%TYPE;
198: TYPE mrcenabledtypeTable IS TABLE OF Varchar2(1) INDEX BY BINARY_INTEGER;
199: TYPE AllowInterestInvoicesTable IS TABLE OF ap_system_parameters.auto_calculate_interest_flag%TYPE;
200: TYPE approval_timingTable IS TABLE OF ap_system_parameters.approval_timing%TYPE; --Bug4299234