[Home] [Help]
PACKAGE: APPS.HR_WPM_MASS_APR_PUSH
Source
1 Package HR_WPM_MASS_APR_PUSH as
2 /* $Header: pewpmaprpush.pkh 120.3.12010000.1 2008/07/28 06:07:51 appldev 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
14 SUCCESS CONSTANT NUMBER := 0;
15 WARNING CONSTANT NUMBER := 1;
16 ERROR CONSTANT NUMBER := 2;
17 --
18 -- Package global variables.
19 --
20 g_errbuf VARCHAR2(2000);
21 g_retcode NUMBER;
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 -- |---------------------------< appraisal_cp >----------------------------|
63 -- ----------------------------------------------------------------------------
64 -- {Start Of Comments}
65 --
66 -- Description: Publish Performance Management Plan APIs and concurrent program
67 -- calls this procedure.
68 --
69 --
70 -- Prerequisites:
71 --
72 --
73 -- In Parameters:
74 -- Name Reqd Type Description
75 --
76 --
77 -- Post Success:
78 --
79 --
80 -- Name Type Description
81 --
82 -- Post Failure:
83 --
84 --
85 -- Access Status:
86 -- Internal Development Use Only.
87 --
88 -- {End Of Comments}
89 --
90 --
91 procedure appraisal_cp
92 (errbuf out nocopy varchar2
93 ,retcode out nocopy number
94 ,p_effective_date in varchar2
95 ,p_plan_id in number
96 ,p_appraisal_period_id in number
97 ,p_log_output in varchar2 default 'N'
98 ,p_delete_pending_trans IN VARCHAR2 DEFAULT 'N'
99 );
100 --
101 -- ----------------------------------------------------------------------------
102 -- |-----------------------------< appraisal_push>-----------------------------|
103 -- ----------------------------------------------------------------------------
104 -- {Start Of Comments}
105 --
106 -- Description: Publish Performance Management Plan APIs and concurrent program
107 -- calls this procedure.
108 --
109 --
110 -- Prerequisites:
111 --
112 --
113 -- In Parameters:
114 -- Name Reqd Type Description
115 --
116 --
117 -- Post Success:
118 --
119 --
120 -- Name Type Description
121 --
122 -- Post Failure:
123 --
124 --
125 -- Access Status:
126 -- Internal Development Use Only.
127 --
128 -- {End Of Comments}
129 --
130 --
131 procedure appraisal_push
132 (p_effective_date in date
133 ,p_plan_id in number
134 ,p_appraisal_period_id in number
135 ,p_log_output in varchar2
136 );
137
138 --
139
140 -- ----------------------------------------------------------------------------
141 -- |----------------------< create_appraisal_for_person >---------------------|
142 -- ----------------------------------------------------------------------------
143 -- {Start Of Comments}
144 --
145 -- Description:
146 -- Creates Appraisal for a given person when plan is published.
147 --
148 -- Prerequisites:
149 -- None.
150 --
151 -- In Arguments:
152 --
153 --
154 -- Post Success:
155 -- Processing continues if Appraisal is created.
156 --
157 -- Post Failure:
158 -- An application error is raised if scorecard is not created.
159 --
160 -- Access Status:
161 -- Internal Only.
162 --
163 -- {End Of Comments}
164 -- ----------------------------------------------------------------------------
165 PROCEDURE create_appraisal_for_person
166 ( p_score_card_id per_personal_scorecards.scorecard_id%TYPE,
167 p_appraisal_templ_id per_appraisal_templates.appraisal_template_id%TYPE,
168 p_effective_date DATE,
169 p_appraisal_start_date DATE,
170 p_appraisal_end_date DATE,
171 p_appraisal_status per_appraisals.status%TYPE default 'PLANNED',
172 p_type per_appraisals.type%TYPE default null,
173 p_appraisal_date per_appraisals.appraisal_date%TYPE,
174 -- p_appraisal_system_status per_appraisals.appraisal_system_status%TYPE,
175 p_plan_id number,
176 p_next_appraisal_date per_appraisals.next_appraisal_date%TYPE default
177 null,
178 p_status per_appraisals.status%TYPE default null,
179 p_comments per_appraisals.comments%TYPE default null,
180 p_appraisee_access per_appraisals.appraisee_access%TYPE default null,
181 p_appraisal_initiator per_appraisal_periods.initiator_code%TYPE,
182 p_appraisal_system_type in
183 per_appraisal_periods.appraisal_system_type%TYPE,
184 p_return_status out nocopy VARCHAR2
185 );
186 end HR_WPM_MASS_APR_PUSH;
187