[Home] [Help]
PACKAGE: APPS.OKL_CRN_PVT
Source
1 PACKAGE Okl_Crn_Pvt AUTHID CURRENT_USER AS
2 /* $Header: OKLSCRNS.pls 115.1 2002/02/05 12:15:54 pkm ship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE crn_rec_type IS RECORD (
7 id NUMBER := okl_api.G_MISS_NUM,
8 data_type_code OKL_CRITERIA_B.DATA_TYPE_CODE%TYPE := okl_api.G_MISS_CHAR,
9 jtf_object_code OKL_CRITERIA_B.JTF_OBJECT_CODE%TYPE := okl_api.G_MISS_CHAR,
10 crn_type OKL_CRITERIA_B.CRN_TYPE%TYPE := okl_api.G_MISS_CHAR,
11 object_version_number NUMBER := okl_api.G_MISS_NUM,
12 attribute_category OKL_CRITERIA_B.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
13 attribute1 OKL_CRITERIA_B.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
14 attribute2 OKL_CRITERIA_B.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
15 attribute3 OKL_CRITERIA_B.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
16 attribute4 OKL_CRITERIA_B.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
17 attribute5 OKL_CRITERIA_B.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
18 attribute6 OKL_CRITERIA_B.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
19 attribute7 OKL_CRITERIA_B.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
20 attribute8 OKL_CRITERIA_B.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
21 attribute9 OKL_CRITERIA_B.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
22 attribute10 OKL_CRITERIA_B.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
23 attribute11 OKL_CRITERIA_B.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
24 attribute12 OKL_CRITERIA_B.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
25 attribute13 OKL_CRITERIA_B.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
26 attribute14 OKL_CRITERIA_B.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
27 attribute15 OKL_CRITERIA_B.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
28 created_by NUMBER := okl_api.G_MISS_NUM,
29 creation_date OKL_CRITERIA_B.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
30 last_updated_by NUMBER := okl_api.G_MISS_NUM,
31 last_update_date OKL_CRITERIA_B.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
32 last_update_login NUMBER := okl_api.G_MISS_NUM);
33 g_miss_crn_rec crn_rec_type;
34 TYPE crn_tbl_type IS TABLE OF crn_rec_type
35 INDEX BY BINARY_INTEGER;
36 TYPE okl_criteria_tl_rec_type IS RECORD (
37 id NUMBER := okl_api.G_MISS_NUM,
38 LANGUAGE OKL_CRITERIA_TL.LANGUAGE%TYPE := okl_api.G_MISS_CHAR,
39 source_lang OKL_CRITERIA_TL.SOURCE_LANG%TYPE := okl_api.G_MISS_CHAR,
40 sfwt_flag OKL_CRITERIA_TL.SFWT_FLAG%TYPE := okl_api.G_MISS_CHAR,
41 name OKL_CRITERIA_TL.NAME%TYPE := okl_api.G_MISS_CHAR,
42 description OKL_CRITERIA_TL.DESCRIPTION%TYPE := okl_api.G_MISS_CHAR,
43 created_by NUMBER := okl_api.G_MISS_NUM,
44 creation_date OKL_CRITERIA_TL.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
45 last_updated_by NUMBER := okl_api.G_MISS_NUM,
46 last_update_date OKL_CRITERIA_TL.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
47 last_update_login NUMBER := okl_api.G_MISS_NUM);
48 g_miss_okl_criteria_tl_rec okl_criteria_tl_rec_type;
49 TYPE okl_criteria_tl_tbl_type IS TABLE OF okl_criteria_tl_rec_type
50 INDEX BY BINARY_INTEGER;
51 TYPE crnv_rec_type IS RECORD (
52 id NUMBER := okl_api.G_MISS_NUM,
53 object_version_number NUMBER := okl_api.G_MISS_NUM,
54 sfwt_flag OKL_CRITERIA_V.SFWT_FLAG%TYPE := okl_api.G_MISS_CHAR,
55 data_type_code OKL_CRITERIA_V.DATA_TYPE_CODE%TYPE := okl_api.G_MISS_CHAR,
56 jtf_object_code OKL_CRITERIA_V.JTF_OBJECT_CODE%TYPE := okl_api.G_MISS_CHAR,
57 name OKL_CRITERIA_V.NAME%TYPE := okl_api.G_MISS_CHAR,
58 description OKL_CRITERIA_V.DESCRIPTION%TYPE := okl_api.G_MISS_CHAR,
59 attribute_category OKL_CRITERIA_V.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
60 attribute1 OKL_CRITERIA_V.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
61 attribute2 OKL_CRITERIA_V.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
62 attribute3 OKL_CRITERIA_V.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
63 attribute4 OKL_CRITERIA_V.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
64 attribute5 OKL_CRITERIA_V.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
65 attribute6 OKL_CRITERIA_V.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
66 attribute7 OKL_CRITERIA_V.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
67 attribute8 OKL_CRITERIA_V.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
68 attribute9 OKL_CRITERIA_V.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
69 attribute10 OKL_CRITERIA_V.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
70 attribute11 OKL_CRITERIA_V.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
71 attribute12 OKL_CRITERIA_V.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
72 attribute13 OKL_CRITERIA_V.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
73 attribute14 OKL_CRITERIA_V.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
74 attribute15 OKL_CRITERIA_V.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
75 crn_type OKL_CRITERIA_V.CRN_TYPE%TYPE := okl_api.G_MISS_CHAR,
76 created_by NUMBER := okl_api.G_MISS_NUM,
77 creation_date OKL_CRITERIA_V.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
78 last_updated_by NUMBER := okl_api.G_MISS_NUM,
79 last_update_date OKL_CRITERIA_V.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
80 last_update_login NUMBER := okl_api.G_MISS_NUM);
81 g_miss_crnv_rec crnv_rec_type;
82 TYPE crnv_tbl_type IS TABLE OF crnv_rec_type
83 INDEX BY BINARY_INTEGER;
84 ---------------------------------------------------------------------------
85 -- GLOBAL MESSAGE CONSTANTS
86 ---------------------------------------------------------------------------
87 G_FND_APP CONSTANT VARCHAR2(200) := okl_api.G_FND_APP;
88 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := okl_api.G_FORM_UNABLE_TO_RESERVE_REC;
89 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_DELETED;
90 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_CHANGED;
91 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := okl_api.G_RECORD_LOGICALLY_DELETED;
92 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := okl_api.G_REQUIRED_VALUE;
93 G_INVALID_VALUE CONSTANT VARCHAR2(200) := okl_api.G_INVALID_VALUE;
94 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_COL_NAME_TOKEN;
95 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_PARENT_TABLE_TOKEN;
96 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_CHILD_TABLE_TOKEN;
97 ---------------------------------------------------------------------------
98 -- GLOBAL VARIABLES
99 ---------------------------------------------------------------------------
100 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_CRN_PVT';
101 G_APP_NAME CONSTANT VARCHAR2(3) := okl_api.G_APP_NAME;
102
103 /******************ADDED AFTER TAPI, (05/23/2001) ****************/
104 --GLOBAL MESSAGES
105 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
106 G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKL_NO_PARENT_RECORD';
107 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
108 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
109 G_NOT_SAME CONSTANT VARCHAR2(200) := 'OKL_CANNOT_BE_SAME';
110
111
112 --GLOBAL VARIABLES
113 G_VIEW CONSTANT VARCHAR2(30) := 'OKL_CRITERIA_V';
114 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
115
116 /****************END ADDITION AFTER TAPI, (05/23/2001)**************/
117
118 ---------------------------------------------------------------------------
119 -- Procedures and Functions
120 ---------------------------------------------------------------------------
121
122 PROCEDURE qc;
123 PROCEDURE change_version;
124 PROCEDURE api_copy;
125 PROCEDURE add_language;
126 PROCEDURE insert_row(
127 p_api_version IN NUMBER,
128 p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
129 x_return_status OUT NOCOPY VARCHAR2,
130 x_msg_count OUT NOCOPY NUMBER,
131 x_msg_data OUT NOCOPY VARCHAR2,
132 p_crnv_rec IN crnv_rec_type,
133 x_crnv_rec OUT NOCOPY crnv_rec_type);
134
135 PROCEDURE insert_row(
136 p_api_version IN NUMBER,
137 p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
138 x_return_status OUT NOCOPY VARCHAR2,
139 x_msg_count OUT NOCOPY NUMBER,
140 x_msg_data OUT NOCOPY VARCHAR2,
141 p_crnv_tbl IN crnv_tbl_type,
142 x_crnv_tbl OUT NOCOPY crnv_tbl_type);
143
144 PROCEDURE lock_row(
145 p_api_version IN NUMBER,
146 p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
147 x_return_status OUT NOCOPY VARCHAR2,
148 x_msg_count OUT NOCOPY NUMBER,
149 x_msg_data OUT NOCOPY VARCHAR2,
150 p_crnv_rec IN crnv_rec_type);
151
152 PROCEDURE lock_row(
153 p_api_version IN NUMBER,
154 p_init_msg_list IN VARCHAR2 DEFAULT okl_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_crnv_tbl IN crnv_tbl_type);
159
160 PROCEDURE update_row(
161 p_api_version IN NUMBER,
162 p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
163 x_return_status OUT NOCOPY VARCHAR2,
164 x_msg_count OUT NOCOPY NUMBER,
165 x_msg_data OUT NOCOPY VARCHAR2,
166 p_crnv_rec IN crnv_rec_type,
167 x_crnv_rec OUT NOCOPY crnv_rec_type);
168
169 PROCEDURE update_row(
170 p_api_version IN NUMBER,
171 p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
172 x_return_status OUT NOCOPY VARCHAR2,
173 x_msg_count OUT NOCOPY NUMBER,
174 x_msg_data OUT NOCOPY VARCHAR2,
175 p_crnv_tbl IN crnv_tbl_type,
176 x_crnv_tbl OUT NOCOPY crnv_tbl_type);
177
178 PROCEDURE delete_row(
179 p_api_version IN NUMBER,
180 p_init_msg_list IN VARCHAR2 DEFAULT okl_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_crnv_rec IN crnv_rec_type);
185
186 PROCEDURE delete_row(
187 p_api_version IN NUMBER,
188 p_init_msg_list IN VARCHAR2 DEFAULT okl_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_crnv_tbl IN crnv_tbl_type);
193
194 PROCEDURE validate_row(
195 p_api_version IN NUMBER,
196 p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
197 x_return_status OUT NOCOPY VARCHAR2,
198 x_msg_count OUT NOCOPY NUMBER,
199 x_msg_data OUT NOCOPY VARCHAR2,
200 p_crnv_rec IN crnv_rec_type);
201
202 PROCEDURE validate_row(
203 p_api_version IN NUMBER,
204 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
205 x_return_status OUT NOCOPY VARCHAR2,
206 x_msg_count OUT NOCOPY NUMBER,
207 x_msg_data OUT NOCOPY VARCHAR2,
208 p_crnv_tbl IN crnv_tbl_type);
209
210 END Okl_Crn_Pvt;