eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKS_PM_ENTITLEMENTS_PVT dependencies on OKS_ENTITLEMENTS_PVT

Line 4: (P_Contracts IN OKS_ENTITLEMENTS_PVT.GT_Contract_Ref

1: PACKAGE BODY OKS_PM_ENTITLEMENTS_PVT AS
2: /* $Header: OKSRPMEB.pls 120.5 2006/07/10 13:15:30 jvorugan noship $ */
3: PROCEDURE Get_PMContracts_02_Format
4: (P_Contracts IN OKS_ENTITLEMENTS_PVT.GT_Contract_Ref
5: ,P_BusiProc_Id IN Gx_BusProcess_Id
6: ,P_Severity_Id IN Gx_Severity_Id
7: ,P_Request_TZone_Id IN Gx_TimeZoneId
8: ,P_Request_Date IN DATE

Line 38: ,OKS_ENTITLEMENTS_PVT.Get_End_Date_Time(SV.End_Date) SV_End_Date

34: ,HD.Inv_Organization_Id
35: ,HD.End_Date HDR_End_Date --grace period changes
36: ,SV.Id Service_Line_Id
37: ,SV.Start_Date SV_Start_Date
38: ,OKS_ENTITLEMENTS_PVT.Get_End_Date_Time(SV.End_Date) SV_End_Date
39: ,OKS_ENTITLEMENTS_PVT.Get_End_Date_Time(SV.Date_Terminated) SV_Date_Terminated
40: ,CL.Sts_Code CL_Sts_Code
41: ,CL.Id CovLvl_Line_Id
42: ,CL.Start_Date CL_Start_Date

Line 39: ,OKS_ENTITLEMENTS_PVT.Get_End_Date_Time(SV.Date_Terminated) SV_Date_Terminated

35: ,HD.End_Date HDR_End_Date --grace period changes
36: ,SV.Id Service_Line_Id
37: ,SV.Start_Date SV_Start_Date
38: ,OKS_ENTITLEMENTS_PVT.Get_End_Date_Time(SV.End_Date) SV_End_Date
39: ,OKS_ENTITLEMENTS_PVT.Get_End_Date_Time(SV.Date_Terminated) SV_Date_Terminated
40: ,CL.Sts_Code CL_Sts_Code
41: ,CL.Id CovLvl_Line_Id
42: ,CL.Start_Date CL_Start_Date
43: ,OKS_ENTITLEMENTS_PVT.Get_End_Date_Time(CL.End_Date) CL_End_Date

Line 43: ,OKS_ENTITLEMENTS_PVT.Get_End_Date_Time(CL.End_Date) CL_End_Date

39: ,OKS_ENTITLEMENTS_PVT.Get_End_Date_Time(SV.Date_Terminated) SV_Date_Terminated
40: ,CL.Sts_Code CL_Sts_Code
41: ,CL.Id CovLvl_Line_Id
42: ,CL.Start_Date CL_Start_Date
43: ,OKS_ENTITLEMENTS_PVT.Get_End_Date_Time(CL.End_Date) CL_End_Date
44: ,OKS_ENTITLEMENTS_PVT.Get_End_Date_Time(CL.Date_Terminated) CL_Date_Terminated
45: -- ,DECODE(SV.Lse_Id,14,'Y','N') Warranty_Flag
46: ,DECODE(SV.Lse_Id, 14, 'Y', 15, 'Y', 16, 'Y', 17, 'Y', 18, 'Y', 'N') Warranty_Flag
47: ,okscov.pm_program_id PM_Program_Id --rul.object1_id1 PM_Program_Id

Line 44: ,OKS_ENTITLEMENTS_PVT.Get_End_Date_Time(CL.Date_Terminated) CL_Date_Terminated

40: ,CL.Sts_Code CL_Sts_Code
41: ,CL.Id CovLvl_Line_Id
42: ,CL.Start_Date CL_Start_Date
43: ,OKS_ENTITLEMENTS_PVT.Get_End_Date_Time(CL.End_Date) CL_End_Date
44: ,OKS_ENTITLEMENTS_PVT.Get_End_Date_Time(CL.Date_Terminated) CL_Date_Terminated
45: -- ,DECODE(SV.Lse_Id,14,'Y','N') Warranty_Flag
46: ,DECODE(SV.Lse_Id, 14, 'Y', 15, 'Y', 16, 'Y', 17, 'Y', 18, 'Y', 'N') Warranty_Flag
47: ,okscov.pm_program_id PM_Program_Id --rul.object1_id1 PM_Program_Id
48: ,okscov.pm_sch_exists_yn PM_Schedule_Exists --rul.rule_information2 PM_Schedule_Exists

Line 118: ,OKS_ENTITLEMENTS_PVT.Get_End_Date_Time(SV.End_Date) SV_End_Date

114: ,HD.Inv_Organization_Id
115: ,HD.End_Date HDR_End_Date --grace period changes
116: ,SV.Id Service_Line_Id
117: ,SV.Start_Date SV_Start_Date
118: ,OKS_ENTITLEMENTS_PVT.Get_End_Date_Time(SV.End_Date) SV_End_Date
119: ,OKS_ENTITLEMENTS_PVT.Get_End_Date_Time(SV.Date_Terminated) SV_Date_Terminated
120: ,CL.Sts_Code CL_Sts_Code
121: ,CL.Id CovLvl_Line_Id
122: ,CL.Start_Date CL_Start_Date

Line 119: ,OKS_ENTITLEMENTS_PVT.Get_End_Date_Time(SV.Date_Terminated) SV_Date_Terminated

115: ,HD.End_Date HDR_End_Date --grace period changes
116: ,SV.Id Service_Line_Id
117: ,SV.Start_Date SV_Start_Date
118: ,OKS_ENTITLEMENTS_PVT.Get_End_Date_Time(SV.End_Date) SV_End_Date
119: ,OKS_ENTITLEMENTS_PVT.Get_End_Date_Time(SV.Date_Terminated) SV_Date_Terminated
120: ,CL.Sts_Code CL_Sts_Code
121: ,CL.Id CovLvl_Line_Id
122: ,CL.Start_Date CL_Start_Date
123: ,OKS_ENTITLEMENTS_PVT.Get_End_Date_Time(CL.End_Date) CL_End_Date

Line 123: ,OKS_ENTITLEMENTS_PVT.Get_End_Date_Time(CL.End_Date) CL_End_Date

119: ,OKS_ENTITLEMENTS_PVT.Get_End_Date_Time(SV.Date_Terminated) SV_Date_Terminated
120: ,CL.Sts_Code CL_Sts_Code
121: ,CL.Id CovLvl_Line_Id
122: ,CL.Start_Date CL_Start_Date
123: ,OKS_ENTITLEMENTS_PVT.Get_End_Date_Time(CL.End_Date) CL_End_Date
124: ,OKS_ENTITLEMENTS_PVT.Get_End_Date_Time(CL.Date_Terminated) CL_Date_Terminated
125: ,DECODE(SV.Lse_Id, 14, 'Y', 15, 'Y', 16, 'Y', 17, 'Y', 18, 'Y', 'N') Warranty_Flag
126: ,okssrv.pm_program_id PM_Program_Id --rul.object1_id1 PM_Program_Id
127: ,okssrv.pm_sch_exists_yn PM_Schedule_Exists --rul.rule_information2 PM_Schedule_Exists

Line 124: ,OKS_ENTITLEMENTS_PVT.Get_End_Date_Time(CL.Date_Terminated) CL_Date_Terminated

120: ,CL.Sts_Code CL_Sts_Code
121: ,CL.Id CovLvl_Line_Id
122: ,CL.Start_Date CL_Start_Date
123: ,OKS_ENTITLEMENTS_PVT.Get_End_Date_Time(CL.End_Date) CL_End_Date
124: ,OKS_ENTITLEMENTS_PVT.Get_End_Date_Time(CL.Date_Terminated) CL_Date_Terminated
125: ,DECODE(SV.Lse_Id, 14, 'Y', 15, 'Y', 16, 'Y', 17, 'Y', 18, 'Y', 'N') Warranty_Flag
126: ,okssrv.pm_program_id PM_Program_Id --rul.object1_id1 PM_Program_Id
127: ,okssrv.pm_sch_exists_yn PM_Schedule_Exists --rul.rule_information2 PM_Schedule_Exists
128: FROM Okc_K_Headers_ALL_B HD -- Modified for 12.0 MOAC project (JVARGHES)

Line 229: Lx_Contracts OKS_ENTITLEMENTS_PVT.GT_Contract_Ref DEFAULT P_Contracts;

225:
226: --
227: --
228:
229: Lx_Contracts OKS_ENTITLEMENTS_PVT.GT_Contract_Ref DEFAULT P_Contracts;
230: Ld_Request_Date CONSTANT DATE := P_Request_Date;
231: Ld_Request_Date_Start CONSTANT DATE := P_Request_Date_Start;
232: Ld_Request_Date_End CONSTANT DATE := P_Request_Date_End;
233: Lv_Validate_Flag VARCHAR2(1) := P_Validate_Flag;

Line 250: Lx_Idx_Rec OKS_ENTITLEMENTS_PVT.Idx_Rec;

246: Lx_Activities_02 OKS_PM_ENTITLEMENTS_PUB.Get_Activityop_Tbl;
247: Lx_Contracts_02_out OKS_ENTITLEMENTS_PUB.Get_ConTop_Tbl;
248: Lx_Contracts_02_Val OKS_ENTITLEMENTS_PUB.Get_ConTop_Tbl;
249:
250: Lx_Idx_Rec OKS_ENTITLEMENTS_PVT.Idx_Rec;
251:
252: Lx_Result Gx_Boolean DEFAULT G_TRUE;
253: Lx_Return_Status Gx_Ret_Sts DEFAULT G_RET_STS_SUCCESS;
254:

Line 309: OKS_ENTITLEMENTS_PVT.Get_Cont02Format_Validation

305: Lx_Idx_Rec.CL_Start_Date := Idx.CL_Start_Date;
306: Lx_Idx_Rec.CL_End_Date := Idx.CL_End_Date;
307: Lx_Idx_Rec.CL_Date_Terminated := Idx.CL_Date_Terminated;
308: Lx_Idx_Rec.Warranty_Flag := Idx.Warranty_Flag;
309: OKS_ENTITLEMENTS_PVT.Get_Cont02Format_Validation
310: (P_Contracts => Lx_Idx_Rec
311: ,P_BusiProc_Id => Lx_BusiProc_Id
312: ,P_Severity_Id => Lx_Severity_Id
313: ,P_Request_TZone_Id => Lx_Request_TZone_Id

Line 415: OKS_ENTITLEMENTS_PVT.Sort_Asc_GetContracts_02

411: -- above IF commented and new one introduced , as sorting needs to be done when calculate response time flag
412: -- is 'Y' or sort key is sorting with importance level.
413: IF (((Lv_Calc_RespTime_YN = 'N') AND (Lv_Sort_Key = 'COVTYP_IMP')) OR (Lv_Calc_RespTime_YN = 'Y')) THEN
414:
415: OKS_ENTITLEMENTS_PVT.Sort_Asc_GetContracts_02
416: (P_Input_Tab => Lx_Contracts_02
417: ,P_Sort_Key => Lv_Sort_Key
418: ,X_Output_Tab => Lx_Contracts_02_Out
419: ,X_Result => Lx_Result

Line 474: ,P_Inp_Rec IN OKS_ENTITLEMENTS_PVT.Inp_rec_getcont02

470: --ph 2
471: PROCEDURE Get_PMContracts_02
472: (P_API_Version IN NUMBER
473: ,P_Init_Msg_List IN VARCHAR2
474: ,P_Inp_Rec IN OKS_ENTITLEMENTS_PVT.Inp_rec_getcont02
475: ,X_Return_Status out nocopy VARCHAR2
476: ,X_Msg_Count out nocopy NUMBER
477: ,X_Msg_Data out nocopy VARCHAR2
478: ,X_Ent_Contracts out nocopy OKS_ENTITLEMENTS_PUB.Get_ConTop_Tbl

Line 487: Lx_Inp_Rec CONSTANT OKS_ENTITLEMENTS_PVT.Inp_rec_getcont02 := P_Inp_Rec;

483: SELECT Dnz_Chr_Id
484: FROM Okc_K_lines_B
485: WHERE Id = Cx_SrvLine_Id;
486:
487: Lx_Inp_Rec CONSTANT OKS_ENTITLEMENTS_PVT.Inp_rec_getcont02 := P_Inp_Rec;
488: Lx_Return_Status Gx_Ret_Sts DEFAULT G_RET_STS_SUCCESS;
489: Lx_Result Gx_Boolean DEFAULT G_TRUE;
490:
491: Lx_Ent_Contracts OKS_ENTITLEMENTS_PUB.Get_ConTop_Tbl;

Line 494: Lx_Contracts OKS_ENTITLEMENTS_PVT.GT_Contract_Ref;

490:
491: Lx_Ent_Contracts OKS_ENTITLEMENTS_PUB.Get_ConTop_Tbl;
492: --ph2
493: Lx_PM_Activities OKS_PM_ENTITLEMENTS_PUB.Get_Activityop_tbl;
494: Lx_Contracts OKS_ENTITLEMENTS_PVT.GT_Contract_Ref;
495: Lx_Contracts_Temp OKS_ENTITLEMENTS_PVT.GT_Contract_Ref;
496: Lx_Contracts_out OKS_ENTITLEMENTS_PVT.GT_Contract_Ref;
497: Lv_SrvLine_Flag VARCHAR2(1):= 'F';
498:

Line 495: Lx_Contracts_Temp OKS_ENTITLEMENTS_PVT.GT_Contract_Ref;

491: Lx_Ent_Contracts OKS_ENTITLEMENTS_PUB.Get_ConTop_Tbl;
492: --ph2
493: Lx_PM_Activities OKS_PM_ENTITLEMENTS_PUB.Get_Activityop_tbl;
494: Lx_Contracts OKS_ENTITLEMENTS_PVT.GT_Contract_Ref;
495: Lx_Contracts_Temp OKS_ENTITLEMENTS_PVT.GT_Contract_Ref;
496: Lx_Contracts_out OKS_ENTITLEMENTS_PVT.GT_Contract_Ref;
497: Lv_SrvLine_Flag VARCHAR2(1):= 'F';
498:
499: Ln_Organization_Id NUMBER;

Line 496: Lx_Contracts_out OKS_ENTITLEMENTS_PVT.GT_Contract_Ref;

492: --ph2
493: Lx_PM_Activities OKS_PM_ENTITLEMENTS_PUB.Get_Activityop_tbl;
494: Lx_Contracts OKS_ENTITLEMENTS_PVT.GT_Contract_Ref;
495: Lx_Contracts_Temp OKS_ENTITLEMENTS_PVT.GT_Contract_Ref;
496: Lx_Contracts_out OKS_ENTITLEMENTS_PVT.GT_Contract_Ref;
497: Lv_SrvLine_Flag VARCHAR2(1):= 'F';
498:
499: Ln_Organization_Id NUMBER;
500: Ln_Org_Id NUMBER;

Line 513: OKS_ENTITLEMENTS_PVT.G_GRACE_PROFILE_SET := fnd_profile.value('OKS_ENABLE_GRACE_PERIOD');

509: -- Bug# 4735542
510: -- Ln_Organization_Id := SYS_CONTEXT('OKC_CONTEXT','ORGANIZATION_ID');
511: -- Ln_Org_Id := SYS_CONTEXT('OKC_CONTEXT','ORG_ID');
512:
513: OKS_ENTITLEMENTS_PVT.G_GRACE_PROFILE_SET := fnd_profile.value('OKS_ENABLE_GRACE_PERIOD');
514:
515: IF Lx_Inp_Rec.Service_Line_Id IS NOT NULL THEN
516:
517: OPEN Lx_SrvLine(Lx_Inp_Rec.Service_Line_Id);

Line 529: OKS_ENTITLEMENTS_PVT.Get_Contracts_Id

525: Lv_SrvLine_Flag := 'T';
526:
527: ELSIF Lx_Inp_Rec.Contract_Number IS NOT NULL THEN
528:
529: OKS_ENTITLEMENTS_PVT.Get_Contracts_Id
530: (P_Contract_Num => Lx_Inp_Rec.Contract_Number
531: ,P_Contract_Num_Modifier => Lx_Inp_Rec.Contract_Number_Modifier
532: ,X_Contracts => Lx_Contracts
533: ,X_Result => Lx_Result

Line 542: OKS_ENTITLEMENTS_PVT.Get_CovProd_Contracts

538: END IF;
539:
540: ELSIF Lx_Inp_Rec.Product_Id IS NOT NULL THEN
541:
542: OKS_ENTITLEMENTS_PVT.Get_CovProd_Contracts
543: (P_CovProd_Obj_Id => Lx_Inp_Rec.Product_Id
544: ,P_Organization_Id => Ln_Organization_Id
545: ,P_Org_Id => Ln_Org_Id
546: ,X_CovProd_Contracts => Lx_Contracts

Line 559: OKS_ENTITLEMENTS_PVT.Get_CovItem_Contracts

555: ELSE
556:
557: IF Lx_Inp_Rec.Item_Id IS NOT NULL THEN
558:
559: OKS_ENTITLEMENTS_PVT.Get_CovItem_Contracts
560: (P_CovItem_Obj_Id => Lx_Inp_Rec.Item_Id
561: ,P_Organization_Id => Ln_Organization_Id
562: ,P_Party_Id => Lx_Inp_Rec.Party_Id
563: ,X_CovItem_Contracts => Lx_Contracts

Line 576: OKS_ENTITLEMENTS_PVT.Get_CovParty_Contracts

572: END IF;
573:
574: IF Lx_Inp_Rec.Party_Id IS NOT NULL THEN
575:
576: OKS_ENTITLEMENTS_PVT.Get_CovParty_Contracts
577: (P_CovParty_Obj_Id => Lx_Inp_Rec.Party_Id
578: ,X_CovParty_Contracts => Lx_Contracts_Temp
579: ,X_Result => Lx_Result
580: ,X_Return_Status => Lx_Return_Status);

Line 590: OKS_ENTITLEMENTS_PVT.Append_Contract_PlSql_Table

586: END IF;
587:
588: END IF;
589:
590: OKS_ENTITLEMENTS_PVT.Append_Contract_PlSql_Table
591: (P_Input_Tab => Lx_Contracts_Temp
592: ,P_Append_Tab => Lx_Contracts
593: ,X_Output_Tab => Lx_Contracts_Out
594: ,X_Result => Lx_Result

Line 666: Lx_ContInp_Rec OKS_ENTITLEMENTS_PVT.Inp_rec_getCont02;

662: ,x_pm_activities out nocopy OKS_PM_ENTITLEMENTS_PUB.get_activityop_tbl)
663: IS
664:
665: Lx_Inp_Rec Get_pmContIn_Rec := P_Inp_Rec;
666: Lx_ContInp_Rec OKS_ENTITLEMENTS_PVT.Inp_rec_getCont02;
667:
668: BEGIN
669:
670: -- Bug# 4735542