[Home] [Help]
PACKAGE: APPS.OKL_SST_PVT
Source
1 PACKAGE Okl_Sst_Pvt AUTHID CURRENT_USER AS
2 /* $Header: OKLSSSTS.pls 115.3 2002/04/05 09:56:27 pkm ship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 /* -- history tables not supported -- 04 APR 2002
7 TYPE okl_srch_strm_typs_h_rec_type IS RECORD (
8 id NUMBER := Okl_Api.G_MISS_NUM,
9 major_version NUMBER := Okl_Api.G_MISS_NUM,
10 sty_id NUMBER := Okl_Api.G_MISS_NUM,
11 cah_id NUMBER := Okl_Api.G_MISS_NUM,
12 object_version_number NUMBER := Okl_Api.G_MISS_NUM,
13 add_yn OKL_SRCH_STRM_TYPS_H.ADD_YN%TYPE := Okl_Api.G_MISS_CHAR,
14 attribute_category OKL_SRCH_STRM_TYPS_H.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
15 attribute1 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
16 attribute2 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
17 attribute3 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
18 attribute4 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
19 attribute5 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
20 attribute6 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
21 attribute7 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
22 attribute8 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
23 attribute9 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
24 attribute10 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
25 attribute11 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
26 attribute12 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
27 attribute13 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
28 attribute14 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
29 attribute15 OKL_SRCH_STRM_TYPS_H.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
30 created_by NUMBER := Okl_Api.G_MISS_NUM,
31 creation_date OKL_SRCH_STRM_TYPS_H.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
32 last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
33 last_update_date OKL_SRCH_STRM_TYPS_H.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
34 last_update_login NUMBER := Okl_Api.G_MISS_NUM);
35 GMissOklSrchStrmTypsHRec okl_srch_strm_typs_h_rec_type;
36 TYPE okl_srch_strm_typs_h_tbl_type IS TABLE OF okl_srch_strm_typs_h_rec_type
37 INDEX BY BINARY_INTEGER;
38 */ -- history tables not supported -- 04 APR 2002
39 TYPE sst_rec_type IS RECORD (
40 id NUMBER := Okl_Api.G_MISS_NUM,
41 sty_id NUMBER := Okl_Api.G_MISS_NUM,
42 cah_id NUMBER := Okl_Api.G_MISS_NUM,
43 object_version_number NUMBER := Okl_Api.G_MISS_NUM,
44 add_yn OKL_SRCH_STRM_TYPS.ADD_YN%TYPE := Okl_Api.G_MISS_CHAR,
45 attribute_category OKL_SRCH_STRM_TYPS.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
46 attribute1 OKL_SRCH_STRM_TYPS.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
47 attribute2 OKL_SRCH_STRM_TYPS.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
48 attribute3 OKL_SRCH_STRM_TYPS.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
49 attribute4 OKL_SRCH_STRM_TYPS.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
50 attribute5 OKL_SRCH_STRM_TYPS.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
51 attribute6 OKL_SRCH_STRM_TYPS.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
52 attribute7 OKL_SRCH_STRM_TYPS.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
53 attribute8 OKL_SRCH_STRM_TYPS.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
54 attribute9 OKL_SRCH_STRM_TYPS.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
55 attribute10 OKL_SRCH_STRM_TYPS.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
56 attribute11 OKL_SRCH_STRM_TYPS.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
57 attribute12 OKL_SRCH_STRM_TYPS.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
58 attribute13 OKL_SRCH_STRM_TYPS.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
59 attribute14 OKL_SRCH_STRM_TYPS.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
60 attribute15 OKL_SRCH_STRM_TYPS.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
61 created_by NUMBER := Okl_Api.G_MISS_NUM,
62 creation_date OKL_SRCH_STRM_TYPS.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
63 last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
64 last_update_date OKL_SRCH_STRM_TYPS.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
65 last_update_login NUMBER := Okl_Api.G_MISS_NUM);
66 g_miss_sst_rec sst_rec_type;
67 TYPE sst_tbl_type IS TABLE OF sst_rec_type
68 INDEX BY BINARY_INTEGER;
69 TYPE sstv_rec_type IS RECORD (
70 id NUMBER := Okl_Api.G_MISS_NUM,
71 object_version_number NUMBER := Okl_Api.G_MISS_NUM,
72 sty_id NUMBER := Okl_Api.G_MISS_NUM,
73 cah_id NUMBER := Okl_Api.G_MISS_NUM,
74 add_yn OKL_SRCH_STRM_TYPS_V.ADD_YN%TYPE := Okl_Api.G_MISS_CHAR,
75 attribute_category OKL_SRCH_STRM_TYPS_V.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
76 attribute1 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
77 attribute2 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
78 attribute3 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
79 attribute4 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
80 attribute5 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
81 attribute6 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
82 attribute7 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
83 attribute8 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
84 attribute9 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
85 attribute10 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
86 attribute11 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
87 attribute12 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
88 attribute13 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
89 attribute14 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
90 attribute15 OKL_SRCH_STRM_TYPS_V.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
91 created_by NUMBER := Okl_Api.G_MISS_NUM,
92 creation_date OKL_SRCH_STRM_TYPS_V.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
93 last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
94 last_update_date OKL_SRCH_STRM_TYPS_V.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
95 last_update_login NUMBER := Okl_Api.G_MISS_NUM);
96 g_miss_sstv_rec sstv_rec_type;
97 TYPE sstv_tbl_type IS TABLE OF sstv_rec_type
98 INDEX BY BINARY_INTEGER;
99 ---------------------------------------------------------------------------
100 -- GLOBAL MESSAGE CONSTANTS
101 ---------------------------------------------------------------------------
102 G_FND_APP CONSTANT VARCHAR2(200) := Okl_Api.G_FND_APP;
103 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_UNABLE_TO_RESERVE_REC;
104 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_DELETED;
105 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_CHANGED;
106 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_RECORD_LOGICALLY_DELETED;
107 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_REQUIRED_VALUE;
108 G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_INVALID_VALUE;
109 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_COL_NAME_TOKEN;
110 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_PARENT_TABLE_TOKEN;
111 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_CHILD_TABLE_TOKEN;
112 ---------------------------------------------------------------------------
113 -- GLOBAL VARIABLES
114 ---------------------------------------------------------------------------
115 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_SST_PVT';
116 G_APP_NAME CONSTANT VARCHAR2(3) := Okl_Api.G_APP_NAME;
117 ---------------------------------------------------------------------------
118 -- ADDED AFTER TAPI 04/17/2001
119 ---------------------------------------------------------------------------
120 ---------------------------------------------------------------------------
121 -- GLOBAL MESSAGES
122 ---------------------------------------------------------------------------
123 G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKL_NO_PARENT_RECORD';
124 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
125 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
126 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
127
128 ---------------------------------------------------------------------------
129 -- GLOBAL VARIABLES
130 ---------------------------------------------------------------------------
131 G_VIEW CONSTANT VARCHAR2(30) := 'OKL_TRX_AR_INVOICES_V';
132 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
133 ---------------------------------------------------------------------------
134 -- Procedures and Functions
135 ---------------------------------------------------------------------------
136
137 PROCEDURE qc;
138 PROCEDURE change_version;
139 PROCEDURE api_copy;
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_sstv_rec IN sstv_rec_type,
147 x_sstv_rec OUT NOCOPY sstv_rec_type);
148
149 PROCEDURE insert_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_sstv_tbl IN sstv_tbl_type,
156 x_sstv_tbl OUT NOCOPY sstv_tbl_type);
157
158 PROCEDURE lock_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_sstv_rec IN sstv_rec_type);
165
166 PROCEDURE lock_row(
167 p_api_version IN NUMBER,
168 p_init_msg_list IN VARCHAR2 DEFAULT Okl_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_sstv_tbl IN sstv_tbl_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_sstv_rec IN sstv_rec_type,
181 x_sstv_rec OUT NOCOPY sstv_rec_type);
182
183 PROCEDURE update_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_sstv_tbl IN sstv_tbl_type,
190 x_sstv_tbl OUT NOCOPY sstv_tbl_type);
191
192 PROCEDURE delete_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_sstv_rec IN sstv_rec_type);
199
200 PROCEDURE delete_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_sstv_tbl IN sstv_tbl_type);
207
208 PROCEDURE validate_row(
209 p_api_version IN NUMBER,
210 p_init_msg_list IN VARCHAR2 DEFAULT Okl_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_sstv_rec IN sstv_rec_type);
215
216 PROCEDURE validate_row(
217 p_api_version IN NUMBER,
218 p_init_msg_list IN VARCHAR2 DEFAULT Okl_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_sstv_tbl IN sstv_tbl_type);
223
224 END Okl_Sst_Pvt;