[Home] [Help]
PACKAGE: APPS.OKL_STA_PVT
Source
1 PACKAGE Okl_Sta_Pvt AS
2 /* $Header: OKLSSTAS.pls 120.2 2006/07/11 10:28:09 dkagrawa noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 /*
7 TYPE okl_strm_typ_allocs_h_rec_type IS RECORD (
8 id NUMBER := Okl_Api.G_MISS_NUM,
9 major_version NUMBER := Okl_Api.G_MISS_NUM,
10 cat_id NUMBER := Okl_Api.G_MISS_NUM,
11 sty_id NUMBER := Okl_Api.G_MISS_NUM,
12 stream_allc_type OKL_STRM_TYP_ALLOCS_H.STREAM_ALLC_TYPE%TYPE := Okl_Api.G_MISS_CHAR,
13 object_version_number NUMBER := Okl_Api.G_MISS_NUM,
14 sequence_number NUMBER := Okl_Api.G_MISS_NUM,
15 attribute_category OKL_STRM_TYP_ALLOCS_H.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
16 attribute1 OKL_STRM_TYP_ALLOCS_H.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
17 attribute2 OKL_STRM_TYP_ALLOCS_H.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
18 attribute3 OKL_STRM_TYP_ALLOCS_H.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
19 attribute4 OKL_STRM_TYP_ALLOCS_H.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
20 attribute5 OKL_STRM_TYP_ALLOCS_H.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
21 attribute6 OKL_STRM_TYP_ALLOCS_H.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
22 attribute7 OKL_STRM_TYP_ALLOCS_H.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
23 attribute8 OKL_STRM_TYP_ALLOCS_H.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
24 attribute9 OKL_STRM_TYP_ALLOCS_H.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
25 attribute10 OKL_STRM_TYP_ALLOCS_H.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
26 attribute11 OKL_STRM_TYP_ALLOCS_H.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
27 attribute12 OKL_STRM_TYP_ALLOCS_H.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
28 attribute13 OKL_STRM_TYP_ALLOCS_H.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
29 attribute14 OKL_STRM_TYP_ALLOCS_H.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
30 attribute15 OKL_STRM_TYP_ALLOCS_H.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
31 created_by NUMBER := Okl_Api.G_MISS_NUM,
32 creation_date OKL_STRM_TYP_ALLOCS_H.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
33 last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
34 last_update_date OKL_STRM_TYP_ALLOCS_H.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
35 last_update_login NUMBER := Okl_Api.G_MISS_NUM);
36 GMissOklStrmTypAllocsHRec okl_strm_typ_allocs_h_rec_type;
37 TYPE okl_strm_typ_allocs_h_tbl_type IS TABLE OF okl_strm_typ_allocs_h_rec_type
38 INDEX BY BINARY_INTEGER;
39 */
40 TYPE sta_rec_type IS RECORD (
41 id NUMBER := Okl_Api.G_MISS_NUM,
42 cat_id NUMBER := Okl_Api.G_MISS_NUM,
43 sty_id NUMBER := Okl_Api.G_MISS_NUM,
44 stream_allc_type OKL_STRM_TYP_ALLOCS.STREAM_ALLC_TYPE%TYPE := Okl_Api.G_MISS_CHAR,
45 object_version_number NUMBER := Okl_Api.G_MISS_NUM,
46 sequence_number NUMBER := Okl_Api.G_MISS_NUM,
47 attribute_category OKL_STRM_TYP_ALLOCS.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
48 attribute1 OKL_STRM_TYP_ALLOCS.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
49 attribute2 OKL_STRM_TYP_ALLOCS.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
50 attribute3 OKL_STRM_TYP_ALLOCS.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
51 attribute4 OKL_STRM_TYP_ALLOCS.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
52 attribute5 OKL_STRM_TYP_ALLOCS.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
53 attribute6 OKL_STRM_TYP_ALLOCS.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
54 attribute7 OKL_STRM_TYP_ALLOCS.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
55 attribute8 OKL_STRM_TYP_ALLOCS.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
56 attribute9 OKL_STRM_TYP_ALLOCS.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
57 attribute10 OKL_STRM_TYP_ALLOCS.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
58 attribute11 OKL_STRM_TYP_ALLOCS.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
59 attribute12 OKL_STRM_TYP_ALLOCS.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
60 attribute13 OKL_STRM_TYP_ALLOCS.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
61 attribute14 OKL_STRM_TYP_ALLOCS.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
62 attribute15 OKL_STRM_TYP_ALLOCS.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
63 created_by NUMBER := Okl_Api.G_MISS_NUM,
64 creation_date OKL_STRM_TYP_ALLOCS.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
65 last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
66 last_update_date OKL_STRM_TYP_ALLOCS.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
67 last_update_login NUMBER := Okl_Api.G_MISS_NUM);
68 g_miss_sta_rec sta_rec_type;
69 TYPE sta_tbl_type IS TABLE OF sta_rec_type
70 INDEX BY BINARY_INTEGER;
71 TYPE stav_rec_type IS RECORD (
72 id NUMBER := Okl_Api.G_MISS_NUM,
73 object_version_number NUMBER := Okl_Api.G_MISS_NUM,
74 sty_id NUMBER := Okl_Api.G_MISS_NUM,
75 cat_id NUMBER := Okl_Api.G_MISS_NUM,
76 sequence_number NUMBER := Okl_Api.G_MISS_NUM,
77 attribute_category OKL_STRM_TYP_ALLOCS.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
78 attribute1 OKL_STRM_TYP_ALLOCS.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
79 attribute2 OKL_STRM_TYP_ALLOCS.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
80 attribute3 OKL_STRM_TYP_ALLOCS.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
81 attribute4 OKL_STRM_TYP_ALLOCS.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
82 attribute5 OKL_STRM_TYP_ALLOCS.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
83 attribute6 OKL_STRM_TYP_ALLOCS.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
84 attribute7 OKL_STRM_TYP_ALLOCS.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
85 attribute8 OKL_STRM_TYP_ALLOCS.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
86 attribute9 OKL_STRM_TYP_ALLOCS.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
87 attribute10 OKL_STRM_TYP_ALLOCS.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
88 attribute11 OKL_STRM_TYP_ALLOCS.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
89 attribute12 OKL_STRM_TYP_ALLOCS.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
90 attribute13 OKL_STRM_TYP_ALLOCS.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
91 attribute14 OKL_STRM_TYP_ALLOCS.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
92 attribute15 OKL_STRM_TYP_ALLOCS.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
93 stream_allc_type OKL_STRM_TYP_ALLOCS.STREAM_ALLC_TYPE%TYPE := Okl_Api.G_MISS_CHAR,
94 created_by NUMBER := Okl_Api.G_MISS_NUM,
95 creation_date OKL_STRM_TYP_ALLOCS.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
96 last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
97 last_update_date OKL_STRM_TYP_ALLOCS.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
98 last_update_login NUMBER := Okl_Api.G_MISS_NUM);
99 g_miss_stav_rec stav_rec_type;
100 TYPE stav_tbl_type IS TABLE OF stav_rec_type
101 INDEX BY BINARY_INTEGER;
102 ---------------------------------------------------------------------------
103 -- GLOBAL MESSAGE CONSTANTS
104 ---------------------------------------------------------------------------
105 G_FND_APP CONSTANT VARCHAR2(200) := Okl_Api.G_FND_APP;
106 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_UNABLE_TO_RESERVE_REC;
107 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_DELETED;
108 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_CHANGED;
109 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_RECORD_LOGICALLY_DELETED;
110 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_REQUIRED_VALUE;
111 G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_INVALID_VALUE;
112 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_COL_NAME_TOKEN;
113 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_PARENT_TABLE_TOKEN;
114 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_CHILD_TABLE_TOKEN;
115 ---------------------------------------------------------------------------
116 -- GLOBAL VARIABLES
117 ---------------------------------------------------------------------------
118 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_STA_PVT';
119 G_APP_NAME CONSTANT VARCHAR2(3) := Okl_Api.G_APP_NAME;
120 ---------------------------------------------------------------------------
121 -- ADDED AFTER TAPI 04/17/2001
122 ---------------------------------------------------------------------------
123 ---------------------------------------------------------------------------
124 -- GLOBAL MESSAGES
125 ---------------------------------------------------------------------------
126 G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKL_NO_PARENT_RECORD';
127 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
128 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
129 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
130
131 ---------------------------------------------------------------------------
132 -- GLOBAL VARIABLES
133 ---------------------------------------------------------------------------
134 G_VIEW CONSTANT VARCHAR2(30) := 'OKL_TRX_AR_INVOICES_V';
135 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
136 ---------------------------------------------------------------------------
137 -- Procedures and Functions
138 ---------------------------------------------------------------------------
139
140 PROCEDURE qc;
141 PROCEDURE change_version;
142 PROCEDURE api_copy;
143 PROCEDURE insert_row(
144 p_api_version IN NUMBER,
145 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
146 x_return_status OUT NOCOPY VARCHAR2,
147 x_msg_count OUT NOCOPY NUMBER,
148 x_msg_data OUT NOCOPY VARCHAR2,
149 p_stav_rec IN stav_rec_type,
150 x_stav_rec OUT NOCOPY stav_rec_type);
151
152 PROCEDURE insert_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_stav_tbl IN stav_tbl_type,
159 x_stav_tbl OUT NOCOPY stav_tbl_type);
160
161 PROCEDURE lock_row(
162 p_api_version IN NUMBER,
163 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
164 x_return_status OUT NOCOPY VARCHAR2,
165 x_msg_count OUT NOCOPY NUMBER,
166 x_msg_data OUT NOCOPY VARCHAR2,
167 p_stav_rec IN stav_rec_type);
168
169 PROCEDURE lock_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_stav_tbl IN stav_tbl_type);
176
177 PROCEDURE update_row(
178 p_api_version IN NUMBER,
179 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
180 x_return_status OUT NOCOPY VARCHAR2,
181 x_msg_count OUT NOCOPY NUMBER,
182 x_msg_data OUT NOCOPY VARCHAR2,
183 p_stav_rec IN stav_rec_type,
184 x_stav_rec OUT NOCOPY stav_rec_type);
185
186 PROCEDURE update_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_stav_tbl IN stav_tbl_type,
193 x_stav_tbl OUT NOCOPY stav_tbl_type);
194
195 PROCEDURE delete_row(
196 p_api_version IN NUMBER,
197 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
198 x_return_status OUT NOCOPY VARCHAR2,
199 x_msg_count OUT NOCOPY NUMBER,
200 x_msg_data OUT NOCOPY VARCHAR2,
201 p_stav_rec IN stav_rec_type);
202
203 PROCEDURE delete_row(
204 p_api_version IN NUMBER,
205 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
206 x_return_status OUT NOCOPY VARCHAR2,
207 x_msg_count OUT NOCOPY NUMBER,
208 x_msg_data OUT NOCOPY VARCHAR2,
209 p_stav_tbl IN stav_tbl_type);
210
211 PROCEDURE validate_row(
212 p_api_version IN NUMBER,
213 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
214 x_return_status OUT NOCOPY VARCHAR2,
215 x_msg_count OUT NOCOPY NUMBER,
216 x_msg_data OUT NOCOPY VARCHAR2,
217 p_stav_rec IN stav_rec_type);
218
219 PROCEDURE validate_row(
220 p_api_version IN NUMBER,
221 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
222 x_return_status OUT NOCOPY VARCHAR2,
223 x_msg_count OUT NOCOPY NUMBER,
224 x_msg_data OUT NOCOPY VARCHAR2,
225 p_stav_tbl IN stav_tbl_type);
226
227 END Okl_Sta_Pvt;