[Home] [Help]
PACKAGE: APPS.OKE_FUNDSOURCE_PVT
Source
1 package OKE_FUNDSOURCE_PVT AUTHID CURRENT_USER as
2 /* $Header: OKEVKFDS.pls 120.0.12020000.2 2012/11/02 09:11:53 ansraj ship $ */
3
4
5 --
6 -- Global variables
7 --
8
9 G_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
10 G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKE_FUNDSOURCE_PVT';
11 G_APP_NAME CONSTANT VARCHAR2(3) := OKE_API.G_APP_NAME;
12 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
13 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
14 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKE_CONTRACTS_UNEXPECTED_ERROR';
15 G_OBJECT_TYPE CONSTANT VARCHAR2(30) := 'OKE_K_HEADERS';
16 G_PRODUCT_CODE CONSTANT VARCHAR2(3) := 'OKE';
17 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
18 G_RESOURCE_BUSY EXCEPTION;
19 PRAGMA EXCEPTION_INIT(G_RESOURCE_BUSY, -54);
20
21
22 --
23 -- Funding_Rec_In_Type
24 --
25
26 TYPE funding_rec_in_type is RECORD
27 (funding_source_id NUMBER := OKE_API.G_MISS_NUM ,
28 object_type VARCHAR(30) := OKE_API.G_MISS_CHAR ,
29 object_id NUMBER := OKE_API.G_MISS_NUM ,
30 pool_party_id NUMBER := OKE_API.G_MISS_NUM ,
31 k_party_id NUMBER := OKE_API.G_MISS_NUM ,
32 customer_id NUMBER := OKE_API.G_MISS_NUM ,
33 customer_number VARCHAR2(30) := OKE_API.G_MISS_CHAR ,
34 amount NUMBER := OKE_API.G_MISS_NUM ,
35 hard_limit NUMBER := OKE_API.G_MISS_NUM ,
36 funding_status VARCHAR2(30) := OKE_API.G_MISS_CHAR ,
37 currency_code VARCHAR2(15) := OKE_API.G_MISS_CHAR ,
38 k_conversion_type VARCHAR2(30) := OKE_API.G_MISS_CHAR ,
39 k_conversion_date DATE := OKE_API.G_MISS_DATE ,
40 k_conversion_rate NUMBER := OKE_API.G_MISS_NUM ,
41 start_date_active DATE := OKE_API.G_MISS_DATE ,
42 end_date_active DATE := OKE_API.G_MISS_DATE ,
43 -- agreement_flag VARCHAR2(1) := OKE_API.G_MISS_CHAR ,
44 agreement_number VARCHAR2(50) := OKE_API.G_MISS_CHAR ,
45 -- oke_desc_flex_name VARCHAR2(240) := OKE_API.G_MISS_CHAR ,
46 oke_attribute_category VARCHAR2(30) := OKE_API.G_MISS_CHAR ,
47 oke_attribute1 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
48 oke_attribute2 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
49 oke_attribute3 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
50 oke_attribute4 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
51 oke_attribute5 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
52 oke_attribute6 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
53 oke_attribute7 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
54 oke_attribute8 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
55 oke_attribute9 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
56 oke_attribute10 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
57 oke_attribute11 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
58 oke_attribute12 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
59 oke_attribute13 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
60 oke_attribute14 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
61 oke_attribute15 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
62 pa_attribute_category VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
63 pa_attribute1 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
64 pa_attribute2 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
65 pa_attribute3 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
66 pa_attribute4 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
67 pa_attribute5 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
68 pa_attribute6 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
69 pa_attribute7 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
70 pa_attribute8 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
71 pa_attribute9 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
72 pa_attribute10 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
73 pa_attribute11 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
74 pa_attribute12 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
75 pa_attribute13 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
76 pa_attribute14 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
77 pa_attribute15 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
78 pa_attribute16 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
79 pa_attribute17 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
80 pa_attribute18 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
81 pa_attribute19 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
82 pa_attribute20 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
83 pa_attribute21 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
84 pa_attribute22 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
85 pa_attribute23 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
86 pa_attribute24 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
87 pa_attribute25 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
88 revenue_hard_limit NUMBER := OKE_API.G_MISS_NUM ,
89 agreement_org_id NUMBER := OKE_API.G_MISS_NUM
90 );
91
92
93 --
94 -- Funding_Rec_Out_Type
95 --
96
97 TYPE funding_rec_out_type is RECORD
98 (funding_source_id NUMBER := OKE_API.G_MISS_NUM ,
99 return_status VARCHAR2(1) := OKE_API.G_MISS_CHAR
100 );
101
102
103 --
104 -- Procedure: create_funding
105 --
106 -- Description: This procedure is used to insert record in OKE_K_FUNDING_SOURCES table
107 --
108 --
109
110 PROCEDURE create_funding(p_api_version IN NUMBER ,
111 p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,
112 p_commit IN VARCHAR2 := OKE_API.G_FALSE ,
113 p_msg_count OUT NOCOPY NUMBER ,
114 p_msg_data OUT NOCOPY VARCHAR2 ,
115 p_funding_in_rec IN FUNDING_REC_IN_TYPE ,
116 p_funding_out_rec OUT NOCOPY FUNDING_REC_OUT_TYPE ,
117 p_return_status OUT NOCOPY VARCHAR2
118 );
119
120
121 --
122 -- Procedure: update_funding
123 --
124 -- Description: This procedure is used to update record in OKE_FUNDING_SOURCES table
125 --
126 --
127
128 PROCEDURE update_funding(p_api_version IN NUMBER ,
129 p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,
130 p_commit IN VARCHAR2 := OKE_API.G_FALSE ,
131 p_msg_count OUT NOCOPY NUMBER ,
132 p_msg_data OUT NOCOPY VARCHAR2 ,
133 p_funding_in_rec IN FUNDING_REC_IN_TYPE ,
134 p_funding_out_rec OUT NOCOPY FUNDING_REC_OUT_TYPE ,
135 p_return_status OUT NOCOPY VARCHAR2
136 );
137
138
139 --
140 -- Procedure: delete_funding
141 --
142 -- Description: This procedure is used to delete record in OKE_K_FUNDING_SOURCES and PA_PROJECT_FUNDINGS tables
143 --
144 --
145
146 PROCEDURE delete_funding(p_api_version IN NUMBER ,
147 p_commit IN VARCHAR2 := OKE_API.G_FALSE ,
148 p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,
149 p_msg_count OUT NOCOPY NUMBER ,
150 p_msg_data OUT NOCOPY VARCHAR2 ,
151 p_funding_source_id IN NUMBER ,
152 -- p_agreement_flag IN VARCHAR2 := OKE_API.G_FALSE ,
153 p_return_status OUT NOCOPY VARCHAR2
154 );
155
156
157 --
158 -- Procedure: fetch_create_funding
159 --
160 -- Description: This procedure is used to get the existing agreement record
161 -- and create a funding record in OKE
162 --
163 --
164
165 PROCEDURE fetch_create_funding(p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,
166 p_api_version IN NUMBER ,
167 p_msg_count OUT NOCOPY NUMBER ,
168 p_msg_data OUT NOCOPY VARCHAR2 ,
169 p_commit IN VARCHAR2 := OKE_API.G_FALSE ,
170 p_pool_party_id IN NUMBER ,
171 p_customer_id IN NUMBER ,
172 p_customer_number IN VARCHAR2 ,
173 --p_pool_currency IN VARCHAR2 ,
174 --p_source_currency IN VARCHAR2 ,
175 p_party_id IN NUMBER ,
176 p_agreement_id IN NUMBER ,
177 p_org_id IN NUMBER ,
178 p_agreement_number IN VARCHAR2 ,
179 p_agreement_type IN VARCHAR2 ,
180 p_amount IN NUMBER ,
181 p_revenue_limit_flag IN VARCHAR2 ,
182 p_agreement_currency IN VARCHAR2 ,
183 p_expiration_date IN DATE ,
184 p_conversion_type IN VARCHAR2 ,
185 p_conversion_date IN DATE ,
186 p_conversion_rate IN NUMBER ,
187 --p_pa_conversion_type IN VARCHAR2 ,
188 --p_pa_conversion_date IN DATE ,
189 --p_pa_conversion_rate IN NUMBER ,
190 p_k_header_id IN NUMBER ,
191 p_pa_attribute_category IN VARCHAR2 ,
192 p_pa_attribute1 IN VARCHAR2 ,
193 p_pa_attribute2 IN VARCHAR2 ,
194 p_pa_attribute3 IN VARCHAR2 ,
195 p_pa_attribute4 IN VARCHAR2 ,
196 p_pa_attribute5 IN VARCHAR2 ,
197 p_pa_attribute6 IN VARCHAR2 ,
198 p_pa_attribute7 IN VARCHAR2 ,
199 p_pa_attribute8 IN VARCHAR2 ,
200 p_pa_attribute9 IN VARCHAR2 ,
201 p_pa_attribute10 IN VARCHAR2 ,
202 p_pa_attribute11 IN VARCHAR2 ,
203 p_pa_attribute12 IN VARCHAR2 ,
204 p_pa_attribute13 IN VARCHAR2 ,
205 p_pa_attribute14 IN VARCHAR2 ,
206 p_pa_attribute15 IN VARCHAR2 ,
207 p_pa_attribute16 IN VARCHAR2 ,
208 p_pa_attribute17 IN VARCHAR2 ,
209 p_pa_attribute18 IN VARCHAR2 ,
210 p_pa_attribute19 IN VARCHAR2 ,
211 p_pa_attribute20 IN VARCHAR2 ,
212 p_pa_attribute21 IN VARCHAR2 ,
213 p_pa_attribute22 IN VARCHAR2 ,
214 p_pa_attribute23 IN VARCHAR2 ,
215 p_pa_attribute24 IN VARCHAR2 ,
216 p_pa_attribute25 IN VARCHAR2 ,
217 p_owning_organization_id IN NUMBER ,
218 p_invoice_limit_flag IN VARCHAR2 ,
219 -- p_functional_currency_code IN VARCHAR2 ,
220 -- p_allow_currency_update IN VARCHAR2 ,
221 p_funding_source_id OUT NOCOPY NUMBER ,
222 p_return_status OUT NOCOPY VARCHAR2
223 );
224
225
226 PROCEDURE fetch_create_funding(p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,
227 p_api_version IN NUMBER ,
228 p_msg_count OUT NOCOPY NUMBER ,
229 p_msg_data OUT NOCOPY VARCHAR2 ,
230 p_commit IN VARCHAR2 := OKE_API.G_FALSE ,
231 p_pool_party_id IN NUMBER ,
232 p_party_id IN NUMBER ,
233 -- p_source_currency IN VARCHAR2 ,
234 p_agreement_id IN NUMBER ,
235 p_conversion_type IN VARCHAR2 ,
236 p_conversion_date IN DATE ,
237 p_conversion_rate IN NUMBER ,
238 --p_pa_conversion_type IN VARCHAR2 ,
239 --p_pa_conversion_date IN DATE ,
240 -- p_pa_conversion_rate IN NUMBER ,
241 p_k_header_id IN NUMBER ,
242 p_funding_source_id OUT NOCOPY NUMBER ,
243 p_return_status OUT NOCOPY VARCHAR2
244 );
245
246
247 --
248 -- Function: get_funding_rec
249 --
250 -- Description: This function initializes a record of funding_rec_in_type
251 --
252
253 FUNCTION get_funding_rec RETURN FUNDING_REC_IN_TYPE;
254
255 end OKE_FUNDSOURCE_PVT;