[Home] [Help]
PACKAGE: APPS.OKL_CLG_PVT
Source
1 PACKAGE OKL_CLG_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLSCLGS.pls 120.2 2006/11/17 10:28:25 zrehman noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE clg_rec_type IS RECORD (
7 id NUMBER := Okc_Api.G_MISS_NUM,
8 org_id NUMBER := Okc_Api.G_MISS_NUM,
9 currency_code OKL_CNTR_LVLNG_GRPS_B.CURRENCY_CODE%TYPE := Okc_Api.G_MISS_CHAR,
10 inf_id NUMBER := Okc_Api.G_MISS_NUM,
11 ica_id NUMBER := Okc_Api.G_MISS_NUM,
12 ibt_id NUMBER := Okc_Api.G_MISS_NUM,
13 irm_id NUMBER := Okc_Api.G_MISS_NUM,
14 iuv_id NUMBER := Okc_Api.G_MISS_NUM,
15 object_version_number NUMBER := Okc_Api.G_MISS_NUM,
16 attribute_category OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
17 attribute1 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
18 attribute2 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
19 attribute3 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
20 attribute4 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
21 attribute5 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
22 attribute6 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
23 attribute7 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
24 attribute8 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
25 attribute9 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
26 attribute10 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
27 attribute11 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
28 attribute12 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
29 attribute13 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
30 attribute14 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
31 attribute15 OKL_CNTR_LVLNG_GRPS_B.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
32 created_by NUMBER := Okc_Api.G_MISS_NUM,
33 creation_date OKL_CNTR_LVLNG_GRPS_B.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
34 last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
35 last_update_date OKL_CNTR_LVLNG_GRPS_B.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
36 last_update_login NUMBER := Okc_Api.G_MISS_NUM,
37 effective_date_from OKL_CNTR_LVLNG_GRPS_B.EFFECTIVE_DATE_FROM%TYPE := Okc_Api.G_MISS_DATE,
38 effective_date_to OKL_CNTR_LVLNG_GRPS_B.EFFECTIVE_DATE_TO%TYPE := Okc_Api.G_MISS_DATE,
39 ipl_id NUMBER := Okc_Api.G_MISS_NUM,
40 legal_entity_id OKL_CNTR_LVLNG_GRPS_B.LEGAL_ENTITY_ID%TYPE := Okc_Api.G_MISS_NUM); -- for LE Uptake project 08-11-2006
41 g_miss_clg_rec clg_rec_type;
42 TYPE clg_tbl_type IS TABLE OF clg_rec_type
43 INDEX BY BINARY_INTEGER;
44 TYPE OklCntrLvlngGrpsTlRecType IS RECORD (
45 id NUMBER := Okc_Api.G_MISS_NUM,
46 LANGUAGE OKL_CNTR_LVLNG_GRPS_TL.LANGUAGE%TYPE := Okc_Api.G_MISS_CHAR,
47 source_lang OKL_CNTR_LVLNG_GRPS_TL.SOURCE_LANG%TYPE := Okc_Api.G_MISS_CHAR,
48 sfwt_flag OKL_CNTR_LVLNG_GRPS_TL.SFWT_FLAG%TYPE := Okc_Api.G_MISS_CHAR,
49 name OKL_CNTR_LVLNG_GRPS_TL.NAME%TYPE := Okc_Api.G_MISS_CHAR,
50 description OKL_CNTR_LVLNG_GRPS_TL.DESCRIPTION%TYPE := Okc_Api.G_MISS_CHAR,
51 private_label_logo_url OKL_CNTR_LVLNG_GRPS_TL.PRIVATE_LABEL_LOGO_URL%TYPE := Okc_Api.G_MISS_CHAR,
52 created_by NUMBER := Okc_Api.G_MISS_NUM,
53 creation_date OKL_CNTR_LVLNG_GRPS_TL.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
54 last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
55 last_update_date OKL_CNTR_LVLNG_GRPS_TL.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
56 last_update_login NUMBER := Okc_Api.G_MISS_NUM);
57 GMissOklCntrLvlngGrpsTlRec OklCntrLvlngGrpsTlRecType;
58 TYPE OklCntrLvlngGrpsTlTblType IS TABLE OF OklCntrLvlngGrpsTlRecType
59 INDEX BY BINARY_INTEGER;
60 TYPE clgv_rec_type IS RECORD (
61 id NUMBER := Okc_Api.G_MISS_NUM,
62 org_id NUMBER := Okc_Api.G_MISS_NUM,
63 object_version_number NUMBER := Okc_Api.G_MISS_NUM,
64 sfwt_flag OKL_CNTR_LVLNG_GRPS_V.SFWT_FLAG%TYPE := Okc_Api.G_MISS_CHAR,
65 inf_id NUMBER := Okc_Api.G_MISS_NUM,
66 ica_id NUMBER := Okc_Api.G_MISS_NUM,
67 ibt_id NUMBER := Okc_Api.G_MISS_NUM,
68 currency_code OKL_CNTR_LVLNG_GRPS_V.CURRENCY_CODE%TYPE := Okc_Api.G_MISS_CHAR,
69 irm_id NUMBER := Okc_Api.G_MISS_NUM,
70 iuv_id NUMBER := Okc_Api.G_MISS_NUM,
71 name OKL_CNTR_LVLNG_GRPS_V.NAME%TYPE := Okc_Api.G_MISS_CHAR,
72 description OKL_CNTR_LVLNG_GRPS_V.DESCRIPTION%TYPE := Okc_Api.G_MISS_CHAR,
73 private_label_logo_url OKL_CNTR_LVLNG_GRPS_V.PRIVATE_LABEL_LOGO_URL%TYPE := Okc_Api.G_MISS_CHAR,
74 attribute_category OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
75 attribute1 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
76 attribute2 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
77 attribute3 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
78 attribute4 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
79 attribute5 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
80 attribute6 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
81 attribute7 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
82 attribute8 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
83 attribute9 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
84 attribute10 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
85 attribute11 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
86 attribute12 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
87 attribute13 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
88 attribute14 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
89 attribute15 OKL_CNTR_LVLNG_GRPS_V.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
90 created_by NUMBER := Okc_Api.G_MISS_NUM,
91 creation_date OKL_CNTR_LVLNG_GRPS_V.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
92 last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
93 last_update_date OKL_CNTR_LVLNG_GRPS_V.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
94 last_update_login NUMBER := Okc_Api.G_MISS_NUM,
95 effective_date_from OKL_CNTR_LVLNG_GRPS_B.EFFECTIVE_DATE_FROM%TYPE := Okc_Api.G_MISS_DATE,
96 effective_date_to OKL_CNTR_LVLNG_GRPS_B.EFFECTIVE_DATE_TO%TYPE := Okc_Api.G_MISS_DATE,
97 ipl_id NUMBER := Okc_Api.G_MISS_NUM,
98 legal_entity_id OKL_CNTR_LVLNG_GRPS_V.LEGAL_ENTITY_ID%TYPE := Okc_Api.G_MISS_NUM); -- for LE Uptake project 08-11-2006
99 g_miss_clgv_rec clgv_rec_type;
100 TYPE clgv_tbl_type IS TABLE OF clgv_rec_type
101 INDEX BY BINARY_INTEGER;
102 ---------------------------------------------------------------------------
103 -- GLOBAL MESSAGE CONSTANTS
104 ---------------------------------------------------------------------------
105 G_FND_APP CONSTANT VARCHAR2(200) := Okc_Api.G_FND_APP;
106 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_UNABLE_TO_RESERVE_REC;
107 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_DELETED;
108 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_CHANGED;
109 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_RECORD_LOGICALLY_DELETED;
110 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
111 G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_INVALID_VALUE;
112 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_COL_NAME_TOKEN;
113 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_PARENT_TABLE_TOKEN;
114 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_CHILD_TABLE_TOKEN;
115
116 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
117 G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKL_NO_PARENT_RECORD';
118 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
119 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
120 G_NOT_SAME CONSTANT VARCHAR2(200) := 'OKL_CANNOT_BE_SAME';
121
122 ---------------------------------------------------------------------------
123 -- GLOBAL VARIABLES
124 ---------------------------------------------------------------------------
125 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_CLG_PVT';
126 G_APP_NAME CONSTANT VARCHAR2(3) := Okl_Api.G_APP_NAME;
127
128 G_VIEW CONSTANT VARCHAR2(30) := 'OKL_XTD_SELL_INVS_V';
129 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
130
131
132 ---------------------------------------------------------------------------
133 -- Procedures and Functions
134 ---------------------------------------------------------------------------
135
136 PROCEDURE qc;
137 PROCEDURE change_version;
138 PROCEDURE api_copy;
139 PROCEDURE add_language;
140 PROCEDURE insert_row(
141 p_api_version IN NUMBER,
142 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
143 x_return_status OUT NOCOPY VARCHAR2,
144 x_msg_count OUT NOCOPY NUMBER,
145 x_msg_data OUT NOCOPY VARCHAR2,
146 p_clgv_rec IN clgv_rec_type,
147 x_clgv_rec OUT NOCOPY clgv_rec_type);
148
149 PROCEDURE insert_row(
150 p_api_version IN NUMBER,
151 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
152 x_return_status OUT NOCOPY VARCHAR2,
153 x_msg_count OUT NOCOPY NUMBER,
154 x_msg_data OUT NOCOPY VARCHAR2,
155 p_clgv_tbl IN clgv_tbl_type,
156 x_clgv_tbl OUT NOCOPY clgv_tbl_type);
157
158 PROCEDURE lock_row(
159 p_api_version IN NUMBER,
160 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
161 x_return_status OUT NOCOPY VARCHAR2,
162 x_msg_count OUT NOCOPY NUMBER,
163 x_msg_data OUT NOCOPY VARCHAR2,
164 p_clgv_rec IN clgv_rec_type);
165
166 PROCEDURE lock_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_clgv_tbl IN clgv_tbl_type);
173
174 PROCEDURE update_row(
175 p_api_version IN NUMBER,
176 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
177 x_return_status OUT NOCOPY VARCHAR2,
178 x_msg_count OUT NOCOPY NUMBER,
179 x_msg_data OUT NOCOPY VARCHAR2,
180 p_clgv_rec IN clgv_rec_type,
181 x_clgv_rec OUT NOCOPY clgv_rec_type);
182
183 PROCEDURE update_row(
184 p_api_version IN NUMBER,
185 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
186 x_return_status OUT NOCOPY VARCHAR2,
187 x_msg_count OUT NOCOPY NUMBER,
188 x_msg_data OUT NOCOPY VARCHAR2,
189 p_clgv_tbl IN clgv_tbl_type,
190 x_clgv_tbl OUT NOCOPY clgv_tbl_type);
191
192 PROCEDURE delete_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_clgv_rec IN clgv_rec_type);
199
200 PROCEDURE delete_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_clgv_tbl IN clgv_tbl_type);
207
208 PROCEDURE validate_row(
209 p_api_version IN NUMBER,
210 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
211 x_return_status OUT NOCOPY VARCHAR2,
212 x_msg_count OUT NOCOPY NUMBER,
213 x_msg_data OUT NOCOPY VARCHAR2,
214 p_clgv_rec IN clgv_rec_type);
215
216 PROCEDURE validate_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_clgv_tbl IN clgv_tbl_type);
223
224 END Okl_Clg_Pvt;
225