APPS.PSP_EFF_REPORT_DETAILS_API dependencies on PSP_EFF_REPORT_DETAILS_API

Line 1: PACKAGE BODY PSP_EFF_REPORT_DETAILS_API as

1: PACKAGE BODY PSP_EFF_REPORT_DETAILS_API as
2: /* $Header: PSPEDAIB.pls 120.4 2006/01/30 22:33:34 dpaudel noship $ */
3: --
4: -- Package Variables
5: --

Line 6: g_package varchar2(33) := ' PSP_EFF_REPORT_DETAILS_API.';

2: /* $Header: PSPEDAIB.pls 120.4 2006/01/30 22:33:34 dpaudel noship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' PSP_EFF_REPORT_DETAILS_API.';
7: MAX_percent_validation_flag Exception;
8: Range_percent_validation_flag Exception;
9: --
10: -- ----------------------------------------------------------------------------

Line 37: l_approver_person_id psp_eff_report_details_api.assignment_id;

33: l_return_status varchar2(30);
34: l_start_date date; --- uva fix
35: l_end_date date; --- uva fix
36:
37: l_approver_person_id psp_eff_report_details_api.assignment_id;
38: l_investigator_name psp_eff_report_details_api.full_name_type;
39: l_investigator_org_name psp_eff_report_details_api.full_name_type;
40: l_inv_primary_org_id psp_eff_report_details_api.assignment_id;
41:

Line 38: l_investigator_name psp_eff_report_details_api.full_name_type;

34: l_start_date date; --- uva fix
35: l_end_date date; --- uva fix
36:
37: l_approver_person_id psp_eff_report_details_api.assignment_id;
38: l_investigator_name psp_eff_report_details_api.full_name_type;
39: l_investigator_org_name psp_eff_report_details_api.full_name_type;
40: l_inv_primary_org_id psp_eff_report_details_api.assignment_id;
41:
42:

Line 39: l_investigator_org_name psp_eff_report_details_api.full_name_type;

35: l_end_date date; --- uva fix
36:
37: l_approver_person_id psp_eff_report_details_api.assignment_id;
38: l_investigator_name psp_eff_report_details_api.full_name_type;
39: l_investigator_org_name psp_eff_report_details_api.full_name_type;
40: l_inv_primary_org_id psp_eff_report_details_api.assignment_id;
41:
42:
43: -- uva fix.

Line 40: l_inv_primary_org_id psp_eff_report_details_api.assignment_id;

36:
37: l_approver_person_id psp_eff_report_details_api.assignment_id;
38: l_investigator_name psp_eff_report_details_api.full_name_type;
39: l_investigator_org_name psp_eff_report_details_api.full_name_type;
40: l_inv_primary_org_id psp_eff_report_details_api.assignment_id;
41:
42:
43: -- uva fix.
44: cursor get_er_dates is

Line 540: end PSP_EFF_REPORT_DETAILS_API;

536: hr_utility.set_location(' Leaving:'||l_proc, 90);
537: raise FND_API.G_EXC_UNEXPECTED_ERROR;
538: end UPDATE_EFF_REPORT_DETAILS;
539: --
540: end PSP_EFF_REPORT_DETAILS_API;