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

Source


1 package body GHR_CMP_RKD as
2 /* $Header: ghcmprhi.pkb 120.0 2005/05/29 02:54:02 generated noship $ */
3 -- Code generated by the Oracle HRMS API Hook Pre-processor
4 -- Created on 2007/01/03 21:51:35 (YYYY/MM/DD HH24:MI:SS)
5 procedure AFTER_DELETE
6 (P_COMPLAINT_ID in NUMBER
7 ,P_COMPLAINANT_PERSON_ID_O in NUMBER
8 ,P_BUSINESS_GROUP_ID_O in NUMBER
9 ,P_DOCKET_NUMBER_O in VARCHAR2
10 ,P_STAGE_O in VARCHAR2
11 ,P_CLASS_FLAG_O in VARCHAR2
12 ,P_MIXED_FLAG_O in VARCHAR2
13 ,P_CONSOLIDATED_FLAG_O in VARCHAR2
14 ,P_REMAND_FLAG_O in VARCHAR2
15 ,P_ACTIVE_FLAG_O in VARCHAR2
16 ,P_INFORMATION_INQUIRY_O in DATE
17 ,P_PCOM_INIT_O in DATE
18 ,P_ALLEG_INCIDENT_O in DATE
19 ,P_ALLEG_DISCRIM_ORG_ID_O in NUMBER
20 ,P_RR_LTR_DATE_O in DATE
21 ,P_RR_LTR_RECVD_O in DATE
22 ,P_PRE_COM_ELEC_O in VARCHAR2
23 ,P_CLASS_AGENT_FLAG_O in VARCHAR2
24 ,P_PRE_COM_DESC_O in VARCHAR2
25 ,P_COUNSELOR_ASG_O in DATE
26 ,P_INIT_COUNSELOR_INTERVIEW_O in DATE
27 ,P_ANONYMITY_REQUESTED_O in VARCHAR2
28 ,P_COUNSEL_EXT_LTR_O in DATE
29 ,P_TRADITIONAL_COUNSEL_OUTCOM_O in VARCHAR2
30 ,P_FINAL_INTERVIEW_O in DATE
31 ,P_NOTICE_RTF_RECVD_O in DATE
32 ,P_PRECOM_CLOSED_O in DATE
33 ,P_PRECOM_CLOSURE_NATURE_O in VARCHAR2
34 ,P_COUNSELOR_RPT_SUB_O in DATE
35 ,P_HR_OFFICE_ORG_ID_O in NUMBER
36 ,P_EEO_OFFICE_ORG_ID_O in NUMBER
37 ,P_SERVICED_ORG_ID_O in NUMBER
38 ,P_FORMAL_COM_FILED_O in DATE
39 ,P_ACK_LTR_O in DATE
40 ,P_CLARIFICATION_LTR_DATE_O in DATE
41 ,P_CLARIFICATION_RESPONSE_REC_O in DATE
42 ,P_FORWARDED_LEGAL_REVIEW_O in DATE
43 ,P_RETURNED_FROM_LEGAL_O in DATE
44 ,P_LETTER_TYPE_O in VARCHAR2
45 ,P_LETTER_DATE_O in DATE
46 ,P_LETTER_RECVD_O in DATE
47 ,P_INVESTIGATION_SOURCE_O in VARCHAR2
48 ,P_INVESTIGATOR_RECVD_REQ_O in DATE
49 ,P_AGENCY_INVESTIGATOR_REQ_O in DATE
50 ,P_INVESTIGATOR_ASG_O in DATE
51 ,P_INVESTIGATION_START_O in DATE
52 ,P_INVESTIGATION_END_O in DATE
53 ,P_INVESTIGATION_EXTENDED_O in DATE
54 ,P_INVEST_EXTENSION_DESC_O in VARCHAR2
55 ,P_AGENCY_RECVD_ROI_O in DATE
56 ,P_COMREP_RECVD_ROI_O in DATE
57 ,P_OPTIONS_LTR_DATE_O in DATE
58 ,P_COMREP_RECVD_OPT_LTR_O in DATE
59 ,P_COMREP_OPT_LTR_RESPONSE_O in VARCHAR2
60 ,P_RESOLUTION_OFFER_O in DATE
61 ,P_COMREP_RESOL_OFFER_RECVD_O in DATE
62 ,P_COMREP_RESOL_OFFER_RESPONS_O in DATE
63 ,P_COMREP_RESOL_OFFER_DESC_O in VARCHAR2
64 ,P_RESOL_OFFER_SIGNED_O in DATE
65 ,P_RESOL_OFFER_DESC_O in VARCHAR2
66 ,P_HEARING_SOURCE_O in VARCHAR2
67 ,P_AGENCY_NOTIFIED_HEARING_O in DATE
68 ,P_EEOC_HEARING_DOCKET_NUM_O in VARCHAR2
69 ,P_HEARING_COMPLETE_O in DATE
70 ,P_AJ_MERIT_DECISION_DATE_O in DATE
71 ,P_AGENCY_RECVD_AJ_MERIT_DEC_O in DATE
72 ,P_AJ_MERIT_DECISION_O in VARCHAR2
73 ,P_AJ_CA_DECISION_DATE_O in DATE
74 ,P_AGENCY_RECVD_AJ_CA_DEC_O in DATE
75 ,P_AJ_CA_DECISION_O in VARCHAR2
76 ,P_FAD_REQUESTED_O in DATE
77 ,P_MERIT_FAD_O in VARCHAR2
78 ,P_ATTORNEY_FEES_FAD_O in VARCHAR2
79 ,P_COMP_DAMAGES_FAD_O in VARCHAR2
80 ,P_NON_COMPLIANCE_FAD_O in VARCHAR2
81 ,P_FAD_REQ_RECVD_EEO_OFFICE_O in DATE
82 ,P_FAD_REQ_FORWD_TO_AGENCY_O in DATE
83 ,P_AGENCY_RECVD_REQUEST_O in DATE
84 ,P_FAD_DUE_O in DATE
85 ,P_FAD_DATE_O in DATE
86 ,P_FAD_DECISION_O in VARCHAR2
87 ,P_FAD_FORWD_TO_COMREP_O in DATE
88 ,P_FAD_RECVD_BY_COMREP_O in DATE
89 ,P_FAD_IMP_LTR_FORWD_TO_ORG_O in DATE
90 ,P_FAD_DECISION_FORWD_LEGAL_O in DATE
91 ,P_FAD_DECISION_RECVD_LEGAL_O in DATE
92 ,P_FA_SOURCE_O in VARCHAR2
93 ,P_FINAL_ACTION_DUE_O in DATE
94 ,P_FINAL_ACT_FORWD_COMREP_O in DATE
95 ,P_FINAL_ACT_RECVD_COMREP_O in DATE
96 ,P_FINAL_ACTION_DECISION_DATE_O in DATE
97 ,P_FINAL_ACTION_DECISION_O in VARCHAR2
98 ,P_FA_IMP_LTR_FORWD_TO_ORG_O in DATE
99 ,P_FA_DECISION_FORWD_LEGAL_O in DATE
100 ,P_FA_DECISION_RECVD_LEGAL_O in DATE
101 ,P_CIVIL_ACTION_FILED_O in DATE
102 ,P_AGENCY_CLOSURE_CONFIRMED_O in DATE
103 ,P_CONSOLIDATED_COMPLAINT_ID_O in NUMBER
104 ,P_CONSOLIDATED_O in DATE
105 ,P_STAGE_OF_CONSOLIDATION_O in VARCHAR2
106 ,P_COMREP_NOTIF_CONSOLIDATION_O in DATE
107 ,P_CONSOLIDATION_DESC_O in VARCHAR2
108 ,P_COMPLAINT_CLOSED_O in DATE
109 ,P_NATURE_OF_CLOSURE_O in VARCHAR2
110 ,P_COMPLAINT_CLOSED_DESC_O in VARCHAR2
111 ,P_FILED_FORMAL_CLASS_O in DATE
112 ,P_FORWD_EEOC_O in DATE
113 ,P_AJ_CERT_DECISION_DATE_O in DATE
114 ,P_AJ_CERT_DECISION_RECVD_O in DATE
115 ,P_AJ_CERT_DECISION_O in VARCHAR2
116 ,P_CLASS_MEMBERS_NOTIFIED_O in DATE
117 ,P_NUMBER_OF_COMPLAINTANTS_O in NUMBER
118 ,P_CLASS_HEARING_O in DATE
119 ,P_AJ_DEC_O in DATE
120 ,P_AGENCY_RECVD_AJ_DEC_O in DATE
121 ,P_AJ_DECISION_O in VARCHAR2
122 ,P_OBJECT_VERSION_NUMBER_O in NUMBER
123 ,P_AGENCY_BRIEF_EEOC_O in DATE
124 ,P_AGENCY_NOTIF_OF_CIVIL_ACTI_O in DATE
125 ,P_FAD_SOURCE_O in VARCHAR2
126 ,P_AGENCY_FILES_FORWARDED_EEO_O in DATE
127 ,P_HEARING_REQ_O in DATE
128 ,P_AGENCY_CODE_O in VARCHAR2
129 ,P_AUDITED_BY_O in VARCHAR2
130 ,P_RECORD_RECEIVED_O in DATE
131 ,P_ATTRIBUTE_CATEGORY_O in VARCHAR2
132 ,P_ATTRIBUTE1_O in VARCHAR2
133 ,P_ATTRIBUTE2_O in VARCHAR2
134 ,P_ATTRIBUTE3_O in VARCHAR2
135 ,P_ATTRIBUTE4_O in VARCHAR2
136 ,P_ATTRIBUTE5_O in VARCHAR2
137 ,P_ATTRIBUTE6_O in VARCHAR2
138 ,P_ATTRIBUTE7_O in VARCHAR2
139 ,P_ATTRIBUTE8_O in VARCHAR2
140 ,P_ATTRIBUTE9_O in VARCHAR2
141 ,P_ATTRIBUTE10_O in VARCHAR2
142 ,P_ATTRIBUTE11_O in VARCHAR2
143 ,P_ATTRIBUTE12_O in VARCHAR2
144 ,P_ATTRIBUTE13_O in VARCHAR2
145 ,P_ATTRIBUTE14_O in VARCHAR2
146 ,P_ATTRIBUTE15_O in VARCHAR2
147 ,P_ATTRIBUTE16_O in VARCHAR2
148 ,P_ATTRIBUTE17_O in VARCHAR2
149 ,P_ATTRIBUTE18_O in VARCHAR2
150 ,P_ATTRIBUTE19_O in VARCHAR2
151 ,P_ATTRIBUTE20_O in VARCHAR2
152 ,P_ATTRIBUTE21_O in VARCHAR2
153 ,P_ATTRIBUTE22_O in VARCHAR2
154 ,P_ATTRIBUTE23_O in VARCHAR2
155 ,P_ATTRIBUTE24_O in VARCHAR2
156 ,P_ATTRIBUTE25_O in VARCHAR2
157 ,P_ATTRIBUTE26_O in VARCHAR2
158 ,P_ATTRIBUTE27_O in VARCHAR2
159 ,P_ATTRIBUTE28_O in VARCHAR2
160 ,P_ATTRIBUTE29_O in VARCHAR2
161 ,P_ATTRIBUTE30_O in VARCHAR2
162 )is
163 begin
164 hr_utility.set_location('Entering: GHR_CMP_RKD.AFTER_DELETE', 10);
165 hr_utility.set_location(' Leaving: GHR_CMP_RKD.AFTER_DELETE', 20);
166 end AFTER_DELETE;
167 end GHR_CMP_RKD;