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
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;
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;
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;
29 g_er_value1 value_TYPE ;
30 g_er_value2 value_TYPE;
31 g_er_value3 value_TYPE;
32 g_er_value4 value_TYPE;
33 g_er_value5 value_TYPE;
34 g_er_value6 value_TYPE;
35 g_er_value7 value_TYPE;
36 g_er_value8 value_TYPE;
37 g_er_value9 value_TYPE ;
38 g_er_value10 value_TYPE ;
39 g_er_attribute1 attribute_TYPE;
40 g_er_attribute2 attribute_TYPE;
41 g_er_attribute3 attribute_TYPE;
42 g_er_attribute4 attribute_TYPE;
43 g_er_attribute5 attribute_TYPE;
44 g_er_attribute6 attribute_TYPE;
45 g_er_attribute7 attribute_TYPE;
46 g_er_attribute8 attribute_TYPE;
47 g_er_attribute9 attribute_TYPE;
48 g_er_attribute10 attribute_TYPE;
49 g_er_EFFORT_REPORT_DETAIL_ID EFFORT_REPORT_DETAIL_ID_TYPE;
50 g_er_ASSIGNMENT_ID ASSIGNMENT_ID;
51 g_er_GL_SEGMENT1 GL_SEGMENT;
52 g_er_GL_SEGMENT2 GL_SEGMENT;
53 g_er_GL_SEGMENT3 GL_SEGMENT;
54 g_er_GL_SEGMENT4 GL_SEGMENT;
55 g_er_GL_SEGMENT5 GL_SEGMENT;
56 g_er_GL_SEGMENT6 GL_SEGMENT;
57 g_er_GL_SEGMENT7 GL_SEGMENT;
58 g_er_GL_SEGMENT8 GL_SEGMENT;
59 g_er_GL_SEGMENT9 GL_SEGMENT;
60 g_er_GL_SEGMENT10 GL_SEGMENT;
61 g_er_GL_SEGMENT11 GL_SEGMENT;
62 g_er_GL_SEGMENT12 GL_SEGMENT;
63 g_er_GL_SEGMENT13 GL_SEGMENT;
64 g_er_GL_SEGMENT14 GL_SEGMENT;
65 g_er_GL_SEGMENT15 GL_SEGMENT;
66 g_er_GL_SEGMENT16 GL_SEGMENT;
67 g_er_GL_SEGMENT17 GL_SEGMENT;
68 g_er_GL_SEGMENT18 GL_SEGMENT;
69 g_er_GL_SEGMENT19 GL_SEGMENT;
70 g_er_GL_SEGMENT20 GL_SEGMENT;
71 g_er_GL_SEGMENT21 GL_SEGMENT;
72 g_er_GL_SEGMENT22 GL_SEGMENT;
73 g_er_GL_SEGMENT23 GL_SEGMENT;
74 g_er_GL_SEGMENT24 GL_SEGMENT;
75 g_er_GL_SEGMENT25 GL_SEGMENT;
76 g_er_GL_SEGMENT26 GL_SEGMENT;
77 g_er_GL_SEGMENT27 GL_SEGMENT;
78 g_er_GL_SEGMENT28 GL_SEGMENT;
79 g_er_GL_SEGMENT29 GL_SEGMENT;
80 g_er_GL_SEGMENT30 GL_SEGMENT;
81 g_er_PROJECT_ID PROJECT_ID;
82 g_er_EXPENDITURE_ORG_ID EXPENDITURE_ORGANIZATION_ID;
83 g_er_EXPENDITURE_TYPE EXPENDITURE_TYPE;
84 g_er_TASK_ID TASK_ID;
85 g_er_AWARD_ID AWARD_ID;
86 g_er_OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER_TYPE;
87 g_er_FULL_NAME FULL_NAME_TYPE;
88 g_er_approver_person_id assignment_id; --- added folowing vars vor uva
89 g_er_investigator_name full_name_type;
90 g_er_investigator_org_name full_name_type;
91 g_er_inv_primary_org_id assignment_id;
92 g_er_grouping_category grouping_category; -- Add for Hospital Effort Report
93 --
94 -- ----------------------------------------------------------------------------
95 -- |------------------------< update_eff_report_details >---------------------|
96 -- ----------------------------------------------------------------------------
97 --
98 -- {Start Of Comments}
99 /*#
100 * This API updates Effort Report Details.
101 *
102 * This API updates Effort Report cost share details and Effort Report detail
103 * attributes/values.
104 *
105 * <p><b>Licensing</b><br>
106 * This API is licensed for use with Human Resources.
107 *
108 * <p><b>Prerequisites</b><br>
109 * Effort Report record must exist for the concerned person and period.
110 *
111 * <p><b>Post Success</b><br>
112 * Effort Report cost share details will be updated.
113 *
114 * <p><b>Post Failure</b><br>
115 * Effort Report cost share details will not be updated and an error will be
116 * raised.
117 *
118 * @param p_validate If true, then validation alone will be performed and the
119 * database will remain unchanged. If false and all validation checks pass,
120 * then the database will be modified.
121 * @param p_request_id When the API is executed from a concurrent program, set
122 * to the concurrent request identifier.
123 * @param p_start_person When the API is executed from a multi-threaded
124 * concurrent program, set to the start_person in the chunk range.
125 * @param p_end_person When the API is executed from a multi-threaded
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
135 */
136 --
137 -- {End Of Comments}
138 --
139 procedure UPDATE_EFF_REPORT_DETAILS
140 (p_validate in boolean default false
141 ,p_Request_id in number
142 ,p_start_person in number
143 ,p_end_person in number
144 ,p_warning out nocopy boolean
145 );
146 --
147 end PSP_EFF_REPORT_DETAILS_API;