[Home] [Help]
PACKAGE: APPS.CS_COVERAGELEVEL_PVT
Source
1 Package CS_COVERAGELEVEL_PVT AUTHID CURRENT_USER AS
2 /* $Header: csctcles.pls 115.0 99/07/16 08:50:00 porting ship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE CoverageLevel_Rec_Type IS RECORD (
7 coverage_level_id NUMBER := NULL,
8 coverage_level_code CS_CONTRACT_COV_LEVELS.COVERAGE_LEVEL_CODE%TYPE := NULL,
9 coverage_level_value NUMBER := NULL,
10 last_update_date CS_CONTRACT_COV_LEVELS.LAST_UPDATE_DATE%TYPE := NULL,
11 last_updated_by NUMBER := NULL,
12 creation_date CS_CONTRACT_COV_LEVELS.CREATION_DATE%TYPE := NULL,
13 created_by NUMBER := NULL,
14 last_update_login NUMBER := NULL,
15 cp_service_id NUMBER := NULL,
16 attribute1 CS_CONTRACT_COV_LEVELS.ATTRIBUTE1%TYPE := NULL,
17 attribute2 CS_CONTRACT_COV_LEVELS.ATTRIBUTE2%TYPE := NULL,
18 attribute3 CS_CONTRACT_COV_LEVELS.ATTRIBUTE3%TYPE := NULL,
19 attribute4 CS_CONTRACT_COV_LEVELS.ATTRIBUTE4%TYPE := NULL,
20 attribute5 CS_CONTRACT_COV_LEVELS.ATTRIBUTE5%TYPE := NULL,
21 attribute6 CS_CONTRACT_COV_LEVELS.ATTRIBUTE6%TYPE := NULL,
22 attribute7 CS_CONTRACT_COV_LEVELS.ATTRIBUTE7%TYPE := NULL,
23 attribute8 CS_CONTRACT_COV_LEVELS.ATTRIBUTE8%TYPE := NULL,
24 attribute9 CS_CONTRACT_COV_LEVELS.ATTRIBUTE9%TYPE := NULL,
25 attribute10 CS_CONTRACT_COV_LEVELS.ATTRIBUTE10%TYPE := NULL,
26 attribute11 CS_CONTRACT_COV_LEVELS.ATTRIBUTE11%TYPE := NULL,
27 attribute12 CS_CONTRACT_COV_LEVELS.ATTRIBUTE12%TYPE := NULL,
28 attribute13 CS_CONTRACT_COV_LEVELS.ATTRIBUTE13%TYPE := NULL,
29 attribute14 CS_CONTRACT_COV_LEVELS.ATTRIBUTE14%TYPE := NULL,
30 attribute15 CS_CONTRACT_COV_LEVELS.ATTRIBUTE15%TYPE := NULL,
31 context CS_CONTRACT_COV_LEVELS.CONTEXT%TYPE := NULL,
32 object_version_number NUMBER := NULL);
33 G_MISS_coveragelevel_rec CoverageLevel_Rec_Type;
34 TYPE CoverageLevel_Val_Rec_Type IS RECORD (
35 coverage_level_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
36 coverage_level_code CS_CONTRACT_COV_LEVELS.COVERAGE_LEVEL_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
37 coverage_level_value NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
38 last_update_date CS_CONTRACT_COV_LEVELS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
39 last_updated_by NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
40 creation_date CS_CONTRACT_COV_LEVELS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
41 created_by NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
42 last_update_login NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
43 cp_service_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
44 attribute1 CS_CONTRACT_COV_LEVELS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
45 attribute2 CS_CONTRACT_COV_LEVELS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
46 attribute3 CS_CONTRACT_COV_LEVELS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
47 attribute4 CS_CONTRACT_COV_LEVELS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
48 attribute5 CS_CONTRACT_COV_LEVELS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
49 attribute6 CS_CONTRACT_COV_LEVELS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
50 attribute7 CS_CONTRACT_COV_LEVELS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
51 attribute8 CS_CONTRACT_COV_LEVELS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
52 attribute9 CS_CONTRACT_COV_LEVELS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
53 attribute10 CS_CONTRACT_COV_LEVELS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
54 attribute11 CS_CONTRACT_COV_LEVELS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
55 attribute12 CS_CONTRACT_COV_LEVELS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
56 attribute13 CS_CONTRACT_COV_LEVELS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
57 attribute14 CS_CONTRACT_COV_LEVELS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
58 attribute15 CS_CONTRACT_COV_LEVELS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
59 context CS_CONTRACT_COV_LEVELS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
60 object_version_number NUMBER := TAPI_DEV_KIT.G_MISS_NUM);
61 G_MISS_coveragelevel_val_rec CoverageLevel_Val_Rec_Type;
62 ---------------------------------------------------------------------------
63 -- GLOBAL MESSAGE CONSTANTS
64 ---------------------------------------------------------------------------
65 G_FND_APP CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_FND_APP;
66 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_FORM_UNABLE_TO_RESERVE_REC;
67 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_FORM_RECORD_DELETED;
68 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_FORM_RECORD_CHANGED;
69 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_RECORD_LOGICALLY_DELETED;
70 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_REQUIRED_VALUE;
71 G_INVALID_VALUE CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_INVALID_VALUE;
72 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_COL_NAME_TOKEN;
73 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_PARENT_TABLE_TOKEN;
74 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_CHILD_TABLE_TOKEN;
75 ---------------------------------------------------------------------------
76 -- GLOBAL VARIABLES
77 ---------------------------------------------------------------------------
78 G_PKG_NAME CONSTANT VARCHAR2(200) := 'CS_COVERAGELEVEL_PVT';
79 G_APP_NAME CONSTANT VARCHAR2(3) := TAPI_DEV_KIT.G_APP_NAME;
80 ---------------------------------------------------------------------------
81 -- Procedures and Functions
82 ---------------------------------------------------------------------------
83
84 PROCEDURE insert_row
85 (
86 p_api_version IN NUMBER,
87 p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
88 p_validation_level IN NUMBER,
89 p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
90 x_return_status OUT VARCHAR2,
91 x_msg_count OUT NUMBER,
92 x_msg_data OUT VARCHAR2,
93 p_coveragelevel_rec IN CoverageLevel_Rec_Type := G_MISS_COVERAGELEVEL_REC,
94 x_coverage_level_id OUT NUMBER,
95 x_object_version_number OUT NUMBER);
96 PROCEDURE insert_row
97 (
98 p_api_version IN NUMBER,
99 p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
100 p_validation_level IN NUMBER,
101 p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
102 x_return_status OUT VARCHAR2,
103 x_msg_count OUT NUMBER,
104 x_msg_data OUT VARCHAR2,
105 p_coverage_level_code IN CS_CONTRACT_COV_LEVELS.COVERAGE_LEVEL_CODE%TYPE := NULL,
106 p_coverage_level_value IN NUMBER := NULL,
107 p_last_update_date IN CS_CONTRACT_COV_LEVELS.LAST_UPDATE_DATE%TYPE := NULL,
108 p_last_updated_by IN NUMBER := NULL,
109 p_creation_date IN CS_CONTRACT_COV_LEVELS.CREATION_DATE%TYPE := NULL,
110 p_created_by IN NUMBER := NULL,
111 p_last_update_login IN NUMBER := NULL,
112 p_cp_service_id IN NUMBER := NULL,
113 p_attribute1 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE1%TYPE := NULL,
114 p_attribute2 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE2%TYPE := NULL,
115 p_attribute3 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE3%TYPE := NULL,
116 p_attribute4 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE4%TYPE := NULL,
117 p_attribute5 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE5%TYPE := NULL,
118 p_attribute6 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE6%TYPE := NULL,
119 p_attribute7 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE7%TYPE := NULL,
120 p_attribute8 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE8%TYPE := NULL,
121 p_attribute9 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE9%TYPE := NULL,
122 p_attribute10 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE10%TYPE := NULL,
123 p_attribute11 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE11%TYPE := NULL,
124 p_attribute12 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE12%TYPE := NULL,
125 p_attribute13 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE13%TYPE := NULL,
126 p_attribute14 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE14%TYPE := NULL,
127 p_attribute15 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE15%TYPE := NULL,
128 p_context IN CS_CONTRACT_COV_LEVELS.CONTEXT%TYPE := NULL,
129 p_object_version_number IN NUMBER := NULL,
130 x_coverage_level_id OUT NUMBER,
131 x_object_version_number OUT NUMBER);
132 Procedure lock_row
133 (
134 p_api_version IN NUMBER,
135 p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
136 p_validation_level IN NUMBER,
137 p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
138 x_return_status OUT VARCHAR2,
139 x_msg_count OUT NUMBER,
140 x_msg_data OUT VARCHAR2,
141 p_coverage_level_id IN NUMBER,
142 p_object_version_number IN NUMBER);
143 Procedure update_row
144 (
145 p_api_version IN NUMBER,
146 p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
147 p_validation_level IN NUMBER,
148 p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
149 x_return_status OUT VARCHAR2,
150 x_msg_count OUT NUMBER,
151 x_msg_data OUT VARCHAR2,
152 p_coveragelevel_val_rec IN CoverageLevel_Val_Rec_Type := G_MISS_COVERAGELEVEL_VAL_REC,
153 x_object_version_number OUT NUMBER);
154 Procedure update_row
155 (
156 p_api_version IN NUMBER,
157 p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
158 p_validation_level IN NUMBER,
159 p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
160 x_return_status OUT VARCHAR2,
161 x_msg_count OUT NUMBER,
162 x_msg_data OUT VARCHAR2,
163 p_coverage_level_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
164 p_coverage_level_code IN CS_CONTRACT_COV_LEVELS.COVERAGE_LEVEL_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
165 p_coverage_level_value IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
166 p_last_update_date IN CS_CONTRACT_COV_LEVELS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
167 p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
168 p_creation_date IN CS_CONTRACT_COV_LEVELS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
169 p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
170 p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
171 p_cp_service_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
172 p_attribute1 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
173 p_attribute2 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
174 p_attribute3 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
175 p_attribute4 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
176 p_attribute5 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
177 p_attribute6 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
178 p_attribute7 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
179 p_attribute8 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
180 p_attribute9 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
181 p_attribute10 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
182 p_attribute11 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
183 p_attribute12 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
184 p_attribute13 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
185 p_attribute14 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
186 p_attribute15 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
187 p_context IN CS_CONTRACT_COV_LEVELS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
188 p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
189 x_object_version_number OUT NUMBER);
190 Procedure delete_row
191 (
192 p_api_version IN NUMBER,
193 p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
194 p_validation_level IN NUMBER,
195 p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
196 x_return_status OUT VARCHAR2,
197 x_msg_count OUT NUMBER,
198 x_msg_data OUT VARCHAR2,
199 p_coverage_level_id IN NUMBER);
200 PROCEDURE validate_row
201 (
202 p_api_version IN NUMBER,
203 p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
204 p_validation_level IN NUMBER,
205 p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
206 x_return_status OUT VARCHAR2,
207 x_msg_count OUT NUMBER,
208 x_msg_data OUT VARCHAR2,
209 p_coveragelevel_val_rec IN CoverageLevel_Val_Rec_Type := G_MISS_COVERAGELEVEL_VAL_REC);
210 PROCEDURE validate_row
211 (
212 p_api_version IN NUMBER,
213 p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
214 p_validation_level IN NUMBER,
215 p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
216 x_return_status OUT VARCHAR2,
217 x_msg_count OUT NUMBER,
218 x_msg_data OUT VARCHAR2,
219 p_coverage_level_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
220 p_coverage_level_code IN CS_CONTRACT_COV_LEVELS.COVERAGE_LEVEL_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
221 p_coverage_level_value IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
222 p_last_update_date IN CS_CONTRACT_COV_LEVELS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
223 p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
224 p_creation_date IN CS_CONTRACT_COV_LEVELS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
225 p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
226 p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
227 p_cp_service_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
228 p_attribute1 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
229 p_attribute2 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
230 p_attribute3 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
231 p_attribute4 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
232 p_attribute5 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
233 p_attribute6 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
234 p_attribute7 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
235 p_attribute8 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
236 p_attribute9 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
237 p_attribute10 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
238 p_attribute11 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
239 p_attribute12 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
240 p_attribute13 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
241 p_attribute14 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
242 p_attribute15 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
243 p_context IN CS_CONTRACT_COV_LEVELS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
244 p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM);
245 END CS_COVERAGELEVEL_PVT;