[Home] [Help]
PACKAGE: APPS.GHR_ELEMENT_API
Source
1 PACKAGE ghr_element_api AS
2 /* $Header: ghelepkg.pkh 120.1 2005/10/02 01:57:49 aroussel $ */
3 /*#
4 * This API processes Federal HR elements.
5 * @rep:scope public
6 * @rep:product per
7 * @rep:displayname Request for Personnel Action Element
8 */
9 --
10 g_package constant varchar2(33) := ' ghr_element_api.';
11
12 -- ---------------------------------------------------------------------------
13 -- |----------------------< retrieve_element_info >--------------------------|
14 -- ---------------------------------------------------------------------------
15 -- {Start of Comments}
16 --
17 -- Description:
18 -- Retrieve element info
19 --
20 -- Prerequisites:
21 --
22 -- In Parameters:
23 -- p_element_name
24 -- p_input_value_name
25 -- p_assignment_id
26 -- p_effective_date
27 -- p_processing_type
28 --
29 -- Out Parameters:
30 -- p_element_link_id
31 -- p_input_value_id
32 -- p_element_entry_id
33 -- p_value
34 -- p_object_version_number
35 -- p_multiple_error_flag
36 --
37 -- Post Success:
38 -- Processing nulls.
39 --
40 -- Post Failure:
41 -- An application error will be raised and processing is terminated.
42 --
43 -- Developer Implementation Notes:
44 -- None.
45 --
46 -- Access Status:
47 -- Internal Use Only.
48 --
49 -- {End of Comments}
50 -- ---------------------------------------------------------------------------
51 procedure retrieve_element_info
52 (p_element_name in pay_element_types_f.element_name%type
53 ,p_input_value_name in pay_input_values_f.name%type
54 ,p_assignment_id in pay_element_entries_f.assignment_id%type
55 ,p_effective_date in date
56 ,p_processing_type in pay_element_types_f.processing_type%type
57 ,p_element_link_id out nocopy pay_element_links_f.element_link_id%type
58 ,p_input_value_id out nocopy pay_input_values_f.input_value_id%type
59 ,p_element_entry_id out nocopy pay_element_entries_f.element_entry_id%type
60 ,p_value out nocopy pay_element_entry_values_f.screen_entry_value%type
61 ,p_object_version_number
62 out nocopy pay_element_entries_f.object_version_number%type
63 ,p_multiple_error_flag out nocopy varchar2
64 );
65 --
66 -- ----------------------------------------------------------------------------
67 -- |---------------------------< process_sf52_element >-----------------------|
68 -- ----------------------------------------------------------------------------
69 --
70 -- {Start Of Comments}
71 /*#
72 * This API processes Federal HR elements.
73 *
74 * This is a wrapper API used to create and update Federal HR elements by
75 * calling Core Payroll element APIs.
76 *
77 * <p><b>Licensing</b><br>
78 * This API is licensed for use with Human Resources.
79 *
80 * <p><b>Prerequisites</b><br>
81 * Assignment ID and the Input value Name and Value are passed
82 *
83 * <p><b>Post Success</b><br>
84 * This API creates a new element or updates an existing element.
85 *
86 * <p><b>Post Failure</b><br>
87 * An application error is raised and processing is terminated
88 * @param p_assignment_id {@rep:casecolumn PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_ID}
89 * @param p_element_name {@rep:casecolumn PAY_ELEMENT_TYPES_F.ELEMENT_NAME}
90 * @param p_input_value_name1 {@rep:casecolumn PAY_INPUT_VALUES_F.NAME}
91 * @param p_value1 {@rep:casecolumn
92 * PAY_ELEMENT_ENTRY_VALUES_F.SCREEN_ENTRY_VALUE}
93 * @param p_input_value_name2 {@rep:casecolumn PAY_INPUT_VALUES_F.NAME}
94 * @param p_value2 {@rep:casecolumn
95 * PAY_ELEMENT_ENTRY_VALUES_F.SCREEN_ENTRY_VALUE}
96 * @param p_input_value_name3 {@rep:casecolumn PAY_INPUT_VALUES_F.NAME}
97 * @param p_value3 {@rep:casecolumn
98 * PAY_ELEMENT_ENTRY_VALUES_F.SCREEN_ENTRY_VALUE}
99 * @param p_input_value_name4 {@rep:casecolumn PAY_INPUT_VALUES_F.NAME}
100 * @param p_value4 {@rep:casecolumn
101 * PAY_ELEMENT_ENTRY_VALUES_F.SCREEN_ENTRY_VALUE}
102 * @param p_input_value_name5 {@rep:casecolumn PAY_INPUT_VALUES_F.NAME}
103 * @param p_value5 {@rep:casecolumn
104 * PAY_ELEMENT_ENTRY_VALUES_F.SCREEN_ENTRY_VALUE}
105 * @param p_input_value_name6 {@rep:casecolumn PAY_INPUT_VALUES_F.NAME}
106 * @param p_value6 {@rep:casecolumn
107 * PAY_ELEMENT_ENTRY_VALUES_F.SCREEN_ENTRY_VALUE}
108 * @param p_input_value_name7 {@rep:casecolumn PAY_INPUT_VALUES_F.NAME}
109 * @param p_value7 {@rep:casecolumn
110 * PAY_ELEMENT_ENTRY_VALUES_F.SCREEN_ENTRY_VALUE}
111 * @param p_input_value_name8 {@rep:casecolumn PAY_INPUT_VALUES_F.NAME}
112 * @param p_value8 {@rep:casecolumn
113 * PAY_ELEMENT_ENTRY_VALUES_F.SCREEN_ENTRY_VALUE}
114 * @param p_input_value_name9 {@rep:casecolumn PAY_INPUT_VALUES_F.NAME}
115 * @param p_value9 {@rep:casecolumn
116 * PAY_ELEMENT_ENTRY_VALUES_F.SCREEN_ENTRY_VALUE}
117 * @param p_input_value_name10 {@rep:casecolumn PAY_INPUT_VALUES_F.NAME}
118 * @param p_value10 {@rep:casecolumn
119 * PAY_ELEMENT_ENTRY_VALUES_F.SCREEN_ENTRY_VALUE}
120 * @param p_input_value_name11 {@rep:casecolumn PAY_INPUT_VALUES_F.NAME}
121 * @param p_value11 {@rep:casecolumn
122 * PAY_ELEMENT_ENTRY_VALUES_F.SCREEN_ENTRY_VALUE}
123 * @param p_input_value_name12 {@rep:casecolumn PAY_INPUT_VALUES_F.NAME}
124 * @param p_value12 {@rep:casecolumn
125 * PAY_ELEMENT_ENTRY_VALUES_F.SCREEN_ENTRY_VALUE}
126 * @param p_input_value_name13 {@rep:casecolumn PAY_INPUT_VALUES_F.NAME}
127 * @param p_value13 {@rep:casecolumn
128 * PAY_ELEMENT_ENTRY_VALUES_F.SCREEN_ENTRY_VALUE}
129 * @param p_input_value_name14 {@rep:casecolumn PAY_INPUT_VALUES_F.NAME}
130 * @param p_value14 {@rep:casecolumn
131 * PAY_ELEMENT_ENTRY_VALUES_F.SCREEN_ENTRY_VALUE}
132 * @param p_input_value_name15 {@rep:casecolumn PAY_INPUT_VALUES_F.NAME}
133 * @param p_value15 {@rep:casecolumn
134 * PAY_ELEMENT_ENTRY_VALUES_F.SCREEN_ENTRY_VALUE}
135 * @param p_effective_date Reference date for validating lookup values are
136 * applicable during the start to end active date range. This date does not
137 * determine when the changes take effect.
138 * @param p_process_warning Process warning
139 * @rep:displayname Process Request for Personnel Action Element
140 * @rep:category BUSINESS_ENTITY GHR_REQ_FOR_PERSONNEL_ACTION
141 * @rep:scope public
142 * @rep:lifecycle active
143 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
144 */
145 --
146 -- {End Of Comments}
147 --
148 procedure process_sf52_element
149 (p_assignment_id in per_assignments_f.assignment_id%type
150 ,p_element_name in pay_element_types_f.element_name%type
151 ,p_input_value_name1 in pay_input_values_f.name%type
152 default null
153 ,p_value1 in pay_element_entry_values_f.screen_entry_value%type
154 default null
155 ,p_input_value_name2 in pay_input_values_f.name%type
156 default null
157 ,p_value2 in pay_element_entry_values_f.screen_entry_value%type
158 default null
159 ,p_input_value_name3 in pay_input_values_f.name%type
160 default null
161 ,p_value3 in pay_element_entry_values_f.screen_entry_value%type
162 default null
163 ,p_input_value_name4 in pay_input_values_f.name%type
164 default null
165 ,p_value4 in pay_element_entry_values_f.screen_entry_value%type
166 default null
167 ,p_input_value_name5 in pay_input_values_f.name%type
168 default null
169 ,p_value5 in pay_element_entry_values_f.screen_entry_value%type
170 default null
171 ,p_input_value_name6 in pay_input_values_f.name%type
172 default null
173 ,p_value6 in pay_element_entry_values_f.screen_entry_value%type
174 default null
175 ,p_input_value_name7 in pay_input_values_f.name%type
176 default null
177 ,p_value7 in pay_element_entry_values_f.screen_entry_value%type
178 default null
179 ,p_input_value_name8 in pay_input_values_f.name%type
180 default null
181 ,p_value8 in pay_element_entry_values_f.screen_entry_value%type
182 default null
183 ,p_input_value_name9 in pay_input_values_f.name%type
184 default null
185 ,p_value9 in pay_element_entry_values_f.screen_entry_value%type
186 default null
187 ,p_input_value_name10 in pay_input_values_f.name%type
188 default null
189 ,p_value10 in pay_element_entry_values_f.screen_entry_value%type
190 default null
191 ,p_input_value_name11 in pay_input_values_f.name%type
192 default null
193 ,p_value11 in pay_element_entry_values_f.screen_entry_value%type
194 default null
195 ,p_input_value_name12 in pay_input_values_f.name%type
196 default null
197 ,p_value12 in pay_element_entry_values_f.screen_entry_value%type
198 default null
199 ,p_input_value_name13 in pay_input_values_f.name%type
200 default null
201 ,p_value13 in pay_element_entry_values_f.screen_entry_value%type
202 default null
203 ,p_input_value_name14 in pay_input_values_f.name%type
204 default null
205 ,p_value14 in pay_element_entry_values_f.screen_entry_value%type
206 default null
207 ,p_input_value_name15 in pay_input_values_f.name%type
208 default null
209 ,p_value15 in pay_element_entry_values_f.screen_entry_value%type
210 default null
211 ,p_effective_date in date default null
212 ,p_process_warning out nocopy boolean
213 );
214 --
215 end ghr_element_api;