1 PACKAGE psp_external_effort_lines_api AS
2 /* $Header: PSPEEAIS.pls 120.3 2006/07/06 13:25:21 tbalacha noship $ */
3
4 -- ----------------------------------------------------------------------------
5 -- |------------------------< insert_external_effort_line >------------------------|
6 -- ----------------------------------------------------------------------------
7 --
8 -- {Start Of Comments}
9 --
10 -- Description:
11 -- Creates an External Effort Report line
12 --
13 -- Prerequisites:
14 -- None
15 --
16 -- In Parameters:
17 -- Name Reqd Type Description
18 -- p_validate Yes boolean Identifier for validation of effort report line
19 -- p_batch_name Yes varchar2 Identifier the Batch name for the effort which is to be created
20 -- p_distribution_date Yes date Date identifier on which the employee effort is distributed
21 -- p_person_id Yes number Identifier for person id
22 -- p_assignment_id Yes number Identifier for Assignment id
23 -- p_currency_code Yes varchar2 Currency Identifier for the effort report line
24 -- p_distribution_amount Yes number Amount column fo the effort report line
25 -- p_business_group_id Yes number Business group identifier
26 -- p_set_of_books_id Yes number Gl set of books identifier
27 -- p_gl_code_combination_id Yes number Identifier for GL code combination
28 -- p_project_id Yes number Identifier for Projects
29 -- p_task_id Yes number Identifier for Project Task
30 -- p_award_id Yes number Identifier for award
31 -- p_expenditure_organization_id Yes number Identifier for Exp Org
32 -- p_expenditure_type Yes varchar2 identifier for Expenditure type
33 -- p_attribute_category Yes varchar2 Additional Information category
34 -- p_attribute1 Yes varchar2 Identifier for Extra information column
35 -- p_attribute2 Yes varchar2 Identifier for Extra information column
36 -- p_attribute3 Yes varchar2 Identifier for Extra information column
37 -- p_attribute4 Yes varchar2 Identifier for Extra information column
38 -- p_attribute5 Yes varchar2 Identifier for Extra information column
39 -- p_attribute6 Yes varchar2 Identifier for Extra information column
40 -- p_attribute7 Yes varchar2 Identifier for Extra information column
41 -- p_attribute8 Yes varchar2 Identifier for Extra information column
42 -- p_attribute9 Yes varchar2 Identifier for Extra information column
43 -- p_attribute10 Yes varchar2 Identifier for Extra information column
44 -- p_attribute11 Yes varchar2 Identifier for Extra information column
45 -- p_attribute12 Yes varchar2 Identifier for Extra information column
46 -- p_attribute13 Yes varchar2 Identifier for Extra information column
47 -- p_attribute14 Yes varchar2 Identifier for Extra information column
48 -- p_attribute15 Yes varchar2 Identifier for Extra information column
49 --
50 -- Post Success:
51 -- External Effort Report approval line is created
52 --
53 -- Post Failure:
54 -- External Effort Report approval line is not created and an error is raised
55 --
56 -- Access Status:
57 -- Internal Development Use Only.
58 --
59 -- {End Of Comments}
60 --
61 procedure insert_external_effort_line
62 ( p_validate in boolean default false
63 , p_batch_name in varchar2
64 , p_distribution_date in date
65 , p_person_id in number
66 , p_assignment_id in number
67 , p_currency_code in varchar2
68 , p_distribution_amount in number
69 , p_business_group_id in number
70 , p_set_of_books_id in number
71 , p_gl_code_combination_id in number default null
72 , p_project_id in number default null
73 , p_task_id in number default null
74 , p_award_id in number default null
75 , p_expenditure_organization_id in number default null
76 , p_expenditure_type in varchar2 default null
77 , p_attribute_category in varchar2 default null
78 , p_attribute1 in varchar2 default null
79 , p_attribute2 in varchar2 default null
80 , p_attribute3 in varchar2 default null
81 , p_attribute4 in varchar2 default null
82 , p_attribute5 in varchar2 default null
83 , p_attribute6 in varchar2 default null
84 , p_attribute7 in varchar2 default null
85 , p_attribute8 in varchar2 default null
86 , p_attribute9 in varchar2 default null
87 , p_attribute10 in varchar2 default null
88 , p_attribute11 in varchar2 default null
89 , p_attribute12 in varchar2 default null
90 , p_attribute13 in varchar2 default null
91 , p_attribute14 in varchar2 default null
92 , p_attribute15 in varchar2 default null
93 , p_object_version_number in out nocopy number
94 , p_external_effort_line_id out nocopy number
95 , p_return_status out nocopy boolean
96 );
97 --
98 -- ----------------------------------------------------------------------------
99 -- |--------------------------< update_external_effort_line >----------------------|
100 -- ----------------------------------------------------------------------------
101 --
102 -- {Start Of Comments}
103 --
104 -- Description:
105 -- Updates an External Effort Report line
106 --
107 -- Prerequisites:
108 -- None
109 --
110 -- In Parameters:
111 -- Name Reqd Type Description
112 -- p_validate yes boolean Identifier for validation of effort report line
113 -- p_external_effort_line_id yes number Identifier for external effort lines which needs to be updated
114 -- p_batch_name Yes varchar2 Identifier the Batch name for the effort which is to be created
115 -- p_distribution_date Yes date Date identifier on which the employee effort is distributed
116 -- p_person_id Yes number Identifier for person id
117 -- p_assignment_id Yes number Identifier for Assignment id
118 -- p_currency_code Yes varchar2 Currency Identifier for the effort report line
119 -- p_distribution_amount Yes number Amount column fo the effort report line
120 -- p_business_group_id Yes number Business group identifier
121 -- p_set_of_books_id Yes number Gl set of books identifier
122 -- p_gl_code_combination_id Yes number Identifier for GL code combination
123 -- p_project_id Yes number Identifier for Projects
124 -- p_task_id Yes number Identifier for Project Task
125 -- p_award_id Yes number Identifier for award
126 -- p_expenditure_organization_id Yes number Identifier for Exp Org
127 -- p_expenditure_type Yes varchar2 identifier for Expenditure type
128 -- p_attribute_category Yes varchar2 Additional Information category
129 -- p_attribute1 Yes varchar2 Identifier for Extra information column
130 -- p_attribute2 Yes varchar2 Identifier for Extra information column
131 -- p_attribute3 Yes varchar2 Identifier for Extra information column
132 -- p_attribute4 Yes varchar2 Identifier for Extra information column
133 -- p_attribute5 Yes varchar2 Identifier for Extra information column
134 -- p_attribute6 Yes varchar2 Identifier for Extra information column
135 -- p_attribute7 Yes varchar2 Identifier for Extra information column
136 -- p_attribute8 Yes varchar2 Identifier for Extra information column
137 -- p_attribute9 Yes varchar2 Identifier for Extra information column
138 -- p_attribute10 Yes varchar2 Identifier for Extra information column
139 -- p_attribute11 Yes varchar2 Identifier for Extra information column
140 -- p_attribute12 Yes varchar2 Identifier for Extra information column
141 -- p_attribute13 Yes varchar2 Identifier for Extra information column
142 -- p_attribute14 Yes varchar2 Identifier for Extra information column
143 -- p_attribute15 Yes varchar2 Identifier for Extra information column
144 --
145 -- Post Success:
146 -- External Effort Report approval line is updated
147 --
148 -- Post Failure:
149 -- External Effort Report approval line is not updated and an error is raised
150 --
151 -- Access Status:
152 -- Internal Development Use Only.
153 --
154 -- {End Of Comments}
155 --
156 procedure update_external_effort_line
157 ( p_validate in boolean default false
158 , p_external_effort_line_id in number
159 , p_batch_name in varchar2 default hr_api.g_varchar2
160 , p_distribution_date in date default hr_api.g_date
161 , p_person_id in number default hr_api.g_number
162 , p_assignment_id in number default hr_api.g_number
163 , p_currency_code in varchar2 default hr_api.g_varchar2
164 , p_distribution_amount in number default hr_api.g_number
165 , p_business_group_id in number default hr_api.g_number
166 , p_set_of_books_id in number default hr_api.g_number
167 , p_gl_code_combination_id in number default hr_api.g_number
168 , p_project_id in number default hr_api.g_number
169 , p_task_id in number default hr_api.g_number
170 , p_award_id in number default hr_api.g_number
171 , p_expenditure_organization_id in number default hr_api.g_number
172 , p_expenditure_type in varchar2 default hr_api.g_varchar2
173 , p_attribute_category in varchar2 default hr_api.g_varchar2
174 , p_attribute1 in varchar2 default hr_api.g_varchar2
175 , p_attribute2 in varchar2 default hr_api.g_varchar2
176 , p_attribute3 in varchar2 default hr_api.g_varchar2
177 , p_attribute4 in varchar2 default hr_api.g_varchar2
178 , p_attribute5 in varchar2 default hr_api.g_varchar2
179 , p_attribute6 in varchar2 default hr_api.g_varchar2
180 , p_attribute7 in varchar2 default hr_api.g_varchar2
181 , p_attribute8 in varchar2 default hr_api.g_varchar2
182 , p_attribute9 in varchar2 default hr_api.g_varchar2
183 , p_attribute10 in varchar2 default hr_api.g_varchar2
184 , p_attribute11 in varchar2 default hr_api.g_varchar2
185 , p_attribute12 in varchar2 default hr_api.g_varchar2
186 , p_attribute13 in varchar2 default hr_api.g_varchar2
187 , p_attribute14 in varchar2 default hr_api.g_varchar2
188 , p_attribute15 in varchar2 default hr_api.g_varchar2
189 , p_object_version_number in out nocopy number
190 , p_return_status out nocopy boolean
191 );
192
193 --
194 -- ----------------------------------------------------------------------------
195 -- |--------------------------< delete_external_effort_line >----------------------|
196 -- ----------------------------------------------------------------------------
197 --
198 --
199 -- {Start Of Comments}
200 --
201 -- Description:
202 -- Delete an External Effort Report line
203 --
204 -- Prerequisites:
205 -- None
206 --
207 -- In Parameters:
208 -- Name Reqd Type Description
209 -- p_validate Yes boolean Identifier for validation of effort report
210 -- p_external_effort_line_id Yes number External effort line identifier which needs to get deletd
211 -- p_object_version_number Yes number The object version number which establish concurrency.
212 --
213 -- Post Success:
214 -- External Effort Report approval line is deleted
215 --
216 -- Post Failure:
217 -- External Effort Report approval line is not deleted and an error is raised
218 --
219 -- Access Status:
220 -- Internal Development Use Only.
221 --
222 -- {End Of Comments}
223
224 procedure delete_external_effort_line
225 ( p_validate in boolean default false
226 , p_external_effort_line_id in number
227 , p_object_version_number in out nocopy number
228 ) ;
229
230 /*
231 --
232 -- ----------------------------------------------------------------------------
233 -- |--------------------------< delete_external_effort_line_batch >----------------------|
234 -- ----------------------------------------------------------------------------
235 --
236
237 -- procedure delete_external_effort_line_batch
238 -- ( p_validate in boolean default false
239 -- , p_batch_name in varchar2
240 -- , p_person_id in number default hr_api.g_number
241 -- , p_assignment_id in number default hr_api.g_number
242 -- , p_return_status out nocopy boolean
243 -- );
244 */
245 end psp_external_effort_lines_api;