[Home] [Help]
PACKAGE: APPS.OKL_QTY_PVT
Source
1 PACKAGE Okl_Qty_Pvt AUTHID CURRENT_USER AS
2 /* $Header: OKLSQTYS.pls 115.1 2002/02/05 12:19:28 pkm ship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE qty_rec_type IS RECORD (
7 id NUMBER := okl_api.G_MISS_NUM,
8 srd_id NUMBER := okl_api.G_MISS_NUM,
9 lrg_lse_id NUMBER := okl_api.G_MISS_NUM,
10 lrg_srd_id NUMBER := okl_api.G_MISS_NUM,
11 rdr_rdf_code OKL_QUESTION_TYPES_B.RDR_RDF_CODE%TYPE := okl_api.G_MISS_CHAR,
12 rgr_rgd_code OKL_QUESTION_TYPES_B.RGR_RGD_CODE%TYPE := okl_api.G_MISS_CHAR,
13 object_version_number NUMBER := okl_api.G_MISS_NUM,
14 attribute_category OKL_QUESTION_TYPES_B.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
15 attribute1 OKL_QUESTION_TYPES_B.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
16 attribute2 OKL_QUESTION_TYPES_B.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
17 attribute3 OKL_QUESTION_TYPES_B.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
18 attribute4 OKL_QUESTION_TYPES_B.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
19 attribute5 OKL_QUESTION_TYPES_B.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
20 attribute6 OKL_QUESTION_TYPES_B.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
21 attribute7 OKL_QUESTION_TYPES_B.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
22 attribute8 OKL_QUESTION_TYPES_B.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
23 attribute9 OKL_QUESTION_TYPES_B.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
24 attribute10 OKL_QUESTION_TYPES_B.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
25 attribute11 OKL_QUESTION_TYPES_B.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
26 attribute12 OKL_QUESTION_TYPES_B.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
27 attribute13 OKL_QUESTION_TYPES_B.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
28 attribute14 OKL_QUESTION_TYPES_B.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
29 attribute15 OKL_QUESTION_TYPES_B.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
30 created_by NUMBER := okl_api.G_MISS_NUM,
31 creation_date OKL_QUESTION_TYPES_B.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
32 last_updated_by NUMBER := okl_api.G_MISS_NUM,
33 last_update_date OKL_QUESTION_TYPES_B.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
34 last_update_login NUMBER := okl_api.G_MISS_NUM);
35 g_miss_qty_rec qty_rec_type;
36 TYPE qty_tbl_type IS TABLE OF qty_rec_type
37 INDEX BY BINARY_INTEGER;
38 TYPE okl_question_types_tl_rec_type IS RECORD (
39 id NUMBER := okl_api.G_MISS_NUM,
40 LANGUAGE OKL_QUESTION_TYPES_TL.LANGUAGE%TYPE := okl_api.G_MISS_CHAR,
41 source_lang OKL_QUESTION_TYPES_TL.SOURCE_LANG%TYPE := okl_api.G_MISS_CHAR,
42 sfwt_flag OKL_QUESTION_TYPES_TL.SFWT_FLAG%TYPE := okl_api.G_MISS_CHAR,
43 name OKL_QUESTION_TYPES_TL.NAME%TYPE := okl_api.G_MISS_CHAR,
44 description OKL_QUESTION_TYPES_TL.DESCRIPTION%TYPE := okl_api.G_MISS_CHAR,
45 created_by NUMBER := okl_api.G_MISS_NUM,
46 creation_date OKL_QUESTION_TYPES_TL.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
47 last_updated_by NUMBER := okl_api.G_MISS_NUM,
48 last_update_date OKL_QUESTION_TYPES_TL.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
49 last_update_login NUMBER := okl_api.G_MISS_NUM);
50 GMissOklQuestionTypesTlRec okl_question_types_tl_rec_type;
51 TYPE okl_question_types_tl_tbl_type IS TABLE OF okl_question_types_tl_rec_type
52 INDEX BY BINARY_INTEGER;
53 TYPE qtyv_rec_type IS RECORD (
54 id NUMBER := okl_api.G_MISS_NUM,
55 object_version_number NUMBER := okl_api.G_MISS_NUM,
56 sfwt_flag OKL_QUESTION_TYPES_V.SFWT_FLAG%TYPE := okl_api.G_MISS_CHAR,
57 rgr_rgd_code OKL_QUESTION_TYPES_V.RGR_RGD_CODE%TYPE := okl_api.G_MISS_CHAR,
58 srd_id NUMBER := okl_api.G_MISS_NUM,
59 lrg_lse_id NUMBER := okl_api.G_MISS_NUM,
60 rdr_rdf_code OKL_QUESTION_TYPES_V.RDR_RDF_CODE%TYPE := okl_api.G_MISS_CHAR,
61 lrg_srd_id NUMBER := okl_api.G_MISS_NUM,
62 name OKL_QUESTION_TYPES_V.NAME%TYPE := okl_api.G_MISS_CHAR,
63 description OKL_QUESTION_TYPES_V.DESCRIPTION%TYPE := okl_api.G_MISS_CHAR,
64 attribute_category OKL_QUESTION_TYPES_V.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
65 attribute1 OKL_QUESTION_TYPES_V.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
66 attribute2 OKL_QUESTION_TYPES_V.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
67 attribute3 OKL_QUESTION_TYPES_V.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
68 attribute4 OKL_QUESTION_TYPES_V.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
69 attribute5 OKL_QUESTION_TYPES_V.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
70 attribute6 OKL_QUESTION_TYPES_V.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
71 attribute7 OKL_QUESTION_TYPES_V.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
72 attribute8 OKL_QUESTION_TYPES_V.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
73 attribute9 OKL_QUESTION_TYPES_V.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
74 attribute10 OKL_QUESTION_TYPES_V.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
75 attribute11 OKL_QUESTION_TYPES_V.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
76 attribute12 OKL_QUESTION_TYPES_V.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
77 attribute13 OKL_QUESTION_TYPES_V.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
78 attribute14 OKL_QUESTION_TYPES_V.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
79 attribute15 OKL_QUESTION_TYPES_V.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
80 created_by NUMBER := okl_api.G_MISS_NUM,
81 creation_date OKL_QUESTION_TYPES_V.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
82 last_updated_by NUMBER := okl_api.G_MISS_NUM,
83 last_update_date OKL_QUESTION_TYPES_V.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
84 last_update_login NUMBER := okl_api.G_MISS_NUM);
85 g_miss_qtyv_rec qtyv_rec_type;
86 TYPE qtyv_tbl_type IS TABLE OF qtyv_rec_type
87 INDEX BY BINARY_INTEGER;
88 ---------------------------------------------------------------------------
89 -- GLOBAL MESSAGE CONSTANTS
90 ---------------------------------------------------------------------------
91 G_FND_APP CONSTANT VARCHAR2(200) := okl_api.G_FND_APP;
92 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := okl_api.G_FORM_UNABLE_TO_RESERVE_REC;
93 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_DELETED;
94 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_CHANGED;
95 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := okl_api.G_RECORD_LOGICALLY_DELETED;
99 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_PARENT_TABLE_TOKEN;
96 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := okl_api.G_REQUIRED_VALUE;
97 G_INVALID_VALUE CONSTANT VARCHAR2(200) := okl_api.G_INVALID_VALUE;
98 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_COL_NAME_TOKEN;
100 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_CHILD_TABLE_TOKEN;
101 ---------------------------------------------------------------------------
102 -- GLOBAL VARIABLES
103 ---------------------------------------------------------------------------
104 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_QTY_PVT';
105 G_APP_NAME CONSTANT VARCHAR2(3) := okl_api.G_APP_NAME;
106
107 /******************ADDED AFTER TAPI, (05/23/2001) ****************/
108 --GLOBAL MESSAGES
109 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
110 G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKL_NO_PARENT_RECORD';
111 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
112 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
113 G_NOT_SAME CONSTANT VARCHAR2(200) := 'OKL_CANNOT_BE_SAME';
114
115
116 --GLOBAL VARIABLES
117 G_VIEW CONSTANT VARCHAR2(30) := 'OKL_QUESTION_TYPES_V';
118 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
119
120 /****************END ADDITION AFTER TAPI, (05/23/2001)**************/
121
122
123 ---------------------------------------------------------------------------
124 -- Procedures and Functions
125 ---------------------------------------------------------------------------
126
127 PROCEDURE qc;
128 PROCEDURE change_version;
129 PROCEDURE api_copy;
130 PROCEDURE add_language;
131 PROCEDURE insert_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_qtyv_rec IN qtyv_rec_type,
138 x_qtyv_rec OUT NOCOPY qtyv_rec_type);
139
140 PROCEDURE insert_row(
141 p_api_version IN NUMBER,
142 p_init_msg_list IN VARCHAR2 DEFAULT okl_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_qtyv_tbl IN qtyv_tbl_type,
147 x_qtyv_tbl OUT NOCOPY qtyv_tbl_type);
148
149 PROCEDURE lock_row(
150 p_api_version IN NUMBER,
151 p_init_msg_list IN VARCHAR2 DEFAULT okl_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_qtyv_rec IN qtyv_rec_type);
156
157 PROCEDURE lock_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_qtyv_tbl IN qtyv_tbl_type);
164
165 PROCEDURE update_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_qtyv_rec IN qtyv_rec_type,
172 x_qtyv_rec OUT NOCOPY qtyv_rec_type);
173
174 PROCEDURE update_row(
175 p_api_version IN NUMBER,
176 p_init_msg_list IN VARCHAR2 DEFAULT okl_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_qtyv_tbl IN qtyv_tbl_type,
181 x_qtyv_tbl OUT NOCOPY qtyv_tbl_type);
182
183 PROCEDURE delete_row(
184 p_api_version IN NUMBER,
185 p_init_msg_list IN VARCHAR2 DEFAULT okl_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_qtyv_rec IN qtyv_rec_type);
190
191 PROCEDURE delete_row(
192 p_api_version IN NUMBER,
193 p_init_msg_list IN VARCHAR2 DEFAULT okl_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_qtyv_tbl IN qtyv_tbl_type);
198
199 PROCEDURE validate_row(
200 p_api_version IN NUMBER,
201 p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
202 x_return_status OUT NOCOPY VARCHAR2,
203 x_msg_count OUT NOCOPY NUMBER,
204 x_msg_data OUT NOCOPY VARCHAR2,
205 p_qtyv_rec IN qtyv_rec_type);
206
207 PROCEDURE validate_row(
208 p_api_version IN NUMBER,
209 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
210 x_return_status OUT NOCOPY VARCHAR2,
211 x_msg_count OUT NOCOPY NUMBER,
212 x_msg_data OUT NOCOPY VARCHAR2,
213 p_qtyv_tbl IN qtyv_tbl_type);
214
215 END Okl_Qty_Pvt;