[Home] [Help]
5364: ,OKSHDR.tax_status tax_status -- 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)
5421: Lx_Contract_Headers(Li_TableIdx).Period_Code := OKS_ENT_UTIL_PVT.Get_Duration_Period
5422: (Idx.Start_Date,Idx.End_Date,'P');
5423: Lx_Contract_Headers(Li_TableIdx).Start_Date_Active := Idx.Start_Date;
5424: Lx_Contract_Headers(Li_TableIdx).End_Date_Active := Idx.End_Date;
5425: 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
5426: 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
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));
5422: (Idx.Start_Date,Idx.End_Date,'P');
5423: Lx_Contract_Headers(Li_TableIdx).Start_Date_Active := Idx.Start_Date;
5424: Lx_Contract_Headers(Li_TableIdx).End_Date_Active := Idx.End_Date;
5425: 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
5426: 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
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
5424: Lx_Contract_Headers(Li_TableIdx).End_Date_Active := Idx.End_Date;
5425: 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
5426: 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
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
5426: 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
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;
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
5436: 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
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
5436: 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
5437: 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
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:
5453: X_Contract_Headers := Lx_Contract_Headers;
5563: ,LIN.bill_to_site_use_id bill_to_site_use_id -- 11.5.10 changes
5564: ,LIN.ship_to_site_use_id ship_to_site_use_id -- 11.5.10 changes
5565: ,OKSLIN.discount_list discount_list -- 11.5.10 changes
5566: ,LIN.price_list_id price_list_id -- 11.5.10 changes
5567: FROM OKC_K_HEADERS_ALL_B HDR -- OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
5568: ,OKC_LINE_STYLES_V STL
5569: ,OKC_K_LINES_B LIN
5570: ,OKS_K_LINES_B OKSLIN -- 11.5.10 changes
5571: WHERE LIN.ID = Cx_Cle_Id --Commented by Jvorugan NVL(Cx_Cle_Id, LIN.ID)
5590: ,LIN.bill_to_site_use_id bill_to_site_use_id -- 11.5.10 changes
5591: ,LIN.ship_to_site_use_id ship_to_site_use_id -- 11.5.10 changes
5592: ,OKSLIN.discount_list discount_list -- 11.5.10 changes
5593: ,LIN.price_list_id price_list_id -- 11.5.10 changes
5594: FROM OKC_K_HEADERS_ALL_B HDR -- OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
5595: ,OKC_LINE_STYLES_V STL
5596: ,OKC_K_LINES_B LIN
5597: ,OKS_K_LINES_B OKSLIN -- 11.5.10 changes
5598: WHERE -- LIN.ID = NVL(Cx_Cle_Id, LIN.ID)
5836: ,LIN.PRICE_NEGOTIATED
5837: ,STL.NAME
5838: ,HDR.AUTHORING_ORG_ID ORG_ID
5839: ,HDR.INV_ORGANIZATION_ID ORGANIZATION_ID
5840: FROM OKC_K_HEADERS_ALL_B HDR -- OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
5841: ,OKC_LINE_STYLES_V STL
5842: ,OKC_K_LINES_B LIN
5843: ,OKS_K_LINES_B OKSLIN --11.5.10 changes
5844: WHERE LIN.ID = Cx_Cle_Id -- COmmented by Jvorugan for bug:4998337 NVL(Cx_Cle_Id, LIN.ID)
5856: ,LIN.PRICE_NEGOTIATED
5857: ,STL.NAME
5858: ,HDR.AUTHORING_ORG_ID ORG_ID
5859: ,HDR.INV_ORGANIZATION_ID ORGANIZATION_ID
5860: FROM OKC_K_HEADERS_ALL_B HDR -- OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
5861: ,OKC_LINE_STYLES_V STL
5862: ,OKC_K_LINES_B LIN
5863: ,OKS_K_LINES_B OKSLIN --11.5.10 changes
5864: WHERE -- LIN.ID = NVL(Cx_Cle_Id, LIN.ID)
9628: -- cursor modified to fix bug 3041443
9629:
9630: CURSOR Lx_Csr_Contracts(Cv_Contract_Num IN VARCHAR2, Cv_Contract_Num_Modifier IN VARCHAR2) IS
9631: SELECT Id
9632: FROM OKC_K_HEADERS_ALL_B -- OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
9633: WHERE Contract_Number = Cv_Contract_Num
9634: --AND (Cv_Contract_Num_Modifier IS NULL OR Contract_Number_Modifier = Cv_Contract_Num_Modifier);
9635: --AND nvl(Contract_Number_Modifier,-99) = nvl(Cv_Contract_Num_Modifier,-99)
9636: AND nvl(Contract_Number_Modifier,'#') = nvl(Cv_Contract_Num_Modifier,nvl(Contract_Number_Modifier,'#'));
10154: ,Get_End_Date_Time(CL.End_Date) End_Date
10155: ,Get_End_Date_Time(CL.Date_Terminated) Date_Terminated
10156: ,IT.Object1_Id1 Coverage_Level_Id
10157: ,DECODE(SB.Id, 14, 'Y', 15, 'Y', 16, 'Y', 17, 'Y', 18, 'Y', 'N') Warranty_Flag
10158: FROM OKC_K_HEADERS_ALL_B HD -- OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
10159: ,Okc_Line_Styles_B SB
10160: ,Okc_Line_Styles_TL ST
10161: ,Okc_K_Items IT
10162: ,Okc_K_Lines_B CL
10885: ,Get_End_Date_Time(CL.End_Date) CL_End_Date
10886: ,Get_End_Date_Time(CL.Date_Terminated) CL_Date_Terminated
10887: -- ,DECODE(SV.Lse_Id,14,'Y','N') Warranty_Flag
10888: ,DECODE(SV.Lse_Id, 14, 'Y', 15, 'Y', 16, 'Y', 17, 'Y', 18, 'Y', 'N') Warranty_Flag
10889: FROM OKC_K_HEADERS_ALL_B HD -- OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
10890: ,Okc_K_Lines_B SV
10891: ,Okc_K_Lines_B CL
10892: WHERE HD.Id = Cx_Chr_Id
10893: AND HD.Scs_Code IN ('SERVICE','WARRANTY')
10954: ,Get_End_Date_Time(CL.End_Date) CL_End_Date
10955: ,Get_End_Date_Time(CL.Date_Terminated) CL_Date_Terminated
10956: -- ,DECODE(SV.Lse_Id,14,'Y','N') Warranty_Flag
10957: ,DECODE(SV.Lse_Id, 14, 'Y', 15, 'Y', 16, 'Y', 17, 'Y', 18, 'Y', 'N') Warranty_Flag
10958: FROM OKC_K_HEADERS_ALL_B HD -- OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
10959: ,Okc_K_Lines_B SV
10960: ,Okc_K_Lines_B CL
10961: WHERE HD.Id = Cx_Chr_Id
10962: AND HD.Scs_Code IN ('SERVICE','WARRANTY')
11023: ,Get_End_Date_Time(CL.End_Date) CL_End_Date
11024: ,Get_End_Date_Time(CL.Date_Terminated) CL_Date_Terminated
11025: -- ,DECODE(SV.Lse_Id,14,'Y','N') Warranty_Flag
11026: ,DECODE(SV.Lse_Id, 14, 'Y', 15, 'Y', 16, 'Y', 17, 'Y', 18, 'Y', 'N') Warranty_Flag
11027: FROM OKC_K_HEADERS_ALL_B HD -- OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
11028: ,Okc_K_Lines_B SV
11029: ,Okc_K_Lines_B CL
11030: WHERE HD.Id = Cx_Chr_Id
11031: AND HD.Scs_Code IN ('SERVICE','WARRANTY')
11092: ,Get_End_Date_Time(CL.End_Date) CL_End_Date
11093: ,Get_End_Date_Time(CL.Date_Terminated) CL_Date_Terminated
11094: -- ,DECODE(SV.Lse_Id,14,'Y','N') Warranty_Flag
11095: ,DECODE(SV.Lse_Id, 14, 'Y', 15, 'Y', 16, 'Y', 17, 'Y', 18, 'Y', 'N') Warranty_Flag
11096: FROM OKC_K_HEADERS_ALL_B HD -- OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
11097: ,Okc_K_Lines_B SV
11098: ,Okc_K_Lines_B CL
11099: WHERE HD.Id = Cx_Chr_Id
11100: AND HD.Scs_Code IN ('SERVICE','WARRANTY')
12377: ,HB.Start_Date Contract_Start_Date
12378: ,Get_End_Date_Time(HB.End_Date) Contract_End_Date
12379: ,Get_End_Date_Time(HB.Date_Terminated) Contract_Terminated_Date
12380: FROM Okc_K_Headers_TL HT
12381: ,OKC_K_HEADERS_ALL_B HB -- OKC_K_HEADERS_B HB -- Modified for 12.0 MOAC project (JVARGHES)
12382: WHERE HB.Id = NVL(Cx_Chr_Id,HB.Id)
12383: AND HB.Contract_Number = NVL(Cv_Con_Number,HB.Contract_Number)
12384: AND (Cv_Con_Number_Modifier IS NULL OR HB.Contract_Number_Modifier = Cv_Con_Number_Modifier)
12385: AND (Cv_Con_Cusomer_Id IS NULL
13062: cvt.meaning,
13063: cvt.importance_level,
13064: okh.estimated_amount,
13065: okh.sts_code
13066: from OKC_K_HEADERS_ALL_B okh, -- OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
13067: okc_k_lines_b cle,
13068: oks_k_lines_b cle_ksl,
13069: oks_k_lines_b okscle_cov,
13070: okc_k_lines_b cle_cvl,
13130: covtyp.meaning,
13131: covtyp.importance_level importance_level,
13132: okh.estimated_amount,
13133: okh.sts_code
13134: from OKC_K_HEADERS_ALL_B okh, -- OKC_K_HEADERS_B okh -- Modified for 12.0 MOAC project (JVARGHES)
13135: okc_k_lines_b cle,
13136: oks_k_lines_b cle_ksl,
13137: oks_k_lines_b okscle_cov,
13138: okc_k_lines_b cle_cvl,
15100: CURSOR cur_hdr (p_line_id in number) is
15101: select hdr.id id,
15102: hdr.start_date start_date,
15103: hdr.end_date end_date
15104: from OKC_K_HEADERS_ALL_B hdr, --,OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
15105: okc_k_lines_v lines
15106: where lines.chr_id = hdr.id
15107: and lines.dnz_chr_id = hdr.id
15108: and lines.id = p_line_id;
16251: IS
16252:
16253: CURSOR KHDR_Date IS
16254: select end_date
16255: from OKC_K_HEADERS_ALL_B -- OKC_K_HEADERS_B -- Modified for 12.0 MOAC project (JVARGHES)
16256: where id = p_contract_id;
16257:
16258: Lx_CHR_Id CONSTANT Gx_OKS_Id := p_contract_id;
16259:
17400: Cv_contract_grp_id in number) IS
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
17428: /*Bug:6767455*/
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
17454: SELECT /*+ leading(b) use_nl(b oksb) */
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))
17534: Cv_contract_grp_id in number) IS
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 = '#'
17577: Cv_contract_grp_id in number) IS
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
17618: oksb.electronic_renewal_flag -- Added by Jyothi for perf bug:4991724
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 = '#'
17663: Cv_contract_grp_id in number) IS
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
17726: Cv_contract_grp_id in number) IS
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))*/