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