[Home] [Help]
PACKAGE: APPS.OKL_INR_PVT
Source
1 PACKAGE Okl_Inr_Pvt AUTHID CURRENT_USER AS
2 /* $Header: OKLSINRS.pls 120.1 2005/10/30 04:43:00 appldev noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE inr_rec_type IS RECORD (
7 id NUMBER := Okc_Api.G_MISS_NUM,
8 iac_code OKL_INS_RATES.IAC_CODE%TYPE := Okc_Api.G_MISS_CHAR,
9 ipt_id NUMBER := Okc_Api.G_MISS_NUM,
10 ic_id OKL_INS_RATES.IC_ID%TYPE := Okc_Api.G_MISS_CHAR,
11 coverage_max NUMBER := Okc_Api.G_MISS_NUM,
12 deductible NUMBER := Okc_Api.G_MISS_NUM,
13 object_version_number NUMBER := Okc_Api.G_MISS_NUM,
14 factor_range_start NUMBER := Okc_Api.G_MISS_NUM,
15 insured_rate NUMBER := Okc_Api.G_MISS_NUM,
16 factor_range_end NUMBER := Okc_Api.G_MISS_NUM,
17 date_from OKL_INS_RATES.DATE_FROM%TYPE := Okc_Api.G_MISS_DATE,
18 date_to OKL_INS_RATES.DATE_TO%TYPE := Okc_Api.G_MISS_DATE,
19 insurer_rate NUMBER := Okc_Api.G_MISS_NUM,
20 attribute_category OKL_INS_RATES.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
21 attribute1 OKL_INS_RATES.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
22 attribute2 OKL_INS_RATES.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
23 attribute3 OKL_INS_RATES.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
24 attribute4 OKL_INS_RATES.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
25 attribute5 OKL_INS_RATES.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
26 attribute6 OKL_INS_RATES.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
27 attribute7 OKL_INS_RATES.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
28 attribute8 OKL_INS_RATES.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
29 attribute9 OKL_INS_RATES.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
30 attribute10 OKL_INS_RATES.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
31 attribute11 OKL_INS_RATES.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
32 attribute12 OKL_INS_RATES.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
33 attribute13 OKL_INS_RATES.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
34 attribute14 OKL_INS_RATES.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
35 attribute15 OKL_INS_RATES.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
36 created_by NUMBER := Okc_Api.G_MISS_NUM,
37 creation_date OKL_INS_RATES.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
38 last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
39 last_update_date OKL_INS_RATES.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
40 last_update_login NUMBER := Okc_Api.G_MISS_NUM);
41 g_miss_inr_rec inr_rec_type;
42 TYPE inr_tbl_type IS TABLE OF inr_rec_type
43 INDEX BY BINARY_INTEGER;
44 TYPE inrv_rec_type IS RECORD (
45 id NUMBER := Okc_Api.G_MISS_NUM,
46 object_version_number NUMBER := Okc_Api.G_MISS_NUM,
47 ic_id OKL_INS_RATES.IC_ID%TYPE := Okc_Api.G_MISS_CHAR ,
48 ipt_id NUMBER := Okc_Api.G_MISS_NUM,
49 iac_code OKL_INS_RATES_V.IAC_CODE%TYPE := Okc_Api.G_MISS_CHAR,
50 coverage_max NUMBER := Okc_Api.G_MISS_NUM,
51 deductible NUMBER := Okc_Api.G_MISS_NUM,
52 factor_range_start NUMBER := Okc_Api.G_MISS_NUM,
53 insured_rate NUMBER := Okc_Api.G_MISS_NUM,
54 factor_range_end NUMBER := Okc_Api.G_MISS_NUM,
55 date_from OKL_INS_RATES_V.DATE_FROM%TYPE := Okc_Api.G_MISS_DATE,
56 date_to OKL_INS_RATES_V.DATE_TO%TYPE := Okc_Api.G_MISS_DATE,
57 insurer_rate NUMBER := Okc_Api.G_MISS_NUM,
58 attribute_category OKL_INS_RATES_V.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
59 attribute1 OKL_INS_RATES_V.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
60 attribute2 OKL_INS_RATES_V.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
61 attribute3 OKL_INS_RATES_V.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
62 attribute4 OKL_INS_RATES_V.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
63 attribute5 OKL_INS_RATES_V.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
64 attribute6 OKL_INS_RATES_V.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
65 attribute7 OKL_INS_RATES_V.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
66 attribute8 OKL_INS_RATES_V.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
67 attribute9 OKL_INS_RATES_V.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
68 attribute10 OKL_INS_RATES_V.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
69 attribute11 OKL_INS_RATES_V.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
70 attribute12 OKL_INS_RATES_V.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
71 attribute13 OKL_INS_RATES_V.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
72 attribute14 OKL_INS_RATES_V.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
73 attribute15 OKL_INS_RATES_V.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
74 created_by NUMBER := Okc_Api.G_MISS_NUM,
75 creation_date OKL_INS_RATES_V.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
76 last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
77 last_update_date OKL_INS_RATES_V.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
78 last_update_login NUMBER := Okc_Api.G_MISS_NUM);
79 g_miss_inrv_rec inrv_rec_type;
80 TYPE inrv_tbl_type IS TABLE OF inrv_rec_type
81 INDEX BY BINARY_INTEGER;
82 ---------------------------------------------------------------------------
83 -- GLOBAL MESSAGE CONSTANTS
84 ---------------------------------------------------------------------------
85 G_FND_APP CONSTANT VARCHAR2(200) := Okc_Api.G_FND_APP;
86 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := 'OKL_REQUIRED_VALUE';
87 G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_INVALID_VALUE;
88 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := 'COL_NAME';
89 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := 'PARENT_TABLE';
90 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := 'CHILD_TABLE';
91 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
92 G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKL_NO_PARENT_RECORD';
93 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLERRM';
94 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLCODE';
95 G_POSITIVE_NUMBER CONSTANT VARCHAR2(200) := 'OKL_POSITIVE_NUMBER';
96 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
97 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
98 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
99 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
100
101
102 ---------------------------------------------------------------------------
103 -- GLOBAL VARIABLES
104 ---------------------------------------------------------------------------
105 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_INR_PVT';
106 G_APP_NAME CONSTANT VARCHAR2(3) := 'OKL';
107
108 ---------------------------------------------------------------------------
109 -- GLOBAL EXCEPTION
110 ---------------------------------------------------------------------------
111 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
112 ---------------------------------------------------------------------------
113 -- Procedures and Functions
114 ---------------------------------------------------------------------------
115
116 PROCEDURE qc;
117 PROCEDURE change_version;
118 PROCEDURE api_copy;
119 PROCEDURE insert_row(
120 p_api_version IN NUMBER,
121 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
122 x_return_status OUT NOCOPY VARCHAR2,
123 x_msg_count OUT NOCOPY NUMBER,
124 x_msg_data OUT NOCOPY VARCHAR2,
125 p_inrv_rec IN inrv_rec_type,
126 x_inrv_rec OUT NOCOPY inrv_rec_type);
127
128 PROCEDURE insert_row(
129 p_api_version IN NUMBER,
130 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
131 x_return_status OUT NOCOPY VARCHAR2,
132 x_msg_count OUT NOCOPY NUMBER,
133 x_msg_data OUT NOCOPY VARCHAR2,
134 p_inrv_tbl IN inrv_tbl_type,
135 x_inrv_tbl OUT NOCOPY inrv_tbl_type);
136
137 PROCEDURE lock_row(
138 p_api_version IN NUMBER,
139 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
140 x_return_status OUT NOCOPY VARCHAR2,
141 x_msg_count OUT NOCOPY NUMBER,
142 x_msg_data OUT NOCOPY VARCHAR2,
143 p_inrv_rec IN inrv_rec_type);
144
145 PROCEDURE lock_row(
146 p_api_version IN NUMBER,
147 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
148 x_return_status OUT NOCOPY VARCHAR2,
149 x_msg_count OUT NOCOPY NUMBER,
150 x_msg_data OUT NOCOPY VARCHAR2,
151 p_inrv_tbl IN inrv_tbl_type);
152
153 PROCEDURE update_row(
154 p_api_version IN NUMBER,
155 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
156 x_return_status OUT NOCOPY VARCHAR2,
157 x_msg_count OUT NOCOPY NUMBER,
158 x_msg_data OUT NOCOPY VARCHAR2,
159 p_inrv_rec IN inrv_rec_type,
160 x_inrv_rec OUT NOCOPY inrv_rec_type);
161
162 PROCEDURE update_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_inrv_tbl IN inrv_tbl_type,
169 x_inrv_tbl OUT NOCOPY inrv_tbl_type);
170
171 PROCEDURE delete_row(
172 p_api_version IN NUMBER,
173 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
174 x_return_status OUT NOCOPY VARCHAR2,
175 x_msg_count OUT NOCOPY NUMBER,
176 x_msg_data OUT NOCOPY VARCHAR2,
177 p_inrv_rec IN inrv_rec_type);
178
179 PROCEDURE delete_row(
180 p_api_version IN NUMBER,
181 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
182 x_return_status OUT NOCOPY VARCHAR2,
183 x_msg_count OUT NOCOPY NUMBER,
184 x_msg_data OUT NOCOPY VARCHAR2,
185 p_inrv_tbl IN inrv_tbl_type);
186
187 PROCEDURE validate_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_inrv_rec IN inrv_rec_type);
194
195 PROCEDURE validate_row(
196 p_api_version IN NUMBER,
197 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
198 x_return_status OUT NOCOPY VARCHAR2,
199 x_msg_count OUT NOCOPY NUMBER,
200 x_msg_data OUT NOCOPY VARCHAR2,
201 p_inrv_tbl IN inrv_tbl_type);
202
203 END Okl_Inr_Pvt;