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 5757: ,OKS_K_HEADERS_B OKSHDR -- 11.5.10 changes

5753: ,HDR.conversion_type conversion_type -- 11.5.10 changes
5754: FROM OKC_K_PARTY_ROLES_B PTY
5755: ,OKC_K_HEADERS_TL HDT
5756: ,OKC_K_HEADERS_ALL_B HDR --,OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
5757: ,OKS_K_HEADERS_B OKSHDR -- 11.5.10 changes
5758: WHERE HDR.ID = NVL(Cx_Chr_Id,HDR.ID)
5759: AND HDR.END_DATE = NVL(Cd_Chr_EndDate,HDR.END_DATE)
5760: AND HDR.STS_CODE = NVL(Cx_Chr_Sts_Code,HDR.STS_CODE)
5761: AND HDR.CHR_TYPE = NVL(Cx_Chr_Type,HDR.CHR_TYPE)

Line 5819: 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

5815: Lx_Contract_Headers(Li_TableIdx).Agreement_Id := OKS_ENT_UTIL_PVT.Get_Agreement(Idx.Id);
5816: 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
5817: 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));
5818: 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
5819: 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
5820: 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
5821: 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
5822: Lx_Contract_Headers(Li_TableIdx).PO_Number := Idx.Cust_PO_Number;
5823: 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 5835: 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

5831: Lx_Contract_Headers(Li_TableIdx).Auto_Renew_Before_Days := Idx.Auto_Renew_Days;
5832: Lx_Contract_Headers(Li_TableIdx).QA_Check_List_Id := Idx.Qcl_Id;
5833: Lx_Contract_Headers(Li_TableIdx).Renewal_Note := OKS_ENT_UTIL_PVT.Get_RenterNotes(Idx.Id,'RENEW');
5834: Lx_Contract_Headers(Li_TableIdx).Termination_Note := OKS_ENT_UTIL_PVT.Get_RenterNotes(Idx.Id,'TER');
5835: 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
5836: 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
5837: Lx_Contract_Headers(Li_TableIdx).Conversion_Type := Idx.conversion_type; --OKS_ENT_UTIL_PVT.Get_ConvRule(Idx.Id); --okc_k_headers_b.conversion_type
5838:
5839: END LOOP;

Line 5836: 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

5832: Lx_Contract_Headers(Li_TableIdx).QA_Check_List_Id := Idx.Qcl_Id;
5833: Lx_Contract_Headers(Li_TableIdx).Renewal_Note := OKS_ENT_UTIL_PVT.Get_RenterNotes(Idx.Id,'RENEW');
5834: Lx_Contract_Headers(Li_TableIdx).Termination_Note := OKS_ENT_UTIL_PVT.Get_RenterNotes(Idx.Id,'TER');
5835: 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
5836: 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
5837: Lx_Contract_Headers(Li_TableIdx).Conversion_Type := Idx.conversion_type; --OKS_ENT_UTIL_PVT.Get_ConvRule(Idx.Id); --okc_k_headers_b.conversion_type
5838:
5839: END LOOP;
5840:

Line 14590: FROM Oks_K_Headers_B OKH

14586:
14587: CURSOR Lx_Csr_HDR_Grace(Cx_HDR_Id IN Gx_OKS_Id) IS
14588: SELECT Grace_Duration Duration
14589: ,Grace_Period TimeUnit
14590: FROM Oks_K_Headers_B OKH
14591: WHERE OKH.chr_Id = Cx_HDR_Id;
14592:
14593: L_Date DATE;
14594:

Line 18178: FROM OKS_K_Headers_B CHR

18174:
18175:
18176: CURSOR Lx_Csr_SvcPO(Cx_CHR_Id IN Gx_OKS_Id) IS
18177: SELECT service_po_number,service_po_required
18178: FROM OKS_K_Headers_B CHR
18179: WHERE CHR.chr_Id = Cx_CHR_Id;
18180:
18181: Lx_CHR_Id CONSTANT Gx_OKS_Id := P_CHR_Id;
18182: Lx_Set_ExcepionStack CONSTANT Gx_Boolean := P_Set_ExcepionStack;

Line 18184: Lx_Service_PO Oks_K_headers_b.service_po_number%TYPE;

18180:
18181: Lx_CHR_Id CONSTANT Gx_OKS_Id := P_CHR_Id;
18182: Lx_Set_ExcepionStack CONSTANT Gx_Boolean := P_Set_ExcepionStack;
18183:
18184: Lx_Service_PO Oks_K_headers_b.service_po_number%TYPE;
18185: Lx_Service_PO_Required Oks_K_headers_b.service_po_required%TYPE;
18186:
18187:
18188: Lx_Result Gx_Boolean;

Line 18185: Lx_Service_PO_Required Oks_K_headers_b.service_po_required%TYPE;

18181: Lx_CHR_Id CONSTANT Gx_OKS_Id := P_CHR_Id;
18182: Lx_Set_ExcepionStack CONSTANT Gx_Boolean := P_Set_ExcepionStack;
18183:
18184: Lx_Service_PO Oks_K_headers_b.service_po_number%TYPE;
18185: Lx_Service_PO_Required Oks_K_headers_b.service_po_required%TYPE;
18186:
18187:
18188: Lx_Result Gx_Boolean;
18189: Lx_Return_Status Gx_Ret_Sts;

Line 18276: FROM Oks_K_Headers_B OKH

18272:
18273: CURSOR Lx_Csr_HDR_Grace(Cx_HDR_Id IN Gx_OKS_Id) IS
18274: SELECT Grace_Duration Duration
18275: ,Grace_Period TimeUnit
18276: FROM Oks_K_Headers_B OKH
18277: WHERE OKH.chr_Id = Cx_HDR_Id;
18278:
18279: Lx_CHR_Id CONSTANT Gx_OKS_Id := P_Contract_id;
18280: Lx_Set_ExcepionStack CONSTANT Gx_Boolean := P_Set_ExcepionStack;

Line 19249: oks_k_headers_b oksb -- 11.5.10 rule rearchitecture changes

19245: SELECT /*+ leading(b) use_nl(b oksb) */ b.Id Id, -- 11.5.10 rule rearchitecture changes
19246: b.renewal_type_code, -- Added by Jyothi for perf bug:4991724
19247: oksb.electronic_renewal_flag -- Added by Jyothi for perf bug:4991724
19248: FROM OKC_K_HEADERS_ALL_B B, --Okc_K_Headers_B B, /*Bug:6767455*/
19249: oks_k_headers_b oksb -- 11.5.10 rule rearchitecture changes
19250: WHERE b.id = oksb.chr_id -- 11.5.10 rule rearchitecture changes
19251: AND B.Start_Date BETWEEN Cv_Start_Date_From AND Cv_Start_Date_to
19252: AND B.End_Date BETWEEN Cv_End_Date_From AND Cv_End_Date_To
19253: AND B.Date_Terminated BETWEEN Cv_Date_Terminate_From AND Cv_Date_Terminate_To

Line 19277: oks_k_headers_b oksb -- 11.5.10 rule rearchitecture changes

19273: SELECT /*+ leading(b) use_nl(b oksb) */ b.Id Id, -- 11.5.10 rule rearchitecture changes
19274: b.renewal_type_code, -- Added by Jyothi for perf bug:4991724
19275: oksb.electronic_renewal_flag -- Added by Jyothi for perf bug:4991724
19276: FROM OKC_K_HEADERS_ALL_B B, -- OKC_K_HEADERS_B B -- Modified for 12.0 MOAC project /*Bug:6767455*/
19277: oks_k_headers_b oksb -- 11.5.10 rule rearchitecture changes
19278: WHERE b.id = oksb.chr_id -- 11.5.10 rule rearchitecture changes
19279: AND B.Start_Date BETWEEN Cv_Start_Date_From AND Cv_Start_Date_to
19280: AND B.End_Date BETWEEN Cv_End_Date_From AND Cv_End_Date_To
19281: AND sts_code = nvl(Cv_STATUS,B.Sts_Code)

Line 19303: oks_k_headers_b oksb -- 11.5.10 rule rearchitecture changes

19299: b.Id Id, -- 11.5.10 rule rearchitecture changes
19300: b.renewal_type_code, -- Added by Jvorugan for perf bug:4991724
19301: oksb.electronic_renewal_flag -- Added by Jvorugan for perf bug:4991724
19302: FROM OKC_K_HEADERS_ALL_B B, -- OKC_K_HEADERS_B B -- Modified for 12.0 MOAC project (JVARGHES)
19303: oks_k_headers_b oksb -- 11.5.10 rule rearchitecture changes
19304: WHERE B.Id = Cv_Contract_Id --B.Id --nvl(Cv_Contract_Id,B.Id) /*Added for Bug:6767455*/
19305: and Contract_Number = nvl(Cv_Contract_Num,Contract_Number)
19306: --AND nvl(Contract_Number_Modifier,-99) = nvl(Cv_Contract_Num_Modifier,nvl(Contract_Number_Modifier,-99))
19307: AND ( (Cv_Contract_Num_Modifier IS NULL)

Line 19386: oks_k_headers_b oksb -- 11.5.10 rule rearchitecture changes

19382: b.Id Id, -- 11.5.10 rule rearchitecture changes
19383: b.renewal_type_code, -- Added by Jvorugan for perf bug:4991724
19384: oksb.electronic_renewal_flag -- Added by Jvorugan for perf bug:4991724
19385: FROM OKC_K_HEADERS_ALL_B B, -- OKC_K_HEADERS_B B -- Modified for 12.0 MOAC project (JVARGHES)
19386: oks_k_headers_b oksb -- 11.5.10 rule rearchitecture changes
19387: WHERE B.Id = Cv_Contract_Id --B.Id --nvl(Cv_Contract_Id,B.Id) /*Added for Bug:6767455*/
19388: and Contract_Number = nvl(Cv_Contract_Num,Contract_Number)
19389: AND ( (Cv_Contract_Num_Modifier IS NULL)
19390: OR (Contract_Number_Modifier = Cv_Contract_Num_Modifier))

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

19433: SELECT /*+ leading(pr) use_nl(pr b oksb) */ b.Id Id, -- 11.5.10 rule rearchitecture changes
19434: b.renewal_type_code, -- Added by Jyothi for perf bug:4991724
19435: oksb.electronic_renewal_flag -- Added by Jyothi for perf bug:4991724
19436: FROM OKC_K_HEADERS_ALL_B B, -- OKC_K_HEADERS_B B -- Modified for 12.0 MOAC project (JVARGHES)
19437: oks_k_headers_b oksb, -- 11.5.10 rule rearchitecture changes
19438: Okc_K_Party_Roles_B PR
19439: WHERE PR.Object1_Id1 = TO_CHAR(Cv_Cont_Pty_Id)
19440: AND PR.Object1_Id2 = '#'
19441: AND PR.Jtot_Object1_Code = 'OKX_PARTY'

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

19476: SELECT /*+ leading(pr) use_nl(pr b oksb) */ b.Id Id, -- 11.5.10 rule rearchitecture changes
19477: b.renewal_type_code, -- Added by Jyothi for perf bug:4991724
19478: oksb.electronic_renewal_flag -- Added by Jyothi for perf bug:4991724
19479: FROM OKC_K_HEADERS_ALL_B B, -- OKC_K_HEADERS_B B -- Modified for 12.0 MOAC project (JVARGHES)
19480: oks_k_headers_b oksb, -- 11.5.10 rule rearchitecture changes
19481: Okc_K_Party_Roles_B PR
19482: WHERE PR.Object1_Id1 = TO_CHAR(Cv_Cont_Pty_Id)
19483: AND PR.Object1_Id2 = '#'
19484: AND PR.Jtot_Object1_Code = 'OKX_PARTY'

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

19519: SELECT /*+ leading(grpng) use_nl(grpng b oksb) */ b.Id Id, -- 11.5.10 rule rearchitecture changes
19520: b.renewal_type_code, -- Added by Jyothi for perf bug:4991724
19521: oksb.electronic_renewal_flag -- Added by Jyothi for perf bug:4991724
19522: FROM OKC_K_HEADERS_ALL_B B, -- OKC_K_HEADERS_B B -- Modified for 12.0 MOAC project (JVARGHES)
19523: oks_k_headers_b oksb, -- 11.5.10 rule rearchitecture changes
19524: Okc_K_grpings grpng
19525: WHERE grpng.cgp_parent_id = Cv_contract_grp_id
19526: AND B.ID = grpng.included_chr_id
19527: -- AND Contract_Number = nvl(Cv_Contract_Num,Contract_Number)

Line 19564: oks_k_headers_b oksb -- 11.5.10 rule rearchitecture changes

19560:
19561: FROM Okc_K_Party_Roles_B PR,
19562: Okc_K_grpings grpng,
19563: OKC_K_HEADERS_ALL_B B, -- OKC_K_HEADERS_B B -- Modified for 12.0 MOAC project (JVARGHES)
19564: oks_k_headers_b oksb -- 11.5.10 rule rearchitecture changes
19565:
19566: WHERE PR.Object1_Id1 = TO_CHAR(Cv_Cont_Pty_Id)
19567: AND PR.Object1_Id2 = '#'
19568: AND PR.Jtot_Object1_Code = 'OKX_PARTY'

Line 19611: oks_k_headers_b oksb -- 11.5.10 rule rearchitecture changes

19607:
19608: FROM Okc_K_Party_Roles_B PR,
19609: Okc_K_grpings grpng,
19610: OKC_K_HEADERS_ALL_B B, -- OKC_K_HEADERS_B B -- Modified for 12.0 MOAC project (JVARGHES)
19611: oks_k_headers_b oksb -- 11.5.10 rule rearchitecture changes
19612:
19613: WHERE PR.Object1_Id1 = TO_CHAR(Cv_Cont_Pty_Id)
19614: AND PR.Object1_Id2 = '#'
19615: AND PR.Jtot_Object1_Code = 'OKX_PARTY'

Line 19657: oks_k_headers_b oksb -- 11.5.10 rule rearchitecture changes

19653: SELECT /*+ leadin(b) use_nl(b oksb) */ b.Id Id, -- 11.5.10 rule rearchitecture changes
19654: b.renewal_type_code, -- Added by Jyothi for perf bug:4991724
19655: oksb.electronic_renewal_flag -- Added by Jyothi for perf bug:4991724
19656: FROM OKC_K_HEADERS_ALL_B B, -- OKC_K_HEADERS_B B -- Modified for 12.0 MOAC project (JVARGHES)
19657: oks_k_headers_b oksb -- 11.5.10 rule rearchitecture changes
19658: WHERE Contract_Number = Cv_Contract_Num
19659: -- AND ( (Cv_Contract_Num_Modifier IS NULL)
19660: AND Contract_Number_Modifier = Cv_Contract_Num_Modifier
19661: AND b.id = oksb.chr_id -- 11.5.10 rule rearchitecture changes

Line 19721: oks_k_headers_b oksb -- 11.5.10 rule rearchitecture changes

19717: SELECT /*+ leadin(b) use_nl(b oksb) */ b.Id Id, -- 11.5.10 rule rearchitecture changes
19718: b.renewal_type_code, -- Added by Jyothi for perf bug:4991724
19719: oksb.electronic_renewal_flag -- Added by Jyothi for perf bug:4991724
19720: FROM OKC_K_HEADERS_ALL_B B, -- OKC_K_HEADERS_B B -- Modified for 12.0 MOAC project (JVARGHES)
19721: oks_k_headers_b oksb -- 11.5.10 rule rearchitecture changes
19722: WHERE Contract_Number = Cv_Contract_Num
19723: -- AND ( (Cv_Contract_Num_Modifier IS NULL)
19724: AND Contract_Number_Modifier = Cv_Contract_Num_Modifier
19725: AND b.id = oksb.chr_id -- 11.5.10 rule rearchitecture changes

Line 19785: oks_k_headers_b oksb -- 11.5.10 rule rearchitecture changes

19781: SELECT /*+ leadin(b) use_nl(b oksb) */ b.Id Id, -- 11.5.10 rule rearchitecture changes
19782: b.renewal_type_code, -- Added by Jyothi for perf bug:4991724
19783: oksb.electronic_renewal_flag -- Added by Jyothi for perf bug:4991724
19784: FROM OKC_K_HEADERS_ALL_B B, -- OKC_K_HEADERS_B B -- Modified for 12.0 MOAC project (JVARGHES)
19785: oks_k_headers_b oksb -- 11.5.10 rule rearchitecture changes
19786: WHERE Contract_Number = Cv_Contract_Num
19787: /*and Contract_Number = nvl(Cv_Contract_Num,Contract_Number)
19788: AND nvl(Contract_Number_Modifier,-99) = nvl(Cv_Contract_Num_Modifier,nvl(Contract_Number_Modifier,-99))*/
19789: and b.id = oksb.chr_id

Line 19861: oks_k_headers_b oksb -- 11.5.10 rule rearchitecture changes

19857: SELECT /*+ leadin(b) use_nl(b oksb) */ b.Id Id, -- 11.5.10 rule rearchitecture changes
19858: b.renewal_type_code, -- Added by Jyothi for perf bug:4991724
19859: oksb.electronic_renewal_flag -- Added by Jyothi for perf bug:4991724
19860: FROM OKC_K_HEADERS_ALL_B B, -- OKC_K_HEADERS_B B -- Modified for 12.0 MOAC project (JVARGHES)
19861: oks_k_headers_b oksb -- 11.5.10 rule rearchitecture changes
19862: WHERE Contract_Number = Cv_Contract_Num
19863: and b.id = oksb.chr_id
19864: AND B.Start_Date >= NVL(trunc(Cv_Start_Date_From),B.Start_Date)
19865: AND B.Start_Date <= NVL((trunc(Cv_Start_Date_to)+0.99998843),B.Start_Date)