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.
PACKAGE BODY: APPS.PE_PEI_RKD

Source


1 package body PE_PEI_RKD as
2 /* $Header: pepeirhi.pkb 120.1 2005/07/25 05:01:42 generated noship $ */
3 -- Code generated by the Oracle HRMS API Hook Pre-processor
4 -- Created on 2007/01/03 23:17:41 (YYYY/MM/DD HH24:MI:SS)
5 procedure AFTER_DELETE
6 (P_PERSON_EXTRA_INFO_ID_O in NUMBER
7 ,P_PERSON_ID_O in NUMBER
8 ,P_INFORMATION_TYPE_O in VARCHAR2
9 ,P_REQUEST_ID_O in NUMBER
10 ,P_PROGRAM_APPLICATION_ID_O in NUMBER
11 ,P_PROGRAM_ID_O in NUMBER
12 ,P_PROGRAM_UPDATE_DATE_O in DATE
13 ,P_PEI_ATTRIBUTE_CATEGORY_O in VARCHAR2
14 ,P_PEI_ATTRIBUTE1_O in VARCHAR2
15 ,P_PEI_ATTRIBUTE2_O in VARCHAR2
16 ,P_PEI_ATTRIBUTE3_O in VARCHAR2
17 ,P_PEI_ATTRIBUTE4_O in VARCHAR2
18 ,P_PEI_ATTRIBUTE5_O in VARCHAR2
19 ,P_PEI_ATTRIBUTE6_O in VARCHAR2
20 ,P_PEI_ATTRIBUTE7_O in VARCHAR2
21 ,P_PEI_ATTRIBUTE8_O in VARCHAR2
22 ,P_PEI_ATTRIBUTE9_O in VARCHAR2
23 ,P_PEI_ATTRIBUTE10_O in VARCHAR2
24 ,P_PEI_ATTRIBUTE11_O in VARCHAR2
25 ,P_PEI_ATTRIBUTE12_O in VARCHAR2
26 ,P_PEI_ATTRIBUTE13_O in VARCHAR2
27 ,P_PEI_ATTRIBUTE14_O in VARCHAR2
28 ,P_PEI_ATTRIBUTE15_O in VARCHAR2
29 ,P_PEI_ATTRIBUTE16_O in VARCHAR2
30 ,P_PEI_ATTRIBUTE17_O in VARCHAR2
31 ,P_PEI_ATTRIBUTE18_O in VARCHAR2
32 ,P_PEI_ATTRIBUTE19_O in VARCHAR2
33 ,P_PEI_ATTRIBUTE20_O in VARCHAR2
34 ,P_PEI_INFORMATION_CATEGORY_O in VARCHAR2
35 ,P_PEI_INFORMATION1_O in VARCHAR2
36 ,P_PEI_INFORMATION2_O in VARCHAR2
37 ,P_PEI_INFORMATION3_O in VARCHAR2
38 ,P_PEI_INFORMATION4_O in VARCHAR2
39 ,P_PEI_INFORMATION5_O in VARCHAR2
40 ,P_PEI_INFORMATION6_O in VARCHAR2
41 ,P_PEI_INFORMATION7_O in VARCHAR2
42 ,P_PEI_INFORMATION8_O in VARCHAR2
43 ,P_PEI_INFORMATION9_O in VARCHAR2
44 ,P_PEI_INFORMATION10_O in VARCHAR2
45 ,P_PEI_INFORMATION11_O in VARCHAR2
46 ,P_PEI_INFORMATION12_O in VARCHAR2
47 ,P_PEI_INFORMATION13_O in VARCHAR2
48 ,P_PEI_INFORMATION14_O in VARCHAR2
49 ,P_PEI_INFORMATION15_O in VARCHAR2
50 ,P_PEI_INFORMATION16_O in VARCHAR2
51 ,P_PEI_INFORMATION17_O in VARCHAR2
52 ,P_PEI_INFORMATION18_O in VARCHAR2
53 ,P_PEI_INFORMATION19_O in VARCHAR2
54 ,P_PEI_INFORMATION20_O in VARCHAR2
55 ,P_PEI_INFORMATION21_O in VARCHAR2
56 ,P_PEI_INFORMATION22_O in VARCHAR2
57 ,P_PEI_INFORMATION23_O in VARCHAR2
58 ,P_PEI_INFORMATION24_O in VARCHAR2
59 ,P_PEI_INFORMATION25_O in VARCHAR2
60 ,P_PEI_INFORMATION26_O in VARCHAR2
61 ,P_PEI_INFORMATION27_O in VARCHAR2
62 ,P_PEI_INFORMATION28_O in VARCHAR2
63 ,P_PEI_INFORMATION29_O in VARCHAR2
64 ,P_PEI_INFORMATION30_O in VARCHAR2
65 )is
66 l_commit_unit_number number;
67 l_legislation_code   varchar2(30);
68 begin
69 hr_utility.set_location('Entering: PE_PEI_RKD.AFTER_DELETE', 10);
70 l_commit_unit_number := hr_api.return_commit_unit;
71 if hr_api.call_leg_hooks then
72 l_legislation_code := PER_PER_BUS.return_legislation_code(P_PERSON_ID => P_PERSON_ID_O
73 );
74 if l_legislation_code = 'US' then
75 PQP_HRTCA_SYNCHRONIZATION.PEI_DDF_DEL
76 (P_PERSON_ID_O => P_PERSON_ID_O
77 ,P_INFORMATION_TYPE_O => P_INFORMATION_TYPE_O
78 ,P_PEI_ATTRIBUTE_CATEGORY_O => P_PEI_ATTRIBUTE_CATEGORY_O
79 ,P_PEI_INFORMATION_CATEGORY_O => P_PEI_INFORMATION_CATEGORY_O
80 ,P_PEI_INFORMATION1_O => P_PEI_INFORMATION1_O
81 ,P_PEI_INFORMATION2_O => P_PEI_INFORMATION2_O
82 ,P_PEI_INFORMATION3_O => P_PEI_INFORMATION3_O
83 ,P_PEI_INFORMATION4_O => P_PEI_INFORMATION4_O
84 ,P_PEI_INFORMATION5_O => P_PEI_INFORMATION5_O
85 ,P_PEI_INFORMATION6_O => P_PEI_INFORMATION6_O
86 ,P_PEI_INFORMATION7_O => P_PEI_INFORMATION7_O
87 ,P_PEI_INFORMATION8_O => P_PEI_INFORMATION8_O
88 ,P_PEI_INFORMATION9_O => P_PEI_INFORMATION9_O
89 ,P_PEI_INFORMATION10_O => P_PEI_INFORMATION10_O
90 ,P_PEI_INFORMATION11_O => P_PEI_INFORMATION11_O
91 ,P_PEI_INFORMATION12_O => P_PEI_INFORMATION12_O
92 ,P_PEI_INFORMATION13_O => P_PEI_INFORMATION13_O
93 ,P_PEI_INFORMATION14_O => P_PEI_INFORMATION14_O
94 ,P_PEI_INFORMATION15_O => P_PEI_INFORMATION15_O
95 ,P_PEI_INFORMATION16_O => P_PEI_INFORMATION16_O
96 ,P_PEI_INFORMATION17_O => P_PEI_INFORMATION17_O
97 ,P_PEI_INFORMATION18_O => P_PEI_INFORMATION18_O
98 ,P_PEI_INFORMATION19_O => P_PEI_INFORMATION19_O
99 ,P_PEI_INFORMATION20_O => P_PEI_INFORMATION20_O
100 ,P_PEI_INFORMATION21_O => P_PEI_INFORMATION21_O
101 ,P_PEI_INFORMATION22_O => P_PEI_INFORMATION22_O
102 ,P_PEI_INFORMATION23_O => P_PEI_INFORMATION23_O
103 ,P_PEI_INFORMATION24_O => P_PEI_INFORMATION24_O
104 ,P_PEI_INFORMATION25_O => P_PEI_INFORMATION25_O
105 ,P_PEI_INFORMATION26_O => P_PEI_INFORMATION26_O
106 ,P_PEI_INFORMATION27_O => P_PEI_INFORMATION27_O
107 ,P_PEI_INFORMATION28_O => P_PEI_INFORMATION28_O
108 ,P_PEI_INFORMATION29_O => P_PEI_INFORMATION29_O
109 ,P_PEI_INFORMATION30_O => P_PEI_INFORMATION30_O
110 );
111 end if;
112 end if;
113 hr_api.validate_commit_unit(l_commit_unit_number, 'PER_PEOPLE_EXTRA_INFO', 'AD');
114 hr_utility.set_location(' Leaving: PE_PEI_RKD.AFTER_DELETE', 20);
115 end AFTER_DELETE;
116 end PE_PEI_RKD;