[Home] [Help]
PACKAGE: APPS.OKL_CLS_PVT
Source
1 PACKAGE Okl_Cls_Pvt AUTHID CURRENT_USER AS
2 /* $Header: OKLSCLSS.pls 115.1 2002/02/05 12:15:41 pkm ship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE cls_rec_type IS RECORD (
7 id NUMBER := okl_api.G_MISS_NUM,
8 crn_id NUMBER := okl_api.G_MISS_NUM,
9 lse_id NUMBER := okl_api.G_MISS_NUM,
10 object_version_number NUMBER := okl_api.G_MISS_NUM,
11 attribute_category OKL_CRTRN_LNSTYLS.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
12 attribute1 OKL_CRTRN_LNSTYLS.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
13 attribute2 OKL_CRTRN_LNSTYLS.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
14 attribute3 OKL_CRTRN_LNSTYLS.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
15 attribute4 OKL_CRTRN_LNSTYLS.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
16 attribute5 OKL_CRTRN_LNSTYLS.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
17 attribute6 OKL_CRTRN_LNSTYLS.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
18 attribute7 OKL_CRTRN_LNSTYLS.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
19 attribute8 OKL_CRTRN_LNSTYLS.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
20 attribute9 OKL_CRTRN_LNSTYLS.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
21 attribute10 OKL_CRTRN_LNSTYLS.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
22 attribute11 OKL_CRTRN_LNSTYLS.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
23 attribute12 OKL_CRTRN_LNSTYLS.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
24 attribute13 OKL_CRTRN_LNSTYLS.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
25 attribute14 OKL_CRTRN_LNSTYLS.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
26 attribute15 OKL_CRTRN_LNSTYLS.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
27 created_by NUMBER := okl_api.G_MISS_NUM,
28 creation_date OKL_CRTRN_LNSTYLS.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
29 last_updated_by NUMBER := okl_api.G_MISS_NUM,
30 last_update_date OKL_CRTRN_LNSTYLS.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
31 last_update_login NUMBER := okl_api.G_MISS_NUM);
32 g_miss_cls_rec cls_rec_type;
33 TYPE cls_tbl_type IS TABLE OF cls_rec_type
34 INDEX BY BINARY_INTEGER;
35 TYPE clsv_rec_type IS RECORD (
36 id NUMBER := okl_api.G_MISS_NUM,
37 object_version_number NUMBER := okl_api.G_MISS_NUM,
38 crn_id NUMBER := okl_api.G_MISS_NUM,
39 lse_id NUMBER := okl_api.G_MISS_NUM,
40 attribute_category OKL_CRTRN_LNSTYLS_V.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
41 attribute1 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
42 attribute2 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
43 attribute3 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
44 attribute4 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
45 attribute5 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
46 attribute6 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
47 attribute7 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
48 attribute8 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
49 attribute9 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
50 attribute10 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
51 attribute11 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
52 attribute12 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
53 attribute13 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
54 attribute14 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
55 attribute15 OKL_CRTRN_LNSTYLS_V.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
56 created_by NUMBER := okl_api.G_MISS_NUM,
57 creation_date OKL_CRTRN_LNSTYLS_V.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
58 last_updated_by NUMBER := okl_api.G_MISS_NUM,
59 last_update_date OKL_CRTRN_LNSTYLS_V.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
60 last_update_login NUMBER := okl_api.G_MISS_NUM);
61 g_miss_clsv_rec clsv_rec_type;
62 TYPE clsv_tbl_type IS TABLE OF clsv_rec_type
63 INDEX BY BINARY_INTEGER;
64 ---------------------------------------------------------------------------
65 -- GLOBAL MESSAGE CONSTANTS
66 ---------------------------------------------------------------------------
67 G_FND_APP CONSTANT VARCHAR2(200) := okl_api.G_FND_APP;
68 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := okl_api.G_FORM_UNABLE_TO_RESERVE_REC;
69 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_DELETED;
70 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_CHANGED;
71 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := okl_api.G_RECORD_LOGICALLY_DELETED;
72 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := okl_api.G_REQUIRED_VALUE;
73 G_INVALID_VALUE CONSTANT VARCHAR2(200) := okl_api.G_INVALID_VALUE;
74 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_COL_NAME_TOKEN;
75 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_PARENT_TABLE_TOKEN;
76 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_CHILD_TABLE_TOKEN;
77 ---------------------------------------------------------------------------
78 -- GLOBAL VARIABLES
79 ---------------------------------------------------------------------------
80 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_CLS_PVT';
81 G_APP_NAME CONSTANT VARCHAR2(3) := okl_api.G_APP_NAME;
82
83 /******************ADDED AFTER TAPI, (05/23/2001) ****************/
84 --GLOBAL MESSAGES
85 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
86 G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKL_NO_PARENT_RECORD';
87 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
88 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
89 G_NOT_SAME CONSTANT VARCHAR2(200) := 'OKL_CANNOT_BE_SAME';
90
91
92 --GLOBAL VARIABLES
93 G_VIEW CONSTANT VARCHAR2(30) := 'OKL_CRTRN_LNSTYLS_V';
94 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
95
96 /****************END ADDITION AFTER TAPI, (05/23/2001)**************/
97
98 ---------------------------------------------------------------------------
99 -- Procedures and Functions
100 ---------------------------------------------------------------------------
101
102 PROCEDURE qc;
103 PROCEDURE change_version;
104 PROCEDURE api_copy;
105 PROCEDURE insert_row(
106 p_api_version IN NUMBER,
107 p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
108 x_return_status OUT NOCOPY VARCHAR2,
109 x_msg_count OUT NOCOPY NUMBER,
110 x_msg_data OUT NOCOPY VARCHAR2,
111 p_clsv_rec IN clsv_rec_type,
112 x_clsv_rec OUT NOCOPY clsv_rec_type);
113
114 PROCEDURE insert_row(
115 p_api_version IN NUMBER,
116 p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
117 x_return_status OUT NOCOPY VARCHAR2,
118 x_msg_count OUT NOCOPY NUMBER,
119 x_msg_data OUT NOCOPY VARCHAR2,
120 p_clsv_tbl IN clsv_tbl_type,
121 x_clsv_tbl OUT NOCOPY clsv_tbl_type);
122
123 PROCEDURE lock_row(
124 p_api_version IN NUMBER,
125 p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
126 x_return_status OUT NOCOPY VARCHAR2,
127 x_msg_count OUT NOCOPY NUMBER,
128 x_msg_data OUT NOCOPY VARCHAR2,
129 p_clsv_rec IN clsv_rec_type);
130
131 PROCEDURE lock_row(
132 p_api_version IN NUMBER,
133 p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
134 x_return_status OUT NOCOPY VARCHAR2,
135 x_msg_count OUT NOCOPY NUMBER,
136 x_msg_data OUT NOCOPY VARCHAR2,
137 p_clsv_tbl IN clsv_tbl_type);
138
139 PROCEDURE update_row(
140 p_api_version IN NUMBER,
141 p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
142 x_return_status OUT NOCOPY VARCHAR2,
143 x_msg_count OUT NOCOPY NUMBER,
144 x_msg_data OUT NOCOPY VARCHAR2,
145 p_clsv_rec IN clsv_rec_type,
146 x_clsv_rec OUT NOCOPY clsv_rec_type);
147
148 PROCEDURE update_row(
149 p_api_version IN NUMBER,
150 p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
151 x_return_status OUT NOCOPY VARCHAR2,
152 x_msg_count OUT NOCOPY NUMBER,
153 x_msg_data OUT NOCOPY VARCHAR2,
154 p_clsv_tbl IN clsv_tbl_type,
155 x_clsv_tbl OUT NOCOPY clsv_tbl_type);
156
157 PROCEDURE delete_row(
158 p_api_version IN NUMBER,
159 p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
160 x_return_status OUT NOCOPY VARCHAR2,
161 x_msg_count OUT NOCOPY NUMBER,
162 x_msg_data OUT NOCOPY VARCHAR2,
163 p_clsv_rec IN clsv_rec_type);
164
165 PROCEDURE delete_row(
166 p_api_version IN NUMBER,
167 p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
168 x_return_status OUT NOCOPY VARCHAR2,
169 x_msg_count OUT NOCOPY NUMBER,
170 x_msg_data OUT NOCOPY VARCHAR2,
171 p_clsv_tbl IN clsv_tbl_type);
172
173 PROCEDURE validate_row(
174 p_api_version IN NUMBER,
175 p_init_msg_list IN VARCHAR2 DEFAULT okl_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_clsv_rec IN clsv_rec_type);
180
181 PROCEDURE validate_row(
182 p_api_version IN NUMBER,
183 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
184 x_return_status OUT NOCOPY VARCHAR2,
185 x_msg_count OUT NOCOPY NUMBER,
186 x_msg_data OUT NOCOPY VARCHAR2,
187 p_clsv_tbl IN clsv_tbl_type);
188
189 END Okl_Cls_Pvt;