APPS.PER_RECRUIT_ACTIVITY_FOR_PKG dependencies on PER_RECRUITMENT_ACTIVITY_FOR

Line 37: FROM per_recruitment_activity_for

33: procedure chk_vacancy_unique ( p_vacancy_id NUMBER,
34: p_recruitment_activity_id NUMBER ) is
35: CURSOR c1 is
36: SELECT 1
37: FROM per_recruitment_activity_for
38: WHERE recruitment_activity_id = p_recruitment_activity_id
39: AND vacancy_id = p_vacancy_id ;
40: l_dummy number ;
41: --

Line 73: FROM per_recruitment_activity_for recf

69: P_recruitment_activity_id NUMBER,
70: P_Business_group_id NUMBER
71: ) IS
72: SELECT recf.recruitment_activity_id
73: FROM per_recruitment_activity_for recf
74: WHERE recf.recruitment_activity_id = P_recruitment_activity_id
75: AND recf.business_group_id + 0 = P_Business_group_id;
76: --
77: v_dummy_id number;

Line 116: FROM PER_RECRUITMENT_ACTIVITY_FOR

112: X_Recruitment_Activity_Id NUMBER)
113: IS
114: CURSOR C IS
115: SELECT rowid
116: FROM PER_RECRUITMENT_ACTIVITY_FOR
117: WHERE recruitment_activity_for_id = X_Recruitment_Activity_For_Id;
118:
119:
120: CURSOR C2 IS

Line 121: SELECT per_recruitment_activity_for_s.nextval

117: WHERE recruitment_activity_for_id = X_Recruitment_Activity_For_Id;
118:
119:
120: CURSOR C2 IS
121: SELECT per_recruitment_activity_for_s.nextval
122: FROM sys.dual;
123:
124: BEGIN
125: --

Line 137: INSERT INTO PER_RECRUITMENT_ACTIVITY_FOR

133: OPEN C2;
134: FETCH C2 INTO X_Recruitment_Activity_For_Id;
135: CLOSE C2;
136: end if;
137: INSERT INTO PER_RECRUITMENT_ACTIVITY_FOR
138: (recruitment_activity_for_id,
139: business_group_id,
140: vacancy_id,
141: recruitment_activity_id)

Line 182: FROM PER_RECRUITMENT_ACTIVITY_FOR

178: X_Recruitment_Activity_Id NUMBER)
179: IS
180: CURSOR C IS
181: SELECT *
182: FROM PER_RECRUITMENT_ACTIVITY_FOR
183: WHERE rowid = X_Rowid
184: FOR UPDATE of Recruitment_Activity_For_Id NOWAIT;
185: Recinfo C%ROWTYPE;
186:

Line 247: UPDATE PER_RECRUITMENT_ACTIVITY_FOR

243: --
244: chk_vacancy_unique ( p_recruitment_activity_id => X_recruitment_activity_id,
245: p_vacancy_id => X_vacancy_id ) ;
246: --
247: UPDATE PER_RECRUITMENT_ACTIVITY_FOR
248: SET
249:
250: recruitment_activity_for_id = X_Recruitment_Activity_For_Id,
251: business_group_id = X_Business_Group_Id,

Line 280: DELETE FROM PER_RECRUITMENT_ACTIVITY_FOR

276: -----------------------------------------------------------------------------
277: --
278: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
279: BEGIN
280: DELETE FROM PER_RECRUITMENT_ACTIVITY_FOR
281: WHERE rowid = X_Rowid;
282:
283: if (SQL%NOTFOUND) then
284: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');