DBA Data[Home] [Help]

APPS.HR_FMP_UPD dependencies on HR_FMP_SHD

Line 55: (p_rec in out nocopy hr_fmp_shd.g_rec_type

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

Line 117: hr_fmp_shd.constraint_error

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

Line 122: hr_fmp_shd.constraint_error

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

Line 127: hr_fmp_shd.constraint_error

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

Line 167: (p_rec in hr_fmp_shd.g_rec_type

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

Line 211: (p_rec in hr_fmp_shd.g_rec_type

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

Line 296: => hr_fmp_shd.g_old_rec.application_id

292: => p_rec.information29
293: ,p_information30
294: => p_rec.information30
295: ,p_application_id_o
296: => hr_fmp_shd.g_old_rec.application_id
297: ,p_form_id_o
298: => hr_fmp_shd.g_old_rec.form_id
299: ,p_object_version_number_o
300: => hr_tdg_shd.g_old_rec.object_version_number

Line 298: => hr_fmp_shd.g_old_rec.form_id

294: => p_rec.information30
295: ,p_application_id_o
296: => hr_fmp_shd.g_old_rec.application_id
297: ,p_form_id_o
298: => hr_fmp_shd.g_old_rec.form_id
299: ,p_object_version_number_o
300: => hr_tdg_shd.g_old_rec.object_version_number
301: ,p_form_template_id_o
302: => hr_fmp_shd.g_old_rec.form_template_id

Line 302: => hr_fmp_shd.g_old_rec.form_template_id

298: => hr_fmp_shd.g_old_rec.form_id
299: ,p_object_version_number_o
300: => hr_tdg_shd.g_old_rec.object_version_number
301: ,p_form_template_id_o
302: => hr_fmp_shd.g_old_rec.form_template_id
303: ,p_help_target_o
304: => hr_fmp_shd.g_old_rec.help_target
305: ,p_information_category_o
306: => hr_fmp_shd.g_old_rec.information_category

Line 304: => hr_fmp_shd.g_old_rec.help_target

300: => hr_tdg_shd.g_old_rec.object_version_number
301: ,p_form_template_id_o
302: => hr_fmp_shd.g_old_rec.form_template_id
303: ,p_help_target_o
304: => hr_fmp_shd.g_old_rec.help_target
305: ,p_information_category_o
306: => hr_fmp_shd.g_old_rec.information_category
307: ,p_information1_o
308: => hr_fmp_shd.g_old_rec.information1

Line 306: => hr_fmp_shd.g_old_rec.information_category

302: => hr_fmp_shd.g_old_rec.form_template_id
303: ,p_help_target_o
304: => hr_fmp_shd.g_old_rec.help_target
305: ,p_information_category_o
306: => hr_fmp_shd.g_old_rec.information_category
307: ,p_information1_o
308: => hr_fmp_shd.g_old_rec.information1
309: ,p_information2_o
310: => hr_fmp_shd.g_old_rec.information2

Line 308: => hr_fmp_shd.g_old_rec.information1

304: => hr_fmp_shd.g_old_rec.help_target
305: ,p_information_category_o
306: => hr_fmp_shd.g_old_rec.information_category
307: ,p_information1_o
308: => hr_fmp_shd.g_old_rec.information1
309: ,p_information2_o
310: => hr_fmp_shd.g_old_rec.information2
311: ,p_information3_o
312: => hr_fmp_shd.g_old_rec.information3

Line 310: => hr_fmp_shd.g_old_rec.information2

306: => hr_fmp_shd.g_old_rec.information_category
307: ,p_information1_o
308: => hr_fmp_shd.g_old_rec.information1
309: ,p_information2_o
310: => hr_fmp_shd.g_old_rec.information2
311: ,p_information3_o
312: => hr_fmp_shd.g_old_rec.information3
313: ,p_information4_o
314: => hr_fmp_shd.g_old_rec.information4

Line 312: => hr_fmp_shd.g_old_rec.information3

308: => hr_fmp_shd.g_old_rec.information1
309: ,p_information2_o
310: => hr_fmp_shd.g_old_rec.information2
311: ,p_information3_o
312: => hr_fmp_shd.g_old_rec.information3
313: ,p_information4_o
314: => hr_fmp_shd.g_old_rec.information4
315: ,p_information5_o
316: => hr_fmp_shd.g_old_rec.information5

Line 314: => hr_fmp_shd.g_old_rec.information4

310: => hr_fmp_shd.g_old_rec.information2
311: ,p_information3_o
312: => hr_fmp_shd.g_old_rec.information3
313: ,p_information4_o
314: => hr_fmp_shd.g_old_rec.information4
315: ,p_information5_o
316: => hr_fmp_shd.g_old_rec.information5
317: ,p_information6_o
318: => hr_fmp_shd.g_old_rec.information6

Line 316: => hr_fmp_shd.g_old_rec.information5

312: => hr_fmp_shd.g_old_rec.information3
313: ,p_information4_o
314: => hr_fmp_shd.g_old_rec.information4
315: ,p_information5_o
316: => hr_fmp_shd.g_old_rec.information5
317: ,p_information6_o
318: => hr_fmp_shd.g_old_rec.information6
319: ,p_information7_o
320: => hr_fmp_shd.g_old_rec.information7

Line 318: => hr_fmp_shd.g_old_rec.information6

314: => hr_fmp_shd.g_old_rec.information4
315: ,p_information5_o
316: => hr_fmp_shd.g_old_rec.information5
317: ,p_information6_o
318: => hr_fmp_shd.g_old_rec.information6
319: ,p_information7_o
320: => hr_fmp_shd.g_old_rec.information7
321: ,p_information8_o
322: => hr_fmp_shd.g_old_rec.information8

Line 320: => hr_fmp_shd.g_old_rec.information7

316: => hr_fmp_shd.g_old_rec.information5
317: ,p_information6_o
318: => hr_fmp_shd.g_old_rec.information6
319: ,p_information7_o
320: => hr_fmp_shd.g_old_rec.information7
321: ,p_information8_o
322: => hr_fmp_shd.g_old_rec.information8
323: ,p_information9_o
324: => hr_fmp_shd.g_old_rec.information9

Line 322: => hr_fmp_shd.g_old_rec.information8

318: => hr_fmp_shd.g_old_rec.information6
319: ,p_information7_o
320: => hr_fmp_shd.g_old_rec.information7
321: ,p_information8_o
322: => hr_fmp_shd.g_old_rec.information8
323: ,p_information9_o
324: => hr_fmp_shd.g_old_rec.information9
325: ,p_information10_o
326: => hr_fmp_shd.g_old_rec.information10

Line 324: => hr_fmp_shd.g_old_rec.information9

320: => hr_fmp_shd.g_old_rec.information7
321: ,p_information8_o
322: => hr_fmp_shd.g_old_rec.information8
323: ,p_information9_o
324: => hr_fmp_shd.g_old_rec.information9
325: ,p_information10_o
326: => hr_fmp_shd.g_old_rec.information10
327: ,p_information11_o
328: => hr_fmp_shd.g_old_rec.information11

Line 326: => hr_fmp_shd.g_old_rec.information10

322: => hr_fmp_shd.g_old_rec.information8
323: ,p_information9_o
324: => hr_fmp_shd.g_old_rec.information9
325: ,p_information10_o
326: => hr_fmp_shd.g_old_rec.information10
327: ,p_information11_o
328: => hr_fmp_shd.g_old_rec.information11
329: ,p_information12_o
330: => hr_fmp_shd.g_old_rec.information12

Line 328: => hr_fmp_shd.g_old_rec.information11

324: => hr_fmp_shd.g_old_rec.information9
325: ,p_information10_o
326: => hr_fmp_shd.g_old_rec.information10
327: ,p_information11_o
328: => hr_fmp_shd.g_old_rec.information11
329: ,p_information12_o
330: => hr_fmp_shd.g_old_rec.information12
331: ,p_information13_o
332: => hr_fmp_shd.g_old_rec.information13

Line 330: => hr_fmp_shd.g_old_rec.information12

326: => hr_fmp_shd.g_old_rec.information10
327: ,p_information11_o
328: => hr_fmp_shd.g_old_rec.information11
329: ,p_information12_o
330: => hr_fmp_shd.g_old_rec.information12
331: ,p_information13_o
332: => hr_fmp_shd.g_old_rec.information13
333: ,p_information14_o
334: => hr_fmp_shd.g_old_rec.information14

Line 332: => hr_fmp_shd.g_old_rec.information13

328: => hr_fmp_shd.g_old_rec.information11
329: ,p_information12_o
330: => hr_fmp_shd.g_old_rec.information12
331: ,p_information13_o
332: => hr_fmp_shd.g_old_rec.information13
333: ,p_information14_o
334: => hr_fmp_shd.g_old_rec.information14
335: ,p_information15_o
336: => hr_fmp_shd.g_old_rec.information15

Line 334: => hr_fmp_shd.g_old_rec.information14

330: => hr_fmp_shd.g_old_rec.information12
331: ,p_information13_o
332: => hr_fmp_shd.g_old_rec.information13
333: ,p_information14_o
334: => hr_fmp_shd.g_old_rec.information14
335: ,p_information15_o
336: => hr_fmp_shd.g_old_rec.information15
337: ,p_information16_o
338: => hr_fmp_shd.g_old_rec.information16

Line 336: => hr_fmp_shd.g_old_rec.information15

332: => hr_fmp_shd.g_old_rec.information13
333: ,p_information14_o
334: => hr_fmp_shd.g_old_rec.information14
335: ,p_information15_o
336: => hr_fmp_shd.g_old_rec.information15
337: ,p_information16_o
338: => hr_fmp_shd.g_old_rec.information16
339: ,p_information17_o
340: => hr_fmp_shd.g_old_rec.information17

Line 338: => hr_fmp_shd.g_old_rec.information16

334: => hr_fmp_shd.g_old_rec.information14
335: ,p_information15_o
336: => hr_fmp_shd.g_old_rec.information15
337: ,p_information16_o
338: => hr_fmp_shd.g_old_rec.information16
339: ,p_information17_o
340: => hr_fmp_shd.g_old_rec.information17
341: ,p_information18_o
342: => hr_fmp_shd.g_old_rec.information18

Line 340: => hr_fmp_shd.g_old_rec.information17

336: => hr_fmp_shd.g_old_rec.information15
337: ,p_information16_o
338: => hr_fmp_shd.g_old_rec.information16
339: ,p_information17_o
340: => hr_fmp_shd.g_old_rec.information17
341: ,p_information18_o
342: => hr_fmp_shd.g_old_rec.information18
343: ,p_information19_o
344: => hr_fmp_shd.g_old_rec.information19

Line 342: => hr_fmp_shd.g_old_rec.information18

338: => hr_fmp_shd.g_old_rec.information16
339: ,p_information17_o
340: => hr_fmp_shd.g_old_rec.information17
341: ,p_information18_o
342: => hr_fmp_shd.g_old_rec.information18
343: ,p_information19_o
344: => hr_fmp_shd.g_old_rec.information19
345: ,p_information20_o
346: => hr_fmp_shd.g_old_rec.information20

Line 344: => hr_fmp_shd.g_old_rec.information19

340: => hr_fmp_shd.g_old_rec.information17
341: ,p_information18_o
342: => hr_fmp_shd.g_old_rec.information18
343: ,p_information19_o
344: => hr_fmp_shd.g_old_rec.information19
345: ,p_information20_o
346: => hr_fmp_shd.g_old_rec.information20
347: ,p_information21_o
348: => hr_fmp_shd.g_old_rec.information21

Line 346: => hr_fmp_shd.g_old_rec.information20

342: => hr_fmp_shd.g_old_rec.information18
343: ,p_information19_o
344: => hr_fmp_shd.g_old_rec.information19
345: ,p_information20_o
346: => hr_fmp_shd.g_old_rec.information20
347: ,p_information21_o
348: => hr_fmp_shd.g_old_rec.information21
349: ,p_information22_o
350: => hr_fmp_shd.g_old_rec.information22

Line 348: => hr_fmp_shd.g_old_rec.information21

344: => hr_fmp_shd.g_old_rec.information19
345: ,p_information20_o
346: => hr_fmp_shd.g_old_rec.information20
347: ,p_information21_o
348: => hr_fmp_shd.g_old_rec.information21
349: ,p_information22_o
350: => hr_fmp_shd.g_old_rec.information22
351: ,p_information23_o
352: => hr_fmp_shd.g_old_rec.information23

Line 350: => hr_fmp_shd.g_old_rec.information22

346: => hr_fmp_shd.g_old_rec.information20
347: ,p_information21_o
348: => hr_fmp_shd.g_old_rec.information21
349: ,p_information22_o
350: => hr_fmp_shd.g_old_rec.information22
351: ,p_information23_o
352: => hr_fmp_shd.g_old_rec.information23
353: ,p_information24_o
354: => hr_fmp_shd.g_old_rec.information24

Line 352: => hr_fmp_shd.g_old_rec.information23

348: => hr_fmp_shd.g_old_rec.information21
349: ,p_information22_o
350: => hr_fmp_shd.g_old_rec.information22
351: ,p_information23_o
352: => hr_fmp_shd.g_old_rec.information23
353: ,p_information24_o
354: => hr_fmp_shd.g_old_rec.information24
355: ,p_information25_o
356: => hr_fmp_shd.g_old_rec.information25

Line 354: => hr_fmp_shd.g_old_rec.information24

350: => hr_fmp_shd.g_old_rec.information22
351: ,p_information23_o
352: => hr_fmp_shd.g_old_rec.information23
353: ,p_information24_o
354: => hr_fmp_shd.g_old_rec.information24
355: ,p_information25_o
356: => hr_fmp_shd.g_old_rec.information25
357: ,p_information26_o
358: => hr_fmp_shd.g_old_rec.information26

Line 356: => hr_fmp_shd.g_old_rec.information25

352: => hr_fmp_shd.g_old_rec.information23
353: ,p_information24_o
354: => hr_fmp_shd.g_old_rec.information24
355: ,p_information25_o
356: => hr_fmp_shd.g_old_rec.information25
357: ,p_information26_o
358: => hr_fmp_shd.g_old_rec.information26
359: ,p_information27_o
360: => hr_fmp_shd.g_old_rec.information27

Line 358: => hr_fmp_shd.g_old_rec.information26

354: => hr_fmp_shd.g_old_rec.information24
355: ,p_information25_o
356: => hr_fmp_shd.g_old_rec.information25
357: ,p_information26_o
358: => hr_fmp_shd.g_old_rec.information26
359: ,p_information27_o
360: => hr_fmp_shd.g_old_rec.information27
361: ,p_information28_o
362: => hr_fmp_shd.g_old_rec.information28

Line 360: => hr_fmp_shd.g_old_rec.information27

356: => hr_fmp_shd.g_old_rec.information25
357: ,p_information26_o
358: => hr_fmp_shd.g_old_rec.information26
359: ,p_information27_o
360: => hr_fmp_shd.g_old_rec.information27
361: ,p_information28_o
362: => hr_fmp_shd.g_old_rec.information28
363: ,p_information29_o
364: => hr_fmp_shd.g_old_rec.information29

Line 362: => hr_fmp_shd.g_old_rec.information28

358: => hr_fmp_shd.g_old_rec.information26
359: ,p_information27_o
360: => hr_fmp_shd.g_old_rec.information27
361: ,p_information28_o
362: => hr_fmp_shd.g_old_rec.information28
363: ,p_information29_o
364: => hr_fmp_shd.g_old_rec.information29
365: ,p_information30_o
366: => hr_fmp_shd.g_old_rec.information30

Line 364: => hr_fmp_shd.g_old_rec.information29

360: => hr_fmp_shd.g_old_rec.information27
361: ,p_information28_o
362: => hr_fmp_shd.g_old_rec.information28
363: ,p_information29_o
364: => hr_fmp_shd.g_old_rec.information29
365: ,p_information30_o
366: => hr_fmp_shd.g_old_rec.information30
367: );
368: --

Line 366: => hr_fmp_shd.g_old_rec.information30

362: => hr_fmp_shd.g_old_rec.information28
363: ,p_information29_o
364: => hr_fmp_shd.g_old_rec.information29
365: ,p_information30_o
366: => hr_fmp_shd.g_old_rec.information30
367: );
368: --
369: exception
370: --

Line 426: (p_rec in out nocopy hr_fmp_shd.g_rec_type

422: --
423: -- {End Of Comments}
424: -- ----------------------------------------------------------------------------
425: Procedure convert_defs
426: (p_rec in out nocopy hr_fmp_shd.g_rec_type
427: ) is
428: --
429: Begin
430: --

Line 438: hr_fmp_shd.g_old_rec.application_id;

434: -- is being used then we must set to the 'current' argument value.
435: --
436: If (p_rec.application_id = hr_api.g_number) then
437: p_rec.application_id :=
438: hr_fmp_shd.g_old_rec.application_id;
439: End If;
440: If (p_rec.form_id = hr_api.g_number) then
441: p_rec.form_id :=
442: hr_fmp_shd.g_old_rec.form_id;

Line 442: hr_fmp_shd.g_old_rec.form_id;

438: hr_fmp_shd.g_old_rec.application_id;
439: End If;
440: If (p_rec.form_id = hr_api.g_number) then
441: p_rec.form_id :=
442: hr_fmp_shd.g_old_rec.form_id;
443: End If;
444: If (p_rec.form_template_id = hr_api.g_number) then
445: p_rec.form_template_id :=
446: hr_fmp_shd.g_old_rec.form_template_id;

Line 446: hr_fmp_shd.g_old_rec.form_template_id;

442: hr_fmp_shd.g_old_rec.form_id;
443: End If;
444: If (p_rec.form_template_id = hr_api.g_number) then
445: p_rec.form_template_id :=
446: hr_fmp_shd.g_old_rec.form_template_id;
447: End If;
448: If (p_rec.help_target = hr_api.g_varchar2) then
449: p_rec.help_target :=
450: hr_fmp_shd.g_old_rec.help_target;

Line 450: hr_fmp_shd.g_old_rec.help_target;

446: hr_fmp_shd.g_old_rec.form_template_id;
447: End If;
448: If (p_rec.help_target = hr_api.g_varchar2) then
449: p_rec.help_target :=
450: hr_fmp_shd.g_old_rec.help_target;
451: End If;
452: If (p_rec.information_category = hr_api.g_varchar2) then
453: p_rec.information_category :=
454: hr_fmp_shd.g_old_rec.information_category;

Line 454: hr_fmp_shd.g_old_rec.information_category;

450: hr_fmp_shd.g_old_rec.help_target;
451: End If;
452: If (p_rec.information_category = hr_api.g_varchar2) then
453: p_rec.information_category :=
454: hr_fmp_shd.g_old_rec.information_category;
455: End If;
456: If (p_rec.information1 = hr_api.g_varchar2) then
457: p_rec.information1 :=
458: hr_fmp_shd.g_old_rec.information1;

Line 458: hr_fmp_shd.g_old_rec.information1;

454: hr_fmp_shd.g_old_rec.information_category;
455: End If;
456: If (p_rec.information1 = hr_api.g_varchar2) then
457: p_rec.information1 :=
458: hr_fmp_shd.g_old_rec.information1;
459: End If;
460: If (p_rec.information2 = hr_api.g_varchar2) then
461: p_rec.information2 :=
462: hr_fmp_shd.g_old_rec.information2;

Line 462: hr_fmp_shd.g_old_rec.information2;

458: hr_fmp_shd.g_old_rec.information1;
459: End If;
460: If (p_rec.information2 = hr_api.g_varchar2) then
461: p_rec.information2 :=
462: hr_fmp_shd.g_old_rec.information2;
463: End If;
464: If (p_rec.information3 = hr_api.g_varchar2) then
465: p_rec.information3 :=
466: hr_fmp_shd.g_old_rec.information3;

Line 466: hr_fmp_shd.g_old_rec.information3;

462: hr_fmp_shd.g_old_rec.information2;
463: End If;
464: If (p_rec.information3 = hr_api.g_varchar2) then
465: p_rec.information3 :=
466: hr_fmp_shd.g_old_rec.information3;
467: End If;
468: If (p_rec.information4 = hr_api.g_varchar2) then
469: p_rec.information4 :=
470: hr_fmp_shd.g_old_rec.information4;

Line 470: hr_fmp_shd.g_old_rec.information4;

466: hr_fmp_shd.g_old_rec.information3;
467: End If;
468: If (p_rec.information4 = hr_api.g_varchar2) then
469: p_rec.information4 :=
470: hr_fmp_shd.g_old_rec.information4;
471: End If;
472: If (p_rec.information5 = hr_api.g_varchar2) then
473: p_rec.information5 :=
474: hr_fmp_shd.g_old_rec.information5;

Line 474: hr_fmp_shd.g_old_rec.information5;

470: hr_fmp_shd.g_old_rec.information4;
471: End If;
472: If (p_rec.information5 = hr_api.g_varchar2) then
473: p_rec.information5 :=
474: hr_fmp_shd.g_old_rec.information5;
475: End If;
476: If (p_rec.information6 = hr_api.g_varchar2) then
477: p_rec.information6 :=
478: hr_fmp_shd.g_old_rec.information6;

Line 478: hr_fmp_shd.g_old_rec.information6;

474: hr_fmp_shd.g_old_rec.information5;
475: End If;
476: If (p_rec.information6 = hr_api.g_varchar2) then
477: p_rec.information6 :=
478: hr_fmp_shd.g_old_rec.information6;
479: End If;
480: If (p_rec.information7 = hr_api.g_varchar2) then
481: p_rec.information7 :=
482: hr_fmp_shd.g_old_rec.information7;

Line 482: hr_fmp_shd.g_old_rec.information7;

478: hr_fmp_shd.g_old_rec.information6;
479: End If;
480: If (p_rec.information7 = hr_api.g_varchar2) then
481: p_rec.information7 :=
482: hr_fmp_shd.g_old_rec.information7;
483: End If;
484: If (p_rec.information8 = hr_api.g_varchar2) then
485: p_rec.information8 :=
486: hr_fmp_shd.g_old_rec.information8;

Line 486: hr_fmp_shd.g_old_rec.information8;

482: hr_fmp_shd.g_old_rec.information7;
483: End If;
484: If (p_rec.information8 = hr_api.g_varchar2) then
485: p_rec.information8 :=
486: hr_fmp_shd.g_old_rec.information8;
487: End If;
488: If (p_rec.information9 = hr_api.g_varchar2) then
489: p_rec.information9 :=
490: hr_fmp_shd.g_old_rec.information9;

Line 490: hr_fmp_shd.g_old_rec.information9;

486: hr_fmp_shd.g_old_rec.information8;
487: End If;
488: If (p_rec.information9 = hr_api.g_varchar2) then
489: p_rec.information9 :=
490: hr_fmp_shd.g_old_rec.information9;
491: End If;
492: If (p_rec.information10 = hr_api.g_varchar2) then
493: p_rec.information10 :=
494: hr_fmp_shd.g_old_rec.information10;

Line 494: hr_fmp_shd.g_old_rec.information10;

490: hr_fmp_shd.g_old_rec.information9;
491: End If;
492: If (p_rec.information10 = hr_api.g_varchar2) then
493: p_rec.information10 :=
494: hr_fmp_shd.g_old_rec.information10;
495: End If;
496: If (p_rec.information11 = hr_api.g_varchar2) then
497: p_rec.information11 :=
498: hr_fmp_shd.g_old_rec.information11;

Line 498: hr_fmp_shd.g_old_rec.information11;

494: hr_fmp_shd.g_old_rec.information10;
495: End If;
496: If (p_rec.information11 = hr_api.g_varchar2) then
497: p_rec.information11 :=
498: hr_fmp_shd.g_old_rec.information11;
499: End If;
500: If (p_rec.information12 = hr_api.g_varchar2) then
501: p_rec.information12 :=
502: hr_fmp_shd.g_old_rec.information12;

Line 502: hr_fmp_shd.g_old_rec.information12;

498: hr_fmp_shd.g_old_rec.information11;
499: End If;
500: If (p_rec.information12 = hr_api.g_varchar2) then
501: p_rec.information12 :=
502: hr_fmp_shd.g_old_rec.information12;
503: End If;
504: If (p_rec.information13 = hr_api.g_varchar2) then
505: p_rec.information13 :=
506: hr_fmp_shd.g_old_rec.information13;

Line 506: hr_fmp_shd.g_old_rec.information13;

502: hr_fmp_shd.g_old_rec.information12;
503: End If;
504: If (p_rec.information13 = hr_api.g_varchar2) then
505: p_rec.information13 :=
506: hr_fmp_shd.g_old_rec.information13;
507: End If;
508: If (p_rec.information14 = hr_api.g_varchar2) then
509: p_rec.information14 :=
510: hr_fmp_shd.g_old_rec.information14;

Line 510: hr_fmp_shd.g_old_rec.information14;

506: hr_fmp_shd.g_old_rec.information13;
507: End If;
508: If (p_rec.information14 = hr_api.g_varchar2) then
509: p_rec.information14 :=
510: hr_fmp_shd.g_old_rec.information14;
511: End If;
512: If (p_rec.information15 = hr_api.g_varchar2) then
513: p_rec.information15 :=
514: hr_fmp_shd.g_old_rec.information15;

Line 514: hr_fmp_shd.g_old_rec.information15;

510: hr_fmp_shd.g_old_rec.information14;
511: End If;
512: If (p_rec.information15 = hr_api.g_varchar2) then
513: p_rec.information15 :=
514: hr_fmp_shd.g_old_rec.information15;
515: End If;
516: If (p_rec.information16 = hr_api.g_varchar2) then
517: p_rec.information16 :=
518: hr_fmp_shd.g_old_rec.information16;

Line 518: hr_fmp_shd.g_old_rec.information16;

514: hr_fmp_shd.g_old_rec.information15;
515: End If;
516: If (p_rec.information16 = hr_api.g_varchar2) then
517: p_rec.information16 :=
518: hr_fmp_shd.g_old_rec.information16;
519: End If;
520: If (p_rec.information17 = hr_api.g_varchar2) then
521: p_rec.information17 :=
522: hr_fmp_shd.g_old_rec.information17;

Line 522: hr_fmp_shd.g_old_rec.information17;

518: hr_fmp_shd.g_old_rec.information16;
519: End If;
520: If (p_rec.information17 = hr_api.g_varchar2) then
521: p_rec.information17 :=
522: hr_fmp_shd.g_old_rec.information17;
523: End If;
524: If (p_rec.information18 = hr_api.g_varchar2) then
525: p_rec.information18 :=
526: hr_fmp_shd.g_old_rec.information18;

Line 526: hr_fmp_shd.g_old_rec.information18;

522: hr_fmp_shd.g_old_rec.information17;
523: End If;
524: If (p_rec.information18 = hr_api.g_varchar2) then
525: p_rec.information18 :=
526: hr_fmp_shd.g_old_rec.information18;
527: End If;
528: If (p_rec.information19 = hr_api.g_varchar2) then
529: p_rec.information19 :=
530: hr_fmp_shd.g_old_rec.information19;

Line 530: hr_fmp_shd.g_old_rec.information19;

526: hr_fmp_shd.g_old_rec.information18;
527: End If;
528: If (p_rec.information19 = hr_api.g_varchar2) then
529: p_rec.information19 :=
530: hr_fmp_shd.g_old_rec.information19;
531: End If;
532: If (p_rec.information20 = hr_api.g_varchar2) then
533: p_rec.information20 :=
534: hr_fmp_shd.g_old_rec.information20;

Line 534: hr_fmp_shd.g_old_rec.information20;

530: hr_fmp_shd.g_old_rec.information19;
531: End If;
532: If (p_rec.information20 = hr_api.g_varchar2) then
533: p_rec.information20 :=
534: hr_fmp_shd.g_old_rec.information20;
535: End If;
536: If (p_rec.information21 = hr_api.g_varchar2) then
537: p_rec.information21 :=
538: hr_fmp_shd.g_old_rec.information21;

Line 538: hr_fmp_shd.g_old_rec.information21;

534: hr_fmp_shd.g_old_rec.information20;
535: End If;
536: If (p_rec.information21 = hr_api.g_varchar2) then
537: p_rec.information21 :=
538: hr_fmp_shd.g_old_rec.information21;
539: End If;
540: If (p_rec.information22 = hr_api.g_varchar2) then
541: p_rec.information22 :=
542: hr_fmp_shd.g_old_rec.information22;

Line 542: hr_fmp_shd.g_old_rec.information22;

538: hr_fmp_shd.g_old_rec.information21;
539: End If;
540: If (p_rec.information22 = hr_api.g_varchar2) then
541: p_rec.information22 :=
542: hr_fmp_shd.g_old_rec.information22;
543: End If;
544: If (p_rec.information23 = hr_api.g_varchar2) then
545: p_rec.information23 :=
546: hr_fmp_shd.g_old_rec.information23;

Line 546: hr_fmp_shd.g_old_rec.information23;

542: hr_fmp_shd.g_old_rec.information22;
543: End If;
544: If (p_rec.information23 = hr_api.g_varchar2) then
545: p_rec.information23 :=
546: hr_fmp_shd.g_old_rec.information23;
547: End If;
548: If (p_rec.information24 = hr_api.g_varchar2) then
549: p_rec.information24 :=
550: hr_fmp_shd.g_old_rec.information24;

Line 550: hr_fmp_shd.g_old_rec.information24;

546: hr_fmp_shd.g_old_rec.information23;
547: End If;
548: If (p_rec.information24 = hr_api.g_varchar2) then
549: p_rec.information24 :=
550: hr_fmp_shd.g_old_rec.information24;
551: End If;
552: If (p_rec.information25 = hr_api.g_varchar2) then
553: p_rec.information25 :=
554: hr_fmp_shd.g_old_rec.information25;

Line 554: hr_fmp_shd.g_old_rec.information25;

550: hr_fmp_shd.g_old_rec.information24;
551: End If;
552: If (p_rec.information25 = hr_api.g_varchar2) then
553: p_rec.information25 :=
554: hr_fmp_shd.g_old_rec.information25;
555: End If;
556: If (p_rec.information26 = hr_api.g_varchar2) then
557: p_rec.information26 :=
558: hr_fmp_shd.g_old_rec.information26;

Line 558: hr_fmp_shd.g_old_rec.information26;

554: hr_fmp_shd.g_old_rec.information25;
555: End If;
556: If (p_rec.information26 = hr_api.g_varchar2) then
557: p_rec.information26 :=
558: hr_fmp_shd.g_old_rec.information26;
559: End If;
560: If (p_rec.information27 = hr_api.g_varchar2) then
561: p_rec.information27 :=
562: hr_fmp_shd.g_old_rec.information27;

Line 562: hr_fmp_shd.g_old_rec.information27;

558: hr_fmp_shd.g_old_rec.information26;
559: End If;
560: If (p_rec.information27 = hr_api.g_varchar2) then
561: p_rec.information27 :=
562: hr_fmp_shd.g_old_rec.information27;
563: End If;
564: If (p_rec.information28 = hr_api.g_varchar2) then
565: p_rec.information28 :=
566: hr_fmp_shd.g_old_rec.information28;

Line 566: hr_fmp_shd.g_old_rec.information28;

562: hr_fmp_shd.g_old_rec.information27;
563: End If;
564: If (p_rec.information28 = hr_api.g_varchar2) then
565: p_rec.information28 :=
566: hr_fmp_shd.g_old_rec.information28;
567: End If;
568: If (p_rec.information29 = hr_api.g_varchar2) then
569: p_rec.information29 :=
570: hr_fmp_shd.g_old_rec.information29;

Line 570: hr_fmp_shd.g_old_rec.information29;

566: hr_fmp_shd.g_old_rec.information28;
567: End If;
568: If (p_rec.information29 = hr_api.g_varchar2) then
569: p_rec.information29 :=
570: hr_fmp_shd.g_old_rec.information29;
571: End If;
572: If (p_rec.information30 = hr_api.g_varchar2) then
573: p_rec.information30 :=
574: hr_fmp_shd.g_old_rec.information30;

Line 574: hr_fmp_shd.g_old_rec.information30;

570: hr_fmp_shd.g_old_rec.information29;
571: End If;
572: If (p_rec.information30 = hr_api.g_varchar2) then
573: p_rec.information30 :=
574: hr_fmp_shd.g_old_rec.information30;
575: End If;
576: --
577: End convert_defs;
578: --

Line 583: (p_rec in out nocopy hr_fmp_shd.g_rec_type

579: -- ----------------------------------------------------------------------------
580: -- |---------------------------------< upd >----------------------------------|
581: -- ----------------------------------------------------------------------------
582: Procedure upd
583: (p_rec in out nocopy hr_fmp_shd.g_rec_type
584: ) is
585: --
586: l_proc varchar2(72) := g_package||'upd';
587: --

Line 593: hr_fmp_shd.lck

589: hr_utility.set_location('Entering:'||l_proc, 5);
590: --
591: -- We must lock the row which we need to update.
592: --
593: hr_fmp_shd.lck
594: (p_rec.form_property_id
595: ,p_rec.object_version_number
596: );
597: --

Line 667: l_rec hr_fmp_shd.g_rec_type;

663: ,p_information29 in varchar2 default hr_api.g_varchar2
664: ,p_information30 in varchar2 default hr_api.g_varchar2
665: ) is
666: --
667: l_rec hr_fmp_shd.g_rec_type;
668: l_proc varchar2(72) := g_package||'upd';
669: --
670: Begin
671: hr_utility.set_location('Entering:'||l_proc, 5);

Line 677: hr_fmp_shd.convert_args

673: -- Call conversion function to turn arguments into the
674: -- l_rec structure.
675: --
676: l_rec :=
677: hr_fmp_shd.convert_args
678: (p_form_property_id
679: ,p_object_version_number
680: ,p_application_id
681: ,p_form_id