[Home] [Help]
PACKAGE: APPS.OKL_STM_PVT
Source
1 PACKAGE Okl_Stm_Pvt AUTHID CURRENT_USER AS
2 /* $Header: OKLSSTMS.pls 120.2 2005/05/30 12:31:52 kthiruva noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE stm_rec_type IS RECORD (
7 id NUMBER ,
8 sty_id NUMBER ,
9 khr_id NUMBER ,
10 kle_id NUMBER ,
11 sgn_code OKL_STREAMS.SGN_CODE%TYPE ,
12 say_code OKL_STREAMS.SAY_CODE%TYPE ,
13 transaction_number OKL_STREAMS.TRANSACTION_NUMBER%TYPE ,
14 active_yn OKL_STREAMS.ACTIVE_YN%TYPE ,
15 object_version_number NUMBER ,
16 created_by NUMBER ,
17 creation_date OKL_STREAMS.CREATION_DATE%TYPE ,
18 last_updated_by NUMBER ,
19 last_update_date OKL_STREAMS.LAST_UPDATE_DATE%TYPE ,
20 date_current OKL_STREAMS.DATE_CURRENT%TYPE ,
21 date_working OKL_STREAMS.DATE_WORKING%TYPE ,
22 date_history OKL_STREAMS.DATE_HISTORY%TYPE ,
23 comments OKL_STREAMS.COMMENTS%TYPE ,
24 program_id NUMBER ,
25 request_id NUMBER ,
26 program_application_id NUMBER ,
27 program_update_date OKL_STREAMS.PROGRAM_UPDATE_DATE%TYPE ,
28 last_update_login NUMBER ,
29 -- mvasudev, Bug#2650599
30 purpose_code OKL_STREAMS.PURPOSE_CODE%TYPE ,
31 --sty_code OKL_STREAMS.STY_CODE%TYPE := OKC_API.G_MISS_CHAR
32 -- end, mvasudev, Bug#2650599
33 --- Changed by Kjinger
34 stm_id NUMBER ,
35 -- Change Ends
36 -- Added by Keerthi for Bug 3166890
37 source_id NUMBER ,
38 source_table OKL_STREAMS.SOURCE_TABLE%TYPE,
39 -- Change Ends
40 -- rgooty : Start
41 trx_id NUMBER,
42 link_hist_stream_id NUMBER
43 -- rgooty : End
44 );
45 g_miss_stm_rec stm_rec_type;
46 TYPE stm_tbl_type IS TABLE OF stm_rec_type
47 INDEX BY BINARY_INTEGER;
48 TYPE stmv_rec_type IS RECORD (
49 id NUMBER ,
50 sty_id NUMBER ,
51 khr_id NUMBER ,
52 kle_id NUMBER ,
53 sgn_code OKL_STREAMS_V.SGN_CODE%TYPE ,
54 say_code OKL_STREAMS_V.SAY_CODE%TYPE ,
55 transaction_number OKL_STREAMS_V.TRANSACTION_NUMBER%TYPE ,
56 active_yn OKL_STREAMS_V.ACTIVE_YN%TYPE ,
57 object_version_number NUMBER ,
58 created_by NUMBER ,
59 creation_date OKL_STREAMS_V.CREATION_DATE%TYPE ,
60 last_updated_by NUMBER ,
61 last_update_date OKL_STREAMS_V.LAST_UPDATE_DATE%TYPE ,
62 date_current OKL_STREAMS_V.DATE_CURRENT%TYPE ,
63 date_working OKL_STREAMS_V.DATE_WORKING%TYPE ,
64 date_history OKL_STREAMS_V.DATE_HISTORY%TYPE ,
65 comments OKL_STREAMS_V.COMMENTS%TYPE ,
66 program_id NUMBER ,
67 request_id NUMBER ,
68 program_application_id NUMBER ,
69 program_update_date OKL_STREAMS_V.PROGRAM_UPDATE_DATE%TYPE ,
70 last_update_login NUMBER ,
71 -- mvasudev, Bug#2650599
72 purpose_code OKL_STREAMS_V.PURPOSE_CODE%TYPE ,
73 --sty_code OKL_STREAMS_V.STY_CODE%TYPE := OKC_API.G_MISS_CHAR
74 -- end, mvasudev, Bug#2650599
75 --- Changed by Kjinger
76 stm_id NUMBER ,
77 --- Change Ends
78 -- Added by Keerthi for Bug 3166890
79 source_id NUMBER ,
80 source_table OKL_STREAMS.SOURCE_TABLE%TYPE,
81 -- rgooty : Start
82 trx_id NUMBER,
83 link_hist_stream_id NUMBER
84 -- rgooty : End
85 );
86 g_miss_stmv_rec stmv_rec_type;
87 TYPE stmv_tbl_type IS TABLE OF stmv_rec_type
88 INDEX BY BINARY_INTEGER;
89 ---------------------------------------------------------------------------
90 -- GLOBAL MESSAGE CONSTANTS
91 ---------------------------------------------------------------------------
92 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
93 G_OKC_APP CONSTANT VARCHAR2(200) := OKC_API.G_APP_NAME;
94 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
95 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
96 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
97 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
98 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
99 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
100 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
101 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
102 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
103
104 G_OKL_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) :='OKL_CONTRACTS_UNEXPECTED_ERROR';
105 G_OKL_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLERRM';
106 G_OKL_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLCODE';
107 G_OKL_UNQS CONSTANT VARCHAR2(200) := 'OKL_STM_NOT_UNIQUE';
108 G_OKL_STM_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKL_STM_NO_PARENT_RECORD';
109 G_OKL_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKL_NO_PARENT_RECORD';
110
111
112 ---------------------------------------------------------------------------
113 -- GLOBAL VARIABLES
114 ---------------------------------------------------------------------------
115 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_STM_PVT';
116 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
117
118
119 ----------------------------------------------------------------------------
120 ----------------- GLOBAL EXCEPTION
121 --------------------------------------------------------
122
123 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
124
125 ---------------------------------------------------------------------------
126 -- Procedures and Functions
127 ---------------------------------------------------------------------------
128
129 PROCEDURE qc;
130 PROCEDURE change_version;
131 PROCEDURE api_copy;
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_stmv_rec IN stmv_rec_type,
139 x_stmv_rec OUT NOCOPY stmv_rec_type);
140
141 PROCEDURE insert_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_stmv_tbl IN stmv_tbl_type,
148 x_stmv_tbl OUT NOCOPY stmv_tbl_type);
149
150 --Added by kthiruva for Streams Performance Improvement
151 --Bug 4346646- Start of Changes
152 PROCEDURE insert_row_perf(
153 p_api_version IN NUMBER,
154 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_stmv_tbl IN stmv_tbl_type,
159 x_stmv_tbl OUT NOCOPY stmv_tbl_type);
160 --Bug 4346646 - End of Changes
161
162 PROCEDURE lock_row(
163 p_api_version IN NUMBER,
164 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
165 x_return_status OUT NOCOPY VARCHAR2,
166 x_msg_count OUT NOCOPY NUMBER,
167 x_msg_data OUT NOCOPY VARCHAR2,
168 p_stmv_rec IN stmv_rec_type);
169
170 PROCEDURE lock_row(
171 p_api_version IN NUMBER,
172 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
173 x_return_status OUT NOCOPY VARCHAR2,
174 x_msg_count OUT NOCOPY NUMBER,
175 x_msg_data OUT NOCOPY VARCHAR2,
176 p_stmv_tbl IN stmv_tbl_type);
177
178 PROCEDURE update_row(
179 p_api_version IN NUMBER,
180 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
181 x_return_status OUT NOCOPY VARCHAR2,
182 x_msg_count OUT NOCOPY NUMBER,
183 x_msg_data OUT NOCOPY VARCHAR2,
184 p_stmv_rec IN stmv_rec_type,
185 x_stmv_rec OUT NOCOPY stmv_rec_type);
186
187 PROCEDURE update_row(
188 p_api_version IN NUMBER,
189 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
190 x_return_status OUT NOCOPY VARCHAR2,
191 x_msg_count OUT NOCOPY NUMBER,
192 x_msg_data OUT NOCOPY VARCHAR2,
193 p_stmv_tbl IN stmv_tbl_type,
194 x_stmv_tbl OUT NOCOPY stmv_tbl_type);
195
196 PROCEDURE delete_row(
197 p_api_version IN NUMBER,
198 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
199 x_return_status OUT NOCOPY VARCHAR2,
200 x_msg_count OUT NOCOPY NUMBER,
201 x_msg_data OUT NOCOPY VARCHAR2,
202 p_stmv_rec IN stmv_rec_type);
203
204 PROCEDURE delete_row(
205 p_api_version IN NUMBER,
206 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
207 x_return_status OUT NOCOPY VARCHAR2,
208 x_msg_count OUT NOCOPY NUMBER,
209 x_msg_data OUT NOCOPY VARCHAR2,
210 p_stmv_tbl IN stmv_tbl_type);
211
212 PROCEDURE validate_row(
213 p_api_version IN NUMBER,
214 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
215 x_return_status OUT NOCOPY VARCHAR2,
216 x_msg_count OUT NOCOPY NUMBER,
217 x_msg_data OUT NOCOPY VARCHAR2,
218 p_stmv_rec IN stmv_rec_type);
219
220 PROCEDURE validate_row(
221 p_api_version IN NUMBER,
222 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
223 x_return_status OUT NOCOPY VARCHAR2,
224 x_msg_count OUT NOCOPY NUMBER,
225 x_msg_data OUT NOCOPY VARCHAR2,
226 p_stmv_tbl IN stmv_tbl_type);
227
228 END Okl_Stm_Pvt;