[Home] [Help]
PACKAGE: APPS.OKS_QUA_PVT
Source
1 Package OKS_QUA_PVT AS
2 /* $Header: OKSSQUAS.pls 120.0 2005/05/27 15:27:07 appldev noship $ */
3
4 ---------------------------------------------------------------------------
5 -- GLOBAL DATASTRUCTURES
6 ---------------------------------------------------------------------------
7 TYPE qua_rec_type IS RECORD (
8 QUALIFIER_ID NUMBER := OKC_API.G_MISS_NUM,
9 CREATION_DATE OKS_QUALIFIERS.creation_date%TYPE := OKC_API.G_MISS_DATE,
10 CREATED_BY NUMBER := OKC_API.G_MISS_NUM,
11 LAST_UPDATE_DATE OKS_QUALIFIERS.last_update_date%TYPE := OKC_API.G_MISS_DATE,
12 LAST_UPDATED_BY NUMBER := OKC_API.G_MISS_NUM,
13 REQUEST_ID NUMBER := OKC_API.G_MISS_NUM,
14 PROGRAM_APPLICATION_ID NUMBER := OKC_API.G_MISS_NUM,
15 PROGRAM_ID NUMBER := OKC_API.G_MISS_NUM,
16 PROGRAM_UPDATE_DATE OKS_QUALIFIERS.program_update_date%TYPE := OKC_API.G_MISS_DATE,
17 LAST_UPDATE_LOGIN NUMBER := OKC_API.G_MISS_NUM,
18 QUALIFIER_GROUPING_NO NUMBER := OKC_API.G_MISS_NUM,
19 QUALIFIER_CONTEXT OKS_QUALIFIERS.QUALIFIER_CONTEXT%TYPE := OKC_API.G_MISS_CHAR,
20 QUALIFIER_ATTRIBUTE OKS_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE := OKC_API.G_MISS_CHAR,
21 QUALIFIER_ATTR_VALUE OKS_QUALIFIERS.QUALIFIER_ATTR_VALUE%TYPE := OKC_API.G_MISS_CHAR,
22 COMPARISON_OPERATOR_CODE OKS_QUALIFIERS.comparison_operator_code%TYPE := OKC_API.G_MISS_CHAR,
23 EXCLUDER_FLAG OKS_QUALIFIERS.excluder_flag%TYPE := OKC_API.G_MISS_CHAR,
24 QUALIFIER_RULE_ID NUMBER := OKC_API.G_MISS_NUM,
25 START_DATE_ACTIVE OKS_QUALIFIERS.start_date_active%TYPE := OKC_API.G_MISS_DATE,
26 END_DATE_ACTIVE OKS_QUALIFIERS.end_date_active%TYPE := OKC_API.G_MISS_DATE,
27 CREATED_FROM_RULE_ID NUMBER := OKC_API.G_MISS_NUM,
28 QUALIFIER_PRECEDENCE NUMBER := OKC_API.G_MISS_NUM,
29 LIST_HEADER_ID NUMBER := OKC_API.G_MISS_NUM,
30 LIST_LINE_ID NUMBER := OKC_API.G_MISS_NUM,
31 QUALIFIER_DATATYPE OKS_QUALIFIERS.QUALIFIER_DATATYPE%TYPE := OKC_API.G_MISS_CHAR,
32 QUALIFIER_ATTR_VALUE_TO OKS_QUALIFIERS.QUALIFIER_attr_value_to%TYPE := OKC_API.G_MISS_CHAR,
33 CONTEXT OKS_QUALIFIERS.CONTEXT%TYPE := OKC_API.G_MISS_CHAR,
34 ATTRIBUTE1 OKS_QUALIFIERS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
35 ATTRIBUTE2 OKS_QUALIFIERS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
36 ATTRIBUTE3 OKS_QUALIFIERS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
37 ATTRIBUTE4 OKS_QUALIFIERS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
38 ATTRIBUTE5 OKS_QUALIFIERS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
39 ATTRIBUTE6 OKS_QUALIFIERS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
40 ATTRIBUTE7 OKS_QUALIFIERS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
41 ATTRIBUTE8 OKS_QUALIFIERS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
42 ATTRIBUTE9 OKS_QUALIFIERS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
43 ATTRIBUTE10 OKS_QUALIFIERS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
44 ATTRIBUTE11 OKS_QUALIFIERS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
45 ATTRIBUTE12 OKS_QUALIFIERS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
46 ATTRIBUTE13 OKS_QUALIFIERS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
47 ATTRIBUTE14 OKS_QUALIFIERS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
48 ATTRIBUTE15 OKS_QUALIFIERS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
49 ACTIVE_FLAG OKS_QUALIFIERS.active_flag%TYPE := OKC_API.G_MISS_CHAR,
50 LIST_TYPE_CODE OKS_QUALIFIERS.list_type_code%TYPE := OKC_API.G_MISS_CHAR,
51 QUAL_ATTR_VALUE_FROM_NUMBER NUMBER := OKC_API.G_MISS_NUM,
52 QUAL_ATTR_VALUE_TO_NUMBER NUMBER := OKC_API.G_MISS_NUM
53 );
54
55 g_miss_qua_rec qua_rec_type;
56 TYPE qua_tbl_type IS TABLE OF qua_rec_type
57 INDEX BY BINARY_INTEGER;
58 TYPE quav_rec_type IS RECORD (
59 QUALIFIER_ID NUMBER := OKC_API.G_MISS_NUM,
60 CREATION_DATE OKS_QUALIFIERS.creation_date%TYPE := OKC_API.G_MISS_DATE,
61 CREATED_BY NUMBER := OKC_API.G_MISS_NUM,
62 LAST_UPDATE_DATE OKS_QUALIFIERS.last_update_date%TYPE := OKC_API.G_MISS_DATE,
63 LAST_UPDATED_BY NUMBER := OKC_API.G_MISS_NUM,
64 REQUEST_ID NUMBER := OKC_API.G_MISS_NUM,
65 PROGRAM_APPLICATION_ID NUMBER := OKC_API.G_MISS_NUM,
66 PROGRAM_ID NUMBER := OKC_API.G_MISS_NUM,
67 PROGRAM_UPDATE_DATE OKS_QUALIFIERS.program_update_date%TYPE := OKC_API.G_MISS_DATE,
68 LAST_UPDATE_LOGIN NUMBER := OKC_API.G_MISS_NUM,
69 QUALIFIER_GROUPING_NO NUMBER := OKC_API.G_MISS_NUM,
70 QUALIFIER_CONTEXT OKS_QUALIFIERS.QUALIFIER_CONTEXT%TYPE := OKC_API.G_MISS_CHAR,
71 QUALIFIER_ATTRIBUTE OKS_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE := OKC_API.G_MISS_CHAR,
72 QUALIFIER_ATTR_VALUE OKS_QUALIFIERS.QUALIFIER_ATTR_VALUE%TYPE := OKC_API.G_MISS_CHAR,
73 COMPARISON_OPERATOR_CODE OKS_QUALIFIERS.comparison_operator_code%TYPE := OKC_API.G_MISS_CHAR,
74 EXCLUDER_FLAG OKS_QUALIFIERS.excluder_flag%TYPE := OKC_API.G_MISS_CHAR,
75 QUALIFIER_RULE_ID NUMBER := OKC_API.G_MISS_NUM,
76 START_DATE_ACTIVE OKS_QUALIFIERS.start_date_active%TYPE := OKC_API.G_MISS_DATE,
77 END_DATE_ACTIVE OKS_QUALIFIERS.end_date_active%TYPE := OKC_API.G_MISS_DATE,
78 CREATED_FROM_RULE_ID NUMBER := OKC_API.G_MISS_NUM,
79 QUALIFIER_PRECEDENCE NUMBER := OKC_API.G_MISS_NUM,
80 LIST_HEADER_ID NUMBER := OKC_API.G_MISS_NUM,
81 LIST_LINE_ID NUMBER := OKC_API.G_MISS_NUM,
82 QUALIFIER_DATATYPE OKS_QUALIFIERS.QUALIFIER_DATATYPE%TYPE := OKC_API.G_MISS_CHAR,
83 QUALIFIER_ATTR_VALUE_TO OKS_QUALIFIERS.QUALIFIER_attr_value_to%TYPE := OKC_API.G_MISS_CHAR,
84 CONTEXT OKS_QUALIFIERS.CONTEXT%TYPE := OKC_API.G_MISS_CHAR,
85 ATTRIBUTE1 OKS_QUALIFIERS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
86 ATTRIBUTE2 OKS_QUALIFIERS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
87 ATTRIBUTE3 OKS_QUALIFIERS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
88 ATTRIBUTE4 OKS_QUALIFIERS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
89 ATTRIBUTE5 OKS_QUALIFIERS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
90 ATTRIBUTE6 OKS_QUALIFIERS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
91 ATTRIBUTE7 OKS_QUALIFIERS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
92 ATTRIBUTE8 OKS_QUALIFIERS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
93 ATTRIBUTE9 OKS_QUALIFIERS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
94 ATTRIBUTE10 OKS_QUALIFIERS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
95 ATTRIBUTE11 OKS_QUALIFIERS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
96 ATTRIBUTE12 OKS_QUALIFIERS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
97 ATTRIBUTE13 OKS_QUALIFIERS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
98 ATTRIBUTE14 OKS_QUALIFIERS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
99 ATTRIBUTE15 OKS_QUALIFIERS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
100 ACTIVE_FLAG OKS_QUALIFIERS.active_flag%TYPE := OKC_API.G_MISS_CHAR,
101 LIST_TYPE_CODE OKS_QUALIFIERS.list_type_code%TYPE := OKC_API.G_MISS_CHAR,
102 QUAL_ATTR_VALUE_FROM_NUMBER NUMBER := OKC_API.G_MISS_NUM,
103 QUAL_ATTR_VALUE_TO_NUMBER NUMBER := OKC_API.G_MISS_NUM
104 );
105 g_miss_quav_rec quav_rec_type;
106 TYPE quav_tbl_type IS TABLE OF quav_rec_type
107 INDEX BY BINARY_INTEGER;
108 ---------------------------------------------------------------------------
109 -- GLOBAL MESSAGE CONSTANTS
110 ---------------------------------------------------------------------------
111 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
112 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
113 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
114 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
115 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
116 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
117 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
118 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
119 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
120 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
121 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_QUALIFIERS_UNEXPECTED_ERROR';
122 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
123 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
124 ---------------------------------------------------------------------------
125 -- GLOBAL EXCEPTIONS
126 ---------------------------------------------------------------------------
127 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
128
129 ---------------------------------------------------------------------------
130 -- GLOBAL VARIABLES
131 ---------------------------------------------------------------------------
132 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKS_QUA_PVT';
133 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
134 ---------------------------------------------------------------------------
135 -- Procedures and Functions
136 ---------------------------------------------------------------------------
137
138 PROCEDURE qc;
139 PROCEDURE change_version;
140 PROCEDURE api_copy;
141 PROCEDURE insert_row(
142 p_api_version IN NUMBER,
143 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
144 x_return_status OUT NOCOPY VARCHAR2,
145 x_msg_count OUT NOCOPY NUMBER,
146 x_msg_data OUT NOCOPY VARCHAR2,
147 p_quav_rec IN quav_rec_type,
148 x_quav_rec OUT NOCOPY quav_rec_type);
149
150 PROCEDURE insert_row(
151 p_api_version IN NUMBER,
152 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
153 x_return_status OUT NOCOPY VARCHAR2,
154 x_msg_count OUT NOCOPY NUMBER,
155 x_msg_data OUT NOCOPY VARCHAR2,
156 p_quav_tbl IN quav_tbl_type,
157 x_quav_tbl OUT NOCOPY quav_tbl_type);
158
159 PROCEDURE lock_row(
160 p_api_version IN NUMBER,
161 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
162 x_return_status OUT NOCOPY VARCHAR2,
163 x_msg_count OUT NOCOPY NUMBER,
164 x_msg_data OUT NOCOPY VARCHAR2,
165 p_quav_rec IN quav_rec_type);
166
167 PROCEDURE lock_row(
168 p_api_version IN NUMBER,
169 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
170 x_return_status OUT NOCOPY VARCHAR2,
171 x_msg_count OUT NOCOPY NUMBER,
172 x_msg_data OUT NOCOPY VARCHAR2,
173 p_quav_tbl IN quav_tbl_type);
174
175 PROCEDURE update_row(
176 p_api_version IN NUMBER,
177 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
178 x_return_status OUT NOCOPY VARCHAR2,
179 x_msg_count OUT NOCOPY NUMBER,
180 x_msg_data OUT NOCOPY VARCHAR2,
181 p_quav_rec IN quav_rec_type,
182 x_quav_rec OUT NOCOPY quav_rec_type);
183
184 PROCEDURE update_row(
185 p_api_version IN NUMBER,
186 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
187 x_return_status OUT NOCOPY VARCHAR2,
188 x_msg_count OUT NOCOPY NUMBER,
189 x_msg_data OUT NOCOPY VARCHAR2,
190 p_quav_tbl IN quav_tbl_type,
191 x_quav_tbl OUT NOCOPY quav_tbl_type);
192
193 PROCEDURE delete_row(
194 p_api_version IN NUMBER,
195 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
196 x_return_status OUT NOCOPY VARCHAR2,
197 x_msg_count OUT NOCOPY NUMBER,
198 x_msg_data OUT NOCOPY VARCHAR2,
199 p_quav_rec IN quav_rec_type);
200
201 PROCEDURE delete_row(
202 p_api_version IN NUMBER,
203 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
204 x_return_status OUT NOCOPY VARCHAR2,
205 x_msg_count OUT NOCOPY NUMBER,
206 x_msg_data OUT NOCOPY VARCHAR2,
207 p_quav_tbl IN quav_tbl_type);
208
209 PROCEDURE validate_row(
210 p_api_version IN NUMBER,
211 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
212 x_return_status OUT NOCOPY VARCHAR2,
213 x_msg_count OUT NOCOPY NUMBER,
214 x_msg_data OUT NOCOPY VARCHAR2,
215 p_quav_rec IN quav_rec_type);
216
217 PROCEDURE validate_row(
218 p_api_version IN NUMBER,
219 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
220 x_return_status OUT NOCOPY VARCHAR2,
221 x_msg_count OUT NOCOPY NUMBER,
222 x_msg_data OUT NOCOPY VARCHAR2,
223 p_quav_tbl IN quav_tbl_type);
224
225 END OKS_QUA_PVT;