[Home] [Help]
PACKAGE: APPS.OKL_SRS_PVT
Source
1 Package OKL_SRS_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLSSRSS.pls 115.3 2003/05/12 23:39:33 bakuchib noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE srs_rec_type IS RECORD (
7 id NUMBER ,
8 stream_type_name OKL_SIF_RET_STRMS.STREAM_TYPE_NAME%TYPE ,
9 index_number NUMBER ,
10 activity_type OKL_SIF_RET_STRMS.ACTIVITY_TYPE%TYPE ,
11 sequence_number NUMBER ,
12 sre_date OKL_SIF_RET_STRMS.SRE_DATE%TYPE ,
13 amount NUMBER ,
14 sir_id NUMBER ,
15 stream_interface_attribute01 OKL_SIF_RET_STRMS.STREAM_INTERFACE_ATTRIBUTE01%TYPE ,
16 stream_interface_attribute02 OKL_SIF_RET_STRMS.STREAM_INTERFACE_ATTRIBUTE02%TYPE ,
17 stream_interface_attribute03 OKL_SIF_RET_STRMS.STREAM_INTERFACE_ATTRIBUTE03%TYPE ,
18 stream_interface_attribute04 OKL_SIF_RET_STRMS.STREAM_INTERFACE_ATTRIBUTE04%TYPE ,
19 stream_interface_attribute05 OKL_SIF_RET_STRMS.STREAM_INTERFACE_ATTRIBUTE05%TYPE ,
20 stream_interface_attribute06 OKL_SIF_RET_STRMS.STREAM_INTERFACE_ATTRIBUTE06%TYPE ,
21 stream_interface_attribute07 OKL_SIF_RET_STRMS.STREAM_INTERFACE_ATTRIBUTE07%TYPE ,
22 stream_interface_attribute08 OKL_SIF_RET_STRMS.STREAM_INTERFACE_ATTRIBUTE08%TYPE ,
23 stream_interface_attribute09 OKL_SIF_RET_STRMS.STREAM_INTERFACE_ATTRIBUTE09%TYPE ,
24 stream_interface_attribute10 OKL_SIF_RET_STRMS.STREAM_INTERFACE_ATTRIBUTE10%TYPE ,
25 stream_interface_attribute11 OKL_SIF_RET_STRMS.STREAM_INTERFACE_ATTRIBUTE11%TYPE ,
26 stream_interface_attribute12 OKL_SIF_RET_STRMS.STREAM_INTERFACE_ATTRIBUTE12%TYPE ,
27 stream_interface_attribute13 OKL_SIF_RET_STRMS.STREAM_INTERFACE_ATTRIBUTE13%TYPE ,
28 stream_interface_attribute14 OKL_SIF_RET_STRMS.STREAM_INTERFACE_ATTRIBUTE14%TYPE ,
29 stream_interface_attribute15 OKL_SIF_RET_STRMS.STREAM_INTERFACE_ATTRIBUTE15%TYPE ,
30 object_version_number NUMBER ,
31 created_by NUMBER ,
32 last_updated_by NUMBER ,
33 creation_date OKL_SIF_RET_STRMS.CREATION_DATE%TYPE ,
34 last_update_date OKL_SIF_RET_STRMS.LAST_UPDATE_DATE%TYPE ,
35 last_update_login NUMBER );
36 g_miss_srs_rec srs_rec_type;
37 TYPE srs_tbl_type IS TABLE OF srs_rec_type
38 INDEX BY BINARY_INTEGER;
39 TYPE srsv_rec_type IS RECORD (
40 id NUMBER ,
41 stream_type_name OKL_SIF_RET_STRMS_V.STREAM_TYPE_NAME%TYPE ,
42 index_number NUMBER ,
43 activity_type OKL_SIF_RET_STRMS_V.ACTIVITY_TYPE%TYPE ,
44 sequence_number NUMBER ,
45 sre_date OKL_SIF_RET_STRMS_V.SRE_DATE%TYPE ,
46 amount NUMBER ,
47 sir_id NUMBER ,
48 stream_interface_attribute01 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE01%TYPE ,
49 stream_interface_attribute02 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE02%TYPE ,
50 stream_interface_attribute03 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE03%TYPE ,
51 stream_interface_attribute04 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE04%TYPE ,
52 stream_interface_attribute05 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE05%TYPE ,
53 stream_interface_attribute06 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE06%TYPE ,
54 stream_interface_attribute07 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE07%TYPE ,
55 stream_interface_attribute08 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE08%TYPE ,
56 stream_interface_attribute09 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE09%TYPE ,
57 stream_interface_attribute10 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE10%TYPE ,
58 stream_interface_attribute11 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE11%TYPE ,
59 stream_interface_attribute12 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE12%TYPE ,
60 stream_interface_attribute13 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE13%TYPE ,
61 stream_interface_attribute14 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE14%TYPE ,
62 stream_interface_attribute15 OKL_SIF_RET_STRMS_V.STREAM_INTERFACE_ATTRIBUTE15%TYPE ,
63 object_version_number NUMBER ,
64 created_by NUMBER ,
65 last_updated_by NUMBER ,
66
67
68
69
70
71
72
73 creation_date OKL_SIF_RET_STRMS_V.CREATION_DATE%TYPE ,
74 last_update_date OKL_SIF_RET_STRMS_V.LAST_UPDATE_DATE%TYPE ,
75 last_update_login NUMBER );
76 g_miss_srsv_rec srsv_rec_type;
77 TYPE srsv_tbl_type IS TABLE OF srsv_rec_type
78 INDEX BY BINARY_INTEGER;
79 ---------------------------------------------------------------------------
80 -- GLOBAL MESSAGE CONSTANTS
81 ---------------------------------------------------------------------------
82 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
83 G_OKC_APP CONSTANT VARCHAR2(200) := OKC_API.G_APP_NAME;
84 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
85 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
86 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
87 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
88 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
89 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
90 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
91 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
92 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
93
94
95 -- START CHANGE : akjain -- 09/05/2001
96 -- Adding MESSAGE CONSTANTs for 'Unique Key Validation','SQLCode', 'SQLErrM','Unexpected Error'
97 G_OKL_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) :='OKL_CONTRACTS_UNEXPECTED_ERROR';
98 G_OKL_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLERRM';
99 G_OKL_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLCODE';
100 G_OKL_UNQS CONSTANT VARCHAR2(200) := 'OKL_SRS_NOT_UNIQUE';
101 -- Added Exception for Halt_validation
102 --------------------------------------------------------------------------------
103 -- ERRORS AND EXCEPTIONS
104 --------------------------------------------------------------------------------
105 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
106 -- END change : akjain
107
108
109
110
111 ---------------------------------------------------------------------------
112 -- GLOBAL VARIABLES
113 ---------------------------------------------------------------------------
114 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_SRS_PVT ';
115 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
116 ---------------------------------------------------------------------------
117 -- Procedures and Functions
118 ---------------------------------------------------------------------------
119
120 PROCEDURE qc;
121 PROCEDURE change_version;
122 PROCEDURE api_copy;
123 PROCEDURE insert_row(
124 p_api_version IN NUMBER,
125 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
126 x_return_status OUT NOCOPY VARCHAR2,
127 x_msg_count OUT NOCOPY NUMBER,
128 x_msg_data OUT NOCOPY VARCHAR2,
129 p_srsv_rec IN srsv_rec_type,
130 x_srsv_rec OUT NOCOPY srsv_rec_type);
131
132 PROCEDURE insert_row(
133 p_api_version IN NUMBER,
134 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
135 x_return_status OUT NOCOPY VARCHAR2,
136 x_msg_count OUT NOCOPY NUMBER,
137 x_msg_data OUT NOCOPY VARCHAR2,
138 p_srsv_tbl IN srsv_tbl_type,
139 x_srsv_tbl OUT NOCOPY srsv_tbl_type);
140
141 PROCEDURE lock_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_srsv_rec IN srsv_rec_type);
148
149 PROCEDURE lock_row(
150 p_api_version IN NUMBER,
151 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_srsv_tbl IN srsv_tbl_type);
156
157 PROCEDURE update_row(
158 p_api_version IN NUMBER,
159 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_srsv_rec IN srsv_rec_type,
164 x_srsv_rec OUT NOCOPY srsv_rec_type);
165
166 PROCEDURE update_row(
167 p_api_version IN NUMBER,
168 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_srsv_tbl IN srsv_tbl_type,
173 x_srsv_tbl OUT NOCOPY srsv_tbl_type);
174
175 PROCEDURE delete_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_srsv_rec IN srsv_rec_type);
182
183 PROCEDURE delete_row(
184 p_api_version IN NUMBER,
185 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_srsv_tbl IN srsv_tbl_type);
190
191 PROCEDURE validate_row(
192 p_api_version IN NUMBER,
193 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_srsv_rec IN srsv_rec_type);
198
199 PROCEDURE validate_row(
200 p_api_version IN NUMBER,
201 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_srsv_tbl IN srsv_tbl_type);
206
207 --BAKUCHIB Bug#2807737 start
208 PROCEDURE insert_row_upg(p_srsv_tbl srsv_tbl_type);
209
210 PROCEDURE insert_row_per(
211 p_api_version IN NUMBER,
212 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
213 x_return_status OUT NOCOPY VARCHAR2,
214 x_msg_count OUT NOCOPY NUMBER,
215 x_msg_data OUT NOCOPY VARCHAR2,
216 p_srsv_rec IN srsv_rec_type,
217 x_srsv_rec OUT NOCOPY srsv_rec_type);
218 --BAKUCHIB Bug#2807737 End
219
220 END OKL_SRS_PVT ;