[Home] [Help]
PACKAGE: APPS.OKL_SIY_PVT
Source
1 PACKAGE OKL_SIY_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLSSIYS.pls 115.4 2002/07/22 23:17:43 mvasudev noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE siy_rec_type IS RECORD (
7 id NUMBER := OKC_API.G_MISS_NUM,
8 object_version_number NUMBER := OKC_API.G_MISS_NUM,
9 yield_name OKL_SIF_YIELDS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
10 sif_id NUMBER := OKC_API.G_MISS_NUM,
11 method OKL_SIF_YIELDS.METHOD%TYPE := OKC_API.G_MISS_CHAR,
12 array_type OKL_SIF_YIELDS.ARRAY_TYPE%TYPE := OKC_API.G_MISS_CHAR,
13 roe_type OKL_SIF_YIELDS.ROE_TYPE%TYPE := OKC_API.G_MISS_CHAR,
14 roe_base OKL_SIF_YIELDS.ROE_BASE%TYPE := OKC_API.G_MISS_CHAR,
15 compounded_method OKL_SIF_YIELDS.COMPOUNDED_METHOD%TYPE := OKC_API.G_MISS_CHAR,
16 target_value NUMBER := OKC_API.G_MISS_NUM,
17 index_number NUMBER := OKC_API.G_MISS_NUM,
18 nominal_yn OKL_SIF_YIELDS.NOMINAL_YN%TYPE := OKC_API.G_MISS_CHAR,
19 -- 04/29/2002, mvasudev
20 -- added for "Restructure" requirements
21 pre_tax_yn OKL_SIF_YIELDS.PRE_TAX_YN%TYPE := OKC_API.G_MISS_CHAR,
22 -- mvasudev, 06/26/2002
23 siy_type OKL_SIF_YIELDS.siy_type%TYPE := OKC_API.G_MISS_CHAR,
24 stream_interface_attribute01 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE01%TYPE := OKC_API.G_MISS_CHAR,
25 stream_interface_attribute02 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE02%TYPE := OKC_API.G_MISS_CHAR,
26 stream_interface_attribute03 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE03%TYPE := OKC_API.G_MISS_CHAR,
27 stream_interface_attribute04 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE04%TYPE := OKC_API.G_MISS_CHAR,
28 stream_interface_attribute05 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE05%TYPE := OKC_API.G_MISS_CHAR,
29 stream_interface_attribute06 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE06%TYPE := OKC_API.G_MISS_CHAR,
30 stream_interface_attribute07 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE07%TYPE := OKC_API.G_MISS_CHAR,
31 stream_interface_attribute08 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE08%TYPE := OKC_API.G_MISS_CHAR,
32 stream_interface_attribute09 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE09%TYPE := OKC_API.G_MISS_CHAR,
33 stream_interface_attribute10 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
34 stream_interface_attribute11 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
35 stream_interface_attribute12 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
36 stream_interface_attribute13 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
37 stream_interface_attribute14 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
38 stream_interface_attribute15 OKL_SIF_YIELDS.STREAM_INTERFACE_ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
39 created_by NUMBER := OKC_API.G_MISS_NUM,
40 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
41 creation_date OKL_SIF_YIELDS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
42 last_update_date OKL_SIF_YIELDS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
43 last_update_login NUMBER := OKC_API.G_MISS_NUM);
44 g_miss_siy_rec siy_rec_type;
45 TYPE siy_tbl_type IS TABLE OF siy_rec_type
46 INDEX BY BINARY_INTEGER;
47 TYPE siyv_rec_type IS RECORD (
48 id NUMBER := OKC_API.G_MISS_NUM,
49 object_version_number NUMBER := OKC_API.G_MISS_NUM,
50 yield_name OKL_SIF_YIELDS_V.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
51 sif_id NUMBER := OKC_API.G_MISS_NUM,
52 method OKL_SIF_YIELDS_V.METHOD%TYPE := OKC_API.G_MISS_CHAR,
53 array_type OKL_SIF_YIELDS_V.ARRAY_TYPE%TYPE := OKC_API.G_MISS_CHAR,
54 roe_type OKL_SIF_YIELDS_V.ROE_TYPE%TYPE := OKC_API.G_MISS_CHAR,
55 roe_base OKL_SIF_YIELDS_V.ROE_BASE%TYPE := OKC_API.G_MISS_CHAR,
56 compounded_method OKL_SIF_YIELDS_V.COMPOUNDED_METHOD%TYPE := OKC_API.G_MISS_CHAR,
57 target_value NUMBER := OKC_API.G_MISS_NUM,
58 index_number NUMBER := OKC_API.G_MISS_NUM,
59 nominal_yn OKL_SIF_YIELDS_V.NOMINAL_YN%TYPE := OKC_API.G_MISS_CHAR,
60 -- 04/29/2002, mvasudev
61 -- added for "Restructure" requirements
62 pre_tax_yn OKL_SIF_YIELDS_V.PRE_TAX_YN%TYPE := OKC_API.G_MISS_CHAR,
63 -- mvasudev, 06/26/2002
64 siy_type OKL_SIF_YIELDS_V.siy_type%TYPE := OKC_API.G_MISS_CHAR,
65 stream_interface_attribute01 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE01%TYPE := OKC_API.G_MISS_CHAR,
66 stream_interface_attribute02 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE02%TYPE := OKC_API.G_MISS_CHAR,
67 stream_interface_attribute03 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE03%TYPE := OKC_API.G_MISS_CHAR,
68 stream_interface_attribute04 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE04%TYPE := OKC_API.G_MISS_CHAR,
69 stream_interface_attribute05 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE05%TYPE := OKC_API.G_MISS_CHAR,
70 stream_interface_attribute06 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE06%TYPE := OKC_API.G_MISS_CHAR,
71 stream_interface_attribute07 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE07%TYPE := OKC_API.G_MISS_CHAR,
72 stream_interface_attribute08 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE08%TYPE := OKC_API.G_MISS_CHAR,
73 stream_interface_attribute09 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE09%TYPE := OKC_API.G_MISS_CHAR,
74 stream_interface_attribute10 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
75 stream_interface_attribute11 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
76 stream_interface_attribute12 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
77 stream_interface_attribute13 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
78 stream_interface_attribute14 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
79 stream_interface_attribute15 OKL_SIF_YIELDS_V.STREAM_INTERFACE_ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
80 created_by NUMBER := OKC_API.G_MISS_NUM,
81 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
82 creation_date OKL_SIF_YIELDS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
83 last_update_date OKL_SIF_YIELDS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
84 last_update_login NUMBER := OKC_API.G_MISS_NUM);
85 g_miss_siyv_rec siyv_rec_type;
86 TYPE siyv_tbl_type IS TABLE OF siyv_rec_type
87 INDEX BY BINARY_INTEGER;
88 ---------------------------------------------------------------------------
89 -- GLOBAL MESSAGE CONSTANTS
90 ---------------------------------------------------------------------------
91 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
92 G_OKC_APP CONSTANT VARCHAR2(200) := OKC_API.G_APP_NAME;
93 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
94 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
95 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
96 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
97 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
98 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
99 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
100 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
101 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
102 ---------------------------------------------------------------------------
103 -- GLOBAL VARIABLES
104 ---------------------------------------------------------------------------
105 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_SIY_PVT';
106 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
107
108 -- START CHANGE : mvasudev -- 12/28/2001
109 G_OKL_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLERRM';
110 G_OKL_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLCODE';
111 G_OKL_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
112 G_OKL_UNQS CONSTANT VARCHAR2(200) := 'OKL_SIY_NOT_UNIQUE';
113
114 -- 06/24/2002 , mvasudev, sno
115 G_SIY_TYPE_YIELD CONSTANT VARCHAR2(200) := 'YLD';
116 G_SIY_TYPE_INTEREST_RATE CONSTANT VARCHAR2(200) := 'INT';
117 -- end, mvasudev -- 04/23/2003
118
119 -- Added Exception for Halt_validation
120 --------------------------------------------------------------------------------
121 -- ERRORS AND EXCEPTIONS
122 --------------------------------------------------------------------------------
123 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
124 -- END change : mvasudev
125
126 ---------------------------------------------------------------------------
127 -- Procedures and Functions
128 ---------------------------------------------------------------------------
129
130 PROCEDURE qc;
131 PROCEDURE change_version;
132 PROCEDURE api_copy;
133 PROCEDURE insert_row(
134 p_api_version IN NUMBER,
135 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_siyv_rec IN siyv_rec_type,
140 x_siyv_rec OUT NOCOPY siyv_rec_type);
141
142 PROCEDURE insert_row(
143 p_api_version IN NUMBER,
144 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_siyv_tbl IN siyv_tbl_type,
149 x_siyv_tbl OUT NOCOPY siyv_tbl_type);
150
151 PROCEDURE lock_row(
152 p_api_version IN NUMBER,
153 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
154 x_return_status OUT NOCOPY VARCHAR2,
155 x_msg_count OUT NOCOPY NUMBER,
156 x_msg_data OUT NOCOPY VARCHAR2,
157 p_siyv_rec IN siyv_rec_type);
158
159 PROCEDURE lock_row(
160 p_api_version IN NUMBER,
161 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
162 x_return_status OUT NOCOPY VARCHAR2,
163 x_msg_count OUT NOCOPY NUMBER,
164 x_msg_data OUT NOCOPY VARCHAR2,
165 p_siyv_tbl IN siyv_tbl_type);
166
167 PROCEDURE update_row(
168 p_api_version IN NUMBER,
169 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_siyv_rec IN siyv_rec_type,
174 x_siyv_rec OUT NOCOPY siyv_rec_type);
175
176 PROCEDURE update_row(
177 p_api_version IN NUMBER,
178 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_siyv_tbl IN siyv_tbl_type,
183 x_siyv_tbl OUT NOCOPY siyv_tbl_type);
184
185 PROCEDURE delete_row(
186 p_api_version IN NUMBER,
187 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
188 x_return_status OUT NOCOPY VARCHAR2,
189 x_msg_count OUT NOCOPY NUMBER,
190 x_msg_data OUT NOCOPY VARCHAR2,
191 p_siyv_rec IN siyv_rec_type);
192
193 PROCEDURE delete_row(
194 p_api_version IN NUMBER,
195 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
196 x_return_status OUT NOCOPY VARCHAR2,
197 x_msg_count OUT NOCOPY NUMBER,
198 x_msg_data OUT NOCOPY VARCHAR2,
199 p_siyv_tbl IN siyv_tbl_type);
200
201 PROCEDURE validate_row(
202 p_api_version IN NUMBER,
203 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
204 x_return_status OUT NOCOPY VARCHAR2,
205 x_msg_count OUT NOCOPY NUMBER,
206 x_msg_data OUT NOCOPY VARCHAR2,
207 p_siyv_rec IN siyv_rec_type);
208
209 PROCEDURE validate_row(
210 p_api_version IN NUMBER,
211 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
212 x_return_status OUT NOCOPY VARCHAR2,
213 x_msg_count OUT NOCOPY NUMBER,
214 x_msg_data OUT NOCOPY VARCHAR2,
215 p_siyv_tbl IN siyv_tbl_type);
216
217 END OKL_SIY_PVT;