[Home] [Help]
PACKAGE: APPS.OKL_SAO_PVT
Source
1 PACKAGE Okl_Sao_Pvt AS
2 /* $Header: OKLSSAOS.pls 120.6.12010000.2 2008/09/18 21:36:17 smereddy ship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE sao_rec_type IS RECORD (
7 id NUMBER := Okc_Api.G_MISS_NUM,
8 cc_rep_currency_code OKL_SYS_ACCT_OPTS.CC_REP_CURRENCY_CODE%TYPE := Okc_Api.G_MISS_CHAR,
9 code_combination_id NUMBER := Okc_Api.G_MISS_NUM,
10 ael_rep_currency_code OKL_SYS_ACCT_OPTS.AEL_REP_CURRENCY_CODE%TYPE := Okc_Api.G_MISS_CHAR,
11 set_of_books_id NUMBER := Okc_Api.G_MISS_NUM,
12 object_version_number NUMBER := Okc_Api.G_MISS_NUM,
13 rec_ccid NUMBER := Okc_Api.G_MISS_NUM,
14 realized_gain_ccid NUMBER := Okc_Api.G_MISS_NUM,
15 realized_loss_ccid NUMBER := Okc_Api.G_MISS_NUM,
16 tax_ccid NUMBER := Okc_Api.G_MISS_NUM,
17 cross_currency_ccid NUMBER := Okc_Api.G_MISS_NUM,
18 rounding_ccid NUMBER := Okc_Api.G_MISS_NUM,
19 ar_clearing_ccid NUMBER := Okc_Api.G_MISS_NUM,
20 payables_ccid NUMBER := Okc_Api.G_MISS_NUM,
21 liablity_ccid NUMBER := Okc_Api.G_MISS_NUM,
22 pre_payment_ccid NUMBER := Okc_Api.G_MISS_NUM,
23 fut_date_pay_ccid NUMBER := Okc_Api.G_MISS_NUM,
24 cc_rounding_rule OKL_SYS_ACCT_OPTS.CC_ROUNDING_RULE%TYPE := Okc_Api.G_MISS_CHAR,
25 cc_precision NUMBER := Okc_Api.G_MISS_NUM,
26 cc_min_acct_unit NUMBER := Okc_Api.G_MISS_NUM,
27 dis_taken_ccid NUMBER := Okc_Api.G_MISS_NUM,
28 ap_clearing_ccid NUMBER := Okc_Api.G_MISS_NUM,
29 ael_rounding_rule OKL_SYS_ACCT_OPTS.AEL_ROUNDING_RULE%TYPE := Okc_Api.G_MISS_CHAR,
30 ael_precision NUMBER := Okc_Api.G_MISS_NUM,
31 ael_min_acct_unit NUMBER := Okc_Api.G_MISS_NUM,
32 org_id NUMBER := Okc_Api.G_MISS_NUM,
33 attribute_category OKL_SYS_ACCT_OPTS.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
34 attribute1 OKL_SYS_ACCT_OPTS.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
35 attribute2 OKL_SYS_ACCT_OPTS.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
36 attribute3 OKL_SYS_ACCT_OPTS.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
37 attribute4 OKL_SYS_ACCT_OPTS.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
38 attribute5 OKL_SYS_ACCT_OPTS.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
39 attribute6 OKL_SYS_ACCT_OPTS.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
40 attribute7 OKL_SYS_ACCT_OPTS.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
41 attribute8 OKL_SYS_ACCT_OPTS.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
42 attribute9 OKL_SYS_ACCT_OPTS.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
43 attribute10 OKL_SYS_ACCT_OPTS.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
44 attribute11 OKL_SYS_ACCT_OPTS.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
45 attribute12 OKL_SYS_ACCT_OPTS.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
46 attribute13 OKL_SYS_ACCT_OPTS.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
47 attribute14 OKL_SYS_ACCT_OPTS.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
48 attribute15 OKL_SYS_ACCT_OPTS.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
49 created_by NUMBER := Okc_Api.G_MISS_NUM,
50 creation_date OKL_SYS_ACCT_OPTS.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
51 last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
52 last_update_date OKL_SYS_ACCT_OPTS.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
53 last_update_login NUMBER := Okc_Api.G_MISS_NUM,
54 /* Changed Made by Kanti on 06/21/2001. The following two fields are available in the
55 table but missing from here.
56 Changes start here */
57 cc_apply_rounding_difference OKL_SYS_ACCT_OPTS.CC_APPLY_ROUNDING_DIFFERENCE%TYPE := Okc_Api.G_MISS_CHAR,
58 ael_apply_rounding_difference OKL_SYS_ACCT_OPTS.AEL_APPLY_ROUNDING_DIFFERENCE%TYPE := Okc_Api.G_MISS_CHAR,
59 /* Changes End Here */
60 accrual_reversal_days NUMBER := OKC_API.G_MISS_NUM ,
61 -- Added a new field for the bug 2331564 Santonyr
62 lke_hold_days NUMBER := OKC_API.G_MISS_NUM ,
63 /*Changes added by Keerthi 10-Sep-2003 for Rounding the Amounts in Streams */
64 stm_apply_rounding_difference OKL_SYS_ACCT_OPTS.STM_APPLY_ROUNDING_DIFFERENCE%TYPE := Okc_Api.G_MISS_CHAR,
65 stm_rounding_rule OKL_SYS_ACCT_OPTS.STM_ROUNDING_RULE%TYPE := Okc_Api.G_MISS_CHAR
66 /*Added new field for bug 4884618(H) */
67 ,validate_khr_start_date OKL_SYS_ACCT_OPTS.validate_khr_start_date%TYPE := Okc_Api.G_MISS_CHAR
68 -- R12 SLA Uptake
69 ,account_derivation OKL_SYS_ACCT_OPTS.ACCOUNT_DERIVATION%TYPE := Okc_Api.G_MISS_CHAR
70 ,isg_arrears_pay_dates_option OKL_SYS_ACCT_OPTS.ISG_ARREARS_PAY_DATES_OPTION%TYPE := Okc_Api.G_MISS_CHAR
71 ,PAY_DIST_SET_ID OKL_SYS_ACCT_OPTS.PAY_DIST_SET_ID%TYPE :=OKC_API.G_MISS_NUM,
72 /*Added new field for bug Multi-GAAP bug 7225249 */
73 SECONDARY_REP_METHOD OKL_SYS_ACCT_OPTS.SECONDARY_REP_METHOD%type := Okc_Api.G_MISS_CHAR
74 );
75 g_miss_sao_rec sao_rec_type;
76 TYPE sao_tbl_type IS TABLE OF sao_rec_type
77 INDEX BY BINARY_INTEGER;
78 TYPE saov_rec_type IS RECORD (
79 id NUMBER := Okc_Api.G_MISS_NUM,
80 object_version_number NUMBER := Okc_Api.G_MISS_NUM,
81 set_of_books_id NUMBER := Okc_Api.G_MISS_NUM,
82 code_combination_id NUMBER := Okc_Api.G_MISS_NUM,
83 cc_rep_currency_code OKL_SYS_ACCT_OPTS.CC_REP_CURRENCY_CODE%TYPE := Okc_Api.G_MISS_CHAR,
84 ael_rep_currency_code OKL_SYS_ACCT_OPTS.AEL_REP_CURRENCY_CODE%TYPE := Okc_Api.G_MISS_CHAR,
85 rec_ccid NUMBER := Okc_Api.G_MISS_NUM,
86 realized_gain_ccid NUMBER := Okc_Api.G_MISS_NUM,
87 realized_loss_ccid NUMBER := Okc_Api.G_MISS_NUM,
88 tax_ccid NUMBER := Okc_Api.G_MISS_NUM,
89 cross_currency_ccid NUMBER := Okc_Api.G_MISS_NUM,
90 rounding_ccid NUMBER := Okc_Api.G_MISS_NUM,
91 ar_clearing_ccid NUMBER := Okc_Api.G_MISS_NUM,
92 payables_ccid NUMBER := Okc_Api.G_MISS_NUM,
93 liablity_ccid NUMBER := Okc_Api.G_MISS_NUM,
94 pre_payment_ccid NUMBER := Okc_Api.G_MISS_NUM,
95 fut_date_pay_ccid NUMBER := Okc_Api.G_MISS_NUM,
96 dis_taken_ccid NUMBER := Okc_Api.G_MISS_NUM,
97 ap_clearing_ccid NUMBER := Okc_Api.G_MISS_NUM,
98 ael_rounding_rule OKL_SYS_ACCT_OPTS.AEL_ROUNDING_RULE%TYPE := Okc_Api.G_MISS_CHAR,
99 ael_precision NUMBER := Okc_Api.G_MISS_NUM,
100 ael_min_acct_unit NUMBER := Okc_Api.G_MISS_NUM,
101 cc_rounding_rule OKL_SYS_ACCT_OPTS.CC_ROUNDING_RULE%TYPE := Okc_Api.G_MISS_CHAR,
102 cc_precision NUMBER := Okc_Api.G_MISS_NUM,
103 cc_min_acct_unit NUMBER := Okc_Api.G_MISS_NUM,
104 attribute_category OKL_SYS_ACCT_OPTS.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
105 attribute1 OKL_SYS_ACCT_OPTS.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
106 attribute2 OKL_SYS_ACCT_OPTS.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
107 attribute3 OKL_SYS_ACCT_OPTS.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
108 attribute4 OKL_SYS_ACCT_OPTS.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
109 attribute5 OKL_SYS_ACCT_OPTS.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
110 attribute6 OKL_SYS_ACCT_OPTS.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
111 attribute7 OKL_SYS_ACCT_OPTS.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
112 attribute8 OKL_SYS_ACCT_OPTS.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
113 attribute9 OKL_SYS_ACCT_OPTS.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
114 attribute10 OKL_SYS_ACCT_OPTS.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
115 attribute11 OKL_SYS_ACCT_OPTS.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
116 attribute12 OKL_SYS_ACCT_OPTS.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
117 attribute13 OKL_SYS_ACCT_OPTS.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
118 attribute14 OKL_SYS_ACCT_OPTS.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
119 attribute15 OKL_SYS_ACCT_OPTS.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
120 org_id NUMBER := Okc_Api.G_MISS_NUM,
121 created_by NUMBER := Okc_Api.G_MISS_NUM,
122 creation_date OKL_SYS_ACCT_OPTS.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
123 last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
124 last_update_date OKL_SYS_ACCT_OPTS.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
125 last_update_login NUMBER := Okc_Api.G_MISS_NUM,
126 /* Changed Made by Kanti on 06/21/2001. The following two fields are available in the
127 table but missing from here.
128 Changes start here */
129 cc_apply_rounding_difference OKL_SYS_ACCT_OPTS.CC_APPLY_ROUNDING_DIFFERENCE%TYPE := Okc_Api.G_MISS_CHAR,
130 ael_apply_rounding_difference OKL_SYS_ACCT_OPTS.AEL_APPLY_ROUNDING_DIFFERENCE%TYPE := Okc_Api.G_MISS_CHAR,
131 /* Changes End Here */
132 accrual_reversal_days NUMBER := OKC_API.G_MISS_NUM ,
133 -- Added a new field for the bug 2331564 Santonyr
134 lke_hold_days NUMBER := OKC_API.G_MISS_NUM ,
135 /*Changes added by Keerthi 10-Sep-2003 for Rounding the Amounts in Streams*/
136 stm_apply_rounding_difference OKL_SYS_ACCT_OPTS.STM_APPLY_ROUNDING_DIFFERENCE%TYPE := Okc_Api.G_MISS_CHAR,
137 stm_rounding_rule OKL_SYS_ACCT_OPTS.STM_ROUNDING_RULE%TYPE := Okc_Api.G_MISS_CHAR
138 /*Added new field for bug 4884618(H) */
139 ,validate_khr_start_date OKL_SYS_ACCT_OPTS.validate_khr_start_date%TYPE := Okc_Api.G_MISS_CHAR
140 ,account_derivation OKL_SYS_ACCT_OPTS.ACCOUNT_DERIVATION%TYPE := Okc_Api.G_MISS_CHAR
141 ,isg_arrears_pay_dates_option OKL_SYS_ACCT_OPTS.ISG_ARREARS_PAY_DATES_OPTION%TYPE := Okc_Api.G_MISS_CHAR
142 ,PAY_DIST_SET_ID OKL_SYS_ACCT_OPTS.PAY_DIST_SET_ID%TYPE :=OKC_API.G_MISS_NUM,
143 /*Added new field for bug Multi-GAAP bug 7225249 */
144 SECONDARY_REP_METHOD OKL_SYS_ACCT_OPTS.SECONDARY_REP_METHOD%type := Okc_Api.G_MISS_CHAR
145 );
146 g_miss_saov_rec saov_rec_type;
147 TYPE saov_tbl_type IS TABLE OF saov_rec_type
148 INDEX BY BINARY_INTEGER;
149 ---------------------------------------------------------------------------
150 -- GLOBAL MESSAGE CONSTANTS
151 ---------------------------------------------------------------------------
152 G_FND_APP CONSTANT VARCHAR2(200) := Okc_Api.G_FND_APP;
153 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_UNABLE_TO_RESERVE_REC;
154 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_DELETED;
155 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_CHANGED;
156 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_RECORD_LOGICALLY_DELETED;
157 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
158 G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_INVALID_VALUE;
159 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_COL_NAME_TOKEN;
160 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_PARENT_TABLE_TOKEN;
161 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_CHILD_TABLE_TOKEN;
162 -- START CHANGE : mvasudev -- 05/02/2001
163 -- Adding MESSAGE CONSTANTs for 'Unique Key Validation','SQLCode', 'SQLErrM'
164 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLerrm';
165 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLcode';
166 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
167 -- END CHANGE : mvasudev
168 ---------------------------------------------------------------------------
169 -- GLOBAL VARIABLES
170 ---------------------------------------------------------------------------
171 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_SAO_PVT';
172 G_APP_NAME CONSTANT VARCHAR2(3) := Okc_Api.G_APP_NAME;
173
174 -- START change : mvasudev, 05/02/2001
175 -- Added Exception for Halt_validation
176 --------------------------------------------------------------------------------
177 -- ERRORS AND EXCEPTIONS
178 --------------------------------------------------------------------------------
179 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
180 -- END change : mvasudev
181
182 ---------------------------------------------------------------------------
183 -- Procedures and Functions
184 ---------------------------------------------------------------------------
185
186 PROCEDURE qc;
187 PROCEDURE change_version;
188 PROCEDURE api_copy;
189 PROCEDURE insert_row(
190 p_api_version IN NUMBER,
191 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
192 x_return_status OUT NOCOPY VARCHAR2,
193 x_msg_count OUT NOCOPY NUMBER,
194 x_msg_data OUT NOCOPY VARCHAR2,
195 p_saov_rec IN saov_rec_type,
196 x_saov_rec OUT NOCOPY saov_rec_type);
197
198 PROCEDURE insert_row(
199 p_api_version IN NUMBER,
200 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
201 x_return_status OUT NOCOPY VARCHAR2,
202 x_msg_count OUT NOCOPY NUMBER,
203 x_msg_data OUT NOCOPY VARCHAR2,
204 p_saov_tbl IN saov_tbl_type,
205 x_saov_tbl OUT NOCOPY saov_tbl_type);
206
207 PROCEDURE lock_row(
208 p_api_version IN NUMBER,
209 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
210 x_return_status OUT NOCOPY VARCHAR2,
211 x_msg_count OUT NOCOPY NUMBER,
212 x_msg_data OUT NOCOPY VARCHAR2,
213 p_saov_rec IN saov_rec_type);
214
215 PROCEDURE lock_row(
216 p_api_version IN NUMBER,
217 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
218 x_return_status OUT NOCOPY VARCHAR2,
219 x_msg_count OUT NOCOPY NUMBER,
220 x_msg_data OUT NOCOPY VARCHAR2,
221 p_saov_tbl IN saov_tbl_type);
222
223 PROCEDURE update_row(
224 p_api_version IN NUMBER,
225 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
226 x_return_status OUT NOCOPY VARCHAR2,
227 x_msg_count OUT NOCOPY NUMBER,
228 x_msg_data OUT NOCOPY VARCHAR2,
229 p_saov_rec IN saov_rec_type,
230 x_saov_rec OUT NOCOPY saov_rec_type);
231
232 PROCEDURE update_row(
233 p_api_version IN NUMBER,
234 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
235 x_return_status OUT NOCOPY VARCHAR2,
236 x_msg_count OUT NOCOPY NUMBER,
237 x_msg_data OUT NOCOPY VARCHAR2,
238 p_saov_tbl IN saov_tbl_type,
239 x_saov_tbl OUT NOCOPY saov_tbl_type);
240
241 PROCEDURE delete_row(
242 p_api_version IN NUMBER,
243 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
244 x_return_status OUT NOCOPY VARCHAR2,
245 x_msg_count OUT NOCOPY NUMBER,
246 x_msg_data OUT NOCOPY VARCHAR2,
247 p_saov_rec IN saov_rec_type);
248
249 PROCEDURE delete_row(
250 p_api_version IN NUMBER,
251 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
252 x_return_status OUT NOCOPY VARCHAR2,
253 x_msg_count OUT NOCOPY NUMBER,
254 x_msg_data OUT NOCOPY VARCHAR2,
255 p_saov_tbl IN saov_tbl_type);
256
257 PROCEDURE validate_row(
258 p_api_version IN NUMBER,
259 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
260 x_return_status OUT NOCOPY VARCHAR2,
261 x_msg_count OUT NOCOPY NUMBER,
262 x_msg_data OUT NOCOPY VARCHAR2,
263 p_saov_rec IN saov_rec_type);
264
265 PROCEDURE validate_row(
266 p_api_version IN NUMBER,
267 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
268 x_return_status OUT NOCOPY VARCHAR2,
269 x_msg_count OUT NOCOPY NUMBER,
270 x_msg_data OUT NOCOPY VARCHAR2,
271 p_saov_tbl IN saov_tbl_type);
272
273 END OKL_SAO_PVT;