[Home] [Help]
PACKAGE: APPS.OKL_TPL_PVT
Source
1 PACKAGE OKL_TPL_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLSTPLS.pls 120.3 2007/05/14 17:43:56 cklee ship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE tpl_rec_type IS RECORD (
7 id NUMBER := OKC_API.G_MISS_NUM,
8 inv_distr_line_code OKL_TXL_AP_INV_LNS_B.INV_DISTR_LINE_CODE%TYPE := OKC_API.G_MISS_CHAR,
9 tap_id NUMBER := OKC_API.G_MISS_NUM,
10 disbursement_basis_code OKL_TXL_AP_INV_LNS_B.DISBURSEMENT_BASIS_CODE%TYPE := OKC_API.G_MISS_CHAR,
11 tpl_id_reverses NUMBER := OKC_API.G_MISS_NUM,
12 combo_id NUMBER := OKC_API.G_MISS_NUM,
13 lsm_id NUMBER := OKC_API.G_MISS_NUM,
14 kle_id NUMBER := OKC_API.G_MISS_NUM,
15 khr_id NUMBER := OKC_API.G_MISS_NUM,
19 -- trx_type OKL_TXL_AP_INV_LNS_B.TRX_TYPE%TYPE := OKC_API.G_MISS_CHAR,
16 cnsld_ap_inv_id NUMBER := OKC_API.G_MISS_NUM,
17 itc_id NUMBER := OKC_API.G_MISS_NUM,
18 sty_id NUMBER := OKC_API.G_MISS_NUM,
20 line_number NUMBER := OKC_API.G_MISS_NUM,
21 cnsld_line_number NUMBER := OKC_API.G_MISS_NUM,
22 ref_line_number NUMBER := OKC_API.G_MISS_NUM,
23 object_version_number NUMBER := OKC_API.G_MISS_NUM,
24 date_accounting OKL_TXL_AP_INV_LNS_B.DATE_ACCOUNTING%TYPE := OKC_API.G_MISS_DATE,
25 amount NUMBER := OKC_API.G_MISS_NUM,
26 payables_invoice_id NUMBER := OKC_API.G_MISS_NUM,
27 request_id NUMBER := OKC_API.G_MISS_NUM,
28 program_application_id NUMBER := OKC_API.G_MISS_NUM,
29 program_id NUMBER := OKC_API.G_MISS_NUM,
30 program_update_date OKL_TXL_AP_INV_LNS_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
31 org_id NUMBER := OKC_API.G_MISS_NUM,
32 error_message OKL_TXL_AP_INV_LNS_B.error_message%TYPE := OKC_API.G_MISS_CHAR,
33 attribute_category OKL_TXL_AP_INV_LNS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
34 attribute1 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
35 attribute2 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
36 attribute3 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
37 attribute4 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
38 attribute5 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
39 attribute6 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
40 attribute7 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
41 attribute8 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
42 attribute9 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
43 attribute10 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
44 attribute11 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
45 attribute12 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
46 attribute13 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
47 attribute14 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
48 attribute15 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
49 created_by NUMBER := OKC_API.G_MISS_NUM,
50 creation_date OKL_TXL_AP_INV_LNS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
51 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
52 last_update_date OKL_TXL_AP_INV_LNS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
53 last_update_login NUMBER := OKC_API.G_MISS_NUM,
54 funding_reference_type_code OKL_TXL_AP_INV_LNS_B.funding_reference_type_code%TYPE := OKC_API.G_MISS_CHAR, -- added g_miss 5/14/07 cklee
55 funding_reference_number OKL_TXL_AP_INV_LNS_B.FUNDING_REFERENCE_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
56 code_combination_id OKL_TXL_AP_INV_LNS_B.code_combination_id%TYPE := OKC_API.G_MISS_NUM, -- added g_miss 5/14/07 cklee
57 sel_id OKL_TXL_AP_INV_LNS_B.sel_id%TYPE := OKC_API.G_MISS_NUM, -- added g_miss 5/14/07 cklee
58 taxable_yn OKL_TXL_AP_INV_LNS_B.TAXABLE_YN%TYPE := OKC_API.G_MISS_CHAR,
59 --start:| 14-May-07 cklee -- added TLD_ID column |
60 TLD_ID OKL_TXL_AP_INV_LNS_B.TLD_ID%TYPE := OKC_API.G_MISS_NUM
61 --end:| 14-May-07 cklee -- added TLD_ID column |
62 );
63 g_miss_tpl_rec tpl_rec_type;
64 TYPE tpl_tbl_type IS TABLE OF tpl_rec_type
65 INDEX BY BINARY_INTEGER;
66 TYPE okl_txl_ap_inv_lns_tl_rec_type IS RECORD (
67 id NUMBER := OKC_API.G_MISS_NUM,
68 language OKL_TXL_AP_INV_LNS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
69 source_lang OKL_TXL_AP_INV_LNS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
70 sfwt_flag OKL_TXL_AP_INV_LNS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
71 description OKL_TXL_AP_INV_LNS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
72 created_by NUMBER := OKC_API.G_MISS_NUM,
73 creation_date OKL_TXL_AP_INV_LNS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
74 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
75 last_update_date OKL_TXL_AP_INV_LNS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
76 last_update_login NUMBER := OKC_API.G_MISS_NUM);
77 GMissOklTxlApInvLnsTlRec okl_txl_ap_inv_lns_tl_rec_type;
78 TYPE okl_txl_ap_inv_lns_tl_tbl_type IS TABLE OF okl_txl_ap_inv_lns_tl_rec_type
79 INDEX BY BINARY_INTEGER;
80 TYPE tplv_rec_type IS RECORD (
81 id NUMBER := OKC_API.G_MISS_NUM,
82 object_version_number NUMBER := OKC_API.G_MISS_NUM,
83 sfwt_flag OKL_TXL_AP_INV_LNS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
84 combo_id NUMBER := OKC_API.G_MISS_NUM,
85 itc_id NUMBER := OKC_API.G_MISS_NUM,
86 disbursement_basis_code OKL_TXL_AP_INV_LNS_V.DISBURSEMENT_BASIS_CODE%TYPE := OKC_API.G_MISS_CHAR,
87 kle_id NUMBER := OKC_API.G_MISS_NUM,
88 khr_id NUMBER := OKC_API.G_MISS_NUM,
89 cnsld_ap_inv_id NUMBER := OKC_API.G_MISS_NUM,
93 sty_id NUMBER := OKC_API.G_MISS_NUM,
90 lsm_id NUMBER := OKC_API.G_MISS_NUM,
91 tpl_id_reverses NUMBER := OKC_API.G_MISS_NUM,
92 inv_distr_line_code OKL_TXL_AP_INV_LNS_V.INV_DISTR_LINE_CODE%TYPE := OKC_API.G_MISS_CHAR,
94 tap_id NUMBER := OKC_API.G_MISS_NUM,
95 date_accounting OKL_TXL_AP_INV_LNS_V.DATE_ACCOUNTING%TYPE := OKC_API.G_MISS_DATE,
96 amount NUMBER := OKC_API.G_MISS_NUM,
97 line_number NUMBER := OKC_API.G_MISS_NUM,
98 cnsld_line_number NUMBER := OKC_API.G_MISS_NUM,
99 ref_line_number NUMBER := OKC_API.G_MISS_NUM,
100 payables_invoice_id NUMBER := OKC_API.G_MISS_NUM,
101 description OKL_TXL_AP_INV_LNS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
102 error_message OKL_TXL_AP_INV_LNS_V.error_message%TYPE := OKC_API.G_MISS_CHAR,
103 attribute_category OKL_TXL_AP_INV_LNS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
104 attribute1 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
105 attribute2 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
106 attribute3 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
107 attribute4 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
108 attribute5 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
109 attribute6 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
110 attribute7 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
111 attribute8 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
112 attribute9 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
113 attribute10 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
114 attribute11 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
115 attribute12 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
116 attribute13 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
117 attribute14 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
118 attribute15 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
119 -- trx_type OKL_TXL_AP_INV_LNS_V.TRX_TYPE%TYPE := OKC_API.G_MISS_CHAR,
120 request_id NUMBER := OKC_API.G_MISS_NUM,
121 program_application_id NUMBER := OKC_API.G_MISS_NUM,
122 program_id NUMBER := OKC_API.G_MISS_NUM,
123 program_update_date OKL_TXL_AP_INV_LNS_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
124 org_id NUMBER := OKC_API.G_MISS_NUM,
125 created_by NUMBER := OKC_API.G_MISS_NUM,
126 creation_date OKL_TXL_AP_INV_LNS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
127 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
128 last_update_date OKL_TXL_AP_INV_LNS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
129 last_update_login NUMBER := OKC_API.G_MISS_NUM,
130 funding_reference_number OKL_TXL_AP_INV_LNS_v.FUNDING_REFERENCE_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
131 funding_reference_type_code OKL_TXL_AP_INV_LNS_B.funding_reference_type_code%TYPE := OKC_API.G_MISS_CHAR, -- added g_miss 5/14/07 cklee
132 code_combination_id OKL_TXL_AP_INV_LNS_v.code_combination_id%TYPE := OKC_API.G_MISS_NUM, -- added g_miss 5/14/07 cklee
133 sel_id OKL_TXL_AP_INV_LNS_v.sel_id%TYPE := OKC_API.G_MISS_NUM, -- added g_miss 5/14/07 cklee
134 taxable_yn OKL_TXL_AP_INV_LNS_V.TAXABLE_YN%TYPE := OKC_API.G_MISS_CHAR,
135 --start:| 14-May-07 cklee -- added TLD_ID column |
136 TLD_ID OKL_TXL_AP_INV_LNS_B.TLD_ID%TYPE := OKC_API.G_MISS_NUM
137 --end:| 14-May-07 cklee -- added TLD_ID column |
138 );
139 g_miss_tplv_rec tplv_rec_type;
140 TYPE tplv_tbl_type IS TABLE OF tplv_rec_type
141 INDEX BY BINARY_INTEGER;
142 ---------------------------------------------------------------------------
143 -- GLOBAL MESSAGE CONSTANTS
144 ---------------------------------------------------------------------------
145 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
146 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
147 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
148 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
149 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
150 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
151 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
152 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
153 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
154 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
155 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
156 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(30) := 'OKL_UNEXPECTED_ERROR';
157 G_NO_PARENT_RECORD CONSTANT VARCHAR2(30) :='OKL_NO_PARENT_RECORD';
158 G_SQLERRM_TOKEN CONSTANT VARCHAR2(30) := 'OKL_SQLERRM';
159 G_SQLCODE_TOKEN CONSTANT VARCHAR2(30) := 'OKL_SQLCODE';
160 ---------------------------------------------------------------------------
161 -- GLOBAL VARIABLES
162 ---------------------------------------------------------------------------
163 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_TPL_PVT';
164 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
165 ---------------------------------------------------------------------------
166 -- Procedures and Functions
167 ---------------------------------------------------------------------------
168
169 PROCEDURE qc;
170 PROCEDURE change_version;
171 PROCEDURE api_copy;
172 PROCEDURE add_language;
173 PROCEDURE insert_row(
174 p_api_version IN NUMBER,
175 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
176 x_return_status OUT NOCOPY VARCHAR2,
177 x_msg_count OUT NOCOPY NUMBER,
178 x_msg_data OUT NOCOPY VARCHAR2,
179 p_tplv_rec IN tplv_rec_type,
180 x_tplv_rec OUT NOCOPY tplv_rec_type);
181
182 PROCEDURE insert_row(
183 p_api_version IN NUMBER,
184 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
185 x_return_status OUT NOCOPY VARCHAR2,
186 x_msg_count OUT NOCOPY NUMBER,
187 x_msg_data OUT NOCOPY VARCHAR2,
188 p_tplv_tbl IN tplv_tbl_type,
189 x_tplv_tbl OUT NOCOPY tplv_tbl_type);
190
191 PROCEDURE lock_row(
192 p_api_version IN NUMBER,
193 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
194 x_return_status OUT NOCOPY VARCHAR2,
195 x_msg_count OUT NOCOPY NUMBER,
196 x_msg_data OUT NOCOPY VARCHAR2,
197 p_tplv_rec IN tplv_rec_type);
198
199 PROCEDURE lock_row(
200 p_api_version IN NUMBER,
201 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
202 x_return_status OUT NOCOPY VARCHAR2,
203 x_msg_count OUT NOCOPY NUMBER,
204 x_msg_data OUT NOCOPY VARCHAR2,
205 p_tplv_tbl IN tplv_tbl_type);
206
207 PROCEDURE update_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_tplv_rec IN tplv_rec_type,
214 x_tplv_rec OUT NOCOPY tplv_rec_type);
215
216 PROCEDURE update_row(
217 p_api_version IN NUMBER,
218 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
219 x_return_status OUT NOCOPY VARCHAR2,
220 x_msg_count OUT NOCOPY NUMBER,
221 x_msg_data OUT NOCOPY VARCHAR2,
222 p_tplv_tbl IN tplv_tbl_type,
223 x_tplv_tbl OUT NOCOPY tplv_tbl_type);
224
225 PROCEDURE delete_row(
226 p_api_version IN NUMBER,
227 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
228 x_return_status OUT NOCOPY VARCHAR2,
229 x_msg_count OUT NOCOPY NUMBER,
230 x_msg_data OUT NOCOPY VARCHAR2,
231 p_tplv_rec IN tplv_rec_type);
232
233 PROCEDURE delete_row(
234 p_api_version IN NUMBER,
235 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
236 x_return_status OUT NOCOPY VARCHAR2,
237 x_msg_count OUT NOCOPY NUMBER,
238 x_msg_data OUT NOCOPY VARCHAR2,
239 p_tplv_tbl IN tplv_tbl_type);
240
241 PROCEDURE validate_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_tplv_rec IN tplv_rec_type);
248
249 PROCEDURE validate_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_tplv_tbl IN tplv_tbl_type);
256
257 END OKL_TPL_PVT;