DBA Data[Home] [Help]

APPS.PER_RCF_UPD dependencies on PER_RCF_SHD

Line 55: (p_rec in out nocopy per_rcf_shd.g_rec_type

51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml
55: (p_rec in out nocopy per_rcf_shd.g_rec_type
56: ) is
57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: --

Line 91: per_rcf_shd.constraint_error

87: Exception
88: When hr_api.check_integrity_violated Then
89: -- A check constraint has been violated
90: --
91: per_rcf_shd.constraint_error
92: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
93: When hr_api.parent_integrity_violated Then
94: -- Parent integrity has been violated
95: --

Line 96: per_rcf_shd.constraint_error

92: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
93: When hr_api.parent_integrity_violated Then
94: -- Parent integrity has been violated
95: --
96: per_rcf_shd.constraint_error
97: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
98: When hr_api.unique_integrity_violated Then
99: -- Unique integrity has been violated
100: --

Line 101: per_rcf_shd.constraint_error

97: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
98: When hr_api.unique_integrity_violated Then
99: -- Unique integrity has been violated
100: --
101: per_rcf_shd.constraint_error
102: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
103: When Others Then
104: --
105: Raise;

Line 141: (p_rec in per_rcf_shd.g_rec_type

137: --
138: -- {End Of Comments}
139: -- ----------------------------------------------------------------------------
140: Procedure pre_update
141: (p_rec in per_rcf_shd.g_rec_type
142: ) is
143: --
144: l_proc varchar2(72) := g_package||'pre_update';
145: --

Line 185: (p_rec in per_rcf_shd.g_rec_type

181: --
182: -- {End Of Comments}
183: -- ----------------------------------------------------------------------------
184: Procedure post_update
185: (p_rec in per_rcf_shd.g_rec_type
186: ) is
187: --
188: l_proc varchar2(72) := g_package||'post_update';
189: --

Line 214: => per_rcf_shd.g_old_rec.business_group_id

210: => p_rec.program_update_date
211: ,p_object_version_number
212: => p_rec.object_version_number
213: ,p_business_group_id_o
214: => per_rcf_shd.g_old_rec.business_group_id
215: ,p_vacancy_id_o
216: => per_rcf_shd.g_old_rec.vacancy_id
217: ,p_rec_activity_id_o
218: => per_rcf_shd.g_old_rec.rec_activity_id

Line 216: => per_rcf_shd.g_old_rec.vacancy_id

212: => p_rec.object_version_number
213: ,p_business_group_id_o
214: => per_rcf_shd.g_old_rec.business_group_id
215: ,p_vacancy_id_o
216: => per_rcf_shd.g_old_rec.vacancy_id
217: ,p_rec_activity_id_o
218: => per_rcf_shd.g_old_rec.rec_activity_id
219: ,p_request_id_o
220: => per_rcf_shd.g_old_rec.request_id

Line 218: => per_rcf_shd.g_old_rec.rec_activity_id

214: => per_rcf_shd.g_old_rec.business_group_id
215: ,p_vacancy_id_o
216: => per_rcf_shd.g_old_rec.vacancy_id
217: ,p_rec_activity_id_o
218: => per_rcf_shd.g_old_rec.rec_activity_id
219: ,p_request_id_o
220: => per_rcf_shd.g_old_rec.request_id
221: ,p_program_application_id_o
222: => per_rcf_shd.g_old_rec.program_application_id

Line 220: => per_rcf_shd.g_old_rec.request_id

216: => per_rcf_shd.g_old_rec.vacancy_id
217: ,p_rec_activity_id_o
218: => per_rcf_shd.g_old_rec.rec_activity_id
219: ,p_request_id_o
220: => per_rcf_shd.g_old_rec.request_id
221: ,p_program_application_id_o
222: => per_rcf_shd.g_old_rec.program_application_id
223: ,p_program_id_o
224: => per_rcf_shd.g_old_rec.program_id

Line 222: => per_rcf_shd.g_old_rec.program_application_id

218: => per_rcf_shd.g_old_rec.rec_activity_id
219: ,p_request_id_o
220: => per_rcf_shd.g_old_rec.request_id
221: ,p_program_application_id_o
222: => per_rcf_shd.g_old_rec.program_application_id
223: ,p_program_id_o
224: => per_rcf_shd.g_old_rec.program_id
225: ,p_program_update_date_o
226: => per_rcf_shd.g_old_rec.program_update_date

Line 224: => per_rcf_shd.g_old_rec.program_id

220: => per_rcf_shd.g_old_rec.request_id
221: ,p_program_application_id_o
222: => per_rcf_shd.g_old_rec.program_application_id
223: ,p_program_id_o
224: => per_rcf_shd.g_old_rec.program_id
225: ,p_program_update_date_o
226: => per_rcf_shd.g_old_rec.program_update_date
227: ,p_object_version_number_o
228: => per_rcf_shd.g_old_rec.object_version_number

Line 226: => per_rcf_shd.g_old_rec.program_update_date

222: => per_rcf_shd.g_old_rec.program_application_id
223: ,p_program_id_o
224: => per_rcf_shd.g_old_rec.program_id
225: ,p_program_update_date_o
226: => per_rcf_shd.g_old_rec.program_update_date
227: ,p_object_version_number_o
228: => per_rcf_shd.g_old_rec.object_version_number
229: );
230: --

Line 228: => per_rcf_shd.g_old_rec.object_version_number

224: => per_rcf_shd.g_old_rec.program_id
225: ,p_program_update_date_o
226: => per_rcf_shd.g_old_rec.program_update_date
227: ,p_object_version_number_o
228: => per_rcf_shd.g_old_rec.object_version_number
229: );
230: --
231: exception
232: --

Line 288: (p_rec in out nocopy per_rcf_shd.g_rec_type

284: --
285: -- {End Of Comments}
286: -- ----------------------------------------------------------------------------
287: Procedure convert_defs
288: (p_rec in out nocopy per_rcf_shd.g_rec_type
289: ) is
290: --
291: Begin
292: --

Line 300: per_rcf_shd.g_old_rec.business_group_id;

296: -- is being used then we must set to the 'current' argument value.
297: --
298: If (p_rec.business_group_id = hr_api.g_number) then
299: p_rec.business_group_id :=
300: per_rcf_shd.g_old_rec.business_group_id;
301: End If;
302: If (p_rec.vacancy_id = hr_api.g_number) then
303: p_rec.vacancy_id :=
304: per_rcf_shd.g_old_rec.vacancy_id;

Line 304: per_rcf_shd.g_old_rec.vacancy_id;

300: per_rcf_shd.g_old_rec.business_group_id;
301: End If;
302: If (p_rec.vacancy_id = hr_api.g_number) then
303: p_rec.vacancy_id :=
304: per_rcf_shd.g_old_rec.vacancy_id;
305: End If;
306: If (p_rec.rec_activity_id = hr_api.g_number) then
307: p_rec.rec_activity_id :=
308: per_rcf_shd.g_old_rec.rec_activity_id;

Line 308: per_rcf_shd.g_old_rec.rec_activity_id;

304: per_rcf_shd.g_old_rec.vacancy_id;
305: End If;
306: If (p_rec.rec_activity_id = hr_api.g_number) then
307: p_rec.rec_activity_id :=
308: per_rcf_shd.g_old_rec.rec_activity_id;
309: End If;
310: If (p_rec.request_id = hr_api.g_number) then
311: p_rec.request_id :=
312: per_rcf_shd.g_old_rec.request_id;

Line 312: per_rcf_shd.g_old_rec.request_id;

308: per_rcf_shd.g_old_rec.rec_activity_id;
309: End If;
310: If (p_rec.request_id = hr_api.g_number) then
311: p_rec.request_id :=
312: per_rcf_shd.g_old_rec.request_id;
313: End If;
314: If (p_rec.program_application_id = hr_api.g_number) then
315: p_rec.program_application_id :=
316: per_rcf_shd.g_old_rec.program_application_id;

Line 316: per_rcf_shd.g_old_rec.program_application_id;

312: per_rcf_shd.g_old_rec.request_id;
313: End If;
314: If (p_rec.program_application_id = hr_api.g_number) then
315: p_rec.program_application_id :=
316: per_rcf_shd.g_old_rec.program_application_id;
317: End If;
318: If (p_rec.program_id = hr_api.g_number) then
319: p_rec.program_id :=
320: per_rcf_shd.g_old_rec.program_id;

Line 320: per_rcf_shd.g_old_rec.program_id;

316: per_rcf_shd.g_old_rec.program_application_id;
317: End If;
318: If (p_rec.program_id = hr_api.g_number) then
319: p_rec.program_id :=
320: per_rcf_shd.g_old_rec.program_id;
321: End If;
322: If (p_rec.program_update_date = hr_api.g_date) then
323: p_rec.program_update_date :=
324: per_rcf_shd.g_old_rec.program_update_date;

Line 324: per_rcf_shd.g_old_rec.program_update_date;

320: per_rcf_shd.g_old_rec.program_id;
321: End If;
322: If (p_rec.program_update_date = hr_api.g_date) then
323: p_rec.program_update_date :=
324: per_rcf_shd.g_old_rec.program_update_date;
325: End If;
326: --
327: End convert_defs;
328: --

Line 333: (p_rec in out nocopy per_rcf_shd.g_rec_type

329: -- ----------------------------------------------------------------------------
330: -- |---------------------------------< upd >----------------------------------|
331: -- ----------------------------------------------------------------------------
332: Procedure upd
333: (p_rec in out nocopy per_rcf_shd.g_rec_type
334: ) is
335: --
336: l_proc varchar2(72) := g_package||'upd';
337: --

Line 343: per_rcf_shd.lck

339: hr_utility.set_location('Entering:'||l_proc, 5);
340: --
341: -- We must lock the row which we need to update.
342: --
343: per_rcf_shd.lck
344: (p_rec.rec_activity_for_id
345: ,p_rec.object_version_number
346: );
347: --

Line 393: l_rec per_rcf_shd.g_rec_type;

389: ,p_program_id in number default hr_api.g_number
390: ,p_program_update_date in date default hr_api.g_date
391: ) is
392: --
393: l_rec per_rcf_shd.g_rec_type;
394: l_proc varchar2(72) := g_package||'upd';
395: --
396: Begin
397: hr_utility.set_location('Entering:'||l_proc, 5);

Line 403: per_rcf_shd.convert_args

399: -- Call conversion function to turn arguments into the
400: -- l_rec structure.
401: --
402: l_rec :=
403: per_rcf_shd.convert_args
404: (p_rec_activity_for_id
405: ,p_business_group_id
406: ,p_vacancy_id
407: ,p_rec_activity_id