[Home] [Help]
5752: ,OKSHDR.tax_status tax_status -- 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)
5809: Lx_Contract_Headers(Li_TableIdx).Period_Code := OKS_ENT_UTIL_PVT.Get_Duration_Period
5810: (Idx.Start_Date,Idx.End_Date,'P');
5811: Lx_Contract_Headers(Li_TableIdx).Start_Date_Active := Idx.Start_Date;
5812: Lx_Contract_Headers(Li_TableIdx).End_Date_Active := Idx.End_Date;
5813: Lx_Contract_Headers(Li_TableIdx).Bill_To_Site_Use_Id := Idx.bill_to_site_use_id; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BilltoShipto(Idx.Id,NULL,'OKX_BILLTO')); --from okc_k_headers_b
5814: Lx_Contract_Headers(Li_TableIdx).Ship_To_Site_Use_Id := Idx.ship_to_site_use_id; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BilltoShipto(Idx.Id,NULL,'OKX_SHIPTO')); --from okc_k_headers_b
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));
5810: (Idx.Start_Date,Idx.End_Date,'P');
5811: Lx_Contract_Headers(Li_TableIdx).Start_Date_Active := Idx.Start_Date;
5812: Lx_Contract_Headers(Li_TableIdx).End_Date_Active := Idx.End_Date;
5813: Lx_Contract_Headers(Li_TableIdx).Bill_To_Site_Use_Id := Idx.bill_to_site_use_id; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BilltoShipto(Idx.Id,NULL,'OKX_BILLTO')); --from okc_k_headers_b
5814: Lx_Contract_Headers(Li_TableIdx).Ship_To_Site_Use_Id := Idx.ship_to_site_use_id; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BilltoShipto(Idx.Id,NULL,'OKX_SHIPTO')); --from okc_k_headers_b
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
5812: Lx_Contract_Headers(Li_TableIdx).End_Date_Active := Idx.End_Date;
5813: Lx_Contract_Headers(Li_TableIdx).Bill_To_Site_Use_Id := Idx.bill_to_site_use_id; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BilltoShipto(Idx.Id,NULL,'OKX_BILLTO')); --from okc_k_headers_b
5814: Lx_Contract_Headers(Li_TableIdx).Ship_To_Site_Use_Id := Idx.ship_to_site_use_id; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BilltoShipto(Idx.Id,NULL,'OKX_SHIPTO')); --from okc_k_headers_b
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
5814: Lx_Contract_Headers(Li_TableIdx).Ship_To_Site_Use_Id := Idx.ship_to_site_use_id; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BilltoShipto(Idx.Id,NULL,'OKX_SHIPTO')); --from okc_k_headers_b
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;
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
5824: Lx_Contract_Headers(Li_TableIdx).Billing_Frequency := null; -- does not exist in 11.5.10 --SUBSTR(OKS_ENT_UTIL_PVT.Get_BillingSchedule(Idx.Id,NULL,'F'),1,25); --null
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
5824: Lx_Contract_Headers(Li_TableIdx).Billing_Frequency := null; -- does not exist in 11.5.10 --SUBSTR(OKS_ENT_UTIL_PVT.Get_BillingSchedule(Idx.Id,NULL,'F'),1,25); --null
5825: Lx_Contract_Headers(Li_TableIdx).Billing_Method := null; -- does not exist in 11.5.10 --SUBSTR(OKS_ENT_UTIL_PVT.Get_BillingSchedule(Idx.Id,NULL,'M'),1,3); --null
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:
5841: X_Contract_Headers := Lx_Contract_Headers;
5951: ,LIN.bill_to_site_use_id bill_to_site_use_id -- 11.5.10 changes
5952: ,LIN.ship_to_site_use_id ship_to_site_use_id -- 11.5.10 changes
5953: ,OKSLIN.discount_list discount_list -- 11.5.10 changes
5954: ,LIN.price_list_id price_list_id -- 11.5.10 changes
5955: FROM OKC_K_HEADERS_ALL_B HDR -- OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
5956: ,OKC_LINE_STYLES_V STL
5957: ,OKC_K_LINES_B LIN
5958: ,OKS_K_LINES_B OKSLIN -- 11.5.10 changes
5959: WHERE LIN.ID = Cx_Cle_Id --Commented by Jvorugan NVL(Cx_Cle_Id, LIN.ID)
5978: ,LIN.bill_to_site_use_id bill_to_site_use_id -- 11.5.10 changes
5979: ,LIN.ship_to_site_use_id ship_to_site_use_id -- 11.5.10 changes
5980: ,OKSLIN.discount_list discount_list -- 11.5.10 changes
5981: ,LIN.price_list_id price_list_id -- 11.5.10 changes
5982: FROM OKC_K_HEADERS_ALL_B HDR -- OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
5983: ,OKC_LINE_STYLES_V STL
5984: ,OKC_K_LINES_B LIN
5985: ,OKS_K_LINES_B OKSLIN -- 11.5.10 changes
5986: WHERE -- LIN.ID = NVL(Cx_Cle_Id, LIN.ID)
6224: ,LIN.PRICE_NEGOTIATED
6225: ,STL.NAME
6226: ,HDR.AUTHORING_ORG_ID ORG_ID
6227: ,HDR.INV_ORGANIZATION_ID ORGANIZATION_ID
6228: FROM OKC_K_HEADERS_ALL_B HDR -- OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
6229: ,OKC_LINE_STYLES_V STL
6230: ,OKC_K_LINES_B LIN
6231: ,OKS_K_LINES_B OKSLIN --11.5.10 changes
6232: WHERE LIN.ID = Cx_Cle_Id -- COmmented by Jvorugan for bug:4998337 NVL(Cx_Cle_Id, LIN.ID)
6244: ,LIN.PRICE_NEGOTIATED
6245: ,STL.NAME
6246: ,HDR.AUTHORING_ORG_ID ORG_ID
6247: ,HDR.INV_ORGANIZATION_ID ORGANIZATION_ID
6248: FROM OKC_K_HEADERS_ALL_B HDR -- OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
6249: ,OKC_LINE_STYLES_V STL
6250: ,OKC_K_LINES_B LIN
6251: ,OKS_K_LINES_B OKSLIN --11.5.10 changes
6252: WHERE -- LIN.ID = NVL(Cx_Cle_Id, LIN.ID)
10059: -- cursor modified to fix bug 3041443
10060:
10061: CURSOR Lx_Csr_Contracts(Cv_Contract_Num IN VARCHAR2, Cv_Contract_Num_Modifier IN VARCHAR2) IS
10062: SELECT Id
10063: FROM OKC_K_HEADERS_ALL_B -- OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
10064: WHERE Contract_Number = Cv_Contract_Num
10065: --AND (Cv_Contract_Num_Modifier IS NULL OR Contract_Number_Modifier = Cv_Contract_Num_Modifier);
10066: --AND nvl(Contract_Number_Modifier,-99) = nvl(Cv_Contract_Num_Modifier,-99)
10067: AND nvl(Contract_Number_Modifier,'#') = nvl(Cv_Contract_Num_Modifier,nvl(Contract_Number_Modifier,'#'));
10585: ,Get_End_Date_Time(CL.End_Date) End_Date
10586: ,Get_End_Date_Time(CL.Date_Terminated) Date_Terminated
10587: ,IT.Object1_Id1 Coverage_Level_Id
10588: ,DECODE(SB.Id, 14, 'Y', 15, 'Y', 16, 'Y', 17, 'Y', 18, 'Y', 'N') Warranty_Flag
10589: FROM OKC_K_HEADERS_ALL_B HD -- OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
10590: ,Okc_Line_Styles_B SB
10591: ,Okc_Line_Styles_TL ST
10592: ,Okc_K_Items IT
10593: ,Okc_K_Lines_B CL
10630: ,Get_End_Date_Time(CL.End_Date) End_Date
10631: ,Get_End_Date_Time(CL.Date_Terminated) Date_Terminated
10632: ,IT.Object1_Id1 Coverage_Level_Id
10633: ,DECODE(SB.Id, 14, 'Y', 15, 'Y', 16, 'Y', 17, 'Y', 18, 'Y', 'N') Warranty_Flag
10634: FROM OKC_K_HEADERS_ALL_B HD -- OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
10635: ,Okc_Line_Styles_B SB
10636: ,Okc_Line_Styles_TL ST
10637: ,Okc_K_Items IT
10638: ,Okc_K_Lines_B CL
11514: ,Get_End_Date_Time(CL.End_Date) CL_End_Date
11515: ,Get_End_Date_Time(CL.Date_Terminated) CL_Date_Terminated
11516: -- ,DECODE(SV.Lse_Id,14,'Y','N') Warranty_Flag
11517: ,DECODE(SV.Lse_Id, 14, 'Y', 15, 'Y', 16, 'Y', 17, 'Y', 18, 'Y', 'N') Warranty_Flag
11518: FROM OKC_K_HEADERS_ALL_B HD -- OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
11519: ,Okc_K_Lines_B SV
11520: ,Okc_K_Lines_B CL
11521: WHERE HD.Id = Cx_Chr_Id
11522: AND HD.Scs_Code IN ('SERVICE','WARRANTY')
11563: ,Get_End_Date_Time(CL.End_Date) CL_End_Date
11564: ,Get_End_Date_Time(CL.Date_Terminated) CL_Date_Terminated
11565: -- ,DECODE(SV.Lse_Id,14,'Y','N') Warranty_Flag
11566: ,DECODE(SV.Lse_Id, 14, 'Y', 15, 'Y', 16, 'Y', 17, 'Y', 18, 'Y', 'N') Warranty_Flag
11567: FROM OKC_K_HEADERS_ALL_B HD -- OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
11568: ,Okc_K_Lines_B SV
11569: ,Okc_K_Lines_B CL
11570: WHERE HD.Id = Cx_Chr_Id
11571: AND HD.Scs_Code IN ('SERVICE','WARRANTY','SUBSCRIPTION') ----Modified condition for ER9681794
11633: ,Get_End_Date_Time(CL.End_Date) CL_End_Date
11634: ,Get_End_Date_Time(CL.Date_Terminated) CL_Date_Terminated
11635: -- ,DECODE(SV.Lse_Id,14,'Y','N') Warranty_Flag
11636: ,DECODE(SV.Lse_Id, 14, 'Y', 15, 'Y', 16, 'Y', 17, 'Y', 18, 'Y', 'N') Warranty_Flag
11637: FROM OKC_K_HEADERS_ALL_B HD -- OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
11638: ,Okc_K_Lines_B SV
11639: ,Okc_K_Lines_B CL
11640: WHERE HD.Id = Cx_Chr_Id
11641: AND HD.Scs_Code IN ('SERVICE','WARRANTY')
11682: ,Get_End_Date_Time(CL.End_Date) CL_End_Date
11683: ,Get_End_Date_Time(CL.Date_Terminated) CL_Date_Terminated
11684: -- ,DECODE(SV.Lse_Id,14,'Y','N') Warranty_Flag
11685: ,DECODE(SV.Lse_Id, 14, 'Y', 15, 'Y', 16, 'Y', 17, 'Y', 18, 'Y', 'N') Warranty_Flag
11686: FROM OKC_K_HEADERS_ALL_B HD -- OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
11687: ,Okc_K_Lines_B SV
11688: ,Okc_K_Lines_B CL
11689: WHERE HD.Id = Cx_Chr_Id
11690: AND HD.Scs_Code IN ('SERVICE','WARRANTY','SUBSCRIPTION') -------Modified condition for ER9681794
11752: ,Get_End_Date_Time(CL.End_Date) CL_End_Date
11753: ,Get_End_Date_Time(CL.Date_Terminated) CL_Date_Terminated
11754: -- ,DECODE(SV.Lse_Id,14,'Y','N') Warranty_Flag
11755: ,DECODE(SV.Lse_Id, 14, 'Y', 15, 'Y', 16, 'Y', 17, 'Y', 18, 'Y', 'N') Warranty_Flag
11756: FROM OKC_K_HEADERS_ALL_B HD -- OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
11757: ,Okc_K_Lines_B SV
11758: ,Okc_K_Lines_B CL
11759: WHERE HD.Id = Cx_Chr_Id
11760: AND HD.Scs_Code IN ('SERVICE','WARRANTY')
11802: ,Get_End_Date_Time(CL.End_Date) CL_End_Date
11803: ,Get_End_Date_Time(CL.Date_Terminated) CL_Date_Terminated
11804: -- ,DECODE(SV.Lse_Id,14,'Y','N') Warranty_Flag
11805: ,DECODE(SV.Lse_Id, 14, 'Y', 15, 'Y', 16, 'Y', 17, 'Y', 18, 'Y', 'N') Warranty_Flag
11806: FROM OKC_K_HEADERS_ALL_B HD -- OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
11807: ,Okc_K_Lines_B SV
11808: ,Okc_K_Lines_B CL
11809: WHERE HD.Id = Cx_Chr_Id
11810: AND HD.Scs_Code IN ('SERVICE','WARRANTY','SUBSCRIPTION') ----Modified condition for ER9681794
11872: ,Get_End_Date_Time(CL.End_Date) CL_End_Date
11873: ,Get_End_Date_Time(CL.Date_Terminated) CL_Date_Terminated
11874: -- ,DECODE(SV.Lse_Id,14,'Y','N') Warranty_Flag
11875: ,DECODE(SV.Lse_Id, 14, 'Y', 15, 'Y', 16, 'Y', 17, 'Y', 18, 'Y', 'N') Warranty_Flag
11876: FROM OKC_K_HEADERS_ALL_B HD -- OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
11877: ,Okc_K_Lines_B SV
11878: ,Okc_K_Lines_B CL
11879: WHERE HD.Id = Cx_Chr_Id
11880: AND HD.Scs_Code IN ('SERVICE','WARRANTY')
11921: ,Get_End_Date_Time(CL.End_Date) CL_End_Date
11922: ,Get_End_Date_Time(CL.Date_Terminated) CL_Date_Terminated
11923: -- ,DECODE(SV.Lse_Id,14,'Y','N') Warranty_Flag
11924: ,DECODE(SV.Lse_Id, 14, 'Y', 15, 'Y', 16, 'Y', 17, 'Y', 18, 'Y', 'N') Warranty_Flag
11925: FROM OKC_K_HEADERS_ALL_B HD -- OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
11926: ,Okc_K_Lines_B SV
11927: ,Okc_K_Lines_B CL
11928: WHERE HD.Id = Cx_Chr_Id
11929: AND HD.Scs_Code IN ('SERVICE','WARRANTY','SUBSCRIPTION') ----Modified condition for ER9681794
13628: ,HB.Start_Date Contract_Start_Date
13629: ,Get_End_Date_Time(HB.End_Date) Contract_End_Date
13630: ,Get_End_Date_Time(HB.Date_Terminated) Contract_Terminated_Date
13631: FROM Okc_K_Headers_TL HT
13632: ,OKC_K_HEADERS_ALL_B HB -- OKC_K_HEADERS_B HB -- Modified for 12.0 MOAC project (JVARGHES)
13633: WHERE HB.Id = NVL(Cx_Chr_Id,HB.Id)
13634: AND HB.Contract_Number = NVL(Cv_Con_Number,HB.Contract_Number)
13635: AND (Cv_Con_Number_Modifier IS NULL OR HB.Contract_Number_Modifier = Cv_Con_Number_Modifier)
13636: AND (Cv_Con_Cusomer_Id IS NULL
13675: ,HB.Start_Date Contract_Start_Date
13676: ,Get_End_Date_Time(HB.End_Date) Contract_End_Date
13677: ,Get_End_Date_Time(HB.Date_Terminated) Contract_Terminated_Date
13678: FROM Okc_K_Headers_TL HT
13679: ,OKC_K_HEADERS_ALL_B HB -- OKC_K_HEADERS_B HB -- Modified for 12.0 MOAC project (JVARGHES)
13680: WHERE HB.Id = NVL(Cx_Chr_Id,HB.Id)
13681: AND HB.Contract_Number = NVL(Cv_Con_Number,HB.Contract_Number)
13682: AND (Cv_Con_Number_Modifier IS NULL OR HB.Contract_Number_Modifier = Cv_Con_Number_Modifier)
13683: AND (Cv_Con_Cusomer_Id IS NULL
14420: cvt.meaning,
14421: cvt.importance_level,
14422: okh.estimated_amount,
14423: okh.sts_code
14424: from OKC_K_HEADERS_ALL_B okh, -- OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
14425: okc_k_lines_b cle,
14426: oks_k_lines_b cle_ksl,
14427: oks_k_lines_b okscle_cov,
14428: okc_k_lines_b cle_cvl,
14488: covtyp.meaning,
14489: covtyp.importance_level importance_level,
14490: okh.estimated_amount,
14491: okh.sts_code
14492: from OKC_K_HEADERS_ALL_B okh, -- OKC_K_HEADERS_B okh -- Modified for 12.0 MOAC project (JVARGHES)
14493: okc_k_lines_b cle,
14494: oks_k_lines_b cle_ksl,
14495: oks_k_lines_b okscle_cov,
14496: okc_k_lines_b cle_cvl,
16503: CURSOR cur_hdr (p_line_id in number) is
16504: select hdr.id id,
16505: hdr.start_date start_date,
16506: hdr.end_date end_date
16507: from OKC_K_HEADERS_ALL_B hdr, --,OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
16508: okc_k_lines_v lines
16509: where lines.chr_id = hdr.id
16510: and lines.dnz_chr_id = hdr.id
16511: and lines.id = p_line_id;
18095: IS
18096:
18097: CURSOR KHDR_Date IS
18098: select end_date
18099: from OKC_K_HEADERS_ALL_B -- OKC_K_HEADERS_B -- Modified for 12.0 MOAC project (JVARGHES)
18100: where id = p_contract_id;
18101:
18102: Lx_CHR_Id CONSTANT Gx_OKS_Id := p_contract_id;
18103:
19244: Cv_contract_grp_id in number) IS
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
19272: /*Bug:6767455*/
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
19298: SELECT /*+ leading(b) use_nl(b oksb) */
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))
19381: SELECT /*+ leading(b) use_nl(b oksb) */
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)
19432: Cv_contract_grp_id in number) IS
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 = '#'
19475: Cv_contract_grp_id in number) IS
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 = '#'
19518: Cv_contract_grp_id in number) IS
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
19559: oksb.electronic_renewal_flag -- Added by Jyothi for perf bug:4991724
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 = '#'
19606: oksb.electronic_renewal_flag -- Added by Jyothi for perf bug:4991724
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 = '#'
19652: Cv_contract_grp_id in number) IS
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
19716: Cv_contract_grp_id in number) IS
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
19780: Cv_contract_grp_id in number) IS
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))*/
19856: Cv_contract_grp_id in number) IS
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)