APPS.HXC_RET_UPLOAD_PKG dependencies on HXC_RETRIEVAL_PROCESSES

Line 31: l_retrieval_process_id hxc_retrieval_processes.retrieval_process_id%TYPE;

27: , p_mapping_name IN VARCHAR2
28: , p_owner IN VARCHAR2
29: , p_custom_mode IN VARCHAR2 ) IS
30:
31: l_retrieval_process_id hxc_retrieval_processes.retrieval_process_id%TYPE;
32: l_time_recipient_id hxc_time_recipients.time_recipient_id%TYPE;
33: l_mapping_id hxc_mappings.mapping_id%TYPE;
34: l_ovn hxc_deposit_processes.object_version_number%TYPE;
35: l_owner VARCHAR2(6);

Line 48: FROM hxc_retrieval_processes

44: , DECODE( NVL(last_updated_by,-1), 1, 'SEED', 'CUSTOM')
45: INTO l_retrieval_process_id
46: , l_ovn
47: , l_owner
48: FROM hxc_retrieval_processes
49: WHERE name = P_NAME;
50:
51: IF ( p_custom_mode = 'FORCE' OR l_owner = 'SEED' )
52: THEN

Line 54: hxc_retrieval_processes_api.update_retrieval_processes (

50:
51: IF ( p_custom_mode = 'FORCE' OR l_owner = 'SEED' )
52: THEN
53:
54: hxc_retrieval_processes_api.update_retrieval_processes (
55: p_name => p_name
56: , p_time_recipient_id => l_time_recipient_id
57: , p_mapping_id => l_mapping_id
58: , p_retrieval_process_id => l_retrieval_process_id

Line 66: hxc_retrieval_processes_api.create_retrieval_processes (

62:
63: EXCEPTION WHEN NO_DATA_FOUND
64: THEN
65:
66: hxc_retrieval_processes_api.create_retrieval_processes (
67: p_name => p_name
68: , p_time_recipient_id => l_time_recipient_id
69: , p_mapping_id => l_mapping_id
70: , p_retrieval_process_id => l_retrieval_process_id