[Home] [Help]
PACKAGE: APPS.OKL_SVF_PVT
Source
4 ---------------------------------------------------------------------------
1 Package Okl_Svf_Pvt AUTHID CURRENT_USER AS
2 /* $Header: OKLSSVFS.pls 120.2 2006/07/31 13:11:41 varangan noship $ */
3
5 -- GLOBAL DATASTRUCTURES
6 ---------------------------------------------------------------------------
7 TYPE svf_rec_type IS RECORD (
8 id NUMBER := Okl_Api.G_MISS_NUM,
9 srv_code OKL_SERVICE_FEES_B.SRV_CODE%TYPE := Okl_Api.G_MISS_CHAR,
10 object_version_number NUMBER := Okl_Api.G_MISS_NUM,
11 amount NUMBER := Okl_Api.G_MISS_NUM,
12 start_date OKL_SERVICE_FEES_B.START_DATE%TYPE := Okl_Api.G_MISS_DATE,
13 end_date OKL_SERVICE_FEES_B.END_DATE%TYPE := Okl_Api.G_MISS_DATE,
14 organization_id NUMBER := Okl_Api.G_MISS_NUM,
15 attribute_category OKL_SERVICE_FEES_B.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
16 attribute1 OKL_SERVICE_FEES_B.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
17 attribute2 OKL_SERVICE_FEES_B.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
21 attribute6 OKL_SERVICE_FEES_B.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
18 attribute3 OKL_SERVICE_FEES_B.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
19 attribute4 OKL_SERVICE_FEES_B.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
20 attribute5 OKL_SERVICE_FEES_B.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
22 attribute7 OKL_SERVICE_FEES_B.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
23 attribute8 OKL_SERVICE_FEES_B.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
24 attribute9 OKL_SERVICE_FEES_B.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
25 attribute10 OKL_SERVICE_FEES_B.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
26 attribute11 OKL_SERVICE_FEES_B.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
27 attribute12 OKL_SERVICE_FEES_B.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
28 attribute13 OKL_SERVICE_FEES_B.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
29 attribute14 OKL_SERVICE_FEES_B.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
30 attribute15 OKL_SERVICE_FEES_B.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
31 created_by NUMBER := Okl_Api.G_MISS_NUM,
32 creation_date OKL_SERVICE_FEES_B.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
33 last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
34 last_update_date OKL_SERVICE_FEES_B.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
35 last_update_login NUMBER := Okl_Api.G_MISS_NUM,
36 org_id NUMBER := Okl_Api.G_MISS_NUM);
37 g_miss_svf_rec svf_rec_type;
38 TYPE svf_tbl_type IS TABLE OF svf_rec_type
39 INDEX BY BINARY_INTEGER;
40 TYPE okl_service_fees_tl_rec_type IS RECORD (
41 id NUMBER := Okl_Api.G_MISS_NUM,
42 LANGUAGE OKL_SERVICE_FEES_TL.LANGUAGE%TYPE := Okl_Api.G_MISS_CHAR,
43 source_lang OKL_SERVICE_FEES_TL.SOURCE_LANG%TYPE := Okl_Api.G_MISS_CHAR,
44 sfwt_flag OKL_SERVICE_FEES_TL.SFWT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
45 name OKL_SERVICE_FEES_TL.NAME%TYPE := Okl_Api.G_MISS_CHAR,
46 description OKL_SERVICE_FEES_TL.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
47 created_by NUMBER := Okl_Api.G_MISS_NUM,
48 creation_date OKL_SERVICE_FEES_TL.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
49 last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
50 last_update_date OKL_SERVICE_FEES_TL.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
51 last_update_login NUMBER := Okl_Api.G_MISS_NUM);
52 g_miss_okl_service_fees_tl_rec okl_service_fees_tl_rec_type;
53 TYPE okl_service_fees_tl_tbl_type IS TABLE OF okl_service_fees_tl_rec_type
54 INDEX BY BINARY_INTEGER;
55 TYPE svfv_rec_type IS RECORD (
56 id NUMBER := Okl_Api.G_MISS_NUM,
57 object_version_number NUMBER := Okl_Api.G_MISS_NUM,
58 sfwt_flag OKL_SERVICE_FEES_V.SFWT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
59 srv_code OKL_SERVICE_FEES_V.SRV_CODE%TYPE := Okl_Api.G_MISS_CHAR,
60 name OKL_SERVICE_FEES_V.NAME%TYPE := Okl_Api.G_MISS_CHAR,
61 description OKL_SERVICE_FEES_V.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
62 amount NUMBER := Okl_Api.G_MISS_NUM,
63 start_date OKL_SERVICE_FEES_V.START_DATE%TYPE := Okl_Api.G_MISS_DATE,
64 end_date OKL_SERVICE_FEES_V.END_DATE%TYPE := Okl_Api.G_MISS_DATE,
65 organization_id NUMBER := Okl_Api.G_MISS_NUM,
66 attribute_category OKL_SERVICE_FEES_V.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
67 attribute1 OKL_SERVICE_FEES_V.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
68 attribute2 OKL_SERVICE_FEES_V.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
69 attribute3 OKL_SERVICE_FEES_V.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
70 attribute4 OKL_SERVICE_FEES_V.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
71 attribute5 OKL_SERVICE_FEES_V.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
72 attribute6 OKL_SERVICE_FEES_V.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
73 attribute7 OKL_SERVICE_FEES_V.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
74 attribute8 OKL_SERVICE_FEES_V.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
75 attribute9 OKL_SERVICE_FEES_V.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
76 attribute10 OKL_SERVICE_FEES_V.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
77 attribute11 OKL_SERVICE_FEES_V.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
78 attribute12 OKL_SERVICE_FEES_V.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
79 attribute13 OKL_SERVICE_FEES_V.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
80 attribute14 OKL_SERVICE_FEES_V.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
81 attribute15 OKL_SERVICE_FEES_V.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
82 created_by NUMBER := Okl_Api.G_MISS_NUM,
83 creation_date OKL_SERVICE_FEES_V.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
84 last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
85 last_update_date OKL_SERVICE_FEES_V.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
86 last_update_login NUMBER := Okl_Api.G_MISS_NUM);
87 g_miss_svfv_rec svfv_rec_type;
88 TYPE svfv_tbl_type IS TABLE OF svfv_rec_type
89 INDEX BY BINARY_INTEGER;
90 ---------------------------------------------------------------------------
91 -- GLOBAL MESSAGE CONSTANTS
95 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_UNABLE_TO_RESERVE_REC;
92 ---------------------------------------------------------------------------
93
94 G_FND_APP CONSTANT VARCHAR2(200) := Okl_Api.G_FND_APP;
96 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_DELETED;
97 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_CHANGED;
98 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_RECORD_LOGICALLY_DELETED;
99 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := 'OKL_REQUIRED_VALUE';
100 G_INVALID_VALUE CONSTANT VARCHAR2(200) := 'OKL_INVALID_VALUE';
101 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := 'COL_NAME';
102 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := 'PARENT_TABLE';
103 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := 'CHILD_TABLE';
104 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
105 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
106 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
107 G_FND_LOOKUP_SERVICE_FEE_TYPE CONSTANT VARCHAR2(200) := 'SERVICE_FEES';
108 G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKL_NO_PARENT_RECORD';
109 G_OKL_SERVICE_FEES CONSTANT VARCHAR2(200) := 'OKL_SERVICE_FEES';
110 G_OKL_AMOUNT_GREATER_THAN_ZERO CONSTANT VARCHAR2(200) := 'OKL_AMOUNT_GREATER_THAN_ZERO';
111 G_OKL_INVALID_END_DATE CONSTANT VARCHAR2(200) := 'OKL_INVALID_END_DATE';
112 G_OKL_DUPLICATE_SERVICE_FEE CONSTANT VARCHAR2(200) := 'OKL_DUPLICATE_SERVICE_FEE';
113 G_OKL_START_DATE CONSTANT VARCHAR2(200) := 'OKL_START_DATE';
114
115 ---------------------------------------------------------------------------
116 -- GLOBAL VARIABLES
117 ---------------------------------------------------------------------------
118 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_SVF_PVT';
119 G_APP_NAME CONSTANT VARCHAR2(3) := Okl_Api.G_APP_NAME;
120
121 --------------------------------------------------------------------------
122 -- GLOBAL EXCEPTION
123 ---------------------------------------------------------------------------
124 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
125
126 ---------------------------------------------------------------------------
127 -- Procedures and Functions
128 ---------------------------------------------------------------------------
129
130 PROCEDURE qc;
131 PROCEDURE change_version;
132 PROCEDURE api_copy;
133 PROCEDURE add_language;
134 PROCEDURE insert_row(
135 p_api_version IN NUMBER,
136 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
137 x_return_status OUT NOCOPY VARCHAR2,
138 x_msg_count OUT NOCOPY NUMBER,
139 x_msg_data OUT NOCOPY VARCHAR2,
140 p_svfv_rec IN svfv_rec_type,
141 x_svfv_rec OUT NOCOPY svfv_rec_type);
142
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_svfv_tbl IN svfv_tbl_type,
150 x_svfv_tbl OUT NOCOPY svfv_tbl_type);
151
152 PROCEDURE lock_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_svfv_rec IN svfv_rec_type);
159
160 PROCEDURE lock_row(
161 p_api_version IN NUMBER,
162 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
163 x_return_status OUT NOCOPY VARCHAR2,
164 x_msg_count OUT NOCOPY NUMBER,
165 x_msg_data OUT NOCOPY VARCHAR2,
166 p_svfv_tbl IN svfv_tbl_type);
167
168 PROCEDURE update_row(
169 p_api_version IN NUMBER,
170 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
171 x_return_status OUT NOCOPY VARCHAR2,
172 x_msg_count OUT NOCOPY NUMBER,
173 x_msg_data OUT NOCOPY VARCHAR2,
174 p_svfv_rec IN svfv_rec_type,
175 x_svfv_rec OUT NOCOPY svfv_rec_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_svfv_tbl IN svfv_tbl_type,
184 x_svfv_tbl OUT NOCOPY svfv_tbl_type);
185
186 PROCEDURE delete_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_svfv_rec IN svfv_rec_type);
193
194 PROCEDURE delete_row(
195 p_api_version IN NUMBER,
196 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
197 x_return_status OUT NOCOPY VARCHAR2,
198 x_msg_count OUT NOCOPY NUMBER,
199 x_msg_data OUT NOCOPY VARCHAR2,
200 p_svfv_tbl IN svfv_tbl_type);
201
202 PROCEDURE validate_row(
203 p_api_version IN NUMBER,
204 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
205 x_return_status OUT NOCOPY VARCHAR2,
206 x_msg_count OUT NOCOPY NUMBER,
207 x_msg_data OUT NOCOPY VARCHAR2,
208 p_svfv_rec IN svfv_rec_type);
209
210 PROCEDURE validate_row(
211 p_api_version IN NUMBER,
212 p_init_msg_list IN VARCHAR2 DEFAULT Okl_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_svfv_tbl IN svfv_tbl_type);
217
218 END Okl_Svf_Pvt;