APPS.HXC_GENERIC_RETRIEVAL_UTILS dependencies on HXC_RETRIEVAL_PROCESSES

Line 79: hxc_retrieval_processes hrp

75: htd.time_building_block_ovn,
76: ht.transaction_process_id
77: FROM hxc_transaction_details htd,
78: hxc_transactions ht,
79: hxc_retrieval_processes hrp
80: WHERE htd.time_building_block_id = p_curr_bb_id
81: AND htd.transaction_id = ht.transaction_id
82: AND ht.type = 'RETRIEVAL'
83: AND htd.status = 'SUCCESS'

Line 426: l_bee_ret_id hxc_retrieval_processes.retrieval_process_id%TYPE;

422:
423: l_rtr_exists t_rtr_exists;
424:
425:
426: l_bee_ret_id hxc_retrieval_processes.retrieval_process_id%TYPE;
427:
428:
429: l_process_id hxc_retrieval_processes.retrieval_process_id%TYPE;
430: l_rtr_process_id hxc_retrieval_processes.retrieval_process_id%TYPE;

Line 429: l_process_id hxc_retrieval_processes.retrieval_process_id%TYPE;

425:
426: l_bee_ret_id hxc_retrieval_processes.retrieval_process_id%TYPE;
427:
428:
429: l_process_id hxc_retrieval_processes.retrieval_process_id%TYPE;
430: l_rtr_process_id hxc_retrieval_processes.retrieval_process_id%TYPE;
431:
432:
433: l_resource_start_time DATE;

Line 430: l_rtr_process_id hxc_retrieval_processes.retrieval_process_id%TYPE;

426: l_bee_ret_id hxc_retrieval_processes.retrieval_process_id%TYPE;
427:
428:
429: l_process_id hxc_retrieval_processes.retrieval_process_id%TYPE;
430: l_rtr_process_id hxc_retrieval_processes.retrieval_process_id%TYPE;
431:
432:
433: l_resource_start_time DATE;
434: l_resource_stop_time DATE;

Line 477: FROM hxc_retrieval_processes ret

473: apsc.time_recipient_id = p_ret_tr_id;
474:
475: CURSOR csr_get_bee_ret_id IS
476: SELECT ret.retrieval_process_id
477: FROM hxc_retrieval_processes ret
478: WHERE ret.name = 'BEE Retrieval Process';
479:
480:
481: BEGIN -- parse_resources