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