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_ENTITLEMENTS_PVT dependencies on OKS_ENTITLEMENTS_PVT

Line 1: PACKAGE BODY OKS_ENTITLEMENTS_PVT AS

1: PACKAGE BODY OKS_ENTITLEMENTS_PVT AS
2: /* $Header: OKSRENTB.pls 120.35.12020000.10 2013/05/16 10:01:31 mchandak ship $ */
3:
4: covd_account_party_id VARCHAR2(40) := NULL; -- 4690940
5: set_account_party_id VARCHAR2(1) := 'F'; -- 4690940

Line 6974: and trunc(nvl(Ld_Request_Date,sysdate)) <= trunc(oks_entitlements_pvt.get_final_end_date(bpl.dnz_chr_id,bpl.end_date)) -- uptake grace period

6970: AND BPL.Lse_Id IN (3,16,21)
6971: and bpl.id = cimbp.cle_id
6972: and cimbp.object1_id1 = nvl(p_business_process_id,cimbp.object1_id1)
6973: AND trunc(nvl(Ld_Request_Date,sysdate)) >= trunc(bpl.start_date)
6974: and trunc(nvl(Ld_Request_Date,sysdate)) <= trunc(oks_entitlements_pvt.get_final_end_date(bpl.dnz_chr_id,bpl.end_date)) -- uptake grace period
6975: AND ROL.Cle_Id = BPL.Id
6976: AND CON.Cpl_Id = ROL.Id
6977: AND CON.Jtot_Object1_Code = 'OKX_RESOURCE'
6978: AND RSC.resource_id = CON.Object1_Id1

Line 7213: ld_bpl_end := oks_entitlements_pvt.get_final_end_date(idx.ksl_dnz_chr_id,Ld_BPL_End );

7209: Ld_BPL_End := Idx.BPL_End_Date;
7210:
7211: END IF;
7212:
7213: ld_bpl_end := oks_entitlements_pvt.get_final_end_date(idx.ksl_dnz_chr_id,Ld_BPL_End );
7214:
7215: --
7216:
7217: IF trunc(nvl(Ld_Request_Date,sysdate)) between trunc(Ld_BPL_Start) and trunc(ld_bpl_end) then -- Added for Coverage Rearch project (JVARGHES)

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

16540: i := 0;
16541: Lx_Result := G_TRUE;
16542: Lx_Return_Status := G_RET_STS_SUCCESS;
16543:
16544: OKS_ENTITLEMENTS_PVT.G_GRACE_PROFILE_SET := fnd_profile.value('OKS_ENABLE_GRACE_PERIOD');
16545:
16546: IF OKS_ENTITLEMENTS_PVT.G_GRACE_PROFILE_SET = 'Y' THEN
16547: FOR Hdr_rec in cur_hdr (p_inp_rec_bp.contract_line_id) LOOP
16548: HDR := Hdr_rec;

Line 16546: IF OKS_ENTITLEMENTS_PVT.G_GRACE_PROFILE_SET = 'Y' THEN

16542: Lx_Return_Status := G_RET_STS_SUCCESS;
16543:
16544: OKS_ENTITLEMENTS_PVT.G_GRACE_PROFILE_SET := fnd_profile.value('OKS_ENABLE_GRACE_PERIOD');
16545:
16546: IF OKS_ENTITLEMENTS_PVT.G_GRACE_PROFILE_SET = 'Y' THEN
16547: FOR Hdr_rec in cur_hdr (p_inp_rec_bp.contract_line_id) LOOP
16548: HDR := Hdr_rec;
16549: END LOOP;
16550: END IF;

Line 16591: IF OKS_ENTITLEMENTS_PVT.G_GRACE_PROFILE_SET = 'Y' THEN

16587: -- x_cov_txn_grp_lines(i).start_date := l_bp_out.start_date; -- Modified for 12.0 Coverage Rearch project (JVARGHES)
16588: x_cov_txn_grp_lines(i).start_date := Ld_BPL_Start_date; -- Modified for 12.0 Coverage Rearch project (JVARGHES)
16589:
16590:
16591: IF OKS_ENTITLEMENTS_PVT.G_GRACE_PROFILE_SET = 'Y' THEN
16592: IF (trunc(HDR.end_date) = trunc(l_bp_out.end_date)) then
16593: x_cov_txn_grp_lines(i).end_date := OKS_ENTITLEMENTS_PVT.Get_Final_End_Date(l_bp_out.dnz_chr_id,
16594: l_bp_out.end_date);
16595: ELSE

Line 16593: x_cov_txn_grp_lines(i).end_date := OKS_ENTITLEMENTS_PVT.Get_Final_End_Date(l_bp_out.dnz_chr_id,

16589:
16590:
16591: IF OKS_ENTITLEMENTS_PVT.G_GRACE_PROFILE_SET = 'Y' THEN
16592: IF (trunc(HDR.end_date) = trunc(l_bp_out.end_date)) then
16593: x_cov_txn_grp_lines(i).end_date := OKS_ENTITLEMENTS_PVT.Get_Final_End_Date(l_bp_out.dnz_chr_id,
16594: l_bp_out.end_date);
16595: ELSE
16596: x_cov_txn_grp_lines(i).end_date := l_bp_out.end_date;
16597: END IF;

Line 18369: Lx_Product_CovLevels OKS_ENTITLEMENTS_PVT.GT_ContItem_Ref;

18365: l_busiproc_match VARCHAR2(1);
18366: j NUMBER ;
18367:
18368: Lx_Party_Id Okx_Customer_Accounts_V.Party_Id%TYPE;
18369: Lx_Product_CovLevels OKS_ENTITLEMENTS_PVT.GT_ContItem_Ref;
18370: Lx_Item_CovLevels OKS_ENTITLEMENTS_PVT.GT_ContItem_Ref;
18371: Lx_System_CovLevels OKS_ENTITLEMENTS_PVT.GT_ContItem_Ref;
18372: Lx_Cust_CovLevels OKS_ENTITLEMENTS_PVT.GT_ContItem_Ref;
18373: Lx_Site_CovLevels OKS_ENTITLEMENTS_PVT.GT_ContItem_Ref;

Line 18370: Lx_Item_CovLevels OKS_ENTITLEMENTS_PVT.GT_ContItem_Ref;

18366: j NUMBER ;
18367:
18368: Lx_Party_Id Okx_Customer_Accounts_V.Party_Id%TYPE;
18369: Lx_Product_CovLevels OKS_ENTITLEMENTS_PVT.GT_ContItem_Ref;
18370: Lx_Item_CovLevels OKS_ENTITLEMENTS_PVT.GT_ContItem_Ref;
18371: Lx_System_CovLevels OKS_ENTITLEMENTS_PVT.GT_ContItem_Ref;
18372: Lx_Cust_CovLevels OKS_ENTITLEMENTS_PVT.GT_ContItem_Ref;
18373: Lx_Site_CovLevels OKS_ENTITLEMENTS_PVT.GT_ContItem_Ref;
18374: Lx_Party_CovLevels OKS_ENTITLEMENTS_PVT.GT_ContItem_Ref;

Line 18371: Lx_System_CovLevels OKS_ENTITLEMENTS_PVT.GT_ContItem_Ref;

18367:
18368: Lx_Party_Id Okx_Customer_Accounts_V.Party_Id%TYPE;
18369: Lx_Product_CovLevels OKS_ENTITLEMENTS_PVT.GT_ContItem_Ref;
18370: Lx_Item_CovLevels OKS_ENTITLEMENTS_PVT.GT_ContItem_Ref;
18371: Lx_System_CovLevels OKS_ENTITLEMENTS_PVT.GT_ContItem_Ref;
18372: Lx_Cust_CovLevels OKS_ENTITLEMENTS_PVT.GT_ContItem_Ref;
18373: Lx_Site_CovLevels OKS_ENTITLEMENTS_PVT.GT_ContItem_Ref;
18374: Lx_Party_CovLevels OKS_ENTITLEMENTS_PVT.GT_ContItem_Ref;
18375: l_jtot_object1_code VARCHAR2(30);

Line 18372: Lx_Cust_CovLevels OKS_ENTITLEMENTS_PVT.GT_ContItem_Ref;

18368: Lx_Party_Id Okx_Customer_Accounts_V.Party_Id%TYPE;
18369: Lx_Product_CovLevels OKS_ENTITLEMENTS_PVT.GT_ContItem_Ref;
18370: Lx_Item_CovLevels OKS_ENTITLEMENTS_PVT.GT_ContItem_Ref;
18371: Lx_System_CovLevels OKS_ENTITLEMENTS_PVT.GT_ContItem_Ref;
18372: Lx_Cust_CovLevels OKS_ENTITLEMENTS_PVT.GT_ContItem_Ref;
18373: Lx_Site_CovLevels OKS_ENTITLEMENTS_PVT.GT_ContItem_Ref;
18374: Lx_Party_CovLevels OKS_ENTITLEMENTS_PVT.GT_ContItem_Ref;
18375: l_jtot_object1_code VARCHAR2(30);
18376:

Line 18373: Lx_Site_CovLevels OKS_ENTITLEMENTS_PVT.GT_ContItem_Ref;

18369: Lx_Product_CovLevels OKS_ENTITLEMENTS_PVT.GT_ContItem_Ref;
18370: Lx_Item_CovLevels OKS_ENTITLEMENTS_PVT.GT_ContItem_Ref;
18371: Lx_System_CovLevels OKS_ENTITLEMENTS_PVT.GT_ContItem_Ref;
18372: Lx_Cust_CovLevels OKS_ENTITLEMENTS_PVT.GT_ContItem_Ref;
18373: Lx_Site_CovLevels OKS_ENTITLEMENTS_PVT.GT_ContItem_Ref;
18374: Lx_Party_CovLevels OKS_ENTITLEMENTS_PVT.GT_ContItem_Ref;
18375: l_jtot_object1_code VARCHAR2(30);
18376:
18377: prod_index NUMBER;

Line 18374: Lx_Party_CovLevels OKS_ENTITLEMENTS_PVT.GT_ContItem_Ref;

18370: Lx_Item_CovLevels OKS_ENTITLEMENTS_PVT.GT_ContItem_Ref;
18371: Lx_System_CovLevels OKS_ENTITLEMENTS_PVT.GT_ContItem_Ref;
18372: Lx_Cust_CovLevels OKS_ENTITLEMENTS_PVT.GT_ContItem_Ref;
18373: Lx_Site_CovLevels OKS_ENTITLEMENTS_PVT.GT_ContItem_Ref;
18374: Lx_Party_CovLevels OKS_ENTITLEMENTS_PVT.GT_ContItem_Ref;
18375: l_jtot_object1_code VARCHAR2(30);
18376:
18377: prod_index NUMBER;
18378: system_index NUMBER;

Line 18626: OKS_ENTITLEMENTS_PVT.Validate_Required_NumValue

18622: Lx_Set_ExcepionStack := OKC_API.G_TRUE;
18623:
18624: -- check that the p_contract_line_id is not null
18625:
18626: OKS_ENTITLEMENTS_PVT.Validate_Required_NumValue
18627: (P_Num_Value => p_contract_line_id
18628: ,P_Set_ExcepionStack => Lx_Set_ExcepionStack
18629: ,P_ExcepionMsg => 'Contract Line'
18630: ,X_Result => Lx_result

Line 18690: OKS_ENTITLEMENTS_PVT.Get_Product_CovLevels

18686: IF p_covlevel_tbl_in(i).covlevel_code = 'OKX_CUSTPROD' THEN
18687:
18688: l_jtot_object1_code := 'OKX_CUSTPROD';
18689:
18690: OKS_ENTITLEMENTS_PVT.Get_Product_CovLevels
18691: (P_CovProd_Obj_Id => p_covlevel_tbl_in(i).covlevel_id, -- l_jtot_object1_code,
18692: P_Organization_Id => Ln_Organization_Id,
18693: P_Org_Id => Ln_Org_Id,
18694: X_Party_Id => Lx_Party_Id,

Line 18727: OKS_ENTITLEMENTS_PVT.Get_Item_CovLevels(P_CovItem_Obj_Id => p_covlevel_tbl_in(i).covlevel_id,

18723: ELSIF p_covlevel_tbl_in(i).covlevel_code = 'OKX_COVITEM' THEN
18724:
18725: l_jtot_object1_code := 'OKX_COVITEM';
18726:
18727: OKS_ENTITLEMENTS_PVT.Get_Item_CovLevels(P_CovItem_Obj_Id => p_covlevel_tbl_in(i).covlevel_id,
18728: P_Organization_Id => Ln_Organization_Id,
18729: X_Item_CovLevels => Lx_Item_CovLevels,
18730: X_Result => Lx_Result,
18731: X_Return_Status => Lx_Return_Status);

Line 18762: OKS_ENTITLEMENTS_PVT.Get_System_CovLevels(P_CovSys_Obj_Id => p_covlevel_tbl_in(i).covlevel_id,

18758: ELSIF p_covlevel_tbl_in(i).covlevel_code = 'OKX_COVSYST' THEN
18759:
18760: l_jtot_object1_code := 'OKX_COVSYST';
18761:
18762: OKS_ENTITLEMENTS_PVT.Get_System_CovLevels(P_CovSys_Obj_Id => p_covlevel_tbl_in(i).covlevel_id,
18763: P_Org_Id => Ln_Org_Id,
18764: X_System_CovLevels => Lx_System_CovLevels,
18765: X_Result => Lx_Result,
18766: X_Return_Status => Lx_Return_Status );

Line 18796: OKS_ENTITLEMENTS_PVT.Get_Customer_CovLevels(P_CovCust_Obj_Id => p_covlevel_tbl_in(i).covlevel_id,

18792: ELSIF p_covlevel_tbl_in(i).covlevel_code = 'OKX_CUSTACCT' THEN
18793:
18794: l_jtot_object1_code := 'OKX_CUSTACCT';
18795:
18796: OKS_ENTITLEMENTS_PVT.Get_Customer_CovLevels(P_CovCust_Obj_Id => p_covlevel_tbl_in(i).covlevel_id,
18797: X_Party_Id => Lx_Party_Id,
18798: X_Customer_CovLevels => Lx_Cust_CovLevels,
18799: X_Result => Lx_Result,
18800: X_Return_Status => Lx_Return_Status );

Line 18829: OKS_ENTITLEMENTS_PVT.Get_Site_CovLevels(P_CovSite_Obj_Id => p_covlevel_tbl_in(i).covlevel_id,

18825: ELSIF p_covlevel_tbl_in(i).covlevel_code = 'OKX_PARTYSITE' THEN
18826:
18827: l_jtot_object1_code := 'OKX_PARTYSITE';
18828:
18829: OKS_ENTITLEMENTS_PVT.Get_Site_CovLevels(P_CovSite_Obj_Id => p_covlevel_tbl_in(i).covlevel_id,
18830: P_Org_Id => Ln_Org_Id,
18831: X_Site_CovLevels => Lx_Site_CovLevels,
18832: X_Result => Lx_Result,
18833: X_Return_Status => Lx_Return_Status );

Line 18864: OKS_ENTITLEMENTS_PVT.Get_Party_CovLevels(P_CovParty_Obj_Id => p_covlevel_tbl_in(i).covlevel_id,

18860: ELSIF p_covlevel_tbl_in(i).covlevel_code = 'OKX_PARTY' THEN
18861:
18862: l_jtot_object1_code := 'OKX_PARTY';
18863:
18864: OKS_ENTITLEMENTS_PVT.Get_Party_CovLevels(P_CovParty_Obj_Id => p_covlevel_tbl_in(i).covlevel_id,
18865: X_Party_CovLevels => Lx_Party_CovLevels,
18866: X_Result => Lx_Result,
18867: X_Return_Status => Lx_Return_Status );
18868:

Line 22747: END OKS_ENTITLEMENTS_PVT;

22743: END Get_BPL_Offset_Start_Date;
22744:
22745: --
22746:
22747: END OKS_ENTITLEMENTS_PVT;