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_EFF_REPORT_DETAILS_API dependencies on PSP_EFF_REPORT_DETAILS

Line 1: PACKAGE PSP_EFF_REPORT_DETAILS_API AUTHID CURRENT_USER as

1: PACKAGE PSP_EFF_REPORT_DETAILS_API AUTHID CURRENT_USER as
2: /* $Header: PSPEDAIS.pls 120.5 2006/01/25 01:49:59 dpaudel noship $ */
3: /*#
4: * This package contains Update API for Effort Report Details.
5: * @rep:scope public

Line 9: TYPE proposed_salary_amt_TYPE IS TABLE OF PSP_EFF_REPORT_DETAILS.PROPOSED_SALARY_AMT%TYPE INDEX BY BINARY_INTEGER;

5: * @rep:scope public
6: * @rep:product PER
7: * @rep:displayname Effort Report Detail
8: */
9: TYPE proposed_salary_amt_TYPE IS TABLE OF PSP_EFF_REPORT_DETAILS.PROPOSED_SALARY_AMT%TYPE INDEX BY BINARY_INTEGER;
10: TYPE proposed_effort_percent_TYPE IS TABLE OF PSP_EFF_REPORT_DETAILS.proposed_effort_percent%TYPE INDEX BY BINARY_INTEGER;
11: TYPE committed_cost_share_TYPE IS TABLE OF PSP_EFF_REPORT_DETAILS.committed_cost_share%TYPE INDEX BY BINARY_INTEGER;
12: TYPE value_TYPE IS TABLE OF PSP_EFF_REPORT_DETAILS.value1%TYPE INDEX BY BINARY_INTEGER;
13: TYPE attribute_TYPE IS TABLE OF PSP_EFF_REPORT_DETAILS.attribute1%TYPE INDEX BY BINARY_INTEGER;

Line 10: TYPE proposed_effort_percent_TYPE IS TABLE OF PSP_EFF_REPORT_DETAILS.proposed_effort_percent%TYPE INDEX BY BINARY_INTEGER;

6: * @rep:product PER
7: * @rep:displayname Effort Report Detail
8: */
9: TYPE proposed_salary_amt_TYPE IS TABLE OF PSP_EFF_REPORT_DETAILS.PROPOSED_SALARY_AMT%TYPE INDEX BY BINARY_INTEGER;
10: TYPE proposed_effort_percent_TYPE IS TABLE OF PSP_EFF_REPORT_DETAILS.proposed_effort_percent%TYPE INDEX BY BINARY_INTEGER;
11: TYPE committed_cost_share_TYPE IS TABLE OF PSP_EFF_REPORT_DETAILS.committed_cost_share%TYPE INDEX BY BINARY_INTEGER;
12: TYPE value_TYPE IS TABLE OF PSP_EFF_REPORT_DETAILS.value1%TYPE INDEX BY BINARY_INTEGER;
13: TYPE attribute_TYPE IS TABLE OF PSP_EFF_REPORT_DETAILS.attribute1%TYPE INDEX BY BINARY_INTEGER;
14: TYPE EFFORT_REPORT_DETAIL_ID_TYPE IS TABLE OF PSP_EFF_REPORT_DETAILS.EFFORT_REPORT_DETAIL_ID%TYPE INDEX BY BINARY_INTEGER;

Line 11: TYPE committed_cost_share_TYPE IS TABLE OF PSP_EFF_REPORT_DETAILS.committed_cost_share%TYPE INDEX BY BINARY_INTEGER;

7: * @rep:displayname Effort Report Detail
8: */
9: TYPE proposed_salary_amt_TYPE IS TABLE OF PSP_EFF_REPORT_DETAILS.PROPOSED_SALARY_AMT%TYPE INDEX BY BINARY_INTEGER;
10: TYPE proposed_effort_percent_TYPE IS TABLE OF PSP_EFF_REPORT_DETAILS.proposed_effort_percent%TYPE INDEX BY BINARY_INTEGER;
11: TYPE committed_cost_share_TYPE IS TABLE OF PSP_EFF_REPORT_DETAILS.committed_cost_share%TYPE INDEX BY BINARY_INTEGER;
12: TYPE value_TYPE IS TABLE OF PSP_EFF_REPORT_DETAILS.value1%TYPE INDEX BY BINARY_INTEGER;
13: TYPE attribute_TYPE IS TABLE OF PSP_EFF_REPORT_DETAILS.attribute1%TYPE INDEX BY BINARY_INTEGER;
14: TYPE EFFORT_REPORT_DETAIL_ID_TYPE IS TABLE OF PSP_EFF_REPORT_DETAILS.EFFORT_REPORT_DETAIL_ID%TYPE INDEX BY BINARY_INTEGER;
15: TYPE ASSIGNMENT_ID IS TABLE OF PSP_EFF_REPORT_DETAILS.ASSIGNMENT_ID%TYPE INDEX BY BINARY_INTEGER;

Line 12: TYPE value_TYPE IS TABLE OF PSP_EFF_REPORT_DETAILS.value1%TYPE INDEX BY BINARY_INTEGER;

8: */
9: TYPE proposed_salary_amt_TYPE IS TABLE OF PSP_EFF_REPORT_DETAILS.PROPOSED_SALARY_AMT%TYPE INDEX BY BINARY_INTEGER;
10: TYPE proposed_effort_percent_TYPE IS TABLE OF PSP_EFF_REPORT_DETAILS.proposed_effort_percent%TYPE INDEX BY BINARY_INTEGER;
11: TYPE committed_cost_share_TYPE IS TABLE OF PSP_EFF_REPORT_DETAILS.committed_cost_share%TYPE INDEX BY BINARY_INTEGER;
12: TYPE value_TYPE IS TABLE OF PSP_EFF_REPORT_DETAILS.value1%TYPE INDEX BY BINARY_INTEGER;
13: TYPE attribute_TYPE IS TABLE OF PSP_EFF_REPORT_DETAILS.attribute1%TYPE INDEX BY BINARY_INTEGER;
14: TYPE EFFORT_REPORT_DETAIL_ID_TYPE IS TABLE OF PSP_EFF_REPORT_DETAILS.EFFORT_REPORT_DETAIL_ID%TYPE INDEX BY BINARY_INTEGER;
15: TYPE ASSIGNMENT_ID IS TABLE OF PSP_EFF_REPORT_DETAILS.ASSIGNMENT_ID%TYPE INDEX BY BINARY_INTEGER;
16: TYPE GL_SEGMENT IS TABLE OF PSP_EFF_REPORT_DETAILS.GL_SEGMENT1%TYPE INDEX BY BINARY_INTEGER;

Line 13: TYPE attribute_TYPE IS TABLE OF PSP_EFF_REPORT_DETAILS.attribute1%TYPE INDEX BY BINARY_INTEGER;

9: TYPE proposed_salary_amt_TYPE IS TABLE OF PSP_EFF_REPORT_DETAILS.PROPOSED_SALARY_AMT%TYPE INDEX BY BINARY_INTEGER;
10: TYPE proposed_effort_percent_TYPE IS TABLE OF PSP_EFF_REPORT_DETAILS.proposed_effort_percent%TYPE INDEX BY BINARY_INTEGER;
11: TYPE committed_cost_share_TYPE IS TABLE OF PSP_EFF_REPORT_DETAILS.committed_cost_share%TYPE INDEX BY BINARY_INTEGER;
12: TYPE value_TYPE IS TABLE OF PSP_EFF_REPORT_DETAILS.value1%TYPE INDEX BY BINARY_INTEGER;
13: TYPE attribute_TYPE IS TABLE OF PSP_EFF_REPORT_DETAILS.attribute1%TYPE INDEX BY BINARY_INTEGER;
14: TYPE EFFORT_REPORT_DETAIL_ID_TYPE IS TABLE OF PSP_EFF_REPORT_DETAILS.EFFORT_REPORT_DETAIL_ID%TYPE INDEX BY BINARY_INTEGER;
15: TYPE ASSIGNMENT_ID IS TABLE OF PSP_EFF_REPORT_DETAILS.ASSIGNMENT_ID%TYPE INDEX BY BINARY_INTEGER;
16: TYPE GL_SEGMENT IS TABLE OF PSP_EFF_REPORT_DETAILS.GL_SEGMENT1%TYPE INDEX BY BINARY_INTEGER;
17: TYPE PROJECT_ID IS TABLE OF PSP_EFF_REPORT_DETAILS.PROJECT_ID%TYPE INDEX BY BINARY_INTEGER;

Line 14: TYPE EFFORT_REPORT_DETAIL_ID_TYPE IS TABLE OF PSP_EFF_REPORT_DETAILS.EFFORT_REPORT_DETAIL_ID%TYPE INDEX BY BINARY_INTEGER;

10: TYPE proposed_effort_percent_TYPE IS TABLE OF PSP_EFF_REPORT_DETAILS.proposed_effort_percent%TYPE INDEX BY BINARY_INTEGER;
11: TYPE committed_cost_share_TYPE IS TABLE OF PSP_EFF_REPORT_DETAILS.committed_cost_share%TYPE INDEX BY BINARY_INTEGER;
12: TYPE value_TYPE IS TABLE OF PSP_EFF_REPORT_DETAILS.value1%TYPE INDEX BY BINARY_INTEGER;
13: TYPE attribute_TYPE IS TABLE OF PSP_EFF_REPORT_DETAILS.attribute1%TYPE INDEX BY BINARY_INTEGER;
14: TYPE EFFORT_REPORT_DETAIL_ID_TYPE IS TABLE OF PSP_EFF_REPORT_DETAILS.EFFORT_REPORT_DETAIL_ID%TYPE INDEX BY BINARY_INTEGER;
15: TYPE ASSIGNMENT_ID IS TABLE OF PSP_EFF_REPORT_DETAILS.ASSIGNMENT_ID%TYPE INDEX BY BINARY_INTEGER;
16: TYPE GL_SEGMENT IS TABLE OF PSP_EFF_REPORT_DETAILS.GL_SEGMENT1%TYPE INDEX BY BINARY_INTEGER;
17: TYPE PROJECT_ID IS TABLE OF PSP_EFF_REPORT_DETAILS.PROJECT_ID%TYPE INDEX BY BINARY_INTEGER;
18: TYPE EXPENDITURE_ORGANIZATION_ID IS TABLE OF PSP_EFF_REPORT_DETAILS.EXPENDITURE_ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 15: TYPE ASSIGNMENT_ID IS TABLE OF PSP_EFF_REPORT_DETAILS.ASSIGNMENT_ID%TYPE INDEX BY BINARY_INTEGER;

11: TYPE committed_cost_share_TYPE IS TABLE OF PSP_EFF_REPORT_DETAILS.committed_cost_share%TYPE INDEX BY BINARY_INTEGER;
12: TYPE value_TYPE IS TABLE OF PSP_EFF_REPORT_DETAILS.value1%TYPE INDEX BY BINARY_INTEGER;
13: TYPE attribute_TYPE IS TABLE OF PSP_EFF_REPORT_DETAILS.attribute1%TYPE INDEX BY BINARY_INTEGER;
14: TYPE EFFORT_REPORT_DETAIL_ID_TYPE IS TABLE OF PSP_EFF_REPORT_DETAILS.EFFORT_REPORT_DETAIL_ID%TYPE INDEX BY BINARY_INTEGER;
15: TYPE ASSIGNMENT_ID IS TABLE OF PSP_EFF_REPORT_DETAILS.ASSIGNMENT_ID%TYPE INDEX BY BINARY_INTEGER;
16: TYPE GL_SEGMENT IS TABLE OF PSP_EFF_REPORT_DETAILS.GL_SEGMENT1%TYPE INDEX BY BINARY_INTEGER;
17: TYPE PROJECT_ID IS TABLE OF PSP_EFF_REPORT_DETAILS.PROJECT_ID%TYPE INDEX BY BINARY_INTEGER;
18: TYPE EXPENDITURE_ORGANIZATION_ID IS TABLE OF PSP_EFF_REPORT_DETAILS.EXPENDITURE_ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;
19: TYPE EXPENDITURE_TYPE IS TABLE OF PSP_EFF_REPORT_DETAILS.EXPENDITURE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 16: TYPE GL_SEGMENT IS TABLE OF PSP_EFF_REPORT_DETAILS.GL_SEGMENT1%TYPE INDEX BY BINARY_INTEGER;

12: TYPE value_TYPE IS TABLE OF PSP_EFF_REPORT_DETAILS.value1%TYPE INDEX BY BINARY_INTEGER;
13: TYPE attribute_TYPE IS TABLE OF PSP_EFF_REPORT_DETAILS.attribute1%TYPE INDEX BY BINARY_INTEGER;
14: TYPE EFFORT_REPORT_DETAIL_ID_TYPE IS TABLE OF PSP_EFF_REPORT_DETAILS.EFFORT_REPORT_DETAIL_ID%TYPE INDEX BY BINARY_INTEGER;
15: TYPE ASSIGNMENT_ID IS TABLE OF PSP_EFF_REPORT_DETAILS.ASSIGNMENT_ID%TYPE INDEX BY BINARY_INTEGER;
16: TYPE GL_SEGMENT IS TABLE OF PSP_EFF_REPORT_DETAILS.GL_SEGMENT1%TYPE INDEX BY BINARY_INTEGER;
17: TYPE PROJECT_ID IS TABLE OF PSP_EFF_REPORT_DETAILS.PROJECT_ID%TYPE INDEX BY BINARY_INTEGER;
18: TYPE EXPENDITURE_ORGANIZATION_ID IS TABLE OF PSP_EFF_REPORT_DETAILS.EXPENDITURE_ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;
19: TYPE EXPENDITURE_TYPE IS TABLE OF PSP_EFF_REPORT_DETAILS.EXPENDITURE_TYPE%TYPE INDEX BY BINARY_INTEGER;
20: TYPE TASK_ID IS TABLE OF PSP_EFF_REPORT_DETAILS.TASK_ID%TYPE INDEX BY BINARY_INTEGER;

Line 17: TYPE PROJECT_ID IS TABLE OF PSP_EFF_REPORT_DETAILS.PROJECT_ID%TYPE INDEX BY BINARY_INTEGER;

13: TYPE attribute_TYPE IS TABLE OF PSP_EFF_REPORT_DETAILS.attribute1%TYPE INDEX BY BINARY_INTEGER;
14: TYPE EFFORT_REPORT_DETAIL_ID_TYPE IS TABLE OF PSP_EFF_REPORT_DETAILS.EFFORT_REPORT_DETAIL_ID%TYPE INDEX BY BINARY_INTEGER;
15: TYPE ASSIGNMENT_ID IS TABLE OF PSP_EFF_REPORT_DETAILS.ASSIGNMENT_ID%TYPE INDEX BY BINARY_INTEGER;
16: TYPE GL_SEGMENT IS TABLE OF PSP_EFF_REPORT_DETAILS.GL_SEGMENT1%TYPE INDEX BY BINARY_INTEGER;
17: TYPE PROJECT_ID IS TABLE OF PSP_EFF_REPORT_DETAILS.PROJECT_ID%TYPE INDEX BY BINARY_INTEGER;
18: TYPE EXPENDITURE_ORGANIZATION_ID IS TABLE OF PSP_EFF_REPORT_DETAILS.EXPENDITURE_ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;
19: TYPE EXPENDITURE_TYPE IS TABLE OF PSP_EFF_REPORT_DETAILS.EXPENDITURE_TYPE%TYPE INDEX BY BINARY_INTEGER;
20: TYPE TASK_ID IS TABLE OF PSP_EFF_REPORT_DETAILS.TASK_ID%TYPE INDEX BY BINARY_INTEGER;
21: TYPE AWARD_ID IS TABLE OF PSP_EFF_REPORT_DETAILS.AWARD_ID%TYPE INDEX BY BINARY_INTEGER;

Line 18: TYPE EXPENDITURE_ORGANIZATION_ID IS TABLE OF PSP_EFF_REPORT_DETAILS.EXPENDITURE_ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;

14: TYPE EFFORT_REPORT_DETAIL_ID_TYPE IS TABLE OF PSP_EFF_REPORT_DETAILS.EFFORT_REPORT_DETAIL_ID%TYPE INDEX BY BINARY_INTEGER;
15: TYPE ASSIGNMENT_ID IS TABLE OF PSP_EFF_REPORT_DETAILS.ASSIGNMENT_ID%TYPE INDEX BY BINARY_INTEGER;
16: TYPE GL_SEGMENT IS TABLE OF PSP_EFF_REPORT_DETAILS.GL_SEGMENT1%TYPE INDEX BY BINARY_INTEGER;
17: TYPE PROJECT_ID IS TABLE OF PSP_EFF_REPORT_DETAILS.PROJECT_ID%TYPE INDEX BY BINARY_INTEGER;
18: TYPE EXPENDITURE_ORGANIZATION_ID IS TABLE OF PSP_EFF_REPORT_DETAILS.EXPENDITURE_ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;
19: TYPE EXPENDITURE_TYPE IS TABLE OF PSP_EFF_REPORT_DETAILS.EXPENDITURE_TYPE%TYPE INDEX BY BINARY_INTEGER;
20: TYPE TASK_ID IS TABLE OF PSP_EFF_REPORT_DETAILS.TASK_ID%TYPE INDEX BY BINARY_INTEGER;
21: TYPE AWARD_ID IS TABLE OF PSP_EFF_REPORT_DETAILS.AWARD_ID%TYPE INDEX BY BINARY_INTEGER;
22: TYPE OBJECT_VERSION_NUMBER_TYPE IS TABLE OF PSP_EFF_REPORT_DETAILS.OBJECT_VERSION_NUMBER%TYPE INDEX BY BINARY_INTEGER;

Line 19: TYPE EXPENDITURE_TYPE IS TABLE OF PSP_EFF_REPORT_DETAILS.EXPENDITURE_TYPE%TYPE INDEX BY BINARY_INTEGER;

15: TYPE ASSIGNMENT_ID IS TABLE OF PSP_EFF_REPORT_DETAILS.ASSIGNMENT_ID%TYPE INDEX BY BINARY_INTEGER;
16: TYPE GL_SEGMENT IS TABLE OF PSP_EFF_REPORT_DETAILS.GL_SEGMENT1%TYPE INDEX BY BINARY_INTEGER;
17: TYPE PROJECT_ID IS TABLE OF PSP_EFF_REPORT_DETAILS.PROJECT_ID%TYPE INDEX BY BINARY_INTEGER;
18: TYPE EXPENDITURE_ORGANIZATION_ID IS TABLE OF PSP_EFF_REPORT_DETAILS.EXPENDITURE_ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;
19: TYPE EXPENDITURE_TYPE IS TABLE OF PSP_EFF_REPORT_DETAILS.EXPENDITURE_TYPE%TYPE INDEX BY BINARY_INTEGER;
20: TYPE TASK_ID IS TABLE OF PSP_EFF_REPORT_DETAILS.TASK_ID%TYPE INDEX BY BINARY_INTEGER;
21: TYPE AWARD_ID IS TABLE OF PSP_EFF_REPORT_DETAILS.AWARD_ID%TYPE INDEX BY BINARY_INTEGER;
22: TYPE OBJECT_VERSION_NUMBER_TYPE IS TABLE OF PSP_EFF_REPORT_DETAILS.OBJECT_VERSION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
23: TYPE FULL_NAME_TYPE IS TABLE OF PSP_EFF_REPORTS.FULL_NAME%TYPE INDEX BY BINARY_INTEGER;

Line 20: TYPE TASK_ID IS TABLE OF PSP_EFF_REPORT_DETAILS.TASK_ID%TYPE INDEX BY BINARY_INTEGER;

16: TYPE GL_SEGMENT IS TABLE OF PSP_EFF_REPORT_DETAILS.GL_SEGMENT1%TYPE INDEX BY BINARY_INTEGER;
17: TYPE PROJECT_ID IS TABLE OF PSP_EFF_REPORT_DETAILS.PROJECT_ID%TYPE INDEX BY BINARY_INTEGER;
18: TYPE EXPENDITURE_ORGANIZATION_ID IS TABLE OF PSP_EFF_REPORT_DETAILS.EXPENDITURE_ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;
19: TYPE EXPENDITURE_TYPE IS TABLE OF PSP_EFF_REPORT_DETAILS.EXPENDITURE_TYPE%TYPE INDEX BY BINARY_INTEGER;
20: TYPE TASK_ID IS TABLE OF PSP_EFF_REPORT_DETAILS.TASK_ID%TYPE INDEX BY BINARY_INTEGER;
21: TYPE AWARD_ID IS TABLE OF PSP_EFF_REPORT_DETAILS.AWARD_ID%TYPE INDEX BY BINARY_INTEGER;
22: TYPE OBJECT_VERSION_NUMBER_TYPE IS TABLE OF PSP_EFF_REPORT_DETAILS.OBJECT_VERSION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
23: TYPE FULL_NAME_TYPE IS TABLE OF PSP_EFF_REPORTS.FULL_NAME%TYPE INDEX BY BINARY_INTEGER;
24: TYPE GROUPING_CATEGORY IS TABLE OF PSP_EFF_REPORT_DETAILS.GROUPING_CATEGORY%TYPE INDEX BY BINARY_INTEGER; -- Add for Hospital Effort Report

Line 21: TYPE AWARD_ID IS TABLE OF PSP_EFF_REPORT_DETAILS.AWARD_ID%TYPE INDEX BY BINARY_INTEGER;

17: TYPE PROJECT_ID IS TABLE OF PSP_EFF_REPORT_DETAILS.PROJECT_ID%TYPE INDEX BY BINARY_INTEGER;
18: TYPE EXPENDITURE_ORGANIZATION_ID IS TABLE OF PSP_EFF_REPORT_DETAILS.EXPENDITURE_ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;
19: TYPE EXPENDITURE_TYPE IS TABLE OF PSP_EFF_REPORT_DETAILS.EXPENDITURE_TYPE%TYPE INDEX BY BINARY_INTEGER;
20: TYPE TASK_ID IS TABLE OF PSP_EFF_REPORT_DETAILS.TASK_ID%TYPE INDEX BY BINARY_INTEGER;
21: TYPE AWARD_ID IS TABLE OF PSP_EFF_REPORT_DETAILS.AWARD_ID%TYPE INDEX BY BINARY_INTEGER;
22: TYPE OBJECT_VERSION_NUMBER_TYPE IS TABLE OF PSP_EFF_REPORT_DETAILS.OBJECT_VERSION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
23: TYPE FULL_NAME_TYPE IS TABLE OF PSP_EFF_REPORTS.FULL_NAME%TYPE INDEX BY BINARY_INTEGER;
24: TYPE GROUPING_CATEGORY IS TABLE OF PSP_EFF_REPORT_DETAILS.GROUPING_CATEGORY%TYPE INDEX BY BINARY_INTEGER; -- Add for Hospital Effort Report
25:

Line 22: TYPE OBJECT_VERSION_NUMBER_TYPE IS TABLE OF PSP_EFF_REPORT_DETAILS.OBJECT_VERSION_NUMBER%TYPE INDEX BY BINARY_INTEGER;

18: TYPE EXPENDITURE_ORGANIZATION_ID IS TABLE OF PSP_EFF_REPORT_DETAILS.EXPENDITURE_ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;
19: TYPE EXPENDITURE_TYPE IS TABLE OF PSP_EFF_REPORT_DETAILS.EXPENDITURE_TYPE%TYPE INDEX BY BINARY_INTEGER;
20: TYPE TASK_ID IS TABLE OF PSP_EFF_REPORT_DETAILS.TASK_ID%TYPE INDEX BY BINARY_INTEGER;
21: TYPE AWARD_ID IS TABLE OF PSP_EFF_REPORT_DETAILS.AWARD_ID%TYPE INDEX BY BINARY_INTEGER;
22: TYPE OBJECT_VERSION_NUMBER_TYPE IS TABLE OF PSP_EFF_REPORT_DETAILS.OBJECT_VERSION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
23: TYPE FULL_NAME_TYPE IS TABLE OF PSP_EFF_REPORTS.FULL_NAME%TYPE INDEX BY BINARY_INTEGER;
24: TYPE GROUPING_CATEGORY IS TABLE OF PSP_EFF_REPORT_DETAILS.GROUPING_CATEGORY%TYPE INDEX BY BINARY_INTEGER; -- Add for Hospital Effort Report
25:
26: g_er_proposed_salary_amt proposed_salary_amt_TYPE;

Line 24: TYPE GROUPING_CATEGORY IS TABLE OF PSP_EFF_REPORT_DETAILS.GROUPING_CATEGORY%TYPE INDEX BY BINARY_INTEGER; -- Add for Hospital Effort Report

20: TYPE TASK_ID IS TABLE OF PSP_EFF_REPORT_DETAILS.TASK_ID%TYPE INDEX BY BINARY_INTEGER;
21: TYPE AWARD_ID IS TABLE OF PSP_EFF_REPORT_DETAILS.AWARD_ID%TYPE INDEX BY BINARY_INTEGER;
22: TYPE OBJECT_VERSION_NUMBER_TYPE IS TABLE OF PSP_EFF_REPORT_DETAILS.OBJECT_VERSION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
23: TYPE FULL_NAME_TYPE IS TABLE OF PSP_EFF_REPORTS.FULL_NAME%TYPE INDEX BY BINARY_INTEGER;
24: TYPE GROUPING_CATEGORY IS TABLE OF PSP_EFF_REPORT_DETAILS.GROUPING_CATEGORY%TYPE INDEX BY BINARY_INTEGER; -- Add for Hospital Effort Report
25:
26: g_er_proposed_salary_amt proposed_salary_amt_TYPE;
27: g_er_proposed_effort_percent proposed_effort_percent_TYPE;
28: g_er_committed_cost_share committed_cost_share_TYPE;

Line 130: * @rep:category BUSINESS_ENTITY PSP_EFF_REPORT_DETAILS

126: * concurrent program, set to the end_person in a chunk range.
127: * @param p_warning Set to TRUE when an error condition is encountered within
128: * the API.
129: * @rep:displayname Update Effort Report Detail
130: * @rep:category BUSINESS_ENTITY PSP_EFF_REPORT_DETAILS
131: * @rep:lifecycle active
132: * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
133: * @rep:scope public
134: * @rep:ihelp PER/@scalapi APIs in Oracle HRMS

Line 147: end PSP_EFF_REPORT_DETAILS_API;

143: ,p_end_person in number
144: ,p_warning out nocopy boolean
145: );
146: --
147: end PSP_EFF_REPORT_DETAILS_API;