DBA Data[Home] [Help]

APPS.PAY_HR_OTC_RETRIEVAL_INTERFACE dependencies on FND_PROFILE_OPTION_VALUES

Line 2291: l_retrieval_options fnd_profile_option_values.profile_option_value%TYPE

2287: l_where_clause hxt_interface_utilities.max_varchar;
2288: l_unique_params hxt_interface_utilities.max_varchar;
2289: l_batch_ref pay_batch_headers.batch_reference%TYPE;
2290: l_no_otm hxt_interface_utilities.flag_varchar := 'N';
2291: l_retrieval_options fnd_profile_option_values.profile_option_value%TYPE
2292: := fnd_profile.VALUE ('HXC_RETRIEVAL_OPTIONS');
2293: BEGIN
2294: -- Set session date
2295: hxc_generic_retrieval_pkg.g_ret_criteria.location_id := p_location_id;