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 HR_API

Line 86: When hr_api.check_integrity_violated Then

82: --
83: hr_utility.set_location(' Leaving:'||l_proc, 10);
84: --
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));

Line 90: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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: --
94: pay_cnu_shd.constraint_error

Line 91: When hr_api.parent_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: --
94: pay_cnu_shd.constraint_error
95: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 95: (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: --
99: pay_cnu_shd.constraint_error

Line 96: When hr_api.unique_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: --
99: pay_cnu_shd.constraint_error
100: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 100: (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;
104: End update_dml;

Line 215: when hr_api.cannot_find_prog_unit then

211: );
212: --
213: exception
214: --
215: when hr_api.cannot_find_prog_unit then
216: --
217: hr_api.cannot_find_prog_unit_error
218: (p_module_name => 'PAY_FR_CONTRIBUTION_USAGES'
219: ,p_hook_type => 'AU');

Line 217: hr_api.cannot_find_prog_unit_error

213: exception
214: --
215: when hr_api.cannot_find_prog_unit then
216: --
217: hr_api.cannot_find_prog_unit_error
218: (p_module_name => 'PAY_FR_CONTRIBUTION_USAGES'
219: ,p_hook_type => 'AU');
220: --
221: end;

Line 280: If (p_rec.date_from = hr_api.g_date) then

276: -- p_rec plsql record structure
277: -- to see if a system default is being used. If a system default
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

Line 284: If (p_rec.date_to = hr_api.g_date) then

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;
287: End If;
288: If (p_rec.group_code = hr_api.g_varchar2) then

Line 288: If (p_rec.group_code = hr_api.g_varchar2) then

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;
291: End If;
292: If (p_rec.process_type = hr_api.g_varchar2) then

Line 292: If (p_rec.process_type = hr_api.g_varchar2) then

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;
295: End If;
296: If (p_rec.element_name = hr_api.g_varchar2) then

Line 296: If (p_rec.element_name = hr_api.g_varchar2) then

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;
299: End If;
300: If (p_rec.rate_type = hr_api.g_varchar2) then

Line 300: If (p_rec.rate_type = hr_api.g_varchar2) then

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;
303: End If;
304: If (p_rec.contribution_code = hr_api.g_varchar2) then

Line 304: If (p_rec.contribution_code = hr_api.g_varchar2) then

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;
307: End If;
308: If (p_rec.retro_contribution_code = hr_api.g_varchar2) then

Line 308: If (p_rec.retro_contribution_code = hr_api.g_varchar2) then

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;
311: End If;
312: If (p_rec.contribution_type = hr_api.g_varchar2) then

Line 312: If (p_rec.contribution_type = hr_api.g_varchar2) then

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;
315: End If;
316: If (p_rec.contribution_usage_type = hr_api.g_varchar2) then

Line 316: If (p_rec.contribution_usage_type = hr_api.g_varchar2) then

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;
319: End If;
320: If (p_rec.rate_category = hr_api.g_varchar2) then

Line 320: If (p_rec.rate_category = hr_api.g_varchar2) then

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;
323: End If;
324: If (p_rec.business_group_id = hr_api.g_number) then

Line 324: If (p_rec.business_group_id = hr_api.g_number) then

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;
327: End If;
328: If (p_rec.code_rate_id = hr_api.g_number) then

Line 328: If (p_rec.code_rate_id = hr_api.g_number) then

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;
331: End If;
332: --

Line 389: ,p_date_to in date default hr_api.g_date

385: Procedure upd
386: (p_effective_date in date
387: ,p_contribution_usage_id in number
388: ,p_object_version_number in out nocopy number
389: ,p_date_to in date default hr_api.g_date
390: ,p_contribution_code IN varchar2
391: ,p_contribution_type IN varchar2
392: ,p_retro_contribution_code in varchar2 default hr_api.g_varchar2
393: ,p_code_rate_id in varchar2

Line 392: ,p_retro_contribution_code in varchar2 default hr_api.g_varchar2

388: ,p_object_version_number in out nocopy number
389: ,p_date_to in date default hr_api.g_date
390: ,p_contribution_code IN varchar2
391: ,p_contribution_type IN varchar2
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;

Line 408: ,hr_api.g_date

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
411: ,hr_api.g_varchar2
412: ,hr_api.g_varchar2

Line 410: ,hr_api.g_varchar2

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
411: ,hr_api.g_varchar2
412: ,hr_api.g_varchar2
413: ,hr_api.g_varchar2
414: ,p_contribution_code

Line 411: ,hr_api.g_varchar2

407: (p_contribution_usage_id
408: ,hr_api.g_date
409: ,p_date_to
410: ,hr_api.g_varchar2
411: ,hr_api.g_varchar2
412: ,hr_api.g_varchar2
413: ,hr_api.g_varchar2
414: ,p_contribution_code
415: ,p_retro_contribution_code

Line 412: ,hr_api.g_varchar2

408: ,hr_api.g_date
409: ,p_date_to
410: ,hr_api.g_varchar2
411: ,hr_api.g_varchar2
412: ,hr_api.g_varchar2
413: ,hr_api.g_varchar2
414: ,p_contribution_code
415: ,p_retro_contribution_code
416: ,p_contribution_type

Line 413: ,hr_api.g_varchar2

409: ,p_date_to
410: ,hr_api.g_varchar2
411: ,hr_api.g_varchar2
412: ,hr_api.g_varchar2
413: ,hr_api.g_varchar2
414: ,p_contribution_code
415: ,p_retro_contribution_code
416: ,p_contribution_type
417: ,hr_api.g_varchar2

Line 417: ,hr_api.g_varchar2

413: ,hr_api.g_varchar2
414: ,p_contribution_code
415: ,p_retro_contribution_code
416: ,p_contribution_type
417: ,hr_api.g_varchar2
418: ,hr_api.g_varchar2
419: ,hr_api.g_number
420: ,p_object_version_number
421: ,to_number(p_code_rate_id)

Line 418: ,hr_api.g_varchar2

414: ,p_contribution_code
415: ,p_retro_contribution_code
416: ,p_contribution_type
417: ,hr_api.g_varchar2
418: ,hr_api.g_varchar2
419: ,hr_api.g_number
420: ,p_object_version_number
421: ,to_number(p_code_rate_id)
422: );

Line 419: ,hr_api.g_number

415: ,p_retro_contribution_code
416: ,p_contribution_type
417: ,hr_api.g_varchar2
418: ,hr_api.g_varchar2
419: ,hr_api.g_number
420: ,p_object_version_number
421: ,to_number(p_code_rate_id)
422: );
423: --