APPS.HR_H2PI_MAP dependencies on HR_H2PI_ID_MAPPING

Line 16: -- Description: Insert a record into HR_H2PI_ID_MAPPING to map internal ids

12: --
13: -- ----------------------------------------------------------------------------
14: -- |--< Create_Id_Mapping >---------------------------------------------------|
15: -- ----------------------------------------------------------------------------
16: -- Description: Insert a record into HR_H2PI_ID_MAPPING to map internal ids
17: -- from the HR to Payroll system.
18: -- ----------------------------------------------------------------------------
19: PROCEDURE create_id_mapping (p_table_name VARCHAR2,
20: p_from_id NUMBER,

Line 47: INSERT INTO hr_h2pi_id_mapping

43: 'The Parameter Value for TO_ID cannot be null';
44: RAISE INVALID_PARAM;
45: END IF;
46:
47: INSERT INTO hr_h2pi_id_mapping
48: (to_business_group_id, from_id, to_id, table_name)
49: SELECT distinct hr_h2pi_upload.g_to_business_group_id,
50: p_from_id,
51: p_to_id,

Line 53: FROM hr_h2pi_id_mapping im1

49: SELECT distinct hr_h2pi_upload.g_to_business_group_id,
50: p_from_id,
51: p_to_id,
52: p_table_name
53: FROM hr_h2pi_id_mapping im1
54: WHERE NOT EXISTS (SELECT 1
55: FROM hr_h2pi_id_mapping im2
56: WHERE to_business_group_id =
57: hr_h2pi_upload.g_to_business_group_id

Line 55: FROM hr_h2pi_id_mapping im2

51: p_to_id,
52: p_table_name
53: FROM hr_h2pi_id_mapping im1
54: WHERE NOT EXISTS (SELECT 1
55: FROM hr_h2pi_id_mapping im2
56: WHERE to_business_group_id =
57: hr_h2pi_upload.g_to_business_group_id
58: AND from_id = p_from_id
59: AND to_id = p_to_id

Line 85: l_to_id hr_h2pi_id_mapping.to_id%type;

81: p_from_id NUMBER,
82: p_report_error BOOLEAN DEFAULT FALSE) RETURN NUMBER IS
83:
84: l_proc VARCHAR2(72) := g_package||'get_to_id';
85: l_to_id hr_h2pi_id_mapping.to_id%type;
86: INVALID_PARAM EXCEPTION;
87: PRAGMA EXCEPTION_INIT(INVALID_PARAM,-20001);
88:
89: BEGIN

Line 99: FROM hr_h2pi_id_mapping

95: RETURN NULL;
96: END IF;
97:
98: SELECT to_id INTO l_to_id
99: FROM hr_h2pi_id_mapping
100: WHERE to_business_group_id = hr_h2pi_upload.g_to_business_group_id
101: AND table_name = p_table_name
102: AND from_id = p_from_id;
103: RETURN l_to_id;

Line 139: l_from_id hr_h2pi_id_mapping.from_id%type;

135: p_to_id NUMBER,
136: p_report_error BOOLEAN DEFAULT FALSE) RETURN NUMBER IS
137:
138: l_proc VARCHAR2(72) := g_package||'get_from_id';
139: l_from_id hr_h2pi_id_mapping.from_id%type;
140: INVALID_PARAM EXCEPTION;
141: PRAGMA EXCEPTION_INIT(INVALID_PARAM,-20001);
142:
143: BEGIN

Line 153: FROM hr_h2pi_id_mapping

149: RETURN NULL;
150: END IF;
151:
152: SELECT from_id INTO l_from_id
153: FROM hr_h2pi_id_mapping
154: WHERE to_business_group_id = hr_h2pi_upload.g_to_business_group_id
155: AND table_name = p_table_name
156: AND to_id = p_to_id;
157: