eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_REQ_UPD dependencies on PER_REQ_SHD

Line 55: (p_rec in out nocopy per_req_shd.g_rec_type

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

Line 116: per_req_shd.constraint_error

112: Exception
113: When hr_api.check_integrity_violated Then
114: -- A check constraint has been violated
115: --
116: per_req_shd.constraint_error
117: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
118: When hr_api.parent_integrity_violated Then
119: -- Parent integrity has been violated
120: --

Line 121: per_req_shd.constraint_error

117: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
118: When hr_api.parent_integrity_violated Then
119: -- Parent integrity has been violated
120: --
121: per_req_shd.constraint_error
122: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
123: When hr_api.unique_integrity_violated Then
124: -- Unique integrity has been violated
125: --

Line 126: per_req_shd.constraint_error

122: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
123: When hr_api.unique_integrity_violated Then
124: -- Unique integrity has been violated
125: --
126: per_req_shd.constraint_error
127: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
128: When Others Then
129: --
130: Raise;

Line 166: (p_rec in per_req_shd.g_rec_type

162: --
163: -- {End Of Comments}
164: -- ----------------------------------------------------------------------------
165: Procedure pre_update
166: (p_rec in per_req_shd.g_rec_type
167: ) is
168: --
169: l_proc varchar2(72) := g_package||'pre_update';
170: --

Line 210: (p_rec in per_req_shd.g_rec_type

206: --
207: -- {End Of Comments}
208: -- ----------------------------------------------------------------------------
209: Procedure post_update
210: (p_rec in per_req_shd.g_rec_type
211: ) is
212: --
213: l_proc varchar2(72) := g_package||'post_update';
214: --

Line 289: => per_req_shd.g_old_rec.business_group_id

285: => p_rec.attribute20
286: ,p_object_version_number
287: => p_rec.object_version_number
288: ,p_business_group_id_o
289: => per_req_shd.g_old_rec.business_group_id
290: ,p_person_id_o
291: => per_req_shd.g_old_rec.person_id
292: ,p_date_from_o
293: => per_req_shd.g_old_rec.date_from

Line 291: => per_req_shd.g_old_rec.person_id

287: => p_rec.object_version_number
288: ,p_business_group_id_o
289: => per_req_shd.g_old_rec.business_group_id
290: ,p_person_id_o
291: => per_req_shd.g_old_rec.person_id
292: ,p_date_from_o
293: => per_req_shd.g_old_rec.date_from
294: ,p_name_o
295: => per_req_shd.g_old_rec.name

Line 293: => per_req_shd.g_old_rec.date_from

289: => per_req_shd.g_old_rec.business_group_id
290: ,p_person_id_o
291: => per_req_shd.g_old_rec.person_id
292: ,p_date_from_o
293: => per_req_shd.g_old_rec.date_from
294: ,p_name_o
295: => per_req_shd.g_old_rec.name
296: ,p_comments_o
297: => per_req_shd.g_old_rec.comments

Line 295: => per_req_shd.g_old_rec.name

291: => per_req_shd.g_old_rec.person_id
292: ,p_date_from_o
293: => per_req_shd.g_old_rec.date_from
294: ,p_name_o
295: => per_req_shd.g_old_rec.name
296: ,p_comments_o
297: => per_req_shd.g_old_rec.comments
298: ,p_date_to_o
299: => per_req_shd.g_old_rec.date_to

Line 297: => per_req_shd.g_old_rec.comments

293: => per_req_shd.g_old_rec.date_from
294: ,p_name_o
295: => per_req_shd.g_old_rec.name
296: ,p_comments_o
297: => per_req_shd.g_old_rec.comments
298: ,p_date_to_o
299: => per_req_shd.g_old_rec.date_to
300: ,p_description_o
301: => per_req_shd.g_old_rec.description

Line 299: => per_req_shd.g_old_rec.date_to

295: => per_req_shd.g_old_rec.name
296: ,p_comments_o
297: => per_req_shd.g_old_rec.comments
298: ,p_date_to_o
299: => per_req_shd.g_old_rec.date_to
300: ,p_description_o
301: => per_req_shd.g_old_rec.description
302: ,p_request_id_o
303: => per_req_shd.g_old_rec.request_id

Line 301: => per_req_shd.g_old_rec.description

297: => per_req_shd.g_old_rec.comments
298: ,p_date_to_o
299: => per_req_shd.g_old_rec.date_to
300: ,p_description_o
301: => per_req_shd.g_old_rec.description
302: ,p_request_id_o
303: => per_req_shd.g_old_rec.request_id
304: ,p_program_application_id_o
305: => per_req_shd.g_old_rec.program_application_id

Line 303: => per_req_shd.g_old_rec.request_id

299: => per_req_shd.g_old_rec.date_to
300: ,p_description_o
301: => per_req_shd.g_old_rec.description
302: ,p_request_id_o
303: => per_req_shd.g_old_rec.request_id
304: ,p_program_application_id_o
305: => per_req_shd.g_old_rec.program_application_id
306: ,p_program_id_o
307: => per_req_shd.g_old_rec.program_id

Line 305: => per_req_shd.g_old_rec.program_application_id

301: => per_req_shd.g_old_rec.description
302: ,p_request_id_o
303: => per_req_shd.g_old_rec.request_id
304: ,p_program_application_id_o
305: => per_req_shd.g_old_rec.program_application_id
306: ,p_program_id_o
307: => per_req_shd.g_old_rec.program_id
308: ,p_program_update_date_o
309: => per_req_shd.g_old_rec.program_update_date

Line 307: => per_req_shd.g_old_rec.program_id

303: => per_req_shd.g_old_rec.request_id
304: ,p_program_application_id_o
305: => per_req_shd.g_old_rec.program_application_id
306: ,p_program_id_o
307: => per_req_shd.g_old_rec.program_id
308: ,p_program_update_date_o
309: => per_req_shd.g_old_rec.program_update_date
310: ,p_attribute_category_o
311: => per_req_shd.g_old_rec.attribute_category

Line 309: => per_req_shd.g_old_rec.program_update_date

305: => per_req_shd.g_old_rec.program_application_id
306: ,p_program_id_o
307: => per_req_shd.g_old_rec.program_id
308: ,p_program_update_date_o
309: => per_req_shd.g_old_rec.program_update_date
310: ,p_attribute_category_o
311: => per_req_shd.g_old_rec.attribute_category
312: ,p_attribute1_o
313: => per_req_shd.g_old_rec.attribute1

Line 311: => per_req_shd.g_old_rec.attribute_category

307: => per_req_shd.g_old_rec.program_id
308: ,p_program_update_date_o
309: => per_req_shd.g_old_rec.program_update_date
310: ,p_attribute_category_o
311: => per_req_shd.g_old_rec.attribute_category
312: ,p_attribute1_o
313: => per_req_shd.g_old_rec.attribute1
314: ,p_attribute2_o
315: => per_req_shd.g_old_rec.attribute2

Line 313: => per_req_shd.g_old_rec.attribute1

309: => per_req_shd.g_old_rec.program_update_date
310: ,p_attribute_category_o
311: => per_req_shd.g_old_rec.attribute_category
312: ,p_attribute1_o
313: => per_req_shd.g_old_rec.attribute1
314: ,p_attribute2_o
315: => per_req_shd.g_old_rec.attribute2
316: ,p_attribute3_o
317: => per_req_shd.g_old_rec.attribute3

Line 315: => per_req_shd.g_old_rec.attribute2

311: => per_req_shd.g_old_rec.attribute_category
312: ,p_attribute1_o
313: => per_req_shd.g_old_rec.attribute1
314: ,p_attribute2_o
315: => per_req_shd.g_old_rec.attribute2
316: ,p_attribute3_o
317: => per_req_shd.g_old_rec.attribute3
318: ,p_attribute4_o
319: => per_req_shd.g_old_rec.attribute4

Line 317: => per_req_shd.g_old_rec.attribute3

313: => per_req_shd.g_old_rec.attribute1
314: ,p_attribute2_o
315: => per_req_shd.g_old_rec.attribute2
316: ,p_attribute3_o
317: => per_req_shd.g_old_rec.attribute3
318: ,p_attribute4_o
319: => per_req_shd.g_old_rec.attribute4
320: ,p_attribute5_o
321: => per_req_shd.g_old_rec.attribute5

Line 319: => per_req_shd.g_old_rec.attribute4

315: => per_req_shd.g_old_rec.attribute2
316: ,p_attribute3_o
317: => per_req_shd.g_old_rec.attribute3
318: ,p_attribute4_o
319: => per_req_shd.g_old_rec.attribute4
320: ,p_attribute5_o
321: => per_req_shd.g_old_rec.attribute5
322: ,p_attribute6_o
323: => per_req_shd.g_old_rec.attribute6

Line 321: => per_req_shd.g_old_rec.attribute5

317: => per_req_shd.g_old_rec.attribute3
318: ,p_attribute4_o
319: => per_req_shd.g_old_rec.attribute4
320: ,p_attribute5_o
321: => per_req_shd.g_old_rec.attribute5
322: ,p_attribute6_o
323: => per_req_shd.g_old_rec.attribute6
324: ,p_attribute7_o
325: => per_req_shd.g_old_rec.attribute7

Line 323: => per_req_shd.g_old_rec.attribute6

319: => per_req_shd.g_old_rec.attribute4
320: ,p_attribute5_o
321: => per_req_shd.g_old_rec.attribute5
322: ,p_attribute6_o
323: => per_req_shd.g_old_rec.attribute6
324: ,p_attribute7_o
325: => per_req_shd.g_old_rec.attribute7
326: ,p_attribute8_o
327: => per_req_shd.g_old_rec.attribute8

Line 325: => per_req_shd.g_old_rec.attribute7

321: => per_req_shd.g_old_rec.attribute5
322: ,p_attribute6_o
323: => per_req_shd.g_old_rec.attribute6
324: ,p_attribute7_o
325: => per_req_shd.g_old_rec.attribute7
326: ,p_attribute8_o
327: => per_req_shd.g_old_rec.attribute8
328: ,p_attribute9_o
329: => per_req_shd.g_old_rec.attribute9

Line 327: => per_req_shd.g_old_rec.attribute8

323: => per_req_shd.g_old_rec.attribute6
324: ,p_attribute7_o
325: => per_req_shd.g_old_rec.attribute7
326: ,p_attribute8_o
327: => per_req_shd.g_old_rec.attribute8
328: ,p_attribute9_o
329: => per_req_shd.g_old_rec.attribute9
330: ,p_attribute10_o
331: => per_req_shd.g_old_rec.attribute10

Line 329: => per_req_shd.g_old_rec.attribute9

325: => per_req_shd.g_old_rec.attribute7
326: ,p_attribute8_o
327: => per_req_shd.g_old_rec.attribute8
328: ,p_attribute9_o
329: => per_req_shd.g_old_rec.attribute9
330: ,p_attribute10_o
331: => per_req_shd.g_old_rec.attribute10
332: ,p_attribute11_o
333: => per_req_shd.g_old_rec.attribute11

Line 331: => per_req_shd.g_old_rec.attribute10

327: => per_req_shd.g_old_rec.attribute8
328: ,p_attribute9_o
329: => per_req_shd.g_old_rec.attribute9
330: ,p_attribute10_o
331: => per_req_shd.g_old_rec.attribute10
332: ,p_attribute11_o
333: => per_req_shd.g_old_rec.attribute11
334: ,p_attribute12_o
335: => per_req_shd.g_old_rec.attribute12

Line 333: => per_req_shd.g_old_rec.attribute11

329: => per_req_shd.g_old_rec.attribute9
330: ,p_attribute10_o
331: => per_req_shd.g_old_rec.attribute10
332: ,p_attribute11_o
333: => per_req_shd.g_old_rec.attribute11
334: ,p_attribute12_o
335: => per_req_shd.g_old_rec.attribute12
336: ,p_attribute13_o
337: => per_req_shd.g_old_rec.attribute13

Line 335: => per_req_shd.g_old_rec.attribute12

331: => per_req_shd.g_old_rec.attribute10
332: ,p_attribute11_o
333: => per_req_shd.g_old_rec.attribute11
334: ,p_attribute12_o
335: => per_req_shd.g_old_rec.attribute12
336: ,p_attribute13_o
337: => per_req_shd.g_old_rec.attribute13
338: ,p_attribute14_o
339: => per_req_shd.g_old_rec.attribute14

Line 337: => per_req_shd.g_old_rec.attribute13

333: => per_req_shd.g_old_rec.attribute11
334: ,p_attribute12_o
335: => per_req_shd.g_old_rec.attribute12
336: ,p_attribute13_o
337: => per_req_shd.g_old_rec.attribute13
338: ,p_attribute14_o
339: => per_req_shd.g_old_rec.attribute14
340: ,p_attribute15_o
341: => per_req_shd.g_old_rec.attribute15

Line 339: => per_req_shd.g_old_rec.attribute14

335: => per_req_shd.g_old_rec.attribute12
336: ,p_attribute13_o
337: => per_req_shd.g_old_rec.attribute13
338: ,p_attribute14_o
339: => per_req_shd.g_old_rec.attribute14
340: ,p_attribute15_o
341: => per_req_shd.g_old_rec.attribute15
342: ,p_attribute16_o
343: => per_req_shd.g_old_rec.attribute16

Line 341: => per_req_shd.g_old_rec.attribute15

337: => per_req_shd.g_old_rec.attribute13
338: ,p_attribute14_o
339: => per_req_shd.g_old_rec.attribute14
340: ,p_attribute15_o
341: => per_req_shd.g_old_rec.attribute15
342: ,p_attribute16_o
343: => per_req_shd.g_old_rec.attribute16
344: ,p_attribute17_o
345: => per_req_shd.g_old_rec.attribute17

Line 343: => per_req_shd.g_old_rec.attribute16

339: => per_req_shd.g_old_rec.attribute14
340: ,p_attribute15_o
341: => per_req_shd.g_old_rec.attribute15
342: ,p_attribute16_o
343: => per_req_shd.g_old_rec.attribute16
344: ,p_attribute17_o
345: => per_req_shd.g_old_rec.attribute17
346: ,p_attribute18_o
347: => per_req_shd.g_old_rec.attribute18

Line 345: => per_req_shd.g_old_rec.attribute17

341: => per_req_shd.g_old_rec.attribute15
342: ,p_attribute16_o
343: => per_req_shd.g_old_rec.attribute16
344: ,p_attribute17_o
345: => per_req_shd.g_old_rec.attribute17
346: ,p_attribute18_o
347: => per_req_shd.g_old_rec.attribute18
348: ,p_attribute19_o
349: => per_req_shd.g_old_rec.attribute19

Line 347: => per_req_shd.g_old_rec.attribute18

343: => per_req_shd.g_old_rec.attribute16
344: ,p_attribute17_o
345: => per_req_shd.g_old_rec.attribute17
346: ,p_attribute18_o
347: => per_req_shd.g_old_rec.attribute18
348: ,p_attribute19_o
349: => per_req_shd.g_old_rec.attribute19
350: ,p_attribute20_o
351: => per_req_shd.g_old_rec.attribute20

Line 349: => per_req_shd.g_old_rec.attribute19

345: => per_req_shd.g_old_rec.attribute17
346: ,p_attribute18_o
347: => per_req_shd.g_old_rec.attribute18
348: ,p_attribute19_o
349: => per_req_shd.g_old_rec.attribute19
350: ,p_attribute20_o
351: => per_req_shd.g_old_rec.attribute20
352: ,p_object_version_number_o
353: => per_req_shd.g_old_rec.object_version_number

Line 351: => per_req_shd.g_old_rec.attribute20

347: => per_req_shd.g_old_rec.attribute18
348: ,p_attribute19_o
349: => per_req_shd.g_old_rec.attribute19
350: ,p_attribute20_o
351: => per_req_shd.g_old_rec.attribute20
352: ,p_object_version_number_o
353: => per_req_shd.g_old_rec.object_version_number
354: );
355: --

Line 353: => per_req_shd.g_old_rec.object_version_number

349: => per_req_shd.g_old_rec.attribute19
350: ,p_attribute20_o
351: => per_req_shd.g_old_rec.attribute20
352: ,p_object_version_number_o
353: => per_req_shd.g_old_rec.object_version_number
354: );
355: --
356: exception
357: --

Line 413: (p_rec in out nocopy per_req_shd.g_rec_type

409: --
410: -- {End Of Comments}
411: -- ----------------------------------------------------------------------------
412: Procedure convert_defs
413: (p_rec in out nocopy per_req_shd.g_rec_type
414: ) is
415: --
416: Begin
417: --

Line 425: per_req_shd.g_old_rec.business_group_id;

421: -- is being used then we must set to the 'current' argument value.
422: --
423: If (p_rec.business_group_id = hr_api.g_number) then
424: p_rec.business_group_id :=
425: per_req_shd.g_old_rec.business_group_id;
426: End If;
427: If (p_rec.person_id = hr_api.g_number) then
428: p_rec.person_id :=
429: per_req_shd.g_old_rec.person_id;

Line 429: per_req_shd.g_old_rec.person_id;

425: per_req_shd.g_old_rec.business_group_id;
426: End If;
427: If (p_rec.person_id = hr_api.g_number) then
428: p_rec.person_id :=
429: per_req_shd.g_old_rec.person_id;
430: End If;
431: If (p_rec.date_from = hr_api.g_date) then
432: p_rec.date_from :=
433: per_req_shd.g_old_rec.date_from;

Line 433: per_req_shd.g_old_rec.date_from;

429: per_req_shd.g_old_rec.person_id;
430: End If;
431: If (p_rec.date_from = hr_api.g_date) then
432: p_rec.date_from :=
433: per_req_shd.g_old_rec.date_from;
434: End If;
435: If (p_rec.name = hr_api.g_varchar2) then
436: p_rec.name :=
437: per_req_shd.g_old_rec.name;

Line 437: per_req_shd.g_old_rec.name;

433: per_req_shd.g_old_rec.date_from;
434: End If;
435: If (p_rec.name = hr_api.g_varchar2) then
436: p_rec.name :=
437: per_req_shd.g_old_rec.name;
438: End If;
439: If (p_rec.comments = hr_api.g_varchar2) then
440: p_rec.comments :=
441: per_req_shd.g_old_rec.comments;

Line 441: per_req_shd.g_old_rec.comments;

437: per_req_shd.g_old_rec.name;
438: End If;
439: If (p_rec.comments = hr_api.g_varchar2) then
440: p_rec.comments :=
441: per_req_shd.g_old_rec.comments;
442: End If;
443: If (p_rec.date_to = hr_api.g_date) then
444: p_rec.date_to :=
445: per_req_shd.g_old_rec.date_to;

Line 445: per_req_shd.g_old_rec.date_to;

441: per_req_shd.g_old_rec.comments;
442: End If;
443: If (p_rec.date_to = hr_api.g_date) then
444: p_rec.date_to :=
445: per_req_shd.g_old_rec.date_to;
446: End If;
447: If (p_rec.description = hr_api.g_varchar2) then
448: p_rec.description :=
449: per_req_shd.g_old_rec.description;

Line 449: per_req_shd.g_old_rec.description;

445: per_req_shd.g_old_rec.date_to;
446: End If;
447: If (p_rec.description = hr_api.g_varchar2) then
448: p_rec.description :=
449: per_req_shd.g_old_rec.description;
450: End If;
451: If (p_rec.request_id = hr_api.g_number) then
452: p_rec.request_id :=
453: per_req_shd.g_old_rec.request_id;

Line 453: per_req_shd.g_old_rec.request_id;

449: per_req_shd.g_old_rec.description;
450: End If;
451: If (p_rec.request_id = hr_api.g_number) then
452: p_rec.request_id :=
453: per_req_shd.g_old_rec.request_id;
454: End If;
455: If (p_rec.program_application_id = hr_api.g_number) then
456: p_rec.program_application_id :=
457: per_req_shd.g_old_rec.program_application_id;

Line 457: per_req_shd.g_old_rec.program_application_id;

453: per_req_shd.g_old_rec.request_id;
454: End If;
455: If (p_rec.program_application_id = hr_api.g_number) then
456: p_rec.program_application_id :=
457: per_req_shd.g_old_rec.program_application_id;
458: End If;
459: If (p_rec.program_id = hr_api.g_number) then
460: p_rec.program_id :=
461: per_req_shd.g_old_rec.program_id;

Line 461: per_req_shd.g_old_rec.program_id;

457: per_req_shd.g_old_rec.program_application_id;
458: End If;
459: If (p_rec.program_id = hr_api.g_number) then
460: p_rec.program_id :=
461: per_req_shd.g_old_rec.program_id;
462: End If;
463: If (p_rec.program_update_date = hr_api.g_date) then
464: p_rec.program_update_date :=
465: per_req_shd.g_old_rec.program_update_date;

Line 465: per_req_shd.g_old_rec.program_update_date;

461: per_req_shd.g_old_rec.program_id;
462: End If;
463: If (p_rec.program_update_date = hr_api.g_date) then
464: p_rec.program_update_date :=
465: per_req_shd.g_old_rec.program_update_date;
466: End If;
467: If (p_rec.attribute_category = hr_api.g_varchar2) then
468: p_rec.attribute_category :=
469: per_req_shd.g_old_rec.attribute_category;

Line 469: per_req_shd.g_old_rec.attribute_category;

465: per_req_shd.g_old_rec.program_update_date;
466: End If;
467: If (p_rec.attribute_category = hr_api.g_varchar2) then
468: p_rec.attribute_category :=
469: per_req_shd.g_old_rec.attribute_category;
470: End If;
471: If (p_rec.attribute1 = hr_api.g_varchar2) then
472: p_rec.attribute1 :=
473: per_req_shd.g_old_rec.attribute1;

Line 473: per_req_shd.g_old_rec.attribute1;

469: per_req_shd.g_old_rec.attribute_category;
470: End If;
471: If (p_rec.attribute1 = hr_api.g_varchar2) then
472: p_rec.attribute1 :=
473: per_req_shd.g_old_rec.attribute1;
474: End If;
475: If (p_rec.attribute2 = hr_api.g_varchar2) then
476: p_rec.attribute2 :=
477: per_req_shd.g_old_rec.attribute2;

Line 477: per_req_shd.g_old_rec.attribute2;

473: per_req_shd.g_old_rec.attribute1;
474: End If;
475: If (p_rec.attribute2 = hr_api.g_varchar2) then
476: p_rec.attribute2 :=
477: per_req_shd.g_old_rec.attribute2;
478: End If;
479: If (p_rec.attribute3 = hr_api.g_varchar2) then
480: p_rec.attribute3 :=
481: per_req_shd.g_old_rec.attribute3;

Line 481: per_req_shd.g_old_rec.attribute3;

477: per_req_shd.g_old_rec.attribute2;
478: End If;
479: If (p_rec.attribute3 = hr_api.g_varchar2) then
480: p_rec.attribute3 :=
481: per_req_shd.g_old_rec.attribute3;
482: End If;
483: If (p_rec.attribute4 = hr_api.g_varchar2) then
484: p_rec.attribute4 :=
485: per_req_shd.g_old_rec.attribute4;

Line 485: per_req_shd.g_old_rec.attribute4;

481: per_req_shd.g_old_rec.attribute3;
482: End If;
483: If (p_rec.attribute4 = hr_api.g_varchar2) then
484: p_rec.attribute4 :=
485: per_req_shd.g_old_rec.attribute4;
486: End If;
487: If (p_rec.attribute5 = hr_api.g_varchar2) then
488: p_rec.attribute5 :=
489: per_req_shd.g_old_rec.attribute5;

Line 489: per_req_shd.g_old_rec.attribute5;

485: per_req_shd.g_old_rec.attribute4;
486: End If;
487: If (p_rec.attribute5 = hr_api.g_varchar2) then
488: p_rec.attribute5 :=
489: per_req_shd.g_old_rec.attribute5;
490: End If;
491: If (p_rec.attribute6 = hr_api.g_varchar2) then
492: p_rec.attribute6 :=
493: per_req_shd.g_old_rec.attribute6;

Line 493: per_req_shd.g_old_rec.attribute6;

489: per_req_shd.g_old_rec.attribute5;
490: End If;
491: If (p_rec.attribute6 = hr_api.g_varchar2) then
492: p_rec.attribute6 :=
493: per_req_shd.g_old_rec.attribute6;
494: End If;
495: If (p_rec.attribute7 = hr_api.g_varchar2) then
496: p_rec.attribute7 :=
497: per_req_shd.g_old_rec.attribute7;

Line 497: per_req_shd.g_old_rec.attribute7;

493: per_req_shd.g_old_rec.attribute6;
494: End If;
495: If (p_rec.attribute7 = hr_api.g_varchar2) then
496: p_rec.attribute7 :=
497: per_req_shd.g_old_rec.attribute7;
498: End If;
499: If (p_rec.attribute8 = hr_api.g_varchar2) then
500: p_rec.attribute8 :=
501: per_req_shd.g_old_rec.attribute8;

Line 501: per_req_shd.g_old_rec.attribute8;

497: per_req_shd.g_old_rec.attribute7;
498: End If;
499: If (p_rec.attribute8 = hr_api.g_varchar2) then
500: p_rec.attribute8 :=
501: per_req_shd.g_old_rec.attribute8;
502: End If;
503: If (p_rec.attribute9 = hr_api.g_varchar2) then
504: p_rec.attribute9 :=
505: per_req_shd.g_old_rec.attribute9;

Line 505: per_req_shd.g_old_rec.attribute9;

501: per_req_shd.g_old_rec.attribute8;
502: End If;
503: If (p_rec.attribute9 = hr_api.g_varchar2) then
504: p_rec.attribute9 :=
505: per_req_shd.g_old_rec.attribute9;
506: End If;
507: If (p_rec.attribute10 = hr_api.g_varchar2) then
508: p_rec.attribute10 :=
509: per_req_shd.g_old_rec.attribute10;

Line 509: per_req_shd.g_old_rec.attribute10;

505: per_req_shd.g_old_rec.attribute9;
506: End If;
507: If (p_rec.attribute10 = hr_api.g_varchar2) then
508: p_rec.attribute10 :=
509: per_req_shd.g_old_rec.attribute10;
510: End If;
511: If (p_rec.attribute11 = hr_api.g_varchar2) then
512: p_rec.attribute11 :=
513: per_req_shd.g_old_rec.attribute11;

Line 513: per_req_shd.g_old_rec.attribute11;

509: per_req_shd.g_old_rec.attribute10;
510: End If;
511: If (p_rec.attribute11 = hr_api.g_varchar2) then
512: p_rec.attribute11 :=
513: per_req_shd.g_old_rec.attribute11;
514: End If;
515: If (p_rec.attribute12 = hr_api.g_varchar2) then
516: p_rec.attribute12 :=
517: per_req_shd.g_old_rec.attribute12;

Line 517: per_req_shd.g_old_rec.attribute12;

513: per_req_shd.g_old_rec.attribute11;
514: End If;
515: If (p_rec.attribute12 = hr_api.g_varchar2) then
516: p_rec.attribute12 :=
517: per_req_shd.g_old_rec.attribute12;
518: End If;
519: If (p_rec.attribute13 = hr_api.g_varchar2) then
520: p_rec.attribute13 :=
521: per_req_shd.g_old_rec.attribute13;

Line 521: per_req_shd.g_old_rec.attribute13;

517: per_req_shd.g_old_rec.attribute12;
518: End If;
519: If (p_rec.attribute13 = hr_api.g_varchar2) then
520: p_rec.attribute13 :=
521: per_req_shd.g_old_rec.attribute13;
522: End If;
523: If (p_rec.attribute14 = hr_api.g_varchar2) then
524: p_rec.attribute14 :=
525: per_req_shd.g_old_rec.attribute14;

Line 525: per_req_shd.g_old_rec.attribute14;

521: per_req_shd.g_old_rec.attribute13;
522: End If;
523: If (p_rec.attribute14 = hr_api.g_varchar2) then
524: p_rec.attribute14 :=
525: per_req_shd.g_old_rec.attribute14;
526: End If;
527: If (p_rec.attribute15 = hr_api.g_varchar2) then
528: p_rec.attribute15 :=
529: per_req_shd.g_old_rec.attribute15;

Line 529: per_req_shd.g_old_rec.attribute15;

525: per_req_shd.g_old_rec.attribute14;
526: End If;
527: If (p_rec.attribute15 = hr_api.g_varchar2) then
528: p_rec.attribute15 :=
529: per_req_shd.g_old_rec.attribute15;
530: End If;
531: If (p_rec.attribute16 = hr_api.g_varchar2) then
532: p_rec.attribute16 :=
533: per_req_shd.g_old_rec.attribute16;

Line 533: per_req_shd.g_old_rec.attribute16;

529: per_req_shd.g_old_rec.attribute15;
530: End If;
531: If (p_rec.attribute16 = hr_api.g_varchar2) then
532: p_rec.attribute16 :=
533: per_req_shd.g_old_rec.attribute16;
534: End If;
535: If (p_rec.attribute17 = hr_api.g_varchar2) then
536: p_rec.attribute17 :=
537: per_req_shd.g_old_rec.attribute17;

Line 537: per_req_shd.g_old_rec.attribute17;

533: per_req_shd.g_old_rec.attribute16;
534: End If;
535: If (p_rec.attribute17 = hr_api.g_varchar2) then
536: p_rec.attribute17 :=
537: per_req_shd.g_old_rec.attribute17;
538: End If;
539: If (p_rec.attribute18 = hr_api.g_varchar2) then
540: p_rec.attribute18 :=
541: per_req_shd.g_old_rec.attribute18;

Line 541: per_req_shd.g_old_rec.attribute18;

537: per_req_shd.g_old_rec.attribute17;
538: End If;
539: If (p_rec.attribute18 = hr_api.g_varchar2) then
540: p_rec.attribute18 :=
541: per_req_shd.g_old_rec.attribute18;
542: End If;
543: If (p_rec.attribute19 = hr_api.g_varchar2) then
544: p_rec.attribute19 :=
545: per_req_shd.g_old_rec.attribute19;

Line 545: per_req_shd.g_old_rec.attribute19;

541: per_req_shd.g_old_rec.attribute18;
542: End If;
543: If (p_rec.attribute19 = hr_api.g_varchar2) then
544: p_rec.attribute19 :=
545: per_req_shd.g_old_rec.attribute19;
546: End If;
547: If (p_rec.attribute20 = hr_api.g_varchar2) then
548: p_rec.attribute20 :=
549: per_req_shd.g_old_rec.attribute20;

Line 549: per_req_shd.g_old_rec.attribute20;

545: per_req_shd.g_old_rec.attribute19;
546: End If;
547: If (p_rec.attribute20 = hr_api.g_varchar2) then
548: p_rec.attribute20 :=
549: per_req_shd.g_old_rec.attribute20;
550: End If;
551: --
552: End convert_defs;
553: --

Line 558: (p_rec in out nocopy per_req_shd.g_rec_type

554: -- ----------------------------------------------------------------------------
555: -- |---------------------------------< upd >----------------------------------|
556: -- ----------------------------------------------------------------------------
557: Procedure upd
558: (p_rec in out nocopy per_req_shd.g_rec_type
559: ) is
560: --
561: l_proc varchar2(72) := g_package||'upd';
562: --

Line 568: per_req_shd.lck

564: hr_utility.set_location('Entering:'||l_proc, 5);
565: --
566: -- We must lock the row which we need to update.
567: --
568: per_req_shd.lck
569: (p_rec.requisition_id
570: ,p_rec.object_version_number
571: );
572: --

Line 639: l_rec per_req_shd.g_rec_type;

635: ,p_attribute19 in varchar2 default hr_api.g_varchar2
636: ,p_attribute20 in varchar2 default hr_api.g_varchar2
637: ) is
638: --
639: l_rec per_req_shd.g_rec_type;
640: l_proc varchar2(72) := g_package||'upd';
641: --
642: Begin
643: hr_utility.set_location('Entering:'||l_proc, 5);

Line 649: per_req_shd.convert_args

645: -- Call conversion function to turn arguments into the
646: -- l_rec structure.
647: --
648: l_rec :=
649: per_req_shd.convert_args
650: (p_requisition_id
651: ,p_business_group_id
652: ,p_person_id
653: ,p_date_from