1 package body PER_PER_RKD as
2 /* $Header: peperrhi.pkb 120.14.12010000.3 2008/10/01 06:47:05 generated ship $ */
3 -- Code generated by the Oracle HRMS API Hook Pre-processor
4 -- Created on 2009/03/30 04:46:35 (YYYY/MM/DD HH24:MI:SS)
5 procedure AFTER_DELETE
6 (P_EFFECTIVE_DATE in DATE
7 ,P_VALIDATION_START_DATE in DATE
8 ,P_VALIDATION_END_DATE in DATE
9 ,P_DATETRACK_MODE in VARCHAR2
10 ,P_PERSON_ID in NUMBER
11 ,P_EFFECTIVE_START_DATE in DATE
12 ,P_EFFECTIVE_END_DATE in DATE
13 ,P_OBJECT_VERSION_NUMBER in NUMBER
14 ,P_EFFECTIVE_START_DATE_O in DATE
15 ,P_EFFECTIVE_END_DATE_O in DATE
16 ,P_BUSINESS_GROUP_ID_O in NUMBER
17 ,P_PERSON_TYPE_ID_O in NUMBER
18 ,P_LAST_NAME_O in VARCHAR2
19 ,P_START_DATE_O in DATE
20 ,P_APPLICANT_NUMBER_O in VARCHAR2
21 ,P_COMMENT_ID_O in NUMBER
22 ,P_CURRENT_APPLICANT_FLAG_O in VARCHAR2
23 ,P_CURRENT_EMP_OR_APL_FLAG_O in VARCHAR2
24 ,P_CURRENT_EMPLOYEE_FLAG_O in VARCHAR2
25 ,P_DATE_EMPLOYEE_DATA_VERIFIE_O in DATE
26 ,P_DATE_OF_BIRTH_O in DATE
27 ,P_EMAIL_ADDRESS_O in VARCHAR2
28 ,P_EMPLOYEE_NUMBER_O in VARCHAR2
29 ,P_EXPENSE_CHECK_SEND_TO_ADDR_O in VARCHAR2
30 ,P_FIRST_NAME_O in VARCHAR2
31 ,P_FULL_NAME_O in VARCHAR2
32 ,P_KNOWN_AS_O in VARCHAR2
33 ,P_MARITAL_STATUS_O in VARCHAR2
34 ,P_MIDDLE_NAMES_O in VARCHAR2
35 ,P_NATIONALITY_O in VARCHAR2
36 ,P_NATIONAL_IDENTIFIER_O in VARCHAR2
37 ,P_PREVIOUS_LAST_NAME_O in VARCHAR2
38 ,P_REGISTERED_DISABLED_FLAG_O in VARCHAR2
39 ,P_SEX_O in VARCHAR2
40 ,P_TITLE_O in VARCHAR2
41 ,P_VENDOR_ID_O in NUMBER
42 ,P_WORK_TELEPHONE_O in VARCHAR2
43 ,P_REQUEST_ID_O in NUMBER
44 ,P_PROGRAM_APPLICATION_ID_O in NUMBER
45 ,P_PROGRAM_ID_O in NUMBER
46 ,P_PROGRAM_UPDATE_DATE_O in DATE
47 ,P_ATTRIBUTE_CATEGORY_O in VARCHAR2
48 ,P_ATTRIBUTE1_O in VARCHAR2
49 ,P_ATTRIBUTE2_O in VARCHAR2
50 ,P_ATTRIBUTE3_O in VARCHAR2
51 ,P_ATTRIBUTE4_O in VARCHAR2
52 ,P_ATTRIBUTE5_O in VARCHAR2
53 ,P_ATTRIBUTE6_O in VARCHAR2
54 ,P_ATTRIBUTE7_O in VARCHAR2
55 ,P_ATTRIBUTE8_O in VARCHAR2
56 ,P_ATTRIBUTE9_O in VARCHAR2
57 ,P_ATTRIBUTE10_O in VARCHAR2
58 ,P_ATTRIBUTE11_O in VARCHAR2
59 ,P_ATTRIBUTE12_O in VARCHAR2
60 ,P_ATTRIBUTE13_O in VARCHAR2
61 ,P_ATTRIBUTE14_O in VARCHAR2
62 ,P_ATTRIBUTE15_O in VARCHAR2
63 ,P_ATTRIBUTE16_O in VARCHAR2
64 ,P_ATTRIBUTE17_O in VARCHAR2
65 ,P_ATTRIBUTE18_O in VARCHAR2
66 ,P_ATTRIBUTE19_O in VARCHAR2
67 ,P_ATTRIBUTE20_O in VARCHAR2
68 ,P_ATTRIBUTE21_O in VARCHAR2
69 ,P_ATTRIBUTE22_O in VARCHAR2
70 ,P_ATTRIBUTE23_O in VARCHAR2
71 ,P_ATTRIBUTE24_O in VARCHAR2
72 ,P_ATTRIBUTE25_O in VARCHAR2
73 ,P_ATTRIBUTE26_O in VARCHAR2
74 ,P_ATTRIBUTE27_O in VARCHAR2
75 ,P_ATTRIBUTE28_O in VARCHAR2
76 ,P_ATTRIBUTE29_O in VARCHAR2
77 ,P_ATTRIBUTE30_O in VARCHAR2
78 ,P_PER_INFORMATION_CATEGORY_O in VARCHAR2
79 ,P_PER_INFORMATION1_O in VARCHAR2
80 ,P_PER_INFORMATION2_O in VARCHAR2
81 ,P_PER_INFORMATION3_O in VARCHAR2
82 ,P_PER_INFORMATION4_O in VARCHAR2
83 ,P_PER_INFORMATION5_O in VARCHAR2
84 ,P_PER_INFORMATION6_O in VARCHAR2
85 ,P_PER_INFORMATION7_O in VARCHAR2
86 ,P_PER_INFORMATION8_O in VARCHAR2
87 ,P_PER_INFORMATION9_O in VARCHAR2
88 ,P_PER_INFORMATION10_O in VARCHAR2
89 ,P_PER_INFORMATION11_O in VARCHAR2
90 ,P_PER_INFORMATION12_O in VARCHAR2
91 ,P_PER_INFORMATION13_O in VARCHAR2
92 ,P_PER_INFORMATION14_O in VARCHAR2
93 ,P_PER_INFORMATION15_O in VARCHAR2
94 ,P_PER_INFORMATION16_O in VARCHAR2
95 ,P_PER_INFORMATION17_O in VARCHAR2
96 ,P_PER_INFORMATION18_O in VARCHAR2
97 ,P_PER_INFORMATION19_O in VARCHAR2
98 ,P_PER_INFORMATION20_O in VARCHAR2
99 ,P_SUFFIX_O in VARCHAR2
100 ,P_DATE_OF_DEATH_O in DATE
101 ,P_BACKGROUND_CHECK_STATUS_O in VARCHAR2
102 ,P_BACKGROUND_DATE_CHECK_O in DATE
103 ,P_BLOOD_TYPE_O in VARCHAR2
104 ,P_CORRESPONDENCE_LANGUAGE_O in VARCHAR2
105 ,P_FAST_PATH_EMPLOYEE_O in VARCHAR2
106 ,P_FTE_CAPACITY_O in NUMBER
107 ,P_HOLD_APPLICANT_DATE_UNTIL_O in DATE
108 ,P_HONORS_O in VARCHAR2
109 ,P_INTERNAL_LOCATION_O in VARCHAR2
110 ,P_LAST_MEDICAL_TEST_BY_O in VARCHAR2
111 ,P_LAST_MEDICAL_TEST_DATE_O in DATE
112 ,P_MAILSTOP_O in VARCHAR2
113 ,P_OFFICE_NUMBER_O in VARCHAR2
114 ,P_ON_MILITARY_SERVICE_O in VARCHAR2
115 ,P_ORDER_NAME_O in VARCHAR2
116 ,P_PRE_NAME_ADJUNCT_O in VARCHAR2
117 ,P_PROJECTED_START_DATE_O in DATE
118 ,P_REHIRE_AUTHORIZOR_O in VARCHAR2
119 ,P_REHIRE_RECOMMENDATION_O in VARCHAR2
120 ,P_RESUME_EXISTS_O in VARCHAR2
121 ,P_RESUME_LAST_UPDATED_O in DATE
122 ,P_SECOND_PASSPORT_EXISTS_O in VARCHAR2
123 ,P_STUDENT_STATUS_O in VARCHAR2
124 ,P_WORK_SCHEDULE_O in VARCHAR2
125 ,P_PER_INFORMATION21_O in VARCHAR2
126 ,P_PER_INFORMATION22_O in VARCHAR2
127 ,P_PER_INFORMATION23_O in VARCHAR2
128 ,P_PER_INFORMATION24_O in VARCHAR2
129 ,P_PER_INFORMATION25_O in VARCHAR2
130 ,P_PER_INFORMATION26_O in VARCHAR2
131 ,P_PER_INFORMATION27_O in VARCHAR2
132 ,P_PER_INFORMATION28_O in VARCHAR2
133 ,P_PER_INFORMATION29_O in VARCHAR2
134 ,P_PER_INFORMATION30_O in VARCHAR2
135 ,P_REHIRE_REASON_O in VARCHAR2
136 ,P_BENEFIT_GROUP_ID_O in VARCHAR2
137 ,P_RECEIPT_OF_DEATH_CERT_DATE_O in DATE
138 ,P_COORD_BEN_MED_PLN_NO_O in VARCHAR2
139 ,P_COORD_BEN_NO_CVG_FLAG_O in VARCHAR2
140 ,P_COORD_BEN_MED_EXT_ER_O in VARCHAR2
141 ,P_COORD_BEN_MED_PL_NAME_O in VARCHAR2
142 ,P_COORD_BEN_MED_INSR_CRR_NAM_O in VARCHAR2
143 ,P_COORD_BEN_MED_INSR_CRR_IDE_O in VARCHAR2
144 ,P_COORD_BEN_MED_CVG_STRT_DT_O in DATE
145 ,P_COORD_BEN_MED_CVG_END_DT_O in DATE
146 ,P_USES_TOBACCO_FLAG_O in VARCHAR2
147 ,P_DPDNT_ADOPTION_DATE_O in DATE
148 ,P_DPDNT_VLNTRY_SVCE_FLAG_O in VARCHAR2
149 ,P_ORIGINAL_DATE_OF_HIRE_O in DATE
150 ,P_TOWN_OF_BIRTH_O in VARCHAR2
151 ,P_REGION_OF_BIRTH_O in VARCHAR2
152 ,P_COUNTRY_OF_BIRTH_O in VARCHAR2
153 ,P_GLOBAL_PERSON_ID_O in VARCHAR2
154 ,P_PARTY_ID_O in NUMBER
155 ,P_NPW_NUMBER_O in VARCHAR2
156 ,P_CURRENT_NPW_FLAG_O in VARCHAR2
157 ,P_GLOBAL_NAME_O in VARCHAR2
158 ,P_LOCAL_NAME_O in VARCHAR2
159 ,P_OBJECT_VERSION_NUMBER_O in NUMBER
160 )is
161 begin
162 hr_utility.set_location('Entering: PER_PER_RKD.AFTER_DELETE', 10);
163 hr_utility.set_location(' Leaving: PER_PER_RKD.AFTER_DELETE', 20);
164 end AFTER_DELETE;
165 end PER_PER_RKD;
[Home] [Help]