DBA Data[Home] [Help]

APPS.HR_TPP_UPD dependencies on HR_TPP_SHD

Line 55: (p_rec in out nocopy hr_tpp_shd.g_rec_type

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

Line 117: hr_tpp_shd.constraint_error

113: Exception
114: When hr_api.check_integrity_violated Then
115: -- A check constraint has been violated
116: --
117: hr_tpp_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_tpp_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_tpp_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_tpp_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_tpp_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_tpp_shd.g_rec_type

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

Line 212: ,p_rec in hr_tpp_shd.g_rec_type

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

Line 298: => hr_tpp_shd.g_old_rec.form_tab_page_id

294: => p_rec.information29
295: ,p_information30
296: => p_rec.information30
297: ,p_form_tab_page_id_o
298: => hr_tpp_shd.g_old_rec.form_tab_page_id
299: ,p_template_tab_page_id_o
300: => hr_tpp_shd.g_old_rec.template_tab_page_id
301: ,p_object_version_number_o
302: => hr_tpp_shd.g_old_rec.object_version_number

Line 300: => hr_tpp_shd.g_old_rec.template_tab_page_id

296: => p_rec.information30
297: ,p_form_tab_page_id_o
298: => hr_tpp_shd.g_old_rec.form_tab_page_id
299: ,p_template_tab_page_id_o
300: => hr_tpp_shd.g_old_rec.template_tab_page_id
301: ,p_object_version_number_o
302: => hr_tpp_shd.g_old_rec.object_version_number
303: ,p_navigation_direction_o
304: => hr_tpp_shd.g_old_rec.navigation_direction

Line 302: => hr_tpp_shd.g_old_rec.object_version_number

298: => hr_tpp_shd.g_old_rec.form_tab_page_id
299: ,p_template_tab_page_id_o
300: => hr_tpp_shd.g_old_rec.template_tab_page_id
301: ,p_object_version_number_o
302: => hr_tpp_shd.g_old_rec.object_version_number
303: ,p_navigation_direction_o
304: => hr_tpp_shd.g_old_rec.navigation_direction
305: ,p_visible_o
306: => hr_tpp_shd.g_old_rec.visible

Line 304: => hr_tpp_shd.g_old_rec.navigation_direction

300: => hr_tpp_shd.g_old_rec.template_tab_page_id
301: ,p_object_version_number_o
302: => hr_tpp_shd.g_old_rec.object_version_number
303: ,p_navigation_direction_o
304: => hr_tpp_shd.g_old_rec.navigation_direction
305: ,p_visible_o
306: => hr_tpp_shd.g_old_rec.visible
307: ,p_information_category_o
308: => hr_tpp_shd.g_old_rec.information_category

Line 306: => hr_tpp_shd.g_old_rec.visible

302: => hr_tpp_shd.g_old_rec.object_version_number
303: ,p_navigation_direction_o
304: => hr_tpp_shd.g_old_rec.navigation_direction
305: ,p_visible_o
306: => hr_tpp_shd.g_old_rec.visible
307: ,p_information_category_o
308: => hr_tpp_shd.g_old_rec.information_category
309: ,p_information1_o
310: => hr_tpp_shd.g_old_rec.information1

Line 308: => hr_tpp_shd.g_old_rec.information_category

304: => hr_tpp_shd.g_old_rec.navigation_direction
305: ,p_visible_o
306: => hr_tpp_shd.g_old_rec.visible
307: ,p_information_category_o
308: => hr_tpp_shd.g_old_rec.information_category
309: ,p_information1_o
310: => hr_tpp_shd.g_old_rec.information1
311: ,p_information2_o
312: => hr_tpp_shd.g_old_rec.information2

Line 310: => hr_tpp_shd.g_old_rec.information1

306: => hr_tpp_shd.g_old_rec.visible
307: ,p_information_category_o
308: => hr_tpp_shd.g_old_rec.information_category
309: ,p_information1_o
310: => hr_tpp_shd.g_old_rec.information1
311: ,p_information2_o
312: => hr_tpp_shd.g_old_rec.information2
313: ,p_information3_o
314: => hr_tpp_shd.g_old_rec.information3

Line 312: => hr_tpp_shd.g_old_rec.information2

308: => hr_tpp_shd.g_old_rec.information_category
309: ,p_information1_o
310: => hr_tpp_shd.g_old_rec.information1
311: ,p_information2_o
312: => hr_tpp_shd.g_old_rec.information2
313: ,p_information3_o
314: => hr_tpp_shd.g_old_rec.information3
315: ,p_information4_o
316: => hr_tpp_shd.g_old_rec.information4

Line 314: => hr_tpp_shd.g_old_rec.information3

310: => hr_tpp_shd.g_old_rec.information1
311: ,p_information2_o
312: => hr_tpp_shd.g_old_rec.information2
313: ,p_information3_o
314: => hr_tpp_shd.g_old_rec.information3
315: ,p_information4_o
316: => hr_tpp_shd.g_old_rec.information4
317: ,p_information5_o
318: => hr_tpp_shd.g_old_rec.information5

Line 316: => hr_tpp_shd.g_old_rec.information4

312: => hr_tpp_shd.g_old_rec.information2
313: ,p_information3_o
314: => hr_tpp_shd.g_old_rec.information3
315: ,p_information4_o
316: => hr_tpp_shd.g_old_rec.information4
317: ,p_information5_o
318: => hr_tpp_shd.g_old_rec.information5
319: ,p_information6_o
320: => hr_tpp_shd.g_old_rec.information6

Line 318: => hr_tpp_shd.g_old_rec.information5

314: => hr_tpp_shd.g_old_rec.information3
315: ,p_information4_o
316: => hr_tpp_shd.g_old_rec.information4
317: ,p_information5_o
318: => hr_tpp_shd.g_old_rec.information5
319: ,p_information6_o
320: => hr_tpp_shd.g_old_rec.information6
321: ,p_information7_o
322: => hr_tpp_shd.g_old_rec.information7

Line 320: => hr_tpp_shd.g_old_rec.information6

316: => hr_tpp_shd.g_old_rec.information4
317: ,p_information5_o
318: => hr_tpp_shd.g_old_rec.information5
319: ,p_information6_o
320: => hr_tpp_shd.g_old_rec.information6
321: ,p_information7_o
322: => hr_tpp_shd.g_old_rec.information7
323: ,p_information8_o
324: => hr_tpp_shd.g_old_rec.information8

Line 322: => hr_tpp_shd.g_old_rec.information7

318: => hr_tpp_shd.g_old_rec.information5
319: ,p_information6_o
320: => hr_tpp_shd.g_old_rec.information6
321: ,p_information7_o
322: => hr_tpp_shd.g_old_rec.information7
323: ,p_information8_o
324: => hr_tpp_shd.g_old_rec.information8
325: ,p_information9_o
326: => hr_tpp_shd.g_old_rec.information9

Line 324: => hr_tpp_shd.g_old_rec.information8

320: => hr_tpp_shd.g_old_rec.information6
321: ,p_information7_o
322: => hr_tpp_shd.g_old_rec.information7
323: ,p_information8_o
324: => hr_tpp_shd.g_old_rec.information8
325: ,p_information9_o
326: => hr_tpp_shd.g_old_rec.information9
327: ,p_information10_o
328: => hr_tpp_shd.g_old_rec.information10

Line 326: => hr_tpp_shd.g_old_rec.information9

322: => hr_tpp_shd.g_old_rec.information7
323: ,p_information8_o
324: => hr_tpp_shd.g_old_rec.information8
325: ,p_information9_o
326: => hr_tpp_shd.g_old_rec.information9
327: ,p_information10_o
328: => hr_tpp_shd.g_old_rec.information10
329: ,p_information11_o
330: => hr_tpp_shd.g_old_rec.information11

Line 328: => hr_tpp_shd.g_old_rec.information10

324: => hr_tpp_shd.g_old_rec.information8
325: ,p_information9_o
326: => hr_tpp_shd.g_old_rec.information9
327: ,p_information10_o
328: => hr_tpp_shd.g_old_rec.information10
329: ,p_information11_o
330: => hr_tpp_shd.g_old_rec.information11
331: ,p_information12_o
332: => hr_tpp_shd.g_old_rec.information12

Line 330: => hr_tpp_shd.g_old_rec.information11

326: => hr_tpp_shd.g_old_rec.information9
327: ,p_information10_o
328: => hr_tpp_shd.g_old_rec.information10
329: ,p_information11_o
330: => hr_tpp_shd.g_old_rec.information11
331: ,p_information12_o
332: => hr_tpp_shd.g_old_rec.information12
333: ,p_information13_o
334: => hr_tpp_shd.g_old_rec.information13

Line 332: => hr_tpp_shd.g_old_rec.information12

328: => hr_tpp_shd.g_old_rec.information10
329: ,p_information11_o
330: => hr_tpp_shd.g_old_rec.information11
331: ,p_information12_o
332: => hr_tpp_shd.g_old_rec.information12
333: ,p_information13_o
334: => hr_tpp_shd.g_old_rec.information13
335: ,p_information14_o
336: => hr_tpp_shd.g_old_rec.information14

Line 334: => hr_tpp_shd.g_old_rec.information13

330: => hr_tpp_shd.g_old_rec.information11
331: ,p_information12_o
332: => hr_tpp_shd.g_old_rec.information12
333: ,p_information13_o
334: => hr_tpp_shd.g_old_rec.information13
335: ,p_information14_o
336: => hr_tpp_shd.g_old_rec.information14
337: ,p_information15_o
338: => hr_tpp_shd.g_old_rec.information15

Line 336: => hr_tpp_shd.g_old_rec.information14

332: => hr_tpp_shd.g_old_rec.information12
333: ,p_information13_o
334: => hr_tpp_shd.g_old_rec.information13
335: ,p_information14_o
336: => hr_tpp_shd.g_old_rec.information14
337: ,p_information15_o
338: => hr_tpp_shd.g_old_rec.information15
339: ,p_information16_o
340: => hr_tpp_shd.g_old_rec.information16

Line 338: => hr_tpp_shd.g_old_rec.information15

334: => hr_tpp_shd.g_old_rec.information13
335: ,p_information14_o
336: => hr_tpp_shd.g_old_rec.information14
337: ,p_information15_o
338: => hr_tpp_shd.g_old_rec.information15
339: ,p_information16_o
340: => hr_tpp_shd.g_old_rec.information16
341: ,p_information17_o
342: => hr_tpp_shd.g_old_rec.information17

Line 340: => hr_tpp_shd.g_old_rec.information16

336: => hr_tpp_shd.g_old_rec.information14
337: ,p_information15_o
338: => hr_tpp_shd.g_old_rec.information15
339: ,p_information16_o
340: => hr_tpp_shd.g_old_rec.information16
341: ,p_information17_o
342: => hr_tpp_shd.g_old_rec.information17
343: ,p_information18_o
344: => hr_tpp_shd.g_old_rec.information18

Line 342: => hr_tpp_shd.g_old_rec.information17

338: => hr_tpp_shd.g_old_rec.information15
339: ,p_information16_o
340: => hr_tpp_shd.g_old_rec.information16
341: ,p_information17_o
342: => hr_tpp_shd.g_old_rec.information17
343: ,p_information18_o
344: => hr_tpp_shd.g_old_rec.information18
345: ,p_information19_o
346: => hr_tpp_shd.g_old_rec.information19

Line 344: => hr_tpp_shd.g_old_rec.information18

340: => hr_tpp_shd.g_old_rec.information16
341: ,p_information17_o
342: => hr_tpp_shd.g_old_rec.information17
343: ,p_information18_o
344: => hr_tpp_shd.g_old_rec.information18
345: ,p_information19_o
346: => hr_tpp_shd.g_old_rec.information19
347: ,p_information20_o
348: => hr_tpp_shd.g_old_rec.information20

Line 346: => hr_tpp_shd.g_old_rec.information19

342: => hr_tpp_shd.g_old_rec.information17
343: ,p_information18_o
344: => hr_tpp_shd.g_old_rec.information18
345: ,p_information19_o
346: => hr_tpp_shd.g_old_rec.information19
347: ,p_information20_o
348: => hr_tpp_shd.g_old_rec.information20
349: ,p_information21_o
350: => hr_tpp_shd.g_old_rec.information21

Line 348: => hr_tpp_shd.g_old_rec.information20

344: => hr_tpp_shd.g_old_rec.information18
345: ,p_information19_o
346: => hr_tpp_shd.g_old_rec.information19
347: ,p_information20_o
348: => hr_tpp_shd.g_old_rec.information20
349: ,p_information21_o
350: => hr_tpp_shd.g_old_rec.information21
351: ,p_information22_o
352: => hr_tpp_shd.g_old_rec.information22

Line 350: => hr_tpp_shd.g_old_rec.information21

346: => hr_tpp_shd.g_old_rec.information19
347: ,p_information20_o
348: => hr_tpp_shd.g_old_rec.information20
349: ,p_information21_o
350: => hr_tpp_shd.g_old_rec.information21
351: ,p_information22_o
352: => hr_tpp_shd.g_old_rec.information22
353: ,p_information23_o
354: => hr_tpp_shd.g_old_rec.information23

Line 352: => hr_tpp_shd.g_old_rec.information22

348: => hr_tpp_shd.g_old_rec.information20
349: ,p_information21_o
350: => hr_tpp_shd.g_old_rec.information21
351: ,p_information22_o
352: => hr_tpp_shd.g_old_rec.information22
353: ,p_information23_o
354: => hr_tpp_shd.g_old_rec.information23
355: ,p_information24_o
356: => hr_tpp_shd.g_old_rec.information24

Line 354: => hr_tpp_shd.g_old_rec.information23

350: => hr_tpp_shd.g_old_rec.information21
351: ,p_information22_o
352: => hr_tpp_shd.g_old_rec.information22
353: ,p_information23_o
354: => hr_tpp_shd.g_old_rec.information23
355: ,p_information24_o
356: => hr_tpp_shd.g_old_rec.information24
357: ,p_information25_o
358: => hr_tpp_shd.g_old_rec.information25

Line 356: => hr_tpp_shd.g_old_rec.information24

352: => hr_tpp_shd.g_old_rec.information22
353: ,p_information23_o
354: => hr_tpp_shd.g_old_rec.information23
355: ,p_information24_o
356: => hr_tpp_shd.g_old_rec.information24
357: ,p_information25_o
358: => hr_tpp_shd.g_old_rec.information25
359: ,p_information26_o
360: => hr_tpp_shd.g_old_rec.information26

Line 358: => hr_tpp_shd.g_old_rec.information25

354: => hr_tpp_shd.g_old_rec.information23
355: ,p_information24_o
356: => hr_tpp_shd.g_old_rec.information24
357: ,p_information25_o
358: => hr_tpp_shd.g_old_rec.information25
359: ,p_information26_o
360: => hr_tpp_shd.g_old_rec.information26
361: ,p_information27_o
362: => hr_tpp_shd.g_old_rec.information27

Line 360: => hr_tpp_shd.g_old_rec.information26

356: => hr_tpp_shd.g_old_rec.information24
357: ,p_information25_o
358: => hr_tpp_shd.g_old_rec.information25
359: ,p_information26_o
360: => hr_tpp_shd.g_old_rec.information26
361: ,p_information27_o
362: => hr_tpp_shd.g_old_rec.information27
363: ,p_information28_o
364: => hr_tpp_shd.g_old_rec.information28

Line 362: => hr_tpp_shd.g_old_rec.information27

358: => hr_tpp_shd.g_old_rec.information25
359: ,p_information26_o
360: => hr_tpp_shd.g_old_rec.information26
361: ,p_information27_o
362: => hr_tpp_shd.g_old_rec.information27
363: ,p_information28_o
364: => hr_tpp_shd.g_old_rec.information28
365: ,p_information29_o
366: => hr_tpp_shd.g_old_rec.information29

Line 364: => hr_tpp_shd.g_old_rec.information28

360: => hr_tpp_shd.g_old_rec.information26
361: ,p_information27_o
362: => hr_tpp_shd.g_old_rec.information27
363: ,p_information28_o
364: => hr_tpp_shd.g_old_rec.information28
365: ,p_information29_o
366: => hr_tpp_shd.g_old_rec.information29
367: ,p_information30_o
368: => hr_tpp_shd.g_old_rec.information30

Line 366: => hr_tpp_shd.g_old_rec.information29

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

Line 368: => hr_tpp_shd.g_old_rec.information30

364: => hr_tpp_shd.g_old_rec.information28
365: ,p_information29_o
366: => hr_tpp_shd.g_old_rec.information29
367: ,p_information30_o
368: => hr_tpp_shd.g_old_rec.information30
369: );
370: --
371: exception
372: --

Line 428: (p_rec in out nocopy hr_tpp_shd.g_rec_type

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

Line 440: hr_tpp_shd.g_old_rec.form_tab_page_id;

436: -- is being used then we must set to the 'current' argument value.
437: --
438: If (p_rec.form_tab_page_id = hr_api.g_number) then
439: p_rec.form_tab_page_id :=
440: hr_tpp_shd.g_old_rec.form_tab_page_id;
441: End If;
442: If (p_rec.template_tab_page_id = hr_api.g_number) then
443: p_rec.template_tab_page_id :=
444: hr_tpp_shd.g_old_rec.template_tab_page_id;

Line 444: hr_tpp_shd.g_old_rec.template_tab_page_id;

440: hr_tpp_shd.g_old_rec.form_tab_page_id;
441: End If;
442: If (p_rec.template_tab_page_id = hr_api.g_number) then
443: p_rec.template_tab_page_id :=
444: hr_tpp_shd.g_old_rec.template_tab_page_id;
445: End If;
446: If (p_rec.navigation_direction = hr_api.g_varchar2) then
447: p_rec.navigation_direction :=
448: hr_tpp_shd.g_old_rec.navigation_direction;

Line 448: hr_tpp_shd.g_old_rec.navigation_direction;

444: hr_tpp_shd.g_old_rec.template_tab_page_id;
445: End If;
446: If (p_rec.navigation_direction = hr_api.g_varchar2) then
447: p_rec.navigation_direction :=
448: hr_tpp_shd.g_old_rec.navigation_direction;
449: End If;
450: If (p_rec.visible = hr_api.g_number) then
451: p_rec.visible :=
452: hr_tpp_shd.g_old_rec.visible;

Line 452: hr_tpp_shd.g_old_rec.visible;

448: hr_tpp_shd.g_old_rec.navigation_direction;
449: End If;
450: If (p_rec.visible = hr_api.g_number) then
451: p_rec.visible :=
452: hr_tpp_shd.g_old_rec.visible;
453: End If;
454: If (p_rec.information_category = hr_api.g_varchar2) then
455: p_rec.information_category :=
456: hr_tpp_shd.g_old_rec.information_category;

Line 456: hr_tpp_shd.g_old_rec.information_category;

452: hr_tpp_shd.g_old_rec.visible;
453: End If;
454: If (p_rec.information_category = hr_api.g_varchar2) then
455: p_rec.information_category :=
456: hr_tpp_shd.g_old_rec.information_category;
457: End If;
458: If (p_rec.information1 = hr_api.g_varchar2) then
459: p_rec.information1 :=
460: hr_tpp_shd.g_old_rec.information1;

Line 460: hr_tpp_shd.g_old_rec.information1;

456: hr_tpp_shd.g_old_rec.information_category;
457: End If;
458: If (p_rec.information1 = hr_api.g_varchar2) then
459: p_rec.information1 :=
460: hr_tpp_shd.g_old_rec.information1;
461: End If;
462: If (p_rec.information2 = hr_api.g_varchar2) then
463: p_rec.information2 :=
464: hr_tpp_shd.g_old_rec.information2;

Line 464: hr_tpp_shd.g_old_rec.information2;

460: hr_tpp_shd.g_old_rec.information1;
461: End If;
462: If (p_rec.information2 = hr_api.g_varchar2) then
463: p_rec.information2 :=
464: hr_tpp_shd.g_old_rec.information2;
465: End If;
466: If (p_rec.information3 = hr_api.g_varchar2) then
467: p_rec.information3 :=
468: hr_tpp_shd.g_old_rec.information3;

Line 468: hr_tpp_shd.g_old_rec.information3;

464: hr_tpp_shd.g_old_rec.information2;
465: End If;
466: If (p_rec.information3 = hr_api.g_varchar2) then
467: p_rec.information3 :=
468: hr_tpp_shd.g_old_rec.information3;
469: End If;
470: If (p_rec.information4 = hr_api.g_varchar2) then
471: p_rec.information4 :=
472: hr_tpp_shd.g_old_rec.information4;

Line 472: hr_tpp_shd.g_old_rec.information4;

468: hr_tpp_shd.g_old_rec.information3;
469: End If;
470: If (p_rec.information4 = hr_api.g_varchar2) then
471: p_rec.information4 :=
472: hr_tpp_shd.g_old_rec.information4;
473: End If;
474: If (p_rec.information5 = hr_api.g_varchar2) then
475: p_rec.information5 :=
476: hr_tpp_shd.g_old_rec.information5;

Line 476: hr_tpp_shd.g_old_rec.information5;

472: hr_tpp_shd.g_old_rec.information4;
473: End If;
474: If (p_rec.information5 = hr_api.g_varchar2) then
475: p_rec.information5 :=
476: hr_tpp_shd.g_old_rec.information5;
477: End If;
478: If (p_rec.information6 = hr_api.g_varchar2) then
479: p_rec.information6 :=
480: hr_tpp_shd.g_old_rec.information6;

Line 480: hr_tpp_shd.g_old_rec.information6;

476: hr_tpp_shd.g_old_rec.information5;
477: End If;
478: If (p_rec.information6 = hr_api.g_varchar2) then
479: p_rec.information6 :=
480: hr_tpp_shd.g_old_rec.information6;
481: End If;
482: If (p_rec.information7 = hr_api.g_varchar2) then
483: p_rec.information7 :=
484: hr_tpp_shd.g_old_rec.information7;

Line 484: hr_tpp_shd.g_old_rec.information7;

480: hr_tpp_shd.g_old_rec.information6;
481: End If;
482: If (p_rec.information7 = hr_api.g_varchar2) then
483: p_rec.information7 :=
484: hr_tpp_shd.g_old_rec.information7;
485: End If;
486: If (p_rec.information8 = hr_api.g_varchar2) then
487: p_rec.information8 :=
488: hr_tpp_shd.g_old_rec.information8;

Line 488: hr_tpp_shd.g_old_rec.information8;

484: hr_tpp_shd.g_old_rec.information7;
485: End If;
486: If (p_rec.information8 = hr_api.g_varchar2) then
487: p_rec.information8 :=
488: hr_tpp_shd.g_old_rec.information8;
489: End If;
490: If (p_rec.information9 = hr_api.g_varchar2) then
491: p_rec.information9 :=
492: hr_tpp_shd.g_old_rec.information9;

Line 492: hr_tpp_shd.g_old_rec.information9;

488: hr_tpp_shd.g_old_rec.information8;
489: End If;
490: If (p_rec.information9 = hr_api.g_varchar2) then
491: p_rec.information9 :=
492: hr_tpp_shd.g_old_rec.information9;
493: End If;
494: If (p_rec.information10 = hr_api.g_varchar2) then
495: p_rec.information10 :=
496: hr_tpp_shd.g_old_rec.information10;

Line 496: hr_tpp_shd.g_old_rec.information10;

492: hr_tpp_shd.g_old_rec.information9;
493: End If;
494: If (p_rec.information10 = hr_api.g_varchar2) then
495: p_rec.information10 :=
496: hr_tpp_shd.g_old_rec.information10;
497: End If;
498: If (p_rec.information11 = hr_api.g_varchar2) then
499: p_rec.information11 :=
500: hr_tpp_shd.g_old_rec.information11;

Line 500: hr_tpp_shd.g_old_rec.information11;

496: hr_tpp_shd.g_old_rec.information10;
497: End If;
498: If (p_rec.information11 = hr_api.g_varchar2) then
499: p_rec.information11 :=
500: hr_tpp_shd.g_old_rec.information11;
501: End If;
502: If (p_rec.information12 = hr_api.g_varchar2) then
503: p_rec.information12 :=
504: hr_tpp_shd.g_old_rec.information12;

Line 504: hr_tpp_shd.g_old_rec.information12;

500: hr_tpp_shd.g_old_rec.information11;
501: End If;
502: If (p_rec.information12 = hr_api.g_varchar2) then
503: p_rec.information12 :=
504: hr_tpp_shd.g_old_rec.information12;
505: End If;
506: If (p_rec.information13 = hr_api.g_varchar2) then
507: p_rec.information13 :=
508: hr_tpp_shd.g_old_rec.information13;

Line 508: hr_tpp_shd.g_old_rec.information13;

504: hr_tpp_shd.g_old_rec.information12;
505: End If;
506: If (p_rec.information13 = hr_api.g_varchar2) then
507: p_rec.information13 :=
508: hr_tpp_shd.g_old_rec.information13;
509: End If;
510: If (p_rec.information14 = hr_api.g_varchar2) then
511: p_rec.information14 :=
512: hr_tpp_shd.g_old_rec.information14;

Line 512: hr_tpp_shd.g_old_rec.information14;

508: hr_tpp_shd.g_old_rec.information13;
509: End If;
510: If (p_rec.information14 = hr_api.g_varchar2) then
511: p_rec.information14 :=
512: hr_tpp_shd.g_old_rec.information14;
513: End If;
514: If (p_rec.information15 = hr_api.g_varchar2) then
515: p_rec.information15 :=
516: hr_tpp_shd.g_old_rec.information15;

Line 516: hr_tpp_shd.g_old_rec.information15;

512: hr_tpp_shd.g_old_rec.information14;
513: End If;
514: If (p_rec.information15 = hr_api.g_varchar2) then
515: p_rec.information15 :=
516: hr_tpp_shd.g_old_rec.information15;
517: End If;
518: If (p_rec.information16 = hr_api.g_varchar2) then
519: p_rec.information16 :=
520: hr_tpp_shd.g_old_rec.information16;

Line 520: hr_tpp_shd.g_old_rec.information16;

516: hr_tpp_shd.g_old_rec.information15;
517: End If;
518: If (p_rec.information16 = hr_api.g_varchar2) then
519: p_rec.information16 :=
520: hr_tpp_shd.g_old_rec.information16;
521: End If;
522: If (p_rec.information17 = hr_api.g_varchar2) then
523: p_rec.information17 :=
524: hr_tpp_shd.g_old_rec.information17;

Line 524: hr_tpp_shd.g_old_rec.information17;

520: hr_tpp_shd.g_old_rec.information16;
521: End If;
522: If (p_rec.information17 = hr_api.g_varchar2) then
523: p_rec.information17 :=
524: hr_tpp_shd.g_old_rec.information17;
525: End If;
526: If (p_rec.information18 = hr_api.g_varchar2) then
527: p_rec.information18 :=
528: hr_tpp_shd.g_old_rec.information18;

Line 528: hr_tpp_shd.g_old_rec.information18;

524: hr_tpp_shd.g_old_rec.information17;
525: End If;
526: If (p_rec.information18 = hr_api.g_varchar2) then
527: p_rec.information18 :=
528: hr_tpp_shd.g_old_rec.information18;
529: End If;
530: If (p_rec.information19 = hr_api.g_varchar2) then
531: p_rec.information19 :=
532: hr_tpp_shd.g_old_rec.information19;

Line 532: hr_tpp_shd.g_old_rec.information19;

528: hr_tpp_shd.g_old_rec.information18;
529: End If;
530: If (p_rec.information19 = hr_api.g_varchar2) then
531: p_rec.information19 :=
532: hr_tpp_shd.g_old_rec.information19;
533: End If;
534: If (p_rec.information20 = hr_api.g_varchar2) then
535: p_rec.information20 :=
536: hr_tpp_shd.g_old_rec.information20;

Line 536: hr_tpp_shd.g_old_rec.information20;

532: hr_tpp_shd.g_old_rec.information19;
533: End If;
534: If (p_rec.information20 = hr_api.g_varchar2) then
535: p_rec.information20 :=
536: hr_tpp_shd.g_old_rec.information20;
537: End If;
538: If (p_rec.information21 = hr_api.g_varchar2) then
539: p_rec.information21 :=
540: hr_tpp_shd.g_old_rec.information21;

Line 540: hr_tpp_shd.g_old_rec.information21;

536: hr_tpp_shd.g_old_rec.information20;
537: End If;
538: If (p_rec.information21 = hr_api.g_varchar2) then
539: p_rec.information21 :=
540: hr_tpp_shd.g_old_rec.information21;
541: End If;
542: If (p_rec.information22 = hr_api.g_varchar2) then
543: p_rec.information22 :=
544: hr_tpp_shd.g_old_rec.information22;

Line 544: hr_tpp_shd.g_old_rec.information22;

540: hr_tpp_shd.g_old_rec.information21;
541: End If;
542: If (p_rec.information22 = hr_api.g_varchar2) then
543: p_rec.information22 :=
544: hr_tpp_shd.g_old_rec.information22;
545: End If;
546: If (p_rec.information23 = hr_api.g_varchar2) then
547: p_rec.information23 :=
548: hr_tpp_shd.g_old_rec.information23;

Line 548: hr_tpp_shd.g_old_rec.information23;

544: hr_tpp_shd.g_old_rec.information22;
545: End If;
546: If (p_rec.information23 = hr_api.g_varchar2) then
547: p_rec.information23 :=
548: hr_tpp_shd.g_old_rec.information23;
549: End If;
550: If (p_rec.information24 = hr_api.g_varchar2) then
551: p_rec.information24 :=
552: hr_tpp_shd.g_old_rec.information24;

Line 552: hr_tpp_shd.g_old_rec.information24;

548: hr_tpp_shd.g_old_rec.information23;
549: End If;
550: If (p_rec.information24 = hr_api.g_varchar2) then
551: p_rec.information24 :=
552: hr_tpp_shd.g_old_rec.information24;
553: End If;
554: If (p_rec.information25 = hr_api.g_varchar2) then
555: p_rec.information25 :=
556: hr_tpp_shd.g_old_rec.information25;

Line 556: hr_tpp_shd.g_old_rec.information25;

552: hr_tpp_shd.g_old_rec.information24;
553: End If;
554: If (p_rec.information25 = hr_api.g_varchar2) then
555: p_rec.information25 :=
556: hr_tpp_shd.g_old_rec.information25;
557: End If;
558: If (p_rec.information26 = hr_api.g_varchar2) then
559: p_rec.information26 :=
560: hr_tpp_shd.g_old_rec.information26;

Line 560: hr_tpp_shd.g_old_rec.information26;

556: hr_tpp_shd.g_old_rec.information25;
557: End If;
558: If (p_rec.information26 = hr_api.g_varchar2) then
559: p_rec.information26 :=
560: hr_tpp_shd.g_old_rec.information26;
561: End If;
562: If (p_rec.information27 = hr_api.g_varchar2) then
563: p_rec.information27 :=
564: hr_tpp_shd.g_old_rec.information27;

Line 564: hr_tpp_shd.g_old_rec.information27;

560: hr_tpp_shd.g_old_rec.information26;
561: End If;
562: If (p_rec.information27 = hr_api.g_varchar2) then
563: p_rec.information27 :=
564: hr_tpp_shd.g_old_rec.information27;
565: End If;
566: If (p_rec.information28 = hr_api.g_varchar2) then
567: p_rec.information28 :=
568: hr_tpp_shd.g_old_rec.information28;

Line 568: hr_tpp_shd.g_old_rec.information28;

564: hr_tpp_shd.g_old_rec.information27;
565: End If;
566: If (p_rec.information28 = hr_api.g_varchar2) then
567: p_rec.information28 :=
568: hr_tpp_shd.g_old_rec.information28;
569: End If;
570: If (p_rec.information29 = hr_api.g_varchar2) then
571: p_rec.information29 :=
572: hr_tpp_shd.g_old_rec.information29;

Line 572: hr_tpp_shd.g_old_rec.information29;

568: hr_tpp_shd.g_old_rec.information28;
569: End If;
570: If (p_rec.information29 = hr_api.g_varchar2) then
571: p_rec.information29 :=
572: hr_tpp_shd.g_old_rec.information29;
573: End If;
574: If (p_rec.information30 = hr_api.g_varchar2) then
575: p_rec.information30 :=
576: hr_tpp_shd.g_old_rec.information30;

Line 576: hr_tpp_shd.g_old_rec.information30;

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

Line 586: ,p_rec in out nocopy hr_tpp_shd.g_rec_type

582: -- |---------------------------------< upd >----------------------------------|
583: -- ----------------------------------------------------------------------------
584: Procedure upd
585: (p_effective_date in date
586: ,p_rec in out nocopy hr_tpp_shd.g_rec_type
587: ) is
588: --
589: l_proc varchar2(72) := g_package||'upd';
590: --

Line 596: hr_tpp_shd.lck

592: hr_utility.set_location('Entering:'||l_proc, 5);
593: --
594: -- We must lock the row which we need to update.
595: --
596: hr_tpp_shd.lck
597: (p_rec.tab_page_property_id
598: ,p_rec.object_version_number
599: );
600: --

Line 673: l_rec hr_tpp_shd.g_rec_type;

669: ,p_information29 in varchar2 default hr_api.g_varchar2
670: ,p_information30 in varchar2 default hr_api.g_varchar2
671: ) is
672: --
673: l_rec hr_tpp_shd.g_rec_type;
674: l_proc varchar2(72) := g_package||'upd';
675: --
676: Begin
677: hr_utility.set_location('Entering:'||l_proc, 5);

Line 683: hr_tpp_shd.convert_args

679: -- Call conversion function to turn arguments into the
680: -- l_rec structure.
681: --
682: l_rec :=
683: hr_tpp_shd.convert_args
684: (p_tab_page_property_id
685: ,p_object_version_number
686: ,p_form_tab_page_id
687: ,p_template_tab_page_id