DBA Data[Home] [Help]

APPS.PAY_HR_OTC_RETRIEVAL_INTERFACE dependencies on FND_PROFILE

Line 1559: l_retrieval_options fnd_profile_option_values.profile_option_value%TYPE

1555: l_where_clause hxt_interface_utilities.max_varchar;
1556: l_unique_params hxt_interface_utilities.max_varchar;
1557: l_batch_ref pay_batch_headers.batch_reference%TYPE;
1558: l_no_otm hxt_interface_utilities.flag_varchar := 'N';
1559: l_retrieval_options fnd_profile_option_values.profile_option_value%TYPE
1560: := fnd_profile.VALUE ('HXC_RETRIEVAL_OPTIONS');
1561: BEGIN
1562: -- Set session date
1563: hxc_generic_retrieval_pkg.g_ret_criteria.location_id := p_location_id;

Line 1560: := fnd_profile.VALUE ('HXC_RETRIEVAL_OPTIONS');

1556: l_unique_params hxt_interface_utilities.max_varchar;
1557: l_batch_ref pay_batch_headers.batch_reference%TYPE;
1558: l_no_otm hxt_interface_utilities.flag_varchar := 'N';
1559: l_retrieval_options fnd_profile_option_values.profile_option_value%TYPE
1560: := fnd_profile.VALUE ('HXC_RETRIEVAL_OPTIONS');
1561: BEGIN
1562: -- Set session date
1563: hxc_generic_retrieval_pkg.g_ret_criteria.location_id := p_location_id;
1564: hxc_generic_retrieval_pkg.g_ret_criteria.payroll_id := p_payroll_id;