APPS.HXC_GENERIC_RETRIEVAL_UTILS dependencies on HXC_RETRIEVAL_PROCESSES

Line 74: hxc_retrieval_processes hrp

70: htd.time_building_block_ovn,
71: ht.transaction_process_id
72: FROM hxc_transaction_details htd,
73: hxc_transactions ht,
74: hxc_retrieval_processes hrp
75: WHERE htd.time_building_block_id = p_curr_bb_id
76: AND htd.transaction_id = ht.transaction_id
77: AND ht.type = 'RETRIEVAL'
78: AND htd.status = 'SUCCESS'

Line 343: l_bee_ret_id hxc_retrieval_processes.retrieval_process_id%TYPE;

339:
340: l_rtr_exists t_rtr_exists;
341:
342:
343: l_bee_ret_id hxc_retrieval_processes.retrieval_process_id%TYPE;
344:
345:
346: l_process_id hxc_retrieval_processes.retrieval_process_id%TYPE;
347: l_rtr_process_id hxc_retrieval_processes.retrieval_process_id%TYPE;

Line 346: l_process_id hxc_retrieval_processes.retrieval_process_id%TYPE;

342:
343: l_bee_ret_id hxc_retrieval_processes.retrieval_process_id%TYPE;
344:
345:
346: l_process_id hxc_retrieval_processes.retrieval_process_id%TYPE;
347: l_rtr_process_id hxc_retrieval_processes.retrieval_process_id%TYPE;
348:
349:
350: l_resource_start_time DATE;

Line 347: l_rtr_process_id hxc_retrieval_processes.retrieval_process_id%TYPE;

343: l_bee_ret_id hxc_retrieval_processes.retrieval_process_id%TYPE;
344:
345:
346: l_process_id hxc_retrieval_processes.retrieval_process_id%TYPE;
347: l_rtr_process_id hxc_retrieval_processes.retrieval_process_id%TYPE;
348:
349:
350: l_resource_start_time DATE;
351: l_resource_stop_time DATE;

Line 394: FROM hxc_retrieval_processes ret

390: apsc.time_recipient_id = p_ret_tr_id;
391:
392: CURSOR csr_get_bee_ret_id IS
393: SELECT ret.retrieval_process_id
394: FROM hxc_retrieval_processes ret
395: WHERE ret.name = 'BEE Retrieval Process';
396:
397:
398: BEGIN -- parse_resources