APPS.OKS_ENTITLEMENTS_PVT dependencies on OKS_ENT_UTIL_PVT

Line 5801: Lx_Contract_Headers(Li_TableIdx).Contract_Amount := Idx.Estimated_amount; --11.5.10 changes..OKS_ENT_UTIL_PVT.Get_Contract_Amount(Idx.Id);

5797: Lx_Contract_Headers(Li_TableIdx).Contract_Id := Idx.Id;
5798: Lx_Contract_Headers(Li_TableIdx).Contract_Number := Idx.Contract_Number;
5799: Lx_Contract_Headers(Li_TableIdx).Contract_Number_Modifier := Idx.Contract_Number_Modifier;
5800: Lx_Contract_Headers(Li_TableIdx).Short_Description := Idx.Short_Description;
5801: Lx_Contract_Headers(Li_TableIdx).Contract_Amount := Idx.Estimated_amount; --11.5.10 changes..OKS_ENT_UTIL_PVT.Get_Contract_Amount(Idx.Id);
5802: Lx_Contract_Headers(Li_TableIdx).Contract_Status_Code := Idx.Sts_Code;
5803: Lx_Contract_Headers(Li_TableIdx).Contract_Type := Idx.Chr_Type;
5804: Lx_Contract_Headers(Li_TableIdx).Party_Id := TO_NUMBER(Idx.Party_Id);
5805: Lx_Contract_Headers(Li_TableIdx).Template_YN := Idx.Template_YN;

Line 5807: Lx_Contract_Headers(Li_TableIdx).Duration := TO_NUMBER(OKS_ENT_UTIL_PVT.Get_Duration_Period

5803: Lx_Contract_Headers(Li_TableIdx).Contract_Type := Idx.Chr_Type;
5804: Lx_Contract_Headers(Li_TableIdx).Party_Id := TO_NUMBER(Idx.Party_Id);
5805: Lx_Contract_Headers(Li_TableIdx).Template_YN := Idx.Template_YN;
5806: Lx_Contract_Headers(Li_TableIdx).Template_Used := Idx.Template_Used;
5807: Lx_Contract_Headers(Li_TableIdx).Duration := TO_NUMBER(OKS_ENT_UTIL_PVT.Get_Duration_Period
5808: (Idx.Start_Date,Idx.End_Date,'D'));
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;

Line 5809: Lx_Contract_Headers(Li_TableIdx).Period_Code := OKS_ENT_UTIL_PVT.Get_Duration_Period

5805: Lx_Contract_Headers(Li_TableIdx).Template_YN := Idx.Template_YN;
5806: Lx_Contract_Headers(Li_TableIdx).Template_Used := Idx.Template_Used;
5807: Lx_Contract_Headers(Li_TableIdx).Duration := TO_NUMBER(OKS_ENT_UTIL_PVT.Get_Duration_Period
5808: (Idx.Start_Date,Idx.End_Date,'D'));
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

Line 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

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));

Line 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

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

Line 5815: Lx_Contract_Headers(Li_TableIdx).Agreement_Id := OKS_ENT_UTIL_PVT.Get_Agreement(Idx.Id);

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
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

Line 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

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

Line 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));

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
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

Line 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

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;

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 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

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

Line 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

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

Line 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

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
5826: Lx_Contract_Headers(Li_TableIdx).Regular_Offset_Days := null; -- does not exist in 11.5.10 --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BillingSchedule(Idx.Id,NULL,'R'));--null
5827: Lx_Contract_Headers(Li_TableIdx).First_Bill_To := null; -- does not exist in 11.5.10 --TO_DATE(OKS_ENT_UTIL_PVT.Get_BillingSchedule

Line 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

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
5826: Lx_Contract_Headers(Li_TableIdx).Regular_Offset_Days := null; -- does not exist in 11.5.10 --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BillingSchedule(Idx.Id,NULL,'R'));--null
5827: Lx_Contract_Headers(Li_TableIdx).First_Bill_To := null; -- does not exist in 11.5.10 --TO_DATE(OKS_ENT_UTIL_PVT.Get_BillingSchedule
5828: --(Idx.Id,NULL,'T'),'YYYY/MM/DD HH24:MI:SS'); --null

Line 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

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
5826: Lx_Contract_Headers(Li_TableIdx).Regular_Offset_Days := null; -- does not exist in 11.5.10 --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BillingSchedule(Idx.Id,NULL,'R'));--null
5827: Lx_Contract_Headers(Li_TableIdx).First_Bill_To := null; -- does not exist in 11.5.10 --TO_DATE(OKS_ENT_UTIL_PVT.Get_BillingSchedule
5828: --(Idx.Id,NULL,'T'),'YYYY/MM/DD HH24:MI:SS'); --null
5829: Lx_Contract_Headers(Li_TableIdx).First_Bill_On := null; -- does not exist in 11.5.10 --TO_DATE(OKS_ENT_UTIL_PVT.Get_BillingSchedule

Line 5826: Lx_Contract_Headers(Li_TableIdx).Regular_Offset_Days := null; -- does not exist in 11.5.10 --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BillingSchedule(Idx.Id,NULL,'R'));--null

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
5826: Lx_Contract_Headers(Li_TableIdx).Regular_Offset_Days := null; -- does not exist in 11.5.10 --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BillingSchedule(Idx.Id,NULL,'R'));--null
5827: Lx_Contract_Headers(Li_TableIdx).First_Bill_To := null; -- does not exist in 11.5.10 --TO_DATE(OKS_ENT_UTIL_PVT.Get_BillingSchedule
5828: --(Idx.Id,NULL,'T'),'YYYY/MM/DD HH24:MI:SS'); --null
5829: Lx_Contract_Headers(Li_TableIdx).First_Bill_On := null; -- does not exist in 11.5.10 --TO_DATE(OKS_ENT_UTIL_PVT.Get_BillingSchedule
5830: ---(Idx.Id,NULL,'O'),'YYYY/MM/DD HH24:MI:SS'); --null

Line 5827: Lx_Contract_Headers(Li_TableIdx).First_Bill_To := null; -- does not exist in 11.5.10 --TO_DATE(OKS_ENT_UTIL_PVT.Get_BillingSchedule

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
5826: Lx_Contract_Headers(Li_TableIdx).Regular_Offset_Days := null; -- does not exist in 11.5.10 --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BillingSchedule(Idx.Id,NULL,'R'));--null
5827: Lx_Contract_Headers(Li_TableIdx).First_Bill_To := null; -- does not exist in 11.5.10 --TO_DATE(OKS_ENT_UTIL_PVT.Get_BillingSchedule
5828: --(Idx.Id,NULL,'T'),'YYYY/MM/DD HH24:MI:SS'); --null
5829: Lx_Contract_Headers(Li_TableIdx).First_Bill_On := null; -- does not exist in 11.5.10 --TO_DATE(OKS_ENT_UTIL_PVT.Get_BillingSchedule
5830: ---(Idx.Id,NULL,'O'),'YYYY/MM/DD HH24:MI:SS'); --null
5831: Lx_Contract_Headers(Li_TableIdx).Auto_Renew_Before_Days := Idx.Auto_Renew_Days;

Line 5829: Lx_Contract_Headers(Li_TableIdx).First_Bill_On := null; -- does not exist in 11.5.10 --TO_DATE(OKS_ENT_UTIL_PVT.Get_BillingSchedule

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
5826: Lx_Contract_Headers(Li_TableIdx).Regular_Offset_Days := null; -- does not exist in 11.5.10 --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BillingSchedule(Idx.Id,NULL,'R'));--null
5827: Lx_Contract_Headers(Li_TableIdx).First_Bill_To := null; -- does not exist in 11.5.10 --TO_DATE(OKS_ENT_UTIL_PVT.Get_BillingSchedule
5828: --(Idx.Id,NULL,'T'),'YYYY/MM/DD HH24:MI:SS'); --null
5829: Lx_Contract_Headers(Li_TableIdx).First_Bill_On := null; -- does not exist in 11.5.10 --TO_DATE(OKS_ENT_UTIL_PVT.Get_BillingSchedule
5830: ---(Idx.Id,NULL,'O'),'YYYY/MM/DD HH24:MI:SS'); --null
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');

Line 5833: Lx_Contract_Headers(Li_TableIdx).Renewal_Note := OKS_ENT_UTIL_PVT.Get_RenterNotes(Idx.Id,'RENEW');

5829: Lx_Contract_Headers(Li_TableIdx).First_Bill_On := null; -- does not exist in 11.5.10 --TO_DATE(OKS_ENT_UTIL_PVT.Get_BillingSchedule
5830: ---(Idx.Id,NULL,'O'),'YYYY/MM/DD HH24:MI:SS'); --null
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

Line 5834: Lx_Contract_Headers(Li_TableIdx).Termination_Note := OKS_ENT_UTIL_PVT.Get_RenterNotes(Idx.Id,'TER');

5830: ---(Idx.Id,NULL,'O'),'YYYY/MM/DD HH24:MI:SS'); --null
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:

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 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

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;

Line 6025: Lx_Contract_Lines(Li_TableIdx).Duration := TO_NUMBER(OKS_ENT_UTIL_PVT.Get_Duration_Period

6021: Lx_Contract_Lines(Li_TableIdx).Contract_Line_Id := Idx.Id;
6022: Lx_Contract_Lines(Li_TableIdx).Contract_Parent_Line_Id := Idx.Cle_Id;
6023: Lx_Contract_Lines(Li_TableIdx).Contract_Id := Idx.Dnz_Chr_Id;
6024: Lx_Contract_Lines(Li_TableIdx).Line_Status_Code := Idx.Sts_Code;
6025: Lx_Contract_Lines(Li_TableIdx).Duration := TO_NUMBER(OKS_ENT_UTIL_PVT.Get_Duration_Period
6026: (Idx.Start_Date,Idx.End_Date,'D'));
6027: Lx_Contract_Lines(Li_TableIdx).Period_Code := OKS_ENT_UTIL_PVT.Get_Duration_Period
6028: (Idx.Start_Date,Idx.End_Date,'P');
6029: Lx_Contract_Lines(Li_TableIdx).Start_Date_Active := Idx.Start_Date;

Line 6027: Lx_Contract_Lines(Li_TableIdx).Period_Code := OKS_ENT_UTIL_PVT.Get_Duration_Period

6023: Lx_Contract_Lines(Li_TableIdx).Contract_Id := Idx.Dnz_Chr_Id;
6024: Lx_Contract_Lines(Li_TableIdx).Line_Status_Code := Idx.Sts_Code;
6025: Lx_Contract_Lines(Li_TableIdx).Duration := TO_NUMBER(OKS_ENT_UTIL_PVT.Get_Duration_Period
6026: (Idx.Start_Date,Idx.End_Date,'D'));
6027: Lx_Contract_Lines(Li_TableIdx).Period_Code := OKS_ENT_UTIL_PVT.Get_Duration_Period
6028: (Idx.Start_Date,Idx.End_Date,'P');
6029: Lx_Contract_Lines(Li_TableIdx).Start_Date_Active := Idx.Start_Date;
6030: Lx_Contract_Lines(Li_TableIdx).End_Date_Active := Idx.End_Date;
6031: Lx_Contract_Lines(Li_TableIdx).Line_Name := Idx.Name;

Line 6032: Lx_Contract_Lines(Li_TableIdx).Bill_To_Site_Use_Id := Idx.Bill_To_Site_Use_Id; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BilltoShipto

6028: (Idx.Start_Date,Idx.End_Date,'P');
6029: Lx_Contract_Lines(Li_TableIdx).Start_Date_Active := Idx.Start_Date;
6030: Lx_Contract_Lines(Li_TableIdx).End_Date_Active := Idx.End_Date;
6031: Lx_Contract_Lines(Li_TableIdx).Line_Name := Idx.Name;
6032: Lx_Contract_Lines(Li_TableIdx).Bill_To_Site_Use_Id := Idx.Bill_To_Site_Use_Id; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BilltoShipto
6033: --(NULL,Idx.Id,'OKX_BILLTO')); -- okc_k_lines_b.bill_to_site_use_id
6034: Lx_Contract_Lines(Li_TableIdx).Ship_To_Site_Use_Id := Idx.Ship_To_Site_Use_Id; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BilltoShipto
6035: --(NULL,Idx.Id,'OKX_SHIPTO')); --okc_k_lines_b.ship_to_site_use_id
6036: Lx_Contract_Lines(Li_TableIdx).Modifier := Idx.discount_list; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_Discount(NULL,Idx.Id)); --oks_k_lines_b.discount_list

Line 6034: Lx_Contract_Lines(Li_TableIdx).Ship_To_Site_Use_Id := Idx.Ship_To_Site_Use_Id; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BilltoShipto

6030: Lx_Contract_Lines(Li_TableIdx).End_Date_Active := Idx.End_Date;
6031: Lx_Contract_Lines(Li_TableIdx).Line_Name := Idx.Name;
6032: Lx_Contract_Lines(Li_TableIdx).Bill_To_Site_Use_Id := Idx.Bill_To_Site_Use_Id; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BilltoShipto
6033: --(NULL,Idx.Id,'OKX_BILLTO')); -- okc_k_lines_b.bill_to_site_use_id
6034: Lx_Contract_Lines(Li_TableIdx).Ship_To_Site_Use_Id := Idx.Ship_To_Site_Use_Id; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BilltoShipto
6035: --(NULL,Idx.Id,'OKX_SHIPTO')); --okc_k_lines_b.ship_to_site_use_id
6036: Lx_Contract_Lines(Li_TableIdx).Modifier := Idx.discount_list; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_Discount(NULL,Idx.Id)); --oks_k_lines_b.discount_list
6037: Lx_Contract_Lines(Li_TableIdx).Price_List_Id := Idx.price_list_id; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_PriceList(NULL,Idx.Id,'P')); --okc_k_lines_b.price_list_id
6038: Lx_Contract_Lines(Li_TableIdx).Price_Negotiated := Idx.Price_Negotiated;

Line 6036: Lx_Contract_Lines(Li_TableIdx).Modifier := Idx.discount_list; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_Discount(NULL,Idx.Id)); --oks_k_lines_b.discount_list

6032: Lx_Contract_Lines(Li_TableIdx).Bill_To_Site_Use_Id := Idx.Bill_To_Site_Use_Id; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BilltoShipto
6033: --(NULL,Idx.Id,'OKX_BILLTO')); -- okc_k_lines_b.bill_to_site_use_id
6034: Lx_Contract_Lines(Li_TableIdx).Ship_To_Site_Use_Id := Idx.Ship_To_Site_Use_Id; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BilltoShipto
6035: --(NULL,Idx.Id,'OKX_SHIPTO')); --okc_k_lines_b.ship_to_site_use_id
6036: Lx_Contract_Lines(Li_TableIdx).Modifier := Idx.discount_list; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_Discount(NULL,Idx.Id)); --oks_k_lines_b.discount_list
6037: Lx_Contract_Lines(Li_TableIdx).Price_List_Id := Idx.price_list_id; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_PriceList(NULL,Idx.Id,'P')); --okc_k_lines_b.price_list_id
6038: Lx_Contract_Lines(Li_TableIdx).Price_Negotiated := Idx.Price_Negotiated;
6039: Lx_Contract_Lines(Li_TableIdx).Billing_Profile_Id := null; -- does not exist in 11.5.10 --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BillingProfile(NULL,Idx.Id)); --null
6040: Lx_Contract_Lines(Li_TableIdx).Billing_Frequency := null; -- does not exist in 11.5.10 --SUBSTR(OKS_ENT_UTIL_PVT.Get_BillingSchedule(NULL,Idx.Id,'F'),1,25); --null

Line 6037: Lx_Contract_Lines(Li_TableIdx).Price_List_Id := Idx.price_list_id; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_PriceList(NULL,Idx.Id,'P')); --okc_k_lines_b.price_list_id

6033: --(NULL,Idx.Id,'OKX_BILLTO')); -- okc_k_lines_b.bill_to_site_use_id
6034: Lx_Contract_Lines(Li_TableIdx).Ship_To_Site_Use_Id := Idx.Ship_To_Site_Use_Id; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BilltoShipto
6035: --(NULL,Idx.Id,'OKX_SHIPTO')); --okc_k_lines_b.ship_to_site_use_id
6036: Lx_Contract_Lines(Li_TableIdx).Modifier := Idx.discount_list; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_Discount(NULL,Idx.Id)); --oks_k_lines_b.discount_list
6037: Lx_Contract_Lines(Li_TableIdx).Price_List_Id := Idx.price_list_id; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_PriceList(NULL,Idx.Id,'P')); --okc_k_lines_b.price_list_id
6038: Lx_Contract_Lines(Li_TableIdx).Price_Negotiated := Idx.Price_Negotiated;
6039: Lx_Contract_Lines(Li_TableIdx).Billing_Profile_Id := null; -- does not exist in 11.5.10 --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BillingProfile(NULL,Idx.Id)); --null
6040: Lx_Contract_Lines(Li_TableIdx).Billing_Frequency := null; -- does not exist in 11.5.10 --SUBSTR(OKS_ENT_UTIL_PVT.Get_BillingSchedule(NULL,Idx.Id,'F'),1,25); --null
6041: Lx_Contract_Lines(Li_TableIdx).Billing_Method := null; -- does not exist in 11.5.10 --SUBSTR(OKS_ENT_UTIL_PVT.Get_BillingSchedule(NULL,Idx.Id,'M'),1,3); --null

Line 6039: Lx_Contract_Lines(Li_TableIdx).Billing_Profile_Id := null; -- does not exist in 11.5.10 --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BillingProfile(NULL,Idx.Id)); --null

6035: --(NULL,Idx.Id,'OKX_SHIPTO')); --okc_k_lines_b.ship_to_site_use_id
6036: Lx_Contract_Lines(Li_TableIdx).Modifier := Idx.discount_list; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_Discount(NULL,Idx.Id)); --oks_k_lines_b.discount_list
6037: Lx_Contract_Lines(Li_TableIdx).Price_List_Id := Idx.price_list_id; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_PriceList(NULL,Idx.Id,'P')); --okc_k_lines_b.price_list_id
6038: Lx_Contract_Lines(Li_TableIdx).Price_Negotiated := Idx.Price_Negotiated;
6039: Lx_Contract_Lines(Li_TableIdx).Billing_Profile_Id := null; -- does not exist in 11.5.10 --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BillingProfile(NULL,Idx.Id)); --null
6040: Lx_Contract_Lines(Li_TableIdx).Billing_Frequency := null; -- does not exist in 11.5.10 --SUBSTR(OKS_ENT_UTIL_PVT.Get_BillingSchedule(NULL,Idx.Id,'F'),1,25); --null
6041: Lx_Contract_Lines(Li_TableIdx).Billing_Method := null; -- does not exist in 11.5.10 --SUBSTR(OKS_ENT_UTIL_PVT.Get_BillingSchedule(NULL,Idx.Id,'M'),1,3); --null
6042: Lx_Contract_Lines(Li_TableIdx).Regular_Offset_Days := null; -- does not exist in 11.5.10 --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BillingSchedule(NULL,Idx.Id,'R')); --null
6043: Lx_Contract_Lines(Li_TableIdx).First_Bill_To := null; -- does not exist in 11.5.10 --TO_DATE(OKS_ENT_UTIL_PVT.Get_BillingSchedule

Line 6040: Lx_Contract_Lines(Li_TableIdx).Billing_Frequency := null; -- does not exist in 11.5.10 --SUBSTR(OKS_ENT_UTIL_PVT.Get_BillingSchedule(NULL,Idx.Id,'F'),1,25); --null

6036: Lx_Contract_Lines(Li_TableIdx).Modifier := Idx.discount_list; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_Discount(NULL,Idx.Id)); --oks_k_lines_b.discount_list
6037: Lx_Contract_Lines(Li_TableIdx).Price_List_Id := Idx.price_list_id; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_PriceList(NULL,Idx.Id,'P')); --okc_k_lines_b.price_list_id
6038: Lx_Contract_Lines(Li_TableIdx).Price_Negotiated := Idx.Price_Negotiated;
6039: Lx_Contract_Lines(Li_TableIdx).Billing_Profile_Id := null; -- does not exist in 11.5.10 --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BillingProfile(NULL,Idx.Id)); --null
6040: Lx_Contract_Lines(Li_TableIdx).Billing_Frequency := null; -- does not exist in 11.5.10 --SUBSTR(OKS_ENT_UTIL_PVT.Get_BillingSchedule(NULL,Idx.Id,'F'),1,25); --null
6041: Lx_Contract_Lines(Li_TableIdx).Billing_Method := null; -- does not exist in 11.5.10 --SUBSTR(OKS_ENT_UTIL_PVT.Get_BillingSchedule(NULL,Idx.Id,'M'),1,3); --null
6042: Lx_Contract_Lines(Li_TableIdx).Regular_Offset_Days := null; -- does not exist in 11.5.10 --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BillingSchedule(NULL,Idx.Id,'R')); --null
6043: Lx_Contract_Lines(Li_TableIdx).First_Bill_To := null; -- does not exist in 11.5.10 --TO_DATE(OKS_ENT_UTIL_PVT.Get_BillingSchedule
6044: --(NULL,Idx.Id,'T'),'YYYY/MM/DD HH24:MI:SS'); --null

Line 6041: Lx_Contract_Lines(Li_TableIdx).Billing_Method := null; -- does not exist in 11.5.10 --SUBSTR(OKS_ENT_UTIL_PVT.Get_BillingSchedule(NULL,Idx.Id,'M'),1,3); --null

6037: Lx_Contract_Lines(Li_TableIdx).Price_List_Id := Idx.price_list_id; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_PriceList(NULL,Idx.Id,'P')); --okc_k_lines_b.price_list_id
6038: Lx_Contract_Lines(Li_TableIdx).Price_Negotiated := Idx.Price_Negotiated;
6039: Lx_Contract_Lines(Li_TableIdx).Billing_Profile_Id := null; -- does not exist in 11.5.10 --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BillingProfile(NULL,Idx.Id)); --null
6040: Lx_Contract_Lines(Li_TableIdx).Billing_Frequency := null; -- does not exist in 11.5.10 --SUBSTR(OKS_ENT_UTIL_PVT.Get_BillingSchedule(NULL,Idx.Id,'F'),1,25); --null
6041: Lx_Contract_Lines(Li_TableIdx).Billing_Method := null; -- does not exist in 11.5.10 --SUBSTR(OKS_ENT_UTIL_PVT.Get_BillingSchedule(NULL,Idx.Id,'M'),1,3); --null
6042: Lx_Contract_Lines(Li_TableIdx).Regular_Offset_Days := null; -- does not exist in 11.5.10 --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BillingSchedule(NULL,Idx.Id,'R')); --null
6043: Lx_Contract_Lines(Li_TableIdx).First_Bill_To := null; -- does not exist in 11.5.10 --TO_DATE(OKS_ENT_UTIL_PVT.Get_BillingSchedule
6044: --(NULL,Idx.Id,'T'),'YYYY/MM/DD HH24:MI:SS'); --null
6045: Lx_Contract_Lines(Li_TableIdx).First_Bill_On := null; -- does not exist in 11.5.10 --TO_DATE(OKS_ENT_UTIL_PVT.Get_BillingSchedule

Line 6042: Lx_Contract_Lines(Li_TableIdx).Regular_Offset_Days := null; -- does not exist in 11.5.10 --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BillingSchedule(NULL,Idx.Id,'R')); --null

6038: Lx_Contract_Lines(Li_TableIdx).Price_Negotiated := Idx.Price_Negotiated;
6039: Lx_Contract_Lines(Li_TableIdx).Billing_Profile_Id := null; -- does not exist in 11.5.10 --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BillingProfile(NULL,Idx.Id)); --null
6040: Lx_Contract_Lines(Li_TableIdx).Billing_Frequency := null; -- does not exist in 11.5.10 --SUBSTR(OKS_ENT_UTIL_PVT.Get_BillingSchedule(NULL,Idx.Id,'F'),1,25); --null
6041: Lx_Contract_Lines(Li_TableIdx).Billing_Method := null; -- does not exist in 11.5.10 --SUBSTR(OKS_ENT_UTIL_PVT.Get_BillingSchedule(NULL,Idx.Id,'M'),1,3); --null
6042: Lx_Contract_Lines(Li_TableIdx).Regular_Offset_Days := null; -- does not exist in 11.5.10 --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BillingSchedule(NULL,Idx.Id,'R')); --null
6043: Lx_Contract_Lines(Li_TableIdx).First_Bill_To := null; -- does not exist in 11.5.10 --TO_DATE(OKS_ENT_UTIL_PVT.Get_BillingSchedule
6044: --(NULL,Idx.Id,'T'),'YYYY/MM/DD HH24:MI:SS'); --null
6045: Lx_Contract_Lines(Li_TableIdx).First_Bill_On := null; -- does not exist in 11.5.10 --TO_DATE(OKS_ENT_UTIL_PVT.Get_BillingSchedule
6046: --(NULL,Idx.Id,'O'),'YYYY/MM/DD HH24:MI:SS'); --null

Line 6043: Lx_Contract_Lines(Li_TableIdx).First_Bill_To := null; -- does not exist in 11.5.10 --TO_DATE(OKS_ENT_UTIL_PVT.Get_BillingSchedule

6039: Lx_Contract_Lines(Li_TableIdx).Billing_Profile_Id := null; -- does not exist in 11.5.10 --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BillingProfile(NULL,Idx.Id)); --null
6040: Lx_Contract_Lines(Li_TableIdx).Billing_Frequency := null; -- does not exist in 11.5.10 --SUBSTR(OKS_ENT_UTIL_PVT.Get_BillingSchedule(NULL,Idx.Id,'F'),1,25); --null
6041: Lx_Contract_Lines(Li_TableIdx).Billing_Method := null; -- does not exist in 11.5.10 --SUBSTR(OKS_ENT_UTIL_PVT.Get_BillingSchedule(NULL,Idx.Id,'M'),1,3); --null
6042: Lx_Contract_Lines(Li_TableIdx).Regular_Offset_Days := null; -- does not exist in 11.5.10 --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BillingSchedule(NULL,Idx.Id,'R')); --null
6043: Lx_Contract_Lines(Li_TableIdx).First_Bill_To := null; -- does not exist in 11.5.10 --TO_DATE(OKS_ENT_UTIL_PVT.Get_BillingSchedule
6044: --(NULL,Idx.Id,'T'),'YYYY/MM/DD HH24:MI:SS'); --null
6045: Lx_Contract_Lines(Li_TableIdx).First_Bill_On := null; -- does not exist in 11.5.10 --TO_DATE(OKS_ENT_UTIL_PVT.Get_BillingSchedule
6046: --(NULL,Idx.Id,'O'),'YYYY/MM/DD HH24:MI:SS'); --null
6047: Lx_Contract_Lines(Li_TableIdx).Termination_Date := Idx.Date_Terminated;

Line 6045: Lx_Contract_Lines(Li_TableIdx).First_Bill_On := null; -- does not exist in 11.5.10 --TO_DATE(OKS_ENT_UTIL_PVT.Get_BillingSchedule

6041: Lx_Contract_Lines(Li_TableIdx).Billing_Method := null; -- does not exist in 11.5.10 --SUBSTR(OKS_ENT_UTIL_PVT.Get_BillingSchedule(NULL,Idx.Id,'M'),1,3); --null
6042: Lx_Contract_Lines(Li_TableIdx).Regular_Offset_Days := null; -- does not exist in 11.5.10 --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BillingSchedule(NULL,Idx.Id,'R')); --null
6043: Lx_Contract_Lines(Li_TableIdx).First_Bill_To := null; -- does not exist in 11.5.10 --TO_DATE(OKS_ENT_UTIL_PVT.Get_BillingSchedule
6044: --(NULL,Idx.Id,'T'),'YYYY/MM/DD HH24:MI:SS'); --null
6045: Lx_Contract_Lines(Li_TableIdx).First_Bill_On := null; -- does not exist in 11.5.10 --TO_DATE(OKS_ENT_UTIL_PVT.Get_BillingSchedule
6046: --(NULL,Idx.Id,'O'),'YYYY/MM/DD HH24:MI:SS'); --null
6047: Lx_Contract_Lines(Li_TableIdx).Termination_Date := Idx.Date_Terminated;
6048:
6049: END LOOP;

Line 6061: Lx_Contract_Lines(Li_TableIdx).Duration := TO_NUMBER(OKS_ENT_UTIL_PVT.Get_Duration_Period

6057: Lx_Contract_Lines(Li_TableIdx).Contract_Line_Id := Idx.Id;
6058: Lx_Contract_Lines(Li_TableIdx).Contract_Parent_Line_Id := Idx.Cle_Id;
6059: Lx_Contract_Lines(Li_TableIdx).Contract_Id := Idx.Dnz_Chr_Id;
6060: Lx_Contract_Lines(Li_TableIdx).Line_Status_Code := Idx.Sts_Code;
6061: Lx_Contract_Lines(Li_TableIdx).Duration := TO_NUMBER(OKS_ENT_UTIL_PVT.Get_Duration_Period
6062: (Idx.Start_Date,Idx.End_Date,'D'));
6063: Lx_Contract_Lines(Li_TableIdx).Period_Code := OKS_ENT_UTIL_PVT.Get_Duration_Period
6064: (Idx.Start_Date,Idx.End_Date,'P');
6065: Lx_Contract_Lines(Li_TableIdx).Start_Date_Active := Idx.Start_Date;

Line 6063: Lx_Contract_Lines(Li_TableIdx).Period_Code := OKS_ENT_UTIL_PVT.Get_Duration_Period

6059: Lx_Contract_Lines(Li_TableIdx).Contract_Id := Idx.Dnz_Chr_Id;
6060: Lx_Contract_Lines(Li_TableIdx).Line_Status_Code := Idx.Sts_Code;
6061: Lx_Contract_Lines(Li_TableIdx).Duration := TO_NUMBER(OKS_ENT_UTIL_PVT.Get_Duration_Period
6062: (Idx.Start_Date,Idx.End_Date,'D'));
6063: Lx_Contract_Lines(Li_TableIdx).Period_Code := OKS_ENT_UTIL_PVT.Get_Duration_Period
6064: (Idx.Start_Date,Idx.End_Date,'P');
6065: Lx_Contract_Lines(Li_TableIdx).Start_Date_Active := Idx.Start_Date;
6066: Lx_Contract_Lines(Li_TableIdx).End_Date_Active := Idx.End_Date;
6067: Lx_Contract_Lines(Li_TableIdx).Line_Name := Idx.Name;

Line 6068: Lx_Contract_Lines(Li_TableIdx).Bill_To_Site_Use_Id := Idx.Bill_To_Site_Use_Id; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BilltoShipto

6064: (Idx.Start_Date,Idx.End_Date,'P');
6065: Lx_Contract_Lines(Li_TableIdx).Start_Date_Active := Idx.Start_Date;
6066: Lx_Contract_Lines(Li_TableIdx).End_Date_Active := Idx.End_Date;
6067: Lx_Contract_Lines(Li_TableIdx).Line_Name := Idx.Name;
6068: Lx_Contract_Lines(Li_TableIdx).Bill_To_Site_Use_Id := Idx.Bill_To_Site_Use_Id; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BilltoShipto
6069: --(NULL,Idx.Id,'OKX_BILLTO')); -- okc_k_lines_b.bill_to_site_use_id
6070: Lx_Contract_Lines(Li_TableIdx).Ship_To_Site_Use_Id := Idx.Ship_To_Site_Use_Id; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BilltoShipto
6071: --(NULL,Idx.Id,'OKX_SHIPTO')); --okc_k_lines_b.ship_to_site_use_id
6072: Lx_Contract_Lines(Li_TableIdx).Modifier := Idx.discount_list; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_Discount(NULL,Idx.Id)); --oks_k_lines_b.discount_list

Line 6070: Lx_Contract_Lines(Li_TableIdx).Ship_To_Site_Use_Id := Idx.Ship_To_Site_Use_Id; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BilltoShipto

6066: Lx_Contract_Lines(Li_TableIdx).End_Date_Active := Idx.End_Date;
6067: Lx_Contract_Lines(Li_TableIdx).Line_Name := Idx.Name;
6068: Lx_Contract_Lines(Li_TableIdx).Bill_To_Site_Use_Id := Idx.Bill_To_Site_Use_Id; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BilltoShipto
6069: --(NULL,Idx.Id,'OKX_BILLTO')); -- okc_k_lines_b.bill_to_site_use_id
6070: Lx_Contract_Lines(Li_TableIdx).Ship_To_Site_Use_Id := Idx.Ship_To_Site_Use_Id; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BilltoShipto
6071: --(NULL,Idx.Id,'OKX_SHIPTO')); --okc_k_lines_b.ship_to_site_use_id
6072: Lx_Contract_Lines(Li_TableIdx).Modifier := Idx.discount_list; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_Discount(NULL,Idx.Id)); --oks_k_lines_b.discount_list
6073: Lx_Contract_Lines(Li_TableIdx).Price_List_Id := Idx.price_list_id; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_PriceList(NULL,Idx.Id,'P')); --okc_k_lines_b.price_list_id
6074: Lx_Contract_Lines(Li_TableIdx).Price_Negotiated := Idx.Price_Negotiated;

Line 6072: Lx_Contract_Lines(Li_TableIdx).Modifier := Idx.discount_list; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_Discount(NULL,Idx.Id)); --oks_k_lines_b.discount_list

6068: Lx_Contract_Lines(Li_TableIdx).Bill_To_Site_Use_Id := Idx.Bill_To_Site_Use_Id; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BilltoShipto
6069: --(NULL,Idx.Id,'OKX_BILLTO')); -- okc_k_lines_b.bill_to_site_use_id
6070: Lx_Contract_Lines(Li_TableIdx).Ship_To_Site_Use_Id := Idx.Ship_To_Site_Use_Id; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BilltoShipto
6071: --(NULL,Idx.Id,'OKX_SHIPTO')); --okc_k_lines_b.ship_to_site_use_id
6072: Lx_Contract_Lines(Li_TableIdx).Modifier := Idx.discount_list; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_Discount(NULL,Idx.Id)); --oks_k_lines_b.discount_list
6073: Lx_Contract_Lines(Li_TableIdx).Price_List_Id := Idx.price_list_id; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_PriceList(NULL,Idx.Id,'P')); --okc_k_lines_b.price_list_id
6074: Lx_Contract_Lines(Li_TableIdx).Price_Negotiated := Idx.Price_Negotiated;
6075: Lx_Contract_Lines(Li_TableIdx).Billing_Profile_Id := null; -- does not exist in 11.5.10 --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BillingProfile(NULL,Idx.Id)); --null
6076: Lx_Contract_Lines(Li_TableIdx).Billing_Frequency := null; -- does not exist in 11.5.10 --SUBSTR(OKS_ENT_UTIL_PVT.Get_BillingSchedule(NULL,Idx.Id,'F'),1,25); --null

Line 6073: Lx_Contract_Lines(Li_TableIdx).Price_List_Id := Idx.price_list_id; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_PriceList(NULL,Idx.Id,'P')); --okc_k_lines_b.price_list_id

6069: --(NULL,Idx.Id,'OKX_BILLTO')); -- okc_k_lines_b.bill_to_site_use_id
6070: Lx_Contract_Lines(Li_TableIdx).Ship_To_Site_Use_Id := Idx.Ship_To_Site_Use_Id; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BilltoShipto
6071: --(NULL,Idx.Id,'OKX_SHIPTO')); --okc_k_lines_b.ship_to_site_use_id
6072: Lx_Contract_Lines(Li_TableIdx).Modifier := Idx.discount_list; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_Discount(NULL,Idx.Id)); --oks_k_lines_b.discount_list
6073: Lx_Contract_Lines(Li_TableIdx).Price_List_Id := Idx.price_list_id; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_PriceList(NULL,Idx.Id,'P')); --okc_k_lines_b.price_list_id
6074: Lx_Contract_Lines(Li_TableIdx).Price_Negotiated := Idx.Price_Negotiated;
6075: Lx_Contract_Lines(Li_TableIdx).Billing_Profile_Id := null; -- does not exist in 11.5.10 --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BillingProfile(NULL,Idx.Id)); --null
6076: Lx_Contract_Lines(Li_TableIdx).Billing_Frequency := null; -- does not exist in 11.5.10 --SUBSTR(OKS_ENT_UTIL_PVT.Get_BillingSchedule(NULL,Idx.Id,'F'),1,25); --null
6077: Lx_Contract_Lines(Li_TableIdx).Billing_Method := null; -- does not exist in 11.5.10 --SUBSTR(OKS_ENT_UTIL_PVT.Get_BillingSchedule(NULL,Idx.Id,'M'),1,3); --null

Line 6075: Lx_Contract_Lines(Li_TableIdx).Billing_Profile_Id := null; -- does not exist in 11.5.10 --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BillingProfile(NULL,Idx.Id)); --null

6071: --(NULL,Idx.Id,'OKX_SHIPTO')); --okc_k_lines_b.ship_to_site_use_id
6072: Lx_Contract_Lines(Li_TableIdx).Modifier := Idx.discount_list; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_Discount(NULL,Idx.Id)); --oks_k_lines_b.discount_list
6073: Lx_Contract_Lines(Li_TableIdx).Price_List_Id := Idx.price_list_id; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_PriceList(NULL,Idx.Id,'P')); --okc_k_lines_b.price_list_id
6074: Lx_Contract_Lines(Li_TableIdx).Price_Negotiated := Idx.Price_Negotiated;
6075: Lx_Contract_Lines(Li_TableIdx).Billing_Profile_Id := null; -- does not exist in 11.5.10 --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BillingProfile(NULL,Idx.Id)); --null
6076: Lx_Contract_Lines(Li_TableIdx).Billing_Frequency := null; -- does not exist in 11.5.10 --SUBSTR(OKS_ENT_UTIL_PVT.Get_BillingSchedule(NULL,Idx.Id,'F'),1,25); --null
6077: Lx_Contract_Lines(Li_TableIdx).Billing_Method := null; -- does not exist in 11.5.10 --SUBSTR(OKS_ENT_UTIL_PVT.Get_BillingSchedule(NULL,Idx.Id,'M'),1,3); --null
6078: Lx_Contract_Lines(Li_TableIdx).Regular_Offset_Days := null; -- does not exist in 11.5.10 --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BillingSchedule(NULL,Idx.Id,'R')); --null
6079: Lx_Contract_Lines(Li_TableIdx).First_Bill_To := null; -- does not exist in 11.5.10 --TO_DATE(OKS_ENT_UTIL_PVT.Get_BillingSchedule

Line 6076: Lx_Contract_Lines(Li_TableIdx).Billing_Frequency := null; -- does not exist in 11.5.10 --SUBSTR(OKS_ENT_UTIL_PVT.Get_BillingSchedule(NULL,Idx.Id,'F'),1,25); --null

6072: Lx_Contract_Lines(Li_TableIdx).Modifier := Idx.discount_list; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_Discount(NULL,Idx.Id)); --oks_k_lines_b.discount_list
6073: Lx_Contract_Lines(Li_TableIdx).Price_List_Id := Idx.price_list_id; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_PriceList(NULL,Idx.Id,'P')); --okc_k_lines_b.price_list_id
6074: Lx_Contract_Lines(Li_TableIdx).Price_Negotiated := Idx.Price_Negotiated;
6075: Lx_Contract_Lines(Li_TableIdx).Billing_Profile_Id := null; -- does not exist in 11.5.10 --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BillingProfile(NULL,Idx.Id)); --null
6076: Lx_Contract_Lines(Li_TableIdx).Billing_Frequency := null; -- does not exist in 11.5.10 --SUBSTR(OKS_ENT_UTIL_PVT.Get_BillingSchedule(NULL,Idx.Id,'F'),1,25); --null
6077: Lx_Contract_Lines(Li_TableIdx).Billing_Method := null; -- does not exist in 11.5.10 --SUBSTR(OKS_ENT_UTIL_PVT.Get_BillingSchedule(NULL,Idx.Id,'M'),1,3); --null
6078: Lx_Contract_Lines(Li_TableIdx).Regular_Offset_Days := null; -- does not exist in 11.5.10 --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BillingSchedule(NULL,Idx.Id,'R')); --null
6079: Lx_Contract_Lines(Li_TableIdx).First_Bill_To := null; -- does not exist in 11.5.10 --TO_DATE(OKS_ENT_UTIL_PVT.Get_BillingSchedule
6080: --(NULL,Idx.Id,'T'),'YYYY/MM/DD HH24:MI:SS'); --null

Line 6077: Lx_Contract_Lines(Li_TableIdx).Billing_Method := null; -- does not exist in 11.5.10 --SUBSTR(OKS_ENT_UTIL_PVT.Get_BillingSchedule(NULL,Idx.Id,'M'),1,3); --null

6073: Lx_Contract_Lines(Li_TableIdx).Price_List_Id := Idx.price_list_id; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_PriceList(NULL,Idx.Id,'P')); --okc_k_lines_b.price_list_id
6074: Lx_Contract_Lines(Li_TableIdx).Price_Negotiated := Idx.Price_Negotiated;
6075: Lx_Contract_Lines(Li_TableIdx).Billing_Profile_Id := null; -- does not exist in 11.5.10 --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BillingProfile(NULL,Idx.Id)); --null
6076: Lx_Contract_Lines(Li_TableIdx).Billing_Frequency := null; -- does not exist in 11.5.10 --SUBSTR(OKS_ENT_UTIL_PVT.Get_BillingSchedule(NULL,Idx.Id,'F'),1,25); --null
6077: Lx_Contract_Lines(Li_TableIdx).Billing_Method := null; -- does not exist in 11.5.10 --SUBSTR(OKS_ENT_UTIL_PVT.Get_BillingSchedule(NULL,Idx.Id,'M'),1,3); --null
6078: Lx_Contract_Lines(Li_TableIdx).Regular_Offset_Days := null; -- does not exist in 11.5.10 --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BillingSchedule(NULL,Idx.Id,'R')); --null
6079: Lx_Contract_Lines(Li_TableIdx).First_Bill_To := null; -- does not exist in 11.5.10 --TO_DATE(OKS_ENT_UTIL_PVT.Get_BillingSchedule
6080: --(NULL,Idx.Id,'T'),'YYYY/MM/DD HH24:MI:SS'); --null
6081: Lx_Contract_Lines(Li_TableIdx).First_Bill_On := null; -- does not exist in 11.5.10 --TO_DATE(OKS_ENT_UTIL_PVT.Get_BillingSchedule

Line 6078: Lx_Contract_Lines(Li_TableIdx).Regular_Offset_Days := null; -- does not exist in 11.5.10 --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BillingSchedule(NULL,Idx.Id,'R')); --null

6074: Lx_Contract_Lines(Li_TableIdx).Price_Negotiated := Idx.Price_Negotiated;
6075: Lx_Contract_Lines(Li_TableIdx).Billing_Profile_Id := null; -- does not exist in 11.5.10 --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BillingProfile(NULL,Idx.Id)); --null
6076: Lx_Contract_Lines(Li_TableIdx).Billing_Frequency := null; -- does not exist in 11.5.10 --SUBSTR(OKS_ENT_UTIL_PVT.Get_BillingSchedule(NULL,Idx.Id,'F'),1,25); --null
6077: Lx_Contract_Lines(Li_TableIdx).Billing_Method := null; -- does not exist in 11.5.10 --SUBSTR(OKS_ENT_UTIL_PVT.Get_BillingSchedule(NULL,Idx.Id,'M'),1,3); --null
6078: Lx_Contract_Lines(Li_TableIdx).Regular_Offset_Days := null; -- does not exist in 11.5.10 --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BillingSchedule(NULL,Idx.Id,'R')); --null
6079: Lx_Contract_Lines(Li_TableIdx).First_Bill_To := null; -- does not exist in 11.5.10 --TO_DATE(OKS_ENT_UTIL_PVT.Get_BillingSchedule
6080: --(NULL,Idx.Id,'T'),'YYYY/MM/DD HH24:MI:SS'); --null
6081: Lx_Contract_Lines(Li_TableIdx).First_Bill_On := null; -- does not exist in 11.5.10 --TO_DATE(OKS_ENT_UTIL_PVT.Get_BillingSchedule
6082: --(NULL,Idx.Id,'O'),'YYYY/MM/DD HH24:MI:SS'); --null

Line 6079: Lx_Contract_Lines(Li_TableIdx).First_Bill_To := null; -- does not exist in 11.5.10 --TO_DATE(OKS_ENT_UTIL_PVT.Get_BillingSchedule

6075: Lx_Contract_Lines(Li_TableIdx).Billing_Profile_Id := null; -- does not exist in 11.5.10 --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BillingProfile(NULL,Idx.Id)); --null
6076: Lx_Contract_Lines(Li_TableIdx).Billing_Frequency := null; -- does not exist in 11.5.10 --SUBSTR(OKS_ENT_UTIL_PVT.Get_BillingSchedule(NULL,Idx.Id,'F'),1,25); --null
6077: Lx_Contract_Lines(Li_TableIdx).Billing_Method := null; -- does not exist in 11.5.10 --SUBSTR(OKS_ENT_UTIL_PVT.Get_BillingSchedule(NULL,Idx.Id,'M'),1,3); --null
6078: Lx_Contract_Lines(Li_TableIdx).Regular_Offset_Days := null; -- does not exist in 11.5.10 --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BillingSchedule(NULL,Idx.Id,'R')); --null
6079: Lx_Contract_Lines(Li_TableIdx).First_Bill_To := null; -- does not exist in 11.5.10 --TO_DATE(OKS_ENT_UTIL_PVT.Get_BillingSchedule
6080: --(NULL,Idx.Id,'T'),'YYYY/MM/DD HH24:MI:SS'); --null
6081: Lx_Contract_Lines(Li_TableIdx).First_Bill_On := null; -- does not exist in 11.5.10 --TO_DATE(OKS_ENT_UTIL_PVT.Get_BillingSchedule
6082: --(NULL,Idx.Id,'O'),'YYYY/MM/DD HH24:MI:SS'); --null
6083: Lx_Contract_Lines(Li_TableIdx).Termination_Date := Idx.Date_Terminated;

Line 6081: Lx_Contract_Lines(Li_TableIdx).First_Bill_On := null; -- does not exist in 11.5.10 --TO_DATE(OKS_ENT_UTIL_PVT.Get_BillingSchedule

6077: Lx_Contract_Lines(Li_TableIdx).Billing_Method := null; -- does not exist in 11.5.10 --SUBSTR(OKS_ENT_UTIL_PVT.Get_BillingSchedule(NULL,Idx.Id,'M'),1,3); --null
6078: Lx_Contract_Lines(Li_TableIdx).Regular_Offset_Days := null; -- does not exist in 11.5.10 --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BillingSchedule(NULL,Idx.Id,'R')); --null
6079: Lx_Contract_Lines(Li_TableIdx).First_Bill_To := null; -- does not exist in 11.5.10 --TO_DATE(OKS_ENT_UTIL_PVT.Get_BillingSchedule
6080: --(NULL,Idx.Id,'T'),'YYYY/MM/DD HH24:MI:SS'); --null
6081: Lx_Contract_Lines(Li_TableIdx).First_Bill_On := null; -- does not exist in 11.5.10 --TO_DATE(OKS_ENT_UTIL_PVT.Get_BillingSchedule
6082: --(NULL,Idx.Id,'O'),'YYYY/MM/DD HH24:MI:SS'); --null
6083: Lx_Contract_Lines(Li_TableIdx).Termination_Date := Idx.Date_Terminated;
6084:
6085: END LOOP;

Line 6098: Lx_Contract_Lines(Li_TableIdx).Duration := TO_NUMBER(OKS_ENT_UTIL_PVT.Get_Duration_Period

6094: Lx_Contract_Lines(Li_TableIdx).Contract_Line_Id := Idx.Id;
6095: Lx_Contract_Lines(Li_TableIdx).Contract_Parent_Line_Id := Idx.Cle_Id;
6096: Lx_Contract_Lines(Li_TableIdx).Contract_Id := Idx.Dnz_Chr_Id;
6097: Lx_Contract_Lines(Li_TableIdx).Line_Status_Code := Idx.Sts_Code;
6098: Lx_Contract_Lines(Li_TableIdx).Duration := TO_NUMBER(OKS_ENT_UTIL_PVT.Get_Duration_Period
6099: (Idx.Start_Date,Idx.End_Date,'D'));
6100: Lx_Contract_Lines(Li_TableIdx).Period_Code := OKS_ENT_UTIL_PVT.Get_Duration_Period
6101: (Idx.Start_Date,Idx.End_Date,'P');
6102: Lx_Contract_Lines(Li_TableIdx).Start_Date_Active := Idx.Start_Date;

Line 6100: Lx_Contract_Lines(Li_TableIdx).Period_Code := OKS_ENT_UTIL_PVT.Get_Duration_Period

6096: Lx_Contract_Lines(Li_TableIdx).Contract_Id := Idx.Dnz_Chr_Id;
6097: Lx_Contract_Lines(Li_TableIdx).Line_Status_Code := Idx.Sts_Code;
6098: Lx_Contract_Lines(Li_TableIdx).Duration := TO_NUMBER(OKS_ENT_UTIL_PVT.Get_Duration_Period
6099: (Idx.Start_Date,Idx.End_Date,'D'));
6100: Lx_Contract_Lines(Li_TableIdx).Period_Code := OKS_ENT_UTIL_PVT.Get_Duration_Period
6101: (Idx.Start_Date,Idx.End_Date,'P');
6102: Lx_Contract_Lines(Li_TableIdx).Start_Date_Active := Idx.Start_Date;
6103: Lx_Contract_Lines(Li_TableIdx).End_Date_Active := Idx.End_Date;
6104: Lx_Contract_Lines(Li_TableIdx).Line_Name := Idx.Name;

Line 6105: Lx_Contract_Lines(Li_TableIdx).Bill_To_Site_Use_Id := Idx.Bill_To_Site_Use_Id; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BilltoShipto

6101: (Idx.Start_Date,Idx.End_Date,'P');
6102: Lx_Contract_Lines(Li_TableIdx).Start_Date_Active := Idx.Start_Date;
6103: Lx_Contract_Lines(Li_TableIdx).End_Date_Active := Idx.End_Date;
6104: Lx_Contract_Lines(Li_TableIdx).Line_Name := Idx.Name;
6105: Lx_Contract_Lines(Li_TableIdx).Bill_To_Site_Use_Id := Idx.Bill_To_Site_Use_Id; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BilltoShipto
6106: --(NULL,Idx.Id,'OKX_BILLTO')); -- okc_k_lines_b.bill_to_site_use_id
6107: Lx_Contract_Lines(Li_TableIdx).Ship_To_Site_Use_Id := Idx.Ship_To_Site_Use_Id; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BilltoShipto
6108: --(NULL,Idx.Id,'OKX_SHIPTO')); --okc_k_lines_b.ship_to_site_use_id
6109: Lx_Contract_Lines(Li_TableIdx).Modifier := Idx.discount_list; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_Discount(NULL,Idx.Id)); --oks_k_lines_b.discount_list

Line 6107: Lx_Contract_Lines(Li_TableIdx).Ship_To_Site_Use_Id := Idx.Ship_To_Site_Use_Id; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BilltoShipto

6103: Lx_Contract_Lines(Li_TableIdx).End_Date_Active := Idx.End_Date;
6104: Lx_Contract_Lines(Li_TableIdx).Line_Name := Idx.Name;
6105: Lx_Contract_Lines(Li_TableIdx).Bill_To_Site_Use_Id := Idx.Bill_To_Site_Use_Id; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BilltoShipto
6106: --(NULL,Idx.Id,'OKX_BILLTO')); -- okc_k_lines_b.bill_to_site_use_id
6107: Lx_Contract_Lines(Li_TableIdx).Ship_To_Site_Use_Id := Idx.Ship_To_Site_Use_Id; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BilltoShipto
6108: --(NULL,Idx.Id,'OKX_SHIPTO')); --okc_k_lines_b.ship_to_site_use_id
6109: Lx_Contract_Lines(Li_TableIdx).Modifier := Idx.discount_list; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_Discount(NULL,Idx.Id)); --oks_k_lines_b.discount_list
6110: Lx_Contract_Lines(Li_TableIdx).Price_List_Id := Idx.price_list_id; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_PriceList(NULL,Idx.Id,'P')); --okc_k_lines_b.price_list_id
6111: Lx_Contract_Lines(Li_TableIdx).Price_Negotiated := Idx.Price_Negotiated;

Line 6109: Lx_Contract_Lines(Li_TableIdx).Modifier := Idx.discount_list; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_Discount(NULL,Idx.Id)); --oks_k_lines_b.discount_list

6105: Lx_Contract_Lines(Li_TableIdx).Bill_To_Site_Use_Id := Idx.Bill_To_Site_Use_Id; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BilltoShipto
6106: --(NULL,Idx.Id,'OKX_BILLTO')); -- okc_k_lines_b.bill_to_site_use_id
6107: Lx_Contract_Lines(Li_TableIdx).Ship_To_Site_Use_Id := Idx.Ship_To_Site_Use_Id; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BilltoShipto
6108: --(NULL,Idx.Id,'OKX_SHIPTO')); --okc_k_lines_b.ship_to_site_use_id
6109: Lx_Contract_Lines(Li_TableIdx).Modifier := Idx.discount_list; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_Discount(NULL,Idx.Id)); --oks_k_lines_b.discount_list
6110: Lx_Contract_Lines(Li_TableIdx).Price_List_Id := Idx.price_list_id; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_PriceList(NULL,Idx.Id,'P')); --okc_k_lines_b.price_list_id
6111: Lx_Contract_Lines(Li_TableIdx).Price_Negotiated := Idx.Price_Negotiated;
6112: Lx_Contract_Lines(Li_TableIdx).Billing_Profile_Id := null; -- does not exist in 11.5.10 --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BillingProfile(NULL,Idx.Id)); --null
6113: Lx_Contract_Lines(Li_TableIdx).Billing_Frequency := null; -- does not exist in 11.5.10 --SUBSTR(OKS_ENT_UTIL_PVT.Get_BillingSchedule(NULL,Idx.Id,'F'),1,25); --null

Line 6110: Lx_Contract_Lines(Li_TableIdx).Price_List_Id := Idx.price_list_id; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_PriceList(NULL,Idx.Id,'P')); --okc_k_lines_b.price_list_id

6106: --(NULL,Idx.Id,'OKX_BILLTO')); -- okc_k_lines_b.bill_to_site_use_id
6107: Lx_Contract_Lines(Li_TableIdx).Ship_To_Site_Use_Id := Idx.Ship_To_Site_Use_Id; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BilltoShipto
6108: --(NULL,Idx.Id,'OKX_SHIPTO')); --okc_k_lines_b.ship_to_site_use_id
6109: Lx_Contract_Lines(Li_TableIdx).Modifier := Idx.discount_list; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_Discount(NULL,Idx.Id)); --oks_k_lines_b.discount_list
6110: Lx_Contract_Lines(Li_TableIdx).Price_List_Id := Idx.price_list_id; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_PriceList(NULL,Idx.Id,'P')); --okc_k_lines_b.price_list_id
6111: Lx_Contract_Lines(Li_TableIdx).Price_Negotiated := Idx.Price_Negotiated;
6112: Lx_Contract_Lines(Li_TableIdx).Billing_Profile_Id := null; -- does not exist in 11.5.10 --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BillingProfile(NULL,Idx.Id)); --null
6113: Lx_Contract_Lines(Li_TableIdx).Billing_Frequency := null; -- does not exist in 11.5.10 --SUBSTR(OKS_ENT_UTIL_PVT.Get_BillingSchedule(NULL,Idx.Id,'F'),1,25); --null
6114: Lx_Contract_Lines(Li_TableIdx).Billing_Method := null; -- does not exist in 11.5.10 --SUBSTR(OKS_ENT_UTIL_PVT.Get_BillingSchedule(NULL,Idx.Id,'M'),1,3); --null

Line 6112: Lx_Contract_Lines(Li_TableIdx).Billing_Profile_Id := null; -- does not exist in 11.5.10 --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BillingProfile(NULL,Idx.Id)); --null

6108: --(NULL,Idx.Id,'OKX_SHIPTO')); --okc_k_lines_b.ship_to_site_use_id
6109: Lx_Contract_Lines(Li_TableIdx).Modifier := Idx.discount_list; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_Discount(NULL,Idx.Id)); --oks_k_lines_b.discount_list
6110: Lx_Contract_Lines(Li_TableIdx).Price_List_Id := Idx.price_list_id; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_PriceList(NULL,Idx.Id,'P')); --okc_k_lines_b.price_list_id
6111: Lx_Contract_Lines(Li_TableIdx).Price_Negotiated := Idx.Price_Negotiated;
6112: Lx_Contract_Lines(Li_TableIdx).Billing_Profile_Id := null; -- does not exist in 11.5.10 --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BillingProfile(NULL,Idx.Id)); --null
6113: Lx_Contract_Lines(Li_TableIdx).Billing_Frequency := null; -- does not exist in 11.5.10 --SUBSTR(OKS_ENT_UTIL_PVT.Get_BillingSchedule(NULL,Idx.Id,'F'),1,25); --null
6114: Lx_Contract_Lines(Li_TableIdx).Billing_Method := null; -- does not exist in 11.5.10 --SUBSTR(OKS_ENT_UTIL_PVT.Get_BillingSchedule(NULL,Idx.Id,'M'),1,3); --null
6115: Lx_Contract_Lines(Li_TableIdx).Regular_Offset_Days := null; -- does not exist in 11.5.10 --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BillingSchedule(NULL,Idx.Id,'R')); --null
6116: Lx_Contract_Lines(Li_TableIdx).First_Bill_To := null; -- does not exist in 11.5.10 --TO_DATE(OKS_ENT_UTIL_PVT.Get_BillingSchedule

Line 6113: Lx_Contract_Lines(Li_TableIdx).Billing_Frequency := null; -- does not exist in 11.5.10 --SUBSTR(OKS_ENT_UTIL_PVT.Get_BillingSchedule(NULL,Idx.Id,'F'),1,25); --null

6109: Lx_Contract_Lines(Li_TableIdx).Modifier := Idx.discount_list; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_Discount(NULL,Idx.Id)); --oks_k_lines_b.discount_list
6110: Lx_Contract_Lines(Li_TableIdx).Price_List_Id := Idx.price_list_id; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_PriceList(NULL,Idx.Id,'P')); --okc_k_lines_b.price_list_id
6111: Lx_Contract_Lines(Li_TableIdx).Price_Negotiated := Idx.Price_Negotiated;
6112: Lx_Contract_Lines(Li_TableIdx).Billing_Profile_Id := null; -- does not exist in 11.5.10 --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BillingProfile(NULL,Idx.Id)); --null
6113: Lx_Contract_Lines(Li_TableIdx).Billing_Frequency := null; -- does not exist in 11.5.10 --SUBSTR(OKS_ENT_UTIL_PVT.Get_BillingSchedule(NULL,Idx.Id,'F'),1,25); --null
6114: Lx_Contract_Lines(Li_TableIdx).Billing_Method := null; -- does not exist in 11.5.10 --SUBSTR(OKS_ENT_UTIL_PVT.Get_BillingSchedule(NULL,Idx.Id,'M'),1,3); --null
6115: Lx_Contract_Lines(Li_TableIdx).Regular_Offset_Days := null; -- does not exist in 11.5.10 --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BillingSchedule(NULL,Idx.Id,'R')); --null
6116: Lx_Contract_Lines(Li_TableIdx).First_Bill_To := null; -- does not exist in 11.5.10 --TO_DATE(OKS_ENT_UTIL_PVT.Get_BillingSchedule
6117: --(NULL,Idx.Id,'T'),'YYYY/MM/DD HH24:MI:SS'); --null

Line 6114: Lx_Contract_Lines(Li_TableIdx).Billing_Method := null; -- does not exist in 11.5.10 --SUBSTR(OKS_ENT_UTIL_PVT.Get_BillingSchedule(NULL,Idx.Id,'M'),1,3); --null

6110: Lx_Contract_Lines(Li_TableIdx).Price_List_Id := Idx.price_list_id; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_PriceList(NULL,Idx.Id,'P')); --okc_k_lines_b.price_list_id
6111: Lx_Contract_Lines(Li_TableIdx).Price_Negotiated := Idx.Price_Negotiated;
6112: Lx_Contract_Lines(Li_TableIdx).Billing_Profile_Id := null; -- does not exist in 11.5.10 --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BillingProfile(NULL,Idx.Id)); --null
6113: Lx_Contract_Lines(Li_TableIdx).Billing_Frequency := null; -- does not exist in 11.5.10 --SUBSTR(OKS_ENT_UTIL_PVT.Get_BillingSchedule(NULL,Idx.Id,'F'),1,25); --null
6114: Lx_Contract_Lines(Li_TableIdx).Billing_Method := null; -- does not exist in 11.5.10 --SUBSTR(OKS_ENT_UTIL_PVT.Get_BillingSchedule(NULL,Idx.Id,'M'),1,3); --null
6115: Lx_Contract_Lines(Li_TableIdx).Regular_Offset_Days := null; -- does not exist in 11.5.10 --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BillingSchedule(NULL,Idx.Id,'R')); --null
6116: Lx_Contract_Lines(Li_TableIdx).First_Bill_To := null; -- does not exist in 11.5.10 --TO_DATE(OKS_ENT_UTIL_PVT.Get_BillingSchedule
6117: --(NULL,Idx.Id,'T'),'YYYY/MM/DD HH24:MI:SS'); --null
6118: Lx_Contract_Lines(Li_TableIdx).First_Bill_On := null; -- does not exist in 11.5.10 --TO_DATE(OKS_ENT_UTIL_PVT.Get_BillingSchedule

Line 6115: Lx_Contract_Lines(Li_TableIdx).Regular_Offset_Days := null; -- does not exist in 11.5.10 --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BillingSchedule(NULL,Idx.Id,'R')); --null

6111: Lx_Contract_Lines(Li_TableIdx).Price_Negotiated := Idx.Price_Negotiated;
6112: Lx_Contract_Lines(Li_TableIdx).Billing_Profile_Id := null; -- does not exist in 11.5.10 --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BillingProfile(NULL,Idx.Id)); --null
6113: Lx_Contract_Lines(Li_TableIdx).Billing_Frequency := null; -- does not exist in 11.5.10 --SUBSTR(OKS_ENT_UTIL_PVT.Get_BillingSchedule(NULL,Idx.Id,'F'),1,25); --null
6114: Lx_Contract_Lines(Li_TableIdx).Billing_Method := null; -- does not exist in 11.5.10 --SUBSTR(OKS_ENT_UTIL_PVT.Get_BillingSchedule(NULL,Idx.Id,'M'),1,3); --null
6115: Lx_Contract_Lines(Li_TableIdx).Regular_Offset_Days := null; -- does not exist in 11.5.10 --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BillingSchedule(NULL,Idx.Id,'R')); --null
6116: Lx_Contract_Lines(Li_TableIdx).First_Bill_To := null; -- does not exist in 11.5.10 --TO_DATE(OKS_ENT_UTIL_PVT.Get_BillingSchedule
6117: --(NULL,Idx.Id,'T'),'YYYY/MM/DD HH24:MI:SS'); --null
6118: Lx_Contract_Lines(Li_TableIdx).First_Bill_On := null; -- does not exist in 11.5.10 --TO_DATE(OKS_ENT_UTIL_PVT.Get_BillingSchedule
6119: --(NULL,Idx.Id,'O'),'YYYY/MM/DD HH24:MI:SS'); --null

Line 6116: Lx_Contract_Lines(Li_TableIdx).First_Bill_To := null; -- does not exist in 11.5.10 --TO_DATE(OKS_ENT_UTIL_PVT.Get_BillingSchedule

6112: Lx_Contract_Lines(Li_TableIdx).Billing_Profile_Id := null; -- does not exist in 11.5.10 --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BillingProfile(NULL,Idx.Id)); --null
6113: Lx_Contract_Lines(Li_TableIdx).Billing_Frequency := null; -- does not exist in 11.5.10 --SUBSTR(OKS_ENT_UTIL_PVT.Get_BillingSchedule(NULL,Idx.Id,'F'),1,25); --null
6114: Lx_Contract_Lines(Li_TableIdx).Billing_Method := null; -- does not exist in 11.5.10 --SUBSTR(OKS_ENT_UTIL_PVT.Get_BillingSchedule(NULL,Idx.Id,'M'),1,3); --null
6115: Lx_Contract_Lines(Li_TableIdx).Regular_Offset_Days := null; -- does not exist in 11.5.10 --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BillingSchedule(NULL,Idx.Id,'R')); --null
6116: Lx_Contract_Lines(Li_TableIdx).First_Bill_To := null; -- does not exist in 11.5.10 --TO_DATE(OKS_ENT_UTIL_PVT.Get_BillingSchedule
6117: --(NULL,Idx.Id,'T'),'YYYY/MM/DD HH24:MI:SS'); --null
6118: Lx_Contract_Lines(Li_TableIdx).First_Bill_On := null; -- does not exist in 11.5.10 --TO_DATE(OKS_ENT_UTIL_PVT.Get_BillingSchedule
6119: --(NULL,Idx.Id,'O'),'YYYY/MM/DD HH24:MI:SS'); --null
6120: Lx_Contract_Lines(Li_TableIdx).Termination_Date := Idx.Date_Terminated;

Line 6118: Lx_Contract_Lines(Li_TableIdx).First_Bill_On := null; -- does not exist in 11.5.10 --TO_DATE(OKS_ENT_UTIL_PVT.Get_BillingSchedule

6114: Lx_Contract_Lines(Li_TableIdx).Billing_Method := null; -- does not exist in 11.5.10 --SUBSTR(OKS_ENT_UTIL_PVT.Get_BillingSchedule(NULL,Idx.Id,'M'),1,3); --null
6115: Lx_Contract_Lines(Li_TableIdx).Regular_Offset_Days := null; -- does not exist in 11.5.10 --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BillingSchedule(NULL,Idx.Id,'R')); --null
6116: Lx_Contract_Lines(Li_TableIdx).First_Bill_To := null; -- does not exist in 11.5.10 --TO_DATE(OKS_ENT_UTIL_PVT.Get_BillingSchedule
6117: --(NULL,Idx.Id,'T'),'YYYY/MM/DD HH24:MI:SS'); --null
6118: Lx_Contract_Lines(Li_TableIdx).First_Bill_On := null; -- does not exist in 11.5.10 --TO_DATE(OKS_ENT_UTIL_PVT.Get_BillingSchedule
6119: --(NULL,Idx.Id,'O'),'YYYY/MM/DD HH24:MI:SS'); --null
6120: Lx_Contract_Lines(Li_TableIdx).Termination_Date := Idx.Date_Terminated;
6121:
6122: END LOOP;

Line 6284: Lx_Prod_Rec OKS_ENT_UTIL_PVT.L_Pdt_Rec;

6280:
6281: Lx_Cle_Id CONSTANT Gx_OKS_Id := P_Cle_Id;
6282: Lx_Covered_Levels Clvl_Tbl_Type;
6283:
6284: Lx_Prod_Rec OKS_ENT_UTIL_PVT.L_Pdt_Rec;
6285: Lx_Item_Rec OKS_ENT_UTIL_PVT.L_Inv_Rec;
6286: Lx_Sys_Rec OKS_ENT_UTIL_PVT.L_Sys_Rec;
6287: Lx_Party_Rec OKS_ENT_UTIL_PVT.L_Party_Rec;
6288: Lx_CustAc_Rec OKS_ENT_UTIL_PVT.L_Cust_Rec;

Line 6285: Lx_Item_Rec OKS_ENT_UTIL_PVT.L_Inv_Rec;

6281: Lx_Cle_Id CONSTANT Gx_OKS_Id := P_Cle_Id;
6282: Lx_Covered_Levels Clvl_Tbl_Type;
6283:
6284: Lx_Prod_Rec OKS_ENT_UTIL_PVT.L_Pdt_Rec;
6285: Lx_Item_Rec OKS_ENT_UTIL_PVT.L_Inv_Rec;
6286: Lx_Sys_Rec OKS_ENT_UTIL_PVT.L_Sys_Rec;
6287: Lx_Party_Rec OKS_ENT_UTIL_PVT.L_Party_Rec;
6288: Lx_CustAc_Rec OKS_ENT_UTIL_PVT.L_Cust_Rec;
6289: Lx_Site_Rec OKS_ENT_UTIL_PVT.L_Site_Rec;

Line 6286: Lx_Sys_Rec OKS_ENT_UTIL_PVT.L_Sys_Rec;

6282: Lx_Covered_Levels Clvl_Tbl_Type;
6283:
6284: Lx_Prod_Rec OKS_ENT_UTIL_PVT.L_Pdt_Rec;
6285: Lx_Item_Rec OKS_ENT_UTIL_PVT.L_Inv_Rec;
6286: Lx_Sys_Rec OKS_ENT_UTIL_PVT.L_Sys_Rec;
6287: Lx_Party_Rec OKS_ENT_UTIL_PVT.L_Party_Rec;
6288: Lx_CustAc_Rec OKS_ENT_UTIL_PVT.L_Cust_Rec;
6289: Lx_Site_Rec OKS_ENT_UTIL_PVT.L_Site_Rec;
6290: Lx_QtyRate_Rec OKS_ENT_UTIL_PVT.L_QtyRate_Rec;

Line 6287: Lx_Party_Rec OKS_ENT_UTIL_PVT.L_Party_Rec;

6283:
6284: Lx_Prod_Rec OKS_ENT_UTIL_PVT.L_Pdt_Rec;
6285: Lx_Item_Rec OKS_ENT_UTIL_PVT.L_Inv_Rec;
6286: Lx_Sys_Rec OKS_ENT_UTIL_PVT.L_Sys_Rec;
6287: Lx_Party_Rec OKS_ENT_UTIL_PVT.L_Party_Rec;
6288: Lx_CustAc_Rec OKS_ENT_UTIL_PVT.L_Cust_Rec;
6289: Lx_Site_Rec OKS_ENT_UTIL_PVT.L_Site_Rec;
6290: Lx_QtyRate_Rec OKS_ENT_UTIL_PVT.L_QtyRate_Rec;
6291:

Line 6288: Lx_CustAc_Rec OKS_ENT_UTIL_PVT.L_Cust_Rec;

6284: Lx_Prod_Rec OKS_ENT_UTIL_PVT.L_Pdt_Rec;
6285: Lx_Item_Rec OKS_ENT_UTIL_PVT.L_Inv_Rec;
6286: Lx_Sys_Rec OKS_ENT_UTIL_PVT.L_Sys_Rec;
6287: Lx_Party_Rec OKS_ENT_UTIL_PVT.L_Party_Rec;
6288: Lx_CustAc_Rec OKS_ENT_UTIL_PVT.L_Cust_Rec;
6289: Lx_Site_Rec OKS_ENT_UTIL_PVT.L_Site_Rec;
6290: Lx_QtyRate_Rec OKS_ENT_UTIL_PVT.L_QtyRate_Rec;
6291:
6292: Lx_Result Gx_Boolean;

Line 6289: Lx_Site_Rec OKS_ENT_UTIL_PVT.L_Site_Rec;

6285: Lx_Item_Rec OKS_ENT_UTIL_PVT.L_Inv_Rec;
6286: Lx_Sys_Rec OKS_ENT_UTIL_PVT.L_Sys_Rec;
6287: Lx_Party_Rec OKS_ENT_UTIL_PVT.L_Party_Rec;
6288: Lx_CustAc_Rec OKS_ENT_UTIL_PVT.L_Cust_Rec;
6289: Lx_Site_Rec OKS_ENT_UTIL_PVT.L_Site_Rec;
6290: Lx_QtyRate_Rec OKS_ENT_UTIL_PVT.L_QtyRate_Rec;
6291:
6292: Lx_Result Gx_Boolean;
6293: Lx_Return_Status Gx_Ret_Sts;

Line 6290: Lx_QtyRate_Rec OKS_ENT_UTIL_PVT.L_QtyRate_Rec;

6286: Lx_Sys_Rec OKS_ENT_UTIL_PVT.L_Sys_Rec;
6287: Lx_Party_Rec OKS_ENT_UTIL_PVT.L_Party_Rec;
6288: Lx_CustAc_Rec OKS_ENT_UTIL_PVT.L_Cust_Rec;
6289: Lx_Site_Rec OKS_ENT_UTIL_PVT.L_Site_Rec;
6290: Lx_QtyRate_Rec OKS_ENT_UTIL_PVT.L_QtyRate_Rec;
6291:
6292: Lx_Result Gx_Boolean;
6293: Lx_Return_Status Gx_Ret_Sts;
6294:

Line 6319: Lx_Prod_Rec := OKS_ENT_UTIL_PVT.Get_Product(Idx.Id);

6315:
6316: Li_TableIdx := Li_TableIdx + 1;
6317:
6318: Lv_Prod_Name := NULL;
6319: Lx_Prod_Rec := OKS_ENT_UTIL_PVT.Get_Product(Idx.Id);
6320:
6321: IF Lx_Prod_Rec.Product_Id IS NOT NULL THEN
6322: OPEN Lx_Csr_CovProd (Lx_Prod_Rec.Product_Id,Idx.Org_Id,Idx.Organization_Id);
6323: FETCH Lx_Csr_CovProd INTO Lv_Prod_Name;

Line 6327: Lx_Item_Rec := OKS_ENT_UTIL_PVT.Get_InvItem(Idx.Id,Idx.Organization_Id);

6323: FETCH Lx_Csr_CovProd INTO Lv_Prod_Name;
6324: CLOSE Lx_Csr_CovProd;
6325: END IF;
6326:
6327: Lx_Item_Rec := OKS_ENT_UTIL_PVT.Get_InvItem(Idx.Id,Idx.Organization_Id);
6328: Lx_Sys_Rec := OKS_ENT_UTIL_PVT.Get_System(Idx.Id,Idx.Org_Id);
6329:
6330: Lx_Party_Rec := OKS_ENT_UTIL_PVT.Get_CLvl_Party(Idx.Id);
6331: Lx_CustAc_Rec := OKS_ENT_UTIL_PVT.Get_CLvl_Customer(Idx.Id);

Line 6328: Lx_Sys_Rec := OKS_ENT_UTIL_PVT.Get_System(Idx.Id,Idx.Org_Id);

6324: CLOSE Lx_Csr_CovProd;
6325: END IF;
6326:
6327: Lx_Item_Rec := OKS_ENT_UTIL_PVT.Get_InvItem(Idx.Id,Idx.Organization_Id);
6328: Lx_Sys_Rec := OKS_ENT_UTIL_PVT.Get_System(Idx.Id,Idx.Org_Id);
6329:
6330: Lx_Party_Rec := OKS_ENT_UTIL_PVT.Get_CLvl_Party(Idx.Id);
6331: Lx_CustAc_Rec := OKS_ENT_UTIL_PVT.Get_CLvl_Customer(Idx.Id);
6332: Lx_Site_Rec := OKS_ENT_UTIL_PVT.Get_CLvl_Site(Idx.Id, Idx.Org_Id);

Line 6330: Lx_Party_Rec := OKS_ENT_UTIL_PVT.Get_CLvl_Party(Idx.Id);

6326:
6327: Lx_Item_Rec := OKS_ENT_UTIL_PVT.Get_InvItem(Idx.Id,Idx.Organization_Id);
6328: Lx_Sys_Rec := OKS_ENT_UTIL_PVT.Get_System(Idx.Id,Idx.Org_Id);
6329:
6330: Lx_Party_Rec := OKS_ENT_UTIL_PVT.Get_CLvl_Party(Idx.Id);
6331: Lx_CustAc_Rec := OKS_ENT_UTIL_PVT.Get_CLvl_Customer(Idx.Id);
6332: Lx_Site_Rec := OKS_ENT_UTIL_PVT.Get_CLvl_Site(Idx.Id, Idx.Org_Id);
6333:
6334: -- Lx_QtyRate_Rec := OKS_ENT_UTIL_PVT.Get_QtyRate_Rule(Idx.Id); --null oks_k_lines_b , okc_k_lines_b

Line 6331: Lx_CustAc_Rec := OKS_ENT_UTIL_PVT.Get_CLvl_Customer(Idx.Id);

6327: Lx_Item_Rec := OKS_ENT_UTIL_PVT.Get_InvItem(Idx.Id,Idx.Organization_Id);
6328: Lx_Sys_Rec := OKS_ENT_UTIL_PVT.Get_System(Idx.Id,Idx.Org_Id);
6329:
6330: Lx_Party_Rec := OKS_ENT_UTIL_PVT.Get_CLvl_Party(Idx.Id);
6331: Lx_CustAc_Rec := OKS_ENT_UTIL_PVT.Get_CLvl_Customer(Idx.Id);
6332: Lx_Site_Rec := OKS_ENT_UTIL_PVT.Get_CLvl_Site(Idx.Id, Idx.Org_Id);
6333:
6334: -- Lx_QtyRate_Rec := OKS_ENT_UTIL_PVT.Get_QtyRate_Rule(Idx.Id); --null oks_k_lines_b , okc_k_lines_b
6335: -- Ln_ListPrice := TO_NUMBER(OKS_ENT_UTIL_PVT.Get_PriceList(NULL,Idx.Id,'P'));

Line 6332: Lx_Site_Rec := OKS_ENT_UTIL_PVT.Get_CLvl_Site(Idx.Id, Idx.Org_Id);

6328: Lx_Sys_Rec := OKS_ENT_UTIL_PVT.Get_System(Idx.Id,Idx.Org_Id);
6329:
6330: Lx_Party_Rec := OKS_ENT_UTIL_PVT.Get_CLvl_Party(Idx.Id);
6331: Lx_CustAc_Rec := OKS_ENT_UTIL_PVT.Get_CLvl_Customer(Idx.Id);
6332: Lx_Site_Rec := OKS_ENT_UTIL_PVT.Get_CLvl_Site(Idx.Id, Idx.Org_Id);
6333:
6334: -- Lx_QtyRate_Rec := OKS_ENT_UTIL_PVT.Get_QtyRate_Rule(Idx.Id); --null oks_k_lines_b , okc_k_lines_b
6335: -- Ln_ListPrice := TO_NUMBER(OKS_ENT_UTIL_PVT.Get_PriceList(NULL,Idx.Id,'P'));
6336:

Line 6334: -- Lx_QtyRate_Rec := OKS_ENT_UTIL_PVT.Get_QtyRate_Rule(Idx.Id); --null oks_k_lines_b , okc_k_lines_b

6330: Lx_Party_Rec := OKS_ENT_UTIL_PVT.Get_CLvl_Party(Idx.Id);
6331: Lx_CustAc_Rec := OKS_ENT_UTIL_PVT.Get_CLvl_Customer(Idx.Id);
6332: Lx_Site_Rec := OKS_ENT_UTIL_PVT.Get_CLvl_Site(Idx.Id, Idx.Org_Id);
6333:
6334: -- Lx_QtyRate_Rec := OKS_ENT_UTIL_PVT.Get_QtyRate_Rule(Idx.Id); --null oks_k_lines_b , okc_k_lines_b
6335: -- Ln_ListPrice := TO_NUMBER(OKS_ENT_UTIL_PVT.Get_PriceList(NULL,Idx.Id,'P'));
6336:
6337: Lx_Covered_Levels(Li_TableIdx).Row_Id := Idx.RowId;
6338: Lx_Covered_Levels(Li_TableIdx).Line_Id := Idx.Id;

Line 6335: -- Ln_ListPrice := TO_NUMBER(OKS_ENT_UTIL_PVT.Get_PriceList(NULL,Idx.Id,'P'));

6331: Lx_CustAc_Rec := OKS_ENT_UTIL_PVT.Get_CLvl_Customer(Idx.Id);
6332: Lx_Site_Rec := OKS_ENT_UTIL_PVT.Get_CLvl_Site(Idx.Id, Idx.Org_Id);
6333:
6334: -- Lx_QtyRate_Rec := OKS_ENT_UTIL_PVT.Get_QtyRate_Rule(Idx.Id); --null oks_k_lines_b , okc_k_lines_b
6335: -- Ln_ListPrice := TO_NUMBER(OKS_ENT_UTIL_PVT.Get_PriceList(NULL,Idx.Id,'P'));
6336:
6337: Lx_Covered_Levels(Li_TableIdx).Row_Id := Idx.RowId;
6338: Lx_Covered_Levels(Li_TableIdx).Line_Id := Idx.Id;
6339: Lx_Covered_Levels(Li_TableIdx).Header_Id := Idx.Dnz_Chr_Id;

Line 6382: Lx_Prod_Rec := OKS_ENT_UTIL_PVT.Get_Product(Idx.Id);

6378:
6379: Li_TableIdx := Li_TableIdx + 1;
6380:
6381: Lv_Prod_Name := NULL;
6382: Lx_Prod_Rec := OKS_ENT_UTIL_PVT.Get_Product(Idx.Id);
6383:
6384: IF Lx_Prod_Rec.Product_Id IS NOT NULL THEN
6385: OPEN Lx_Csr_CovProd (Lx_Prod_Rec.Product_Id,Idx.Org_Id,Idx.Organization_Id);
6386: FETCH Lx_Csr_CovProd INTO Lv_Prod_Name;

Line 6390: Lx_Item_Rec := OKS_ENT_UTIL_PVT.Get_InvItem(Idx.Id,Idx.Organization_Id);

6386: FETCH Lx_Csr_CovProd INTO Lv_Prod_Name;
6387: CLOSE Lx_Csr_CovProd;
6388: END IF;
6389:
6390: Lx_Item_Rec := OKS_ENT_UTIL_PVT.Get_InvItem(Idx.Id,Idx.Organization_Id);
6391: Lx_Sys_Rec := OKS_ENT_UTIL_PVT.Get_System(Idx.Id,Idx.Org_Id);
6392:
6393: Lx_Party_Rec := OKS_ENT_UTIL_PVT.Get_CLvl_Party(Idx.Id);
6394: Lx_CustAc_Rec := OKS_ENT_UTIL_PVT.Get_CLvl_Customer(Idx.Id);

Line 6391: Lx_Sys_Rec := OKS_ENT_UTIL_PVT.Get_System(Idx.Id,Idx.Org_Id);

6387: CLOSE Lx_Csr_CovProd;
6388: END IF;
6389:
6390: Lx_Item_Rec := OKS_ENT_UTIL_PVT.Get_InvItem(Idx.Id,Idx.Organization_Id);
6391: Lx_Sys_Rec := OKS_ENT_UTIL_PVT.Get_System(Idx.Id,Idx.Org_Id);
6392:
6393: Lx_Party_Rec := OKS_ENT_UTIL_PVT.Get_CLvl_Party(Idx.Id);
6394: Lx_CustAc_Rec := OKS_ENT_UTIL_PVT.Get_CLvl_Customer(Idx.Id);
6395: Lx_Site_Rec := OKS_ENT_UTIL_PVT.Get_CLvl_Site(Idx.Id, Idx.Org_Id);

Line 6393: Lx_Party_Rec := OKS_ENT_UTIL_PVT.Get_CLvl_Party(Idx.Id);

6389:
6390: Lx_Item_Rec := OKS_ENT_UTIL_PVT.Get_InvItem(Idx.Id,Idx.Organization_Id);
6391: Lx_Sys_Rec := OKS_ENT_UTIL_PVT.Get_System(Idx.Id,Idx.Org_Id);
6392:
6393: Lx_Party_Rec := OKS_ENT_UTIL_PVT.Get_CLvl_Party(Idx.Id);
6394: Lx_CustAc_Rec := OKS_ENT_UTIL_PVT.Get_CLvl_Customer(Idx.Id);
6395: Lx_Site_Rec := OKS_ENT_UTIL_PVT.Get_CLvl_Site(Idx.Id, Idx.Org_Id);
6396:
6397: -- Lx_QtyRate_Rec := OKS_ENT_UTIL_PVT.Get_QtyRate_Rule(Idx.Id); --null oks_k_lines_b , okc_k_lines_b

Line 6394: Lx_CustAc_Rec := OKS_ENT_UTIL_PVT.Get_CLvl_Customer(Idx.Id);

6390: Lx_Item_Rec := OKS_ENT_UTIL_PVT.Get_InvItem(Idx.Id,Idx.Organization_Id);
6391: Lx_Sys_Rec := OKS_ENT_UTIL_PVT.Get_System(Idx.Id,Idx.Org_Id);
6392:
6393: Lx_Party_Rec := OKS_ENT_UTIL_PVT.Get_CLvl_Party(Idx.Id);
6394: Lx_CustAc_Rec := OKS_ENT_UTIL_PVT.Get_CLvl_Customer(Idx.Id);
6395: Lx_Site_Rec := OKS_ENT_UTIL_PVT.Get_CLvl_Site(Idx.Id, Idx.Org_Id);
6396:
6397: -- Lx_QtyRate_Rec := OKS_ENT_UTIL_PVT.Get_QtyRate_Rule(Idx.Id); --null oks_k_lines_b , okc_k_lines_b
6398: -- Ln_ListPrice := TO_NUMBER(OKS_ENT_UTIL_PVT.Get_PriceList(NULL,Idx.Id,'P'));

Line 6395: Lx_Site_Rec := OKS_ENT_UTIL_PVT.Get_CLvl_Site(Idx.Id, Idx.Org_Id);

6391: Lx_Sys_Rec := OKS_ENT_UTIL_PVT.Get_System(Idx.Id,Idx.Org_Id);
6392:
6393: Lx_Party_Rec := OKS_ENT_UTIL_PVT.Get_CLvl_Party(Idx.Id);
6394: Lx_CustAc_Rec := OKS_ENT_UTIL_PVT.Get_CLvl_Customer(Idx.Id);
6395: Lx_Site_Rec := OKS_ENT_UTIL_PVT.Get_CLvl_Site(Idx.Id, Idx.Org_Id);
6396:
6397: -- Lx_QtyRate_Rec := OKS_ENT_UTIL_PVT.Get_QtyRate_Rule(Idx.Id); --null oks_k_lines_b , okc_k_lines_b
6398: -- Ln_ListPrice := TO_NUMBER(OKS_ENT_UTIL_PVT.Get_PriceList(NULL,Idx.Id,'P'));
6399:

Line 6397: -- Lx_QtyRate_Rec := OKS_ENT_UTIL_PVT.Get_QtyRate_Rule(Idx.Id); --null oks_k_lines_b , okc_k_lines_b

6393: Lx_Party_Rec := OKS_ENT_UTIL_PVT.Get_CLvl_Party(Idx.Id);
6394: Lx_CustAc_Rec := OKS_ENT_UTIL_PVT.Get_CLvl_Customer(Idx.Id);
6395: Lx_Site_Rec := OKS_ENT_UTIL_PVT.Get_CLvl_Site(Idx.Id, Idx.Org_Id);
6396:
6397: -- Lx_QtyRate_Rec := OKS_ENT_UTIL_PVT.Get_QtyRate_Rule(Idx.Id); --null oks_k_lines_b , okc_k_lines_b
6398: -- Ln_ListPrice := TO_NUMBER(OKS_ENT_UTIL_PVT.Get_PriceList(NULL,Idx.Id,'P'));
6399:
6400: Lx_Covered_Levels(Li_TableIdx).Row_Id := Idx.RowId;
6401: Lx_Covered_Levels(Li_TableIdx).Line_Id := Idx.Id;

Line 6398: -- Ln_ListPrice := TO_NUMBER(OKS_ENT_UTIL_PVT.Get_PriceList(NULL,Idx.Id,'P'));

6394: Lx_CustAc_Rec := OKS_ENT_UTIL_PVT.Get_CLvl_Customer(Idx.Id);
6395: Lx_Site_Rec := OKS_ENT_UTIL_PVT.Get_CLvl_Site(Idx.Id, Idx.Org_Id);
6396:
6397: -- Lx_QtyRate_Rec := OKS_ENT_UTIL_PVT.Get_QtyRate_Rule(Idx.Id); --null oks_k_lines_b , okc_k_lines_b
6398: -- Ln_ListPrice := TO_NUMBER(OKS_ENT_UTIL_PVT.Get_PriceList(NULL,Idx.Id,'P'));
6399:
6400: Lx_Covered_Levels(Li_TableIdx).Row_Id := Idx.RowId;
6401: Lx_Covered_Levels(Li_TableIdx).Line_Id := Idx.Id;
6402: Lx_Covered_Levels(Li_TableIdx).Header_Id := Idx.Dnz_Chr_Id;

Line 6445: Lx_Prod_Rec := OKS_ENT_UTIL_PVT.Get_Product(Idx.Id);

6441:
6442: Li_TableIdx := Li_TableIdx + 1;
6443:
6444: Lv_Prod_Name := NULL;
6445: Lx_Prod_Rec := OKS_ENT_UTIL_PVT.Get_Product(Idx.Id);
6446:
6447: IF Lx_Prod_Rec.Product_Id IS NOT NULL THEN
6448: OPEN Lx_Csr_CovProd (Lx_Prod_Rec.Product_Id,Idx.Org_Id,Idx.Organization_Id);
6449: FETCH Lx_Csr_CovProd INTO Lv_Prod_Name;

Line 6453: Lx_Item_Rec := OKS_ENT_UTIL_PVT.Get_InvItem(Idx.Id,Idx.Organization_Id);

6449: FETCH Lx_Csr_CovProd INTO Lv_Prod_Name;
6450: CLOSE Lx_Csr_CovProd;
6451: END IF;
6452:
6453: Lx_Item_Rec := OKS_ENT_UTIL_PVT.Get_InvItem(Idx.Id,Idx.Organization_Id);
6454: Lx_Sys_Rec := OKS_ENT_UTIL_PVT.Get_System(Idx.Id,Idx.Org_Id);
6455:
6456: Lx_Party_Rec := OKS_ENT_UTIL_PVT.Get_CLvl_Party(Idx.Id);
6457: Lx_CustAc_Rec := OKS_ENT_UTIL_PVT.Get_CLvl_Customer(Idx.Id);

Line 6454: Lx_Sys_Rec := OKS_ENT_UTIL_PVT.Get_System(Idx.Id,Idx.Org_Id);

6450: CLOSE Lx_Csr_CovProd;
6451: END IF;
6452:
6453: Lx_Item_Rec := OKS_ENT_UTIL_PVT.Get_InvItem(Idx.Id,Idx.Organization_Id);
6454: Lx_Sys_Rec := OKS_ENT_UTIL_PVT.Get_System(Idx.Id,Idx.Org_Id);
6455:
6456: Lx_Party_Rec := OKS_ENT_UTIL_PVT.Get_CLvl_Party(Idx.Id);
6457: Lx_CustAc_Rec := OKS_ENT_UTIL_PVT.Get_CLvl_Customer(Idx.Id);
6458: Lx_Site_Rec := OKS_ENT_UTIL_PVT.Get_CLvl_Site(Idx.Id, Idx.Org_Id);

Line 6456: Lx_Party_Rec := OKS_ENT_UTIL_PVT.Get_CLvl_Party(Idx.Id);

6452:
6453: Lx_Item_Rec := OKS_ENT_UTIL_PVT.Get_InvItem(Idx.Id,Idx.Organization_Id);
6454: Lx_Sys_Rec := OKS_ENT_UTIL_PVT.Get_System(Idx.Id,Idx.Org_Id);
6455:
6456: Lx_Party_Rec := OKS_ENT_UTIL_PVT.Get_CLvl_Party(Idx.Id);
6457: Lx_CustAc_Rec := OKS_ENT_UTIL_PVT.Get_CLvl_Customer(Idx.Id);
6458: Lx_Site_Rec := OKS_ENT_UTIL_PVT.Get_CLvl_Site(Idx.Id, Idx.Org_Id);
6459:
6460: -- Lx_QtyRate_Rec := OKS_ENT_UTIL_PVT.Get_QtyRate_Rule(Idx.Id); --null oks_k_lines_b , okc_k_lines_b

Line 6457: Lx_CustAc_Rec := OKS_ENT_UTIL_PVT.Get_CLvl_Customer(Idx.Id);

6453: Lx_Item_Rec := OKS_ENT_UTIL_PVT.Get_InvItem(Idx.Id,Idx.Organization_Id);
6454: Lx_Sys_Rec := OKS_ENT_UTIL_PVT.Get_System(Idx.Id,Idx.Org_Id);
6455:
6456: Lx_Party_Rec := OKS_ENT_UTIL_PVT.Get_CLvl_Party(Idx.Id);
6457: Lx_CustAc_Rec := OKS_ENT_UTIL_PVT.Get_CLvl_Customer(Idx.Id);
6458: Lx_Site_Rec := OKS_ENT_UTIL_PVT.Get_CLvl_Site(Idx.Id, Idx.Org_Id);
6459:
6460: -- Lx_QtyRate_Rec := OKS_ENT_UTIL_PVT.Get_QtyRate_Rule(Idx.Id); --null oks_k_lines_b , okc_k_lines_b
6461: -- Ln_ListPrice := TO_NUMBER(OKS_ENT_UTIL_PVT.Get_PriceList(NULL,Idx.Id,'P'));

Line 6458: Lx_Site_Rec := OKS_ENT_UTIL_PVT.Get_CLvl_Site(Idx.Id, Idx.Org_Id);

6454: Lx_Sys_Rec := OKS_ENT_UTIL_PVT.Get_System(Idx.Id,Idx.Org_Id);
6455:
6456: Lx_Party_Rec := OKS_ENT_UTIL_PVT.Get_CLvl_Party(Idx.Id);
6457: Lx_CustAc_Rec := OKS_ENT_UTIL_PVT.Get_CLvl_Customer(Idx.Id);
6458: Lx_Site_Rec := OKS_ENT_UTIL_PVT.Get_CLvl_Site(Idx.Id, Idx.Org_Id);
6459:
6460: -- Lx_QtyRate_Rec := OKS_ENT_UTIL_PVT.Get_QtyRate_Rule(Idx.Id); --null oks_k_lines_b , okc_k_lines_b
6461: -- Ln_ListPrice := TO_NUMBER(OKS_ENT_UTIL_PVT.Get_PriceList(NULL,Idx.Id,'P'));
6462:

Line 6460: -- Lx_QtyRate_Rec := OKS_ENT_UTIL_PVT.Get_QtyRate_Rule(Idx.Id); --null oks_k_lines_b , okc_k_lines_b

6456: Lx_Party_Rec := OKS_ENT_UTIL_PVT.Get_CLvl_Party(Idx.Id);
6457: Lx_CustAc_Rec := OKS_ENT_UTIL_PVT.Get_CLvl_Customer(Idx.Id);
6458: Lx_Site_Rec := OKS_ENT_UTIL_PVT.Get_CLvl_Site(Idx.Id, Idx.Org_Id);
6459:
6460: -- Lx_QtyRate_Rec := OKS_ENT_UTIL_PVT.Get_QtyRate_Rule(Idx.Id); --null oks_k_lines_b , okc_k_lines_b
6461: -- Ln_ListPrice := TO_NUMBER(OKS_ENT_UTIL_PVT.Get_PriceList(NULL,Idx.Id,'P'));
6462:
6463: Lx_Covered_Levels(Li_TableIdx).Row_Id := Idx.RowId;
6464: Lx_Covered_Levels(Li_TableIdx).Line_Id := Idx.Id;

Line 6461: -- Ln_ListPrice := TO_NUMBER(OKS_ENT_UTIL_PVT.Get_PriceList(NULL,Idx.Id,'P'));

6457: Lx_CustAc_Rec := OKS_ENT_UTIL_PVT.Get_CLvl_Customer(Idx.Id);
6458: Lx_Site_Rec := OKS_ENT_UTIL_PVT.Get_CLvl_Site(Idx.Id, Idx.Org_Id);
6459:
6460: -- Lx_QtyRate_Rec := OKS_ENT_UTIL_PVT.Get_QtyRate_Rule(Idx.Id); --null oks_k_lines_b , okc_k_lines_b
6461: -- Ln_ListPrice := TO_NUMBER(OKS_ENT_UTIL_PVT.Get_PriceList(NULL,Idx.Id,'P'));
6462:
6463: Lx_Covered_Levels(Li_TableIdx).Row_Id := Idx.RowId;
6464: Lx_Covered_Levels(Li_TableIdx).Line_Id := Idx.Id;
6465: Lx_Covered_Levels(Li_TableIdx).Header_Id := Idx.Dnz_Chr_Id;