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.PSP_PRT_UPD dependencies on HR_API

Line 100: When hr_api.check_integrity_violated Then

96: --
97: hr_utility.set_location(' Leaving:'||l_proc, 10);
98: --
99: Exception
100: When hr_api.check_integrity_violated Then
101: -- A check constraint has been violated
102: psp_prt_shd.g_api_dml := false; -- Unset the api dml status
103: psp_prt_shd.constraint_error
104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

100: When hr_api.check_integrity_violated Then
101: -- A check constraint has been violated
102: psp_prt_shd.g_api_dml := false; -- Unset the api dml status
103: psp_prt_shd.constraint_error
104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
105: When hr_api.parent_integrity_violated Then
106: -- Parent integrity has been violated
107: psp_prt_shd.g_api_dml := false; -- Unset the api dml status
108: psp_prt_shd.constraint_error

Line 105: When hr_api.parent_integrity_violated Then

101: -- A check constraint has been violated
102: psp_prt_shd.g_api_dml := false; -- Unset the api dml status
103: psp_prt_shd.constraint_error
104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
105: When hr_api.parent_integrity_violated Then
106: -- Parent integrity has been violated
107: psp_prt_shd.g_api_dml := false; -- Unset the api dml status
108: psp_prt_shd.constraint_error
109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

105: When hr_api.parent_integrity_violated Then
106: -- Parent integrity has been violated
107: psp_prt_shd.g_api_dml := false; -- Unset the api dml status
108: psp_prt_shd.constraint_error
109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
110: When hr_api.unique_integrity_violated Then
111: -- Unique integrity has been violated
112: psp_prt_shd.g_api_dml := false; -- Unset the api dml status
113: psp_prt_shd.constraint_error

Line 110: When hr_api.unique_integrity_violated Then

106: -- Parent integrity has been violated
107: psp_prt_shd.g_api_dml := false; -- Unset the api dml status
108: psp_prt_shd.constraint_error
109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
110: When hr_api.unique_integrity_violated Then
111: -- Unique integrity has been violated
112: psp_prt_shd.g_api_dml := false; -- Unset the api dml status
113: psp_prt_shd.constraint_error
114: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

110: When hr_api.unique_integrity_violated Then
111: -- Unique integrity has been violated
112: psp_prt_shd.g_api_dml := false; -- Unset the api dml status
113: psp_prt_shd.constraint_error
114: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
115: When Others Then
116: psp_prt_shd.g_api_dml := false; -- Unset the api dml status
117: Raise;
118: End update_dml;

Line 293: when hr_api.cannot_find_prog_unit then

289: );
290: --
291: exception
292: --
293: when hr_api.cannot_find_prog_unit then
294: --
295: hr_api.cannot_find_prog_unit_error
296: (p_module_name => 'PSP_REPORT_TEMPLATES'
297: ,p_hook_type => 'AU');

Line 295: hr_api.cannot_find_prog_unit_error

291: exception
292: --
293: when hr_api.cannot_find_prog_unit then
294: --
295: hr_api.cannot_find_prog_unit_error
296: (p_module_name => 'PSP_REPORT_TEMPLATES'
297: ,p_hook_type => 'AU');
298: --
299: end;

Line 358: If (p_rec.template_name = hr_api.g_varchar2) then

354: -- p_rec plsql record structure
355: -- to see if a system default is being used. If a system default
356: -- is being used then we must set to the 'current' argument value.
357: --
358: If (p_rec.template_name = hr_api.g_varchar2) then
359: p_rec.template_name :=
360: psp_prt_shd.g_old_rec.template_name;
361: End If;
362: If (p_rec.business_group_id = hr_api.g_number) then

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

358: If (p_rec.template_name = hr_api.g_varchar2) then
359: p_rec.template_name :=
360: psp_prt_shd.g_old_rec.template_name;
361: End If;
362: If (p_rec.business_group_id = hr_api.g_number) then
363: p_rec.business_group_id :=
364: psp_prt_shd.g_old_rec.business_group_id;
365: End If;
366: If (p_rec.set_of_books_id = hr_api.g_number) then

Line 366: If (p_rec.set_of_books_id = hr_api.g_number) then

362: If (p_rec.business_group_id = hr_api.g_number) then
363: p_rec.business_group_id :=
364: psp_prt_shd.g_old_rec.business_group_id;
365: End If;
366: If (p_rec.set_of_books_id = hr_api.g_number) then
367: p_rec.set_of_books_id :=
368: psp_prt_shd.g_old_rec.set_of_books_id;
369: End If;
370: If (p_rec.report_type = hr_api.g_varchar2) then

Line 370: If (p_rec.report_type = hr_api.g_varchar2) then

366: If (p_rec.set_of_books_id = hr_api.g_number) then
367: p_rec.set_of_books_id :=
368: psp_prt_shd.g_old_rec.set_of_books_id;
369: End If;
370: If (p_rec.report_type = hr_api.g_varchar2) then
371: p_rec.report_type :=
372: psp_prt_shd.g_old_rec.report_type;
373: End If;
374: If (p_rec.period_frequency_id = hr_api.g_number) then

Line 374: If (p_rec.period_frequency_id = hr_api.g_number) then

370: If (p_rec.report_type = hr_api.g_varchar2) then
371: p_rec.report_type :=
372: psp_prt_shd.g_old_rec.report_type;
373: End If;
374: If (p_rec.period_frequency_id = hr_api.g_number) then
375: p_rec.period_frequency_id :=
376: psp_prt_shd.g_old_rec.period_frequency_id;
377: End If;
378: If (p_rec.report_template_code = hr_api.g_varchar2) then

Line 378: If (p_rec.report_template_code = hr_api.g_varchar2) then

374: If (p_rec.period_frequency_id = hr_api.g_number) then
375: p_rec.period_frequency_id :=
376: psp_prt_shd.g_old_rec.period_frequency_id;
377: End If;
378: If (p_rec.report_template_code = hr_api.g_varchar2) then
379: p_rec.report_template_code :=
380: psp_prt_shd.g_old_rec.report_template_code;
381: End If;
382: If (p_rec.display_all_emp_distrib_flag = hr_api.g_varchar2) then

Line 382: If (p_rec.display_all_emp_distrib_flag = hr_api.g_varchar2) then

378: If (p_rec.report_template_code = hr_api.g_varchar2) then
379: p_rec.report_template_code :=
380: psp_prt_shd.g_old_rec.report_template_code;
381: End If;
382: If (p_rec.display_all_emp_distrib_flag = hr_api.g_varchar2) then
383: p_rec.display_all_emp_distrib_flag :=
384: psp_prt_shd.g_old_rec.display_all_emp_distrib_flag;
385: End If;
386: If (p_rec.manual_entry_override_flag = hr_api.g_varchar2) then

Line 386: If (p_rec.manual_entry_override_flag = hr_api.g_varchar2) then

382: If (p_rec.display_all_emp_distrib_flag = hr_api.g_varchar2) then
383: p_rec.display_all_emp_distrib_flag :=
384: psp_prt_shd.g_old_rec.display_all_emp_distrib_flag;
385: End If;
386: If (p_rec.manual_entry_override_flag = hr_api.g_varchar2) then
387: p_rec.manual_entry_override_flag :=
388: psp_prt_shd.g_old_rec.manual_entry_override_flag;
389: End If;
390: If (p_rec.approval_type = hr_api.g_varchar2) then

Line 390: If (p_rec.approval_type = hr_api.g_varchar2) then

386: If (p_rec.manual_entry_override_flag = hr_api.g_varchar2) then
387: p_rec.manual_entry_override_flag :=
388: psp_prt_shd.g_old_rec.manual_entry_override_flag;
389: End If;
390: If (p_rec.approval_type = hr_api.g_varchar2) then
391: p_rec.approval_type :=
392: psp_prt_shd.g_old_rec.approval_type;
393: End If;
394: If (p_rec.custom_approval_code = hr_api.g_varchar2) then

Line 394: If (p_rec.custom_approval_code = hr_api.g_varchar2) then

390: If (p_rec.approval_type = hr_api.g_varchar2) then
391: p_rec.approval_type :=
392: psp_prt_shd.g_old_rec.approval_type;
393: End If;
394: If (p_rec.custom_approval_code = hr_api.g_varchar2) then
395: p_rec.custom_approval_code :=
396: psp_prt_shd.g_old_rec.custom_approval_code;
397: End If;
398: If (p_rec.sup_levels = hr_api.g_number) then

Line 398: If (p_rec.sup_levels = hr_api.g_number) then

394: If (p_rec.custom_approval_code = hr_api.g_varchar2) then
395: p_rec.custom_approval_code :=
396: psp_prt_shd.g_old_rec.custom_approval_code;
397: End If;
398: If (p_rec.sup_levels = hr_api.g_number) then
399: p_rec.sup_levels :=
400: psp_prt_shd.g_old_rec.sup_levels;
401: End If;
402: If (p_rec.preview_effort_report_flag = hr_api.g_varchar2) then

Line 402: If (p_rec.preview_effort_report_flag = hr_api.g_varchar2) then

398: If (p_rec.sup_levels = hr_api.g_number) then
399: p_rec.sup_levels :=
400: psp_prt_shd.g_old_rec.sup_levels;
401: End If;
402: If (p_rec.preview_effort_report_flag = hr_api.g_varchar2) then
403: p_rec.preview_effort_report_flag :=
404: psp_prt_shd.g_old_rec.preview_effort_report_flag;
405: End If;
406: If (p_rec.notification_reminder_in_days = hr_api.g_number) then

Line 406: If (p_rec.notification_reminder_in_days = hr_api.g_number) then

402: If (p_rec.preview_effort_report_flag = hr_api.g_varchar2) then
403: p_rec.preview_effort_report_flag :=
404: psp_prt_shd.g_old_rec.preview_effort_report_flag;
405: End If;
406: If (p_rec.notification_reminder_in_days = hr_api.g_number) then
407: p_rec.notification_reminder_in_days :=
408: psp_prt_shd.g_old_rec.notification_reminder_in_days;
409: End If;
410: If (p_rec.sprcd_tolerance_amt = hr_api.g_number) then

Line 410: If (p_rec.sprcd_tolerance_amt = hr_api.g_number) then

406: If (p_rec.notification_reminder_in_days = hr_api.g_number) then
407: p_rec.notification_reminder_in_days :=
408: psp_prt_shd.g_old_rec.notification_reminder_in_days;
409: End If;
410: If (p_rec.sprcd_tolerance_amt = hr_api.g_number) then
411: p_rec.sprcd_tolerance_amt :=
412: psp_prt_shd.g_old_rec.sprcd_tolerance_amt;
413: End If;
414: If (p_rec.sprcd_tolerance_percent = hr_api.g_number) then

Line 414: If (p_rec.sprcd_tolerance_percent = hr_api.g_number) then

410: If (p_rec.sprcd_tolerance_amt = hr_api.g_number) then
411: p_rec.sprcd_tolerance_amt :=
412: psp_prt_shd.g_old_rec.sprcd_tolerance_amt;
413: End If;
414: If (p_rec.sprcd_tolerance_percent = hr_api.g_number) then
415: p_rec.sprcd_tolerance_percent :=
416: psp_prt_shd.g_old_rec.sprcd_tolerance_percent;
417: End If;
418: If (p_rec.description = hr_api.g_varchar2) then

Line 418: If (p_rec.description = hr_api.g_varchar2) then

414: If (p_rec.sprcd_tolerance_percent = hr_api.g_number) then
415: p_rec.sprcd_tolerance_percent :=
416: psp_prt_shd.g_old_rec.sprcd_tolerance_percent;
417: End If;
418: If (p_rec.description = hr_api.g_varchar2) then
419: p_rec.description :=
420: psp_prt_shd.g_old_rec.description;
421: End If;
422: If (p_rec.legislation_code = hr_api.g_varchar2) then

Line 422: If (p_rec.legislation_code = hr_api.g_varchar2) then

418: If (p_rec.description = hr_api.g_varchar2) then
419: p_rec.description :=
420: psp_prt_shd.g_old_rec.description;
421: End If;
422: If (p_rec.legislation_code = hr_api.g_varchar2) then
423: p_rec.legislation_code :=
424: psp_prt_shd.g_old_rec.legislation_code;
425: End If;
426: If (p_rec.hundred_pcent_eff_at_per_asg = hr_api.g_varchar2) then

Line 426: If (p_rec.hundred_pcent_eff_at_per_asg = hr_api.g_varchar2) then

422: If (p_rec.legislation_code = hr_api.g_varchar2) then
423: p_rec.legislation_code :=
424: psp_prt_shd.g_old_rec.legislation_code;
425: End If;
426: If (p_rec.hundred_pcent_eff_at_per_asg = hr_api.g_varchar2) then
427: p_rec.hundred_pcent_eff_at_per_asg :=
428: psp_prt_shd.g_old_rec.hundred_pcent_eff_at_per_asg;
429: End If;
430: If (p_rec.selection_match_level = hr_api.g_varchar2) then

Line 430: If (p_rec.selection_match_level = hr_api.g_varchar2) then

426: If (p_rec.hundred_pcent_eff_at_per_asg = hr_api.g_varchar2) then
427: p_rec.hundred_pcent_eff_at_per_asg :=
428: psp_prt_shd.g_old_rec.hundred_pcent_eff_at_per_asg;
429: End If;
430: If (p_rec.selection_match_level = hr_api.g_varchar2) then
431: p_rec.selection_match_level :=
432: psp_prt_shd.g_old_rec.selection_match_level;
433: End If;
434: --

Line 494: ,p_template_name in varchar2 default hr_api.g_varchar2

490: -- ----------------------------------------------------------------------------
491: Procedure upd
492: (p_template_id in number
493: ,p_object_version_number in out nocopy number
494: ,p_template_name in varchar2 default hr_api.g_varchar2
495: ,p_business_group_id in number default hr_api.g_number
496: ,p_set_of_books_id in number default hr_api.g_number
497: ,p_report_type in varchar2 default hr_api.g_varchar2
498: ,p_period_frequency_id in number default hr_api.g_number

Line 495: ,p_business_group_id in number default hr_api.g_number

491: Procedure upd
492: (p_template_id in number
493: ,p_object_version_number in out nocopy number
494: ,p_template_name in varchar2 default hr_api.g_varchar2
495: ,p_business_group_id in number default hr_api.g_number
496: ,p_set_of_books_id in number default hr_api.g_number
497: ,p_report_type in varchar2 default hr_api.g_varchar2
498: ,p_period_frequency_id in number default hr_api.g_number
499: ,p_report_template_code in varchar2 default hr_api.g_varchar2

Line 496: ,p_set_of_books_id in number default hr_api.g_number

492: (p_template_id in number
493: ,p_object_version_number in out nocopy number
494: ,p_template_name in varchar2 default hr_api.g_varchar2
495: ,p_business_group_id in number default hr_api.g_number
496: ,p_set_of_books_id in number default hr_api.g_number
497: ,p_report_type in varchar2 default hr_api.g_varchar2
498: ,p_period_frequency_id in number default hr_api.g_number
499: ,p_report_template_code in varchar2 default hr_api.g_varchar2
500: ,p_approval_type in varchar2 default hr_api.g_varchar2

Line 497: ,p_report_type in varchar2 default hr_api.g_varchar2

493: ,p_object_version_number in out nocopy number
494: ,p_template_name in varchar2 default hr_api.g_varchar2
495: ,p_business_group_id in number default hr_api.g_number
496: ,p_set_of_books_id in number default hr_api.g_number
497: ,p_report_type in varchar2 default hr_api.g_varchar2
498: ,p_period_frequency_id in number default hr_api.g_number
499: ,p_report_template_code in varchar2 default hr_api.g_varchar2
500: ,p_approval_type in varchar2 default hr_api.g_varchar2
501: ,p_preview_effort_report_flag in varchar2 default hr_api.g_varchar2

Line 498: ,p_period_frequency_id in number default hr_api.g_number

494: ,p_template_name in varchar2 default hr_api.g_varchar2
495: ,p_business_group_id in number default hr_api.g_number
496: ,p_set_of_books_id in number default hr_api.g_number
497: ,p_report_type in varchar2 default hr_api.g_varchar2
498: ,p_period_frequency_id in number default hr_api.g_number
499: ,p_report_template_code in varchar2 default hr_api.g_varchar2
500: ,p_approval_type in varchar2 default hr_api.g_varchar2
501: ,p_preview_effort_report_flag in varchar2 default hr_api.g_varchar2
502: ,p_hundred_pcent_eff_at_per_asg in varchar2 default hr_api.g_varchar2

Line 499: ,p_report_template_code in varchar2 default hr_api.g_varchar2

495: ,p_business_group_id in number default hr_api.g_number
496: ,p_set_of_books_id in number default hr_api.g_number
497: ,p_report_type in varchar2 default hr_api.g_varchar2
498: ,p_period_frequency_id in number default hr_api.g_number
499: ,p_report_template_code in varchar2 default hr_api.g_varchar2
500: ,p_approval_type in varchar2 default hr_api.g_varchar2
501: ,p_preview_effort_report_flag in varchar2 default hr_api.g_varchar2
502: ,p_hundred_pcent_eff_at_per_asg in varchar2 default hr_api.g_varchar2
503: ,p_selection_match_level in varchar2 default hr_api.g_varchar2

Line 500: ,p_approval_type in varchar2 default hr_api.g_varchar2

496: ,p_set_of_books_id in number default hr_api.g_number
497: ,p_report_type in varchar2 default hr_api.g_varchar2
498: ,p_period_frequency_id in number default hr_api.g_number
499: ,p_report_template_code in varchar2 default hr_api.g_varchar2
500: ,p_approval_type in varchar2 default hr_api.g_varchar2
501: ,p_preview_effort_report_flag in varchar2 default hr_api.g_varchar2
502: ,p_hundred_pcent_eff_at_per_asg in varchar2 default hr_api.g_varchar2
503: ,p_selection_match_level in varchar2 default hr_api.g_varchar2
504: ,p_display_all_emp_distrib_flag in varchar2 default hr_api.g_varchar2

Line 501: ,p_preview_effort_report_flag in varchar2 default hr_api.g_varchar2

497: ,p_report_type in varchar2 default hr_api.g_varchar2
498: ,p_period_frequency_id in number default hr_api.g_number
499: ,p_report_template_code in varchar2 default hr_api.g_varchar2
500: ,p_approval_type in varchar2 default hr_api.g_varchar2
501: ,p_preview_effort_report_flag in varchar2 default hr_api.g_varchar2
502: ,p_hundred_pcent_eff_at_per_asg in varchar2 default hr_api.g_varchar2
503: ,p_selection_match_level in varchar2 default hr_api.g_varchar2
504: ,p_display_all_emp_distrib_flag in varchar2 default hr_api.g_varchar2
505: ,p_manual_entry_override_flag in varchar2 default hr_api.g_varchar2

Line 502: ,p_hundred_pcent_eff_at_per_asg in varchar2 default hr_api.g_varchar2

498: ,p_period_frequency_id in number default hr_api.g_number
499: ,p_report_template_code in varchar2 default hr_api.g_varchar2
500: ,p_approval_type in varchar2 default hr_api.g_varchar2
501: ,p_preview_effort_report_flag in varchar2 default hr_api.g_varchar2
502: ,p_hundred_pcent_eff_at_per_asg in varchar2 default hr_api.g_varchar2
503: ,p_selection_match_level in varchar2 default hr_api.g_varchar2
504: ,p_display_all_emp_distrib_flag in varchar2 default hr_api.g_varchar2
505: ,p_manual_entry_override_flag in varchar2 default hr_api.g_varchar2
506: ,p_custom_approval_code in varchar2 default hr_api.g_varchar2

Line 503: ,p_selection_match_level in varchar2 default hr_api.g_varchar2

499: ,p_report_template_code in varchar2 default hr_api.g_varchar2
500: ,p_approval_type in varchar2 default hr_api.g_varchar2
501: ,p_preview_effort_report_flag in varchar2 default hr_api.g_varchar2
502: ,p_hundred_pcent_eff_at_per_asg in varchar2 default hr_api.g_varchar2
503: ,p_selection_match_level in varchar2 default hr_api.g_varchar2
504: ,p_display_all_emp_distrib_flag in varchar2 default hr_api.g_varchar2
505: ,p_manual_entry_override_flag in varchar2 default hr_api.g_varchar2
506: ,p_custom_approval_code in varchar2 default hr_api.g_varchar2
507: ,p_sup_levels in number default hr_api.g_number

Line 504: ,p_display_all_emp_distrib_flag in varchar2 default hr_api.g_varchar2

500: ,p_approval_type in varchar2 default hr_api.g_varchar2
501: ,p_preview_effort_report_flag in varchar2 default hr_api.g_varchar2
502: ,p_hundred_pcent_eff_at_per_asg in varchar2 default hr_api.g_varchar2
503: ,p_selection_match_level in varchar2 default hr_api.g_varchar2
504: ,p_display_all_emp_distrib_flag in varchar2 default hr_api.g_varchar2
505: ,p_manual_entry_override_flag in varchar2 default hr_api.g_varchar2
506: ,p_custom_approval_code in varchar2 default hr_api.g_varchar2
507: ,p_sup_levels in number default hr_api.g_number
508: ,p_notification_reminder_in_day in number default hr_api.g_number

Line 505: ,p_manual_entry_override_flag in varchar2 default hr_api.g_varchar2

501: ,p_preview_effort_report_flag in varchar2 default hr_api.g_varchar2
502: ,p_hundred_pcent_eff_at_per_asg in varchar2 default hr_api.g_varchar2
503: ,p_selection_match_level in varchar2 default hr_api.g_varchar2
504: ,p_display_all_emp_distrib_flag in varchar2 default hr_api.g_varchar2
505: ,p_manual_entry_override_flag in varchar2 default hr_api.g_varchar2
506: ,p_custom_approval_code in varchar2 default hr_api.g_varchar2
507: ,p_sup_levels in number default hr_api.g_number
508: ,p_notification_reminder_in_day in number default hr_api.g_number
509: ,p_sprcd_tolerance_amt in number default hr_api.g_number

Line 506: ,p_custom_approval_code in varchar2 default hr_api.g_varchar2

502: ,p_hundred_pcent_eff_at_per_asg in varchar2 default hr_api.g_varchar2
503: ,p_selection_match_level in varchar2 default hr_api.g_varchar2
504: ,p_display_all_emp_distrib_flag in varchar2 default hr_api.g_varchar2
505: ,p_manual_entry_override_flag in varchar2 default hr_api.g_varchar2
506: ,p_custom_approval_code in varchar2 default hr_api.g_varchar2
507: ,p_sup_levels in number default hr_api.g_number
508: ,p_notification_reminder_in_day in number default hr_api.g_number
509: ,p_sprcd_tolerance_amt in number default hr_api.g_number
510: ,p_sprcd_tolerance_percent in number default hr_api.g_number

Line 507: ,p_sup_levels in number default hr_api.g_number

503: ,p_selection_match_level in varchar2 default hr_api.g_varchar2
504: ,p_display_all_emp_distrib_flag in varchar2 default hr_api.g_varchar2
505: ,p_manual_entry_override_flag in varchar2 default hr_api.g_varchar2
506: ,p_custom_approval_code in varchar2 default hr_api.g_varchar2
507: ,p_sup_levels in number default hr_api.g_number
508: ,p_notification_reminder_in_day in number default hr_api.g_number
509: ,p_sprcd_tolerance_amt in number default hr_api.g_number
510: ,p_sprcd_tolerance_percent in number default hr_api.g_number
511: ,p_description in varchar2 default hr_api.g_varchar2

Line 508: ,p_notification_reminder_in_day in number default hr_api.g_number

504: ,p_display_all_emp_distrib_flag in varchar2 default hr_api.g_varchar2
505: ,p_manual_entry_override_flag in varchar2 default hr_api.g_varchar2
506: ,p_custom_approval_code in varchar2 default hr_api.g_varchar2
507: ,p_sup_levels in number default hr_api.g_number
508: ,p_notification_reminder_in_day in number default hr_api.g_number
509: ,p_sprcd_tolerance_amt in number default hr_api.g_number
510: ,p_sprcd_tolerance_percent in number default hr_api.g_number
511: ,p_description in varchar2 default hr_api.g_varchar2
512: ,p_legislation_code in varchar2 default hr_api.g_varchar2

Line 509: ,p_sprcd_tolerance_amt in number default hr_api.g_number

505: ,p_manual_entry_override_flag in varchar2 default hr_api.g_varchar2
506: ,p_custom_approval_code in varchar2 default hr_api.g_varchar2
507: ,p_sup_levels in number default hr_api.g_number
508: ,p_notification_reminder_in_day in number default hr_api.g_number
509: ,p_sprcd_tolerance_amt in number default hr_api.g_number
510: ,p_sprcd_tolerance_percent in number default hr_api.g_number
511: ,p_description in varchar2 default hr_api.g_varchar2
512: ,p_legislation_code in varchar2 default hr_api.g_varchar2
513: ) is

Line 510: ,p_sprcd_tolerance_percent in number default hr_api.g_number

506: ,p_custom_approval_code in varchar2 default hr_api.g_varchar2
507: ,p_sup_levels in number default hr_api.g_number
508: ,p_notification_reminder_in_day in number default hr_api.g_number
509: ,p_sprcd_tolerance_amt in number default hr_api.g_number
510: ,p_sprcd_tolerance_percent in number default hr_api.g_number
511: ,p_description in varchar2 default hr_api.g_varchar2
512: ,p_legislation_code in varchar2 default hr_api.g_varchar2
513: ) is
514: --

Line 511: ,p_description in varchar2 default hr_api.g_varchar2

507: ,p_sup_levels in number default hr_api.g_number
508: ,p_notification_reminder_in_day in number default hr_api.g_number
509: ,p_sprcd_tolerance_amt in number default hr_api.g_number
510: ,p_sprcd_tolerance_percent in number default hr_api.g_number
511: ,p_description in varchar2 default hr_api.g_varchar2
512: ,p_legislation_code in varchar2 default hr_api.g_varchar2
513: ) is
514: --
515: l_rec psp_prt_shd.g_rec_type;

Line 512: ,p_legislation_code in varchar2 default hr_api.g_varchar2

508: ,p_notification_reminder_in_day in number default hr_api.g_number
509: ,p_sprcd_tolerance_amt in number default hr_api.g_number
510: ,p_sprcd_tolerance_percent in number default hr_api.g_number
511: ,p_description in varchar2 default hr_api.g_varchar2
512: ,p_legislation_code in varchar2 default hr_api.g_varchar2
513: ) is
514: --
515: l_rec psp_prt_shd.g_rec_type;
516: l_proc varchar2(72) := g_package||'upd';