[Home] [Help]
PACKAGE: APPS.OKC_CNL_PVT
Source
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE cnl_rec_type IS RECORD (
7 id NUMBER := OKC_API.G_MISS_NUM,
8 cnh_id NUMBER := OKC_API.G_MISS_NUM,
9 pdf_id NUMBER := OKC_API.G_MISS_NUM,
10 aae_id NUMBER := OKC_API.G_MISS_NUM,
11 left_ctr_master_id NUMBER := OKC_API.G_MISS_NUM,
12 right_ctr_master_id NUMBER := OKC_API.G_MISS_NUM,
13 left_counter_id NUMBER := OKC_API.G_MISS_NUM,
14 right_counter_id NUMBER := OKC_API.G_MISS_NUM,
15 dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
16 sortseq NUMBER := OKC_API.G_MISS_NUM,
17 logical_operator OKC_CONDITION_LINES_B.LOGICAL_OPERATOR%TYPE := OKC_API.G_MISS_CHAR,
18 cnl_type OKC_CONDITION_LINES_B.CNL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
19 object_version_number NUMBER := OKC_API.G_MISS_NUM,
20 created_by NUMBER := OKC_API.G_MISS_NUM,
21 creation_date OKC_CONDITION_LINES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
22 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
23 last_update_date OKC_CONDITION_LINES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
24 left_parenthesis OKC_CONDITION_LINES_B.LEFT_PARENTHESIS%TYPE := OKC_API.G_MISS_CHAR,
25 relational_operator OKC_CONDITION_LINES_B.RELATIONAL_OPERATOR%TYPE := OKC_API.G_MISS_CHAR,
26 right_parenthesis OKC_CONDITION_LINES_B.RIGHT_PARENTHESIS%TYPE := OKC_API.G_MISS_CHAR,
27 tolerance NUMBER := OKC_API.G_MISS_NUM,
28 start_at NUMBER := OKC_API.G_MISS_NUM,
29 right_operand OKC_CONDITION_LINES_B.RIGHT_OPERAND%TYPE := OKC_API.G_MISS_CHAR,
30 last_update_login NUMBER := OKC_API.G_MISS_NUM,
31 attribute_category OKC_CONDITION_LINES_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
32 attribute1 OKC_CONDITION_LINES_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
33 attribute2 OKC_CONDITION_LINES_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
34 attribute3 OKC_CONDITION_LINES_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
35 attribute4 OKC_CONDITION_LINES_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
36 attribute5 OKC_CONDITION_LINES_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
37 attribute6 OKC_CONDITION_LINES_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
38 attribute7 OKC_CONDITION_LINES_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
39 attribute8 OKC_CONDITION_LINES_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
40 attribute9 OKC_CONDITION_LINES_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
41 attribute10 OKC_CONDITION_LINES_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
42 attribute11 OKC_CONDITION_LINES_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
43 attribute12 OKC_CONDITION_LINES_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
44 attribute13 OKC_CONDITION_LINES_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
45 attribute14 OKC_CONDITION_LINES_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
46 attribute15 OKC_CONDITION_LINES_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
47 application_id NUMBER := OKC_API.G_MISS_NUM,
48 seeded_flag OKC_CONDITION_LINES_B.SEEDED_FLAG%TYPE := OKC_API.G_MISS_CHAR);
49 g_miss_cnl_rec cnl_rec_type;
50 TYPE cnl_tbl_type IS TABLE OF cnl_rec_type
51 INDEX BY BINARY_INTEGER;
52 TYPE OkcConditionLinesTlRecType IS RECORD (
53 id NUMBER := OKC_API.G_MISS_NUM,
54 language OKC_CONDITION_LINES_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
55 source_lang OKC_CONDITION_LINES_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
56 sfwt_flag OKC_CONDITION_LINES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
57 description OKC_CONDITION_LINES_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
58 created_by NUMBER := OKC_API.G_MISS_NUM,
59 creation_date OKC_CONDITION_LINES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
60 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
61 last_update_date OKC_CONDITION_LINES_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
62 last_update_login NUMBER := OKC_API.G_MISS_NUM);
63 GMissOkcConditionLinesTlRec OkcConditionLinesTlRecType;
64 TYPE OkcConditionLinesTlTblType IS TABLE OF OkcConditionLinesTlRecType
65 INDEX BY BINARY_INTEGER;
66 TYPE cnlv_rec_type IS RECORD (
67 id NUMBER := OKC_API.G_MISS_NUM,
68 object_version_number NUMBER := OKC_API.G_MISS_NUM,
69 sfwt_flag OKC_CONDITION_LINES_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
70 cnh_id NUMBER := OKC_API.G_MISS_NUM,
71 pdf_id NUMBER := OKC_API.G_MISS_NUM,
72 aae_id NUMBER := OKC_API.G_MISS_NUM,
73 left_ctr_master_id NUMBER := OKC_API.G_MISS_NUM,
74 right_ctr_master_id NUMBER := OKC_API.G_MISS_NUM,
75 left_counter_id NUMBER := OKC_API.G_MISS_NUM,
76 right_counter_id NUMBER := OKC_API.G_MISS_NUM,
77 dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
78 sortseq NUMBER := OKC_API.G_MISS_NUM,
79 cnl_type OKC_CONDITION_LINES_V.CNL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
80 description OKC_CONDITION_LINES_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
81 left_parenthesis OKC_CONDITION_LINES_V.LEFT_PARENTHESIS%TYPE := OKC_API.G_MISS_CHAR,
82 relational_operator OKC_CONDITION_LINES_V.RELATIONAL_OPERATOR%TYPE := OKC_API.G_MISS_CHAR,
83 right_parenthesis OKC_CONDITION_LINES_V.RIGHT_PARENTHESIS%TYPE := OKC_API.G_MISS_CHAR,
84 logical_operator OKC_CONDITION_LINES_V.LOGICAL_OPERATOR%TYPE := OKC_API.G_MISS_CHAR,
85 tolerance NUMBER := OKC_API.G_MISS_NUM,
86 start_at NUMBER := OKC_API.G_MISS_NUM,
87 right_operand OKC_CONDITION_LINES_V.RIGHT_OPERAND%TYPE := OKC_API.G_MISS_CHAR,
88 application_id NUMBER := OKC_API.G_MISS_NUM,
89 seeded_flag OKC_CONDITION_LINES_V.SEEDED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
90 attribute_category OKC_CONDITION_LINES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
91 attribute1 OKC_CONDITION_LINES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
92 attribute2 OKC_CONDITION_LINES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
93 attribute3 OKC_CONDITION_LINES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
94 attribute4 OKC_CONDITION_LINES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
95 attribute5 OKC_CONDITION_LINES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
96 attribute6 OKC_CONDITION_LINES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
97 attribute7 OKC_CONDITION_LINES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
98 attribute8 OKC_CONDITION_LINES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
99 attribute9 OKC_CONDITION_LINES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
100 attribute10 OKC_CONDITION_LINES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
101 attribute11 OKC_CONDITION_LINES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
102 attribute12 OKC_CONDITION_LINES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
103 attribute13 OKC_CONDITION_LINES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
104 attribute14 OKC_CONDITION_LINES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
105 attribute15 OKC_CONDITION_LINES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
106 created_by NUMBER := OKC_API.G_MISS_NUM,
107 creation_date OKC_CONDITION_LINES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
108 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
109 last_update_date OKC_CONDITION_LINES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
110 last_update_login NUMBER := OKC_API.G_MISS_NUM);
111 g_miss_cnlv_rec cnlv_rec_type;
112 TYPE cnlv_tbl_type IS TABLE OF cnlv_rec_type
113 INDEX BY BINARY_INTEGER;
114 ---------------------------------------------------------------------------
115 -- GLOBAL MESSAGE CONSTANTS
116 ---------------------------------------------------------------------------
117 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
118 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
119 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
120 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
121 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
122 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
123 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
124 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
125 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
126 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
127 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
128 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
129 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
130 G_UPPERCASE_REQUIRED CONSTANT VARCHAR2(200) := 'OKC_UPPERCASE_REQUIRED';
131 ---------------------------------------------------------------------------
132 -- GLOBAL EXCEPTION
133 ---------------------------------------------------------------------------
134 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
135 ---------------------------------------------------------------------------
136 -- GLOBAL VARIABLES
137 ---------------------------------------------------------------------------
138 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_CNL_PVT';
139 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
140 ---------------------------------------------------------------------------
141 -- Procedures and Functions
145 PROCEDURE change_version;
1 Package OKC_CNL_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKCSCNLS.pls 120.0 2005/05/25 18:39:47 appldev noship $ */
142 ---------------------------------------------------------------------------
143
144 PROCEDURE qc;
146 PROCEDURE api_copy;
147 PROCEDURE add_language;
148 PROCEDURE insert_row(
149 p_api_version IN NUMBER,
150 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_cnlv_rec IN cnlv_rec_type,
155 x_cnlv_rec OUT NOCOPY cnlv_rec_type);
156
157 PROCEDURE insert_row(
158 p_api_version IN NUMBER,
159 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_cnlv_tbl IN cnlv_tbl_type,
164 x_cnlv_tbl OUT NOCOPY cnlv_tbl_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_cnlv_rec IN cnlv_rec_type);
173
174 PROCEDURE lock_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_cnlv_tbl IN cnlv_tbl_type);
181
182 PROCEDURE update_row(
183 p_api_version IN NUMBER,
184 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
185 x_return_status OUT NOCOPY VARCHAR2,
186 x_msg_count OUT NOCOPY NUMBER,
187 x_msg_data OUT NOCOPY VARCHAR2,
188 p_cnlv_rec IN cnlv_rec_type,
189 x_cnlv_rec OUT NOCOPY cnlv_rec_type);
190
191 PROCEDURE update_row(
192 p_api_version IN NUMBER,
193 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
194 x_return_status OUT NOCOPY VARCHAR2,
195 x_msg_count OUT NOCOPY NUMBER,
196 x_msg_data OUT NOCOPY VARCHAR2,
197 p_cnlv_tbl IN cnlv_tbl_type,
198 x_cnlv_tbl OUT NOCOPY cnlv_tbl_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,
207
204 x_msg_count OUT NOCOPY NUMBER,
205 x_msg_data OUT NOCOPY VARCHAR2,
206 p_cnlv_rec IN cnlv_rec_type);
208 PROCEDURE delete_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_cnlv_tbl IN cnlv_tbl_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_cnlv_rec IN cnlv_rec_type);
223
224 PROCEDURE validate_row(
225 p_api_version IN NUMBER,
226 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
227 x_return_status OUT NOCOPY VARCHAR2,
228 x_msg_count OUT NOCOPY NUMBER,
229 x_msg_data OUT NOCOPY VARCHAR2,
230 p_cnlv_tbl IN cnlv_tbl_type);
231
232 PROCEDURE INSERT_ROW_UPG(x_return_status OUT NOCOPY VARCHAR2, p_cnlv_tbl cnlv_tbl_type);
233
234 FUNCTION create_version(
235 p_chr_id IN NUMBER,
236 p_major_version IN NUMBER) RETURN VARCHAR2;
237
238 FUNCTION restore_version(
239 p_chr_id IN NUMBER,
242 END OKC_CNL_PVT;
240 p_major_version IN NUMBER) RETURN VARCHAR2;
241