eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKS_COVERAGES_MIGRATION SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 11


	select
	 nvl(cov.COVERAGE_ID,0) COVERAGE_ID,
	 cov.NAME,
	 cov.DESCRIPTION,
	cov.START_DATE,
	cov.END_DATE,
	cov.FREE_UPGRADE_YN,
	cov.COVERAGE_TYPE_CODE,
	cov.EXCEPTION_COVERAGE_YN,
	cov.EXC_COVERAGE_ID,
	cov.TEMPLATE_FLAG_YN,
	cov.WARRANTY_YN,
	cov.WARRANTY_INHERITANCE_CODE,
	cov.TRANSFER_ALLOWED_YN,
	cov.ATTRIBUTE_CATEGORY,
	cov.ATTRIBUTE1,
	cov.ATTRIBUTE2,
	cov.ATTRIBUTE3,
	cov.ATTRIBUTE4,
	cov.ATTRIBUTE5,
	cov.ATTRIBUTE6,
	cov.ATTRIBUTE7,
	cov.ATTRIBUTE8,
	cov.ATTRIBUTE9,
	cov.ATTRIBUTE10,
	cov.ATTRIBUTE11,
	cov.ATTRIBUTE12,
	cov.ATTRIBUTE13,
	cov.ATTRIBUTE14,
	cov.ATTRIBUTE15
from oks_coverages_int_all cov,
     OKS_CON_LINES_INT_ALL lines,
     OKS_CON_HEADERS_INT_ALL head
where cov.coverage_id <> 0
and  cov.interfaced_status_flag is null
and  head.batch_number between p_FromId and p_ToID
and  head.interfaced_status_flag = 'S'
and  head.contract_id = lines.contract_id
and  lines.interfaced_status_flag = 'S'
and  lines.coverage_id = cov.coverage_id;

Line: 55


SELECT cle1.Id           Id,
		cle1.Lse_Id           Lse_Id,
		cle1.Start_Date       Start_Date,
		cle1.Sts_Code         Sts_Code,
		cle1.End_Date         End_Date,
		cle1.Dnz_Chr_Id       Dnz_Chr_Id,
		cle1.Currency_Code    Currency_Code,
		cle1.display_sequence display_sequence,
		cle1.Line_Number      Line_Number,
		cle1.CREATED_BY       CREATED_BY,
		cle1.CREATION_DATE    CREATION_DATE,
		cle1.LAST_UPDATED_BY  LAST_UPDATED_BY,
		cle1.LAST_UPDATE_DATE LAST_UPDATE_DATE,
        cle1.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
        FROM OKC_K_LINES_B cle1,OKS_CON_LINES_INT_ALL ocl
        WHERE 	cle1.Lse_Id = 1
        AND     cle1.UPG_ORIG_SYSTEM_REF_ID = ocl.contract_line_id
        AND     cle1.dnz_chr_Id <> -1
        AND     cle1.UPG_ORIG_SYSTEM_REF = g_line_ref
        AND     ocl.coverage_id  = p_id;

Line: 79


	select nvl(coverage_id,0) id,nvl(coverage_template_id,0) tid
	from oks_con_lines_int_all
    where coverage_id <> 0;

Line: 84


		select distinct coverage_schedule_id id
		from mtl_system_items mtl,
		Okc_k_Lines_b cle,
		okc_k_Items cim
		WHERE to_char(mtl.Inventory_Item_Id) = cim.object1_Id1
		AND to_char(mtl.Organization_Id) = cim.object1_Id2
		AND cle.Id = cim.Cle_Id
		AND mtl.Coverage_Schedule_Id IS NOT NULL ;

Line: 134


		 SELECT LOOKUP_CODE
		 FROM   FND_LOOKUPS
		 WHERE  LOOKUP_TYPE = 'OKSCVETYPE'
		 AND    MEANING = P_contract_type;

Line: 182


        l_clev_tbl_in(i).LAST_UPDATE_DATE    := sysdate;

Line: 183


        l_clev_tbl_in(i).LAST_UPDATED_BY     := -1;

Line: 184


        l_clev_tbl_in(i).LAST_UPDATE_LOGIN   := -1;

Line: 242


           okc_cle_pvt.Insert_Row(
                                p_api_version   =>  l_api_version,
                                p_init_msg_list =>    l_init_msg_list,
                                x_return_status =>    l_return_status ,
                                x_msg_count     =>    l_msg_count,
                                x_msg_data      =>    l_msg_data,
                                p_clev_tbl      =>    l_clev_tbl_in,
                                x_clev_tbl      =>    x_clev_tbl_in);

Line: 254


    	okc_cle_pvt.Insert_Row_Upg( l_return_status , l_clev_tbl_in);

Line: 266


    l_rgpv_tbl_in(i).LAST_UPDATE_DATE       := sysdate;

Line: 267


    l_rgpv_tbl_in(i).LAST_UPDATED_BY        := -1;

Line: 268


    l_rgpv_tbl_in(i).LAST_UPDATE_LOGIN      := -1;

Line: 304


           okc_rgp_pvt.Insert_Row(
                                p_api_version   =>  l_api_version,
                                p_init_msg_list =>    l_init_msg_list,
                                x_return_status =>    l_return_status ,
                                x_msg_count     =>    l_msg_count,
                                x_msg_data      =>    l_msg_data,
                                p_rgpv_tbl      =>    l_rgpv_tbl_in,
                                x_rgpv_tbl      =>    x_rgpv_tbl_in);

Line: 316


   	okc_rgp_pvt.Insert_Row_Upg( l_return_status , l_rgpv_tbl_in);

Line: 322


/*Inserting Rule Informations */
--OFS Rule
           l_rulv_tbl_in(i).rgp_id	            	  := l_rgpv_tbl_in(i).id;

Line: 334


           l_rulv_tbl_in(i).LAST_UPDATE_DATE          := sysdate;

Line: 335


           l_rulv_tbl_in(i).LAST_UPDATED_BY           := -1;

Line: 336


           l_rulv_tbl_in(i).LAST_UPDATE_LOGIN         := -1;

Line: 388


           okc_rul_pvt.Insert_Row(
                                p_api_version   =>  l_api_version,
                                p_init_msg_list =>    l_init_msg_list,
                                x_return_status =>    l_return_status ,
                                x_msg_count     =>    l_msg_count,
                                x_msg_data      =>    l_msg_data,
                                p_rulv_tbl      =>    l_rulv_tbl_in,
                                x_rulv_tbl      =>    x_rulv_tbl_in);

Line: 400


            	okc_rul_pvt.Insert_Row_Upg( l_return_status , l_rulv_tbl_in);

Line: 448


  l_isev_ext_tbl_in(i).LAST_UPDATE_DATE          := sysdate;

Line: 449


  l_isev_ext_tbl_in(i).LAST_UPDATED_BY           := -1;

Line: 450


  l_isev_ext_tbl_in(i).LAST_UPDATE_LOGIN         := -1;

Line: 452


	okc_time_pvt.Insert_ise_Row_Upg( l_isev_ext_tbl_in);

Line: 454


                l_rulv_tbl_in.delete;

Line: 455


                l_isev_ext_tbl_in.delete;

Line: 471


           l_rulv_tbl_in(i).LAST_UPDATE_DATE          := sysdate;

Line: 472


           l_rulv_tbl_in(i).LAST_UPDATED_BY           := -1;

Line: 473


           l_rulv_tbl_in(i).LAST_UPDATE_LOGIN         := -1;

Line: 523


           okc_rul_pvt.Insert_Row(
                                p_api_version   =>  l_api_version,
                                p_init_msg_list =>    l_init_msg_list,
                                x_return_status =>    l_return_status ,
                                x_msg_count     =>    l_msg_count,
                                x_msg_data      =>    l_msg_data,
                                p_rulv_tbl      =>    l_rulv_tbl_in,
                                x_rulv_tbl      =>    x_rulv_tbl_in);

Line: 535


            	okc_rul_pvt.Insert_Row_Upg( l_return_status , l_rulv_tbl_in);

Line: 539


                l_rulv_tbl_in.delete;

Line: 555


           l_rulv_tbl_in(i).LAST_UPDATE_DATE          := sysdate;

Line: 556


           l_rulv_tbl_in(i).LAST_UPDATED_BY           := -1;

Line: 557


           l_rulv_tbl_in(i).LAST_UPDATE_LOGIN         := -1;

Line: 606


           okc_rul_pvt.Insert_Row(
                                p_api_version   =>  l_api_version,
                                p_init_msg_list =>    l_init_msg_list,
                                x_return_status =>    l_return_status ,
                                x_msg_count     =>    l_msg_count,
                                x_msg_data      =>    l_msg_data,
                                p_rulv_tbl      =>    l_rulv_tbl_in,
                                x_rulv_tbl      =>    x_rulv_tbl_in);

Line: 618


            	okc_rul_pvt.Insert_Row_Upg( l_return_status , l_rulv_tbl_in);

Line: 621


                l_rulv_tbl_in.delete;

Line: 635


           l_rulv_tbl_in(i).LAST_UPDATE_DATE          := sysdate;

Line: 636


           l_rulv_tbl_in(i).LAST_UPDATED_BY           := -1;

Line: 637


           l_rulv_tbl_in(i).LAST_UPDATE_LOGIN         := -1;

Line: 686


           okc_rul_pvt.Insert_Row(
                                p_api_version   =>  l_api_version,
                                p_init_msg_list =>    l_init_msg_list,
                                x_return_status =>    l_return_status ,
                                x_msg_count     =>    l_msg_count,
                                x_msg_data      =>    l_msg_data,
                                p_rulv_tbl      =>    l_rulv_tbl_in,
                                x_rulv_tbl      =>    x_rulv_tbl_in);

Line: 698


            	okc_rul_pvt.Insert_Row_Upg( l_return_status , l_rulv_tbl_in);

Line: 701


                l_rulv_tbl_in.delete;

Line: 716


            l_rulv_tbl_in(i).LAST_UPDATE_DATE          := sysdate;

Line: 717


            l_rulv_tbl_in(i).LAST_UPDATED_BY           := -1;

Line: 718


            l_rulv_tbl_in(i).LAST_UPDATE_LOGIN         := -1;

Line: 765


           okc_rul_pvt.Insert_Row(
                                p_api_version   =>  l_api_version,
                                p_init_msg_list =>    l_init_msg_list,
                                x_return_status =>    l_return_status ,
                                x_msg_count     =>    l_msg_count,
                                x_msg_data      =>    l_msg_data,
                                p_rulv_tbl      =>    l_rulv_tbl_in,
                                x_rulv_tbl      =>    x_rulv_tbl_in);

Line: 777


            	okc_rul_pvt.Insert_Row_Upg( l_return_status , l_rulv_tbl_in);

Line: 780


                        l_rulv_tbl_in.delete;

Line: 783


/*Complete Inserting Rule Informations */


            -- dbms_output.put_line('Before 0 Commit');

Line: 788


            l_clev_tbl_in.delete;

Line: 789


            l_rgpv_tbl_in.delete;

Line: 793


          UPDATE oks_coverages_int_all
          SET    INTERFACED_STATUS_FLAG  = 'S',
                 LAST_UPDATED_BY         = -1,
                 LAST_UPDATE_DATE        = sysdate,
                 LAST_UPDATE_LOGIN       = -1
          WHERE  COVERAGE_ID = get_coverages_rec.coverage_id;

Line: 827


SELECT
obp.coverage_bus_process_id,
obp.coverage_id,
obp.business_process_id,
obp.offset_duration,
obp.offset_period,
obp.start_date,
obp.end_date,
obp.price_list_id,
obp.discount_id,
obp.coverage_sunday_start_time,
obp.coverage_sunday_end_time,
obp.coverage_monday_start_time,
obp.coverage_monday_end_time,
obp.coverage_tuesday_start_time,
obp.coverage_tuesday_end_time,
obp.coverage_wednesday_start_time,
obp.coverage_wednesday_end_time,
obp.coverage_thursday_start_time,
obp.coverage_thursday_end_time,
obp.coverage_friday_start_time,
obp.coverage_friday_end_time,
obp.coverage_saturday_start_time,
obp.coverage_saturday_end_time,
obp.time_zone_id,
obp.reaction_name,
obp.reaction_description,
obp.reaction_time_id,
obp.reaction_severity_code,
obp.Incident_severity_id,
obp.sunday_reaction_times,
obp.monday_reaction_times,
obp.tuesday_reaction_times,
obp.wednesday_reaction_times,
obp.thursday_reaction_times,
obp.friday_reaction_times,
obp.saturday_reaction_times,
obp.work_through_yn,
obp.active_yn,
obp.sunday_resolution_times,
obp.monday_resolution_times,
obp.tuesday_resolution_times,
obp.wednesday_resolution_times,
obp.thursday_resolution_times,
obp.friday_resolution_times,
obp.saturday_resolution_times,
obp.preferred_resource_type,
obp.preferred_resource_id,
obp.attribute_category,
obp.attribute1,
obp.attribute2,
obp.attribute3,
obp.attribute4,
obp.attribute5,
obp.attribute6,
obp.attribute7,
obp.attribute8,
obp.attribute9,
obp.attribute10,
obp.attribute11,
obp.attribute12,
obp.attribute13,
obp.attribute14,
obp.attribute15,
okl.id cle_id,
okl.dnz_chr_id,
okl.sts_code,
okl.currency_code
FROM    oks_cov_txn_groups_int_all obp,
        okc_k_lines_b okl,
        oks_coverages_int_all cov,
        oks_con_lines_int_all lines,
        oks_con_headers_int_all head
WHERE   okl.upg_Orig_System_Ref= g_covline_ref
AND     okl.upg_Orig_System_Ref_Id = obp.Coverage_Id
AND     obp.coverage_id = cov.coverage_id
AND     cov.INTERFACED_STATUS_FLAG = 'S'
AND     cov.coverage_id = lines.coverage_id
AND     lines.INTERFACED_STATUS_FLAG = 'S'
AND     head.contract_id = lines.contract_id
AND     head.INTERFACED_STATUS_FLAG = 'S'
AND     head.batch_number between p_fromid and p_toid
AND     obp.interfaced_status_flag is null;

Line: 919


      g_Last_updated_by         NUMBER;

Line: 920


      g_Last_update_date        date;

Line: 921


      g_Last_Update_Login       NUMBER;

Line: 1018


SELECT Id1 FROM OKX_RESOURCES_V
WHERE Description = P_Name;

Line: 1053


	SELECT old.contract_status_id k_id, upper(old.name) old_stat,
     	  decode(new.code, NULL,'ENTERED',upper(old.name)) new_stat
	FROM   OKC_STATUSES_V new, CS_CONTRACT_STATUSES old
	WHERE  upper(new.code(+)) = upper(old.name);

Line: 1148


                g_LAST_UPDATE_DATE              := sysdate;

Line: 1149


                g_LAST_UPDATED_BY               := -1;

Line: 1150


                g_LAST_UPDATE_LOGIN             := -1;

Line: 1164


    l_clev_tbl_in(i).LAST_UPDATE_DATE   := g_LAST_UPDATE_DATE;

Line: 1165


    l_clev_tbl_in(i).LAST_UPDATED_BY    := g_LAST_UPDATED_BY;

Line: 1166


    l_clev_tbl_in(i).LAST_UPDATE_LOGIN  := g_LAST_UPDATE_LOGIN;

Line: 1208


    l_clev_tbl_in(i).LAST_UPDATE_LOGIN                        :=Null;

Line: 1238


    l_cimv_tbl_in(i).LAST_UPDATE_DATE             := g_LAST_UPDATE_DATE;

Line: 1239


    l_cimv_tbl_in(i).LAST_UPDATED_BY              := g_LAST_UPDATED_BY;

Line: 1240


    l_cimv_tbl_in(i).LAST_UPDATE_LOGIN            := g_LAST_UPDATE_LOGIN;

Line: 1261


     l_rgpv_tbl_in(i).LAST_UPDATE_DATE          := g_LAST_UPDATE_DATE;

Line: 1262


     l_rgpv_tbl_in(i).LAST_UPDATED_BY           := g_LAST_UPDATED_BY;

Line: 1263


     l_rgpv_tbl_in(i).LAST_UPDATE_LOGIN         := g_LAST_UPDATE_LOGIN;

Line: 1334


  l_isev_rel_tbl_in(i).LAST_UPDATE_DATE              := sysdate;

Line: 1335


  l_isev_rel_tbl_in(i).LAST_UPDATED_BY               := -1;

Line: 1336


  l_isev_rel_tbl_in(i).LAST_UPDATE_LOGIN             := -1;

Line: 1387


  l_isev_ext_tbl_in(i).LAST_UPDATE_DATE              := sysdate;

Line: 1388


  l_isev_ext_tbl_in(i).LAST_UPDATED_BY               := -1;

Line: 1389


  l_isev_ext_tbl_in(i).LAST_UPDATE_LOGIN             := -1;

Line: 1403


   l_rulv_tbl_in(i).LAST_UPDATE_DATE                := sysdate;

Line: 1404


   l_rulv_tbl_in(i).LAST_UPDATED_BY                 := -1;

Line: 1405


   l_rulv_tbl_in(i).LAST_UPDATE_LOGIN               := -1;

Line: 1479


   l_rulv_tbl_in(i+1000).LAST_UPDATE_DATE           := sysdate;

Line: 1480


   l_rulv_tbl_in(i+1000).LAST_UPDATED_BY            := -1;

Line: 1481


   l_rulv_tbl_in(i+1000).LAST_UPDATE_LOGIN          := -1;

Line: 1536


   l_rulv_tbl_in(i+3000).LAST_UPDATE_DATE          := g_LAST_UPDATE_DATE;

Line: 1537


   l_rulv_tbl_in(i+3000).LAST_UPDATED_BY           := g_LAST_UPDATED_BY;

Line: 1538


   l_rulv_tbl_in(i+3000).LAST_UPDATE_LOGIN         := g_LAST_UPDATE_LOGIN;

Line: 1596


    l_igsv_ext_tbl_in(i).LAST_UPDATE_DATE                := g_LAST_UPDATE_DATE;

Line: 1597


    l_igsv_ext_tbl_in(i).LAST_UPDATED_BY                 := g_LAST_UPDATED_BY;

Line: 1598


    l_igsv_ext_tbl_in(i).LAST_UPDATE_LOGIN               := g_LAST_UPDATE_LOGIN;

Line: 1629


    l_ctiv_tbl_in(i).LAST_UPDATE_DATE       := g_LAST_UPDATE_DATE;

Line: 1630


    l_ctiv_tbl_in(i).LAST_UPDATED_BY        := g_LAST_UPDATED_BY;

Line: 1631


    l_ctiv_tbl_in(i).LAST_UPDATE_LOGIN      := g_LAST_UPDATE_LOGIN;

Line: 1652


    l_igsv_ext_tbl_in(i+1000).LAST_UPDATE_DATE                := g_LAST_UPDATE_DATE;

Line: 1653


    l_igsv_ext_tbl_in(i+1000).LAST_UPDATED_BY                 := g_LAST_UPDATED_BY;

Line: 1654


    l_igsv_ext_tbl_in(i+1000).LAST_UPDATE_LOGIN               := g_LAST_UPDATE_LOGIN;

Line: 1684


    l_ctiv_tbl_in(i+1000).LAST_UPDATE_DATE       := g_LAST_UPDATE_DATE;

Line: 1685


    l_ctiv_tbl_in(i+1000).LAST_UPDATED_BY        := g_LAST_UPDATED_BY;

Line: 1686


    l_ctiv_tbl_in(i+1000).LAST_UPDATE_LOGIN      := g_LAST_UPDATE_LOGIN;

Line: 1705


    l_igsv_ext_tbl_in(i+2000).LAST_UPDATE_DATE                := g_LAST_UPDATE_DATE;

Line: 1706


    l_igsv_ext_tbl_in(i+2000).LAST_UPDATED_BY                 := g_LAST_UPDATED_BY;

Line: 1707


    l_igsv_ext_tbl_in(i+2000).LAST_UPDATE_LOGIN               := g_LAST_UPDATE_LOGIN;

Line: 1737


    l_ctiv_tbl_in(i+2000).LAST_UPDATE_DATE       := g_LAST_UPDATE_DATE;

Line: 1738


    l_ctiv_tbl_in(i+2000).LAST_UPDATED_BY        := g_LAST_UPDATED_BY;

Line: 1739


    l_ctiv_tbl_in(i+2000).LAST_UPDATE_LOGIN      := g_LAST_UPDATE_LOGIN;

Line: 1758


    l_igsv_ext_tbl_in(i+3000).LAST_UPDATE_DATE                := g_LAST_UPDATE_DATE;

Line: 1759


    l_igsv_ext_tbl_in(i+3000).LAST_UPDATED_BY                 := g_LAST_UPDATED_BY;

Line: 1760


    l_igsv_ext_tbl_in(i+3000).LAST_UPDATE_LOGIN               := g_LAST_UPDATE_LOGIN;

Line: 1790


    l_ctiv_tbl_in(i+3000).LAST_UPDATE_DATE       := g_LAST_UPDATE_DATE;

Line: 1791


    l_ctiv_tbl_in(i+3000).LAST_UPDATED_BY        := g_LAST_UPDATED_BY;

Line: 1792


    l_ctiv_tbl_in(i+3000).LAST_UPDATE_LOGIN      := g_LAST_UPDATE_LOGIN;

Line: 1812


    l_igsv_ext_tbl_in(i+4000).LAST_UPDATE_DATE                := g_LAST_UPDATE_DATE;

Line: 1813


    l_igsv_ext_tbl_in(i+4000).LAST_UPDATED_BY                 := g_LAST_UPDATED_BY;

Line: 1814


    l_igsv_ext_tbl_in(i+4000).LAST_UPDATE_LOGIN               := g_LAST_UPDATE_LOGIN;

Line: 1845


    l_ctiv_tbl_in(i+4000).LAST_UPDATE_DATE       := g_LAST_UPDATE_DATE;

Line: 1846


    l_ctiv_tbl_in(i+4000).LAST_UPDATED_BY        := g_LAST_UPDATED_BY;

Line: 1847


    l_ctiv_tbl_in(i+4000).LAST_UPDATE_LOGIN      := g_LAST_UPDATE_LOGIN;

Line: 1867


    l_igsv_ext_tbl_in(i+5000).LAST_UPDATE_DATE                := g_LAST_UPDATE_DATE;

Line: 1868


    l_igsv_ext_tbl_in(i+5000).LAST_UPDATED_BY                 := g_LAST_UPDATED_BY;

Line: 1869


    l_igsv_ext_tbl_in(i+5000).LAST_UPDATE_LOGIN               := g_LAST_UPDATE_LOGIN;

Line: 1899


    l_ctiv_tbl_in(i+5000).LAST_UPDATE_DATE       := g_LAST_UPDATE_DATE;

Line: 1900


    l_ctiv_tbl_in(i+5000).LAST_UPDATED_BY        := g_LAST_UPDATED_BY;

Line: 1901


    l_ctiv_tbl_in(i+5000).LAST_UPDATE_LOGIN      := g_LAST_UPDATE_LOGIN;

Line: 1919


    l_igsv_ext_tbl_in(i+6000).LAST_UPDATE_DATE                := g_LAST_UPDATE_DATE;

Line: 1920


    l_igsv_ext_tbl_in(i+6000).LAST_UPDATED_BY                 := g_LAST_UPDATED_BY;

Line: 1921


    l_igsv_ext_tbl_in(i+6000).LAST_UPDATE_LOGIN               := g_LAST_UPDATE_LOGIN;

Line: 1951


    l_ctiv_tbl_in(i+6000).LAST_UPDATE_DATE       := g_LAST_UPDATE_DATE;

Line: 1952


    l_ctiv_tbl_in(i+6000).LAST_UPDATED_BY        := g_LAST_UPDATED_BY;

Line: 1953


    l_ctiv_tbl_in(i+6000).LAST_UPDATE_LOGIN      := g_LAST_UPDATE_LOGIN;

Line: 1969


   l_cplv_tbl_in(i).LAST_UPDATE_DATE            := g_LAST_UPDATE_DATE;

Line: 1970


   l_cplv_tbl_in(i).LAST_UPDATED_BY             := g_LAST_UPDATED_BY;

Line: 1971


   l_cplv_tbl_in(i).LAST_UPDATE_LOGIN           := g_LAST_UPDATE_LOGIN;

Line: 1979


  l_cplv_tbl_in(i).LAST_UPDATE_LOGIN                       :=null;

Line: 2004


   l_ctcv_tbl_in(i).LAST_UPDATE_DATE            := g_LAST_UPDATE_DATE;

Line: 2005


   l_ctcv_tbl_in(i).LAST_UPDATED_BY             := g_LAST_UPDATED_BY;

Line: 2006


   l_ctcv_tbl_in(i).LAST_UPDATE_LOGIN           := g_LAST_UPDATE_LOGIN;

Line: 2011


   l_ctcv_tbl_in(i).LAST_UPDATE_LOGIN                         :=null;

Line: 2035


    l_clev_tbl_in(i+1000).LAST_UPDATE_DATE     := g_LAST_UPDATE_DATE;

Line: 2036


    l_clev_tbl_in(i+1000).LAST_UPDATED_BY        := g_LAST_UPDATED_BY;

Line: 2037


    l_clev_tbl_in(i+1000).LAST_UPDATE_LOGIN    := g_LAST_UPDATE_LOGIN;

Line: 2106


     l_rgpv_tbl_in(i+1000).LAST_UPDATE_DATE          := g_LAST_UPDATE_DATE;

Line: 2107


     l_rgpv_tbl_in(i+1000).LAST_UPDATED_BY           := g_LAST_UPDATED_BY;

Line: 2108


     l_rgpv_tbl_in(i+1000).LAST_UPDATE_LOGIN         := g_LAST_UPDATE_LOGIN;

Line: 2143


   l_rulv_tbl_in(i+4000).LAST_UPDATE_DATE := g_LAST_UPDATE_DATE;

Line: 2144


   l_rulv_tbl_in(i+4000).LAST_UPDATED_BY := g_LAST_UPDATED_BY;

Line: 2145


   l_rulv_tbl_in(i+4000).LAST_UPDATE_LOGIN := g_LAST_UPDATE_LOGIN;

Line: 2201


   l_rulv_tbl_in(i+5000).LAST_UPDATE_DATE := g_LAST_UPDATE_DATE;

Line: 2202


   l_rulv_tbl_in(i+5000).LAST_UPDATED_BY := g_LAST_UPDATED_BY;

Line: 2203


   l_rulv_tbl_in(i+5000).LAST_UPDATE_LOGIN := g_LAST_UPDATE_LOGIN;

Line: 2261


    l_tgdv_ext_tbl_in(i).LAST_UPDATE_DATE := g_LAST_UPDATE_DATE;

Line: 2262


    l_tgdv_ext_tbl_in(i).LAST_UPDATED_BY := g_LAST_UPDATED_BY;

Line: 2263


    l_tgdv_ext_tbl_in(i).LAST_UPDATE_LOGIN := g_LAST_UPDATE_LOGIN;

Line: 2303


    l_rilv_tbl_in(i).LAST_UPDATE_DATE := g_LAST_UPDATE_DATE;

Line: 2304


    l_rilv_tbl_in(i).LAST_UPDATED_BY := g_LAST_UPDATED_BY;

Line: 2305


    l_rilv_tbl_in(i).LAST_UPDATE_LOGIN := g_LAST_UPDATE_LOGIN;

Line: 2317


    l_tgdv_ext_tbl_in(i+1000).LAST_UPDATE_DATE := g_LAST_UPDATE_DATE;

Line: 2318


    l_tgdv_ext_tbl_in(i+1000).LAST_UPDATED_BY := g_LAST_UPDATED_BY;

Line: 2319


    l_tgdv_ext_tbl_in(i+1000).LAST_UPDATE_LOGIN := g_LAST_UPDATE_LOGIN;

Line: 2359


    l_rilv_tbl_in(i+1000).LAST_UPDATE_DATE := g_LAST_UPDATE_DATE;

Line: 2360


    l_rilv_tbl_in(i+1000).LAST_UPDATED_BY := g_LAST_UPDATED_BY;

Line: 2361


    l_rilv_tbl_in(i+1000).LAST_UPDATE_LOGIN := g_LAST_UPDATE_LOGIN;

Line: 2372


    l_tgdv_ext_tbl_in(i+2000).LAST_UPDATE_DATE := g_LAST_UPDATE_DATE;

Line: 2373


    l_tgdv_ext_tbl_in(i+2000).LAST_UPDATED_BY := g_LAST_UPDATED_BY;

Line: 2374


    l_tgdv_ext_tbl_in(i+2000).LAST_UPDATE_LOGIN := g_LAST_UPDATE_LOGIN;

Line: 2413


    l_rilv_tbl_in(i+2000).LAST_UPDATE_DATE := g_LAST_UPDATE_DATE;

Line: 2414


    l_rilv_tbl_in(i+2000).LAST_UPDATED_BY := g_LAST_UPDATED_BY;

Line: 2415


    l_rilv_tbl_in(i+2000).LAST_UPDATE_LOGIN := g_LAST_UPDATE_LOGIN;

Line: 2425


    l_tgdv_ext_tbl_in(i+3000).LAST_UPDATE_DATE := g_LAST_UPDATE_DATE;

Line: 2426


    l_tgdv_ext_tbl_in(i+3000).LAST_UPDATED_BY := g_LAST_UPDATED_BY;

Line: 2427


    l_tgdv_ext_tbl_in(i+3000).LAST_UPDATE_LOGIN := g_LAST_UPDATE_LOGIN;

Line: 2467


    l_rilv_tbl_in(i+3000).LAST_UPDATE_DATE := g_LAST_UPDATE_DATE;

Line: 2468


    l_rilv_tbl_in(i+3000).LAST_UPDATED_BY := g_LAST_UPDATED_BY;

Line: 2469


    l_rilv_tbl_in(i+3000).LAST_UPDATE_LOGIN := g_LAST_UPDATE_LOGIN;

Line: 2480


    l_tgdv_ext_tbl_in(i+4000).LAST_UPDATE_DATE := g_LAST_UPDATE_DATE;

Line: 2481


    l_tgdv_ext_tbl_in(i+4000).LAST_UPDATED_BY := g_LAST_UPDATED_BY;

Line: 2482


    l_tgdv_ext_tbl_in(i+4000).LAST_UPDATE_LOGIN := g_LAST_UPDATE_LOGIN;

Line: 2522


    l_rilv_tbl_in(i+4000).LAST_UPDATE_DATE := g_LAST_UPDATE_DATE;

Line: 2523


    l_rilv_tbl_in(i+4000).LAST_UPDATED_BY := g_LAST_UPDATED_BY;

Line: 2524


    l_rilv_tbl_in(i+4000).LAST_UPDATE_LOGIN := g_LAST_UPDATE_LOGIN;

Line: 2535


    l_tgdv_ext_tbl_in(i+5000).LAST_UPDATE_DATE := g_LAST_UPDATE_DATE;

Line: 2536


    l_tgdv_ext_tbl_in(i+5000).LAST_UPDATED_BY := g_LAST_UPDATED_BY;

Line: 2537


    l_tgdv_ext_tbl_in(i+5000).LAST_UPDATE_LOGIN := g_LAST_UPDATE_LOGIN;

Line: 2577


    l_rilv_tbl_in(i+5000).LAST_UPDATE_DATE := g_LAST_UPDATE_DATE;

Line: 2578


    l_rilv_tbl_in(i+5000).LAST_UPDATED_BY := g_LAST_UPDATED_BY;

Line: 2579


    l_rilv_tbl_in(i+5000).LAST_UPDATE_LOGIN := g_LAST_UPDATE_LOGIN;

Line: 2590


    l_tgdv_ext_tbl_in(i+6000).LAST_UPDATE_DATE := g_LAST_UPDATE_DATE;

Line: 2591


    l_tgdv_ext_tbl_in(i+6000).LAST_UPDATED_BY := g_LAST_UPDATED_BY;

Line: 2592


    l_tgdv_ext_tbl_in(i+6000).LAST_UPDATE_LOGIN := g_LAST_UPDATE_LOGIN;

Line: 2632


    l_rilv_tbl_in(i+6000).LAST_UPDATE_DATE := g_LAST_UPDATE_DATE;

Line: 2633


    l_rilv_tbl_in(i+6000).LAST_UPDATED_BY := g_LAST_UPDATED_BY;

Line: 2634


    l_rilv_tbl_in(i+6000).LAST_UPDATE_LOGIN := g_LAST_UPDATE_LOGIN;

Line: 2644


    l_tgdv_rcn_tbl_in(i).LAST_UPDATE_DATE := g_LAST_UPDATE_DATE;

Line: 2645


    l_tgdv_rcn_tbl_in(i).LAST_UPDATED_BY := g_LAST_UPDATED_BY;

Line: 2646


    l_tgdv_rcn_tbl_in(i).LAST_UPDATE_LOGIN := g_LAST_UPDATE_LOGIN;

Line: 2686


    l_rilt_tbl_in(i).LAST_UPDATE_DATE := g_LAST_UPDATE_DATE;

Line: 2687


    l_rilt_tbl_in(i).LAST_UPDATED_BY := g_LAST_UPDATED_BY;

Line: 2688


    l_rilt_tbl_in(i).LAST_UPDATE_LOGIN := g_LAST_UPDATE_LOGIN;

Line: 2700


    l_tgdv_rcn_tbl_in(i+1000).LAST_UPDATE_DATE := g_LAST_UPDATE_DATE;

Line: 2701


    l_tgdv_rcn_tbl_in(i+1000).LAST_UPDATED_BY := g_LAST_UPDATED_BY;

Line: 2702


    l_tgdv_rcn_tbl_in(i+1000).LAST_UPDATE_LOGIN := g_LAST_UPDATE_LOGIN;

Line: 2742


    l_rilt_tbl_in(i+1000).LAST_UPDATE_DATE := g_LAST_UPDATE_DATE;

Line: 2743


    l_rilt_tbl_in(i+1000).LAST_UPDATED_BY := g_LAST_UPDATED_BY;

Line: 2744


    l_rilt_tbl_in(i+1000).LAST_UPDATE_LOGIN := g_LAST_UPDATE_LOGIN;

Line: 2755


    l_tgdv_rcn_tbl_in(i+2000).LAST_UPDATE_DATE := g_LAST_UPDATE_DATE;

Line: 2756


    l_tgdv_rcn_tbl_in(i+2000).LAST_UPDATED_BY := g_LAST_UPDATED_BY;

Line: 2757


    l_tgdv_rcn_tbl_in(i+2000).LAST_UPDATE_LOGIN := g_LAST_UPDATE_LOGIN;

Line: 2796


    l_rilt_tbl_in(i+2000).LAST_UPDATE_DATE := g_LAST_UPDATE_DATE;

Line: 2797


    l_rilt_tbl_in(i+2000).LAST_UPDATED_BY := g_LAST_UPDATED_BY;

Line: 2798


    l_rilt_tbl_in(i+2000).LAST_UPDATE_LOGIN := g_LAST_UPDATE_LOGIN;

Line: 2808


    l_tgdv_rcn_tbl_in(i+3000).LAST_UPDATE_DATE := g_LAST_UPDATE_DATE;

Line: 2809


    l_tgdv_rcn_tbl_in(i+3000).LAST_UPDATED_BY := g_LAST_UPDATED_BY;

Line: 2810


    l_tgdv_rcn_tbl_in(i+3000).LAST_UPDATE_LOGIN := g_LAST_UPDATE_LOGIN;

Line: 2850


    l_rilt_tbl_in(i+3000).LAST_UPDATE_DATE := g_LAST_UPDATE_DATE;

Line: 2851


    l_rilt_tbl_in(i+3000).LAST_UPDATED_BY := g_LAST_UPDATED_BY;

Line: 2852


    l_rilt_tbl_in(i+3000).LAST_UPDATE_LOGIN := g_LAST_UPDATE_LOGIN;

Line: 2863


    l_tgdv_rcn_tbl_in(i+4000).LAST_UPDATE_DATE := g_LAST_UPDATE_DATE;

Line: 2864


    l_tgdv_rcn_tbl_in(i+4000).LAST_UPDATED_BY := g_LAST_UPDATED_BY;

Line: 2865


    l_tgdv_rcn_tbl_in(i+4000).LAST_UPDATE_LOGIN := g_LAST_UPDATE_LOGIN;

Line: 2905


    l_rilt_tbl_in(i+4000).LAST_UPDATE_DATE := g_LAST_UPDATE_DATE;

Line: 2906


    l_rilt_tbl_in(i+4000).LAST_UPDATED_BY := g_LAST_UPDATED_BY;

Line: 2907


    l_rilt_tbl_in(i+4000).LAST_UPDATE_LOGIN := g_LAST_UPDATE_LOGIN;

Line: 2918


    l_tgdv_rcn_tbl_in(i+5000).LAST_UPDATE_DATE := g_LAST_UPDATE_DATE;

Line: 2919


    l_tgdv_rcn_tbl_in(i+5000).LAST_UPDATED_BY := g_LAST_UPDATED_BY;

Line: 2920


    l_tgdv_rcn_tbl_in(i+5000).LAST_UPDATE_LOGIN := g_LAST_UPDATE_LOGIN;

Line: 2960


    l_rilt_tbl_in(i+5000).LAST_UPDATE_DATE := g_LAST_UPDATE_DATE;

Line: 2961


    l_rilt_tbl_in(i+5000).LAST_UPDATED_BY := g_LAST_UPDATED_BY;

Line: 2962


    l_rilt_tbl_in(i+5000).LAST_UPDATE_LOGIN := g_LAST_UPDATE_LOGIN;

Line: 2973


    l_tgdv_rcn_tbl_in(i+6000).LAST_UPDATE_DATE := g_LAST_UPDATE_DATE;

Line: 2974


    l_tgdv_rcn_tbl_in(i+6000).LAST_UPDATED_BY := g_LAST_UPDATED_BY;

Line: 2975


    l_tgdv_rcn_tbl_in(i+6000).LAST_UPDATE_LOGIN := g_LAST_UPDATE_LOGIN;

Line: 3015


    l_rilt_tbl_in(i+6000).LAST_UPDATE_DATE := g_LAST_UPDATE_DATE;

Line: 3016


    l_rilt_tbl_in(i+6000).LAST_UPDATED_BY := g_LAST_UPDATED_BY;

Line: 3017


    l_rilt_tbl_in(i+6000).LAST_UPDATE_LOGIN := g_LAST_UPDATE_LOGIN;

Line: 3031


           okc_cle_pvt.Insert_Row(
                                p_api_version   =>  l_api_version,
                                p_init_msg_list =>    l_init_msg_list,
                                x_return_status =>    l_return_status ,
                                x_msg_count     =>    l_msg_count,
                                x_msg_data      =>    l_msg_data,
                                p_clev_tbl      =>    l_clev_tbl_in,
                                x_clev_tbl      =>    x_clev_tbl_in);

Line: 3043


                l_Clev_tbl_in.DELETE;

Line: 3048


         okc_cim_pvt.Insert_Row(
                                p_api_version   =>  l_api_version,
                                p_init_msg_list =>    l_init_msg_list,
                                x_return_status =>    l_return_status ,
                                x_msg_count     =>    l_msg_count,
                                x_msg_data      =>    l_msg_data,
                                p_cimv_tbl      =>    l_cimv_tbl_in,
                                x_cimv_tbl      =>    x_cimv_tbl_in);

Line: 3058


                l_Cimv_tbl_in.DELETE;

Line: 3064


okc_rgp_pvt.Insert_Row(
                                p_api_version   =>  l_api_version,
                                p_init_msg_list =>    l_init_msg_list,
                                x_return_status =>    l_return_status ,
                                x_msg_count     =>    l_msg_count,
                                x_msg_data      =>    l_msg_data,
                                p_rgpv_tbl      =>    l_rgpv_tbl_in,
                                x_rgpv_tbl      =>    x_rgpv_tbl_in);

Line: 3075


                l_rgpv_tbl_in.DELETE;

Line: 3081


           okc_rul_pvt.Insert_Row(
                                p_api_version   =>  l_api_version,
                                p_init_msg_list =>    l_init_msg_list,
                                x_return_status =>    l_return_status ,
                                x_msg_count     =>    l_msg_count,
                                x_msg_data      =>    l_msg_data,
                                p_rulv_tbl      =>    l_rulv_tbl_in,
                                x_rulv_tbl      =>    x_rulv_tbl_in);

Line: 3092


l_rulv_tbl_in.delete;

Line: 3097


	okc_cpl_pvt.Insert_Row(
                                p_api_version   =>  l_api_version,
                                p_init_msg_list =>    l_init_msg_list,
                                x_return_status =>    l_return_status ,
                                x_msg_count     =>    l_msg_count,
                                x_msg_data      =>    l_msg_data,
                                p_cplv_tbl      =>    l_cplv_tbl_in,
                                x_cplv_tbl      =>    x_cplv_tbl_in);

Line: 3108


                l_Cplv_Tbl_In.DELETE;

Line: 3113


	okc_ctc_pvt.Insert_Row(
                                p_api_version   =>  l_api_version,
                                p_init_msg_list =>    l_init_msg_list,
                                x_return_status =>    l_return_status ,
                                x_msg_count     =>    l_msg_count,
                                x_msg_data      =>    l_msg_data,
                                p_ctcv_tbl      =>    l_ctcv_tbl_in,
                                x_ctcv_tbl      =>    x_ctcv_tbl_in);

Line: 3124


                l_ctcv_Tbl_In.DELETE;

Line: 3130


l_error_message := 'okc_time_pvt.Insert_ise_Row_Upg -';

Line: 3131


	okc_time_pvt.Insert_ise_Row_Upg(l_isev_rel_tbl_in);

Line: 3133


    l_isev_rel_tbl_in.delete;

Line: 3137


   l_error_message := 'okc_time_pvt.Insert_ise_Row_Upg -';

Line: 3138


	okc_time_pvt.Insert_ise_Row_Upg(l_isev_ext_tbl_in);

Line: 3140


                l_isev_ext_Tbl_In.DELETE;

Line: 3144


   l_error_message := 'okc_time_pvt.Insert_igs_Row_Upg -';

Line: 3145


	okc_time_pvt.Insert_igs_Row_Upg( l_igsv_ext_tbl_in);

Line: 3147


                l_igsv_ext_Tbl_In.DELETE;

Line: 3154


okc_cti_pvt.Insert_Row(
                                p_api_version   =>  l_api_version,
                                p_init_msg_list =>    l_init_msg_list,
                                x_return_status =>    l_return_status ,
                                x_msg_count     =>    l_msg_count,
                                x_msg_data      =>    l_msg_data,
                                p_ctiv_tbl      =>    l_ctiv_tbl_in,
                                x_ctiv_tbl      =>    x_ctiv_tbl_in);

Line: 3166


                l_ctiv_Tbl_In.DELETE;

Line: 3170


	okc_Time_pvt.Insert_Tgd_Row_Upg( l_tgdv_ext_tbl_in);

Line: 3172


                l_tgdv_ext_tbl_in.DELETE;

Line: 3178


	okc_ril_pvt.Insert_Row(
                                p_api_version   =>  l_api_version,
                                p_init_msg_list =>    l_init_msg_list,
                                x_return_status =>    l_return_status ,
                                x_msg_count     =>    l_msg_count,
                                x_msg_data      =>    l_msg_data,
                                p_rilv_tbl      =>    l_rilv_tbl_in,
                                x_rilv_tbl      =>    x_rilv_tbl_in);

Line: 3189


    l_rilv_tbl_in.DELETE;

Line: 3194


	okc_Time_pvt.Insert_Tgd_Row_Upg( l_tgdv_rcn_tbl_in);

Line: 3196


                l_tgdv_rcn_tbl_in.DELETE;

Line: 3202


	okc_ril_pvt.Insert_Row(
                                p_api_version   =>  l_api_version,
                                p_init_msg_list =>    l_init_msg_list,
                                x_return_status =>    l_return_status ,
                                x_msg_count     =>    l_msg_count,
                                x_msg_data      =>    l_msg_data,
                                p_rilv_tbl      =>    l_rilt_tbl_in,
                                x_rilv_tbl      =>    x_rilt_tbl_in);

Line: 3213


    l_rilt_tbl_in.DELETE;

Line: 3227


	okc_cle_pvt.Insert_Row_Upg( l_return_status , l_clev_tbl_in);

Line: 3229


                l_Clev_tbl_in.DELETE;

Line: 3234


	okc_cim_pvt.Insert_Row_Upg( l_return_status , l_cimv_tbl_in);

Line: 3236


                l_Cimv_tbl_in.DELETE;

Line: 3242


	okc_rgp_pvt.Insert_Row_Upg( l_return_status , l_rgpv_tbl_in);

Line: 3244


                l_rgpv_tbl_in.DELETE;

Line: 3250


	okc_rul_pvt.Insert_Row_Upg( l_return_status , l_rulv_tbl_in);

Line: 3252


l_rulv_tbl_in.delete;

Line: 3257


	okc_cpl_pvt.Insert_Row_Upg( l_return_status , l_cplv_tbl_in);

Line: 3259


                l_Cplv_Tbl_In.DELETE;

Line: 3263


	okc_ctc_pvt.Insert_Row_Upg( l_return_status , l_ctcv_tbl_in);

Line: 3265


                l_ctcv_Tbl_In.DELETE;

Line: 3269


l_error_message := 'okc_time_pvt.Insert_ise_Row_Upg -';

Line: 3270


	okc_time_pvt.Insert_ise_Row_Upg(l_isev_rel_tbl_in);

Line: 3272


    l_isev_rel_tbl_in.delete;

Line: 3276


   l_error_message := 'okc_time_pvt.Insert_ise_Row_Upg -';

Line: 3277


	okc_time_pvt.Insert_ise_Row_Upg(l_isev_ext_tbl_in);

Line: 3279


                l_isev_ext_Tbl_In.DELETE;

Line: 3283


   l_error_message := 'okc_time_pvt.Insert_igs_Row_Upg -';

Line: 3284


	okc_time_pvt.Insert_igs_Row_Upg( l_igsv_ext_tbl_in);

Line: 3286


                l_igsv_ext_Tbl_In.DELETE;

Line: 3292


	okc_cti_pvt.Insert_Row_Upg( l_return_status , l_ctiv_tbl_in);

Line: 3294


                l_ctiv_Tbl_In.DELETE;

Line: 3298


	okc_Time_pvt.Insert_Tgd_Row_Upg( l_tgdv_ext_tbl_in);

Line: 3300


                l_tgdv_ext_tbl_in.DELETE;

Line: 3305


	okc_ril_pvt.Insert_Row_Upg( l_return_status , l_rilv_tbl_in);

Line: 3307


    l_rilv_tbl_in.DELETE;

Line: 3312


	okc_Time_pvt.Insert_Tgd_Row_Upg( l_tgdv_rcn_tbl_in);

Line: 3314


                l_tgdv_rcn_tbl_in.DELETE;

Line: 3319


	okc_ril_pvt.Insert_Row_Upg( l_return_status , l_rilt_tbl_in);

Line: 3321


    l_rilt_tbl_in.DELETE;

Line: 3326


          UPDATE oks_cov_txn_groups_int_all
          SET    INTERFACED_STATUS_FLAG  = 'S',
                 LAST_UPDATED_BY         = -1,
                 LAST_UPDATE_DATE        = sysdate,
                 LAST_UPDATE_LOGIN       = -1
          WHERE  coverage_bus_process_id = COVERAGE_BUSS_PROCESS_ID_tbl(i);

Line: 3360


SELECT
 obt.COV_BP_BILLING_TYPE_ID         ,
 obt.UPTO_AMOUNT                    ,
 obt.PERCENT_COVER                  ,
 obt.BILLING_TYPE_ID                ,
 obt.COVERAGE_BUS_PROCESS_ID        ,
 obt.ATTRIBUTE_CATEGORY             ,
 obt.ATTRIBUTE1                     ,
 obt.ATTRIBUTE2                     ,
 obt.ATTRIBUTE3                     ,
 obt.ATTRIBUTE4                     ,
 obt.ATTRIBUTE5                     ,
 obt.ATTRIBUTE6                     ,
 obt.ATTRIBUTE7                     ,
 obt.ATTRIBUTE8                     ,
 obt.ATTRIBUTE9                     ,
 obt.ATTRIBUTE10                    ,
 obt.ATTRIBUTE11                    ,
 obt.ATTRIBUTE12                    ,
 obt.ATTRIBUTE13                    ,
 obt.ATTRIBUTE14                    ,
 obt.ATTRIBUTE15                    ,
 okl.id                             ,
 okl.dnz_chr_id                     ,
 okl.sts_code                       ,
 okl.start_date                     ,
 okl.end_date                       ,
 okl.currency_code
FROM
    oks_cov_bill_types_int_all obt ,
    oks_cov_txn_groups_int_all obp,
    okc_k_lines_b okl,
    oks_coverages_int_all cov,
    oks_con_lines_int_all lines,
    oks_con_headers_int_all head

WHERE
    obt.COVERAGE_BUS_PROCESS_ID  =  obp.COVERAGE_BUS_PROCESS_ID
 AND okl.upg_Orig_System_Ref= g_bpline_ref --'Int_Buss_Process_Line'
 AND okl.upg_Orig_System_Ref_id = obp.coverage_bus_process_id
 AND okl.lse_id = 3
 AND obt.coverage_id = obp.coverage_id
 AND obt.interfaced_status_flag is null
 AND cov.interfaced_status_flag = 'S'
 AND lines.interfaced_status_flag = 'S'
 AND head.interfaced_status_flag = 'S'
 AND obp.coverage_id = cov.coverage_id
 AND cov.coverage_id = lines.coverage_id
 AND lines.contract_id = head.contract_id
 AND head.batch_number between p_FromId and P_ToId;

Line: 3501


                    l_clev_tbl_in(i).LAST_UPDATE_DATE := sysdate;

Line: 3502


                    l_clev_tbl_in(i).LAST_UPDATED_BY := -1;

Line: 3503


                    l_clev_tbl_in(i).LAST_UPDATE_LOGIN := -1;

Line: 3545


    l_clev_tbl_in(i).LAST_UPDATE_LOGIN                        :=Null;

Line: 3575


     l_cimv_tbl_in(i).LAST_UPDATE_DATE := sysdate;

Line: 3576


     l_cimv_tbl_in(i).LAST_UPDATED_BY := -1 ;

Line: 3577


     l_cimv_tbl_in(i).LAST_UPDATE_LOGIN := -1 ;

Line: 3595


        l_rgpv_tbl_in(i).LAST_UPDATE_DATE := sysdate;

Line: 3596


        l_rgpv_tbl_in(i).LAST_UPDATED_BY := -1 ;

Line: 3597


        l_rgpv_tbl_in(i).LAST_UPDATE_LOGIN := -1 ;

Line: 3636


   l_rulv_tbl_in(i).LAST_UPDATE_DATE := sysdate;

Line: 3637


   l_rulv_tbl_in(i).LAST_UPDATED_BY := -1;

Line: 3638


   l_rulv_tbl_in(i).LAST_UPDATE_LOGIN := -1;

Line: 3690


         okc_cle_pvt.Insert_Row(
                                p_api_version   =>  l_api_version,
                                p_init_msg_list =>    l_init_msg_list,
                                x_return_status =>    l_return_status ,
                                x_msg_count     =>    l_msg_count,
                                x_msg_data      =>    l_msg_data,
                                p_clev_tbl      =>    l_clev_tbl_in,
                                x_clev_tbl      =>    x_clev_tbl_in);

Line: 3702


        okc_rgp_pvt.Insert_Row(
                                p_api_version   =>  l_api_version,
                                p_init_msg_list =>    l_init_msg_list,
                                x_return_status =>    l_return_status ,
                                x_msg_count     =>    l_msg_count,
                                x_msg_data      =>    l_msg_data,
                                p_rgpv_tbl      =>    l_rgpv_tbl_in,
                                x_rgpv_tbl      =>    x_rgpv_tbl_in);

Line: 3715


           okc_rul_pvt.Insert_Row(
                                p_api_version   =>  l_api_version,
                                p_init_msg_list =>    l_init_msg_list,
                                x_return_status =>    l_return_status ,
                                x_msg_count     =>    l_msg_count,
                                x_msg_data      =>    l_msg_data,
                                p_rulv_tbl      =>    l_rulv_tbl_in,
                                x_rulv_tbl      =>    x_rulv_tbl_in);

Line: 3728


         okc_cim_pvt.Insert_Row(
                                p_api_version   =>  l_api_version,
                                p_init_msg_list =>    l_init_msg_list,
                                x_return_status =>    l_return_status ,
                                x_msg_count     =>    l_msg_count,
                                x_msg_data      =>    l_msg_data,
                                p_cimv_tbl      =>    l_cimv_tbl_in,
                                x_cimv_tbl      =>    x_cimv_tbl_in);

Line: 3745


	okc_cle_pvt.Insert_Row_Upg( l_return_status , l_clev_tbl_in);

Line: 3750


	okc_rgp_pvt.Insert_Row_Upg( l_return_status , l_rgpv_tbl_in);

Line: 3756


	okc_rul_pvt.Insert_Row_Upg( l_return_status , l_rulv_tbl_in);

Line: 3762


	okc_cim_pvt.Insert_Row_Upg( l_return_status , l_cimv_tbl_in);

Line: 3766


                l_Cimv_tbl_in.DELETE;

Line: 3767


                  l_rgpv_tbl_in.DELETE;

Line: 3768


                 l_rulv_tbl_in.DELETE;

Line: 3769


                 l_Clev_tbl_in.DELETE;

Line: 3774


          UPDATE oks_cov_bill_types_int_all
          SET    INTERFACED_STATUS_FLAG  = 'S',
                 LAST_UPDATED_BY         = -1,
                 LAST_UPDATE_DATE        = sysdate,
                 LAST_UPDATE_LOGIN       = -1
          WHERE  COV_BP_BILLING_TYPE_ID = COV_BP_BILLING_TYPE_ID_tbl(i);

Line: 3807


select
	obr.COVERAGE_BILL_RATE_ID,
obr.COVERAGE_BILLING_TYPE_ID,
obr.BILL_RATE_CODE,
obr.UNIT_OF_MEASURE_CODE,
obr.FLAT_RATE,
obr.PERCENT_RATE,
obr.ATTRIBUTE_CATEGORY,
obr.ATTRIBUTE1,
obr.ATTRIBUTE2,
obr.ATTRIBUTE3,
obr.ATTRIBUTE4,
obr.ATTRIBUTE5,
obr.ATTRIBUTE6,
obr.ATTRIBUTE7,
obr.ATTRIBUTE8,
obr.ATTRIBUTE9,
obr.ATTRIBUTE10,
obr.ATTRIBUTE11,
obr.ATTRIBUTE12,
obr.ATTRIBUTE13,
obr.ATTRIBUTE14,
obr.ATTRIBUTE15,
okl.id,
okl.sts_code,
okl.start_date,
okl.end_date,
okl.dnz_chr_id,
okl.currency_code
FROM    oks_cov_bill_rates_int_all obr ,
        oks_cov_bill_types_int_all obt,
        okc_k_lines_b okl,
        oks_cov_txn_groups_int_all obp,
        oks_coverages_int_all cov,
        oks_con_lines_int_all lines,
        oks_con_headers_int_all head
WHERE   obr.COVERAGE_BILLING_TYPE_ID = obt.COV_BP_BILLING_TYPE_ID
AND     okl.upg_Orig_System_Ref= g_btline_ref
AND     okl.upg_Orig_System_Ref_Id = obt.COV_BP_BILLING_TYPE_ID
AND     okl.lse_id = 5
AND     obr.interfaced_status_flag is null
AND     obt.interfaced_status_flag = 'S'
AND     head.interfaced_status_flag = 'S'
AND     lines.interfaced_status_flag = 'S'
AND     cov.interfaced_status_flag = 'S'
AND     obp.interfaced_status_flag = 'S'
AND     obt.interfaced_status_flag = 'S'
AND     head.batch_number between p_fromid and p_toid
AND     head.contract_id = lines.contract_id
AND     lines.coverage_id = cov.coverage_id
AND     cov.coverage_id = obp.coverage_id
AND     obp.COVERAGE_BUS_PROCESS_ID = obt.COVERAGE_BUS_PROCESS_ID
AND     obp.coverage_id = obt.coverage_id;

Line: 3963


    l_clev_tbl_in(i).LAST_UPDATE_DATE := sysdate;

Line: 3964


    l_clev_tbl_in(i).LAST_UPDATED_BY 	:= -1 ;

Line: 3965


    l_clev_tbl_in(i).LAST_UPDATE_LOGIN := -1 ;

Line: 4026


    l_rgpv_tbl_in(i).LAST_UPDATE_DATE   := sysdate;

Line: 4027


    l_rgpv_tbl_in(i).LAST_UPDATED_BY    := -1;

Line: 4028


    l_rgpv_tbl_in(i).LAST_UPDATE_LOGIN  := -1;

Line: 4072


   l_rulv_tbl_in(i).LAST_UPDATE_DATE  := sysdate;

Line: 4073


   l_rulv_tbl_in(i).LAST_UPDATED_BY    := -1;

Line: 4074


   l_rulv_tbl_in(i).LAST_UPDATE_LOGIN:= -1;

Line: 4118


         okc_cle_pvt.Insert_Row(
                                p_api_version   =>  l_api_version,
                                p_init_msg_list =>    l_init_msg_list,
                                x_return_status =>    l_return_status ,
                                x_msg_count     =>    l_msg_count,
                                x_msg_data      =>    l_msg_data,
                                p_clev_tbl      =>    l_clev_tbl_in,
                                x_clev_tbl      =>    x_clev_tbl_in);

Line: 4130


        okc_rgp_pvt.Insert_Row(
                                p_api_version   =>  l_api_version,
                                p_init_msg_list =>    l_init_msg_list,
                                x_return_status =>    l_return_status ,
                                x_msg_count     =>    l_msg_count,
                                x_msg_data      =>    l_msg_data,
                                p_rgpv_tbl      =>    l_rgpv_tbl_in,
                                x_rgpv_tbl      =>    x_rgpv_tbl_in);

Line: 4142


        okc_rul_pvt.Insert_Row(
                                p_api_version   =>  l_api_version,
                                p_init_msg_list =>    l_init_msg_list,
                                x_return_status =>    l_return_status ,
                                x_msg_count     =>    l_msg_count,
                                x_msg_data      =>    l_msg_data,
                                p_rulv_tbl      =>    l_rulv_tbl_in,
                                x_rulv_tbl      =>    x_rulv_tbl_in);

Line: 4160


				okc_cle_pvt.Insert_Row_Upg( l_return_status , l_clev_tbl_in);

Line: 4162


				l_Clev_tbl_in.DELETE;

Line: 4167


				okc_rgp_pvt.Insert_Row_Upg( l_return_status , l_rgpv_tbl_in);

Line: 4169


				l_rgpv_tbl_in.DELETE;

Line: 4174


				okc_rul_pvt.Insert_Row_Upg( l_return_status , l_rulv_tbl_in);

Line: 4176


				l_rulv_tbl_in.delete;

Line: 4181


          UPDATE oks_cov_bill_rates_int_all
          SET    INTERFACED_STATUS_FLAG  = 'S',
                 LAST_UPDATED_BY         = -1,
                 LAST_UPDATE_DATE        = sysdate,
                 LAST_UPDATE_LOGIN       = -1
          WHERE  COVERAGE_BILL_RATE_ID = COVERAGE_BILL_RATE_ID_tbl(i);

Line: 4211


IS    SELECT contract_number,
           contract_id,
           interfaced_status_flag,
           batch_number
    FROM  OKS_CON_HEADERS_INT_ALL
    WHERE BATCH_NUMBER between p_from_id and p_to_id;

Line: 4219


IS     SELECT Contract_Id,
              Contract_line_id,
              Coverage_Id,
              Interfaced_status_flag
        FROM  OKS_CON_LINES_INT_ALL lines
        WHERE lines.contract_id = p_id;

Line: 4227


IS      SELECT Coverage_id,
               NAME,
               Interfaced_status_flag
        FROM   OKS_COVERAGES_INT_ALL cov
        WHERE  cov.coverage_id = p_id;

Line: 4234


IS      SELECT  Coverage_Bus_process_id,
                Business_process_id,
                Interfaced_Status_flag
        FROM    oks_cov_txn_groups_int_all txn
        WHERE   txn.coverage_id = p_id;

Line: 4241


IS      SELECT  Interfaced_Status_flag,
                COV_BP_BILLING_TYPE_ID,
                Upto_amount,
                Percent_Cover
        FROM    oks_cov_bill_types_int_all
        WHERE   coverage_bus_process_id = p_id;

Line: 4249


IS      SELECT  Interfaced_Status_flag,
                COVERAGE_BILL_RATE_ID
        FROM    oks_cov_bill_rates_int_all
        WHERE   COVERAGE_BILLING_TYPE_ID = p_id;