[Home] [Help]
PACKAGE: APPS.HR_WPM_MASS_APR_PUSH
Source
1 PACKAGE hr_wpm_mass_apr_push AUTHID CURRENT_USER AS
2 /* $Header: pewpmaprpush.pkh 120.6.12020000.4 2013/01/16 07:17:24 schowdhu ship $ */
3 --
4 -- Package global constants.
5 --
6 g_no_debug CONSTANT NUMBER := 0;
7 g_pipe CONSTANT NUMBER := 1;
8 g_fnd_log CONSTANT NUMBER := 2;
9 --
10 g_regular_log CONSTANT NUMBER := 1;
11 g_debug_log CONSTANT NUMBER := 2;
12 --
13 success CONSTANT NUMBER := 0;
14 warning CONSTANT NUMBER := 1;
15 error CONSTANT NUMBER := 2;
16 --
17 -- Package global variables.
18 --
19 g_errbuf VARCHAR2 (2000);
20 g_retcode NUMBER;
21
22 --
23 -- ----------------------------------------------------------------------------
24 -- |---------------------< submit_apprisal_cp >---------------------------|
25 -- ----------------------------------------------------------------------------
26 -- {Start Of Comments}
27 --
28 -- Description: Publish Performance Management Plan APIs and concurrent program
29 -- calls this procedure.
30 --
31 --
32 -- Prerequisites:
33 --
34 --
35 -- In Parameters:
36 -- Name Reqd Type Description
37 --
38 --
39 -- Post Success:
40 --
41 --
42 -- Name Type Description
43 --
44 -- Post Failure:
45 --
46 --
47 -- Access Status:
48 -- Internal Development Use Only.
49 --
50 -- {End Of Comments}
51 --
52 --
53 PROCEDURE submit_appraisal_cp (
54 p_effective_date in date
55 ,p_start_date in varchar2
56 ,p_plan_id in number
57 ,p_appraisal_period_id in number
58 ,p_log_output in varchar2
59 );
60
61 --
62 -- ----------------------------------------------------------------------------
63 -- |---------------------------< appraisal_cp >----------------------------|
64 -- ----------------------------------------------------------------------------
65 -- {Start Of Comments}
66 --
67 -- Description: Publish Performance Management Plan APIs and concurrent program
68 -- calls this procedure.
69 --
70 --
71 -- Prerequisites:
72 --
73 --
74 -- In Parameters:
75 -- Name Reqd Type Description
76 --
77 --
78 -- Post Success:
79 --
80 --
81 -- Name Type Description
82 --
83 -- Post Failure:
84 --
85 --
86 -- Access Status:
87 -- Internal Development Use Only.
88 --
89 -- {End Of Comments}
90 --
91 --
92 procedure appraisal_cp
93 (errbuf out nocopy varchar2
94 ,retcode out nocopy number
95 ,p_effective_date in varchar2
96 ,p_plan_id in number
97 ,p_appraisal_period_id in number
98 ,p_log_output in varchar2 default 'N'
99 ,p_delete_pending_trans IN VARCHAR2 DEFAULT 'N'
100 );
101
102 --
103 -- ----------------------------------------------------------------------------
104 -- |-----------------------------< appraisal_push>-----------------------------|
105 -- ----------------------------------------------------------------------------
106 -- {Start Of Comments}
107 --
108 -- Description: Publish Performance Management Plan APIs and concurrent program
109 -- calls this procedure.
110 --
111 --
112 -- Prerequisites:
113 --
114 --
115 -- In Parameters:
116 -- Name Reqd Type Description
117 --
118 --
119 -- Post Success:
120 --
121 --
122 -- Name Type Description
123 --
124 -- Post Failure:
125 --
126 --
127 -- Access Status:
128 -- Internal Development Use Only.
129 --
130 -- {End Of Comments}
131 --
132 --
133 procedure appraisal_push
134 (p_effective_date in date
135 ,p_plan_id in number
136 ,p_appraisal_period_id in number
137 ,p_log_output in varchar2
138 );
139
140 --
141
142 -- ----------------------------------------------------------------------------
143 -- |----------------------< create_appraisal_for_person >---------------------|
144 -- ----------------------------------------------------------------------------
145 -- {Start Of Comments}
146 --
147 -- Description:
148 -- Creates Appraisal for a given person when plan is published.
149 --
150 -- Prerequisites:
151 -- None.
152 --
153 -- In Arguments:
154 --
155 --
156 -- Post Success:
157 -- Processing continues if Appraisal is created.
158 --
159 -- Post Failure:
160 -- An application error is raised if scorecard is not created.
161 --
162 -- Access Status:
163 -- Internal Only.
164 --
165 -- {End Of Comments}
166 -- ----------------------------------------------------------------------------
167 PROCEDURE create_appraisal_for_person
168 ( p_score_card_id per_personal_scorecards.scorecard_id%TYPE,
169 p_appraisal_templ_id per_appraisal_templates.appraisal_template_id%TYPE,
170 p_effective_date DATE,
171 p_appraisal_start_date DATE,
172 p_appraisal_end_date DATE,
173 p_appraisal_status per_appraisals.status%TYPE DEFAULT 'PLANNED',
174 p_type per_appraisals.TYPE%TYPE DEFAULT NULL,
175 p_appraisal_date per_appraisals.appraisal_date%TYPE,
176 -- p_appraisal_system_status per_appraisals.appraisal_system_status%TYPE,
177 p_plan_id NUMBER,
178 p_next_appraisal_date per_appraisals.next_appraisal_date%TYPE default
179 null,
180 p_status per_appraisals.status%TYPE DEFAULT NULL,
181 p_comments per_appraisals.comments%TYPE DEFAULT NULL,
182 p_appraisee_access per_appraisals.appraisee_access%TYPE default null,
183 p_appraisal_initiator per_appraisal_periods.initiator_code%TYPE,
184 p_appraisal_system_type IN per_appraisal_periods.appraisal_system_type%TYPE,
185 p_participation_type IN per_appraisal_periods.participation_type%TYPE DEFAULT NULL,
186 p_questionnaire_template_id IN per_appraisal_periods.questionnaire_template_id%TYPE DEFAULT NULL,
187 p_return_status OUT NOCOPY VARCHAR2
188 );
189
190
191
192 -- WPM Logging Changes code Start :
193
194 l_current_wpm_batch_action_id per_wpm_person_actions.wpm_batch_action_id%TYPE;
195
196 -- Used for Logging the error/Warning/Eligibility Information of each assignment/scorecard/person
197 TYPE g_wpm_person_actions_r IS RECORD (
198 wpm_person_action_id per_wpm_person_actions.wpm_person_action_id%TYPE,
199 wpm_batch_action_id per_wpm_person_actions.wpm_batch_action_id%TYPE,
200 person_id per_wpm_person_actions.person_id%TYPE,
201 assignment_id per_wpm_person_actions.assignment_id%TYPE,
202 business_group_id per_wpm_person_actions.business_group_id%TYPE,
203 processing_status per_wpm_person_actions.processing_status%TYPE,
204 eligibility_status per_wpm_person_actions.eligibility_status%TYPE,
205 MESSAGE_TYPE per_wpm_person_actions.MESSAGE_TYPE%TYPE,
206 message_number per_wpm_person_actions.message_number%TYPE,
207 MESSAGE_TEXT per_wpm_person_actions.MESSAGE_TEXT%TYPE,
208 transaction_ref_table per_wpm_person_actions.transaction_ref_table%TYPE,
209 transaction_ref_id per_wpm_person_actions.transaction_ref_id%TYPE,
210 information_category per_wpm_person_actions.information_category%TYPE,
211 information1 per_wpm_person_actions.information1%TYPE,
212 information2 per_wpm_person_actions.information2%TYPE,
213 information3 per_wpm_person_actions.information3%TYPE,
214 information4 per_wpm_person_actions.information4%TYPE,
215 information5 per_wpm_person_actions.information5%TYPE,
216 information6 per_wpm_person_actions.information6%TYPE,
217 information7 per_wpm_person_actions.information7%TYPE,
218 information8 per_wpm_person_actions.information8%TYPE,
219 information9 per_wpm_person_actions.information9%TYPE,
220 information10 per_wpm_person_actions.information10%TYPE,
221 information11 per_wpm_person_actions.information11%TYPE,
222 information12 per_wpm_person_actions.information12%TYPE,
223 information13 per_wpm_person_actions.information13%TYPE,
224 information14 per_wpm_person_actions.information14%TYPE,
225 information15 per_wpm_person_actions.information15%TYPE,
226 information16 per_wpm_person_actions.information16%TYPE,
227 information17 per_wpm_person_actions.information17%TYPE,
228 information18 per_wpm_person_actions.information18%TYPE,
229 information19 per_wpm_person_actions.information19%TYPE,
230 information20 per_wpm_person_actions.information20%TYPE
231 );
232
233 TYPE g_wpm_person_actions_t IS TABLE OF g_wpm_person_actions_r
234 INDEX BY BINARY_INTEGER;
235
236 g_wpm_person_actions g_wpm_person_actions_t;
237
238 -- log_records_index Ponts to the current record in the g_wpm_person_actions Table
239 -- whose log information has to be updated
240 log_records_index NUMBER;
241
242 PROCEDURE print_cache;
243
244 PROCEDURE submit_ma_change_cp (
245 p_batch_action_id IN NUMBER,
246 p_request_id OUT NOCOPY NUMBER,
247 p_effective_date IN VARCHAR2 DEFAULT NULL,
248 p_log_output IN VARCHAR2 DEFAULT 'Y'
249 );
250
251 PROCEDURE ma_change_cp (
252 errbuf OUT NOCOPY VARCHAR2,
253 retcode OUT NOCOPY NUMBER,
254 p_effective_date IN VARCHAR2,
255 p_batch_action_id IN NUMBER,
256 p_log_output IN VARCHAR2 DEFAULT 'Y'
257 );
258 -- WPM Logging Changes code End
259
260
261
262 END hr_wpm_mass_apr_push;