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.PER_ASG_RKD

Source


1 package body PER_ASG_RKD as
2 /* $Header: peasgrhi.pkb 120.19.12010000.3 2008/11/12 06:37:24 generated ship $ */
3 -- Code generated by the Oracle HRMS API Hook Pre-processor
4 -- Created on 2009/03/30 04:46:20 (YYYY/MM/DD HH24:MI:SS)
5 procedure AFTER_DELETE
6 (P_EFFECTIVE_DATE in DATE
7 ,P_DATETRACK_MODE in VARCHAR2
8 ,P_VALIDATION_START_DATE in DATE
9 ,P_VALIDATION_END_DATE in DATE
10 ,P_ASSIGNMENT_ID in NUMBER
11 ,P_EFFECTIVE_START_DATE in DATE
12 ,P_EFFECTIVE_END_DATE in DATE
13 ,P_ORG_NOW_NO_MANAGER_WARNING in BOOLEAN
14 ,P_OBJECT_VERSION_NUMBER in NUMBER
15 ,P_EFFECTIVE_START_DATE_O in DATE
16 ,P_EFFECTIVE_END_DATE_O in DATE
17 ,P_BUSINESS_GROUP_ID_O in NUMBER
18 ,P_RECRUITER_ID_O in NUMBER
19 ,P_GRADE_ID_O in NUMBER
20 ,P_POSITION_ID_O in NUMBER
21 ,P_JOB_ID_O in NUMBER
22 ,P_ASSIGNMENT_STATUS_TYPE_ID_O in NUMBER
23 ,P_PAYROLL_ID_O in NUMBER
24 ,P_LOCATION_ID_O in NUMBER
25 ,P_PERSON_REFERRED_BY_ID_O in NUMBER
26 ,P_SUPERVISOR_ID_O in NUMBER
27 ,P_SPECIAL_CEILING_STEP_ID_O in NUMBER
28 ,P_PERSON_ID_O in NUMBER
29 ,P_RECRUITMENT_ACTIVITY_ID_O in NUMBER
30 ,P_SOURCE_ORGANIZATION_ID_O in NUMBER
31 ,P_ORGANIZATION_ID_O in NUMBER
32 ,P_PEOPLE_GROUP_ID_O in NUMBER
33 ,P_SOFT_CODING_KEYFLEX_ID_O in NUMBER
34 ,P_VACANCY_ID_O in NUMBER
35 ,P_PAY_BASIS_ID_O in NUMBER
36 ,P_ASSIGNMENT_SEQUENCE_O in NUMBER
37 ,P_ASSIGNMENT_TYPE_O in VARCHAR2
38 ,P_PRIMARY_FLAG_O in VARCHAR2
39 ,P_APPLICATION_ID_O in NUMBER
40 ,P_ASSIGNMENT_NUMBER_O in VARCHAR2
41 ,P_CHANGE_REASON_O in VARCHAR2
42 ,P_COMMENT_ID_O in NUMBER
43 ,P_DATE_PROBATION_END_O in DATE
44 ,P_DEFAULT_CODE_COMB_ID_O in NUMBER
45 ,P_EMPLOYMENT_CATEGORY_O in VARCHAR2
46 ,P_FREQUENCY_O in VARCHAR2
47 ,P_INTERNAL_ADDRESS_LINE_O in VARCHAR2
48 ,P_MANAGER_FLAG_O in VARCHAR2
49 ,P_NORMAL_HOURS_O in NUMBER
50 ,P_PERF_REVIEW_PERIOD_O in NUMBER
51 ,P_PERF_REVIEW_PERIOD_FREQUEN_O in VARCHAR2
52 ,P_PERIOD_OF_SERVICE_ID_O in NUMBER
53 ,P_PROBATION_PERIOD_O in NUMBER
54 ,P_PROBATION_UNIT_O in VARCHAR2
55 ,P_SAL_REVIEW_PERIOD_O in NUMBER
56 ,P_SAL_REVIEW_PERIOD_FREQUEN_O in VARCHAR2
57 ,P_SET_OF_BOOKS_ID_O in NUMBER
58 ,P_SOURCE_TYPE_O in VARCHAR2
59 ,P_TIME_NORMAL_FINISH_O in VARCHAR2
60 ,P_TIME_NORMAL_START_O in VARCHAR2
61 ,P_BARGAINING_UNIT_CODE_O in VARCHAR2
62 ,P_LABOUR_UNION_MEMBER_FLAG_O in VARCHAR2
63 ,P_HOURLY_SALARIED_CODE_O in VARCHAR2
64 ,P_REQUEST_ID_O in NUMBER
65 ,P_PROGRAM_APPLICATION_ID_O in NUMBER
66 ,P_PROGRAM_ID_O in NUMBER
67 ,P_PROGRAM_UPDATE_DATE_O in DATE
68 ,P_ASS_ATTRIBUTE_CATEGORY_O in VARCHAR2
69 ,P_ASS_ATTRIBUTE1_O in VARCHAR2
70 ,P_ASS_ATTRIBUTE2_O in VARCHAR2
71 ,P_ASS_ATTRIBUTE3_O in VARCHAR2
72 ,P_ASS_ATTRIBUTE4_O in VARCHAR2
73 ,P_ASS_ATTRIBUTE5_O in VARCHAR2
74 ,P_ASS_ATTRIBUTE6_O in VARCHAR2
75 ,P_ASS_ATTRIBUTE7_O in VARCHAR2
76 ,P_ASS_ATTRIBUTE8_O in VARCHAR2
77 ,P_ASS_ATTRIBUTE9_O in VARCHAR2
78 ,P_ASS_ATTRIBUTE10_O in VARCHAR2
79 ,P_ASS_ATTRIBUTE11_O in VARCHAR2
80 ,P_ASS_ATTRIBUTE12_O in VARCHAR2
81 ,P_ASS_ATTRIBUTE13_O in VARCHAR2
82 ,P_ASS_ATTRIBUTE14_O in VARCHAR2
83 ,P_ASS_ATTRIBUTE15_O in VARCHAR2
84 ,P_ASS_ATTRIBUTE16_O in VARCHAR2
85 ,P_ASS_ATTRIBUTE17_O in VARCHAR2
86 ,P_ASS_ATTRIBUTE18_O in VARCHAR2
87 ,P_ASS_ATTRIBUTE19_O in VARCHAR2
88 ,P_ASS_ATTRIBUTE20_O in VARCHAR2
89 ,P_ASS_ATTRIBUTE21_O in VARCHAR2
90 ,P_ASS_ATTRIBUTE22_O in VARCHAR2
91 ,P_ASS_ATTRIBUTE23_O in VARCHAR2
92 ,P_ASS_ATTRIBUTE24_O in VARCHAR2
93 ,P_ASS_ATTRIBUTE25_O in VARCHAR2
94 ,P_ASS_ATTRIBUTE26_O in VARCHAR2
95 ,P_ASS_ATTRIBUTE27_O in VARCHAR2
96 ,P_ASS_ATTRIBUTE28_O in VARCHAR2
97 ,P_ASS_ATTRIBUTE29_O in VARCHAR2
98 ,P_ASS_ATTRIBUTE30_O in VARCHAR2
99 ,P_TITLE_O in VARCHAR2
100 ,P_CONTRACT_ID_O in NUMBER
101 ,P_ESTABLISHMENT_ID_O in NUMBER
102 ,P_COLLECTIVE_AGREEMENT_ID_O in NUMBER
103 ,P_CAGR_GRADE_DEF_ID_O in NUMBER
104 ,P_CAGR_ID_FLEX_NUM_O in NUMBER
105 ,P_OBJECT_VERSION_NUMBER_O in NUMBER
106 ,P_NOTICE_PERIOD_O in NUMBER
107 ,P_NOTICE_PERIOD_UOM_O in VARCHAR2
108 ,P_EMPLOYEE_CATEGORY_O in VARCHAR2
109 ,P_WORK_AT_HOME_O in VARCHAR2
110 ,P_JOB_POST_SOURCE_NAME_O in VARCHAR2
111 ,P_POSTING_CONTENT_ID_O in NUMBER
112 ,P_PLACEMENT_DATE_START_O in DATE
113 ,P_VENDOR_ID_O in NUMBER
114 ,P_VENDOR_EMPLOYEE_NUMBER_O in VARCHAR2
115 ,P_VENDOR_ASSIGNMENT_NUMBER_O in VARCHAR2
116 ,P_ASSIGNMENT_CATEGORY_O in VARCHAR2
117 ,P_PROJECT_TITLE_O in VARCHAR2
118 ,P_APPLICANT_RANK_O in NUMBER
119 ,P_GRADE_LADDER_PGM_ID_O in NUMBER
120 ,P_SUPERVISOR_ASSIGNMENT_ID_O in NUMBER
121 ,P_VENDOR_SITE_ID_O in NUMBER
122 ,P_PO_HEADER_ID_O in NUMBER
123 ,P_PO_LINE_ID_O in NUMBER
124 ,P_PROJECTED_ASSIGNMENT_END_O in DATE
125 )is
126 l_commit_unit_number number;
127 l_legislation_code   varchar2(30);
128 begin
129 hr_utility.set_location('Entering: PER_ASG_RKD.AFTER_DELETE', 10);
130 l_commit_unit_number := hr_api.return_commit_unit;
131 if hr_api.call_app_hooks then
132 PAY_DYT_ALL_ASSIGNMENTS_PKG.AFTER_DELETE
133 (P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
134 ,P_DATETRACK_MODE => P_DATETRACK_MODE
135 ,P_VALIDATION_START_DATE => P_VALIDATION_START_DATE
136 ,P_VALIDATION_END_DATE => P_VALIDATION_END_DATE
137 ,P_ASSIGNMENT_ID => P_ASSIGNMENT_ID
138 ,P_EFFECTIVE_END_DATE => P_EFFECTIVE_END_DATE
139 ,P_EFFECTIVE_START_DATE => P_EFFECTIVE_START_DATE
140 ,P_OBJECT_VERSION_NUMBER => P_OBJECT_VERSION_NUMBER
141 ,P_ORG_NOW_NO_MANAGER_WARNING => P_ORG_NOW_NO_MANAGER_WARNING
142 ,P_APPLICANT_RANK_O => P_APPLICANT_RANK_O
143 ,P_APPLICATION_ID_O => P_APPLICATION_ID_O
144 ,P_ASSIGNMENT_CATEGORY_O => P_ASSIGNMENT_CATEGORY_O
145 ,P_ASSIGNMENT_NUMBER_O => P_ASSIGNMENT_NUMBER_O
146 ,P_ASSIGNMENT_SEQUENCE_O => P_ASSIGNMENT_SEQUENCE_O
147 ,P_ASSIGNMENT_STATUS_TYPE_ID_O => P_ASSIGNMENT_STATUS_TYPE_ID_O
148 ,P_ASSIGNMENT_TYPE_O => P_ASSIGNMENT_TYPE_O
149 ,P_ASS_ATTRIBUTE1_O => P_ASS_ATTRIBUTE1_O
150 ,P_ASS_ATTRIBUTE10_O => P_ASS_ATTRIBUTE10_O
151 ,P_ASS_ATTRIBUTE11_O => P_ASS_ATTRIBUTE11_O
152 ,P_ASS_ATTRIBUTE12_O => P_ASS_ATTRIBUTE12_O
153 ,P_ASS_ATTRIBUTE13_O => P_ASS_ATTRIBUTE13_O
154 ,P_ASS_ATTRIBUTE14_O => P_ASS_ATTRIBUTE14_O
155 ,P_ASS_ATTRIBUTE15_O => P_ASS_ATTRIBUTE15_O
156 ,P_ASS_ATTRIBUTE16_O => P_ASS_ATTRIBUTE16_O
157 ,P_ASS_ATTRIBUTE17_O => P_ASS_ATTRIBUTE17_O
158 ,P_ASS_ATTRIBUTE18_O => P_ASS_ATTRIBUTE18_O
159 ,P_ASS_ATTRIBUTE19_O => P_ASS_ATTRIBUTE19_O
160 ,P_ASS_ATTRIBUTE2_O => P_ASS_ATTRIBUTE2_O
161 ,P_ASS_ATTRIBUTE20_O => P_ASS_ATTRIBUTE20_O
162 ,P_ASS_ATTRIBUTE21_O => P_ASS_ATTRIBUTE21_O
163 ,P_ASS_ATTRIBUTE22_O => P_ASS_ATTRIBUTE22_O
164 ,P_ASS_ATTRIBUTE23_O => P_ASS_ATTRIBUTE23_O
165 ,P_ASS_ATTRIBUTE24_O => P_ASS_ATTRIBUTE24_O
166 ,P_ASS_ATTRIBUTE25_O => P_ASS_ATTRIBUTE25_O
167 ,P_ASS_ATTRIBUTE26_O => P_ASS_ATTRIBUTE26_O
168 ,P_ASS_ATTRIBUTE27_O => P_ASS_ATTRIBUTE27_O
169 ,P_ASS_ATTRIBUTE28_O => P_ASS_ATTRIBUTE28_O
170 ,P_ASS_ATTRIBUTE29_O => P_ASS_ATTRIBUTE29_O
171 ,P_ASS_ATTRIBUTE3_O => P_ASS_ATTRIBUTE3_O
172 ,P_ASS_ATTRIBUTE30_O => P_ASS_ATTRIBUTE30_O
173 ,P_ASS_ATTRIBUTE4_O => P_ASS_ATTRIBUTE4_O
174 ,P_ASS_ATTRIBUTE5_O => P_ASS_ATTRIBUTE5_O
175 ,P_ASS_ATTRIBUTE6_O => P_ASS_ATTRIBUTE6_O
176 ,P_ASS_ATTRIBUTE7_O => P_ASS_ATTRIBUTE7_O
177 ,P_ASS_ATTRIBUTE8_O => P_ASS_ATTRIBUTE8_O
178 ,P_ASS_ATTRIBUTE9_O => P_ASS_ATTRIBUTE9_O
179 ,P_ASS_ATTRIBUTE_CATEGORY_O => P_ASS_ATTRIBUTE_CATEGORY_O
180 ,P_BARGAINING_UNIT_CODE_O => P_BARGAINING_UNIT_CODE_O
181 ,P_BUSINESS_GROUP_ID_O => P_BUSINESS_GROUP_ID_O
182 ,P_CAGR_GRADE_DEF_ID_O => P_CAGR_GRADE_DEF_ID_O
183 ,P_CAGR_ID_FLEX_NUM_O => P_CAGR_ID_FLEX_NUM_O
184 ,P_CHANGE_REASON_O => P_CHANGE_REASON_O
185 ,P_COLLECTIVE_AGREEMENT_ID_O => P_COLLECTIVE_AGREEMENT_ID_O
186 ,P_COMMENT_ID_O => P_COMMENT_ID_O
187 ,P_CONTRACT_ID_O => P_CONTRACT_ID_O
188 ,P_DATE_PROBATION_END_O => P_DATE_PROBATION_END_O
189 ,P_DEFAULT_CODE_COMB_ID_O => P_DEFAULT_CODE_COMB_ID_O
190 ,P_EFFECTIVE_END_DATE_O => P_EFFECTIVE_END_DATE_O
191 ,P_EFFECTIVE_START_DATE_O => P_EFFECTIVE_START_DATE_O
192 ,P_EMPLOYEE_CATEGORY_O => P_EMPLOYEE_CATEGORY_O
193 ,P_EMPLOYMENT_CATEGORY_O => P_EMPLOYMENT_CATEGORY_O
194 ,P_ESTABLISHMENT_ID_O => P_ESTABLISHMENT_ID_O
195 ,P_FREQUENCY_O => P_FREQUENCY_O
196 ,P_GRADE_ID_O => P_GRADE_ID_O
197 ,P_HOURLY_SALARIED_CODE_O => P_HOURLY_SALARIED_CODE_O
198 ,P_INTERNAL_ADDRESS_LINE_O => P_INTERNAL_ADDRESS_LINE_O
199 ,P_JOB_ID_O => P_JOB_ID_O
200 ,P_JOB_POST_SOURCE_NAME_O => P_JOB_POST_SOURCE_NAME_O
201 ,P_LABOUR_UNION_MEMBER_FLAG_O => P_LABOUR_UNION_MEMBER_FLAG_O
202 ,P_LOCATION_ID_O => P_LOCATION_ID_O
203 ,P_MANAGER_FLAG_O => P_MANAGER_FLAG_O
204 ,P_NORMAL_HOURS_O => P_NORMAL_HOURS_O
205 ,P_NOTICE_PERIOD_O => P_NOTICE_PERIOD_O
206 ,P_NOTICE_PERIOD_UOM_O => P_NOTICE_PERIOD_UOM_O
207 ,P_OBJECT_VERSION_NUMBER_O => P_OBJECT_VERSION_NUMBER_O
208 ,P_ORGANIZATION_ID_O => P_ORGANIZATION_ID_O
209 ,P_PAYROLL_ID_O => P_PAYROLL_ID_O
210 ,P_PAY_BASIS_ID_O => P_PAY_BASIS_ID_O
211 ,P_PEOPLE_GROUP_ID_O => P_PEOPLE_GROUP_ID_O
212 ,P_PERF_REVIEW_PERIOD_O => P_PERF_REVIEW_PERIOD_O
213 ,P_PERF_REVIEW_PERIOD_FREQUEN_O => P_PERF_REVIEW_PERIOD_FREQUEN_O
214 ,P_PERIOD_OF_SERVICE_ID_O => P_PERIOD_OF_SERVICE_ID_O
215 ,P_PERSON_ID_O => P_PERSON_ID_O
216 ,P_PERSON_REFERRED_BY_ID_O => P_PERSON_REFERRED_BY_ID_O
217 ,P_PLACEMENT_DATE_START_O => P_PLACEMENT_DATE_START_O
218 ,P_POSITION_ID_O => P_POSITION_ID_O
219 ,P_POSTING_CONTENT_ID_O => P_POSTING_CONTENT_ID_O
220 ,P_PRIMARY_FLAG_O => P_PRIMARY_FLAG_O
221 ,P_PROBATION_PERIOD_O => P_PROBATION_PERIOD_O
222 ,P_PROBATION_UNIT_O => P_PROBATION_UNIT_O
223 ,P_PROGRAM_APPLICATION_ID_O => P_PROGRAM_APPLICATION_ID_O
224 ,P_PROGRAM_ID_O => P_PROGRAM_ID_O
225 ,P_PROGRAM_UPDATE_DATE_O => P_PROGRAM_UPDATE_DATE_O
226 ,P_PROJECT_TITLE_O => P_PROJECT_TITLE_O
227 ,P_RECRUITER_ID_O => P_RECRUITER_ID_O
228 ,P_RECRUITMENT_ACTIVITY_ID_O => P_RECRUITMENT_ACTIVITY_ID_O
229 ,P_REQUEST_ID_O => P_REQUEST_ID_O
230 ,P_SAL_REVIEW_PERIOD_O => P_SAL_REVIEW_PERIOD_O
231 ,P_SAL_REVIEW_PERIOD_FREQUEN_O => P_SAL_REVIEW_PERIOD_FREQUEN_O
232 ,P_SET_OF_BOOKS_ID_O => P_SET_OF_BOOKS_ID_O
233 ,P_SOFT_CODING_KEYFLEX_ID_O => P_SOFT_CODING_KEYFLEX_ID_O
234 ,P_SOURCE_ORGANIZATION_ID_O => P_SOURCE_ORGANIZATION_ID_O
235 ,P_SOURCE_TYPE_O => P_SOURCE_TYPE_O
236 ,P_SPECIAL_CEILING_STEP_ID_O => P_SPECIAL_CEILING_STEP_ID_O
237 ,P_SUPERVISOR_ID_O => P_SUPERVISOR_ID_O
238 ,P_TIME_NORMAL_FINISH_O => P_TIME_NORMAL_FINISH_O
239 ,P_TIME_NORMAL_START_O => P_TIME_NORMAL_START_O
240 ,P_TITLE_O => P_TITLE_O
241 ,P_VACANCY_ID_O => P_VACANCY_ID_O
242 ,P_VENDOR_ASSIGNMENT_NUMBER_O => P_VENDOR_ASSIGNMENT_NUMBER_O
243 ,P_VENDOR_EMPLOYEE_NUMBER_O => P_VENDOR_EMPLOYEE_NUMBER_O
244 ,P_VENDOR_ID_O => P_VENDOR_ID_O
245 ,P_WORK_AT_HOME_O => P_WORK_AT_HOME_O
246 ,P_GRADE_LADDER_PGM_ID_O => P_GRADE_LADDER_PGM_ID_O
247 ,P_SUPERVISOR_ASSIGNMENT_ID_O => P_SUPERVISOR_ASSIGNMENT_ID_O
248 ,P_VENDOR_SITE_ID_O => P_VENDOR_SITE_ID_O
249 ,P_PO_HEADER_ID_O => P_PO_HEADER_ID_O
250 ,P_PO_LINE_ID_O => P_PO_LINE_ID_O
251 ,P_PROJECTED_ASSIGNMENT_END_O => P_PROJECTED_ASSIGNMENT_END_O
252 );
253 end if;
254 hr_api.validate_commit_unit(l_commit_unit_number, 'PER_ALL_ASSIGNMENTS_F', 'AD');
255 hr_utility.set_location(' Leaving: PER_ASG_RKD.AFTER_DELETE', 20);
256 end AFTER_DELETE;
257 end PER_ASG_RKD;