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.CS_AUDIT_UPGRADE_CON_PRG SQL Statements

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

Line: 34


   p_update_date IN VARCHAR2
  ) IS

-- Variables Declared for the API

   l_loop_counter    NUMBER;

Line: 43


SELECT
  INCIDENT_ID        ,
  INCIDENT_NUMBER   ,
  LAST_UPDATE_DATE   ,
  LAST_UPDATED_BY   ,
  CREATION_DATE   ,
  CREATED_BY     ,
  CREATION_TIME   ,
  LAST_UPDATE_LOGIN ,
  INCIDENT_STATUS_ID  ,
  to_number(NULL) OLD_INCIDENT_STATUS_ID ,
  'N' CHANGE_INCIDENT_STATUS_FLAG ,
  INCIDENT_TYPE_ID           ,
  to_number(NULL) OLD_INCIDENT_TYPE_ID      ,
  'N' CHANGE_INCIDENT_TYPE_FLAG ,
  INCIDENT_URGENCY_ID      ,
  to_number(NULL) OLD_INCIDENT_URGENCY_ID ,
  'N' CHANGE_INCIDENT_URGENCY_FLAG ,
  INCIDENT_SEVERITY_ID        ,
  to_number(NULL) OLD_INCIDENT_SEVERITY_ID   ,
  'N' CHANGE_INCIDENT_SEVERITY_FLAG,
  RESPONSIBLE_GROUP_ID        ,
  to_number(NULL) OLD_RESPONSIBLE_GROUP_ID   ,
  'N' CHANGE_RESPONSIBLE_GROUP_FLAG ,
  INCIDENT_OWNER_ID            ,
  to_number(NULL) OLD_INCIDENT_OWNER_ID       ,
  'N' CHANGE_INCIDENT_OWNER_FLAG ,
  EXPECTED_RESOLUTION_DATE,
  TO_DATE(NULL) OLD_EXPECTED_RESOLUTION_DATE  ,
  'N' CHANGE_RESOLUTION_FLAG       ,
  OWNER_GROUP_ID GROUP_ID         ,
  to_number(NULL) OLD_GROUP_ID        ,
  'N' CHANGE_GROUP_FLAG  ,
  OBLIGATION_DATE   ,
  TO_DATE(NULL) OLD_OBLIGATION_DATE ,
  'N' CHANGE_OBLIGATION_FLAG    ,
  SITE_ID                  ,
  to_number(NULL) OLD_SITE_ID             ,
  'N' CHANGE_SITE_FLAG       ,
  BILL_TO_CONTACT_ID    ,
  to_number(NULL) OLD_BILL_TO_CONTACT_ID  ,
  'N' CHANGE_BILL_TO_FLAG    ,
  SHIP_TO_CONTACT_ID    ,
  to_number(NULL) OLD_SHIP_TO_CONTACT_ID ,
  'N' CHANGE_SHIP_TO_FLAG   ,
  INCIDENT_DATE        ,
  TO_DATE(NULL) OLD_INCIDENT_DATE   ,
  'N' CHANGE_INCIDENT_DATE_FLAG  ,
  CLOSE_DATE                ,
  to_date(NULL) OLD_CLOSE_DATE           ,
  'N' CHANGE_CLOSE_DATE_FLAG  ,
  CUSTOMER_PRODUCT_ID    ,
  to_number(NULL) OLD_CUSTOMER_PRODUCT_ID ,
  'N' CHANGE_CUSTOMER_PRODUCT_FLAG        ,
  PLATFORM_ID                      ,
  to_number(NULL) OLD_PLATFORM_ID                 ,
  'N' CHANGE_PLATFORM_ID_FLAG        ,
  PLATFORM_VERSION_ID           ,
  to_number(NULL) OLD_PLATFORM_VERSION_ID      ,
  'N' CHANGE_PLAT_VER_ID_FLAG     ,
  CP_COMPONENT_ID            ,
  to_number(NULL) OLD_CP_COMPONENT_ID       ,
  'N' CHANGE_CP_COMPONENT_ID_FLAG ,
  CP_COMPONENT_VERSION_ID    ,
  to_number(NULL) OLD_CP_COMPONENT_VERSION_ID,
  'N' CHANGE_CP_COMP_VER_ID_FLAG ,
  CP_SUBCOMPONENT_ID         ,
  to_number(NULL) OLD_CP_SUBCOMPONENT_ID    ,
  'N' CHANGE_CP_SUBCOMPONENT_ID_FLAG ,
  CP_SUBCOMPONENT_VERSION_ID    ,
  to_number(NULL) OLD_CP_SUBCOMPONENT_VERSION_ID ,
  'N' CHANGE_CP_SUBCOMP_VER_ID_FLAG ,
  LANGUAGE_ID                  ,
  to_number(NULL) OLD_LANGUAGE_ID             ,
  'N' CHANGE_LANGUAGE_ID_FLAG   ,
  TERRITORY_ID             ,
  to_number(NULL) OLD_TERRITORY_ID          ,
  'N' CHANGE_TERRITORY_ID_FLAG ,
  CP_REVISION_ID          ,
  to_number(NULL) OLD_CP_REVISION_ID     ,
  'N' CHANGE_CP_REVISION_ID_FLAG ,
  INV_ITEM_REVISION         ,
  to_char(NULL) OLD_INV_ITEM_REVISION    ,
  'N' CHANGE_INV_ITEM_REVISION,
  INV_COMPONENT_ID       ,
  to_number(NULL) OLD_INV_COMPONENT_ID  ,
  'N' CHANGE_INV_COMPONENT_ID   ,
  INV_COMPONENT_VERSION    ,
  to_char(NULL) OLD_INV_COMPONENT_VERSION  ,
  'N' CHANGE_INV_COMPONENT_VERSION  ,
  INV_SUBCOMPONENT_ID          ,
  to_number(NULL) OLD_INV_SUBCOMPONENT_ID     ,
  'N' CHANGE_INV_SUBCOMPONENT_ID ,
  INV_SUBCOMPONENT_VERSION  ,
  to_char(NULL) OLD_INV_SUBCOMPONENT_VERSION  ,
  'N' CHANGE_INV_SUBCOMP_VERSION   ,
  RESOURCE_TYPE               ,
  to_char(NULL) OLD_RESOURCE_TYPE          ,
  'N'  CHANGE_RESOURCE_TYPE_FLAG ,
  to_char(NULL) OLD_GROUP_TYPE              ,
  GROUP_TYPE                 ,
  'N' CHANGE_GROUP_TYPE_FLAG    ,
  to_date(NULL) OLD_OWNER_ASSIGNED_TIME  ,
  OWNER_ASSIGNED_TIME        ,
  'N' CHANGE_ASSIGNED_TIME_FLAG          ,
  INV_PLATFORM_ORG_ID               ,
  to_number(NULL) OLD_INV_PLATFORM_ORG_ID          ,
  'N' CHANGE_PLATFORM_ORG_ID_FLAG     ,
  COMPONENT_VERSION              ,
  to_char(NULL) OLD_COMPONENT_VERSION         ,
  'N' CHANGE_COMP_VER_FLAG         ,
  SUBCOMPONENT_VERSION        ,
  to_char(NULL) OLD_SUBCOMPONENT_VERSION   ,
  'N' CHANGE_SUBCOMP_VER_FLAG   ,
  PRODUCT_REVISION                   ,
  to_char(NULL) OLD_PRODUCT_REVISION              ,
  'N' CHANGE_PRODUCT_REVISION_FLAG     ,
  INVENTORY_ITEM_ID               ,
  to_number(NULL) OLD_INVENTORY_ITEM_ID          ,
  'N' CHANGE_INVENTORY_ITEM_FLAG    ,
  INV_ORGANIZATION_ID          ,
  to_number(NULL) OLD_INV_ORGANIZATION_ID     ,
  'N' CHANGE_INV_ORGANIZATION_FLAG   ,
  STATUS_FLAG                   ,
  to_char(NULL) OLD_STATUS_FLAG              ,
  'N' CHANGE_STATUS_FLAG          ,
  PRIMARY_CONTACT_ID         ,
  'N' CHANGE_PRIMARY_CONTACT_FLAG  ,
  to_number(NULL) OLD_PRIMARY_CONTACT_ID     ,
  SECURITY_GROUP_ID
FROM CS_INCIDENTS_ALL_B
WHERE ROWID BETWEEN c_start_rowid AND c_end_rowid
AND   creation_date > p_audit_date;

Line: 178


SELECT
  INCIDENT_ID        ,
  INCIDENT_AUDIT_ID,
  LAST_UPDATE_DATE   ,
  LAST_UPDATED_BY   ,
  CREATION_DATE   ,
  CREATED_BY     ,
  LAST_UPDATE_LOGIN ,
  CREATION_TIME    ,
  INCIDENT_STATUS_ID  ,
  OLD_INCIDENT_STATUS_ID ,
  CHANGE_INCIDENT_STATUS_FLAG ,
  INCIDENT_TYPE_ID           ,
  OLD_INCIDENT_TYPE_ID      ,
  CHANGE_INCIDENT_TYPE_FLAG ,
  INCIDENT_URGENCY_ID      ,
  OLD_INCIDENT_URGENCY_ID ,
  CHANGE_INCIDENT_URGENCY_FLAG ,
  INCIDENT_SEVERITY_ID        ,
  OLD_INCIDENT_SEVERITY_ID   ,
  CHANGE_INCIDENT_SEVERITY_FLAG,
  RESPONSIBLE_GROUP_ID        ,
  OLD_RESPONSIBLE_GROUP_ID   ,
  CHANGE_RESPONSIBLE_GROUP_FLAG ,
  INCIDENT_OWNER_ID            ,
  OLD_INCIDENT_OWNER_ID       ,
  CHANGE_INCIDENT_OWNER_FLAG ,
  CREATE_MANUAL_ACTION      ,
  ACTION_ID                ,
  EXPECTED_RESOLUTION_DATE,
  OLD_EXPECTED_RESOLUTION_DATE  ,
  CHANGE_RESOLUTION_FLAG       ,
  GROUP_ID              ,
  OLD_GROUP_ID        ,
  CHANGE_GROUP_FLAG  ,
  OBLIGATION_DATE   ,
  OLD_OBLIGATION_DATE ,
  CHANGE_OBLIGATION_FLAG    ,
  SITE_ID                  ,
  OLD_SITE_ID             ,
  CHANGE_SITE_FLAG       ,
  BILL_TO_CONTACT_ID    ,
  OLD_BILL_TO_CONTACT_ID  ,
  CHANGE_BILL_TO_FLAG    ,
  SHIP_TO_CONTACT_ID    ,
  OLD_SHIP_TO_CONTACT_ID ,
  CHANGE_SHIP_TO_FLAG   ,
  INCIDENT_DATE        ,
  OLD_INCIDENT_DATE   ,
  CHANGE_INCIDENT_DATE_FLAG  ,
  CLOSE_DATE                ,
  OLD_CLOSE_DATE           ,
  CHANGE_CLOSE_DATE_FLAG  ,
  CUSTOMER_PRODUCT_ID    ,
  OLD_CUSTOMER_PRODUCT_ID ,
  CHANGE_CUSTOMER_PRODUCT_FLAG        ,
  AUDIT_FIELD                        ,
  OBJECT_VERSION_NUMBER             ,
  PLATFORM_ID                      ,
  OLD_PLATFORM_ID                 ,
  CHANGE_PLATFORM_ID_FLAG        ,
  PLATFORM_VERSION_ID           ,
  OLD_PLATFORM_VERSION_ID      ,
  CHANGE_PLAT_VER_ID_FLAG     ,
  CP_COMPONENT_ID            ,
  OLD_CP_COMPONENT_ID       ,
  CHANGE_CP_COMPONENT_ID_FLAG ,
  CP_COMPONENT_VERSION_ID    ,
  OLD_CP_COMPONENT_VERSION_ID,
  CHANGE_CP_COMP_VER_ID_FLAG ,
  CP_SUBCOMPONENT_ID         ,
  OLD_CP_SUBCOMPONENT_ID    ,
  CHANGE_CP_SUBCOMPONENT_ID_FLAG ,
  CP_SUBCOMPONENT_VERSION_ID    ,
  OLD_CP_SUBCOMPONENT_VERSION_ID ,
  CHANGE_CP_SUBCOMP_VER_ID_FLAG ,
  LANGUAGE_ID                  ,
  OLD_LANGUAGE_ID             ,
  CHANGE_LANGUAGE_ID_FLAG   ,
  TERRITORY_ID             ,
  OLD_TERRITORY_ID          ,
  CHANGE_TERRITORY_ID_FLAG ,
  CP_REVISION_ID          ,
  OLD_CP_REVISION_ID     ,
  CHANGE_CP_REVISION_ID_FLAG ,
  INV_ITEM_REVISION         ,
  OLD_INV_ITEM_REVISION    ,
  CHANGE_INV_ITEM_REVISION,
  INV_COMPONENT_ID       ,
  OLD_INV_COMPONENT_ID  ,
  CHANGE_INV_COMPONENT_ID   ,
  INV_COMPONENT_VERSION    ,
  OLD_INV_COMPONENT_VERSION  ,
  CHANGE_INV_COMPONENT_VERSION  ,
  INV_SUBCOMPONENT_ID          ,
  OLD_INV_SUBCOMPONENT_ID     ,
  CHANGE_INV_SUBCOMPONENT_ID ,
  INV_SUBCOMPONENT_VERSION  ,
  OLD_INV_SUBCOMPONENT_VERSION  ,
  CHANGE_INV_SUBCOMP_VERSION   ,
  RESOURCE_TYPE               ,
  OLD_RESOURCE_TYPE          ,
  CHANGE_RESOURCE_TYPE_FLAG ,
  OLD_GROUP_TYPE              ,
  GROUP_TYPE                 ,
  CHANGE_GROUP_TYPE_FLAG    ,
  OLD_OWNER_ASSIGNED_TIME  ,
  OWNER_ASSIGNED_TIME   ,
  CHANGE_ASSIGNED_TIME_FLAG          ,
  INV_PLATFORM_ORG_ID               ,
  OLD_INV_PLATFORM_ORG_ID          ,
  CHANGE_PLATFORM_ORG_ID_FLAG     ,
  COMPONENT_VERSION              ,
  OLD_COMPONENT_VERSION         ,
  CHANGE_COMP_VER_FLAG         ,
  SUBCOMPONENT_VERSION        ,
  OLD_SUBCOMPONENT_VERSION   ,
  CHANGE_SUBCOMP_VER_FLAG   ,
  PRODUCT_REVISION                   ,
  OLD_PRODUCT_REVISION              ,
  CHANGE_PRODUCT_REVISION_FLAG     ,
  INVENTORY_ITEM_ID               ,
  OLD_INVENTORY_ITEM_ID          ,
  CHANGE_INVENTORY_ITEM_FLAG    ,
  INV_ORGANIZATION_ID          ,
  OLD_INV_ORGANIZATION_ID     ,
  CHANGE_INV_ORGANIZATION_FLAG   ,
  STATUS_FLAG                   ,
  OLD_STATUS_FLAG              ,
  CHANGE_STATUS_FLAG          ,
  PRIMARY_CONTACT_ID         ,
  CHANGE_PRIMARY_CONTACT_FLAG  ,
  OLD_PRIMARY_CONTACT_ID      ,
  SECURITY_GROUP_ID
FROM cs_incidents_audit_b
WHERE INCIDENT_ID = c_incident_id
AND   NVL(UPGRADE_FLAG_FOR_CREATE,'N') = 'N'
AND   NVL(updated_entity_code, 'SR_HEADER') = 'SR_HEADER'
ORDER BY creation_date desc, incident_audit_id desc;

Line: 319


SELECT
  INCIDENT_ID        ,
  INCIDENT_AUDIT_ID           ,
  LAST_UPDATE_DATE   ,
  LAST_UPDATED_BY   ,
  CREATION_DATE   ,
  CREATED_BY     ,
  LAST_UPDATE_LOGIN ,
  CREATION_TIME    ,
  INCIDENT_STATUS_ID  ,
  OLD_INCIDENT_STATUS_ID ,
  CHANGE_INCIDENT_STATUS_FLAG ,
  INCIDENT_TYPE_ID           ,
  OLD_INCIDENT_TYPE_ID      ,
  CHANGE_INCIDENT_TYPE_FLAG ,
  INCIDENT_URGENCY_ID      ,
  OLD_INCIDENT_URGENCY_ID ,
  CHANGE_INCIDENT_URGENCY_FLAG ,
  INCIDENT_SEVERITY_ID        ,
  OLD_INCIDENT_SEVERITY_ID   ,
  CHANGE_INCIDENT_SEVERITY_FLAG,
  RESPONSIBLE_GROUP_ID        ,
  OLD_RESPONSIBLE_GROUP_ID   ,
  CHANGE_RESPONSIBLE_GROUP_FLAG ,
  INCIDENT_OWNER_ID            ,
  OLD_INCIDENT_OWNER_ID       ,
  CHANGE_INCIDENT_OWNER_FLAG ,
  CREATE_MANUAL_ACTION      ,
  ACTION_ID                ,
  EXPECTED_RESOLUTION_DATE,
  OLD_EXPECTED_RESOLUTION_DATE  ,
  CHANGE_RESOLUTION_FLAG       ,
  GROUP_ID              ,
  OLD_GROUP_ID        ,
  CHANGE_GROUP_FLAG  ,
  OBLIGATION_DATE   ,
  OLD_OBLIGATION_DATE ,
  CHANGE_OBLIGATION_FLAG    ,
  SITE_ID                  ,
  OLD_SITE_ID             ,
  CHANGE_SITE_FLAG       ,
  BILL_TO_CONTACT_ID    ,
  OLD_BILL_TO_CONTACT_ID  ,
  CHANGE_BILL_TO_FLAG    ,
  SHIP_TO_CONTACT_ID    ,
  OLD_SHIP_TO_CONTACT_ID ,
  CHANGE_SHIP_TO_FLAG   ,
  INCIDENT_DATE        ,
  OLD_INCIDENT_DATE   ,
  CHANGE_INCIDENT_DATE_FLAG  ,
  CLOSE_DATE                ,
  OLD_CLOSE_DATE           ,
  CHANGE_CLOSE_DATE_FLAG  ,
  CUSTOMER_PRODUCT_ID    ,
  OLD_CUSTOMER_PRODUCT_ID ,
  CHANGE_CUSTOMER_PRODUCT_FLAG        ,
  AUDIT_FIELD                        ,
  OBJECT_VERSION_NUMBER             ,
  PLATFORM_ID                      ,
  OLD_PLATFORM_ID                 ,
  CHANGE_PLATFORM_ID_FLAG        ,
  PLATFORM_VERSION_ID           ,
  OLD_PLATFORM_VERSION_ID      ,
  CHANGE_PLAT_VER_ID_FLAG     ,
  CP_COMPONENT_ID            ,
  OLD_CP_COMPONENT_ID       ,
  CHANGE_CP_COMPONENT_ID_FLAG ,
  CP_COMPONENT_VERSION_ID    ,
  OLD_CP_COMPONENT_VERSION_ID,
  CHANGE_CP_COMP_VER_ID_FLAG ,
  CP_SUBCOMPONENT_ID         ,
  OLD_CP_SUBCOMPONENT_ID    ,
  CHANGE_CP_SUBCOMPONENT_ID_FLAG ,
  CP_SUBCOMPONENT_VERSION_ID    ,
  OLD_CP_SUBCOMPONENT_VERSION_ID ,
  CHANGE_CP_SUBCOMP_VER_ID_FLAG ,
  LANGUAGE_ID                  ,
  OLD_LANGUAGE_ID             ,
  CHANGE_LANGUAGE_ID_FLAG   ,
  TERRITORY_ID             ,
  OLD_TERRITORY_ID          ,
  CHANGE_TERRITORY_ID_FLAG ,
  CP_REVISION_ID          ,
  OLD_CP_REVISION_ID     ,
  CHANGE_CP_REVISION_ID_FLAG ,
  INV_ITEM_REVISION         ,
  OLD_INV_ITEM_REVISION    ,
  CHANGE_INV_ITEM_REVISION,
  INV_COMPONENT_ID       ,
  OLD_INV_COMPONENT_ID  ,
  CHANGE_INV_COMPONENT_ID   ,
  INV_COMPONENT_VERSION    ,
  OLD_INV_COMPONENT_VERSION  ,
  CHANGE_INV_COMPONENT_VERSION  ,
  INV_SUBCOMPONENT_ID          ,
  OLD_INV_SUBCOMPONENT_ID     ,
  CHANGE_INV_SUBCOMPONENT_ID ,
  INV_SUBCOMPONENT_VERSION  ,
  OLD_INV_SUBCOMPONENT_VERSION  ,
  CHANGE_INV_SUBCOMP_VERSION   ,
  RESOURCE_TYPE               ,
  OLD_RESOURCE_TYPE          ,
  CHANGE_RESOURCE_TYPE_FLAG ,
  OLD_GROUP_TYPE              ,
  GROUP_TYPE                 ,
  CHANGE_GROUP_TYPE_FLAG    ,
  OLD_OWNER_ASSIGNED_TIME  ,
  OWNER_ASSIGNED_TIME   ,
  CHANGE_ASSIGNED_TIME_FLAG          ,
  INV_PLATFORM_ORG_ID               ,
  OLD_INV_PLATFORM_ORG_ID          ,
  CHANGE_PLATFORM_ORG_ID_FLAG     ,
  COMPONENT_VERSION              ,
  OLD_COMPONENT_VERSION         ,
  CHANGE_COMP_VER_FLAG         ,
  SUBCOMPONENT_VERSION        ,
  OLD_SUBCOMPONENT_VERSION   ,
  CHANGE_SUBCOMP_VER_FLAG   ,
  PRODUCT_REVISION                   ,
  OLD_PRODUCT_REVISION              ,
  CHANGE_PRODUCT_REVISION_FLAG     ,
  INVENTORY_ITEM_ID               ,
  OLD_INVENTORY_ITEM_ID          ,
  CHANGE_INVENTORY_ITEM_FLAG    ,
  INV_ORGANIZATION_ID          ,
  OLD_INV_ORGANIZATION_ID     ,
  CHANGE_INV_ORGANIZATION_FLAG   ,
  STATUS_FLAG                   ,
  OLD_STATUS_FLAG              ,
  CHANGE_STATUS_FLAG          ,
  PRIMARY_CONTACT_ID         ,
  CHANGE_PRIMARY_CONTACT_FLAG  ,
  OLD_PRIMARY_CONTACT_ID      ,
  SECURITY_GROUP_ID
FROM cs_incidents_audit_b
WHERE INCIDENT_ID = c_incident_id
AND   NVL(UPGRADE_FLAG_FOR_CREATE,'N') = 'N'
AND   NVL(updated_entity_code,'SR_HEADER') = 'SR_HEADER'
ORDER BY creation_date, incident_audit_id asc;

Line: 460


SELECT close_flag
FROM   cs_incident_statuses_b
WHERE  incident_status_id = p_incident_status_id;

Line: 475


l_sta_update number :=0;

Line: 476


l_sev_update number :=0;

Line: 477


l_urg_update number :=0;

Line: 478


l_typ_update number :=0;

Line: 479


l_rgp_update number :=0;

Line: 480


l_own_update number :=0;

Line: 481


l_res_update number :=0;

Line: 482


l_grp_update number :=0;

Line: 483


l_obl_update number :=0;

Line: 484


l_sit_update number :=0;

Line: 485


l_bto_update number :=0;

Line: 486


l_sto_update number :=0;

Line: 487


l_idt_update number :=0;

Line: 488


l_cdt_update number :=0;

Line: 489


l_cpd_update number :=0;

Line: 490


l_pid_update number :=0;

Line: 491


l_pvf_update number :=0;

Line: 492


l_cci_update number :=0;

Line: 493


l_cvi_update number :=0;

Line: 494


l_sci_update number :=0;

Line: 495


l_svi_update number :=0;

Line: 496


l_lan_update number :=0;

Line: 497


l_ter_update number :=0;

Line: 498


l_cpr_update number :=0;

Line: 499


l_iiv_update number :=0;

Line: 500


l_ici_update number :=0;

Line: 501


l_icv_update number :=0;

Line: 502


l_isc_update number :=0;

Line: 503


l_isv_update number :=0;

Line: 504


l_rrp_update number :=0;

Line: 505


l_gpt_update number :=0;

Line: 506


l_oat_update number :=0;

Line: 507


l_por_update number :=0;

Line: 508


l_cov_update number :=0;

Line: 509


l_scv_update number :=0;

Line: 510


l_prv_update number :=0;

Line: 511


l_inv_update number :=0;

Line: 512


l_ino_update number :=0;

Line: 513


l_sfl_update number :=0;

Line: 514


l_pci_update number :=0;

Line: 561


l_update_name          VARCHAR2(30) := 'csxaucpb.pls'; -- l_update_name will be appended with sysdate, do not make this longer than 18 characters

Line: 587


  ad_parallel_updates_pkg.initialize_rowid_range(
           ad_parallel_updates_pkg.ROWID_RANGE,
           l_table_owner,
           l_table_name,
           l_update_name || p_update_date,  -- to ensure it is rerunnable
           x_worker_id,
           x_num_workers,
           x_batch_size, 0);

Line: 596


  ad_parallel_updates_pkg.get_rowid_range(
           l_start_rowid,
           l_end_rowid,
           l_any_rows_to_process,
           x_batch_size,
           TRUE);

Line: 611


   l_sta_update :=0;

Line: 612


   l_sev_update :=0;

Line: 613


   l_urg_update :=0;

Line: 614


   l_typ_update :=0;

Line: 615


   l_rgp_update :=0;

Line: 616


   l_own_update :=0;

Line: 617


   l_res_update :=0;

Line: 618


   l_grp_update :=0;

Line: 619


   l_obl_update :=0;

Line: 620


   l_sit_update :=0;

Line: 621


   l_bto_update :=0;

Line: 622


   l_sto_update :=0;

Line: 623


   l_idt_update :=0;

Line: 624


   l_cdt_update :=0;

Line: 625


   l_cpd_update :=0;

Line: 626


   l_pid_update :=0;

Line: 627


   l_pvf_update :=0;

Line: 628


   l_cci_update :=0;

Line: 629


   l_cvi_update :=0;

Line: 630


   l_sci_update :=0;

Line: 631


   l_svi_update :=0;

Line: 632


   l_lan_update :=0;

Line: 633


   l_ter_update :=0;

Line: 634


   l_cpr_update :=0;

Line: 635


   l_iiv_update :=0;

Line: 636


   l_ici_update :=0;

Line: 637


   l_icv_update :=0;

Line: 638


   l_isc_update :=0;

Line: 639


   l_isv_update :=0;

Line: 640


   l_rrp_update :=0;

Line: 641


   l_gpt_update :=0;

Line: 642


   l_oat_update :=0;

Line: 643


   l_por_update :=0;

Line: 644


   l_cov_update :=0;

Line: 645


   l_scv_update :=0;

Line: 646


   l_prv_update :=0;

Line: 647


   l_inv_update :=0;

Line: 648


   l_ino_update :=0;

Line: 649


   l_sfl_update :=0;

Line: 650


   l_pci_update :=0;

Line: 685


   select count(incident_audit_id) into l_audit_count
   from cs_incidents_audit_b
   where incident_id= l_request_id
   and NVL(upgrade_flag_for_create,'N') = 'N'
   and NVL(updated_entity_code, 'SR_HEADER') = 'SR_HEADER';

Line: 704


          l_sta_update := 1;

Line: 707


        if l_sta_update >0 then
          if l_create_audit_rec.old_INCIDENT_STATUS_ID is not null then
            l_create_audit_rec.INCIDENT_STATUS_ID := l_create_audit_rec.old_INCIDENT_STATUS_ID ;

Line: 712


          l_sta_update := 0;

Line: 722


          l_typ_update := 1;

Line: 725


        if l_typ_update >0 then
          if (l_create_audit_rec.OLD_INCIDENT_TYPE_ID is not null) then
            l_create_audit_rec.INCIDENT_TYPE_ID := l_create_audit_rec.OLD_INCIDENT_TYPE_ID ;

Line: 730


          l_typ_update := 0;

Line: 740


        l_urg_update := 1;

Line: 743


        if l_urg_update >0 then
          l_create_audit_rec.INCIDENT_URGENCY_ID := l_create_audit_rec.OLD_INCIDENT_URGENCY_ID ;

Line: 746


          l_urg_update := 0;

Line: 756


          l_sev_update := 1;

Line: 759


        if l_sev_update >0 then
          if (l_create_audit_rec.OLD_INCIDENT_SEVERITY_ID is not null) then
            l_create_audit_rec.INCIDENT_SEVERITY_ID := l_create_audit_rec.OLD_INCIDENT_SEVERITY_ID ;

Line: 764


          l_sev_update := 0;

Line: 774


        l_rgp_update := 1;

Line: 777


        if l_rgp_update >0 then
          l_create_audit_rec.RESPONSIBLE_GROUP_ID := l_create_audit_rec.OLD_RESPONSIBLE_GROUP_ID ;

Line: 780


          l_rgp_update := 0;

Line: 796


        l_oat_update := 1;

Line: 797


        l_own_update := 1;

Line: 802


          l_rrp_update := 1;

Line: 805


          if l_rrp_update >0 then
            l_create_audit_rec.RESOURCE_TYPE := l_create_audit_rec.OLD_RESOURCE_TYPE ;

Line: 808


            l_rrp_update := 0;

Line: 816


        if l_own_update >0 then
          l_create_audit_rec.INCIDENT_OWNER_ID := l_create_audit_rec.OLD_INCIDENT_OWNER_ID ;

Line: 819


          l_own_update := 0;

Line: 823


        if l_oat_update >0 then
	        l_create_audit_rec.OWNER_ASSIGNED_TIME := l_create_audit_rec.OLD_OWNER_ASSIGNED_TIME ;

Line: 826


	        l_oat_update := 0;

Line: 836


          if l_rrp_update >0 then
            l_create_audit_rec.RESOURCE_TYPE := l_create_audit_rec.OLD_RESOURCE_TYPE ;

Line: 839


            l_rrp_update := 0;

Line: 850


        l_res_update := 1;

Line: 853


        if l_res_update >0 then
          l_create_audit_rec.EXPECTED_RESOLUTION_DATE := l_create_audit_rec.OLD_EXPECTED_RESOLUTION_DATE ;

Line: 856


          l_res_update := 0;

Line: 866


        l_grp_update := 1;

Line: 871


          l_gpt_update := 1;

Line: 875


        if l_grp_update >0 then
          l_create_audit_rec.GROUP_ID := l_create_audit_rec.OLD_GROUP_ID ;

Line: 878


          l_grp_update := 0;

Line: 884


          if l_gpt_update >0 then
            l_create_audit_rec.GROUP_TYPE := l_create_audit_rec.OLD_GROUP_TYPE ;

Line: 887


            l_gpt_update := 0;

Line: 898


        l_obl_update := 1;

Line: 901


        if l_obl_update >0 then
          l_create_audit_rec.OBLIGATION_DATE := l_create_audit_rec.OLD_OBLIGATION_DATE ;

Line: 904


          l_obl_update := 0;

Line: 914


        l_sit_update := 1;

Line: 917


        if l_sit_update >0 then
          l_create_audit_rec.SITE_ID := l_create_audit_rec.OLD_SITE_ID ;

Line: 920


          l_sit_update := 0;

Line: 930


        l_bto_update := 1;

Line: 933


        if l_bto_update >0 then
          l_create_audit_rec.BILL_TO_CONTACT_ID := l_create_audit_rec.OLD_BILL_TO_CONTACT_ID ;

Line: 936


          l_bto_update := 0;

Line: 946


        l_sto_update := 1;

Line: 949


        if l_sto_update >0 then
          l_create_audit_rec.SHIP_TO_CONTACT_ID := l_create_audit_rec.OLD_SHIP_TO_CONTACT_ID ;

Line: 952


          l_sto_update := 0;

Line: 962


        l_idt_update := 1;

Line: 965


        if l_idt_update >0 then
          l_create_audit_rec.INCIDENT_DATE := l_create_audit_rec.OLD_INCIDENT_DATE ;

Line: 968


          l_idt_update := 0;

Line: 978


        l_cpd_update := 1;

Line: 981


        if l_cpd_update >0 then
          l_create_audit_rec.CUSTOMER_PRODUCT_ID := l_create_audit_rec.OLD_CUSTOMER_PRODUCT_ID ;

Line: 984


          l_cpd_update := 0;

Line: 994


        l_pid_update := 1;

Line: 997


        if l_pid_update >0 then
          l_create_audit_rec.PLATFORM_ID := l_create_audit_rec.OLD_PLATFORM_ID ;

Line: 1000


          l_pid_update := 0;

Line: 1010


        l_pvf_update := 1;

Line: 1013


        if l_pvf_update >0 then
          l_create_audit_rec.PLATFORM_VERSION_ID := l_create_audit_rec.OLD_PLATFORM_VERSION_ID ;

Line: 1016


          l_pvf_update := 0;

Line: 1026


        l_cci_update := 1;

Line: 1029


        if l_cci_update >0 then
          l_create_audit_rec.CP_COMPONENT_ID := l_create_audit_rec.OLD_CP_COMPONENT_ID ;

Line: 1032


          l_cci_update := 0;

Line: 1042


        l_cvi_update := 1;

Line: 1045


        if l_cvi_update >0 then
          l_create_audit_rec.CP_COMPONENT_VERSION_ID := l_create_audit_rec.OLD_CP_COMPONENT_VERSION_ID ;

Line: 1048


          l_cvi_update := 0;

Line: 1058


        l_sci_update := 1;

Line: 1061


        if l_sci_update >0 then
          l_create_audit_rec.CP_SUBCOMPONENT_ID := l_create_audit_rec.OLD_CP_SUBCOMPONENT_ID ;

Line: 1064


          l_sci_update := 0;

Line: 1074


        l_svi_update := 1;

Line: 1077


        if l_svi_update >0 then
          l_create_audit_rec.CP_SUBCOMPONENT_VERSION_ID := l_create_audit_rec.OLD_CP_SUBCOMPONENT_VERSION_ID ;

Line: 1080


          l_svi_update := 0;

Line: 1090


        l_lan_update := 1;

Line: 1093


        if l_lan_update >0 then
          l_create_audit_rec.LANGUAGE_ID := l_create_audit_rec.OLD_LANGUAGE_ID ;

Line: 1096


          l_lan_update := 0;

Line: 1106


        l_ter_update := 1;

Line: 1109


        if l_ter_update >0 then
          l_create_audit_rec.TERRITORY_ID := l_create_audit_rec.OLD_TERRITORY_ID ;

Line: 1112


          l_ter_update := 0;

Line: 1122


        l_cpr_update := 1;

Line: 1125


        if l_cpr_update >0 then
          l_create_audit_rec.CP_REVISION_ID := l_create_audit_rec.CP_REVISION_ID ;

Line: 1128


          l_cpr_update := 0;

Line: 1138


        l_iiv_update := 1;

Line: 1141


        if l_iiv_update >0 then
          l_create_audit_rec.INV_ITEM_REVISION := l_create_audit_rec.OLD_INV_ITEM_REVISION ;

Line: 1144


          l_iiv_update := 0;

Line: 1154


        l_ici_update := 1;

Line: 1157


        if l_ici_update >0 then
          l_create_audit_rec.INV_COMPONENT_ID := l_create_audit_rec.OLD_INV_COMPONENT_ID ;

Line: 1160


          l_ici_update := 0;

Line: 1170


        l_icv_update := 1;

Line: 1173


        if l_icv_update >0 then
          l_create_audit_rec.INV_COMPONENT_VERSION := l_create_audit_rec.OLD_INV_COMPONENT_VERSION ;

Line: 1176


          l_icv_update := 0;

Line: 1186


        l_isc_update := 1;

Line: 1189


        if l_isc_update >0 then
          l_create_audit_rec.INV_SUBCOMPONENT_ID := l_create_audit_rec.OLD_INV_SUBCOMPONENT_ID ;

Line: 1192


          l_isc_update := 0;

Line: 1202


        l_isv_update := 1;

Line: 1205


        if l_isv_update >0 then
          l_create_audit_rec.INV_SUBCOMPONENT_VERSION := l_create_audit_rec.OLD_INV_SUBCOMPONENT_VERSION ;

Line: 1208


          l_isv_update := 0;

Line: 1218


        l_por_update := 1;

Line: 1221


        if l_por_update >0 then
          l_create_audit_rec.INV_PLATFORM_ORG_ID := l_create_audit_rec.OLD_INV_PLATFORM_ORG_ID ;

Line: 1224


          l_por_update := 0;

Line: 1234


        l_cov_update := 1;

Line: 1237


        if l_cov_update >0 then
          l_create_audit_rec.COMPONENT_VERSION := l_create_audit_rec.OLD_COMPONENT_VERSION ;

Line: 1240


          l_cov_update := 0;

Line: 1250


        l_scv_update := 1;

Line: 1253


        if l_scv_update >0 then
          l_create_audit_rec.SUBCOMPONENT_VERSION := l_create_audit_rec.OLD_SUBCOMPONENT_VERSION ;

Line: 1256


          l_scv_update := 0;

Line: 1266


        l_prv_update := 1;

Line: 1269


        if l_prv_update >0 then
          l_create_audit_rec.PRODUCT_REVISION := l_create_audit_rec.OLD_PRODUCT_REVISION ;

Line: 1272


          l_prv_update := 0;

Line: 1282


        l_inv_update := 1;

Line: 1285


        if l_inv_update >0 then
          l_create_audit_rec.INVENTORY_ITEM_ID := l_create_audit_rec.OLD_INVENTORY_ITEM_ID ;

Line: 1288


          l_inv_update := 0;

Line: 1298


        l_ino_update := 1;

Line: 1301


        if l_ino_update >0 then
          l_create_audit_rec.INV_ORGANIZATION_ID := l_create_audit_rec.OLD_INV_ORGANIZATION_ID ;

Line: 1304


          l_ino_update := 0;

Line: 1314


        l_pci_update := 1;

Line: 1317


        if l_pci_update >0 then
          l_create_audit_rec.PRIMARY_CONTACT_ID := l_create_audit_rec.OLD_PRIMARY_CONTACT_ID ;

Line: 1320


          l_pci_update := 0;

Line: 1366


    Update cs_incidents_audit_b
    set    INCIDENT_STATUS_ID = decode(l_create_audit_rec.CHANGE_INCIDENT_STATUS_FLAG,'Y',l_create_audit_rec.OLD_INCIDENT_STATUS_ID,l_create_audit_rec.INCIDENT_STATUS_ID),
         CHANGE_INCIDENT_STATUS_FLAG = decode(l_create_audit_rec.INCIDENT_STATUS_ID,NULL,'N','Y'),
         INCIDENT_TYPE_ID  = decode(l_create_audit_rec.CHANGE_INCIDENT_TYPE_FLAG,'Y',l_create_audit_rec.OLD_INCIDENT_TYPE_ID,l_create_audit_rec.INCIDENT_TYPE_ID),
        CHANGE_INCIDENT_TYPE_FLAG = decode(l_create_audit_rec.INCIDENT_TYPE_ID,NULL,'N','Y'),
        INCIDENT_URGENCY_ID    = decode(l_create_audit_rec.CHANGE_INCIDENT_URGENCY_FLAG,'Y',l_create_audit_rec.OLD_INCIDENT_URGENCY_ID,l_create_audit_rec.INCIDENT_URGENCY_ID),
        CHANGE_INCIDENT_URGENCY_FLAG = decode(l_create_audit_rec.INCIDENT_URGENCY_ID,NULL,'N','Y'),
        INCIDENT_SEVERITY_ID    = decode(l_create_audit_rec.CHANGE_INCIDENT_SEVERITY_FLAG,'Y',l_create_audit_rec.OLD_INCIDENT_SEVERITY_ID,l_create_audit_rec.INCIDENT_SEVERITY_ID),
        CHANGE_INCIDENT_SEVERITY_FLAG = decode(l_create_audit_rec.INCIDENT_SEVERITY_ID,NULL,'N','Y'),
        RESPONSIBLE_GROUP_ID     = decode(l_create_audit_rec.CHANGE_RESPONSIBLE_GROUP_FLAG,'Y',l_create_audit_rec.OLD_RESPONSIBLE_GROUP_ID,l_create_audit_rec.RESPONSIBLE_GROUP_ID),
        CHANGE_RESPONSIBLE_GROUP_FLAG = decode(l_create_audit_rec.RESPONSIBLE_GROUP_ID,NULL,'N','Y'),
        INCIDENT_OWNER_ID        = decode(l_create_audit_rec.CHANGE_INCIDENT_OWNER_FLAG,'Y',l_create_audit_rec.OLD_INCIDENT_OWNER_ID,l_create_audit_rec.INCIDENT_OWNER_ID),
        CHANGE_INCIDENT_OWNER_FLAG = decode(decode(l_create_audit_rec.CHANGE_INCIDENT_OWNER_FLAG,'Y',l_create_audit_rec.OLD_INCIDENT_OWNER_ID,l_create_audit_rec.INCIDENT_OWNER_ID),NULL,'N','Y'),
        EXPECTED_RESOLUTION_DATE= decode(l_create_audit_rec.CHANGE_RESOLUTION_FLAG,'Y',l_create_audit_rec.OLD_EXPECTED_RESOLUTION_DATE,l_create_audit_rec.EXPECTED_RESOLUTION_DATE),
        CHANGE_RESOLUTION_FLAG = decode(decode(l_create_audit_rec.CHANGE_RESOLUTION_FLAG,'Y',l_create_audit_rec.OLD_EXPECTED_RESOLUTION_DATE,l_create_audit_rec.EXPECTED_RESOLUTION_DATE),NULL,'N','Y'),
        GROUP_ID            = decode(l_create_audit_rec.CHANGE_GROUP_FLAG,'Y',l_create_audit_rec.OLD_GROUP_ID,l_create_audit_rec.GROUP_ID),
        CHANGE_GROUP_FLAG = decode(decode(l_create_audit_rec.CHANGE_GROUP_FLAG,'Y',l_create_audit_rec.OLD_GROUP_ID,l_create_audit_rec.GROUP_ID),NULL,'N','Y'),
         OBLIGATION_DATE  = decode(l_create_audit_rec.CHANGE_OBLIGATION_FLAG,'Y',l_create_audit_rec.OLD_OBLIGATION_DATE,l_create_audit_rec.OBLIGATION_DATE) ,
        CHANGE_OBLIGATION_FLAG = decode(decode(l_create_audit_rec.CHANGE_OBLIGATION_FLAG,'Y',l_create_audit_rec.OLD_OBLIGATION_DATE,l_create_audit_rec.OBLIGATION_DATE),NULL,'N','Y'),
        SITE_ID                = decode(l_create_audit_rec.CHANGE_SITE_FLAG,'Y',l_create_audit_rec.OLD_SITE_ID,l_create_audit_rec.SITE_ID),
        CHANGE_SITE_FLAG = decode(decode(l_create_audit_rec.CHANGE_SITE_FLAG,'Y',l_create_audit_rec.OLD_SITE_ID,l_create_audit_rec.SITE_ID),NULL,'N','Y'),
        BILL_TO_CONTACT_ID   = decode(l_create_audit_rec.CHANGE_BILL_TO_FLAG,'Y',l_create_audit_rec.OLD_BILL_TO_CONTACT_ID,l_create_audit_rec.BILL_TO_CONTACT_ID) ,
        CHANGE_BILL_TO_FLAG = decode(decode(l_create_audit_rec.CHANGE_BILL_TO_FLAG,'Y',l_create_audit_rec.OLD_BILL_TO_CONTACT_ID,l_create_audit_rec.BILL_TO_CONTACT_ID),NULL,'N','Y'),
        SHIP_TO_CONTACT_ID   = decode(l_create_audit_rec.CHANGE_SHIP_TO_FLAG,'Y',l_create_audit_rec.OLD_SHIP_TO_CONTACT_ID,l_create_audit_rec.SHIP_TO_CONTACT_ID),
        CHANGE_SHIP_TO_FLAG = decode(decode(l_create_audit_rec.CHANGE_SHIP_TO_FLAG,'Y',l_create_audit_rec.OLD_SHIP_TO_CONTACT_ID,l_create_audit_rec.SHIP_TO_CONTACT_ID),NULL,'N','Y'),
        INCIDENT_DATE       = decode(l_create_audit_rec.CHANGE_INCIDENT_DATE_FLAG,'Y',l_create_audit_rec.OLD_INCIDENT_DATE,l_create_audit_rec.INCIDENT_DATE),
        CHANGE_INCIDENT_DATE_FLAG = decode(decode(l_create_audit_rec.CHANGE_INCIDENT_DATE_FLAG,'Y',l_create_audit_rec.OLD_INCIDENT_DATE,l_create_audit_rec.INCIDENT_DATE),NULL,'N','Y'),
        CLOSE_DATE               = decode(l_create_audit_rec.CHANGE_INCIDENT_STATUS_FLAG,'Y',l_create_audit_rec.OLD_CLOSE_DATE,l_create_audit_rec.CLOSE_DATE),
        CHANGE_CLOSE_DATE_FLAG = decode(decode(l_create_audit_rec.CHANGE_INCIDENT_STATUS_FLAG,'Y',l_create_audit_rec.OLD_CLOSE_DATE,l_create_audit_rec.CLOSE_DATE),NULL,'N','Y'),
        CUSTOMER_PRODUCT_ID   = decode(l_create_audit_rec.CHANGE_CUSTOMER_PRODUCT_FLAG,'Y',l_create_audit_rec.OLD_CUSTOMER_PRODUCT_ID,l_create_audit_rec.CUSTOMER_PRODUCT_ID),
        CHANGE_CUSTOMER_PRODUCT_FLAG = decode(decode(l_create_audit_rec.CHANGE_CUSTOMER_PRODUCT_FLAG,'Y',l_create_audit_rec.OLD_CUSTOMER_PRODUCT_ID,l_create_audit_rec.CUSTOMER_PRODUCT_ID),NULL,'N','Y'),
        PLATFORM_ID           = decode(l_create_audit_rec.CHANGE_PLATFORM_ID_FLAG,'Y',l_create_audit_rec.OLD_PLATFORM_ID,l_create_audit_rec.PLATFORM_ID),
        CHANGE_PLATFORM_ID_FLAG = decode(decode(l_create_audit_rec.CHANGE_PLATFORM_ID_FLAG,'Y',l_create_audit_rec.OLD_PLATFORM_ID,l_create_audit_rec.PLATFORM_ID),NULL,'N','Y'),
        PLATFORM_VERSION_ID     = decode(l_create_audit_rec.CHANGE_PLAT_VER_ID_FLAG,'Y',l_create_audit_rec.OLD_PLATFORM_VERSION_ID,l_create_audit_rec.PLATFORM_VERSION_ID),
        CHANGE_PLAT_VER_ID_FLAG = decode(decode(l_create_audit_rec.CHANGE_PLAT_VER_ID_FLAG,'Y',l_create_audit_rec.OLD_PLATFORM_VERSION_ID,l_create_audit_rec.PLATFORM_VERSION_ID),NULL,'N','Y'),
        CP_COMPONENT_ID           = decode(l_create_audit_rec.CHANGE_CP_COMPONENT_ID_FLAG,'Y',l_create_audit_rec.OLD_CP_COMPONENT_ID,l_create_audit_rec.CP_COMPONENT_ID),
        CHANGE_CP_COMPONENT_ID_FLAG = decode(decode(l_create_audit_rec.CHANGE_CP_COMPONENT_ID_FLAG,'Y',l_create_audit_rec.OLD_CP_COMPONENT_ID,l_create_audit_rec.CP_COMPONENT_ID),NULL,'N','Y'),
        CP_COMPONENT_VERSION_ID   = decode(l_create_audit_rec.CHANGE_CP_COMP_VER_ID_FLAG,'Y',l_create_audit_rec.OLD_CP_COMPONENT_VERSION_ID,l_create_audit_rec.CP_COMPONENT_VERSION_ID),
        CHANGE_CP_COMP_VER_ID_FLAG = decode(decode(l_create_audit_rec.CHANGE_CP_COMP_VER_ID_FLAG,'Y',l_create_audit_rec.OLD_CP_COMPONENT_VERSION_ID,l_create_audit_rec.CP_COMPONENT_VERSION_ID),NULL,'N','Y'),
        CP_SUBCOMPONENT_ID      = decode(l_create_audit_rec.CHANGE_CP_SUBCOMPONENT_ID_FLAG,'Y',l_create_audit_rec.OLD_CP_SUBCOMPONENT_ID,l_create_audit_rec.CP_SUBCOMPONENT_ID),
        CHANGE_CP_SUBCOMPONENT_ID_FLAG = decode(decode(l_create_audit_rec.CHANGE_CP_SUBCOMPONENT_ID_FLAG,'Y',l_create_audit_rec.OLD_CP_SUBCOMPONENT_ID,l_create_audit_rec.CP_SUBCOMPONENT_ID),NULL,'N','Y'),
        CP_SUBCOMPONENT_VERSION_ID   = decode(l_create_audit_rec.CHANGE_CP_SUBCOMP_VER_ID_FLAG,'Y',l_create_audit_rec.OLD_CP_SUBCOMPONENT_VERSION_ID,l_create_audit_rec.CP_SUBCOMPONENT_VERSION_ID),
        CHANGE_CP_SUBCOMP_VER_ID_FLAG = decode(decode(l_create_audit_rec.CHANGE_CP_SUBCOMP_VER_ID_FLAG,'Y',l_create_audit_rec.OLD_CP_SUBCOMPONENT_VERSION_ID,l_create_audit_rec.CP_SUBCOMPONENT_VERSION_ID),NULL,'N','Y'),
        LANGUAGE_ID                 = decode(l_create_audit_rec.CHANGE_LANGUAGE_ID_FLAG,'Y',l_create_audit_rec.OLD_LANGUAGE_ID,l_create_audit_rec.LANGUAGE_ID),
        CHANGE_LANGUAGE_ID_FLAG = decode(decode(l_create_audit_rec.CHANGE_LANGUAGE_ID_FLAG,'Y',l_create_audit_rec.OLD_LANGUAGE_ID,l_create_audit_rec.LANGUAGE_ID),NULL,'N','Y'),
        TERRITORY_ID            = decode(l_create_audit_rec.CHANGE_TERRITORY_ID_FLAG,'Y',l_create_audit_rec.OLD_TERRITORY_ID,l_create_audit_rec.TERRITORY_ID),
        CHANGE_TERRITORY_ID_FLAG = decode(decode(l_create_audit_rec.CHANGE_TERRITORY_ID_FLAG,'Y',l_create_audit_rec.OLD_TERRITORY_ID,l_create_audit_rec.TERRITORY_ID),NULL,'N','Y'),
        CP_REVISION_ID         = decode(l_create_audit_rec.CHANGE_CP_REVISION_ID_FLAG,'Y',l_create_audit_rec.OLD_CP_REVISION_ID,l_create_audit_rec.CP_REVISION_ID),
        CHANGE_CP_REVISION_ID_FLAG = decode(decode(l_create_audit_rec.CHANGE_CP_REVISION_ID_FLAG,'Y',l_create_audit_rec.OLD_CP_REVISION_ID,l_create_audit_rec.CP_REVISION_ID),NULL,'N','Y'),
        INV_ITEM_REVISION        = decode(l_create_audit_rec.CHANGE_INV_ITEM_REVISION,'Y',l_create_audit_rec.OLD_INV_ITEM_REVISION,l_create_audit_rec.INV_ITEM_REVISION),
        CHANGE_INV_ITEM_REVISION = decode(decode(l_create_audit_rec.CHANGE_INV_ITEM_REVISION,'Y',l_create_audit_rec.OLD_INV_ITEM_REVISION,l_create_audit_rec.INV_ITEM_REVISION),NULL,'N','Y'),
        INV_COMPONENT_ID      = decode(l_create_audit_rec.CHANGE_INV_COMPONENT_ID,'Y',l_create_audit_rec.OLD_INV_COMPONENT_ID,l_create_audit_rec.INV_COMPONENT_ID),
        CHANGE_INV_COMPONENT_ID = decode(decode(l_create_audit_rec.CHANGE_INV_COMPONENT_ID,'Y',l_create_audit_rec.OLD_INV_COMPONENT_ID,l_create_audit_rec.INV_COMPONENT_ID),NULL,'N','Y'),
        INV_COMPONENT_VERSION   = decode(l_create_audit_rec.CHANGE_INV_COMPONENT_VERSION,'Y',l_create_audit_rec.OLD_INV_COMPONENT_VERSION,l_create_audit_rec.INV_COMPONENT_VERSION),
        CHANGE_INV_COMPONENT_VERSION = decode(decode(l_create_audit_rec.CHANGE_INV_COMPONENT_VERSION,'Y',l_create_audit_rec.OLD_INV_COMPONENT_VERSION,l_create_audit_rec.INV_COMPONENT_VERSION),NULL,'N','Y'),
        INV_SUBCOMPONENT_ID     = decode(l_create_audit_rec.CHANGE_INV_SUBCOMPONENT_ID,'Y',l_create_audit_rec.OLD_INV_SUBCOMPONENT_ID,l_create_audit_rec.INV_SUBCOMPONENT_ID),
        CHANGE_INV_SUBCOMPONENT_ID = decode(decode(l_create_audit_rec.CHANGE_INV_SUBCOMPONENT_ID,'Y',l_create_audit_rec.OLD_INV_SUBCOMPONENT_ID,l_create_audit_rec.INV_SUBCOMPONENT_ID),NULL,'N','Y'),
        INV_SUBCOMPONENT_VERSION = decode(l_create_audit_rec.CHANGE_INV_SUBCOMP_VERSION,'Y',l_create_audit_rec.OLD_INV_SUBCOMPONENT_VERSION,l_create_audit_rec.INV_SUBCOMPONENT_VERSION),
        CHANGE_INV_SUBCOMP_VERSION = decode(decode(l_create_audit_rec.CHANGE_INV_SUBCOMP_VERSION,'Y',l_create_audit_rec.OLD_INV_SUBCOMPONENT_VERSION,l_create_audit_rec.INV_SUBCOMPONENT_VERSION),NULL,'N','Y'),
        RESOURCE_TYPE            = decode(l_create_audit_rec.CHANGE_RESOURCE_TYPE_FLAG,'Y',l_create_audit_rec.OLD_RESOURCE_TYPE,l_create_audit_rec.RESOURCE_TYPE),
        CHANGE_RESOURCE_TYPE_FLAG = decode(decode(l_create_audit_rec.CHANGE_RESOURCE_TYPE_FLAG,'Y',l_create_audit_rec.OLD_RESOURCE_TYPE,l_create_audit_rec.RESOURCE_TYPE),NULL,'N','Y'),
        GROUP_TYPE                = decode(l_create_audit_rec.CHANGE_GROUP_TYPE_FLAG,'Y',l_create_audit_rec.OLD_GROUP_TYPE,l_create_audit_rec.GROUP_TYPE),
        CHANGE_GROUP_TYPE_FLAG = decode(decode(l_create_audit_rec.CHANGE_GROUP_TYPE_FLAG,'Y',l_create_audit_rec.OLD_GROUP_TYPE,l_create_audit_rec.GROUP_TYPE),NULL,'N','Y'),
        OWNER_ASSIGNED_TIME= decode(l_create_audit_rec.change_assigned_time_flag,'Y',l_create_audit_rec.creation_date,l_create_audit_rec.owner_assigned_time),
        CHANGE_ASSIGNED_TIME_FLAG = decode(decode(l_create_audit_rec.change_assigned_time_flag,'Y',l_create_audit_rec.creation_date,l_create_audit_rec.owner_assigned_time),NULL,'N','Y'),
        INVENTORY_ITEM_ID = decode(l_create_audit_rec.CHANGE_INVENTORY_ITEM_FLAG,'Y',l_create_audit_rec.OLD_INVENTORY_ITEM_ID,l_create_audit_rec.INVENTORY_ITEM_ID) ,
        CHANGE_INVENTORY_ITEM_FLAG = decode(decode(l_create_audit_rec.CHANGE_INVENTORY_ITEM_FLAG,'Y',l_create_audit_rec.OLD_INVENTORY_ITEM_ID,l_create_audit_rec.INVENTORY_ITEM_ID),NULL,'N','Y'),
        INV_ORGANIZATION_ID = decode(l_create_audit_rec.CHANGE_INV_ORGANIZATION_FLAG,'Y',l_create_audit_rec.OLD_INV_ORGANIZATION_ID,l_create_audit_rec.INV_ORGANIZATION_ID),
        CHANGE_INV_ORGANIZATION_FLAG = decode(decode(l_create_audit_rec.CHANGE_INV_ORGANIZATION_FLAG,'Y',l_create_audit_rec.OLD_INV_ORGANIZATION_ID,l_create_audit_rec.INV_ORGANIZATION_ID),NULL,'N','Y'),
        STATUS_FLAG = decode(l_create_audit_rec.CHANGE_INCIDENT_STATUS_FLAG,'Y',l_create_audit_rec.OLD_STATUS_FLAG,l_create_audit_rec.STATUS_FLAG),
        CHANGE_STATUS_FLAG = decode(decode(l_create_audit_rec.CHANGE_INCIDENT_STATUS_FLAG,'Y',l_create_audit_rec.OLD_STATUS_FLAG,l_create_audit_rec.STATUS_FLAG),NULL,'N','Y'),
        UPGRADE_FLAG_FOR_CREATE = 'X',
        updated_entity_code     = 'SR_HEADER'
    WHERE  incident_id = l_create_audit_rec.incident_id
    AND    upgrade_flag_for_create = 'Y';

Line: 2142


     UPDATE cs_incidents_audit_b
       SET LAST_UPDATE_DATE = sysdate,

           INCIDENT_STATUS_ID = l_create_audit_rec.INCIDENT_STATUS_ID,
           OLD_INCIDENT_STATUS_ID = l_create_audit_rec.OLD_INCIDENT_STATUS_ID,
          CHANGE_INCIDENT_STATUS_FLAG = l_create_audit_rec.CHANGE_INCIDENT_STATUS_FLAG,

           INCIDENT_TYPE_ID  = l_create_audit_rec.INCIDENT_TYPE_ID         ,
      OLD_INCIDENT_TYPE_ID   = l_create_audit_rec.OLD_INCIDENT_TYPE_ID   ,
      CHANGE_INCIDENT_TYPE_FLAG = l_create_audit_rec.CHANGE_INCIDENT_TYPE_FLAG,

      INCIDENT_URGENCY_ID    = l_create_audit_rec.INCIDENT_URGENCY_ID  ,
      OLD_INCIDENT_URGENCY_ID = l_create_audit_rec.OLD_INCIDENT_URGENCY_ID,
      CHANGE_INCIDENT_URGENCY_FLAG = l_create_audit_rec.CHANGE_INCIDENT_URGENCY_FLAG,

      INCIDENT_SEVERITY_ID    = l_create_audit_rec.INCIDENT_SEVERITY_ID    ,
      OLD_INCIDENT_SEVERITY_ID = l_create_audit_rec.OLD_INCIDENT_SEVERITY_ID  ,
      CHANGE_INCIDENT_SEVERITY_FLAG = l_create_audit_rec.CHANGE_INCIDENT_SEVERITY_FLAG,

      RESPONSIBLE_GROUP_ID     = l_create_audit_rec.RESPONSIBLE_GROUP_ID   ,
      OLD_RESPONSIBLE_GROUP_ID = l_create_audit_rec.OLD_RESPONSIBLE_GROUP_ID  ,
      CHANGE_RESPONSIBLE_GROUP_FLAG = l_create_audit_rec.CHANGE_RESPONSIBLE_GROUP_FLAG,

      INCIDENT_OWNER_ID        = l_create_audit_rec.INCIDENT_OWNER_ID    ,
      OLD_INCIDENT_OWNER_ID    = l_create_audit_rec.OLD_INCIDENT_OWNER_ID   ,
      CHANGE_INCIDENT_OWNER_FLAG = l_create_audit_rec.CHANGE_INCIDENT_OWNER_FLAG,

      EXPECTED_RESOLUTION_DATE= l_create_audit_rec.EXPECTED_RESOLUTION_DATE,
      OLD_EXPECTED_RESOLUTION_DATE = l_create_audit_rec.OLD_EXPECTED_RESOLUTION_DATE ,
      CHANGE_RESOLUTION_FLAG = l_create_audit_rec.CHANGE_RESOLUTION_FLAG,

      GROUP_ID            = l_create_audit_rec.GROUP_ID  ,
      OLD_GROUP_ID       = l_create_audit_rec.OLD_GROUP_ID ,
      change_group_flag  = l_create_audit_rec.change_group_flag,

      OBLIGATION_DATE  = l_create_audit_rec.OBLIGATION_DATE ,
      OLD_OBLIGATION_DATE= l_create_audit_rec.OLD_OBLIGATION_DATE ,
      CHANGE_OBLIGATION_FLAG = l_create_audit_rec.CHANGE_OBLIGATION_FLAG,

      SITE_ID                = l_create_audit_rec.SITE_ID  ,
      OLD_SITE_ID           = l_create_audit_rec.OLD_SITE_ID  ,
      CHANGE_SITE_FLAG   = l_create_audit_rec.CHANGE_SITE_FLAG,

      BILL_TO_CONTACT_ID   = l_create_audit_rec.BILL_TO_CONTACT_ID ,
      OLD_BILL_TO_CONTACT_ID = l_create_audit_rec.OLD_BILL_TO_CONTACT_ID ,
      CHANGE_BILL_TO_FLAG  = l_create_audit_rec.CHANGE_BILL_TO_FLAG,

      SHIP_TO_CONTACT_ID   = l_create_audit_rec.SHIP_TO_CONTACT_ID ,
      OLD_SHIP_TO_CONTACT_ID= l_create_audit_rec.OLD_SHIP_TO_CONTACT_ID ,
      CHANGE_SHIP_TO_FLAG = l_create_audit_rec.CHANGE_SHIP_TO_FLAG,

      INCIDENT_DATE       = l_create_audit_rec.INCIDENT_DATE ,
      OLD_INCIDENT_DATE  = l_create_audit_rec.OLD_INCIDENT_DATE ,
      CHANGE_INCIDENT_DATE_FLAG = l_create_audit_rec.CHANGE_INCIDENT_DATE_FLAG,

      CLOSE_DATE               = l_create_audit_rec.CLOSE_DATE ,
      OLD_CLOSE_DATE          = l_create_audit_rec.OLD_CLOSE_DATE ,
      CHANGE_CLOSE_DATE_FLAG  = l_create_audit_rec.CHANGE_CLOSE_DATE_FLAG,

      CUSTOMER_PRODUCT_ID   = l_create_audit_rec.CUSTOMER_PRODUCT_ID ,
      OLD_CUSTOMER_PRODUCT_ID= l_create_audit_rec.OLD_CUSTOMER_PRODUCT_ID ,
      CHANGE_CUSTOMER_PRODUCT_FLAG = l_create_audit_rec.CHANGE_CUSTOMER_PRODUCT_FLAG,

      PLATFORM_ID                     = l_create_audit_rec.PLATFORM_ID ,
      OLD_PLATFORM_ID                = l_create_audit_rec.OLD_PLATFORM_ID ,
      CHANGE_PLATFORM_ID_FLAG = l_create_audit_rec.CHANGE_PLATFORM_ID_FLAG,

      PLATFORM_VERSION_ID          = l_create_audit_rec.PLATFORM_VERSION_ID ,
      OLD_PLATFORM_VERSION_ID     = l_create_audit_rec.OLD_PLATFORM_VERSION_ID ,
      CHANGE_PLAT_VER_ID_FLAG = l_create_audit_rec.CHANGE_PLAT_VER_ID_FLAG,

      CP_COMPONENT_ID           = l_create_audit_rec.CP_COMPONENT_ID ,
      OLD_CP_COMPONENT_ID      = l_create_audit_rec.OLD_CP_COMPONENT_ID ,
      CHANGE_CP_COMPONENT_ID_FLAG = l_create_audit_rec.CHANGE_CP_COMPONENT_ID_FLAG,

      CP_COMPONENT_VERSION_ID   = l_create_audit_rec.CP_COMPONENT_VERSION_ID ,
      OLD_CP_COMPONENT_VERSION_ID= l_create_audit_rec.OLD_CP_COMPONENT_VERSION_ID,
      CHANGE_CP_COMP_VER_ID_FLAG = l_create_audit_rec.CHANGE_CP_COMP_VER_ID_FLAG,

      CP_SUBCOMPONENT_ID      = l_create_audit_rec.CP_SUBCOMPONENT_ID,
      OLD_CP_SUBCOMPONENT_ID   = l_create_audit_rec.OLD_CP_SUBCOMPONENT_ID ,
      CHANGE_CP_SUBCOMPONENT_ID_FLAG = l_create_audit_rec.CHANGE_CP_SUBCOMPONENT_ID_FLAG,

      CP_SUBCOMPONENT_VERSION_ID   = l_create_audit_rec.CP_SUBCOMPONENT_VERSION_ID ,
      OLD_CP_SUBCOMPONENT_VERSION_ID= l_create_audit_rec.OLD_CP_SUBCOMPONENT_VERSION_ID ,
      CHANGE_CP_SUBCOMP_VER_ID_FLAG = l_create_audit_rec.CHANGE_CP_SUBCOMP_VER_ID_FLAG,

      LANGUAGE_ID                 = l_create_audit_rec.LANGUAGE_ID ,
      OLD_LANGUAGE_ID            = l_create_audit_rec.OLD_LANGUAGE_ID ,
      CHANGE_LANGUAGE_ID_FLAG = l_create_audit_rec.CHANGE_LANGUAGE_ID_FLAG,

      TERRITORY_ID            = l_create_audit_rec.TERRITORY_ID ,
      OLD_TERRITORY_ID         = l_create_audit_rec.OLD_TERRITORY_ID ,
      CHANGE_TERRITORY_ID_FLAG = l_create_audit_rec.CHANGE_TERRITORY_ID_FLAG,

      CP_REVISION_ID         = l_create_audit_rec.CP_REVISION_ID ,
      OLD_CP_REVISION_ID    = l_create_audit_rec.OLD_CP_REVISION_ID ,
      CHANGE_CP_REVISION_ID_FLAG = l_create_audit_rec.CHANGE_CP_REVISION_ID_FLAG,

      INV_ITEM_REVISION        = l_create_audit_rec.INV_ITEM_REVISION ,
      OLD_INV_ITEM_REVISION   = l_create_audit_rec.OLD_INV_ITEM_REVISION ,
      CHANGE_INV_ITEM_REVISION = l_create_audit_rec.CHANGE_INV_ITEM_REVISION,

      INV_COMPONENT_ID      = l_create_audit_rec.INV_COMPONENT_ID ,
      OLD_INV_COMPONENT_ID = l_create_audit_rec.OLD_INV_COMPONENT_ID ,
      CHANGE_INV_COMPONENT_ID = l_create_audit_rec.CHANGE_INV_COMPONENT_ID,

      INV_COMPONENT_VERSION   = l_create_audit_rec.INV_COMPONENT_VERSION ,
      OLD_INV_COMPONENT_VERSION = l_create_audit_rec.OLD_INV_COMPONENT_VERSION ,
      CHANGE_INV_COMPONENT_VERSION = l_create_audit_rec.CHANGE_INV_COMPONENT_VERSION,

      INV_SUBCOMPONENT_ID         = l_create_audit_rec.INV_SUBCOMPONENT_ID ,
      OLD_INV_SUBCOMPONENT_ID    = l_create_audit_rec.OLD_INV_SUBCOMPONENT_ID ,
      CHANGE_INV_SUBCOMPONENT_ID = l_create_audit_rec.CHANGE_INV_SUBCOMPONENT_ID,

      INV_SUBCOMPONENT_VERSION = l_create_audit_rec.INV_SUBCOMPONENT_VERSION ,
      OLD_INV_SUBCOMPONENT_VERSION = l_create_audit_rec.OLD_INV_SUBCOMPONENT_VERSION ,
      CHANGE_INV_SUBCOMP_VERSION = l_create_audit_rec.CHANGE_INV_SUBCOMP_VERSION,

      RESOURCE_TYPE              = l_create_audit_rec.RESOURCE_TYPE ,
      OLD_RESOURCE_TYPE         = l_create_audit_rec.OLD_RESOURCE_TYPE ,
      change_resource_type_flag    = l_create_audit_rec.change_resource_type_flag,

      OLD_GROUP_TYPE             = l_create_audit_rec.OLD_GROUP_TYPE ,
      GROUP_TYPE                = l_create_audit_rec.GROUP_TYPE ,
      change_group_type_flag    = l_create_audit_rec.change_group_type_flag,

      OLD_OWNER_ASSIGNED_TIME = l_create_audit_rec.OLD_OWNER_ASSIGNED_TIME ,
      OWNER_ASSIGNED_TIME= l_create_audit_rec.OWNER_ASSIGNED_TIME ,
      CHANGE_ASSIGNED_TIME_FLAG = l_create_audit_rec.CHANGE_ASSIGNED_TIME_FLAG,

      INV_PLATFORM_ORG_ID              = l_create_audit_rec.INV_PLATFORM_ORG_ID ,
      OLD_INV_PLATFORM_ORG_ID         = l_create_audit_rec.OLD_INV_PLATFORM_ORG_ID ,
      CHANGE_PLATFORM_ORG_ID_FLAG = l_create_audit_rec.CHANGE_PLATFORM_ORG_ID_FLAG,

      COMPONENT_VERSION             = l_create_audit_rec.COMPONENT_VERSION ,
      OLD_COMPONENT_VERSION        = l_create_audit_rec.OLD_COMPONENT_VERSION ,
      CHANGE_COMP_VER_FLAG = l_create_audit_rec.CHANGE_COMP_VER_FLAG,

      SUBCOMPONENT_VERSION       = l_create_audit_rec.SUBCOMPONENT_VERSION ,
      OLD_SUBCOMPONENT_VERSION  = l_create_audit_rec.OLD_SUBCOMPONENT_VERSION ,
      CHANGE_SUBCOMP_VER_FLAG = l_create_audit_rec.CHANGE_SUBCOMP_VER_FLAG,

      PRODUCT_REVISION                  = l_create_audit_rec.PRODUCT_REVISION ,
      OLD_PRODUCT_REVISION             = l_create_audit_rec.OLD_PRODUCT_REVISION ,
      CHANGE_PRODUCT_REVISION_FLAG = l_create_audit_rec.CHANGE_PRODUCT_REVISION_FLAG,

      INVENTORY_ITEM_ID              = l_create_audit_rec.INVENTORY_ITEM_ID ,
      OLD_INVENTORY_ITEM_ID         = l_create_audit_rec.OLD_INVENTORY_ITEM_ID ,
      CHANGE_INVENTORY_ITEM_FLAG  = decode(l_create_audit_rec.CHANGE_INVENTORY_ITEM_FLAG,NULL,'N',l_create_audit_rec.CHANGE_INVENTORY_ITEM_FLAG),

      INV_ORGANIZATION_ID         = l_create_audit_rec.INV_ORGANIZATION_ID ,
      OLD_INV_ORGANIZATION_ID    = l_create_audit_rec.OLD_INV_ORGANIZATION_ID ,
      --CHANGE_INV_ORGANIZATION_FLAG  = decode(l_create_audit_rec.CHANGE_INV_ORGANIZATION_FLAG,NULL,'N',l_create_audit_rec.CHANGE_INV_ORGANIZATION_FLAG),
      CHANGE_INV_ORGANIZATION_FLAG  = l_create_audit_rec.CHANGE_INV_ORGANIZATION_FLAG,

      STATUS_FLAG                  = l_create_audit_rec.STATUS_FLAG ,
      OLD_STATUS_FLAG    = l_create_audit_rec.OLD_STATUS_FLAG,
      CHANGE_STATUS_FLAG = l_create_audit_rec.CHANGE_STATUS_FLAG,

      PRIMARY_CONTACT_ID        = l_create_audit_rec.PRIMARY_CONTACT_ID ,
      OLD_PRIMARY_CONTACT_ID= l_create_audit_rec.OLD_PRIMARY_CONTACT_ID,
      CHANGE_PRIMARY_CONTACT_FLAG = l_create_audit_rec.CHANGE_PRIMARY_CONTACT_FLAG,

      UPGRADE_FLAG_FOR_CREATE = decode(l_create_record, 'Y', 'X', 'U'),
      updated_entity_code   = 'SR_HEADER'
    WHERE incident_audit_id = l_audit_rec.incident_audit_id;

Line: 2319


    ad_parallel_updates_pkg.processed_rowid_range(
         l_loop_counter,
         l_end_rowid);

Line: 2331


    ad_parallel_updates_pkg.get_rowid_range(
       l_start_rowid,
       l_end_rowid,
       l_any_rows_to_process,
       x_batch_size,
       FALSE);