[Home] [Help]
PACKAGE: APPS.OKL_ASE_PVT
Source
1 Package Okl_Ase_Pvt AS
2 /* $Header: OKLSASES.pls 120.4 2006/07/11 10:10:08 dkagrawa noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 -- OKL_ACCT_SOURCES_V Record Spec
7 TYPE asev_rec_type IS RECORD (
8 -- udhenuko Bug#5042061 - Modified - Start
9 -- id NUMBER := Okc_Api.G_MISS_NUM
10 id OKL_ACCT_SOURCES.ID%TYPE := Okc_Api.G_MISS_CHAR
11 -- udhenuko Bug#5042061 - Modified - End
12 ,source_table OKL_ACCT_SOURCES.SOURCE_TABLE%TYPE := Okc_Api.G_MISS_CHAR
13 ,source_id NUMBER := Okc_Api.G_MISS_NUM
14 ,pdt_id NUMBER := Okc_Api.G_MISS_NUM
15 ,try_id NUMBER := Okc_Api.G_MISS_NUM
16 ,sty_id NUMBER := Okc_Api.G_MISS_NUM
17 ,memo_yn OKL_ACCT_SOURCES.MEMO_YN%TYPE := Okc_Api.G_MISS_CHAR
18 ,factor_investor_flag OKL_ACCT_SOURCES.FACTOR_INVESTOR_FLAG%TYPE := Okc_Api.G_MISS_CHAR
19 ,factor_investor_code OKL_ACCT_SOURCES.FACTOR_INVESTOR_CODE%TYPE := Okc_Api.G_MISS_CHAR
20 ,amount NUMBER := Okc_Api.G_MISS_NUM
21 ,formula_used OKL_ACCT_SOURCES.FORMULA_USED%TYPE := Okc_Api.G_MISS_CHAR
22 ,entered_date OKL_ACCT_SOURCES.ENTERED_DATE%TYPE := Okc_Api.G_MISS_DATE
23 ,accounting_date OKL_ACCT_SOURCES.ACCOUNTING_DATE%TYPE := Okc_Api.G_MISS_DATE
24 ,gl_reversal_flag OKL_ACCT_SOURCES.GL_REVERSAL_FLAG%TYPE := Okc_Api.G_MISS_CHAR
25 ,post_to_gl OKL_ACCT_SOURCES.POST_TO_GL%TYPE := Okc_Api.G_MISS_CHAR
26 ,currency_code OKL_ACCT_SOURCES.CURRENCY_CODE%TYPE := Okc_Api.G_MISS_CHAR
27 ,currency_conversion_type OKL_ACCT_SOURCES.CURRENCY_CONVERSION_TYPE%TYPE := Okc_Api.G_MISS_CHAR
28 ,currency_conversion_date OKL_ACCT_SOURCES.CURRENCY_CONVERSION_DATE%TYPE := Okc_Api.G_MISS_DATE
29 ,currency_conversion_rate NUMBER := Okc_Api.G_MISS_NUM
30 ,khr_id NUMBER := Okc_Api.G_MISS_NUM
31 ,kle_id NUMBER := Okc_Api.G_MISS_NUM
32 ,pay_vendor_sites_pk OKL_ACCT_SOURCES.PAY_VENDOR_SITES_PK%TYPE := Okc_Api.G_MISS_CHAR
33 ,rec_site_uses_pk OKL_ACCT_SOURCES.REC_SITE_USES_PK%TYPE := Okc_Api.G_MISS_CHAR
34 ,asset_category_id_pk1 OKL_ACCT_SOURCES.ASSET_CATEGORY_ID_PK1%TYPE := Okc_Api.G_MISS_CHAR
35 ,asset_book_pk2 OKL_ACCT_SOURCES.ASSET_BOOK_PK2%TYPE := Okc_Api.G_MISS_CHAR
36 ,pay_financial_options_pk OKL_ACCT_SOURCES.PAY_FINANCIAL_OPTIONS_PK%TYPE := Okc_Api.G_MISS_CHAR
37 ,jtf_sales_reps_pk OKL_ACCT_SOURCES.JTF_SALES_REPS_PK%TYPE := Okc_Api.G_MISS_CHAR
38 ,inventory_item_id_pk1 OKL_ACCT_SOURCES.INVENTORY_ITEM_ID_PK1%TYPE := Okc_Api.G_MISS_CHAR
39 ,inventory_org_id_pk2 OKL_ACCT_SOURCES.INVENTORY_ORG_ID_PK2%TYPE := Okc_Api.G_MISS_CHAR
40 ,rec_trx_types_pk OKL_ACCT_SOURCES.REC_TRX_TYPES_PK%TYPE := Okc_Api.G_MISS_CHAR
41 ,avl_id NUMBER := Okc_Api.G_MISS_NUM
42 ,local_product_yn OKL_ACCT_SOURCES.LOCAL_PRODUCT_YN%TYPE := Okc_Api.G_MISS_CHAR
43 ,internal_status OKL_ACCT_SOURCES.INTERNAL_STATUS%TYPE := Okc_Api.G_MISS_CHAR
44 ,custom_status OKL_ACCT_SOURCES.CUSTOM_STATUS%TYPE := Okc_Api.G_MISS_CHAR
45 ,source_indicator_flag OKL_ACCT_SOURCES.SOURCE_INDICATOR_FLAG%TYPE := Okc_Api.G_MISS_CHAR
46 ,org_id NUMBER := Okc_Api.G_MISS_NUM
47 ,program_id NUMBER := Okc_Api.G_MISS_NUM
48 ,program_application_id NUMBER := Okc_Api.G_MISS_NUM
49 ,request_id NUMBER := Okc_Api.G_MISS_NUM
50 ,program_update_date OKL_ACCT_SOURCES.PROGRAM_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE
51 ,created_by NUMBER := Okc_Api.G_MISS_NUM
52 ,creation_date OKL_ACCT_SOURCES.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE
53 ,last_updated_by NUMBER := Okc_Api.G_MISS_NUM
54 ,last_update_date OKL_ACCT_SOURCES.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE
55 ,last_update_login NUMBER := Okc_Api.G_MISS_NUM);
56 G_MISS_asev_rec asev_rec_type;
57 TYPE asev_tbl_type IS TABLE OF asev_rec_type
58 INDEX BY BINARY_INTEGER;
59 -- OKL_ACCT_SOURCES Record Spec
60 TYPE ase_rec_type IS RECORD (
61 -- udhenuko Bug#5042061 - Modified - Start
62 -- id NUMBER := Okc_Api.G_MISS_NUM
63 id OKL_ACCT_SOURCES.ID%TYPE := Okc_Api.G_MISS_CHAR
64 -- udhenuko Bug#5042061 - Modified - Start
65 ,source_table OKL_ACCT_SOURCES.SOURCE_TABLE%TYPE := Okc_Api.G_MISS_CHAR
66 ,source_id NUMBER := Okc_Api.G_MISS_NUM
67 ,pdt_id NUMBER := Okc_Api.G_MISS_NUM
68 ,try_id NUMBER := Okc_Api.G_MISS_NUM
69 ,sty_id NUMBER := Okc_Api.G_MISS_NUM
70 ,memo_yn OKL_ACCT_SOURCES.MEMO_YN%TYPE := Okc_Api.G_MISS_CHAR
71 ,factor_investor_flag OKL_ACCT_SOURCES.FACTOR_INVESTOR_FLAG%TYPE := Okc_Api.G_MISS_CHAR
72 ,factor_investor_code OKL_ACCT_SOURCES.FACTOR_INVESTOR_CODE%TYPE := Okc_Api.G_MISS_CHAR
73 ,amount NUMBER := Okc_Api.G_MISS_NUM
74 ,formula_used OKL_ACCT_SOURCES.FORMULA_USED%TYPE := Okc_Api.G_MISS_CHAR
75 ,entered_date OKL_ACCT_SOURCES.ENTERED_DATE%TYPE := Okc_Api.G_MISS_DATE
76 ,accounting_date OKL_ACCT_SOURCES.ACCOUNTING_DATE%TYPE := Okc_Api.G_MISS_DATE
77 ,gl_reversal_flag OKL_ACCT_SOURCES.GL_REVERSAL_FLAG%TYPE := Okc_Api.G_MISS_CHAR
78 ,post_to_gl OKL_ACCT_SOURCES.POST_TO_GL%TYPE := Okc_Api.G_MISS_CHAR
79 ,currency_code OKL_ACCT_SOURCES.CURRENCY_CODE%TYPE := Okc_Api.G_MISS_CHAR
80 ,currency_conversion_type OKL_ACCT_SOURCES.CURRENCY_CONVERSION_TYPE%TYPE := Okc_Api.G_MISS_CHAR
81 ,currency_conversion_date OKL_ACCT_SOURCES.CURRENCY_CONVERSION_DATE%TYPE := Okc_Api.G_MISS_DATE
82 ,currency_conversion_rate NUMBER := Okc_Api.G_MISS_NUM
83 ,khr_id NUMBER := Okc_Api.G_MISS_NUM
84 ,kle_id NUMBER := Okc_Api.G_MISS_NUM
85 ,pay_vendor_sites_pk OKL_ACCT_SOURCES.PAY_VENDOR_SITES_PK%TYPE := Okc_Api.G_MISS_CHAR
86 ,rec_site_uses_pk OKL_ACCT_SOURCES.REC_SITE_USES_PK%TYPE := Okc_Api.G_MISS_CHAR
87 ,asset_category_id_pk1 OKL_ACCT_SOURCES.ASSET_CATEGORY_ID_PK1%TYPE := Okc_Api.G_MISS_CHAR
88 ,asset_book_pk2 OKL_ACCT_SOURCES.ASSET_BOOK_PK2%TYPE := Okc_Api.G_MISS_CHAR
89 ,pay_financial_options_pk OKL_ACCT_SOURCES.PAY_FINANCIAL_OPTIONS_PK%TYPE := Okc_Api.G_MISS_CHAR
90 ,jtf_sales_reps_pk OKL_ACCT_SOURCES.JTF_SALES_REPS_PK%TYPE := Okc_Api.G_MISS_CHAR
91 ,inventory_item_id_pk1 OKL_ACCT_SOURCES.INVENTORY_ITEM_ID_PK1%TYPE := Okc_Api.G_MISS_CHAR
92 ,inventory_org_id_pk2 OKL_ACCT_SOURCES.INVENTORY_ORG_ID_PK2%TYPE := Okc_Api.G_MISS_CHAR
93 ,rec_trx_types_pk OKL_ACCT_SOURCES.REC_TRX_TYPES_PK%TYPE := Okc_Api.G_MISS_CHAR
94 ,avl_id NUMBER := Okc_Api.G_MISS_NUM
95 ,local_product_yn OKL_ACCT_SOURCES.LOCAL_PRODUCT_YN%TYPE := Okc_Api.G_MISS_CHAR
96 ,internal_status OKL_ACCT_SOURCES.INTERNAL_STATUS%TYPE := Okc_Api.G_MISS_CHAR
97 ,custom_status OKL_ACCT_SOURCES.CUSTOM_STATUS%TYPE := Okc_Api.G_MISS_CHAR
98 ,source_indicator_flag OKL_ACCT_SOURCES.SOURCE_INDICATOR_FLAG%TYPE := Okc_Api.G_MISS_CHAR
99 ,org_id NUMBER := Okc_Api.G_MISS_NUM
100 ,program_id NUMBER := Okc_Api.G_MISS_NUM
101 ,program_application_id NUMBER := Okc_Api.G_MISS_NUM
102 ,request_id NUMBER := Okc_Api.G_MISS_NUM
103 ,program_update_date OKL_ACCT_SOURCES.PROGRAM_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE
104 ,created_by NUMBER := Okc_Api.G_MISS_NUM
105 ,creation_date OKL_ACCT_SOURCES.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE
106 ,last_updated_by NUMBER := Okc_Api.G_MISS_NUM
107 ,last_update_date OKL_ACCT_SOURCES.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE
108 ,last_update_login NUMBER := Okc_Api.G_MISS_NUM);
109 G_MISS_ase_rec ase_rec_type;
110 TYPE ase_tbl_type IS TABLE OF ase_rec_type
111 INDEX BY BINARY_INTEGER;
112 ---------------------------------------------------------------------------
113 -- GLOBAL MESSAGE CONSTANTS
114 ---------------------------------------------------------------------------
115 G_FND_APP CONSTANT VARCHAR2(200) := Okc_Api.G_FND_APP;
116 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_UNABLE_TO_RESERVE_REC;
117 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_DELETED;
118 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_CHANGED;
119 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_RECORD_LOGICALLY_DELETED;
120 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
121 G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_INVALID_VALUE;
122 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_COL_NAME_TOKEN;
123 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_PARENT_TABLE_TOKEN;
124 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_CHILD_TABLE_TOKEN;
125 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
126 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
127 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
128 G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKL_NO_PARENT_RECORD';
129 ---------------------------------------------------------------------------
130 -- GLOBAL EXCEPTIONS
131 ---------------------------------------------------------------------------
132 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
133
134 ---------------------------------------------------------------------------
135 -- GLOBAL VARIABLES
136 ---------------------------------------------------------------------------
137 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_ASE_PVT';
138 G_APP_NAME CONSTANT VARCHAR2(3) := Okc_Api.G_APP_NAME;
139 ---------------------------------------------------------------------------
140 -- Procedures and Functions
141 ---------------------------------------------------------------------------
142
143 PROCEDURE qc;
144 PROCEDURE change_version;
145 PROCEDURE api_copy;
146 PROCEDURE insert_row(
147 p_api_version IN NUMBER,
148 p_init_msg_list IN VARCHAR2,
149 x_return_status OUT NOCOPY VARCHAR2,
150 x_msg_count OUT NOCOPY NUMBER,
151 x_msg_data OUT NOCOPY VARCHAR2,
152 p_asev_rec IN asev_rec_type,
153 x_asev_rec OUT NOCOPY asev_rec_type);
154 PROCEDURE insert_row(
155 p_api_version IN NUMBER,
156 p_init_msg_list IN VARCHAR2,
157 x_return_status OUT NOCOPY VARCHAR2,
158 x_msg_count OUT NOCOPY NUMBER,
159 x_msg_data OUT NOCOPY VARCHAR2,
160 p_asev_tbl IN asev_tbl_type,
161 x_asev_tbl OUT NOCOPY asev_tbl_type);
162
163 --Added by gboomina on 14-Oct-2005 for Accruals Performance Tuning
164 --Bug 4662173 - Start of Changes
165 PROCEDURE insert_row_bulk(
166 p_api_version IN NUMBER,
167 p_init_msg_list IN VARCHAR2,
168 x_return_status OUT NOCOPY VARCHAR2,
169 x_msg_count OUT NOCOPY NUMBER,
170 x_msg_data OUT NOCOPY VARCHAR2,
171 p_asev_tbl IN asev_tbl_type,
172 x_asev_tbl OUT NOCOPY asev_tbl_type);
173 --Bug 4662173 - End of Changes
174
175 PROCEDURE lock_row(
176 p_api_version IN NUMBER,
177 p_init_msg_list IN VARCHAR2,
178 x_return_status OUT NOCOPY VARCHAR2,
179 x_msg_count OUT NOCOPY NUMBER,
180 x_msg_data OUT NOCOPY VARCHAR2,
181 p_asev_rec IN asev_rec_type);
182 PROCEDURE lock_row(
183 p_api_version IN NUMBER,
184 p_init_msg_list IN VARCHAR2,
185 x_return_status OUT NOCOPY VARCHAR2,
186 x_msg_count OUT NOCOPY NUMBER,
187 x_msg_data OUT NOCOPY VARCHAR2,
188 p_asev_tbl IN asev_tbl_type);
189 PROCEDURE update_row(
190 p_api_version IN NUMBER,
191 p_init_msg_list IN VARCHAR2,
192 x_return_status OUT NOCOPY VARCHAR2,
193 x_msg_count OUT NOCOPY NUMBER,
194 x_msg_data OUT NOCOPY VARCHAR2,
195 p_asev_rec IN asev_rec_type,
196 x_asev_rec OUT NOCOPY asev_rec_type);
197 PROCEDURE update_row(
198 p_api_version IN NUMBER,
199 p_init_msg_list IN VARCHAR2,
200 x_return_status OUT NOCOPY VARCHAR2,
201 x_msg_count OUT NOCOPY NUMBER,
202 x_msg_data OUT NOCOPY VARCHAR2,
203 p_asev_tbl IN asev_tbl_type,
204 x_asev_tbl OUT NOCOPY asev_tbl_type);
205 PROCEDURE delete_row(
206 p_api_version IN NUMBER,
207 p_init_msg_list IN VARCHAR2,
208 x_return_status OUT NOCOPY VARCHAR2,
209 x_msg_count OUT NOCOPY NUMBER,
210 x_msg_data OUT NOCOPY VARCHAR2,
211 p_asev_rec IN asev_rec_type);
212 PROCEDURE delete_row(
213 p_api_version IN NUMBER,
214 p_init_msg_list IN VARCHAR2,
215 x_return_status OUT NOCOPY VARCHAR2,
216 x_msg_count OUT NOCOPY NUMBER,
217 x_msg_data OUT NOCOPY VARCHAR2,
218 p_asev_tbl IN asev_tbl_type);
219 PROCEDURE validate_row(
220 p_api_version IN NUMBER,
221 p_init_msg_list IN VARCHAR2,
222 x_return_status OUT NOCOPY VARCHAR2,
223 x_msg_count OUT NOCOPY NUMBER,
224 x_msg_data OUT NOCOPY VARCHAR2,
225 p_asev_rec IN asev_rec_type);
226 PROCEDURE validate_row(
227 p_api_version IN NUMBER,
228 p_init_msg_list IN VARCHAR2,
229 x_return_status OUT NOCOPY VARCHAR2,
230 x_msg_count OUT NOCOPY NUMBER,
231 x_msg_data OUT NOCOPY VARCHAR2,
232 p_asev_tbl IN asev_tbl_type);
233 END Okl_Ase_Pvt;