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.

APPS.PAY_CNU_UPD dependencies on PAY_CNU_SHD

Line 55: (p_rec in out nocopy pay_cnu_shd.g_rec_type

51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml
55: (p_rec in out nocopy pay_cnu_shd.g_rec_type
56: ) is
57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: --

Line 89: pay_cnu_shd.constraint_error

85: Exception
86: When hr_api.check_integrity_violated Then
87: -- A check constraint has been violated
88: --
89: pay_cnu_shd.constraint_error
90: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
91: When hr_api.parent_integrity_violated Then
92: -- Parent integrity has been violated
93: --

Line 94: pay_cnu_shd.constraint_error

90: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
91: When hr_api.parent_integrity_violated Then
92: -- Parent integrity has been violated
93: --
94: pay_cnu_shd.constraint_error
95: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
96: When hr_api.unique_integrity_violated Then
97: -- Unique integrity has been violated
98: --

Line 99: pay_cnu_shd.constraint_error

95: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
96: When hr_api.unique_integrity_violated Then
97: -- Unique integrity has been violated
98: --
99: pay_cnu_shd.constraint_error
100: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
101: When Others Then
102: --
103: Raise;

Line 139: (p_rec in pay_cnu_shd.g_rec_type

135: --
136: -- {End Of Comments}
137: -- ----------------------------------------------------------------------------
138: Procedure pre_update
139: (p_rec in pay_cnu_shd.g_rec_type
140: ) is
141: --
142: l_proc varchar2(72) := g_package||'pre_update';
143: --

Line 183: (p_rec in pay_cnu_shd.g_rec_type

179: --
180: -- {End Of Comments}
181: -- ----------------------------------------------------------------------------
182: Procedure post_update
183: (p_rec in pay_cnu_shd.g_rec_type
184: ) is
185: --
186: l_proc varchar2(72) := g_package||'post_update';
187: --

Line 197: ,p_date_from_o => pay_cnu_shd.g_old_rec.date_from

193: (p_contribution_usage_id => p_rec.contribution_usage_id
194: ,p_date_to => p_rec.date_to
195: ,p_retro_contribution_code => p_rec.retro_contribution_code
196: ,p_object_version_number => p_rec.object_version_number
197: ,p_date_from_o => pay_cnu_shd.g_old_rec.date_from
198: ,p_date_to_o => pay_cnu_shd.g_old_rec.date_to
199: ,p_group_code_o => pay_cnu_shd.g_old_rec.group_code
200: ,p_process_type_o => pay_cnu_shd.g_old_rec.process_type
201: ,p_element_name_o => pay_cnu_shd.g_old_rec.element_name

Line 198: ,p_date_to_o => pay_cnu_shd.g_old_rec.date_to

194: ,p_date_to => p_rec.date_to
195: ,p_retro_contribution_code => p_rec.retro_contribution_code
196: ,p_object_version_number => p_rec.object_version_number
197: ,p_date_from_o => pay_cnu_shd.g_old_rec.date_from
198: ,p_date_to_o => pay_cnu_shd.g_old_rec.date_to
199: ,p_group_code_o => pay_cnu_shd.g_old_rec.group_code
200: ,p_process_type_o => pay_cnu_shd.g_old_rec.process_type
201: ,p_element_name_o => pay_cnu_shd.g_old_rec.element_name
202: ,p_rate_type_o => pay_cnu_shd.g_old_rec.rate_type

Line 199: ,p_group_code_o => pay_cnu_shd.g_old_rec.group_code

195: ,p_retro_contribution_code => p_rec.retro_contribution_code
196: ,p_object_version_number => p_rec.object_version_number
197: ,p_date_from_o => pay_cnu_shd.g_old_rec.date_from
198: ,p_date_to_o => pay_cnu_shd.g_old_rec.date_to
199: ,p_group_code_o => pay_cnu_shd.g_old_rec.group_code
200: ,p_process_type_o => pay_cnu_shd.g_old_rec.process_type
201: ,p_element_name_o => pay_cnu_shd.g_old_rec.element_name
202: ,p_rate_type_o => pay_cnu_shd.g_old_rec.rate_type
203: ,p_contribution_code_o => pay_cnu_shd.g_old_rec.contribution_code

Line 200: ,p_process_type_o => pay_cnu_shd.g_old_rec.process_type

196: ,p_object_version_number => p_rec.object_version_number
197: ,p_date_from_o => pay_cnu_shd.g_old_rec.date_from
198: ,p_date_to_o => pay_cnu_shd.g_old_rec.date_to
199: ,p_group_code_o => pay_cnu_shd.g_old_rec.group_code
200: ,p_process_type_o => pay_cnu_shd.g_old_rec.process_type
201: ,p_element_name_o => pay_cnu_shd.g_old_rec.element_name
202: ,p_rate_type_o => pay_cnu_shd.g_old_rec.rate_type
203: ,p_contribution_code_o => pay_cnu_shd.g_old_rec.contribution_code
204: ,p_retro_contribution_code_o => pay_cnu_shd.g_old_rec.retro_contribution_code

Line 201: ,p_element_name_o => pay_cnu_shd.g_old_rec.element_name

197: ,p_date_from_o => pay_cnu_shd.g_old_rec.date_from
198: ,p_date_to_o => pay_cnu_shd.g_old_rec.date_to
199: ,p_group_code_o => pay_cnu_shd.g_old_rec.group_code
200: ,p_process_type_o => pay_cnu_shd.g_old_rec.process_type
201: ,p_element_name_o => pay_cnu_shd.g_old_rec.element_name
202: ,p_rate_type_o => pay_cnu_shd.g_old_rec.rate_type
203: ,p_contribution_code_o => pay_cnu_shd.g_old_rec.contribution_code
204: ,p_retro_contribution_code_o => pay_cnu_shd.g_old_rec.retro_contribution_code
205: ,p_contribution_type_o => pay_cnu_shd.g_old_rec.contribution_type

Line 202: ,p_rate_type_o => pay_cnu_shd.g_old_rec.rate_type

198: ,p_date_to_o => pay_cnu_shd.g_old_rec.date_to
199: ,p_group_code_o => pay_cnu_shd.g_old_rec.group_code
200: ,p_process_type_o => pay_cnu_shd.g_old_rec.process_type
201: ,p_element_name_o => pay_cnu_shd.g_old_rec.element_name
202: ,p_rate_type_o => pay_cnu_shd.g_old_rec.rate_type
203: ,p_contribution_code_o => pay_cnu_shd.g_old_rec.contribution_code
204: ,p_retro_contribution_code_o => pay_cnu_shd.g_old_rec.retro_contribution_code
205: ,p_contribution_type_o => pay_cnu_shd.g_old_rec.contribution_type
206: ,p_contribution_usage_type_o => pay_cnu_shd.g_old_rec.contribution_usage_type

Line 203: ,p_contribution_code_o => pay_cnu_shd.g_old_rec.contribution_code

199: ,p_group_code_o => pay_cnu_shd.g_old_rec.group_code
200: ,p_process_type_o => pay_cnu_shd.g_old_rec.process_type
201: ,p_element_name_o => pay_cnu_shd.g_old_rec.element_name
202: ,p_rate_type_o => pay_cnu_shd.g_old_rec.rate_type
203: ,p_contribution_code_o => pay_cnu_shd.g_old_rec.contribution_code
204: ,p_retro_contribution_code_o => pay_cnu_shd.g_old_rec.retro_contribution_code
205: ,p_contribution_type_o => pay_cnu_shd.g_old_rec.contribution_type
206: ,p_contribution_usage_type_o => pay_cnu_shd.g_old_rec.contribution_usage_type
207: ,p_rate_category_o => pay_cnu_shd.g_old_rec.rate_category

Line 204: ,p_retro_contribution_code_o => pay_cnu_shd.g_old_rec.retro_contribution_code

200: ,p_process_type_o => pay_cnu_shd.g_old_rec.process_type
201: ,p_element_name_o => pay_cnu_shd.g_old_rec.element_name
202: ,p_rate_type_o => pay_cnu_shd.g_old_rec.rate_type
203: ,p_contribution_code_o => pay_cnu_shd.g_old_rec.contribution_code
204: ,p_retro_contribution_code_o => pay_cnu_shd.g_old_rec.retro_contribution_code
205: ,p_contribution_type_o => pay_cnu_shd.g_old_rec.contribution_type
206: ,p_contribution_usage_type_o => pay_cnu_shd.g_old_rec.contribution_usage_type
207: ,p_rate_category_o => pay_cnu_shd.g_old_rec.rate_category
208: ,p_business_group_id_o => pay_cnu_shd.g_old_rec.business_group_id

Line 205: ,p_contribution_type_o => pay_cnu_shd.g_old_rec.contribution_type

201: ,p_element_name_o => pay_cnu_shd.g_old_rec.element_name
202: ,p_rate_type_o => pay_cnu_shd.g_old_rec.rate_type
203: ,p_contribution_code_o => pay_cnu_shd.g_old_rec.contribution_code
204: ,p_retro_contribution_code_o => pay_cnu_shd.g_old_rec.retro_contribution_code
205: ,p_contribution_type_o => pay_cnu_shd.g_old_rec.contribution_type
206: ,p_contribution_usage_type_o => pay_cnu_shd.g_old_rec.contribution_usage_type
207: ,p_rate_category_o => pay_cnu_shd.g_old_rec.rate_category
208: ,p_business_group_id_o => pay_cnu_shd.g_old_rec.business_group_id
209: ,p_object_version_number_o => pay_cnu_shd.g_old_rec.object_version_number

Line 206: ,p_contribution_usage_type_o => pay_cnu_shd.g_old_rec.contribution_usage_type

202: ,p_rate_type_o => pay_cnu_shd.g_old_rec.rate_type
203: ,p_contribution_code_o => pay_cnu_shd.g_old_rec.contribution_code
204: ,p_retro_contribution_code_o => pay_cnu_shd.g_old_rec.retro_contribution_code
205: ,p_contribution_type_o => pay_cnu_shd.g_old_rec.contribution_type
206: ,p_contribution_usage_type_o => pay_cnu_shd.g_old_rec.contribution_usage_type
207: ,p_rate_category_o => pay_cnu_shd.g_old_rec.rate_category
208: ,p_business_group_id_o => pay_cnu_shd.g_old_rec.business_group_id
209: ,p_object_version_number_o => pay_cnu_shd.g_old_rec.object_version_number
210: ,p_code_rate_id_o => pay_cnu_shd.g_old_rec.code_Rate_id

Line 207: ,p_rate_category_o => pay_cnu_shd.g_old_rec.rate_category

203: ,p_contribution_code_o => pay_cnu_shd.g_old_rec.contribution_code
204: ,p_retro_contribution_code_o => pay_cnu_shd.g_old_rec.retro_contribution_code
205: ,p_contribution_type_o => pay_cnu_shd.g_old_rec.contribution_type
206: ,p_contribution_usage_type_o => pay_cnu_shd.g_old_rec.contribution_usage_type
207: ,p_rate_category_o => pay_cnu_shd.g_old_rec.rate_category
208: ,p_business_group_id_o => pay_cnu_shd.g_old_rec.business_group_id
209: ,p_object_version_number_o => pay_cnu_shd.g_old_rec.object_version_number
210: ,p_code_rate_id_o => pay_cnu_shd.g_old_rec.code_Rate_id
211: );

Line 208: ,p_business_group_id_o => pay_cnu_shd.g_old_rec.business_group_id

204: ,p_retro_contribution_code_o => pay_cnu_shd.g_old_rec.retro_contribution_code
205: ,p_contribution_type_o => pay_cnu_shd.g_old_rec.contribution_type
206: ,p_contribution_usage_type_o => pay_cnu_shd.g_old_rec.contribution_usage_type
207: ,p_rate_category_o => pay_cnu_shd.g_old_rec.rate_category
208: ,p_business_group_id_o => pay_cnu_shd.g_old_rec.business_group_id
209: ,p_object_version_number_o => pay_cnu_shd.g_old_rec.object_version_number
210: ,p_code_rate_id_o => pay_cnu_shd.g_old_rec.code_Rate_id
211: );
212: --

Line 209: ,p_object_version_number_o => pay_cnu_shd.g_old_rec.object_version_number

205: ,p_contribution_type_o => pay_cnu_shd.g_old_rec.contribution_type
206: ,p_contribution_usage_type_o => pay_cnu_shd.g_old_rec.contribution_usage_type
207: ,p_rate_category_o => pay_cnu_shd.g_old_rec.rate_category
208: ,p_business_group_id_o => pay_cnu_shd.g_old_rec.business_group_id
209: ,p_object_version_number_o => pay_cnu_shd.g_old_rec.object_version_number
210: ,p_code_rate_id_o => pay_cnu_shd.g_old_rec.code_Rate_id
211: );
212: --
213: exception

Line 210: ,p_code_rate_id_o => pay_cnu_shd.g_old_rec.code_Rate_id

206: ,p_contribution_usage_type_o => pay_cnu_shd.g_old_rec.contribution_usage_type
207: ,p_rate_category_o => pay_cnu_shd.g_old_rec.rate_category
208: ,p_business_group_id_o => pay_cnu_shd.g_old_rec.business_group_id
209: ,p_object_version_number_o => pay_cnu_shd.g_old_rec.object_version_number
210: ,p_code_rate_id_o => pay_cnu_shd.g_old_rec.code_Rate_id
211: );
212: --
213: exception
214: --

Line 270: (p_rec in out nocopy pay_cnu_shd.g_rec_type

266: --
267: -- {End Of Comments}
268: -- ----------------------------------------------------------------------------
269: Procedure convert_defs
270: (p_rec in out nocopy pay_cnu_shd.g_rec_type
271: ) is
272: --
273: Begin
274: --

Line 282: pay_cnu_shd.g_old_rec.date_from;

278: -- is being used then we must set to the 'current' argument value.
279: --
280: If (p_rec.date_from = hr_api.g_date) then
281: p_rec.date_from :=
282: pay_cnu_shd.g_old_rec.date_from;
283: End If;
284: If (p_rec.date_to = hr_api.g_date) then
285: p_rec.date_to :=
286: pay_cnu_shd.g_old_rec.date_to;

Line 286: pay_cnu_shd.g_old_rec.date_to;

282: pay_cnu_shd.g_old_rec.date_from;
283: End If;
284: If (p_rec.date_to = hr_api.g_date) then
285: p_rec.date_to :=
286: pay_cnu_shd.g_old_rec.date_to;
287: End If;
288: If (p_rec.group_code = hr_api.g_varchar2) then
289: p_rec.group_code :=
290: pay_cnu_shd.g_old_rec.group_code;

Line 290: pay_cnu_shd.g_old_rec.group_code;

286: pay_cnu_shd.g_old_rec.date_to;
287: End If;
288: If (p_rec.group_code = hr_api.g_varchar2) then
289: p_rec.group_code :=
290: pay_cnu_shd.g_old_rec.group_code;
291: End If;
292: If (p_rec.process_type = hr_api.g_varchar2) then
293: p_rec.process_type :=
294: pay_cnu_shd.g_old_rec.process_type;

Line 294: pay_cnu_shd.g_old_rec.process_type;

290: pay_cnu_shd.g_old_rec.group_code;
291: End If;
292: If (p_rec.process_type = hr_api.g_varchar2) then
293: p_rec.process_type :=
294: pay_cnu_shd.g_old_rec.process_type;
295: End If;
296: If (p_rec.element_name = hr_api.g_varchar2) then
297: p_rec.element_name :=
298: pay_cnu_shd.g_old_rec.element_name;

Line 298: pay_cnu_shd.g_old_rec.element_name;

294: pay_cnu_shd.g_old_rec.process_type;
295: End If;
296: If (p_rec.element_name = hr_api.g_varchar2) then
297: p_rec.element_name :=
298: pay_cnu_shd.g_old_rec.element_name;
299: End If;
300: If (p_rec.rate_type = hr_api.g_varchar2) then
301: p_rec.rate_type :=
302: pay_cnu_shd.g_old_rec.rate_type;

Line 302: pay_cnu_shd.g_old_rec.rate_type;

298: pay_cnu_shd.g_old_rec.element_name;
299: End If;
300: If (p_rec.rate_type = hr_api.g_varchar2) then
301: p_rec.rate_type :=
302: pay_cnu_shd.g_old_rec.rate_type;
303: End If;
304: If (p_rec.contribution_code = hr_api.g_varchar2) then
305: p_rec.contribution_code :=
306: pay_cnu_shd.g_old_rec.contribution_code;

Line 306: pay_cnu_shd.g_old_rec.contribution_code;

302: pay_cnu_shd.g_old_rec.rate_type;
303: End If;
304: If (p_rec.contribution_code = hr_api.g_varchar2) then
305: p_rec.contribution_code :=
306: pay_cnu_shd.g_old_rec.contribution_code;
307: End If;
308: If (p_rec.retro_contribution_code = hr_api.g_varchar2) then
309: p_rec.retro_contribution_code :=
310: pay_cnu_shd.g_old_rec.retro_contribution_code;

Line 310: pay_cnu_shd.g_old_rec.retro_contribution_code;

306: pay_cnu_shd.g_old_rec.contribution_code;
307: End If;
308: If (p_rec.retro_contribution_code = hr_api.g_varchar2) then
309: p_rec.retro_contribution_code :=
310: pay_cnu_shd.g_old_rec.retro_contribution_code;
311: End If;
312: If (p_rec.contribution_type = hr_api.g_varchar2) then
313: p_rec.contribution_type :=
314: pay_cnu_shd.g_old_rec.contribution_type;

Line 314: pay_cnu_shd.g_old_rec.contribution_type;

310: pay_cnu_shd.g_old_rec.retro_contribution_code;
311: End If;
312: If (p_rec.contribution_type = hr_api.g_varchar2) then
313: p_rec.contribution_type :=
314: pay_cnu_shd.g_old_rec.contribution_type;
315: End If;
316: If (p_rec.contribution_usage_type = hr_api.g_varchar2) then
317: p_rec.contribution_usage_type :=
318: pay_cnu_shd.g_old_rec.contribution_usage_type;

Line 318: pay_cnu_shd.g_old_rec.contribution_usage_type;

314: pay_cnu_shd.g_old_rec.contribution_type;
315: End If;
316: If (p_rec.contribution_usage_type = hr_api.g_varchar2) then
317: p_rec.contribution_usage_type :=
318: pay_cnu_shd.g_old_rec.contribution_usage_type;
319: End If;
320: If (p_rec.rate_category = hr_api.g_varchar2) then
321: p_rec.rate_category :=
322: pay_cnu_shd.g_old_rec.rate_category;

Line 322: pay_cnu_shd.g_old_rec.rate_category;

318: pay_cnu_shd.g_old_rec.contribution_usage_type;
319: End If;
320: If (p_rec.rate_category = hr_api.g_varchar2) then
321: p_rec.rate_category :=
322: pay_cnu_shd.g_old_rec.rate_category;
323: End If;
324: If (p_rec.business_group_id = hr_api.g_number) then
325: p_rec.business_group_id :=
326: pay_cnu_shd.g_old_rec.business_group_id;

Line 326: pay_cnu_shd.g_old_rec.business_group_id;

322: pay_cnu_shd.g_old_rec.rate_category;
323: End If;
324: If (p_rec.business_group_id = hr_api.g_number) then
325: p_rec.business_group_id :=
326: pay_cnu_shd.g_old_rec.business_group_id;
327: End If;
328: If (p_rec.code_rate_id = hr_api.g_number) then
329: p_rec.code_Rate_id :=
330: pay_cnu_shd.g_old_rec.code_rate_id;

Line 330: pay_cnu_shd.g_old_rec.code_rate_id;

326: pay_cnu_shd.g_old_rec.business_group_id;
327: End If;
328: If (p_rec.code_rate_id = hr_api.g_number) then
329: p_rec.code_Rate_id :=
330: pay_cnu_shd.g_old_rec.code_rate_id;
331: End If;
332: --
333: End convert_defs;
334: --

Line 340: ,p_rec in out nocopy pay_cnu_shd.g_rec_type

336: -- |---------------------------------< upd >----------------------------------|
337: -- ----------------------------------------------------------------------------
338: Procedure upd
339: (p_effective_date in date
340: ,p_rec in out nocopy pay_cnu_shd.g_rec_type
341: ) is
342: --
343: l_proc varchar2(72) := g_package||'upd';
344: --

Line 350: pay_cnu_shd.lck

346: hr_utility.set_location('Entering:'||l_proc, 5);
347: --
348: -- We must lock the row which we need to update.
349: --
350: pay_cnu_shd.lck
351: (p_rec.contribution_usage_id
352: ,p_rec.object_version_number
353: );
354: --

Line 396: l_rec pay_cnu_shd.g_rec_type;

392: ,p_retro_contribution_code in varchar2 default hr_api.g_varchar2
393: ,p_code_rate_id in varchar2
394: ) is
395: --
396: l_rec pay_cnu_shd.g_rec_type;
397: l_proc varchar2(72) := g_package||'upd';
398: --
399: Begin
400: hr_utility.set_location('Entering:'||l_proc, 5);

Line 406: pay_cnu_shd.convert_args

402: -- Call conversion function to turn arguments into the
403: -- l_rec structure.
404: --
405: l_rec :=
406: pay_cnu_shd.convert_args
407: (p_contribution_usage_id
408: ,hr_api.g_date
409: ,p_date_to
410: ,hr_api.g_varchar2