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