1 PACKAGE OKS_ENTITLEMENTS_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKSRENTS.pls 120.9.12020000.2 2012/07/23 07:54:10 spingali ship $ */
3
4 SUBTYPE Gx_Boolean IS VARCHAR2(1);
5 SUBTYPE Gx_YesNo IS VARCHAR2(1);
6 SUBTYPE Gx_Ret_Sts IS VARCHAR2(1);
7 SUBTYPE Gx_ExceptionMsg IS VARCHAR2(200);
8 SUBTYPE Gx_TimeZoneId IS NUMBER; --OKX_TIMEZONES_V.TIMEZONE_ID%TYPE;
9 SUBTYPE Gx_ReactDurn IS NUMBER(15,2);--OKC_REACT_INTERVALS.DURATION%TYPE;
10 SUBTYPE Gx_ReactUOM IS VARCHAR2(3); --OKC_REACT_INTERVALS.UOM_CODE%TYPE;
11 SUBTYPE Gx_OKS_Id IS NUMBER;
12 SUBTYPE Gx_BusProcess_Id IS NUMBER; --OKX_BUS_PROCESSES_V.ID1%TYPE;
13 SUBTYPE Gx_Severity_Id IS NUMBER; --OKX_INCIDENT_SEVERITS_V.ID1%TYPE;
14 SUBTYPE Gx_JTOT_ObjCode IS VARCHAR2(30); --JTF_OBJECTS_B.OBJECT_CODE%TYPE;
15 SUBTYPE Gx_Rule_Id IS NUMBER; --OKC_RULES_B.ID%TYPE;
16 SUBTYPE Gx_Rule_Category IS VARCHAR2(90); --OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE;
17 SUBTYPE Gx_TimeValue_Type IS VARCHAR2(10); --OKC_TIMEVALUES_B.TVE_TYPE%TYPE;
18
19 SUBTYPE Gx_Chr_StsCode IS OKC_K_HEADERS_B.STS_CODE%TYPE;
20 SUBTYPE Gx_Chr_Type IS OKC_K_HEADERS_B.CHR_TYPE%TYPE;
21 SUBTYPE Gx_Chr_PartyId IS OKC_K_PARTY_ROLES_B.OBJECT1_ID1%TYPE;
22
23 SUBTYPE Gx_Itm_Obj1Id1 IS OKC_K_ITEMS.OBJECT1_ID1%TYPE;
24 SUBTYPE Gx_Itm_Obj1Id2 IS OKC_K_ITEMS.OBJECT1_ID2%TYPE;
25
26 SUBTYPE Inp_Rec_Type IS OKS_ENTITLEMENTS_PUB.Inp_Rec_Type;
27 SUBTYPE Hdr_Tbl_Type IS OKS_ENTITLEMENTS_PUB.Hdr_Tbl_Type;
28
29 SUBTYPE Line_Tbl_Type IS OKS_ENTITLEMENTS_PUB.Line_Tbl_Type;
30
31 SUBTYPE Clvl_Tbl_Type IS OKS_ENTITLEMENTS_PUB.Clvl_Tbl_Type;
32 SUBTYPE PrfEng_Tbl_Type IS OKS_ENTITLEMENTS_PUB.PrfEng_Tbl_Type;
33 SUBTYPE Ent_Contact_Tbl IS OKS_ENTITLEMENTS_PUB.Ent_Contact_Tbl;
34
35 -----------------------------------------------------------------------------------------------------------------------*
36
37 SUBTYPE Inp_Cont_Rec IS OKS_ENTITLEMENTS_PUB.Inp_Cont_Rec;
38 SUBTYPE Get_ContIn_Rec IS OKS_ENTITLEMENTS_PUB.Get_ContIn_Rec;
39 SUBTYPE Input_Rec_IB IS OKS_ENTITLEMENTS_PUB.Input_Rec_IB;
40
41 SUBTYPE Ent_Cont_Rec IS OKS_ENTITLEMENTS_PUB.Ent_Cont_Rec;
42 SUBTYPE Ent_Cont_Tbl IS OKS_ENTITLEMENTS_PUB.Ent_Cont_Tbl;
43
44 SUBTYPE Get_ConTop_Rec IS OKS_ENTITLEMENTS_PUB.Get_ConTop_Rec;
45 SUBTYPE Get_ConTop_Tbl IS OKS_ENTITLEMENTS_PUB.Get_ConTop_Tbl;
46
47 SUBTYPE Output_Rec_IB IS OKS_ENTITLEMENTS_PUB.Output_Rec_IB;
48 SUBTYPE Output_Tbl_IB IS OKS_ENTITLEMENTS_PUB.Output_Tbl_IB;
49
50 SUBTYPE grt_inp_rec_type IS OKS_ENTITLEMENTS_PUB.grt_inp_rec_type;
51 SUBTYPE rcn_rsn_rec_type IS OKS_ENTITLEMENTS_PUB.rcn_rsn_rec_type;
52
53 SUBTYPE input_rec_entfrm IS OKS_ENTITLEMENTS_PUB.input_rec_entfrm;
54 SUBTYPE output_rec_entfrm IS OKS_ENTITLEMENTS_PUB.output_rec_entfrm;
55 SUBTYPE output_tbl_entfrm IS OKS_ENTITLEMENTS_PUB.output_tbl_entfrm;
56
57 SUBTYPE CovType_Rec_Type IS OKS_ENTITLEMENTS_PUB.CovType_Rec_Type;
58 SUBTYPE Default_Contline_System_Rec IS OKS_ENTITLEMENTS_PUB.Default_Contline_System_Rec;
59
60 -----------------------------------------------------------------------------------------------------------------------
61
62 SUBTYPE INP_REC_BP IS OKS_ENTITLEMENTS_PUB.INP_REC_BP;
63 SUBTYPE OUTPUT_TBL_BP IS OKS_ENTITLEMENTS_PUB.OUTPUT_TBL_BP;
64 SUBTYPE OUTPUT_TBL_BT IS OKS_ENTITLEMENTS_PUB.OUTPUT_TBL_BT;
65 SUBTYPE OUTPUT_TBL_BR IS OKS_ENTITLEMENTS_PUB.OUTPUT_TBL_BR;
66
67
68 -----------------------------------------------------------------------------------------------------------------------*
69 SUBTYPE inp_cont_rec_type IS OKS_ENTITLEMENTS_PUB.inp_cont_rec_type;
70 SUBTYPE output_tbl_contract IS OKS_ENTITLEMENTS_PUB.output_tbl_contract;
71 SUBTYPE covlvl_id_tbl IS OKS_ENTITLEMENTS_PUB.covlvl_id_tbl;
72 SUBTYPE covlevel_tbl_type IS OKS_ENTITLEMENTS_PUB.covlevel_tbl_type;
73
74 SUBTYPE srchline_inpcontrec_type IS OKS_ENTITLEMENTS_PUB.srchline_inpcontrec_type;
75
76 SUBTYPE srchline_inpcontlinerec_type IS OKS_ENTITLEMENTS_PUB.srchline_inpcontlinerec_type;
77 SUBTYPE srchline_covlvl_id_tbl IS OKS_ENTITLEMENTS_PUB.srchline_covlvl_id_tbl;
78 SUBTYPE output_tbl_contractline IS OKS_ENTITLEMENTS_PUB.output_tbl_contractline;
79
80 SUBTYPE srchline_inpcontlinerec_TBL IS OKS_ENTITLEMENTS_PUB.srchline_inpcontlinerec_TBL;
81
82 /*vgujarat - modified for access hour ER 9675504*/
83 TYPE Inp_rec_getcont02 IS RECORD
84 (Contract_Number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE
85 ,Contract_Number_Modifier OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE
86 ,Service_Line_Id NUMBER
87 ,Party_Id NUMBER
88 ,Site_Id NUMBER
89 ,Cust_Acct_Id NUMBER
90 ,System_Id NUMBER
91 ,Item_Id NUMBER
92 ,Product_Id NUMBER
93 ,Incident_Date DATE -- Added for 12.0 ENT-TZ project (JVARGHES)
94 ,Request_Date DATE
95 ,Request_Date_Start DATE
96 ,Request_Date_End DATE
97 ,Business_Process_Id NUMBER
98 ,Severity_Id NUMBER
99 ,Time_Zone_Id NUMBER
100 ,Dates_In_Input_TZ VARCHAR2(1) -- Added for 12.0 ENT-TZ project (JVARGHES)
101 ,Calc_RespTime_Flag VARCHAR2(1)
102 ,Validate_Flag VARCHAR2(1)
103 ,Validate_Eff_Flag VARCHAR2(1)
104 ,Sort_Key VARCHAR2(10)
105 ,cust_id NUMBER DEFAULT NULL --access hour
106 ,cust_site_id NUMBER DEFAULT null --access hour
107 ,cust_loc_id NUMBER DEFAULT null); --access hour
108
109 TYPE GR_Bp_CoverTime IS RECORD
110 (Rv_Cover_Day VARCHAR2(25)
111 ,Rv_Cover_From VARCHAR2(25)
112 ,Rv_Cover_To VARCHAR2(25)
113 ,Rx_Cover_TZoneId Gx_TimeZoneId
114 ,Ri_Cover_Day INTEGER(1)
115 ,Ri_ReqDay_Relative INTEGER(1)
116 );
117
118 TYPE GR_Bp_Reaction IS RECORD
119 (Rv_React_Day VARCHAR2(25)
120 ,Rx_React_Durn Gx_ReactDurn
121 ,Rx_React_UOM Gx_ReactUOM
122 ,Ri_React_Day INTEGER(1)
123 ,Ri_ReqDay_Relative INTEGER(1)
124 );
125
126 TYPE GR_Contract_Ref IS RECORD
127 (Rx_Chr_Id Gx_OKS_Id
128 ,Rx_Cle_Id Gx_OKS_Id
129 ,Rx_Pty_Id Gx_OKS_Id
130 );
131
132 TYPE GR_ContItem_Ref IS RECORD
133 (Rx_Obj1Id1 Gx_Itm_Obj1Id1
134 ,Rx_Obj1Id2 Gx_Itm_Obj1Id2
135 ,Rx_ObjCode Gx_JTOT_ObjCode
136 );
137
138 TYPE Idx_Rec IS RECORD
139 (Contract_Id NUMBER
140 ,Contract_Number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE
141 ,Contract_Number_Modifier OKC_K_HEADERS_B.CONTRACT_NUMBER_MODIFIER%TYPE
142 ,Sts_Code OKC_K_LINES_B.STS_CODE%TYPE
143 ,Authoring_Org_Id NUMBER
144 ,Inv_Organization_Id NUMBER
145 ,HDR_End_Date DATE--grace period changes
146 ,Service_Line_Id NUMBER
147 ,SV_Start_Date DATE
148 ,SV_End_Date DATE
149 ,SV_Date_Terminated DATE
150 ,CL_Sts_Code OKC_K_LINES_B.STS_CODE%TYPE
151 ,CovLvl_Line_Id NUMBER
152 ,CL_Start_Date DATE
153 ,CL_End_Date DATE
154 ,CL_Date_Terminated DATE
155 ,Warranty_Flag VARCHAR2(1)
156 ,PM_Program_Id VARCHAR2(40)
157 ,PM_Schedule_Exists VARCHAR2(450)
158 ,Scs_Code OKC_K_HEADERS_B.SCS_CODE%TYPE
159 ,Estimated_Amount OKC_K_HEADERS_B.Estimated_Amount%TYPE
160 ,HD_Start_Date DATE
161 ,HD_End_Date DATE
162 ,Cognomen OKC_K_HEADERS_TL.Cognomen%TYPE
163 ,short_description OKC_K_HEADERS_TL.short_description%TYPE
164 ,HD_Currency_code VARCHAR2(15));
165
166 TYPE Day_Cover_Rec IS RECORD
167 (Day_Cover_From VARCHAR2(30)
168 ,Day_Cover_To VARCHAR2(30));
169
170 TYPE Day_Cover_Tbl IS TABLE OF Day_Cover_Rec INDEX BY BINARY_INTEGER;
171
172 TYPE G_STATUS_REC IS RECORD
173 (CODE OKC_STATUSES_V.CODE%TYPE
174 ,MEANING OKC_STATUSES_V.MEANING%TYPE);
175
176 TYPE G_STATUS_TBL IS TABLE OF G_STATUS_REC INDEX BY BINARY_INTEGER;
177
178 l_status_tab G_STATUS_TBL;
179
180 TYPE line_id_rec IS RECORD
181 (line_id NUMBER);
182
183 TYPE line_id_tbl IS TABLE OF line_id_rec INDEX BY BINARY_INTEGER;
184
185 TYPE Rle_Lkup_REC IS RECORD
186 (CODE FND_LOOKUPS.LOOKUP_CODE%TYPE
187 ,MEANING FND_LOOKUPS.MEANING%TYPE);
188
189 TYPE Rle_Lkup_TBL IS TABLE OF Rle_Lkup_REC INDEX BY BINARY_INTEGER;
190
191 -----------------------------------------------------------------------------------------------------------------------*
192
193 TYPE GT_Bp_CoverTimes IS TABLE OF GR_Bp_CoverTime INDEX BY BINARY_INTEGER;
194 TYPE GT_Bp_Reactions IS TABLE OF GR_Bp_Reaction INDEX BY BINARY_INTEGER;
195
196 TYPE GT_Contract_Ref IS TABLE OF GR_Contract_Ref INDEX BY BINARY_INTEGER;
197 TYPE GT_ContItem_Ref IS TABLE OF GR_ContItem_Ref INDEX BY BINARY_INTEGER;
198
199 TYPE GR_PARENT_Ref IS RECORD
200 (RX_Object_ID Gx_Itm_Obj1Id1
201 ,RX_Subject_ID Gx_Itm_Obj1Id1);
202
203 TYPE GT_PARENT_Ref IS TABLE OF GR_PARENT_Ref INDEX BY BINARY_INTEGER;
204
205 TYPE GR_INSTANCES IS RECORD
206 (RX_Inst_ID Gx_Itm_Obj1Id1);
207
208 TYPE GT_INSTANCES IS TABLE OF GR_INSTANCES INDEX BY BINARY_INTEGER;
209
210 TYPE ii_relationship_rec IS RECORD
211 (
212 RELATIONSHIP_ID NUMBER,
213 RELATIONSHIP_TYPE_CODE VARCHAR2(30),
214 OBJECT_ID NUMBER,
215 SUBJECT_ID NUMBER,
216 SUBJECT_HAS_CHILD VARCHAR2(1),
217 POSITION_REFERENCE VARCHAR2(30),
218 ACTIVE_START_DATE DATE,
219 ACTIVE_END_DATE DATE,
220 DISPLAY_ORDER NUMBER,
221 MANDATORY_FLAG VARCHAR2(1),
222 PARENT_TBL_INDEX NUMBER,
223 PROCESSED_FLAG VARCHAR2(1),
224 INTERFACE_ID NUMBER
225 );
226
227 TYPE ii_relationship_tbl IS TABLE OF ii_relationship_rec INDEX BY BINARY_INTEGER;
228
229 -----------------------------------------------------------------------------------------------------------------------*
230
231 G_RET_STS_SUCCESS CONSTANT Gx_Ret_Sts := OKC_API.G_RET_STS_SUCCESS;
232 G_RET_STS_ERROR CONSTANT Gx_Ret_Sts := OKC_API.G_RET_STS_ERROR;
233 G_RET_STS_UNEXP_ERROR CONSTANT Gx_Ret_Sts := OKC_API.G_RET_STS_UNEXP_ERROR;
234
235 G_TRUE CONSTANT Gx_Boolean := OKC_API.G_TRUE;
236 G_FALSE CONSTANT Gx_Boolean := OKC_API.G_FALSE;
237
238
239 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
240 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
241
242 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
243 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
244 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
245 G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKS_NO_PARENT_RECORD';
246
247 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
248 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE'; --'SQLerrm';
249 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE'; --'SQLcode';
250
251 G_DEBUG_TOKEN CONSTANT VARCHAR2(200) := 'OKS_ENT_DEBUG';
252 G_PACKAGE_TOKEN CONSTANT VARCHAR2(200) := 'Package';
253 G_PROGRAM_TOKEN CONSTANT VARCHAR2(200) := 'Program';
254 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKS_ENTITLEMENTS_PUB';
255 G_APP_NAME_OKS CONSTANT VARCHAR2(3) := 'OKS';
256 G_APP_NAME_OKC CONSTANT VARCHAR2(3) := 'OKC';
257
258 G_LINE_STYLE_SERVICE CONSTANT Gx_OKS_Id := 1;
259 G_LINE_STYLE_SRV_COVERAGE CONSTANT Gx_OKS_Id := 2;
260 G_LINE_STYLE_WARRANTY CONSTANT Gx_OKS_Id := 14;
261 G_LINE_STYLE_WAR_COVERAGE CONSTANT Gx_OKS_Id := 15;
262 G_LINE_STYLE_EXT_WARRANTY CONSTANT Gx_OKS_Id := 19;
263 G_LINE_STYLE_EWT_COVERAGE CONSTANT Gx_OKS_Id := 20;
264 G_LINE_STYLE_USAGE CONSTANT Gx_OKS_Id := 12;
265
266 G_JTOT_OBJ_BUSIPROC CONSTANT Gx_JTOT_ObjCode := 'OKX_BUSIPROC';
267 G_JTOT_OBJ_REACTIME CONSTANT Gx_JTOT_ObjCode := 'OKX_REACTIME';
268 G_JTOT_OBJ_PARTY CONSTANT Gx_JTOT_ObjCode := 'OKX_PARTY';
269
270 G_RUL_CATEGORY_REACTION CONSTANT Gx_Rule_Category := 'RCN';
271 G_RUL_CATEGORY_RESOLUTION CONSTANT Gx_Rule_Category := 'RSN';
272 G_RUL_CATEGORY_REACT_RESOLVE CONSTANT Gx_Rule_Category := 'RCN_RSN';
273
274 -- addition due to grace period changes starts
275 G_RUL_CATEGORY_GRACE CONSTANT Gx_Rule_Category := 'GPR';
276 G_GRACE_PROFILE_SET VARCHAR2(1);
277 G_CONTRACT_END_DATE DATE;
278 G_CONTRACT_ID Gx_OKS_Id;
279 -- addition due to grace period changes ends
280
281 G_TIMEVALUE_TYPE_IGS CONSTANT Gx_TimeValue_Type := 'IGS';
282 G_TIMEVALUE_TYPE_TGD CONSTANT Gx_TimeValue_Type := 'TGD';
283
284 G_BEST CONSTANT VARCHAR2(10):= 'BEST';
285 G_FIRST CONSTANT VARCHAR2(10):= 'FIRST';
286 G_YES CONSTANT Gx_YesNo := 'Y';
287 G_NO CONSTANT Gx_YesNo := 'N';
288
289 G_RESOLUTION_TIME CONSTANT VARCHAR2(10):= 'RSN';
290 G_REACTION_TIME CONSTANT VARCHAR2(10):= 'RCN';
291 G_COVERAGE_TYPE_IMP_LEVEL CONSTANT VARCHAR2(10):= 'COVTYP_IMP';
292 G_NO_SORT_KEY CONSTANT VARCHAR2(10):= 'NO_KEY';
293 -- addition for PROCEDURE Default_Contract_line_CSI starts
294 G_CALLED_FROM_DEF_CONLINECSI VARCHAR2(1);
295 -- addition for PROCEDURE Default_Contract_line_CSI ends
296
297 G_Service_Line_Data VARCHAR2(1);
298 G_Header_Data VARCHAR2(1);
299
300 -----------------------------------------------------------------------------------------------------------------------*
301
302 PROCEDURE Validate_Required_NumValue
303 (P_Num_Value IN NUMBER
304 ,P_Set_ExcepionStack IN Gx_Boolean
305 ,P_ExcepionMsg IN Gx_ExceptionMsg
306 ,X_Result out nocopy Gx_Boolean
307 ,X_Return_Status out nocopy Gx_Ret_Sts);
308
309 PROCEDURE Validate_Required_DateValue
310 (P_Date_Value IN DATE
311 ,P_Set_ExcepionStack IN Gx_Boolean
312 ,P_ExcepionMsg IN Gx_ExceptionMsg
313 ,X_Result out nocopy Gx_Boolean
314 ,X_Return_Status out nocopy Gx_Ret_Sts);
315
316 PROCEDURE Validate_Required_CharValue
317 (P_Char_Value IN VARCHAR2
318 ,P_Set_ExcepionStack IN Gx_Boolean
319 ,P_ExcepionMsg IN Gx_ExceptionMsg
320 ,X_Result out nocopy Gx_Boolean
321 ,X_Return_Status out nocopy Gx_Ret_Sts);
322
323 PROCEDURE Validate_Required_RT_Tokens
324 (P_SVL_Id IN Gx_OKS_Id
325 ,P_BusiProc_Id IN Gx_BusProcess_Id
326 ,P_Severity_Id IN Gx_Severity_Id
327 ,P_Request_Date IN DATE
328 ,P_Request_TZone_id IN Gx_TimeZoneId
329 ,P_template_YN in varchar2 -- for default coverage functionality
330 ,P_Set_ExcepionStack IN Gx_Boolean
331 ,X_Result out nocopy Gx_Boolean
332 ,X_Return_Status out nocopy Gx_Ret_Sts);
333
334
335 PROCEDURE Validate_Service_Line
336 (P_SVL_Id IN Gx_OKS_Id
337 ,P_Set_ExcepionStack IN Gx_Boolean
338 ,X_CVL_Id OUT nocopy NUMBER -- Added for 12.0 Coverage Rearch project (JVARGHES)
339 ,X_Std_Cov_YN OUT nocopy VARCHAR2 -- Added for 12.0 Coverage Rearch project (JVARGHES)
340 ,X_SVL_Start out nocopy DATE
341 ,X_SVL_End out nocopy DATE
342 ,X_SVL_Terminated out nocopy DATE
343 ,X_Result out nocopy Gx_Boolean
344 ,X_Return_Status out nocopy Gx_Ret_Sts);
345
346 PROCEDURE Validate_Coverage_Line
347 (P_CVL_Id IN Gx_OKS_Id -- Added for 12.0 Coverage Rearch project (JVARGHES)
348 --,P_SVL_Id IN Gx_OKS_Id -- Modified for 12.0 Coverage Rearch project (JVARGHES)
349 --,P_Template_YN IN varchar2 -- Modified for 12.0 Coverage Rearch project (JVARGHES)
350 ,P_Set_ExcepionStack IN Gx_Boolean
351 --,X_CVL_Id out nocopy Gx_OKS_Id -- Modified for 12.0 Coverage Rearch project (JVARGHES)
352 ,X_CVL_Start out nocopy DATE
353 ,X_CVL_End out nocopy DATE
354 ,X_CVL_Terminated out nocopy DATE
355 ,X_Result out nocopy Gx_Boolean
356 ,X_Return_Status out nocopy Gx_Ret_Sts);
357
358 --
359 -- Added for 12.0 Coverage Rearch project (JVARGHES)
360 --
361
362 PROCEDURE Get_BP_Line_Start_Offset
363 (P_BPL_Id IN Gx_OKS_Id
364 ,P_SVL_Start IN DATE
365 ,X_BPL_OFS_Start OUT NOCOPY DATE
366 ,X_BPL_OFS_Duration OUT NOCOPY NUMBER
367 ,X_BPL_OFS_UOM OUT NOCOPY VARCHAR2
368 ,X_Return_Status out nocopy Gx_Ret_Sts);
369
370 PROCEDURE Validate_BusinessProcess_Line
371 (P_BPL_Id IN Gx_OKS_Id
372 ,P_Set_ExcepionStack IN Gx_Boolean
373 ,X_BPL_Start out nocopy DATE
374 ,X_BPL_End out nocopy DATE
375 ,X_BPL_Terminated out nocopy DATE
376 ,X_Result out nocopy Gx_Boolean
377 ,X_Return_Status out nocopy Gx_Ret_Sts);
378
379 PROCEDURE Validate_Contract_BP
380 (P_CVL_Id IN Gx_OKS_Id -- P_SVL_Id IN Gx_OKS_Id
381 ,P_BP_Id IN Gx_BusProcess_Id
382 ,P_BP_ObjCode IN Gx_JTOT_ObjCode
383 ,P_Set_ExcepionStack IN Gx_Boolean
384 ,P_REQ_DATE IN DATE ------ansraj bug 13795417
385 ,X_BPL_Id OUT nocopy Gx_OKS_Id
386 ,X_BPL_Start OUT nocopy DATE
387 ,X_BPL_End OUT nocopy DATE
388 ,X_BPL_Terminated OUT nocopy DATE
389 ,X_Result OUT nocopy Gx_Boolean
390 ,X_Return_Status OUT nocopy Gx_Ret_Sts);
391
392
393 PROCEDURE Get_Effective_End_Date
394 (P_Start_Date IN DATE
395 ,P_End_Date IN DATE
396 ,P_Termination_Date IN DATE
397 ,P_EndDate_Required IN Gx_Boolean
398 ,P_Set_ExcepionStack IN Gx_Boolean
399 ,P_ExcepionMsg IN Gx_ExceptionMsg
400 ,X_EffEnd_Date out nocopy DATE
401 ,X_Result out nocopy Gx_Boolean
402 ,X_Return_Status out nocopy Gx_Ret_Sts);
403
404 PROCEDURE Convert_TimeZone
405 (P_API_Version IN NUMBER
406 ,P_Init_Msg_List IN VARCHAR2
407 ,p_Source_Date IN DATE
408 ,P_Source_Tz_Id IN Gx_TimeZoneId
409 ,P_Dest_Tz_Id IN Gx_TimeZoneId
410 ,X_Dest_Date out nocopy DATE
411 ,X_Msg_Count out nocopy NUMBER
412 ,X_Msg_Data OUT nocopy VARCHAR2
413 ,X_Return_Status OUT nocopy Gx_Ret_Sts);
414
415 PROCEDURE Validate_Effectivity
416 (P_Request_Date IN DATE
417 ,P_Start_DateTime IN DATE
418 ,P_End_DateTime IN DATE
419 ,P_Set_ExcepionStack IN Gx_Boolean
420 ,P_CL_Msg_TokenValue IN Gx_ExceptionMsg
421 ,X_Result out nocopy Gx_Boolean
422 ,X_Return_Status out nocopy Gx_Ret_Sts);
423
424 -- 11.5.10 rule rearchitecture changes ...the procedure will get only reaction time line id and not rule_id
425
426 PROCEDURE Get_BP_ReactResolTime_Line
427 (P_BPL_Id IN Gx_OKS_Id
428 ,P_Severity_Id IN Gx_Severity_Id
429 ,P_TimeType_Category IN Varchar2 --Gx_TimeType_Category
430 ,P_Active_YN IN Gx_YesNo
431 ,P_Set_ExcepionStack IN Gx_Boolean
432 ,X_RTL_Id out nocopy Gx_OKS_Id
433 ,X_RTL_Start out nocopy DATE
434 ,X_RTL_End out nocopy DATE
435 ,X_RTL_Terminated out nocopy DATE
436 ,X_RTL_Line_Id out nocopy Gx_OKS_Id
437 ,X_RTL_WT_YN out nocopy Gx_YesNo
438 ,X_Result out nocopy Gx_Boolean
439 ,X_Return_Status out nocopy Gx_Ret_Sts);
440
441 PROCEDURE Get_Cont_Effective_Dates
442 (P_SVL_Start IN DATE
443 ,P_SVL_End IN DATE
444 ,P_CVL_Start IN DATE
445 ,P_CVL_End IN DATE
446 ,P_BPL_Start IN DATE
447 ,P_BPL_End IN DATE
448 ,P_RTL_Start IN DATE
449 ,P_RTL_End IN DATE
450 ,P_Set_ExcepionStack IN Gx_Boolean
451 ,X_Cont_EffStart out nocopy DATE
452 ,X_Cont_EffEnd out nocopy DATE
453 ,X_Result out nocopy Gx_Boolean
454 ,X_Return_Status out nocopy Gx_Ret_Sts);
455
456 -- commented and replaced because of 11.5.10 rearchitecture changes
457
458 /*vgujarat - modified for access hour ER 9675504*/
459 PROCEDURE Get_BP_Cover_Times
460 (P_BP_CVTLine_Id IN Gx_OKS_Id
461 ,P_Request_Date IN DATE
462 ,P_CovDay_DispFmt IN VARCHAR2
463 ,P_Set_ExcepionStack IN Gx_Boolean
464 ,X_BP_CovTimes out nocopy Gt_Bp_CoverTimes
465 ,X_Result out nocopy Gx_Boolean
466 ,X_Return_Status out nocopy Gx_Ret_Sts
467 ,P_cust_id IN NUMBER DEFAULT NULL
468 ,P_cust_site_id IN NUMBER DEFAULT NULL
469 ,P_cust_loc_id IN NUMBER DEFAULT NULL);
470
471 -- commented and replaced because of 11.5.10 rearchitecture changes
472
473 PROCEDURE Get_BP_Reaction_Times
474 (P_RTL_Line_Id IN Gx_OKS_Id
475 ,P_Request_Date IN DATE
476 ,P_TimeType_Category IN Varchar2 --Gx_TimeType_Category
477 ,P_ReactDay_DispFmt IN VARCHAR2
478 ,P_Set_ExcepionStack IN Gx_Boolean
479 ,X_Reaction_Attribs out nocopy GT_Bp_Reactions
480 ,X_Result out nocopy Gx_Boolean
481 ,X_Return_Status out nocopy Gx_Ret_Sts);
482
483 PROCEDURE Get_Reactn_Durn_In_Days
484 (P_React_Durn IN Gx_ReactDurn
485 ,P_React_UOM IN Gx_ReactUOM
486 ,P_Set_ExcepionStack IN Gx_Boolean
487 ,X_React_Durn_In_Days out nocopy NUMBER
488 ,X_Result out nocopy Gx_Boolean
489 ,X_Return_Status out nocopy Gx_Ret_Sts);
490
491 PROCEDURE Get_Cover_Day_Attribs
492 (P_BP_CovTimes IN GT_Bp_CoverTimes
493 ,P_Req_Cover_Date IN DATE
494 ,P_Set_ExcepionStack IN Gx_Boolean
495 ,P_Check_Day IN Varchar2
496 ,X_Day_Cover_tbl out nocopy Day_Cover_Tbl
497 ,X_Result out nocopy Gx_Boolean
498 ,X_Return_Status out nocopy Gx_Ret_Sts);
499
500 PROCEDURE Compute_Day_React_By_DateTime
501 (P_Req_DateTime IN DATE
502 ,P_Cover_EffStart IN DATE
503 ,P_Cover_EffEnd IN DATE
504 ,P_BP_Work_Through IN Gx_YesNo
505 ,P_BP_Cover_Times IN GT_Bp_CoverTimes
506 ,P_React_Durn_In_Days IN NUMBER
507 ,P_Template_YN IN VARCHAR2
508 ,P_Set_ExcepionStack IN Gx_Boolean
509 ,P_Check_Day IN Varchar2
510 ,X_React_By_DateTime out nocopy DATE
511 ,X_React_Start_DateTime out nocopy DATE
512 ,X_Result out nocopy Gx_Boolean
513 ,X_Return_Status out nocopy Gx_Ret_Sts);
514
515 PROCEDURE Compute_React_By_DateTime
516 (P_Request_DateTime IN DATE
517 ,P_Cover_EffStart IN DATE
518 ,P_Cover_EffEnd IN DATE
519 ,P_BP_Work_Through IN Gx_YesNo
520 ,P_BP_Cover_Times IN GT_Bp_CoverTimes
521 ,P_Reaction_Attribs IN GT_Bp_Reactions
522 ,P_Option IN VARCHAR2
523 ,P_Template_YN IN VARCHAR2
524 ,P_Set_ExcepionStack IN Gx_Boolean
525 ,X_React_Durn out nocopy Gx_ReactDurn
526 ,X_React_UOM out nocopy Gx_ReactUOM
527 ,X_React_Day out nocopy VARCHAR2
528 ,X_React_By_DateTime out nocopy DATE
529 ,X_React_Start_DateTime out nocopy DATE
530 ,X_Result out nocopy Gx_Boolean
531 ,X_Return_Status out nocopy Gx_Ret_Sts);
532
533 /*vgujarat - modified for access hour ER 9675504*/
534 PROCEDURE Get_ReactResol_By_DateTime
535 (P_API_Version IN NUMBER
536 ,P_Init_Msg_List IN VARCHAR2
537 ,P_SVL_Id IN Gx_OKS_Id -- can be service line id or coverage line id depending on P_Template_YN is 'N' or, 'Y'
538 ,P_BusiProc_Id IN Gx_BusProcess_Id
539 ,P_Severity_Id IN Gx_Severity_Id
540 ,P_Request_Date IN DATE
541 ,P_Request_TZone_id IN Gx_TimeZoneId
542 ,P_Dates_In_Input_TZ IN VARCHAR2 -- Added for 12.0 ENT-TZ project (JVARGHES)
543 ,P_template_YN IN VARCHAR2 -- for default coverage enhancement
544 ,P_Option IN VARCHAR2
545 ,P_Rcn_Rsn_Flag IN VARCHAR2
546 ,P_Set_ExcepionStack IN Gx_Boolean
547 ,X_React_Durn out nocopy Gx_ReactDurn
548 ,X_React_UOM out nocopy Gx_ReactUOM
549 ,X_React_Day out nocopy VARCHAR2
550 ,X_React_By_DateTime out nocopy DATE
551 ,X_React_Start_DateTime out nocopy DATE
552 ,X_Resolve_Durn out nocopy Gx_ReactDurn
553 ,X_Resolve_UOM out nocopy Gx_ReactUOM
554 ,X_Resolve_Day out nocopy VARCHAR2
555 ,X_Resolve_By_DateTime out nocopy DATE
556 ,X_Resolve_Start_DateTime out nocopy DATE
557 ,X_Msg_count OUT NOCOPY Number
558 ,X_Msg_data OUT NOCOPY Varchar2
559 ,X_Result out nocopy Gx_Boolean
560 ,X_Return_Status out nocopy Gx_Ret_Sts
561 ,P_cust_id IN NUMBER DEFAULT NULL
562 ,P_cust_site_id IN NUMBER DEFAULT NULL
563 ,P_cust_loc_id IN NUMBER DEFAULT NULL);
564
565 /*vgujarat - modified for access hour ER 9675504*/
566 PROCEDURE Check_Reaction_Times
567 (P_API_Version IN NUMBER
568 ,P_Init_Msg_List IN VARCHAR2
569 ,P_Business_Process_Id IN NUMBER
570 ,P_Request_Date IN DATE
571 ,P_Sr_Severity IN NUMBER
572 ,P_Time_Zone_Id IN NUMBER
573 ,P_Dates_In_Input_TZ IN VARCHAR2 -- Added for 12.0 ENT-TZ project (JVARGHES)
574 ,P_Contract_Line_Id IN NUMBER
575 ,X_Return_Status OUT NOCOPY VARCHAR2
576 ,X_Msg_Count OUT NOCOPY NUMBER
577 ,X_Msg_Data OUT NOCOPY VARCHAR2
578 ,X_React_Within OUT NOCOPY NUMBER
579 ,X_React_TUOM OUT NOCOPY VARCHAR2
580 ,X_React_By_Date OUT NOCOPY DATE
581 ,P_cust_id IN NUMBER DEFAULT NULL
582 ,P_cust_site_id IN NUMBER DEFAULT NULL
583 ,P_cust_loc_id IN NUMBER DEFAULT NULL);
584
585 PROCEDURE get_react_resolve_by_time
586 (p_api_version in number
587 ,p_init_msg_list in varchar2
588 ,p_inp_rec in grt_inp_rec_type
589 ,x_return_status out nocopy varchar2
590 ,x_msg_count out nocopy number
591 ,x_msg_data out nocopy varchar2
592 ,x_react_rec out nocopy rcn_rsn_rec_type
593 ,x_resolve_rec out nocopy rcn_rsn_rec_type);
594
595 PROCEDURE Validate_Required_CT_Tokens
596 (P_SVL_Id IN Gx_OKS_Id
597 ,P_BusiProc_Id IN Gx_BusProcess_Id
598 ,P_Request_Date IN DATE
599 ,P_Request_TZone_id IN Gx_TimeZoneId
600 ,P_Set_ExcepionStack IN Gx_Boolean
601 ,X_Result out nocopy Gx_Boolean
602 ,X_Return_Status out nocopy Gx_Ret_Sts);
603
604 PROCEDURE Get_Coverage_Times
605 (P_API_Version IN NUMBER
606 ,P_Init_Msg_List IN VARCHAR2
607 ,P_SVL_Id IN Gx_OKS_Id
608 ,P_BusiProc_Id IN Gx_BusProcess_Id
609 ,P_Request_Date IN DATE
610 ,P_Request_TZone_id IN Gx_TimeZoneId
611 ,P_Dates_In_Input_TZ IN VARCHAR2 -- Added for 12.0 ENT-TZ project (JVARGHES)
612 ,P_Set_ExcepionStack IN Gx_Boolean
613 ,X_Day_Cover_From out nocopy DATE
614 ,X_Day_Cover_To out nocopy DATE
615 ,X_Covered out nocopy Gx_Boolean
616 ,X_Msg_Count OUT NOCOPY NUMBER
617 ,X_Msg_Data OUT NOCOPY VARCHAR2
618 ,X_Result out nocopy Gx_Boolean
619 ,X_Return_Status out nocopy Gx_Ret_Sts);
620
621 PROCEDURE Check_Coverage_Times
622 (P_API_Version IN NUMBER
623 ,P_Init_Msg_List IN VARCHAR2
624 ,P_Business_Process_Id IN NUMBER
625 ,P_Request_Date IN DATE
626 ,P_Time_Zone_Id IN NUMBER
627 ,P_Dates_In_Input_TZ IN VARCHAR2 -- Added for 12.0 ENT-TZ project (JVARGHES)
628 ,P_Contract_Line_Id IN NUMBER
629 ,X_Return_Status OUT NOCOPY VARCHAR2
630 ,X_Msg_Count OUT NOCOPY NUMBER
631 ,X_Msg_Data OUT NOCOPY VARCHAR2
632 ,X_Covered_YN OUT NOCOPY VARCHAR2);
633
634 PROCEDURE Get_Contract_Header_Details
635 (P_API_Version IN NUMBER
636 ,P_Init_Msg_List IN VARCHAR2
637 ,P_Chr_Id IN Gx_OKS_Id
638 ,P_Chr_Sts_Code IN Gx_Chr_StsCode
639 ,P_Chr_Type IN Gx_Chr_Type
640 ,P_Chr_EndDate IN DATE
641 ,P_Chr_PartyId IN Gx_Chr_PartyId
642 ,X_Contract_Headers OUT NOCOPY Hdr_Tbl_Type
643 ,X_Msg_Count OUT NOCOPY NUMBER
644 ,X_Msg_Data OUT NOCOPY VARCHAR2
645 ,X_Result out nocopy Gx_Boolean
646 ,X_Return_Status out nocopy Gx_Ret_Sts);
647
648 PROCEDURE Get_All_Contracts
649 (P_API_Version IN NUMBER
650 ,P_Init_Msg_List IN VARCHAR2
651 ,P_Inp_Rec IN Inp_Rec_Type
652 ,X_Return_Status out nocopy VARCHAR2
653 ,X_Msg_Count out nocopy NUMBER
654 ,X_Msg_Data out nocopy VARCHAR2
655 ,X_All_Contracts out nocopy Hdr_Tbl_Type);
656
657 PROCEDURE Get_Contract_Line_Details
658 (P_API_Version IN NUMBER
659 ,P_Init_Msg_List IN VARCHAR2
660 ,P_Cle_Id IN Gx_OKS_Id
661 ,X_Contract_Lines OUT NOCOPY Line_Tbl_Type
662 ,X_Msg_Count OUT NOCOPY NUMBER
663 ,X_Msg_Data OUT NOCOPY VARCHAR2
664 ,X_Result out nocopy Gx_Boolean
665 ,X_Return_Status out nocopy Gx_Ret_Sts);
666
667 PROCEDURE Get_Contract_Details
668 (P_API_Version IN NUMBER
669 ,P_Init_Msg_List IN VARCHAR2
670 ,P_Contract_Line_Id IN NUMBER
671 ,X_Return_Status OUT NOCOPY VARCHAR2
672 ,X_Msg_Count OUT NOCOPY NUMBER
673 ,X_Msg_Data OUT NOCOPY VARCHAR2
674 ,X_All_Lines OUT NOCOPY Line_Tbl_Type);
675
676 PROCEDURE Get_Coverage_Level_Details
677 (P_API_Version IN NUMBER
678 ,P_Init_Msg_List IN VARCHAR2
679 ,P_Cle_Id IN Gx_OKS_Id
680 ,X_Covered_Levels out nocopy Clvl_Tbl_Type
681 ,X_Msg_Count OUT NOCOPY NUMBER
682 ,X_Msg_Data OUT NOCOPY VARCHAR2
683 ,X_Result out nocopy Gx_Boolean
684 ,X_Return_Status out nocopy Gx_Ret_Sts);
685
686 PROCEDURE Get_Coverage_Levels
687 (P_API_Version IN NUMBER
688 ,P_Init_Msg_List IN VARCHAR2
689 ,P_Contract_Line_Id IN NUMBER
690 ,X_Return_Status OUT NOCOPY VARCHAR2
691 ,X_Msg_Count OUT NOCOPY NUMBER
692 ,X_Msg_Data OUT NOCOPY VARCHAR2
693 ,X_Covered_Levels OUT NOCOPY Clvl_Tbl_Type);
694
695 PROCEDURE Get_Coverage_Type_Attribs
696 (P_CVL_Id IN Gx_OKS_Id
697 ,P_Set_ExcepionStack IN Gx_Boolean
698 ,X_Cov_Type_Code out nocopy VARCHAR2
699 ,X_Cov_Type_Meaning out nocopy VARCHAR2
700 ,X_Cov_Type_Description out nocopy VARCHAR2
701 ,X_Cov_Type_Imp_Level out nocopy VARCHAR2
702 ,X_Result out nocopy Gx_Boolean
703 ,X_Return_Status out nocopy Gx_Ret_Sts);
704
705 PROCEDURE Get_Cont_Coverage_Type
706 (P_API_Version IN NUMBER
707 ,P_Init_Msg_List IN VARCHAR2
708 ,P_SVL_Id IN Gx_OKS_Id
709 ,P_Set_ExcepionStack IN Gx_Boolean
710 ,X_Coverage_Type out nocopy CovType_Rec_Type
711 ,X_Msg_Count OUT NOCOPY NUMBER
712 ,X_Msg_Data OUT NOCOPY VARCHAR2
713 ,X_Result out nocopy Gx_Boolean
714 ,X_Return_Status out nocopy Gx_Ret_Sts);
715
716 PROCEDURE Get_Coverage_Type
717 (P_API_Version IN NUMBER
718 ,P_Init_Msg_List IN VARCHAR2
719 ,P_Contract_Line_Id IN NUMBER
720 ,X_Return_Status OUT NOCOPY VARCHAR2
721 ,X_Msg_Count out nocopy NUMBER
722 ,X_Msg_Data out nocopy VARCHAR2
723 ,X_Coverage_Type OUT NOCOPY CovType_Rec_Type);
724
725 PROCEDURE Get_Cont_Preferred_Engineers
726 (P_API_Version IN NUMBER
727 ,P_Init_Msg_List IN VARCHAR2
728 ,P_SVL_Id IN Gx_OKS_Id
729 ,P_business_process_id IN NUMBER -- added for 11.5.9 (patchset I) enhancement # 2467065
730 ,P_request_date IN DATE -- added for 11.5.9 (patchset I) enhancement # 2467065
731 ,P_Set_ExcepionStack IN Gx_Boolean
732 ,X_Pref_Engineers OUT NOCOPY PrfEng_Tbl_Type
733 ,X_Msg_Count OUT NOCOPY NUMBER
734 ,X_Msg_Data OUT NOCOPY VARCHAR2
735 ,X_Result out nocopy Gx_Boolean
736 ,X_Return_Status out nocopy Gx_Ret_Sts);
737
738 PROCEDURE get_preferred_engineers
739 (p_api_version IN Number
740 ,p_init_msg_list IN Varchar2
741 ,p_contract_line_id IN Number
742 ,P_business_process_id IN NUMBER -- added for 11.5.9 (patchset I) enhancement # 2467065
743 ,P_request_date IN DATE -- added for 11.5.9 (patchset I) enhancement # 2467065
744 ,x_return_status out nocopy Varchar2
745 ,x_msg_count out nocopy Number
746 ,x_msg_data out nocopy Varchar2
747 ,x_prf_engineers out nocopy prfeng_tbl_type);
748
749
750 PROCEDURE Get_Contract_Contacts
751 (P_API_Version IN NUMBER
752 ,P_Init_Msg_List IN VARCHAR2
753 ,P_Chr_Id IN Gx_OKS_Id
754 ,P_Cle_Id IN Gx_OKS_Id
755 ,X_Cont_Contacts OUT NOCOPY Ent_Contact_Tbl
756 ,X_Msg_Count OUT NOCOPY NUMBER
757 ,X_Msg_Data OUT NOCOPY VARCHAR2
758 ,X_Result out nocopy Gx_Boolean
759 ,X_Return_Status out nocopy Gx_Ret_Sts);
760
761 PROCEDURE Get_Contacts
762 (P_API_Version IN NUMBER
763 ,P_Init_Msg_List IN VARCHAR2
764 ,P_Contract_Id IN NUMBER
765 ,P_Contract_Line_Id IN NUMBER
766 ,X_Return_Status OUT NOCOPY VARCHAR2
767 ,X_Msg_Count OUT NOCOPY NUMBER
768 ,X_Msg_Data OUT NOCOPY VARCHAR2
769 ,X_Ent_Contacts OUT NOCOPY Ent_Contact_Tbl);
770
771 PROCEDURE Append_ContItem_PlSql_Table
772 (P_Input_Tab IN GT_ContItem_Ref
773 ,P_Append_Tab IN GT_ContItem_Ref
774 ,X_Output_Tab out nocopy GT_ContItem_Ref
775 ,X_Result out nocopy Gx_Boolean
776 ,X_Return_Status out nocopy Gx_Ret_Sts);
777
778 PROCEDURE Get_Item_CovLevels
779 (P_CovItem_Obj_Id IN Gx_OKS_Id
780 ,P_Organization_Id IN NUMBER
781 ,X_Item_CovLevels out nocopy GT_ContItem_Ref
782 ,X_Result out nocopy Gx_Boolean
783 ,X_Return_Status out nocopy Gx_Ret_Sts);
784
785 PROCEDURE Get_Party_CovLevels
786 (P_CovParty_Obj_Id IN Gx_OKS_Id
787 ,X_Party_CovLevels out nocopy GT_ContItem_Ref
788 ,X_Result out nocopy Gx_Boolean
789 ,X_Return_Status out nocopy Gx_Ret_Sts);
790
791 PROCEDURE Get_Customer_CovLevels
792 (P_CovCust_Obj_Id IN Gx_OKS_Id
793 ,X_Party_Id out nocopy Gx_OKS_Id
794 ,X_Customer_CovLevels out nocopy GT_ContItem_Ref
795 ,X_Result out nocopy Gx_Boolean
796 ,X_Return_Status out nocopy Gx_Ret_Sts);
797
798 PROCEDURE Get_Site_CovLevels
799 (P_CovSite_Obj_Id IN Gx_OKS_Id
800 ,P_Org_Id IN NUMBER
801 ,X_Site_CovLevels out nocopy GT_ContItem_Ref
802 ,X_Result out nocopy Gx_Boolean
803 ,X_Return_Status out nocopy Gx_Ret_Sts);
804
805 PROCEDURE Get_System_CovLevels
806 (P_CovSys_Obj_Id IN Gx_OKS_Id
807 ,P_Org_Id IN NUMBER
808 ,X_System_CovLevels out nocopy GT_ContItem_Ref
809 ,X_Result out nocopy Gx_Boolean
810 ,X_Return_Status out nocopy Gx_Ret_Sts);
811
812 -- added procedure Get_All_Parents to fix bug 3583486.
813
814 PROCEDURE Get_All_Parents
815 (
816 p_api_version IN NUMBER,
817 p_commit IN VARCHAR2,
818 p_init_msg_list IN VARCHAR2,
819 p_validation_level IN NUMBER,
820 p_subject_id IN NUMBER,
821 x_rel_tbl OUT NOCOPY ii_relationship_tbl,
822 x_return_status OUT NOCOPY VARCHAR2,
823 x_msg_count OUT NOCOPY NUMBER,
824 x_msg_data OUT NOCOPY VARCHAR2
825 );
826
827 PROCEDURE Get_Product_CovLevels
828 (P_CovProd_Obj_Id IN Gx_OKS_Id
829 ,P_Organization_Id IN NUMBER
830 ,P_Org_Id IN NUMBER
831 ,X_Party_Id out nocopy Gx_OKS_Id
832 ,X_Product_CovLevels out nocopy GT_ContItem_Ref
833 ,X_Result out nocopy Gx_Boolean
834 ,X_Return_Status out nocopy Gx_Ret_Sts);
835
836 PROCEDURE Sort_Asc_ContItem_PlSql_Table
837 (P_Input_Tab IN GT_ContItem_Ref
838 ,X_Output_Tab out nocopy GT_ContItem_Ref
839 ,X_Result out nocopy Gx_Boolean
840 ,X_Return_Status out nocopy Gx_Ret_Sts);
841
842 PROCEDURE Dedup_ContItem_PlSql_Table
843 (P_Input_Tab IN GT_ContItem_Ref
844 ,X_Output_Tab out nocopy GT_ContItem_Ref
845 ,X_Result out nocopy Gx_Boolean
846 ,X_Return_Status out nocopy Gx_Ret_Sts);
847
848 PROCEDURE Get_CovLevel_Contracts
849 (P_CovLevel_Items IN GT_ContItem_Ref
850 ,P_Party_Id IN Gx_OKS_Id
851 ,X_CovLevel_Contracts out nocopy GT_Contract_Ref
852 ,X_Result out nocopy Gx_Boolean
853 ,X_Return_Status out nocopy Gx_Ret_Sts);
854
855 PROCEDURE Get_CovProd_Contracts
856 (P_CovProd_Obj_Id IN Gx_OKS_Id
857 ,P_Organization_Id IN NUMBER
858 ,P_Org_Id IN NUMBER
859 ,X_CovProd_Contracts out nocopy GT_Contract_Ref
860 ,X_Result out nocopy Gx_Boolean
861 ,X_Return_Status out nocopy Gx_Ret_Sts);
862
863 PROCEDURE Get_CovItem_Contracts
864 (P_CovItem_Obj_Id IN Gx_OKS_Id
865 ,P_Organization_Id IN NUMBER
866 ,P_Party_Id IN Gx_OKS_Id
867 ,X_CovItem_Contracts out nocopy GT_Contract_Ref
868 ,X_Result out nocopy Gx_Boolean
869 ,X_Return_Status out nocopy Gx_Ret_Sts);
870
871 PROCEDURE Get_CovSys_Contracts
872 (P_CovSys_Obj_Id IN Gx_OKS_Id
873 ,P_Org_Id IN NUMBER
874 ,X_CovSys_Contracts out nocopy GT_Contract_Ref
875 ,X_Result out nocopy Gx_Boolean
876 ,X_Return_Status out nocopy Gx_Ret_Sts);
877
878 PROCEDURE Get_CovSite_Contracts
879 (P_CovSite_Obj_Id IN Gx_OKS_Id
880 ,P_Org_Id IN NUMBER
881 ,X_CovSite_Contracts out nocopy GT_Contract_Ref
882 ,X_Result out nocopy Gx_Boolean
883 ,X_Return_Status out nocopy Gx_Ret_Sts);
884
885 PROCEDURE Get_CovCust_Contracts
886 (P_CovCust_Obj_Id IN Gx_OKS_Id
887 ,X_CovCust_Contracts out nocopy GT_Contract_Ref
888 ,X_Result out nocopy Gx_Boolean
889 ,X_Return_Status out nocopy Gx_Ret_Sts);
890
891 PROCEDURE Get_CovParty_Contracts
892 (P_CovParty_Obj_Id IN Gx_OKS_Id
893 ,X_CovParty_Contracts out nocopy GT_Contract_Ref
894 ,X_Result out nocopy Gx_Boolean
895 ,X_Return_Status out nocopy Gx_Ret_Sts);
896
897 PROCEDURE Get_CovLvlLine_Contracts
898 (P_CovLvlLine_Id IN Gx_OKS_Id
899 ,X_Contracts out nocopy GT_Contract_Ref
900 ,X_Result out nocopy Gx_Boolean
901 ,X_Return_Status out nocopy Gx_Ret_Sts);
902
903 PROCEDURE Get_Contracts_Id
904 (P_Contract_Num IN VARCHAR2
905 ,P_Contract_Num_Modifier IN VARCHAR2
906 ,X_Contracts out nocopy GT_Contract_Ref
907 ,X_Result out nocopy Gx_Boolean
908 ,X_Return_Status out nocopy Gx_Ret_Sts);
909
910 PROCEDURE Get_Service_Line_Details
911 (P_SrvLine_Id IN Gx_OKS_Id
912 ,P_Organization_Id IN NUMBER
913 ,X_Name out nocopy VARCHAR2
914 ,X_Description out nocopy VARCHAR2
915 ,X_Start_Date out nocopy DATE
916 ,X_End_Date out nocopy DATE
917 ,X_Date_Terminated out nocopy DATE
918 ,X_Eff_End_Date out nocopy DATE
919 ,X_Result out nocopy Gx_Boolean
920 ,X_Return_Status OUT nocopy Gx_Ret_Sts);
921
922 PROCEDURE Get_Coverage_Line_Details
923 (P_SrvLine_Id IN Gx_OKS_Id
924 ,P_Organization_Id IN NUMBER
925 ,X_Cov_Id out nocopy Gx_OKS_Id
926 ,X_Name out nocopy VARCHAR2
927 ,X_Description out nocopy VARCHAR2
928 ,X_Start_Date out nocopy DATE
929 ,X_End_Date out nocopy DATE
930 ,X_Date_Terminated out nocopy DATE
931 ,X_Eff_End_Date out nocopy DATE
932 ,X_Result out nocopy Gx_Boolean
933 ,X_Return_Status OUT nocopy Gx_Ret_Sts);
934
935 PROCEDURE Get_Contracts_01_Format
936 (P_Contracts IN GT_Contract_Ref
937 ,P_Request_Date IN DATE
938 ,P_Validate_Flag IN VARCHAR2
939 ,P_Chr_Id_Flag IN VARCHAR2 --Bug# 4719510 (JVARGHES)
940 ,X_Contracts_01 out nocopy Ent_Cont_Tbl
941 ,X_Result out nocopy Gx_Boolean
942 ,X_Return_Status OUT nocopy Gx_Ret_Sts);
943
944 PROCEDURE Sort_Asc_GetContracts_01
945 (P_Input_Tab IN Ent_Cont_Tbl
946 ,X_Output_Tab out nocopy Ent_Cont_Tbl
947 ,X_Result out nocopy Gx_Boolean
948 ,X_Return_Status out nocopy Gx_Ret_Sts);
949
950 PROCEDURE Get_Contracts_01
951 (P_API_Version IN NUMBER
952 ,P_Init_Msg_List IN VARCHAR2
953 ,P_Inp_Rec IN Inp_Cont_Rec
954 ,X_Return_Status OUT NOCOPY VARCHAR2
955 ,X_Msg_Count OUT NOCOPY NUMBER
956 ,X_Msg_Data OUT NOCOPY VARCHAR2
957 ,X_Ent_Contracts OUT NOCOPY Ent_Cont_Tbl);
958
959 PROCEDURE Get_Contracts
960 (P_API_Version IN NUMBER
961 ,P_Init_Msg_List IN VARCHAR2
962 ,P_Inp_Rec IN Inp_Cont_Rec
963 ,X_Return_Status OUT NOCOPY VARCHAR2
964 ,X_Msg_Count OUT NOCOPY NUMBER
965 ,X_Msg_Data OUT NOCOPY VARCHAR2
966 ,X_Ent_Contracts OUT NOCOPY Ent_Cont_Tbl);
967
968 /*vgujarat - modified for access hour ER 9675504*/
969 PROCEDURE Get_Contracts_02_Format
970 (P_Contracts IN GT_Contract_Ref
971 ,P_BusiProc_Id IN Gx_BusProcess_Id
972 ,P_Severity_Id IN Gx_Severity_Id
973 ,P_Request_TZone_Id IN Gx_TimeZoneId
974 ,P_Dates_In_Input_TZ IN VARCHAR2 -- Added for 12.0 ENT-TZ project (JVARGHES)
975 ,P_Incident_Date IN DATE -- Added for 12.0 ENT-TZ project (JVARGHES)
976 ,P_Request_Date IN DATE
977 ,P_Calc_RespTime_YN IN VARCHAR2
978 ,P_Validate_Eff IN VARCHAR2
979 ,P_Validate_Flag IN VARCHAR2
980 ,P_SrvLine_Flag IN VARCHAR2
981 ,P_Sort_Key IN VARCHAR2
982 ,X_Contracts_02 out nocopy Get_ConTop_Tbl
983 ,X_Result out nocopy Gx_Boolean
984 ,X_Return_Status out nocopy Gx_Ret_Sts
985 ,P_cust_id IN NUMBER DEFAULT NULL
986 ,P_cust_site_id IN NUMBER DEFAULT NULL
987 ,P_cust_loc_id IN NUMBER DEFAULT NULL);
988
989 PROCEDURE Append_Contract_PlSql_Table
990 (P_Input_Tab IN GT_Contract_Ref
991 ,P_Append_Tab IN GT_Contract_Ref
992 ,X_Output_Tab out nocopy GT_Contract_Ref
993 ,X_Result out nocopy Gx_Boolean
994 ,X_Return_Status out nocopy Gx_Ret_Sts);
995
996 PROCEDURE Sort_Asc_GetContracts_02
997 (P_Input_Tab IN Get_ConTop_Tbl
998 ,P_Sort_Key IN VARCHAR2
999 ,X_Output_Tab out nocopy Get_ConTop_Tbl
1000 ,X_Result out nocopy Gx_Boolean
1001 ,X_Return_Status out nocopy Gx_Ret_Sts);
1002
1003 PROCEDURE Get_Contracts_02
1004 (P_API_Version IN NUMBER
1005 ,P_Init_Msg_List IN VARCHAR2
1006 ,P_Inp_Rec IN Inp_rec_getcont02
1007 ,X_Return_Status OUT NOCOPY VARCHAR2
1008 ,X_Msg_Count OUT NOCOPY NUMBER
1009 ,X_Msg_Data OUT NOCOPY VARCHAR2
1010 ,X_Ent_Contracts OUT NOCOPY Get_ConTop_Tbl);
1011
1012 PROCEDURE Get_Contracts
1013 (P_Api_Version IN NUMBER
1014 ,P_Init_Msg_List IN VARCHAR2
1015 ,P_Inp_Rec IN Get_ContIn_Rec
1016 ,X_Return_Status OUT NOCOPY VARCHAR2
1017 ,X_Msg_Count OUT NOCOPY NUMBER
1018 ,X_Msg_Data OUT NOCOPY VARCHAR2
1019 ,X_Ent_Contracts OUT NOCOPY Get_ConTop_Tbl);
1020
1021 PROCEDURE Get_Contracts
1022 (P_Api_Version IN NUMBER
1023 ,P_Init_Msg_List IN VARCHAR2
1024 ,P_Inp_Rec IN Input_Rec_IB
1025 ,X_Return_Status OUT NOCOPY VARCHAR2
1026 ,X_Msg_Count OUT NOCOPY NUMBER
1027 ,X_Msg_Data OUT NOCOPY VARCHAR2
1028 ,X_Ent_Contracts OUT NOCOPY Output_Tbl_IB);
1029
1030 PROCEDURE Sort_Asc_GetContracts_03
1031 (P_Input_Tab IN Output_Tbl_EntFrm
1032 ,X_Output_Tab out nocopy Output_Tbl_EntFrm
1033 ,X_Result out nocopy Gx_Boolean
1034 ,X_Return_Status out nocopy Gx_Ret_Sts);
1035
1036 PROCEDURE Get_Contracts_03_Format
1037 (P_Contracts IN GT_Contract_Ref
1038 ,P_Con_Number IN VARCHAR2
1039 ,P_Con_Number_Modifier IN VARCHAR2
1040 ,P_Con_Customer_Id IN NUMBER
1041 ,P_Service_Item_Id IN NUMBER
1042 ,P_Organization_Id IN NUMBER
1043 ,P_Request_Date IN DATE
1044 ,P_Validate_Eff IN VARCHAR2
1045 ,X_Contracts_03 out nocopy Output_Tbl_EntFrm
1046 ,X_Result out nocopy Gx_Boolean
1047 ,X_Return_Status out nocopy Gx_Ret_Sts);
1048
1049 PROCEDURE Sort_Asc_ContRef_PlSql_Table
1050 (P_Input_Tab IN GT_Contract_Ref
1051 ,X_Output_Tab out nocopy GT_Contract_Ref
1052 ,X_Result out nocopy Gx_Boolean
1053 ,X_Return_Status out nocopy Gx_Ret_Sts);
1054
1055 PROCEDURE Dedup_ContItem_PlSql_Table
1056 (P_Input_Tab IN GT_Contract_Ref
1057 ,X_Output_Tab out nocopy GT_Contract_Ref
1058 ,X_Result out nocopy Gx_Boolean
1059 ,X_Return_Status out nocopy Gx_Ret_Sts);
1060
1061 PROCEDURE Get_Contracts_03
1062 (P_API_Version IN NUMBER
1063 ,P_Init_Msg_List IN VARCHAR2
1064 ,P_Inp_Rec IN Input_Rec_EntFrm
1065 ,X_Return_Status OUT NOCOPY VARCHAR2
1066 ,X_Msg_Count OUT NOCOPY NUMBER
1067 ,X_Msg_Data OUT NOCOPY VARCHAR2
1068 ,X_Ent_Contracts OUT NOCOPY Output_Tbl_EntFrm);
1069
1070 PROCEDURE Get_Contracts
1071 (P_API_Version IN NUMBER
1072 ,P_Init_Msg_List IN VARCHAR2
1073 ,P_Inp_Rec IN Input_Rec_EntFrm
1074 ,X_Return_Status OUT NOCOPY VARCHAR2
1075 ,X_Msg_Count OUT NOCOPY NUMBER
1076 ,X_Msg_Data OUT NOCOPY VARCHAR2
1077 ,X_Ent_Contracts OUT NOCOPY Output_Tbl_EntFrm);
1078
1079 PROCEDURE Get_Prof_Service_Name_And_Desc
1080 (P_Profile_Value IN VARCHAR2
1081 ,P_Db_Srv_Name IN VARCHAR2
1082 ,P_Db_Srv_Desc IN VARCHAR2
1083 ,X_Prof_Srv_Name out nocopy VARCHAR2
1084 ,X_Prof_Srv_Desc out nocopy VARCHAR2
1085 ,X_Result out nocopy Gx_Boolean
1086 ,X_Return_Status OUT nocopy Gx_Ret_Sts);
1087
1088 FUNCTION Get_End_Date_Time
1089 (P_Date_Value IN DATE) Return Date;
1090
1091 PROCEDURE Get_HighImp_CP_Contract
1092 (P_API_Version IN NUMBER
1093 ,P_Init_Msg_List IN VARCHAR2
1094 ,P_Customer_product_Id IN NUMBER
1095 ,X_Return_Status OUT NOCOPY VARCHAR2
1096 ,X_Msg_Count out nocopy NUMBER
1097 ,X_Msg_Data out nocopy VARCHAR2
1098 ,X_Importance_Lvl OUT NOCOPY OKS_ENTITLEMENTS_PUB.High_Imp_level_K_rec);
1099
1100 FUNCTION Get_Final_End_Date(
1101 P_Contract_Id IN number,
1102 P_Enddate IN DATE) Return Date;
1103
1104 PROCEDURE OKS_VALIDATE_SYSTEM
1105 (P_API_Version IN NUMBER
1106 ,P_Init_Msg_List IN VARCHAR2
1107 ,P_System_Id IN NUMBER
1108 ,P_Request_Date IN DATE
1109 ,P_Update_Only_Check IN VARCHAR2
1110 ,X_Return_Status OUT NOCOPY VARCHAR2
1111 ,X_Msg_Count out nocopy NUMBER
1112 ,X_Msg_Data out nocopy VARCHAR2
1113 ,X_System_Valid OUT NOCOPY VARCHAR2);
1114
1115 PROCEDURE Get_CSI_LatestEdDtdKLines_02
1116 (P_Input_Tab IN Get_ConTop_Tbl
1117 ,X_Output_Tab out nocopy Get_ConTop_Tbl
1118 ,X_Result out nocopy Gx_Boolean
1119 ,X_Return_Status out nocopy Gx_Ret_Sts);
1120
1121 PROCEDURE Sort_CSI_KLineId_02
1122 (P_Input_Tab IN Get_ConTop_Tbl
1123 ,X_Output_Tab out nocopy Get_ConTop_Tbl
1124 ,X_Result out nocopy Gx_Boolean
1125 ,X_Return_Status out nocopy Gx_Ret_Sts);
1126
1127 PROCEDURE Dedup_CSICP_KLine_PlSql_Table
1128 (P_Input_Tab IN GT_Contract_Ref
1129 ,X_Output_Tab out nocopy GT_Contract_Ref
1130 ,X_Result out nocopy Gx_Boolean
1131 ,X_Return_Status out nocopy Gx_Ret_Sts);
1132
1133 PROCEDURE Get_Sort_CSI_ImpLvl
1134 (P_Contracts IN Get_ConTop_Tbl
1135 ,X_Contracts_02 out nocopy Get_ConTop_Tbl
1136 ,X_Result out nocopy Gx_Boolean
1137 ,X_Return_Status out nocopy Gx_Ret_Sts);
1138
1139 PROCEDURE Default_Contline_System
1140 (P_API_Version IN NUMBER
1141 ,P_Init_Msg_List IN VARCHAR2
1142 ,P_System_Id IN NUMBER
1143 ,P_Request_Date IN DATE
1144 ,X_Return_Status OUT NOCOPY VARCHAR2
1145 ,X_Msg_Count out nocopy NUMBER
1146 ,X_Msg_Data out nocopy VARCHAR2
1147 ,X_Ent_Contracts OUT NOCOPY Default_Contline_System_Rec);
1148
1149 /*vgujarat - modified for access hour ER 9675504*/
1150 PROCEDURE Get_Cont02Format_Validation
1151 (P_Contracts IN Idx_Rec
1152 ,P_BusiProc_Id IN Gx_BusProcess_Id
1153 ,P_Severity_Id IN Gx_Severity_Id
1154 ,P_Request_TZone_Id IN Gx_TimeZoneId
1155 ,P_Dates_In_Input_TZ IN VARCHAR2 -- Added for 12.0 ENT-TZ project (JVARGHES)
1156 ,P_Incident_Date IN DATE -- Added for 12.0 ENT-TZ project (JVARGHES)
1157 ,P_Request_Date IN DATE
1158 ,P_Request_Date_Start IN DATE
1159 ,P_Request_Date_End IN DATE
1160 ,P_Calc_RespTime_YN IN VARCHAR2
1161 ,P_Validate_Eff IN VARCHAR2
1162 ,P_Validate_Flag IN VARCHAR2
1163 ,P_SrvLine_Flag IN VARCHAR2
1164 ,P_Sort_Key IN VARCHAR2
1165 ,X_Contracts_02 out nocopy Get_ConTop_Tbl
1166 ,X_Result out nocopy Gx_Boolean
1167 ,X_Return_Status out nocopy Gx_Ret_Sts
1168 ,P_cust_id IN NUMBER DEFAULT NULL
1169 ,P_cust_site_id IN NUMBER DEFAULT NULL
1170 ,P_cust_loc_id IN NUMBER DEFAULT NULL);
1171
1172 procedure Get_cov_txn_groups
1173 (p_api_version IN Number
1174 ,p_init_msg_list IN Varchar2
1175 ,p_inp_rec_bp IN INP_REC_BP
1176 ,x_return_status OUT NOCOPY Varchar2
1177 ,x_msg_count OUT NOCOPY Number
1178 ,x_msg_data OUT NOCOPY Varchar2
1179 ,x_cov_txn_grp_lines out nocopy OUTPUT_TBL_BP);
1180
1181 PROCEDURE Get_txn_billing_types
1182 (p_api_version IN Number
1183 ,p_init_msg_list IN Varchar2
1184 ,p_cov_txngrp_line_id IN number
1185 ,p_return_bill_rates_YN IN Varchar2
1186 ,x_return_status OUT NOCOPY Varchar2
1187 ,x_msg_count OUT NOCOPY Number
1188 ,x_msg_data OUT NOCOPY Varchar2
1189 ,x_txn_bill_types OUT NOCOPY output_tbl_bt
1190 ,x_txn_bill_rates out nocopy output_tbl_br);
1191
1192 PROCEDURE Search_Contracts_01_Format
1193 (P_Contracts IN GT_Contract_Ref
1194 ,P_Contract_rec IN inp_cont_rec_type
1195 ,P_Request_Date IN DATE
1196 ,P_Contract_Id IN NUMBER
1197 ,P_Validate_Eff IN VARCHAR2
1198 ,P_Validate_Flag IN VARCHAR2
1199 ,P_SrvLine_Flag IN VARCHAR2
1200 ,P_Sort_Key IN VARCHAR2
1201 ,X_Contracts_02 out nocopy Output_Tbl_Contract
1202 ,X_Result out nocopy Gx_Boolean
1203 ,X_Return_Status out nocopy Gx_Ret_Sts);
1204
1205 PROCEDURE Search_Contracts
1206 (p_api_version IN Number
1207 ,p_init_msg_list IN Varchar2
1208 ,p_contract_rec IN inp_cont_rec_type
1209 ,p_clvl_id_tbl IN covlvl_id_tbl
1210 ,x_return_status out nocopy Varchar2
1211 ,x_msg_count out nocopy Number
1212 ,x_msg_data out nocopy Varchar2
1213 ,x_contract_tbl out nocopy output_tbl_contract);
1214
1215 PROCEDURE Get_Contracts_Expiration
1216 (p_api_version IN Number
1217 ,p_init_msg_list IN Varchar2
1218 ,p_contract_id IN Number
1219 ,x_return_status out nocopy Varchar2
1220 ,x_msg_count out nocopy Number
1221 ,x_msg_data out nocopy Varchar2
1222 ,x_contract_end_date out nocopy date
1223 ,x_Contract_Grace_Duration out nocopy number
1224 ,x_Contract_Grace_Period out nocopy VARCHAR2);
1225
1226 PROCEDURE Get_Service_PO
1227 (P_CHR_Id IN Gx_OKS_Id
1228 ,P_Set_ExcepionStack IN Gx_Boolean
1229 ,X_Service_PO out nocopy VARCHAR2
1230 ,X_Service_PO_required out nocopy VARCHAR2
1231 ,X_Result out nocopy Gx_Boolean
1232 ,X_Return_Status out nocopy Gx_Ret_Sts);
1233
1234 PROCEDURE Get_Contract_Grace
1235 (P_Contract_Id IN number
1236 ,P_Set_ExcepionStack IN Gx_Boolean
1237 ,x_grace_period OUT NOCOPY varchar2
1238 ,x_grace_duration OUT NOCOPY number
1239 ,X_Result out nocopy Gx_Boolean
1240 ,X_Return_Status out nocopy Gx_Ret_Sts) ;
1241
1242 PROCEDURE VALIDATE_CONTRACT_LINE
1243 (p_api_version IN NUMBER
1244 ,p_init_msg_list IN VARCHAR2
1245 ,p_contract_line_id IN NUMBER
1246 ,p_busiproc_id IN NUMBER
1247 ,p_request_date IN DATE
1248 ,p_covlevel_tbl_in IN covlevel_tbl_type
1249 ,p_verify_combination IN VARCHAR2
1250 ,x_return_status OUT nocopy Varchar2
1251 ,x_msg_count OUT nocopy Number
1252 ,x_msg_data OUT nocopy Varchar2
1253 ,x_covlevel_tbl_out OUT NOCOPY covlevel_tbl_type
1254 ,x_combination_valid OUT NOCOPY VARCHAR2);
1255
1256 FUNCTION Get_NLS_day_of_week(
1257 P_day_of_week IN Varchar2) Return Varchar2;
1258
1259 PROCEDURE Get_BP_CoverTimeZone_Line
1260 (P_BPL_Id IN Gx_OKS_Id
1261 ,P_Set_ExcepionStack IN Gx_Boolean
1262 ,X_BP_CVTLine_Id out nocopy Gx_OKS_Id
1263 ,X_BP_Tz_Id out nocopy Gx_TimeZoneId
1264 ,X_Result out nocopy Gx_Boolean
1265 ,X_Return_Status out nocopy Gx_Ret_Sts);
1266
1267 PROCEDURE Search_Contract_lines
1268 (p_api_version IN Number
1269 ,p_init_msg_list IN Varchar2
1270 ,p_contract_rec IN srchline_inpcontrec_type
1271 ,p_contract_line_rec IN srchline_inpcontlinerec_type
1272 ,p_clvl_id_tbl IN srchline_covlvl_id_tbl
1273 ,x_return_status out nocopy Varchar2
1274 ,x_msg_count out nocopy Number
1275 ,x_msg_data out nocopy Varchar2
1276 ,x_contract_tbl out nocopy output_tbl_contractline);
1277
1278 -- Bug# 4899844
1279 FUNCTION Get_BPL_Offset_Start_Date
1280 (P_SVL_Start_Date IN DATE
1281 ,P_Offset_Timeunit IN VARCHAR2
1282 ,P_Offset_Duration IN NUMBER) RETURN DATE;
1283
1284 --
1285
1286 END OKS_ENTITLEMENTS_PVT;
1287