DBA Data[Home] [Help]

PACKAGE BODY: APPS.BEN_CPI_RKD

Source


1 package body BEN_CPI_RKD as
2 /* $Header: becpirhi.pkb 120.0 2005/05/28 01:13:52 generated noship $ */
3 -- Code generated by the Oracle HRMS API Hook Pre-processor
4 -- Created on 2007/01/03 21:30:55 (YYYY/MM/DD HH24:MI:SS)
5 procedure AFTER_DELETE
6 (P_GROUP_PER_IN_LER_ID in NUMBER
7 ,P_ASSIGNMENT_ID_O in NUMBER
8 ,P_PERSON_ID_O in NUMBER
9 ,P_SUPERVISOR_ID_O in NUMBER
10 ,P_EFFECTIVE_DATE_O in DATE
11 ,P_FULL_NAME_O in VARCHAR2
12 ,P_BRIEF_NAME_O in VARCHAR2
13 ,P_CUSTOM_NAME_O in VARCHAR2
14 ,P_SUPERVISOR_FULL_NAME_O in VARCHAR2
15 ,P_SUPERVISOR_BRIEF_NAME_O in VARCHAR2
16 ,P_SUPERVISOR_CUSTOM_NAME_O in VARCHAR2
17 ,P_LEGISLATION_CODE_O in VARCHAR2
18 ,P_YEARS_EMPLOYED_O in NUMBER
19 ,P_YEARS_IN_JOB_O in NUMBER
20 ,P_YEARS_IN_POSITION_O in NUMBER
21 ,P_YEARS_IN_GRADE_O in NUMBER
22 ,P_EMPLOYEE_NUMBER_O in VARCHAR2
23 ,P_START_DATE_O in DATE
24 ,P_ORIGINAL_START_DATE_O in DATE
25 ,P_ADJUSTED_SVC_DATE_O in DATE
26 ,P_BASE_SALARY_O in NUMBER
27 ,P_BASE_SALARY_CHANGE_DATE_O in DATE
28 ,P_PAYROLL_NAME_O in VARCHAR2
29 ,P_PERFORMANCE_RATING_O in VARCHAR2
30 ,P_PERFORMANCE_RATING_TYPE_O in VARCHAR2
31 ,P_PERFORMANCE_RATING_DATE_O in DATE
32 ,P_BUSINESS_GROUP_ID_O in NUMBER
33 ,P_ORGANIZATION_ID_O in NUMBER
34 ,P_JOB_ID_O in NUMBER
35 ,P_GRADE_ID_O in NUMBER
36 ,P_POSITION_ID_O in NUMBER
37 ,P_PEOPLE_GROUP_ID_O in NUMBER
38 ,P_SOFT_CODING_KEYFLEX_ID_O in NUMBER
39 ,P_LOCATION_ID_O in NUMBER
40 ,P_PAY_RATE_ID_O in NUMBER
41 ,P_ASSIGNMENT_STATUS_TYPE_ID_O in NUMBER
42 ,P_FREQUENCY_O in VARCHAR2
43 ,P_GRADE_ANNULIZATION_FACTOR_O in NUMBER
44 ,P_PAY_ANNULIZATION_FACTOR_O in NUMBER
45 ,P_GRD_MIN_VAL_O in NUMBER
46 ,P_GRD_MAX_VAL_O in NUMBER
47 ,P_GRD_MID_POINT_O in NUMBER
48 ,P_GRD_QUARTILE_O in VARCHAR2
49 ,P_GRD_COMPARATIO_O in NUMBER
50 ,P_EMP_CATEGORY_O in VARCHAR2
51 ,P_CHANGE_REASON_O in VARCHAR2
52 ,P_NORMAL_HOURS_O in NUMBER
53 ,P_EMAIL_ADDRESS_O in VARCHAR2
54 ,P_BASE_SALARY_FREQUENCY_O in VARCHAR2
55 ,P_NEW_ASSGN_OVN_O in NUMBER
56 ,P_NEW_PERF_EVENT_ID_O in NUMBER
57 ,P_NEW_PERF_REVIEW_ID_O in NUMBER
58 ,P_POST_PROCESS_STAT_CD_O in VARCHAR2
59 ,P_FEEDBACK_RATING_O in VARCHAR2
60 ,P_FEEDBACK_COMMENTS_O in VARCHAR2
61 ,P_OBJECT_VERSION_NUMBER_O in NUMBER
62 ,P_CUSTOM_SEGMENT1_O in VARCHAR2
63 ,P_CUSTOM_SEGMENT2_O in VARCHAR2
64 ,P_CUSTOM_SEGMENT3_O in VARCHAR2
65 ,P_CUSTOM_SEGMENT4_O in VARCHAR2
66 ,P_CUSTOM_SEGMENT5_O in VARCHAR2
67 ,P_CUSTOM_SEGMENT6_O in VARCHAR2
68 ,P_CUSTOM_SEGMENT7_O in VARCHAR2
69 ,P_CUSTOM_SEGMENT8_O in VARCHAR2
70 ,P_CUSTOM_SEGMENT9_O in VARCHAR2
71 ,P_CUSTOM_SEGMENT10_O in VARCHAR2
72 ,P_CUSTOM_SEGMENT11_O in NUMBER
73 ,P_CUSTOM_SEGMENT12_O in NUMBER
74 ,P_CUSTOM_SEGMENT13_O in NUMBER
75 ,P_CUSTOM_SEGMENT14_O in NUMBER
76 ,P_CUSTOM_SEGMENT15_O in NUMBER
77 ,P_CUSTOM_SEGMENT16_O in NUMBER
78 ,P_CUSTOM_SEGMENT17_O in NUMBER
79 ,P_CUSTOM_SEGMENT18_O in NUMBER
80 ,P_CUSTOM_SEGMENT19_O in NUMBER
81 ,P_CUSTOM_SEGMENT20_O in NUMBER
82 ,P_PEOPLE_GROUP_NAME_O in VARCHAR2
83 ,P_PEOPLE_GROUP_SEGMENT1_O in VARCHAR2
84 ,P_PEOPLE_GROUP_SEGMENT2_O in VARCHAR2
85 ,P_PEOPLE_GROUP_SEGMENT3_O in VARCHAR2
86 ,P_PEOPLE_GROUP_SEGMENT4_O in VARCHAR2
87 ,P_PEOPLE_GROUP_SEGMENT5_O in VARCHAR2
88 ,P_PEOPLE_GROUP_SEGMENT6_O in VARCHAR2
89 ,P_PEOPLE_GROUP_SEGMENT7_O in VARCHAR2
90 ,P_PEOPLE_GROUP_SEGMENT8_O in VARCHAR2
91 ,P_PEOPLE_GROUP_SEGMENT9_O in VARCHAR2
92 ,P_PEOPLE_GROUP_SEGMENT10_O in VARCHAR2
93 ,P_PEOPLE_GROUP_SEGMENT11_O in VARCHAR2
94 ,P_ASS_ATTRIBUTE_CATEGORY_O in VARCHAR2
95 ,P_ASS_ATTRIBUTE1_O in VARCHAR2
96 ,P_ASS_ATTRIBUTE2_O in VARCHAR2
97 ,P_ASS_ATTRIBUTE3_O in VARCHAR2
98 ,P_ASS_ATTRIBUTE4_O in VARCHAR2
99 ,P_ASS_ATTRIBUTE5_O in VARCHAR2
100 ,P_ASS_ATTRIBUTE6_O in VARCHAR2
101 ,P_ASS_ATTRIBUTE7_O in VARCHAR2
102 ,P_ASS_ATTRIBUTE8_O in VARCHAR2
103 ,P_ASS_ATTRIBUTE9_O in VARCHAR2
104 ,P_ASS_ATTRIBUTE10_O in VARCHAR2
105 ,P_ASS_ATTRIBUTE11_O in VARCHAR2
106 ,P_ASS_ATTRIBUTE12_O in VARCHAR2
107 ,P_ASS_ATTRIBUTE13_O in VARCHAR2
108 ,P_ASS_ATTRIBUTE14_O in VARCHAR2
109 ,P_ASS_ATTRIBUTE15_O in VARCHAR2
110 ,P_ASS_ATTRIBUTE16_O in VARCHAR2
111 ,P_ASS_ATTRIBUTE17_O in VARCHAR2
112 ,P_ASS_ATTRIBUTE18_O in VARCHAR2
113 ,P_ASS_ATTRIBUTE19_O in VARCHAR2
114 ,P_ASS_ATTRIBUTE20_O in VARCHAR2
115 ,P_ASS_ATTRIBUTE21_O in VARCHAR2
116 ,P_ASS_ATTRIBUTE22_O in VARCHAR2
117 ,P_ASS_ATTRIBUTE23_O in VARCHAR2
118 ,P_ASS_ATTRIBUTE24_O in VARCHAR2
119 ,P_ASS_ATTRIBUTE25_O in VARCHAR2
120 ,P_ASS_ATTRIBUTE26_O in VARCHAR2
121 ,P_ASS_ATTRIBUTE27_O in VARCHAR2
122 ,P_ASS_ATTRIBUTE28_O in VARCHAR2
123 ,P_ASS_ATTRIBUTE29_O in VARCHAR2
124 ,P_ASS_ATTRIBUTE30_O in VARCHAR2
125 ,P_WS_COMMENTS_O in VARCHAR2
126 ,P_CPI_ATTRIBUTE_CATEGORY_O in VARCHAR2
127 ,P_CPI_ATTRIBUTE1_O in VARCHAR2
128 ,P_CPI_ATTRIBUTE2_O in VARCHAR2
129 ,P_CPI_ATTRIBUTE3_O in VARCHAR2
130 ,P_CPI_ATTRIBUTE4_O in VARCHAR2
131 ,P_CPI_ATTRIBUTE5_O in VARCHAR2
132 ,P_CPI_ATTRIBUTE6_O in VARCHAR2
133 ,P_CPI_ATTRIBUTE7_O in VARCHAR2
134 ,P_CPI_ATTRIBUTE8_O in VARCHAR2
135 ,P_CPI_ATTRIBUTE9_O in VARCHAR2
136 ,P_CPI_ATTRIBUTE10_O in VARCHAR2
137 ,P_CPI_ATTRIBUTE11_O in VARCHAR2
138 ,P_CPI_ATTRIBUTE12_O in VARCHAR2
139 ,P_CPI_ATTRIBUTE13_O in VARCHAR2
140 ,P_CPI_ATTRIBUTE14_O in VARCHAR2
141 ,P_CPI_ATTRIBUTE15_O in VARCHAR2
142 ,P_CPI_ATTRIBUTE16_O in VARCHAR2
143 ,P_CPI_ATTRIBUTE17_O in VARCHAR2
144 ,P_CPI_ATTRIBUTE18_O in VARCHAR2
145 ,P_CPI_ATTRIBUTE19_O in VARCHAR2
146 ,P_CPI_ATTRIBUTE20_O in VARCHAR2
147 ,P_CPI_ATTRIBUTE21_O in VARCHAR2
148 ,P_CPI_ATTRIBUTE22_O in VARCHAR2
149 ,P_CPI_ATTRIBUTE23_O in VARCHAR2
150 ,P_CPI_ATTRIBUTE24_O in VARCHAR2
151 ,P_CPI_ATTRIBUTE25_O in VARCHAR2
152 ,P_CPI_ATTRIBUTE26_O in VARCHAR2
153 ,P_CPI_ATTRIBUTE27_O in VARCHAR2
154 ,P_CPI_ATTRIBUTE28_O in VARCHAR2
155 ,P_CPI_ATTRIBUTE29_O in VARCHAR2
156 ,P_CPI_ATTRIBUTE30_O in VARCHAR2
157 ,P_FEEDBACK_DATE_O in DATE
158 )is
159 begin
160 hr_utility.set_location('Entering: BEN_CPI_RKD.AFTER_DELETE', 10);
161 hr_utility.set_location(' Leaving: BEN_CPI_RKD.AFTER_DELETE', 20);
162 end AFTER_DELETE;
163 end BEN_CPI_RKD;