APPS.PER_SUC_SHD dependencies on PER_SUCCESSION_PLANNING

Line 41: IF (p_constraint_name = 'PER_SUCCESSION_PLANNING_FK1')

37: BEGIN
38: hr_utility.set_location ('Entering:' || l_proc, 5);
39:
40: --
41: IF (p_constraint_name = 'PER_SUCCESSION_PLANNING_FK1')
42: THEN
43: hr_utility.set_message (801, 'HR_52000_SUC_CHK_POS_EXISTS');
44: hr_utility.raise_error;
45: ELSIF (p_constraint_name = 'PER_SUCCESSION_PLANNING_FK2')

Line 45: ELSIF (p_constraint_name = 'PER_SUCCESSION_PLANNING_FK2')

41: IF (p_constraint_name = 'PER_SUCCESSION_PLANNING_FK1')
42: THEN
43: hr_utility.set_message (801, 'HR_52000_SUC_CHK_POS_EXISTS');
44: hr_utility.raise_error;
45: ELSIF (p_constraint_name = 'PER_SUCCESSION_PLANNING_FK2')
46: THEN
47: hr_utility.set_message (801, 'HR_6153_ALL_PROCEDURE_FAIL');
48: hr_utility.set_message_token ('PROCEDURE', l_proc);
49: hr_utility.set_message_token ('STEP', '10');

Line 51: ELSIF (p_constraint_name = 'PER_SUCCESSION_PLANNING_PK')

47: hr_utility.set_message (801, 'HR_6153_ALL_PROCEDURE_FAIL');
48: hr_utility.set_message_token ('PROCEDURE', l_proc);
49: hr_utility.set_message_token ('STEP', '10');
50: hr_utility.raise_error;
51: ELSIF (p_constraint_name = 'PER_SUCCESSION_PLANNING_PK')
52: THEN
53: hr_utility.set_message (801, 'HR_52006_SUC_CHK_SUCC_PLAN_ID');
54: hr_utility.raise_error;
55: ELSIF (p_constraint_name = 'PER_SUCCESSION_PLANNING_UK')

Line 55: ELSIF (p_constraint_name = 'PER_SUCCESSION_PLANNING_UK')

51: ELSIF (p_constraint_name = 'PER_SUCCESSION_PLANNING_PK')
52: THEN
53: hr_utility.set_message (801, 'HR_52006_SUC_CHK_SUCC_PLAN_ID');
54: hr_utility.raise_error;
55: ELSIF (p_constraint_name = 'PER_SUCCESSION_PLANNING_UK')
56: THEN
57: hr_utility.set_message (800, 'HR_33468_SUC_SAME_SUCCESSOR');
58: hr_utility.raise_error;
59: ELSIF (p_constraint_name = 'PER_SUC_AVAIL_FOR_PROMOTION')

Line 124: FROM per_succession_planning

120: person_rank,
121: PERFORMANCE,
122: plan_status,
123: readiness_percentage
124: FROM per_succession_planning
125: WHERE succession_plan_id = p_succession_plan_id;
126:
127: --
128: l_proc VARCHAR2 (72) := g_package || 'api_updating';

Line 239: FROM per_succession_planning

235: person_rank,
236: PERFORMANCE,
237: plan_status,
238: readiness_percentage
239: FROM per_succession_planning
240: WHERE succession_plan_id = p_succession_plan_id
241: FOR UPDATE NOWAIT;
242:
243: --

Line 294: hr_utility.set_message_token ('TABLE_NAME', 'per_succession_planning');

290: -- The object is locked therefore we need to supply a meaningful
291: -- error message.
292: --
293: hr_utility.set_message (801, 'HR_7165_OBJECT_LOCKED');
294: hr_utility.set_message_token ('TABLE_NAME', 'per_succession_planning');
295: hr_utility.raise_error;
296: END lck;
297:
298: --