APPS.HXC_DEP_UPLOAD_PKG dependencies on HXC_DEPOSIT_PROCESSES

Line 31: l_deposit_process_id hxc_deposit_processes.deposit_process_id%TYPE;

27: , p_mapping_name IN VARCHAR2
28: , p_owner IN VARCHAR2
29: , p_custom_mode IN VARCHAR2 ) IS
30:
31: l_deposit_process_id hxc_deposit_processes.deposit_process_id%TYPE;
32: l_time_source_id hxc_time_sources.time_source_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 34: l_ovn hxc_deposit_processes.object_version_number%TYPE;

30:
31: l_deposit_process_id hxc_deposit_processes.deposit_process_id%TYPE;
32: l_time_source_id hxc_time_sources.time_source_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);
36:
37: BEGIN
38:

Line 48: FROM hxc_deposit_processes

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

Line 53: hxc_deposit_processes_api.update_deposit_processes (

49: WHERE name = P_NAME;
50:
51: IF ( p_custom_mode = 'FORCE' OR p_owner = 'SEED' )
52: THEN
53: hxc_deposit_processes_api.update_deposit_processes (
54: p_effective_date => sysdate
55: , p_name => p_name
56: , p_time_source_id => l_time_source_id
57: , p_mapping_id => l_mapping_id

Line 66: hxc_deposit_processes_api.create_deposit_processes (

62:
63: EXCEPTION WHEN NO_DATA_FOUND
64: THEN
65:
66: hxc_deposit_processes_api.create_deposit_processes (
67: p_effective_date => sysdate
68: , p_name => p_name
69: , p_time_source_id => l_time_source_id
70: , p_mapping_id => l_mapping_id