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_K_HEADERS_B

Line 5369: ,OKS_K_HEADERS_B OKSHDR -- 11.5.10 changes

5365: ,HDR.conversion_type conversion_type -- 11.5.10 changes
5366: FROM OKC_K_PARTY_ROLES_B PTY
5367: ,OKC_K_HEADERS_TL HDT
5368: ,OKC_K_HEADERS_ALL_B HDR --,OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
5369: ,OKS_K_HEADERS_B OKSHDR -- 11.5.10 changes
5370: WHERE HDR.ID = NVL(Cx_Chr_Id,HDR.ID)
5371: AND HDR.END_DATE = NVL(Cd_Chr_EndDate,HDR.END_DATE)
5372: AND HDR.STS_CODE = NVL(Cx_Chr_Sts_Code,HDR.STS_CODE)
5373: AND HDR.CHR_TYPE = NVL(Cx_Chr_Type,HDR.CHR_TYPE)

Line 5431: Lx_Contract_Headers(Li_TableIdx).Accounting_Rule_Id := Idx.acct_rule_id; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_Acc_Rule(Idx.Id,NULL)); -- oks_k_headers_b.acct_rule_id

5427: Lx_Contract_Headers(Li_TableIdx).Agreement_Id := OKS_ENT_UTIL_PVT.Get_Agreement(Idx.Id);
5428: Lx_Contract_Headers(Li_TableIdx).Price_List_Id := TO_NUMBER(OKS_ENT_UTIL_PVT.Get_PriceList(Idx.Id,NULL,'P')); --from okc_k_headers_b.price_list_id
5429: Lx_Contract_Headers(Li_TableIdx).Modifier := null; -- does not exist in 11.5.10 --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_Discount(Idx.Id,NULL));
5430: Lx_Contract_Headers(Li_TableIdx).Currency_Code := Idx.Currency_code; --SUBSTR(OKS_ENT_UTIL_PVT.Get_PriceList(Idx.Id,NULL,'C'),1,30); -- from okc_k_headers_b.currency_code
5431: Lx_Contract_Headers(Li_TableIdx).Accounting_Rule_Id := Idx.acct_rule_id; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_Acc_Rule(Idx.Id,NULL)); -- oks_k_headers_b.acct_rule_id
5432: Lx_Contract_Headers(Li_TableIdx).Invoicing_Rule_Id := Idx.inv_rule_id; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_Inv_Rule(Idx.Id,NULL)); -- okc_k_headers_b.inv_rule_id
5433: Lx_Contract_Headers(Li_TableIdx).Terms_Id := Idx.payment_term_id; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_Terms(Idx.Id,NULL)); --okc_k_headers_b.payment_term_id
5434: Lx_Contract_Headers(Li_TableIdx).PO_Number := Idx.Cust_PO_Number;
5435: Lx_Contract_Headers(Li_TableIdx).Billing_Profile_Id := Idx.Billing_profile_id; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BillingProfile(Idx.Id,NULL)); --oks_k_header_b.billing_profile_id

Line 5447: Lx_Contract_Headers(Li_TableIdx).Tax_Exemption := Idx.tax_exemption_id; --OKS_ENT_UTIL_PVT.Get_TaxRule(Idx.Id,'TE'); --oks_k_headers_b.tax_exemption_id

5443: Lx_Contract_Headers(Li_TableIdx).Auto_Renew_Before_Days := Idx.Auto_Renew_Days;
5444: Lx_Contract_Headers(Li_TableIdx).QA_Check_List_Id := Idx.Qcl_Id;
5445: Lx_Contract_Headers(Li_TableIdx).Renewal_Note := OKS_ENT_UTIL_PVT.Get_RenterNotes(Idx.Id,'RENEW');
5446: Lx_Contract_Headers(Li_TableIdx).Termination_Note := OKS_ENT_UTIL_PVT.Get_RenterNotes(Idx.Id,'TER');
5447: Lx_Contract_Headers(Li_TableIdx).Tax_Exemption := Idx.tax_exemption_id; --OKS_ENT_UTIL_PVT.Get_TaxRule(Idx.Id,'TE'); --oks_k_headers_b.tax_exemption_id
5448: Lx_Contract_Headers(Li_TableIdx).Tax_Status := Idx.tax_status; --OKS_ENT_UTIL_PVT.Get_TaxRule(Idx.Id,'TS'); --oks_k_headers_b.tax_status
5449: Lx_Contract_Headers(Li_TableIdx).Conversion_Type := Idx.conversion_type; --OKS_ENT_UTIL_PVT.Get_ConvRule(Idx.Id); --okc_k_headers_b.conversion_type
5450:
5451: END LOOP;

Line 5448: Lx_Contract_Headers(Li_TableIdx).Tax_Status := Idx.tax_status; --OKS_ENT_UTIL_PVT.Get_TaxRule(Idx.Id,'TS'); --oks_k_headers_b.tax_status

5444: Lx_Contract_Headers(Li_TableIdx).QA_Check_List_Id := Idx.Qcl_Id;
5445: Lx_Contract_Headers(Li_TableIdx).Renewal_Note := OKS_ENT_UTIL_PVT.Get_RenterNotes(Idx.Id,'RENEW');
5446: Lx_Contract_Headers(Li_TableIdx).Termination_Note := OKS_ENT_UTIL_PVT.Get_RenterNotes(Idx.Id,'TER');
5447: Lx_Contract_Headers(Li_TableIdx).Tax_Exemption := Idx.tax_exemption_id; --OKS_ENT_UTIL_PVT.Get_TaxRule(Idx.Id,'TE'); --oks_k_headers_b.tax_exemption_id
5448: Lx_Contract_Headers(Li_TableIdx).Tax_Status := Idx.tax_status; --OKS_ENT_UTIL_PVT.Get_TaxRule(Idx.Id,'TS'); --oks_k_headers_b.tax_status
5449: Lx_Contract_Headers(Li_TableIdx).Conversion_Type := Idx.conversion_type; --OKS_ENT_UTIL_PVT.Get_ConvRule(Idx.Id); --okc_k_headers_b.conversion_type
5450:
5451: END LOOP;
5452:

Line 13232: FROM Oks_K_Headers_B OKH

13228:
13229: CURSOR Lx_Csr_HDR_Grace(Cx_HDR_Id IN Gx_OKS_Id) IS
13230: SELECT Grace_Duration Duration
13231: ,Grace_Period TimeUnit
13232: FROM Oks_K_Headers_B OKH
13233: WHERE OKH.chr_Id = Cx_HDR_Id;
13234:
13235: L_Date DATE;
13236:

Line 16334: FROM OKS_K_Headers_B CHR

16330:
16331:
16332: CURSOR Lx_Csr_SvcPO(Cx_CHR_Id IN Gx_OKS_Id) IS
16333: SELECT service_po_number,service_po_required
16334: FROM OKS_K_Headers_B CHR
16335: WHERE CHR.chr_Id = Cx_CHR_Id;
16336:
16337: Lx_CHR_Id CONSTANT Gx_OKS_Id := P_CHR_Id;
16338: Lx_Set_ExcepionStack CONSTANT Gx_Boolean := P_Set_ExcepionStack;

Line 16340: Lx_Service_PO Oks_K_headers_b.service_po_number%TYPE;

16336:
16337: Lx_CHR_Id CONSTANT Gx_OKS_Id := P_CHR_Id;
16338: Lx_Set_ExcepionStack CONSTANT Gx_Boolean := P_Set_ExcepionStack;
16339:
16340: Lx_Service_PO Oks_K_headers_b.service_po_number%TYPE;
16341: Lx_Service_PO_Required Oks_K_headers_b.service_po_required%TYPE;
16342:
16343:
16344: Lx_Result Gx_Boolean;

Line 16341: Lx_Service_PO_Required Oks_K_headers_b.service_po_required%TYPE;

16337: Lx_CHR_Id CONSTANT Gx_OKS_Id := P_CHR_Id;
16338: Lx_Set_ExcepionStack CONSTANT Gx_Boolean := P_Set_ExcepionStack;
16339:
16340: Lx_Service_PO Oks_K_headers_b.service_po_number%TYPE;
16341: Lx_Service_PO_Required Oks_K_headers_b.service_po_required%TYPE;
16342:
16343:
16344: Lx_Result Gx_Boolean;
16345: Lx_Return_Status Gx_Ret_Sts;

Line 16432: FROM Oks_K_Headers_B OKH

16428:
16429: CURSOR Lx_Csr_HDR_Grace(Cx_HDR_Id IN Gx_OKS_Id) IS
16430: SELECT Grace_Duration Duration
16431: ,Grace_Period TimeUnit
16432: FROM Oks_K_Headers_B OKH
16433: WHERE OKH.chr_Id = Cx_HDR_Id;
16434:
16435: Lx_CHR_Id CONSTANT Gx_OKS_Id := P_Contract_id;
16436: Lx_Set_ExcepionStack CONSTANT Gx_Boolean := P_Set_ExcepionStack;

Line 17405: oks_k_headers_b oksb -- 11.5.10 rule rearchitecture changes

17401: SELECT /*+ leading(b) use_nl(b oksb) */ b.Id Id, -- 11.5.10 rule rearchitecture changes
17402: b.renewal_type_code, -- Added by Jyothi for perf bug:4991724
17403: oksb.electronic_renewal_flag -- Added by Jyothi for perf bug:4991724
17404: FROM OKC_K_HEADERS_ALL_B B, --Okc_K_Headers_B B, /*Bug:6767455*/
17405: oks_k_headers_b oksb -- 11.5.10 rule rearchitecture changes
17406: WHERE b.id = oksb.chr_id -- 11.5.10 rule rearchitecture changes
17407: AND B.Start_Date BETWEEN Cv_Start_Date_From AND Cv_Start_Date_to
17408: AND B.End_Date BETWEEN Cv_End_Date_From AND Cv_End_Date_To
17409: AND B.Date_Terminated BETWEEN Cv_Date_Terminate_From AND Cv_Date_Terminate_To

Line 17433: oks_k_headers_b oksb -- 11.5.10 rule rearchitecture changes

17429: SELECT /*+ leading(b) use_nl(b oksb) */ b.Id Id, -- 11.5.10 rule rearchitecture changes
17430: b.renewal_type_code, -- Added by Jyothi for perf bug:4991724
17431: oksb.electronic_renewal_flag -- Added by Jyothi for perf bug:4991724
17432: FROM OKC_K_HEADERS_ALL_B B, -- OKC_K_HEADERS_B B -- Modified for 12.0 MOAC project /*Bug:6767455*/
17433: oks_k_headers_b oksb -- 11.5.10 rule rearchitecture changes
17434: WHERE b.id = oksb.chr_id -- 11.5.10 rule rearchitecture changes
17435: AND B.Start_Date BETWEEN Cv_Start_Date_From AND Cv_Start_Date_to
17436: AND B.End_Date BETWEEN Cv_End_Date_From AND Cv_End_Date_To
17437: AND sts_code = nvl(Cv_STATUS,B.Sts_Code)

Line 17459: oks_k_headers_b oksb -- 11.5.10 rule rearchitecture changes

17455: b.Id Id, -- 11.5.10 rule rearchitecture changes
17456: b.renewal_type_code, -- Added by Jvorugan for perf bug:4991724
17457: oksb.electronic_renewal_flag -- Added by Jvorugan for perf bug:4991724
17458: FROM OKC_K_HEADERS_ALL_B B, -- OKC_K_HEADERS_B B -- Modified for 12.0 MOAC project (JVARGHES)
17459: oks_k_headers_b oksb -- 11.5.10 rule rearchitecture changes
17460: WHERE B.Id = Cv_Contract_Id --B.Id --nvl(Cv_Contract_Id,B.Id) /*Added for Bug:6767455*/
17461: and Contract_Number = nvl(Cv_Contract_Num,Contract_Number)
17462: --AND nvl(Contract_Number_Modifier,-99) = nvl(Cv_Contract_Num_Modifier,nvl(Contract_Number_Modifier,-99))
17463: AND ( (Cv_Contract_Num_Modifier IS NULL)

Line 17539: oks_k_headers_b oksb, -- 11.5.10 rule rearchitecture changes

17535: SELECT /*+ leading(pr) use_nl(pr b oksb) */ b.Id Id, -- 11.5.10 rule rearchitecture changes
17536: b.renewal_type_code, -- Added by Jyothi for perf bug:4991724
17537: oksb.electronic_renewal_flag -- Added by Jyothi for perf bug:4991724
17538: FROM OKC_K_HEADERS_ALL_B B, -- OKC_K_HEADERS_B B -- Modified for 12.0 MOAC project (JVARGHES)
17539: oks_k_headers_b oksb, -- 11.5.10 rule rearchitecture changes
17540: Okc_K_Party_Roles_B PR
17541: WHERE PR.Object1_Id1 = TO_CHAR(Cv_Cont_Pty_Id)
17542: AND PR.Object1_Id2 = '#'
17543: AND PR.Jtot_Object1_Code = 'OKX_PARTY'

Line 17582: oks_k_headers_b oksb, -- 11.5.10 rule rearchitecture changes

17578: SELECT /*+ leading(grpng) use_nl(grpng b oksb) */ b.Id Id, -- 11.5.10 rule rearchitecture changes
17579: b.renewal_type_code, -- Added by Jyothi for perf bug:4991724
17580: oksb.electronic_renewal_flag -- Added by Jyothi for perf bug:4991724
17581: FROM OKC_K_HEADERS_ALL_B B, -- OKC_K_HEADERS_B B -- Modified for 12.0 MOAC project (JVARGHES)
17582: oks_k_headers_b oksb, -- 11.5.10 rule rearchitecture changes
17583: Okc_K_grpings grpng
17584: WHERE grpng.cgp_parent_id = Cv_contract_grp_id
17585: AND B.ID = grpng.included_chr_id
17586: -- AND Contract_Number = nvl(Cv_Contract_Num,Contract_Number)

Line 17623: oks_k_headers_b oksb -- 11.5.10 rule rearchitecture changes

17619:
17620: FROM Okc_K_Party_Roles_B PR,
17621: Okc_K_grpings grpng,
17622: OKC_K_HEADERS_ALL_B B, -- OKC_K_HEADERS_B B -- Modified for 12.0 MOAC project (JVARGHES)
17623: oks_k_headers_b oksb -- 11.5.10 rule rearchitecture changes
17624:
17625: WHERE PR.Object1_Id1 = TO_CHAR(Cv_Cont_Pty_Id)
17626: AND PR.Object1_Id2 = '#'
17627: AND PR.Jtot_Object1_Code = 'OKX_PARTY'

Line 17668: oks_k_headers_b oksb -- 11.5.10 rule rearchitecture changes

17664: SELECT /*+ leadin(b) use_nl(b oksb) */ b.Id Id, -- 11.5.10 rule rearchitecture changes
17665: b.renewal_type_code, -- Added by Jyothi for perf bug:4991724
17666: oksb.electronic_renewal_flag -- Added by Jyothi for perf bug:4991724
17667: FROM OKC_K_HEADERS_ALL_B B, -- OKC_K_HEADERS_B B -- Modified for 12.0 MOAC project (JVARGHES)
17668: oks_k_headers_b oksb -- 11.5.10 rule rearchitecture changes
17669: WHERE Contract_Number = Cv_Contract_Num
17670: -- AND ( (Cv_Contract_Num_Modifier IS NULL)
17671: AND Contract_Number_Modifier = Cv_Contract_Num_Modifier
17672: AND b.id = oksb.chr_id -- 11.5.10 rule rearchitecture changes

Line 17731: oks_k_headers_b oksb -- 11.5.10 rule rearchitecture changes

17727: SELECT /*+ leadin(b) use_nl(b oksb) */ b.Id Id, -- 11.5.10 rule rearchitecture changes
17728: b.renewal_type_code, -- Added by Jyothi for perf bug:4991724
17729: oksb.electronic_renewal_flag -- Added by Jyothi for perf bug:4991724
17730: FROM OKC_K_HEADERS_ALL_B B, -- OKC_K_HEADERS_B B -- Modified for 12.0 MOAC project (JVARGHES)
17731: oks_k_headers_b oksb -- 11.5.10 rule rearchitecture changes
17732: WHERE Contract_Number = Cv_Contract_Num
17733: /*and Contract_Number = nvl(Cv_Contract_Num,Contract_Number)
17734: AND nvl(Contract_Number_Modifier,-99) = nvl(Cv_Contract_Num_Modifier,nvl(Contract_Number_Modifier,-99))*/
17735: and b.id = oksb.chr_id