APPS.HXC_RTR_UPLOAD_PKG dependencies on HXC_RETRIEVAL_PROCESSES

Line 11: l_retrieval_process_id hxc_retrieval_processes.retrieval_process_id%TYPE;

7: , p_owner VARCHAR2
8: , p_custom_mode VARCHAR2 ) IS
9:
10: l_retrieval_rule_id hxc_retrieval_rules.retrieval_rule_id%TYPE;
11: l_retrieval_process_id hxc_retrieval_processes.retrieval_process_id%TYPE;
12: l_ovn hxc_retrieval_rules.object_version_number%TYPE := NULL;
13: l_owner VARCHAR2(6);
14:
15: FUNCTION get_retrieval_process_id ( p_retrieval_process_name VARCHAR2 ) RETURN NUMBER IS

Line 17: l_retrieval_process_id hxc_retrieval_processes.retrieval_process_id%TYPE;

13: l_owner VARCHAR2(6);
14:
15: FUNCTION get_retrieval_process_id ( p_retrieval_process_name VARCHAR2 ) RETURN NUMBER IS
16:
17: l_retrieval_process_id hxc_retrieval_processes.retrieval_process_id%TYPE;
18:
19: CURSOR csr_get_ret_id IS
20: SELECT retrieval_process_id
21: FROM hxc_retrieval_processes

Line 21: FROM hxc_retrieval_processes

17: l_retrieval_process_id hxc_retrieval_processes.retrieval_process_id%TYPE;
18:
19: CURSOR csr_get_ret_id IS
20: SELECT retrieval_process_id
21: FROM hxc_retrieval_processes
22: WHERE name = p_retrieval_process_name;
23:
24: BEGIN
25: