[Home] [Help]
PACKAGE: APPS.OKL_CNR_PVT
Source
1 PACKAGE Okl_Cnr_Pvt AS
2 /* $Header: OKLSCNRS.pls 120.2 2006/11/17 10:28:47 zrehman noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE cnr_rec_type IS RECORD (
7 id NUMBER := Okc_Api.G_MISS_NUM,
8 consolidated_invoice_number OKL_CNSLD_AR_HDRS_B.CONSOLIDATED_INVOICE_NUMBER%TYPE := Okc_Api.G_MISS_CHAR,
9 trx_status_code OKL_CNSLD_AR_HDRS_B.TRX_STATUS_CODE%TYPE := Okc_Api.G_MISS_CHAR,
10 currency_code OKL_CNSLD_AR_HDRS_B.CURRENCY_CODE%TYPE := Okc_Api.G_MISS_CHAR,
11 set_of_books_id NUMBER := Okc_Api.G_MISS_NUM,
12 ibt_id NUMBER := Okc_Api.G_MISS_NUM,
13 ixx_id NUMBER := Okc_Api.G_MISS_NUM,
14 irm_id NUMBER := Okc_Api.G_MISS_NUM,
15 inf_id NUMBER := Okc_Api.G_MISS_NUM,
16 amount NUMBER := Okc_Api.G_MISS_NUM,
17 date_consolidated OKL_CNSLD_AR_HDRS_B.DATE_CONSOLIDATED%TYPE := Okc_Api.G_MISS_DATE,
18 invoice_pull_yn OKL_CNSLD_AR_HDRS_B.INVOICE_PULL_YN%TYPE := Okc_Api.G_MISS_CHAR,
19 object_version_number NUMBER := Okc_Api.G_MISS_NUM,
20 request_id NUMBER := Okc_Api.G_MISS_NUM,
21 program_application_id NUMBER := Okc_Api.G_MISS_NUM,
22 program_id NUMBER := Okc_Api.G_MISS_NUM,
23 program_update_date OKL_CNSLD_AR_HDRS_B.PROGRAM_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
24 org_id NUMBER := Okc_Api.G_MISS_NUM,
25 due_date OKL_CNSLD_AR_HDRS_B.DUE_DATE%TYPE := Okc_Api.G_MISS_DATE,
26 attribute_category OKL_CNSLD_AR_HDRS_B.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
27 attribute1 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
28 attribute2 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
29 attribute3 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
30 attribute4 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
31 attribute5 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
32 attribute6 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
33 attribute7 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
34 attribute8 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
35 attribute9 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
36 attribute10 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
37 attribute11 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
38 attribute12 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
39 attribute13 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
40 attribute14 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
41 attribute15 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
42 created_by NUMBER := Okc_Api.G_MISS_NUM,
43 creation_date OKL_CNSLD_AR_HDRS_B.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
44 last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
45 last_update_date OKL_CNSLD_AR_HDRS_B.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
46 last_update_login NUMBER := Okc_Api.G_MISS_NUM,
47 legal_entity_id OKL_CNSLD_AR_HDRS_B.LEGAL_ENTITY_ID%TYPE := Okc_Api.G_MISS_NUM); -- for LE Uptake project 08-11-2006
48 g_miss_cnr_rec cnr_rec_type;
49 TYPE cnr_tbl_type IS TABLE OF cnr_rec_type
50 INDEX BY BINARY_INTEGER;
51 TYPE okl_cnsld_ar_hdrs_tl_rec_type IS RECORD (
52 id NUMBER := Okc_Api.G_MISS_NUM,
53 LANGUAGE OKL_CNSLD_AR_HDRS_TL.LANGUAGE%TYPE := Okc_Api.G_MISS_CHAR,
54 source_lang OKL_CNSLD_AR_HDRS_TL.SOURCE_LANG%TYPE := Okc_Api.G_MISS_CHAR,
55 sfwt_flag OKL_CNSLD_AR_HDRS_TL.SFWT_FLAG%TYPE := Okc_Api.G_MISS_CHAR,
56 private_label_logo_url OKL_CNSLD_AR_HDRS_TL.PRIVATE_LABEL_LOGO_URL%TYPE := Okc_Api.G_MISS_CHAR,
57 created_by NUMBER := Okc_Api.G_MISS_NUM,
58 creation_date OKL_CNSLD_AR_HDRS_TL.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
59 last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
60 last_update_date OKL_CNSLD_AR_HDRS_TL.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
61 last_update_login NUMBER := Okc_Api.G_MISS_NUM);
62 GMissOklCnsldArHdrsTlRec okl_cnsld_ar_hdrs_tl_rec_type;
63 TYPE okl_cnsld_ar_hdrs_tl_tbl_type IS TABLE OF okl_cnsld_ar_hdrs_tl_rec_type
64 INDEX BY BINARY_INTEGER;
65 TYPE cnrv_rec_type IS RECORD (
66 id NUMBER := Okc_Api.G_MISS_NUM,
67 object_version_number NUMBER := Okc_Api.G_MISS_NUM,
68 sfwt_flag OKL_CNSLD_AR_HDRS_V.SFWT_FLAG%TYPE := Okc_Api.G_MISS_CHAR,
69 ibt_id NUMBER := Okc_Api.G_MISS_NUM,
70 ixx_id NUMBER := Okc_Api.G_MISS_NUM,
71 currency_code OKL_CNSLD_AR_HDRS_V.CURRENCY_CODE%TYPE := Okc_Api.G_MISS_CHAR,
72 irm_id NUMBER := Okc_Api.G_MISS_NUM,
73 inf_id NUMBER := Okc_Api.G_MISS_NUM,
74 set_of_books_id NUMBER := Okc_Api.G_MISS_NUM,
75 consolidated_invoice_number OKL_CNSLD_AR_HDRS_V.CONSOLIDATED_INVOICE_NUMBER%TYPE := Okc_Api.G_MISS_CHAR,
76 trx_status_code OKL_CNSLD_AR_HDRS_V.TRX_STATUS_CODE%TYPE := Okc_Api.G_MISS_CHAR,
77 invoice_pull_yn OKL_CNSLD_AR_HDRS_V.INVOICE_PULL_YN%TYPE := Okc_Api.G_MISS_CHAR,
78 date_consolidated OKL_CNSLD_AR_HDRS_V.DATE_CONSOLIDATED%TYPE := Okc_Api.G_MISS_DATE,
79 private_label_logo_url OKL_CNSLD_AR_HDRS_V.PRIVATE_LABEL_LOGO_URL%TYPE := Okc_Api.G_MISS_CHAR,
80 amount NUMBER := Okc_Api.G_MISS_NUM,
81 due_date OKL_CNSLD_AR_HDRS_V.DUE_DATE%TYPE := Okc_Api.G_MISS_DATE,
82 attribute_category OKL_CNSLD_AR_HDRS_V.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
83 attribute1 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
84 attribute2 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
85 attribute3 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
86 attribute4 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
87 attribute5 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
88 attribute6 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
89 attribute7 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
90 attribute8 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
91 attribute9 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
92 attribute10 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
93 attribute11 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
94 attribute12 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
95 attribute13 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
96 attribute14 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
97 attribute15 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
98 request_id NUMBER := Okc_Api.G_MISS_NUM,
99 program_application_id NUMBER := Okc_Api.G_MISS_NUM,
100 program_id NUMBER := Okc_Api.G_MISS_NUM,
101 program_update_date OKL_CNSLD_AR_HDRS_V.PROGRAM_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
102 org_id NUMBER := Okc_Api.G_MISS_NUM,
103 created_by NUMBER := Okc_Api.G_MISS_NUM,
104 creation_date OKL_CNSLD_AR_HDRS_V.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
105 last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
106 last_update_date OKL_CNSLD_AR_HDRS_V.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
107 last_update_login NUMBER := Okc_Api.G_MISS_NUM,
108 legal_entity_id OKL_CNSLD_AR_HDRS_V.LEGAL_ENTITY_ID%TYPE := Okc_Api.G_MISS_NUM); -- for LE Uptake project 08-11-2006
109 g_miss_cnrv_rec cnrv_rec_type;
110 TYPE cnrv_tbl_type IS TABLE OF cnrv_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 ---------------------------------------------------------------------------
126 -- GLOBAL VARIABLES
127 ---------------------------------------------------------------------------
128 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_CNR_PVT';
129 G_APP_NAME CONSTANT VARCHAR2(3) := Okc_Api.G_APP_NAME;
130
131 /*************ADDED AFTER TAPI, Sunil T. Mathew (04/19/2001) ****************/
132 --GLOBAL MESSAGES
133 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
134 G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKL_NO_PARENT_RECORD';
135 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
136 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
137 G_NOT_SAME CONSTANT VARCHAR2(200) := 'OKL_CANNOT_BE_SAME';
138
139
140 --GLOBAL VARIABLES
141 G_VIEW CONSTANT VARCHAR2(30) := 'OKL_CNSLD_AR_HDRS_V';
142 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
143
144 ---------------------------------------------------------------------------
145 -- Procedures and Functions
146 ---------------------------------------------------------------------------
147
148 PROCEDURE qc;
149 PROCEDURE change_version;
150 PROCEDURE api_copy;
151 PROCEDURE add_language;
152 PROCEDURE insert_row(
153 p_api_version IN NUMBER,
154 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
155 x_return_status OUT NOCOPY VARCHAR2,
156 x_msg_count OUT NOCOPY NUMBER,
157 x_msg_data OUT NOCOPY VARCHAR2,
158 p_cnrv_rec IN cnrv_rec_type,
159 x_cnrv_rec OUT NOCOPY cnrv_rec_type);
160
161 PROCEDURE insert_row(
162 p_api_version IN NUMBER,
163 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
164 x_return_status OUT NOCOPY VARCHAR2,
165 x_msg_count OUT NOCOPY NUMBER,
166 x_msg_data OUT NOCOPY VARCHAR2,
167 p_cnrv_tbl IN cnrv_tbl_type,
168 x_cnrv_tbl OUT NOCOPY cnrv_tbl_type);
169
170 PROCEDURE lock_row(
171 p_api_version IN NUMBER,
172 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
173 x_return_status OUT NOCOPY VARCHAR2,
174 x_msg_count OUT NOCOPY NUMBER,
175 x_msg_data OUT NOCOPY VARCHAR2,
176 p_cnrv_rec IN cnrv_rec_type);
177
178 PROCEDURE lock_row(
179 p_api_version IN NUMBER,
180 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
181 x_return_status OUT NOCOPY VARCHAR2,
182 x_msg_count OUT NOCOPY NUMBER,
183 x_msg_data OUT NOCOPY VARCHAR2,
184 p_cnrv_tbl IN cnrv_tbl_type);
185
186 PROCEDURE update_row(
187 p_api_version IN NUMBER,
188 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
189 x_return_status OUT NOCOPY VARCHAR2,
190 x_msg_count OUT NOCOPY NUMBER,
191 x_msg_data OUT NOCOPY VARCHAR2,
192 p_cnrv_rec IN cnrv_rec_type,
193 x_cnrv_rec OUT NOCOPY cnrv_rec_type);
194
195 PROCEDURE update_row(
196 p_api_version IN NUMBER,
197 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
198 x_return_status OUT NOCOPY VARCHAR2,
199 x_msg_count OUT NOCOPY NUMBER,
200 x_msg_data OUT NOCOPY VARCHAR2,
201 p_cnrv_tbl IN cnrv_tbl_type,
202 x_cnrv_tbl OUT NOCOPY cnrv_tbl_type);
203
204 PROCEDURE delete_row(
205 p_api_version IN NUMBER,
206 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
207 x_return_status OUT NOCOPY VARCHAR2,
208 x_msg_count OUT NOCOPY NUMBER,
209 x_msg_data OUT NOCOPY VARCHAR2,
210 p_cnrv_rec IN cnrv_rec_type);
211
212 PROCEDURE delete_row(
213 p_api_version IN NUMBER,
214 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
215 x_return_status OUT NOCOPY VARCHAR2,
216 x_msg_count OUT NOCOPY NUMBER,
217 x_msg_data OUT NOCOPY VARCHAR2,
218 p_cnrv_tbl IN cnrv_tbl_type);
219
220 PROCEDURE validate_row(
221 p_api_version IN NUMBER,
222 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
223 x_return_status OUT NOCOPY VARCHAR2,
224 x_msg_count OUT NOCOPY NUMBER,
225 x_msg_data OUT NOCOPY VARCHAR2,
226 p_cnrv_rec IN cnrv_rec_type);
227
228 PROCEDURE validate_row(
229 p_api_version IN NUMBER,
230 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
231 x_return_status OUT NOCOPY VARCHAR2,
232 x_msg_count OUT NOCOPY NUMBER,
233 x_msg_data OUT NOCOPY VARCHAR2,
234 p_cnrv_tbl IN cnrv_tbl_type);
235
236 END Okl_Cnr_Pvt;