APPS.PAY_HR_OTC_RETRIEVAL_INTERFACE dependencies on HXC_GENERIC_RETRIEVAL_UTILS

Line 533: hxc_generic_retrieval_utils.set_parent_statuses;

529: IS
530: l_proc CONSTANT proc_name := g_package || 'set_transaction';
531: BEGIN
532: hr_utility.set_location ('Entering ' || l_proc, 10);
533: hxc_generic_retrieval_utils.set_parent_statuses;
534: hxc_generic_retrieval_pkg.update_transaction_status
535: (p_process => p_process_name,
536: p_status => p_status,
537: p_exception_description => SUBSTR

Line 629: IF NOT hxc_generic_retrieval_utils.g_resources.EXISTS(p_resource_id)

625: THEN
626: hr_utility.trace('p_resource_id = '||p_resource_id);
627: END IF;
628:
629: IF NOT hxc_generic_retrieval_utils.g_resources.EXISTS(p_resource_id)
630: THEN
631: IF g_debug
632: THEN
633: hr_utility.trace(' Resource does not exists; returning here ');

Line 650: hxc_generic_retrieval_utils.g_resources(p_resource_id).start_time)

646:
647: hxc_preference_evaluation.resource_preferences
648: (p_resource_id => p_resource_id
649: ,p_start_evaluation_date => NVL(p_start_date,
650: hxc_generic_retrieval_utils.g_resources(p_resource_id).start_time)
651: ,p_end_evaluation_date => NVL(p_end_date,
652: hxc_generic_retrieval_utils.g_resources(p_resource_id).stop_time)
653: ,p_pref_table => l_pref_tab );
654:

Line 652: hxc_generic_retrieval_utils.g_resources(p_resource_id).stop_time)

648: (p_resource_id => p_resource_id
649: ,p_start_evaluation_date => NVL(p_start_date,
650: hxc_generic_retrieval_utils.g_resources(p_resource_id).start_time)
651: ,p_end_evaluation_date => NVL(p_end_date,
652: hxc_generic_retrieval_utils.g_resources(p_resource_id).stop_time)
653: ,p_pref_table => l_pref_tab );
654:
655: IF l_pref_tab.COUNT > 0
656: THEN

Line 2236: hxc_generic_retrieval_utils.set_parent_statuses;

2232: THEN
2233:
2234: hr_utility.trace(dbms_utility.format_error_backtrace);
2235: set_sqlerror_trx (g_bee_retrieval_process);
2236: hxc_generic_retrieval_utils.set_parent_statuses;
2237: hxc_generic_retrieval_pkg.update_transaction_status
2238: (p_process => g_bee_retrieval_process,
2239: p_status => 'ERRORS',
2240: p_exception_description => SUBSTR

Line 2762: -- hxc_generic_retrieval_utils.chk_retrieve would have populated these

2758:
2759: -- Bug 6121705
2760: -- This procedure is used to create reversal batches with Batch source as OTM
2761: -- for the details in hxc_bee_pref_adj_lines table with OTM as batch source.
2762: -- hxc_generic_retrieval_utils.chk_retrieve would have populated these
2763: -- records for which there is a history of a different preference for rules
2764: -- evaluation.
2765:
2766: