[Home] [Help]
PACKAGE: APPS.OKL_TAB_PVT
Source
1 PACKAGE OKL_TAB_PVT AS
2 /* $Header: OKLSTABS.pls 120.5 2007/04/19 12:41:39 nikshah noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE tab_rec_type IS RECORD (
7 id NUMBER := OKC_API.G_MISS_NUM,
8 currency_conversion_type OKL_TRNS_ACC_DSTRS.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
9 set_of_books_id OKL_TRNS_ACC_DSTRS.SET_OF_BOOKS_ID%TYPE := OKC_API.G_MISS_NUM,
10 cr_dr_flag OKL_TRNS_ACC_DSTRS.CR_DR_FLAG%TYPE := OKC_API.G_MISS_CHAR,
11 code_combination_id NUMBER := OKC_API.G_MISS_NUM,
12 org_id NUMBER := OKC_API.G_MISS_NUM,
13 currency_code OKL_TRNS_ACC_DSTRS.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
14 ae_line_type OKL_TRNS_ACC_DSTRS.AE_LINE_TYPE%TYPE := OKC_API.G_MISS_CHAR,
15 template_id NUMBER := OKC_API.G_MISS_NUM,
16 source_id NUMBER := OKC_API.G_MISS_NUM,
17 source_table OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := OKC_API.G_MISS_CHAR,
18 object_version_number NUMBER := OKC_API.G_MISS_NUM,
19 amount NUMBER := OKC_API.G_MISS_NUM,
20 accounted_amount NUMBER := OKC_API.G_MISS_NUM,
21 gl_date OKL_TRNS_ACC_DSTRS.GL_DATE%TYPE := OKC_API.G_MISS_DATE,
22 percentage NUMBER := OKC_API.G_MISS_NUM,
23 comments OKL_TRNS_ACC_DSTRS.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
24 post_request_id NUMBER := OKC_API.G_MISS_NUM,
25 currency_conversion_date OKL_TRNS_ACC_DSTRS.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE,
26 currency_conversion_rate 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_TRNS_ACC_DSTRS.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
31 attribute_category OKL_TRNS_ACC_DSTRS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
32 attribute1 OKL_TRNS_ACC_DSTRS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
33 attribute2 OKL_TRNS_ACC_DSTRS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
34 attribute3 OKL_TRNS_ACC_DSTRS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
35 attribute4 OKL_TRNS_ACC_DSTRS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
36 attribute5 OKL_TRNS_ACC_DSTRS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
37 attribute6 OKL_TRNS_ACC_DSTRS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
38 attribute7 OKL_TRNS_ACC_DSTRS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
39 attribute8 OKL_TRNS_ACC_DSTRS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
40 attribute9 OKL_TRNS_ACC_DSTRS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
41 attribute10 OKL_TRNS_ACC_DSTRS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
42 attribute11 OKL_TRNS_ACC_DSTRS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
43 attribute12 OKL_TRNS_ACC_DSTRS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
44 attribute13 OKL_TRNS_ACC_DSTRS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
45 attribute14 OKL_TRNS_ACC_DSTRS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
46 attribute15 OKL_TRNS_ACC_DSTRS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
47 created_by NUMBER := OKC_API.G_MISS_NUM,
48 creation_date OKL_TRNS_ACC_DSTRS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
49 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
50 last_update_date OKL_TRNS_ACC_DSTRS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
51 last_update_login NUMBER := OKC_API.G_MISS_NUM,
52 aet_id NUMBER := OKC_API.G_MISS_NUM,
53 posted_yn OKL_TRNS_ACC_DSTRS.POSTED_YN%TYPE := OKC_API.G_MISS_CHAR,
54 ae_creation_error OKL_TRNS_ACC_DSTRS.AE_CREATION_ERROR%TYPE := OKC_API.G_MISS_CHAR,
55 gl_reversal_flag OKL_TRNS_ACC_DSTRS.GL_REVERSAL_FLAG%TYPE := OKC_API.G_MISS_CHAR,
56 reverse_event_flag OKL_TRNS_ACC_DSTRS.REVERSE_EVENT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
57 draft_yn OKL_TRNS_ACC_DSTRS.DRAFT_YN%TYPE := OKC_API.G_MISS_CHAR,
58 draft_version NUMBER := OKC_API.G_MISS_NUM,
59 original_dist_id NUMBER := OKC_API.G_MISS_NUM,
60 accounting_event_id NUMBER := OKC_API.G_MISS_NUM,
61 post_to_gl OKL_TRNS_ACC_DSTRS.POST_TO_GL%TYPE := OKC_API.G_MISS_CHAR,
62 accounting_template_name OKL_TRNS_ACC_DSTRS.ACCOUNTING_TEMPLATE_NAME%TYPE := OKC_API.G_MISS_CHAR,
63 -- Added by nikshah for SLA project (Bug 5707866) 13-Apr-2007
64 UPGRADE_STATUS_FLAG OKL_TRNS_ACC_DSTRS.UPGRADE_STATUS_FLAG%TYPE := OKC_API.G_MISS_CHAR);
65 g_miss_tab_rec tab_rec_type;
66 TYPE tab_tbl_type IS TABLE OF tab_rec_type
67 INDEX BY BINARY_INTEGER;
68 TYPE tabv_rec_type IS RECORD (
69 id NUMBER := OKC_API.G_MISS_NUM,
70 object_version_number NUMBER := OKC_API.G_MISS_NUM,
71 template_id NUMBER := OKC_API.G_MISS_NUM,
72 cr_dr_flag OKL_TRNS_ACC_DSTRS.CR_DR_FLAG%TYPE := OKC_API.G_MISS_CHAR,
73 ae_line_type OKL_TRNS_ACC_DSTRS.AE_LINE_TYPE%TYPE := OKC_API.G_MISS_CHAR,
74 org_id NUMBER := OKC_API.G_MISS_NUM,
75 set_of_books_id NUMBER := OKC_API.G_MISS_NUM,
76 code_combination_id NUMBER := OKC_API.G_MISS_NUM,
77 currency_code OKL_TRNS_ACC_DSTRS.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
78 currency_conversion_type OKL_TRNS_ACC_DSTRS.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
79 source_id NUMBER := OKC_API.G_MISS_NUM,
80 source_table OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := OKC_API.G_MISS_CHAR,
81 amount NUMBER := OKC_API.G_MISS_NUM,
82 accounted_amount NUMBER := OKC_API.G_MISS_NUM,
83 gl_date OKL_TRNS_ACC_DSTRS.GL_DATE%TYPE := OKC_API.G_MISS_DATE,
84 percentage NUMBER := OKC_API.G_MISS_NUM,
85 comments OKL_TRNS_ACC_DSTRS.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
86 post_request_id NUMBER := OKC_API.G_MISS_NUM,
87 currency_conversion_date OKL_TRNS_ACC_DSTRS.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE,
88 currency_conversion_rate NUMBER := OKC_API.G_MISS_NUM,
89 attribute_category OKL_TRNS_ACC_DSTRS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
90 attribute1 OKL_TRNS_ACC_DSTRS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
91 attribute2 OKL_TRNS_ACC_DSTRS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
92 attribute3 OKL_TRNS_ACC_DSTRS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
93 attribute4 OKL_TRNS_ACC_DSTRS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
94 attribute5 OKL_TRNS_ACC_DSTRS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
95 attribute6 OKL_TRNS_ACC_DSTRS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
96 attribute7 OKL_TRNS_ACC_DSTRS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
97 attribute8 OKL_TRNS_ACC_DSTRS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
98 attribute9 OKL_TRNS_ACC_DSTRS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
99 attribute10 OKL_TRNS_ACC_DSTRS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
100 attribute11 OKL_TRNS_ACC_DSTRS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
101 attribute12 OKL_TRNS_ACC_DSTRS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
102 attribute13 OKL_TRNS_ACC_DSTRS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
103 attribute14 OKL_TRNS_ACC_DSTRS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
104 attribute15 OKL_TRNS_ACC_DSTRS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
105 request_id NUMBER := OKC_API.G_MISS_NUM,
106 program_application_id NUMBER := OKC_API.G_MISS_NUM,
107 program_id NUMBER := OKC_API.G_MISS_NUM,
108 program_update_date OKL_TRNS_ACC_DSTRS.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
109 created_by NUMBER := OKC_API.G_MISS_NUM,
110 creation_date OKL_TRNS_ACC_DSTRS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
111 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
112 last_update_date OKL_TRNS_ACC_DSTRS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
113 last_update_login NUMBER := OKC_API.G_MISS_NUM,
114 aet_id NUMBER := OKC_API.G_MISS_NUM,
115 posted_yn OKL_TRNS_ACC_DSTRS.POSTED_YN%TYPE := OKC_API.G_MISS_CHAR,
116 ae_creation_error OKL_TRNS_ACC_DSTRS.AE_CREATION_ERROR%TYPE := OKC_API.G_MISS_CHAR,
117 gl_reversal_flag OKL_TRNS_ACC_DSTRS.GL_REVERSAL_FLAG%TYPE := OKC_API.G_MISS_CHAR,
118 reverse_event_flag OKL_TRNS_ACC_DSTRS.REVERSE_EVENT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
119 draft_yn OKL_TRNS_ACC_DSTRS.draft_yn%TYPE := OKC_API.G_MISS_CHAR,
120 draft_version NUMBER := OKC_API.G_MISS_NUM,
121 original_dist_id NUMBER := OKC_API.G_MISS_NUM,
122 accounting_event_id NUMBER := OKC_API.G_MISS_NUM,
123 post_to_gl OKL_TRNS_ACC_DSTRS.POST_TO_GL%TYPE := OKC_API.G_MISS_CHAR,
124 accounting_template_name OKL_TRNS_ACC_DSTRS.ACCOUNTING_TEMPLATE_NAME%TYPE := OKC_API.G_MISS_CHAR,
125 -- Added by nikshah for SLA project (Bug 5707866) 13-Apr-2007
126 UPGRADE_STATUS_FLAG OKL_TRNS_ACC_DSTRS.UPGRADE_STATUS_FLAG%TYPE := OKC_API.G_MISS_CHAR);
127 -- Changes End
128 g_miss_tabv_rec tabv_rec_type;
129 TYPE tabv_tbl_type IS TABLE OF tabv_rec_type
130 INDEX BY BINARY_INTEGER;
131 ---------------------------------------------------------------------------
132 -- GLOBAL MESSAGE CONSTANTS
133 ---------------------------------------------------------------------------
134 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
135 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
136 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
137 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
138 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
139 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
140 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
141 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
142 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
143 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
144 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLerrm';
145 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLcode';
146 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
147
148 ---------------------------------------------------------------------------
149 -- GLOBAL VARIABLES
150 ---------------------------------------------------------------------------
151 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_TAB_PVT';
152 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
153
154 ---------------------------------------------------------------------------
155 -- GLOBAL EXCEPTION
156 ---------------------------------------------------------------------------
157 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
158
159 ---------------------------------------------------------------------------
160 -- Procedures and Functions
161 ---------------------------------------------------------------------------
162
163 PROCEDURE qc;
164 PROCEDURE change_version;
165 PROCEDURE api_copy;
166 PROCEDURE insert_row(
167 p_api_version IN NUMBER,
168 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
169 x_return_status OUT NOCOPY VARCHAR2,
170 x_msg_count OUT NOCOPY NUMBER,
171 x_msg_data OUT NOCOPY VARCHAR2,
172 p_tabv_rec IN tabv_rec_type,
173 x_tabv_rec OUT NOCOPY tabv_rec_type);
174
175 PROCEDURE insert_row(
176 p_api_version IN NUMBER,
177 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
178 x_return_status OUT NOCOPY VARCHAR2,
179 x_msg_count OUT NOCOPY NUMBER,
180 x_msg_data OUT NOCOPY VARCHAR2,
181 p_tabv_tbl IN tabv_tbl_type,
182 x_tabv_tbl OUT NOCOPY tabv_tbl_type);
183
184 PROCEDURE lock_row(
185 p_api_version IN NUMBER,
186 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
187 x_return_status OUT NOCOPY VARCHAR2,
188 x_msg_count OUT NOCOPY NUMBER,
189 x_msg_data OUT NOCOPY VARCHAR2,
190 p_tabv_rec IN tabv_rec_type);
191
192 PROCEDURE lock_row(
193 p_api_version IN NUMBER,
194 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
195 x_return_status OUT NOCOPY VARCHAR2,
196 x_msg_count OUT NOCOPY NUMBER,
197 x_msg_data OUT NOCOPY VARCHAR2,
198 p_tabv_tbl IN tabv_tbl_type);
199
200 PROCEDURE update_row(
201 p_api_version IN NUMBER,
202 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
203 x_return_status OUT NOCOPY VARCHAR2,
204 x_msg_count OUT NOCOPY NUMBER,
205 x_msg_data OUT NOCOPY VARCHAR2,
206 p_tabv_rec IN tabv_rec_type,
207 x_tabv_rec OUT NOCOPY tabv_rec_type);
208
209 PROCEDURE update_row(
210 p_api_version IN NUMBER,
211 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
212 x_return_status OUT NOCOPY VARCHAR2,
213 x_msg_count OUT NOCOPY NUMBER,
214 x_msg_data OUT NOCOPY VARCHAR2,
215 p_tabv_tbl IN tabv_tbl_type,
216 x_tabv_tbl OUT NOCOPY tabv_tbl_type);
217
218 PROCEDURE delete_row(
219 p_api_version IN NUMBER,
220 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
221 x_return_status OUT NOCOPY VARCHAR2,
222 x_msg_count OUT NOCOPY NUMBER,
223 x_msg_data OUT NOCOPY VARCHAR2,
224 p_tabv_rec IN tabv_rec_type);
225
226 PROCEDURE delete_row(
227 p_api_version IN NUMBER,
228 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
229 x_return_status OUT NOCOPY VARCHAR2,
230 x_msg_count OUT NOCOPY NUMBER,
231 x_msg_data OUT NOCOPY VARCHAR2,
232 p_tabv_tbl IN tabv_tbl_type);
233
234 PROCEDURE validate_row(
235 p_api_version IN NUMBER,
236 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
237 x_return_status OUT NOCOPY VARCHAR2,
238 x_msg_count OUT NOCOPY NUMBER,
239 x_msg_data OUT NOCOPY VARCHAR2,
240 p_tabv_rec IN tabv_rec_type);
241
242 PROCEDURE validate_row(
243 p_api_version IN NUMBER,
244 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
245 x_return_status OUT NOCOPY VARCHAR2,
246 x_msg_count OUT NOCOPY NUMBER,
247 x_msg_data OUT NOCOPY VARCHAR2,
248 p_tabv_tbl IN tabv_tbl_type);
249
250 END OKL_TAB_PVT;