DBA Data[Home] [Help]

PACKAGE BODY: APPS.PE_POI_RKI

Source


1 package body PE_POI_RKI as
2 /* $Header: pepoirhi.pkb 120.0 2005/05/31 14:50:38 generated noship $ */
3 -- Code generated by the Oracle HRMS API Hook Pre-processor
4 -- Created on 2007/01/03 22:49:50 (YYYY/MM/DD HH24:MI:SS)
5 procedure AFTER_INSERT
6 (P_POSITION_EXTRA_INFO_ID in NUMBER
7 ,P_POSITION_ID in NUMBER
8 ,P_INFORMATION_TYPE in VARCHAR2
9 ,P_REQUEST_ID in NUMBER
10 ,P_PROGRAM_APPLICATION_ID in NUMBER
11 ,P_PROGRAM_ID in NUMBER
12 ,P_PROGRAM_UPDATE_DATE in DATE
13 ,P_POEI_ATTRIBUTE_CATEGORY in VARCHAR2
14 ,P_POEI_ATTRIBUTE1 in VARCHAR2
15 ,P_POEI_ATTRIBUTE2 in VARCHAR2
16 ,P_POEI_ATTRIBUTE3 in VARCHAR2
17 ,P_POEI_ATTRIBUTE4 in VARCHAR2
18 ,P_POEI_ATTRIBUTE5 in VARCHAR2
19 ,P_POEI_ATTRIBUTE6 in VARCHAR2
20 ,P_POEI_ATTRIBUTE7 in VARCHAR2
21 ,P_POEI_ATTRIBUTE8 in VARCHAR2
22 ,P_POEI_ATTRIBUTE9 in VARCHAR2
23 ,P_POEI_ATTRIBUTE10 in VARCHAR2
24 ,P_POEI_ATTRIBUTE11 in VARCHAR2
25 ,P_POEI_ATTRIBUTE12 in VARCHAR2
26 ,P_POEI_ATTRIBUTE13 in VARCHAR2
27 ,P_POEI_ATTRIBUTE14 in VARCHAR2
28 ,P_POEI_ATTRIBUTE15 in VARCHAR2
29 ,P_POEI_ATTRIBUTE16 in VARCHAR2
30 ,P_POEI_ATTRIBUTE17 in VARCHAR2
31 ,P_POEI_ATTRIBUTE18 in VARCHAR2
32 ,P_POEI_ATTRIBUTE19 in VARCHAR2
33 ,P_POEI_ATTRIBUTE20 in VARCHAR2
34 ,P_POEI_INFORMATION_CATEGORY in VARCHAR2
35 ,P_POEI_INFORMATION1 in VARCHAR2
36 ,P_POEI_INFORMATION2 in VARCHAR2
37 ,P_POEI_INFORMATION3 in VARCHAR2
38 ,P_POEI_INFORMATION4 in VARCHAR2
39 ,P_POEI_INFORMATION5 in VARCHAR2
40 ,P_POEI_INFORMATION6 in VARCHAR2
41 ,P_POEI_INFORMATION7 in VARCHAR2
42 ,P_POEI_INFORMATION8 in VARCHAR2
43 ,P_POEI_INFORMATION9 in VARCHAR2
44 ,P_POEI_INFORMATION10 in VARCHAR2
45 ,P_POEI_INFORMATION11 in VARCHAR2
46 ,P_POEI_INFORMATION12 in VARCHAR2
47 ,P_POEI_INFORMATION13 in VARCHAR2
48 ,P_POEI_INFORMATION14 in VARCHAR2
49 ,P_POEI_INFORMATION15 in VARCHAR2
50 ,P_POEI_INFORMATION16 in VARCHAR2
51 ,P_POEI_INFORMATION17 in VARCHAR2
52 ,P_POEI_INFORMATION18 in VARCHAR2
53 ,P_POEI_INFORMATION19 in VARCHAR2
54 ,P_POEI_INFORMATION20 in VARCHAR2
55 ,P_POEI_INFORMATION21 in VARCHAR2
56 ,P_POEI_INFORMATION22 in VARCHAR2
57 ,P_POEI_INFORMATION23 in VARCHAR2
58 ,P_POEI_INFORMATION24 in VARCHAR2
59 ,P_POEI_INFORMATION25 in VARCHAR2
60 ,P_POEI_INFORMATION26 in VARCHAR2
61 ,P_POEI_INFORMATION27 in VARCHAR2
62 ,P_POEI_INFORMATION28 in VARCHAR2
63 ,P_POEI_INFORMATION29 in VARCHAR2
64 ,P_POEI_INFORMATION30 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_POI_RKI.AFTER_INSERT', 10);
70 l_commit_unit_number := hr_api.return_commit_unit;
71 if hr_api.call_leg_hooks then
72 -- Note: All legislation hook calls will be executed regardless of the
73 -- legislation code because the data for this API module is not held within
74 -- the context of a business_group_id.
75 GHR_POI_FLEX_DDF.DDF
76 (P_POSITION_EXTRA_INFO_ID => P_POSITION_EXTRA_INFO_ID
77 ,P_POSITION_ID => P_POSITION_ID
78 ,P_INFORMATION_TYPE => P_INFORMATION_TYPE
79 ,P_REQUEST_ID => P_REQUEST_ID
80 ,P_PROGRAM_APPLICATION_ID => P_PROGRAM_APPLICATION_ID
81 ,P_PROGRAM_ID => P_PROGRAM_ID
82 ,P_PROGRAM_UPDATE_DATE => P_PROGRAM_UPDATE_DATE
83 ,P_POEI_ATTRIBUTE_CATEGORY => P_POEI_ATTRIBUTE_CATEGORY
84 ,P_POEI_ATTRIBUTE1 => P_POEI_ATTRIBUTE1
85 ,P_POEI_ATTRIBUTE2 => P_POEI_ATTRIBUTE2
86 ,P_POEI_ATTRIBUTE3 => P_POEI_ATTRIBUTE3
87 ,P_POEI_ATTRIBUTE4 => P_POEI_ATTRIBUTE4
88 ,P_POEI_ATTRIBUTE5 => P_POEI_ATTRIBUTE5
89 ,P_POEI_ATTRIBUTE6 => P_POEI_ATTRIBUTE6
90 ,P_POEI_ATTRIBUTE7 => P_POEI_ATTRIBUTE7
91 ,P_POEI_ATTRIBUTE8 => P_POEI_ATTRIBUTE8
92 ,P_POEI_ATTRIBUTE9 => P_POEI_ATTRIBUTE9
93 ,P_POEI_ATTRIBUTE10 => P_POEI_ATTRIBUTE10
94 ,P_POEI_ATTRIBUTE11 => P_POEI_ATTRIBUTE11
95 ,P_POEI_ATTRIBUTE12 => P_POEI_ATTRIBUTE12
96 ,P_POEI_ATTRIBUTE13 => P_POEI_ATTRIBUTE13
97 ,P_POEI_ATTRIBUTE14 => P_POEI_ATTRIBUTE14
98 ,P_POEI_ATTRIBUTE15 => P_POEI_ATTRIBUTE15
99 ,P_POEI_ATTRIBUTE16 => P_POEI_ATTRIBUTE16
100 ,P_POEI_ATTRIBUTE17 => P_POEI_ATTRIBUTE17
101 ,P_POEI_ATTRIBUTE18 => P_POEI_ATTRIBUTE18
102 ,P_POEI_ATTRIBUTE19 => P_POEI_ATTRIBUTE19
103 ,P_POEI_ATTRIBUTE20 => P_POEI_ATTRIBUTE20
104 ,P_POEI_INFORMATION_CATEGORY => P_POEI_INFORMATION_CATEGORY
105 ,P_POEI_INFORMATION1 => P_POEI_INFORMATION1
106 ,P_POEI_INFORMATION2 => P_POEI_INFORMATION2
107 ,P_POEI_INFORMATION3 => P_POEI_INFORMATION3
108 ,P_POEI_INFORMATION4 => P_POEI_INFORMATION4
109 ,P_POEI_INFORMATION5 => P_POEI_INFORMATION5
110 ,P_POEI_INFORMATION6 => P_POEI_INFORMATION6
111 ,P_POEI_INFORMATION7 => P_POEI_INFORMATION7
112 ,P_POEI_INFORMATION8 => P_POEI_INFORMATION8
113 ,P_POEI_INFORMATION9 => P_POEI_INFORMATION9
114 ,P_POEI_INFORMATION10 => P_POEI_INFORMATION10
115 ,P_POEI_INFORMATION11 => P_POEI_INFORMATION11
116 ,P_POEI_INFORMATION12 => P_POEI_INFORMATION12
117 ,P_POEI_INFORMATION13 => P_POEI_INFORMATION13
118 ,P_POEI_INFORMATION14 => P_POEI_INFORMATION14
119 ,P_POEI_INFORMATION15 => P_POEI_INFORMATION15
120 ,P_POEI_INFORMATION16 => P_POEI_INFORMATION16
121 ,P_POEI_INFORMATION17 => P_POEI_INFORMATION17
122 ,P_POEI_INFORMATION18 => P_POEI_INFORMATION18
123 ,P_POEI_INFORMATION19 => P_POEI_INFORMATION19
124 ,P_POEI_INFORMATION20 => P_POEI_INFORMATION20
125 ,P_POEI_INFORMATION21 => P_POEI_INFORMATION21
126 ,P_POEI_INFORMATION22 => P_POEI_INFORMATION22
127 ,P_POEI_INFORMATION23 => P_POEI_INFORMATION23
128 ,P_POEI_INFORMATION24 => P_POEI_INFORMATION24
129 ,P_POEI_INFORMATION25 => P_POEI_INFORMATION25
130 ,P_POEI_INFORMATION26 => P_POEI_INFORMATION26
131 ,P_POEI_INFORMATION27 => P_POEI_INFORMATION27
132 ,P_POEI_INFORMATION28 => P_POEI_INFORMATION28
133 ,P_POEI_INFORMATION29 => P_POEI_INFORMATION29
134 ,P_POEI_INFORMATION30 => P_POEI_INFORMATION30
135 );
136 end if;
137 hr_api.validate_commit_unit(l_commit_unit_number, 'PER_POSITION_EXTRA_INFO', 'AI');
138 hr_utility.set_location(' Leaving: PE_POI_RKI.AFTER_INSERT', 20);
139 end AFTER_INSERT;
140 end PE_POI_RKI;