DBA Data[Home] [Help]

APPS.CS_CF_UPG_PKG SQL Statements

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

Line: 6

    SELECT count(*) from ak_regions
    where region_application_id = p_region_application_id
    and region_code = p_region_code;
Line: 30

    select to_char(sysdate, 'mm-dd-yy') || to_char(sysdate, 'hh24:mi:ss')
    into l_logfilename
    from dual;
Line: 252

  l_upg_return_value := CS_CF_UPG_UTL_PKG.Eval_SR_Product_Selection(l_appl_index,
                                                                 p_applTable,
                                                                 l_resp_index,
                                                                 p_respTable,
                                                                 l_site_index,
                                                                 p_siteProfilesTable);
Line: 350

  SELECT a.profile_option_name,
	    b.level_value,
	    b.level_value_application_id,
	    b.profile_option_value,
	    1 "PRIORITY"
  FROM fnd_profile_option_values b, fnd_profile_options a
  WHERE b.level_id = 10003
  AND   b.level_value = respId
  AND   b.level_value_application_id = respApplId
  AND   a.profile_option_id = b.profile_option_id
  AND   b.application_id = 672
  AND  a.profile_option_name in ('IBU_A_SR_ACCOUNT_OPTION',
                                 'IBU_A_SR_PROB_CODE_MANDATORY',
                                 'IBU_SR_CREATION_PRODUCT_OPTION',
                                 'IBU_SR_ADDR_DISPLAY',
                                 'IBU_SR_ADDR_MANDATORY',
                                 'IBU_A_SR_BILLTO_ADDRESS_OPTION',
                                 'IBU_A_SR_BILLTO_CONTACT_OPTION',
                                 'IBU_A_SR_SHIPTO_ADDRESS_OPTION',
                                 'IBU_A_SR_SHIPTO_CONTACT_OPTION',
                                 'IBU_A_SR_INSTALLEDAT_ADDRESS_OPTION',
                                 'IBU_A_SR_ATTACHMENT_OPTION',
                                 'IBU_SR_TASK_DISPLAY',
                                 'IBU_A_SR_ENABLE_INTERACTION_LOGGING',
                                 'IBU_SR_ENABLE_TEMPLATE',
                                 'IBU_A_SR_PRODUCT_SELECTION_OPTION')
  UNION
  SELECT a.profile_option_name,
	    b.level_value,
	    b.level_value_application_id,
	    b.profile_option_value,
	    2 "PRIORITY"
  FROM fnd_profile_option_values b, fnd_profile_options a
  WHERE b.level_id = 10002
  AND   b.level_value = respApplId
  AND   a.profile_option_id = b.profile_option_id
  AND   b.application_id = 672
  AND  a.profile_option_name in ('IBU_A_SR_ACCOUNT_OPTION',
                                 'IBU_A_SR_PROB_CODE_MANDATORY',
                                 'IBU_SR_CREATION_PRODUCT_OPTION',
                                 'IBU_SR_ADDR_DISPLAY',
                                 'IBU_SR_ADDR_MANDATORY',
                                 'IBU_A_SR_BILLTO_ADDRESS_OPTION',
                                 'IBU_A_SR_BILLTO_CONTACT_OPTION',
                                 'IBU_A_SR_SHIPTO_ADDRESS_OPTION',
                                 'IBU_A_SR_SHIPTO_CONTACT_OPTION',
                                 'IBU_A_SR_INSTALLEDAT_ADDRESS_OPTION',
                                 'IBU_A_SR_ATTACHMENT_OPTION',
                                 'IBU_SR_TASK_DISPLAY',
                                 'IBU_A_SR_ENABLE_INTERACTION_LOGGING',
                                 'IBU_SR_ENABLE_TEMPLATE',
                                 'IBU_A_SR_PRODUCT_SELECTION_OPTION')
  UNION
  SELECT a.profile_option_name,
	    b.level_value,
	    b.level_value_application_id,
	    b.profile_option_value,
	    3 "PRIORITY"
  FROM fnd_profile_option_values b, fnd_profile_options a
  WHERE b.level_id = 10001
  AND   a.profile_option_id = b.profile_option_id
  AND   b.application_id = 672
  AND  a.profile_option_name in ('IBU_A_SR_ACCOUNT_OPTION',
                                 'IBU_A_SR_PROB_CODE_MANDATORY',
                                 'IBU_SR_CREATION_PRODUCT_OPTION',
                                 'IBU_SR_ADDR_DISPLAY',
                                 'IBU_SR_ADDR_MANDATORY',
                                 'IBU_A_SR_BILLTO_ADDRESS_OPTION',
                                 'IBU_A_SR_BILLTO_CONTACT_OPTION',
                                 'IBU_A_SR_SHIPTO_ADDRESS_OPTION',
                                 'IBU_A_SR_SHIPTO_CONTACT_OPTION',
                                 'IBU_A_SR_INSTALLEDAT_ADDRESS_OPTION',
                                 'IBU_A_SR_ATTACHMENT_OPTION',
                                 'IBU_SR_TASK_DISPLAY',
                                 'IBU_A_SR_ENABLE_INTERACTION_LOGGING',
                                 'IBU_SR_ENABLE_TEMPLATE',
                                 'IBU_A_SR_PRODUCT_SELECTION_OPTION')
  ORDER BY PROFILE_OPTION_NAME, PRIORITY;
Line: 485

    l_ProfileTable.DELETE;
Line: 517

  l_newUpdateAddressRegionCode VARCHAR2(30) := 'IBU_CF_SR_25_G';
Line: 532

  l_newUpdateTemplateRegionCode VARCHAR2(30) := 'IBU_CF_SR_320_G';
Line: 534

  l_newUpdateViewRegionCode VARCHAR2(30) := 'IBU_CF_SR_440_G';
Line: 567

  l_newUpdateAddressExists BOOLEAN := FALSE;
Line: 580

  l_newUpdateTemplateExists BOOLEAN := FALSE;
Line: 583

  l_newUpdateViewExists BOOLEAN := FALSE;
Line: 599

  l_examineProdSelectOption BOOLEAN := TRUE;
Line: 619

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newPrimaryContactRegionCode,
                                               'IBU_CF_SR_ACCOUNT_NUMBER',
                                               'Y', 'N', null);
Line: 625

    ELSIF (l_profileOptionName = 'IBU_A_SR_PRODUCT_SELECTION_OPTION' AND l_examineProdSelectOption) THEN
      -- clone the regions
      l_newRegProductRegionCode := 'IBU_CF_SR_80_R' || p_respId;
Line: 635

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newRegProductRegionCode,
                                              'IBU_CF_SR_R_PROD_NAME_LOV',
                                              'Y', 'N', null);
Line: 648

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newAllProductRegionCode,
                                            'IBU_CF_SR_PROD_BY_NAME_LOV',
                                            'Y', 'N', null);
Line: 653

      l_examineProdSelectOption := FALSE;
Line: 654

      CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_PKG.Clone_Regions_For_Resp', 'Done with SR Product Selection Option');
Line: 669

      l_newUpdateAddressRegionCode := 'IBU_CF_SR_25_R' || p_respId;
Line: 678

                                     l_newUpdateAddressRegionCode,
                                     672, FALSE);
Line: 695

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newAddressRegionCode,
                                            'IBU_CF_SR_BILL_TO_HDR',
                                            'Y', 'N', null);
Line: 698

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newUpdateAddressRegionCode,
                                            'IBU_CF_SR_BILL_TO_HDR',
                                            'Y', 'N', null);
Line: 705

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newAddressRegionCode,
                                            'IBU_CF_SR_BILL_TO_ADDRESS',
                                            l_displayBillToAddress, 'N', null);
Line: 709

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newUpdateAddressRegionCode,
                                            'IBU_CF_SR_BILL_TO_ADDRESS',
                                            l_displayBillToAddress, 'N', null);
Line: 716

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newAddressRegionCode,
                                            'IBU_CF_SR_BILL_TO_CONTACT',
                                            l_displayBillToContact, 'N', null);
Line: 720

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newUpdateAddressRegionCode,
                                            'IBU_CF_SR_BILL_TO_CONTACT',
                                            l_displayBillToContact, 'N', null);
Line: 727

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newAddressRegionCode,
                                            'IBU_CF_SR_SHIP_TO_HDR',
                                            'Y', 'N', null);
Line: 731

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newUpdateAddressRegionCode,
                                            'IBU_CF_SR_SHIP_TO_HDR',
                                            'Y', 'N', null);
Line: 738

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newAddressRegionCode,
                                           'IBU_CF_SR_SHIP_TO_ADDRESS',
                                           l_displayShipToAddress, 'N', null);
Line: 742

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newUpdateAddressRegionCode,
                                           'IBU_CF_SR_SHIP_TO_ADDRESS',
                                           l_displayShipToAddress, 'N', null);
Line: 749

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newAddressRegionCode,
                                            'IBU_CF_SR_SHIP_TO_CONTACT',
                                            l_displayShipToContact, 'N', null);
Line: 753

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newUpdateAddressRegionCode,
                                            'IBU_CF_SR_SHIP_TO_CONTACT',
                                            l_displayShipToContact, 'N', null);
Line: 760

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newAddressRegionCode,
                                            'IBU_CF_SR_INSTALLED_AT_HDR',
                                            'Y', 'N', null);
Line: 764

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newUpdateAddressRegionCode,
                                            'IBU_CF_SR_INSTALLED_AT_HDR',
                                            'Y', 'N', null);
Line: 769

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newAddressRegionCode,
                                            'IBU_CF_SR_INSTALL_AT_ADDR',
                                            l_displayInstalledAtAddr, 'N', null);
Line: 773

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newUpdateAddressRegionCode,
                                            'IBU_CF_SR_INSTALL_AT_ADDR',
                                            l_displayInstalledAtAddr, 'N', null);
Line: 785

          CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newAddressRegionCode,
						'IBU_CF_SR_INCIDENT_ADDRESS_HDR',
						'Y', 'Y', null);
Line: 788

          CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newAddressRegionCode,
						'IBU_CF_SR_ADDRESS',
						'Y', 'Y', null);
Line: 791

          CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newAddressRegionCode,
						'IBU_CF_SR_CITY',
						'Y', 'Y', null);
Line: 794

          CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newAddressRegionCode,
						'IBU_CF_SR_STATE',
						'Y', 'Y', null);
Line: 797

          CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newAddressRegionCode,
						'IBU_CF_SR_PROVINCE',
						'Y', 'N', null);
Line: 800

          CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newAddressRegionCode,
						'IBU_CF_SR_POSTAL_CODE',
						'Y', 'N', null);
Line: 803

          CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newAddressRegionCode,
						'IBU_CF_SR_COUNTRY',
						'Y', 'Y', null);
Line: 806

          CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newAddressRegionCode,
						'IBU_CF_SR_COUNTY',
						'Y', 'N', null);
Line: 812

          CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newUpdateAddressRegionCode,
						'IBU_CF_SR_INCIDENT_ADDRESS_HDR',
						'Y', 'N', null);
Line: 815

          CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newUpdateAddressRegionCode,
						'IBU_CF_SR_ADDRESS',
						'Y', 'N', null);
Line: 818

          CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newUpdateAddressRegionCode,
						'IBU_CF_SR_CITY',
						'Y', 'N', null);
Line: 821

          CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newUpdateAddressRegionCode,
						'IBU_CF_SR_STATE',
						'Y', 'N', null);
Line: 824

          CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newUpdateAddressRegionCode,
						'IBU_CF_SR_PROVINCE',
						'Y', 'N', null);
Line: 827

          CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newUpdateAddressRegionCode,
						'IBU_CF_SR_POSTAL_CODE',
						'Y', 'N', null);
Line: 830

          CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newUpdateAddressRegionCode,
						'IBU_CF_SR_COUNTRY',
						'Y', 'N', null);
Line: 833

          CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newUpdateAddressRegionCode,
						'IBU_CF_SR_COUNTY',
						'Y', 'N', null);
Line: 839

          CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newAddressRegionCode,
                              'IBU_CF_SR_INCIDENT_ADDRESS_HDR',
						'Y', 'N', null);
Line: 842

          CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newAddressRegionCode,
						'IBU_CF_SR_ADDRESS',
						'Y', 'N', null);
Line: 845

          CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newAddressRegionCode,
						'IBU_CF_SR_CITY',
						'Y', 'N', null);
Line: 848

          CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newAddressRegionCode,
						'IBU_CF_SR_STATE',
						'Y', 'N', null);
Line: 851

          CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newAddressRegionCode,
						'IBU_CF_SR_PROVINCE',
						'Y', 'N', null);
Line: 854

          CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newAddressRegionCode,
						'IBU_CF_SR_POSTAL_CODE',
						'Y', 'N', null);
Line: 857

          CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newAddressRegionCode,
						'IBU_CF_SR_COUNTRY',
						'Y', 'N', null);
Line: 860

          CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newAddressRegionCode,
						'IBU_CF_SR_COUNTY',
						'Y', 'N', null);
Line: 864

          CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newUpdateAddressRegionCode,
                              'IBU_CF_SR_INCIDENT_ADDRESS_HDR',
						'Y', 'N', null);
Line: 867

          CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newUpdateAddressRegionCode,
						'IBU_CF_SR_ADDRESS',
						'Y', 'N', null);
Line: 870

          CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newUpdateAddressRegionCode,
						'IBU_CF_SR_CITY',
						'Y', 'N', null);
Line: 873

          CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newUpdateAddressRegionCode,
						'IBU_CF_SR_STATE',
						'Y', 'N', null);
Line: 876

          CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newUpdateAddressRegionCode,
						'IBU_CF_SR_PROVINCE',
						'Y', 'N', null);
Line: 879

          CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newUpdateAddressRegionCode,
						'IBU_CF_SR_POSTAL_CODE',
						'Y', 'N', null);
Line: 882

          CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newUpdateAddressRegionCode,
						'IBU_CF_SR_COUNTRY',
						'Y', 'N', null);
Line: 885

          CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newUpdateAddressRegionCode,
						'IBU_CF_SR_COUNTY',
						'Y', 'N', null);
Line: 891

          CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newAddressRegionCode,
						'IBU_CF_SR_INCIDENT_ADDRESS_HDR',
						'N', 'Y', null);
Line: 894

          CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newAddressRegionCode,
						'IBU_CF_SR_ADDRESS',
						'N', 'Y', null);
Line: 897

          CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newAddressRegionCode,
						'IBU_CF_SR_CITY',
						'N', 'Y', null);
Line: 900

          CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newAddressRegionCode,
						'IBU_CF_SR_STATE',
						'N', 'Y', null);
Line: 903

          CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newAddressRegionCode,
						'IBU_CF_SR_PROVINCE',
						'N', 'N', null);
Line: 906

          CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newAddressRegionCode,
						'IBU_CF_SR_POSTAL_CODE',
						'N', 'N', null);
Line: 909

          CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newAddressRegionCode,
						'IBU_CF_SR_COUNTRY',
						'N', 'Y', null);
Line: 912

          CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newAddressRegionCode,
						'IBU_CF_SR_COUNTY',
						'N', 'N', null);
Line: 939

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newIdentifyProductRegionCode,
					   'IBU_CF_SR_ALL_PRODUCT_RG',
					   'N', 'N', null);
Line: 943

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newTemplateProductRegionCode,
					   'IBU_CF_SR_ALL_PRODUCT_RG',
					   'N', 'N', null);
Line: 949

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newIdentifyProductRegionCode,
					   'IBU_CF_SR_REG_PRODUCT_RG',
					   'N', 'N', null);
Line: 953

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newTemplateProductRegionCode,
					   'IBU_CF_SR_REG_PRODUCT_RG',
					   'N', 'N', null);
Line: 965

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newProductFilterRegionCode,
					   'IBU_CF_SR_ALL_PRODUCT_RG',
					   'N', 'N', null);
Line: 970

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newProductFilterRegionCode,
					   'IBU_CF_SR_REG_PRODUCT_RG',
					   'N', 'N', null);
Line: 983

      IF (l_displayAttachment = 'DONOTSHOW' OR l_displayAttachment = 'SHOWDURINGUPDATE' OR l_mandatoryProblemCode = 'Y') THEN
        CS_CF_UPG_UTL_PKG.Clone_Region('IBU_CF_SR_40_G',
                                       672,
                                       l_newIdentifyProblemRegionCode,
                                       672, FALSE);
Line: 989

          CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newIdentifyProblemRegionCode,
                           'IBU_CF_SR_ATTACHMENTS_RG',
                           'N', 'N', null);
Line: 992

        ELSIF (l_displayAttachment = 'SHOWDURINGUPDATE') THEN
          CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newIdentifyProblemRegionCode,
                            'IBU_CF_SR_ATTACHMENTS_RG',
                            'N', 'N', null);
Line: 997

          CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newIdentifyProblemRegionCode,
                          'IBU_CF_SR_PROB_TYPE_CODE',
                          'Y', 'Y', null);
Line: 1011

          CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newDtlOverviewRegionCode,
                            'IBU_CF_SR_ATTACHMENTS_RG',
                            'N', 'N', null);
Line: 1015

          CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newDtlOverviewRegionCode,
                            'IBU_CF_SR_ATTACHMENTS_RG',
                            'N', 'N', null);
Line: 1033

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newProblemDetailsRegionCode,
                            'IBU_CF_SR_PROB_DETAILS',
                            'N', 'N', null);
Line: 1047

      CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newDtlProgOptionsRegionCode,
                            'IBU_CF_SR_DTL_PROGRESS_INTRCT',
                            'Y', 'N', null);
Line: 1059

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newDtlResolnRegionCode,
                            'IBU_CF_SR_DTL_ACTS_RG',
                            'Y', 'N', null);
Line: 1111

    select node_display_flag INTO
    l_displayRegProducts
    from ak_region_items
    where region_code = l_newIdentifyProductRegionCode
    and attribute_code = 'IBU_CF_SR_REG_PRODUCT_RG'
    and region_application_id = 672
    and attribute_application_id = 672;
Line: 1119

    select node_display_flag INTO
    l_displayAllProducts
    from ak_region_items
    where region_code = l_newIdentifyProductRegionCode
    and attribute_code = 'IBU_CF_SR_ALL_PRODUCT_RG'
    and region_application_id = 672
    and attribute_application_id = 672;
Line: 1152

  l_newUpdateAddressRegionCode := 'IBU_CF_SR_25_R' || p_respId;
Line: 1153

  OPEN does_region_already_exists(l_newUpdateAddressRegionCode, 672);
Line: 1158

    l_newUpdateAddressExists := TRUE;
Line: 1177

    select node_display_flag INTO
    l_displayAttachment
    from ak_region_items
    where region_code = l_newIdentifyProblemRegionCode
    and attribute_code = 'IBU_CF_SR_ATTACHMENTS_RG'
    and region_application_id = 672
    and attribute_application_id = 672;
Line: 1207

    select node_display_flag INTO
    l_enableTemplate
    from ak_region_items
    where region_code = l_newProblemDetailsRegionCode
    and attribute_code = 'IBU_CF_SR_PROB_DETAILS'
    and region_application_id = 672
    and attribute_application_id = 672;
Line: 1278

    select node_display_flag INTO
    l_displayTasks
    from ak_region_items
    where region_code = l_newDtlResolnRegionCode
    and attribute_code = 'IBU_CF_SR_DTL_ACTS_RG'
    and region_application_id = 672
    and attribute_application_id = 672;
Line: 1302

          CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newIdentifyProductRegionCode,
				    'IBU_CF_SR_REG_PRODUCT_RG',
				    'Y', 'N', l_newRegProductRegionCode);
Line: 1306

          CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newIdentifyProductRegionCode,
				    'IBU_CF_SR_REG_PRODUCT_RG',
				    l_displayRegProducts, 'N', l_newRegProductRegionCode);
Line: 1311

          CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newIdentifyProductRegionCode,
				    'IBU_CF_SR_ALL_PRODUCT_RG',
				    'Y', 'N', l_newAllProductRegionCode);
Line: 1315

          CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newIdentifyProductRegionCode,
				    'IBU_CF_SR_ALL_PRODUCT_RG',
				    l_displayAllProducts, 'N', l_newAllProductRegionCode);
Line: 1332

          CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newTemplateProductRegionCode,
				    'IBU_CF_SR_REG_PRODUCT_RG',
				    'N', 'N', 'IBU_CF_SR_REG_PRODUCT');
Line: 1337

          CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newTemplateProductRegionCode,
				    'IBU_CF_SR_ALL_PRODUCT_RG',
				    'N', 'N', 'IBU_CF_SR_ALL_PRODUCT');
Line: 1351

          CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newProductFilterRegionCode,
				    'IBU_CF_SR_REG_PRODUCT_RG',
				    'N', 'N', 'IBU_CF_SR_REG_PRODUCT');
Line: 1356

          CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newProductFilterRegionCode,
				    'IBU_CF_SR_ALL_PRODUCT_RG',
				    'N', 'N', 'IBU_CF_SR_ALL_PRODUCT');
Line: 1365

	 CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newIdentifyProblemRegionCode,
				    'IBU_CF_SR_PRIMARY_CONTACT_RG',
				    'Y', 'N', l_newPrimaryContactRegionCode);
Line: 1370

	 CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newIdentifyProblemRegionCode,
				    'IBU_CF_SR_IDENTIFY_PRODUCT_RG',
				    'Y', 'N', l_newIdentifyProductRegionCode);
Line: 1376

	 CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newIdentifyProblemRegionCode,
         			    'IBU_CF_SR_ADDRESS_RG',
         			    'N', 'N', l_newAddressRegionCode);
Line: 1384

	 CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newProblemDetailsRegionCode,
				    'IBU_CF_SR_PRIMARY_CONTACT_RG',
				    'Y', 'N', l_newPrimaryContactRegionCode);
Line: 1389

	 CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newIdentifyProblemRegionCode,
				    'IBU_CF_SR_ATTACHMENTS_RG',
				    'N', 'N', null);
Line: 1397

	 CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newProblemDetailsRegionCode,
         			    'IBU_CF_SR_ADDRESS_RG',
         			    'N', 'N', l_newAddressRegionCode);
Line: 1406

      CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newReviewRegionCode,
				    'IBU_CF_SR_ATTACHMENTS_RG',
	                   'N', 'N', null);
Line: 1411

	 CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newReviewRegionCode,
				    'IBU_CF_SR_ADDRESS_RG',
				    'Y', 'N', l_newAddressRegionCode);
Line: 1416

      CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newReviewRegionCode,
				    'IBU_CF_SR_PROB_DETAILS',
				    'N', 'N', null);
Line: 1424

      CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newContactInfoRegionCode,
				    'IBU_CF_SR_ADDRESS_RG',
	                   'Y', 'N', l_newAddressRegionCode);
Line: 1429

      CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newContactInfoRegionCode,
				    'IBU_CF_SR_PRIMARY_CONTACT_RG',
	                   'Y', 'N', l_newPrimaryContactRegionCode);
Line: 1436

  IF (l_newUpdateAddressExists) THEN
   --  need to clone the IBU_CF_SR_DTL_CONTACT region
   l_newDtlContactAddrRegionCode := 'IBU_CF_SR_210_R' || p_respId;
Line: 1443

    CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newDtlContactAddrRegionCode,
  				    'IBU_CF_SR_ADDRESS_RG',
                                    'Y', 'N', l_newUpdateAddressRegionCode);
Line: 1456

    CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newDtlProgressRegionCode,
				    'IBU_CF_SR_DTL_PROGRESS_OPT_RG',
                                    'Y', 'N', l_newDtlProgOptionsRegionCode);
Line: 1473

    IF (l_newUpdateAddressExists) THEN
      CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newDtlOverviewRegionCode,
    				    'IBU_CF_SR_ADDRESS_RG',
    	                   'N', 'N', l_newUpdateAddressRegionCode);
Line: 1479

      CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newDtlOverviewRegionCode,
				    'IBU_CF_SR_DTL_PROGRESS_RG',
	                   'Y', 'N', l_newDtlProgressRegionCode);
Line: 1484

      CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newDtlOverviewRegionCode,
				    'IBU_CF_SR_DTL_ACTS_RG',
	                   'Y', 'N', null);
Line: 1500

      CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newDtlTabsRegionCode,
				    'IBU_CF_SR_DTL_OVERVIEW_TAB_RG',
	                   'Y', 'N', l_newDtlOverviewRegionCode);
Line: 1505

      CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newDtlTabsRegionCode,
  			         'IBU_CF_SR_DTL_RESOLN_TAB_RG',
	                   'N', 'N', l_newDtlResolnRegionCode);
Line: 1520

      CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newDtlDetailsRegionCode,
				    'IBU_CF_SR_DTL_TABS_RG',
	                   'Y', 'N', l_newDtlTabsRegionCode);
Line: 1547

      CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newCreateTemplateRegionCode,
    				    'IBU_CF_SR_IDENTIFY_PRODUCT_RG',
                       'Y', 'N', l_newTemplateProductRegionCode);
Line: 1552

    l_newUpdateTemplateRegionCode := 'IBU_CF_SR_320_R' || p_respId;
Line: 1556

                                   l_newUpdateTemplateRegionCode,
                                   672, FALSE);
Line: 1564

      CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newUpdateTemplateRegionCode,
    				    'IBU_CF_SR_IDENTIFY_PRODUCT_RG',
    	                   'Y', 'N', l_newTemplateProductRegionCode);
Line: 1568

    l_newUpdateTemplateExists := TRUE;
Line: 1579

    CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newFilterRegionCode,
                                   'IBU_CF_SR_VW_PRODUCT_FILTER_RG',
	                   'Y', 'N', l_newProductFilterRegionCode);
Line: 1594

    CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newSearchViewRegionCode,
				    'IBU_CF_SR_VW_FILTER_RG',
	                   'Y', 'N', l_newFilterRegionCode);
Line: 1606

    CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newCreateViewRegionCode,
                                   'IBU_CF_SR_VW_FILTER_RG',
	                   'Y', 'N', l_newFilterRegionCode);
Line: 1612

    l_newUpdateViewRegionCode := 'IBU_CF_SR_440_R' || p_respId;
Line: 1616

                                   l_newUpdateViewRegionCode,
                                   672, FALSE);
Line: 1618

    CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newUpdateViewRegionCode,
				    'IBU_CF_SR_VW_FILTER_RG',
	                   'Y', 'N', l_newFilterRegionCode);
Line: 1622

    l_newUpdateViewExists := TRUE;
Line: 1629

    CS_CF_UPG_UTL_PKG.Insert_New_Target(
	   'IBU_SR_CR_IDENTIFY_PROBLEM',
	   'RESP',
	   l_respId,
	   l_respApplId,
	   NULL,
	   NULL,
        l_newIdentifyProblemRegionCode,
        '672');
Line: 1641

    CS_CF_UPG_UTL_PKG.Insert_New_Target(
        'IBU_SR_CR_REVIEW',
	   'RESP',
	   l_respId,
	   l_respApplId,
	   NULL,
	   NULL,
        l_newReviewRegionCode,
        '672');
Line: 1653

    CS_CF_UPG_UTL_PKG.Insert_New_Target(
        'IBU_SR_CR_PROBLEM_DETAILS',
	   'RESP',
	   l_respId,
	   l_respApplId,
	   NULL,
	   NULL,
        l_newProblemDetailsRegionCode,
        '672');
Line: 1666

    CS_CF_UPG_UTL_PKG.Insert_New_Target(
        'IBU_SR_CR_CONTACT_INFORMATION',
	   'RESP',
	   l_respId,
	   l_respApplId,
	   NULL,
	   NULL,
        l_newContactInfoRegionCode,
        '672');
Line: 1678

    CS_CF_UPG_UTL_PKG.Insert_New_Target(
        'IBU_SR_DETAILS',
	   'RESP',
	   l_respId,
	   l_respApplId,
	   NULL,
	   NULL,
        l_newDtlDetailsRegionCode,
        '672');
Line: 1690

    CS_CF_UPG_UTL_PKG.Insert_New_Target(
        'IBU_SR_TEMP_CREATE',
	   'RESP',
	   l_respId,
	   l_respApplId,
	   NULL,
	   NULL,
        l_newCreateTemplateRegionCode,
        '672');
Line: 1701

  IF (l_newUpdateTemplateExists) THEN
    CS_CF_UPG_UTL_PKG.Insert_New_Target(
        'IBU_SR_TEMP_UPDATE',
	   'RESP',
	   l_respId,
	   l_respApplId,
	   NULL,
	   NULL,
        l_newUpdateTemplateRegionCode,
        '672');
Line: 1714

    CS_CF_UPG_UTL_PKG.Insert_New_Target(
        'IBU_SR_VIEW_SUMMARY',
	   'RESP',
	   l_respId,
	   l_respApplId,
	   NULL,
	   NULL,
        l_newSearchViewRegionCode,
        '672');
Line: 1726

    CS_CF_UPG_UTL_PKG.Insert_New_Target(
        'IBU_SR_VIEW_CREATE',
	   'RESP',
	   l_respId,
	   l_respApplId,
	   NULL,
	   NULL,
        l_newCreateViewRegionCode,
        '672');
Line: 1737

  IF (l_newUpdateViewExists) THEN
    CS_CF_UPG_UTL_PKG.Insert_New_Target(
        'IBU_SR_VIEW_UPDATE',
	   'RESP',
	   l_respId,
	   l_respApplId,
	   NULL,
	   NULL,
        l_newUpdateViewRegionCode,
        '672');
Line: 1763

  SELECT a.profile_option_name,
	    b.level_value,
	    b.level_value_application_id,
	    b.profile_option_value,
	    1 "PRIORITY"
  FROM fnd_profile_option_values b, fnd_profile_options a
  WHERE b.level_id = 10002
  AND   b.level_value = applId
  AND   a.profile_option_id = b.profile_option_id
  AND   a.application_id = 672
  AND  a.profile_option_name in ('IBU_A_SR_ACCOUNT_OPTION',
                                 'IBU_A_SR_PROB_CODE_MANDATORY',
                                 'IBU_SR_CREATION_PRODUCT_OPTION',
                                 'IBU_SR_ADDR_DISPLAY',
                                 'IBU_SR_ADDR_MANDATORY',
                                 'IBU_A_SR_BILLTO_ADDRESS_OPTION',
                                 'IBU_A_SR_BILLTO_CONTACT_OPTION',
                                 'IBU_A_SR_SHIPTO_ADDRESS_OPTION',
                                 'IBU_A_SR_SHIPTO_CONTACT_OPTION',
                                 'IBU_A_SR_INSTALLEDAT_ADDRESS_OPTION',
                                 'IBU_A_SR_ATTACHMENT_OPTION',
                                 'IBU_SR_TASK_DISPLAY',
                                 'IBU_A_SR_ENABLE_INTERACTION_LOGGING',
                                 'IBU_SR_ENABLE_TEMPLATE',
                                 'IBU_A_SR_PRODUCT_SELECTION_OPTION')
  UNION
  SELECT a.profile_option_name,
	    b.level_value,
	    b.level_value_application_id,
	    b.profile_option_value,
	    2 "PRIORITY"
  FROM fnd_profile_option_values b, fnd_profile_options a
  WHERE b.level_id = 10001
  AND   a.profile_option_id = b.profile_option_id
  AND   a.application_id = 672
  AND  a.profile_option_name in ('IBU_A_SR_ACCOUNT_OPTION',
                                 'IBU_A_SR_PROB_CODE_MANDATORY',
                                 'IBU_SR_CREATION_PRODUCT_OPTION',
                                 'IBU_SR_ADDR_DISPLAY',
                                 'IBU_SR_ADDR_MANDATORY',
                                 'IBU_A_SR_BILLTO_ADDRESS_OPTION',
                                 'IBU_A_SR_BILLTO_CONTACT_OPTION',
                                 'IBU_A_SR_SHIPTO_ADDRESS_OPTION',
                                 'IBU_A_SR_SHIPTO_CONTACT_OPTION',
                                 'IBU_A_SR_INSTALLEDAT_ADDRESS_OPTION',
                                 'IBU_A_SR_ATTACHMENT_OPTION',
                                 'IBU_SR_TASK_DISPLAY',
                                 'IBU_A_SR_ENABLE_INTERACTION_LOGGING',
                                 'IBU_SR_ENABLE_TEMPLATE',
                                 'IBU_A_SR_PRODUCT_SELECTION_OPTION')
  ORDER BY PROFILE_OPTION_NAME, PRIORITY;
Line: 1863

    l_ProfileTable.DELETE;
Line: 1904

  l_newUpdateAddressRegionCode VARCHAR2(30) := 'IBU_CF_SR_25_G';
Line: 1919

  l_newUpdateTemplateRegionCode VARCHAR2(30) := 'IBU_CF_SR_320_G';
Line: 1921

  l_newUpdateViewRegionCode VARCHAR2(30) := 'IBU_CF_SR_440_G';
Line: 1949

  l_newUpdateAddressExists BOOLEAN := FALSE;
Line: 1962

  l_newUpdateTemplateExists BOOLEAN := FALSE;
Line: 1965

  l_newUpdateViewExists BOOLEAN := FALSE;
Line: 1981

  l_examineProdSelectOption BOOLEAN := TRUE;
Line: 2002

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newPrimaryContactRegionCode,
                                              'IBU_CF_SR_ACCOUNT_NUMBER',
                                              'Y', 'N', null);
Line: 2009

    ELSIF (l_profileOptionName = 'IBU_A_SR_PRODUCT_SELECTION_OPTION' AND l_examineProdSelectOption) THEN
      -- clone the regions
      l_newRegProductRegionCode := 'IBU_CF_SR_80_GC';
Line: 2020

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newRegProductRegionCode,
                                              'IBU_CF_SR_R_PROD_NAME_LOV',
                                              'Y', 'N', null);
Line: 2033

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newAllProductRegionCode,
                                              'IBU_CF_SR_PROD_BY_NAME_LOV',
                                              'Y', 'N', null);
Line: 2038

      l_examineProdSelectOption := FALSE;
Line: 2039

      CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_PKG.Clone_Regions_For_Global', 'Done with SR Product Selection Option');
Line: 2058

      l_newUpdateAddressRegionCode := 'IBU_CF_SR_25_GC';
Line: 2062

							l_newUpdateAddressRegionCode,
							672, TRUE);
Line: 2079

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newAddressRegionCode,
					'IBU_CF_SR_BILL_TO_HDR',
                                        'Y', 'N', null);
Line: 2082

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newUpdateAddressRegionCode,
					'IBU_CF_SR_BILL_TO_HDR',
                                        'Y', 'N', null);
Line: 2089

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newAddressRegionCode,
						'IBU_CF_SR_BILL_TO_ADDRESS',
						l_displayBillToAddress, 'N', null);
Line: 2092

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newUpdateAddressRegionCode,
						'IBU_CF_SR_BILL_TO_ADDRESS',
						l_displayBillToAddress, 'N', null);
Line: 2099

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newAddressRegionCode,
						'IBU_CF_SR_BILL_TO_CONTACT',
						l_displayBillToContact, 'N', null);
Line: 2103

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newUpdateAddressRegionCode,
						'IBU_CF_SR_BILL_TO_CONTACT',
						l_displayBillToContact, 'N', null);
Line: 2110

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newAddressRegionCode,
						'IBU_CF_SR_SHIP_TO_HDR',
						'Y', 'N', null);
Line: 2113

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newUpdateAddressRegionCode,
						'IBU_CF_SR_SHIP_TO_HDR',
						'Y', 'N', null);
Line: 2120

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newAddressRegionCode,
                              'IBU_CF_SR_SHIP_TO_ADDRESS',
						l_displayShipToAddress, 'N', null);
Line: 2123

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newUpdateAddressRegionCode,
                              'IBU_CF_SR_SHIP_TO_ADDRESS',
						l_displayShipToAddress, 'N', null);
Line: 2131

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newAddressRegionCode,
						'IBU_CF_SR_SHIP_TO_CONTACT',
						l_displayShipToContact, 'N', null);
Line: 2134

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newUpdateAddressRegionCode,
						'IBU_CF_SR_SHIP_TO_CONTACT',
						l_displayShipToContact, 'N', null);
Line: 2141

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newAddressRegionCode,
						'IBU_CF_SR_INSTALLED_AT_HDR',
						'Y', 'N', null);
Line: 2144

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newUpdateAddressRegionCode,
						'IBU_CF_SR_INSTALLED_AT_HDR',
						'Y', 'N', null);
Line: 2148

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newAddressRegionCode,
						'IBU_CF_SR_INSTALL_AT_ADDR',
						l_displayInstalledAtAddr, 'N', null);
Line: 2152

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newUpdateAddressRegionCode,
						'IBU_CF_SR_INSTALL_AT_ADDR',
						l_displayInstalledAtAddr, 'N', null);
Line: 2163

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newAddressRegionCode,
						'IBU_CF_SR_INCIDENT_ADDRESS_HDR',
						'Y', 'Y', null);
Line: 2166

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newAddressRegionCode,
						'IBU_CF_SR_ADDRESS',
						'Y', 'Y', null);
Line: 2169

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newAddressRegionCode,
						'IBU_CF_SR_CITY',
						'Y', 'Y', null);
Line: 2172

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newAddressRegionCode,
						'IBU_CF_SR_STATE',
						'Y', 'Y', null);
Line: 2175

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newAddressRegionCode,
						'IBU_CF_SR_PROVINCE',
						'Y', 'N', null);
Line: 2178

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newAddressRegionCode,
						'IBU_CF_SR_POSTAL_CODE',
						'Y', 'N', null);
Line: 2181

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newAddressRegionCode,
						'IBU_CF_SR_COUNTRY',
						'Y', 'Y', null);
Line: 2184

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newAddressRegionCode,
						'IBU_CF_SR_COUNTY',
						'Y', 'N', null);
Line: 2189

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newUpdateAddressRegionCode,
						'IBU_CF_SR_INCIDENT_ADDRESS_HDR',
						'Y', 'N', null);
Line: 2192

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newUpdateAddressRegionCode,
						'IBU_CF_SR_ADDRESS',
						'Y', 'N', null);
Line: 2195

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newUpdateAddressRegionCode,
						'IBU_CF_SR_CITY',
						'Y', 'N', null);
Line: 2198

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newUpdateAddressRegionCode,
						'IBU_CF_SR_STATE',
						'Y', 'N', null);
Line: 2201

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newUpdateAddressRegionCode,
						'IBU_CF_SR_PROVINCE',
						'Y', 'N', null);
Line: 2204

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newUpdateAddressRegionCode,
						'IBU_CF_SR_POSTAL_CODE',
						'Y', 'N', null);
Line: 2207

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newUpdateAddressRegionCode,
						'IBU_CF_SR_COUNTRY',
						'Y', 'N', null);
Line: 2210

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newUpdateAddressRegionCode,
						'IBU_CF_SR_COUNTY',
						'Y', 'N', null);
Line: 2215

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newAddressRegionCode,
                              'IBU_CF_SR_INCIDENT_ADDRESS_HDR',
						'Y', 'N', null);
Line: 2218

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newAddressRegionCode,
						'IBU_CF_SR_ADDRESS',
						'Y', 'N', null);
Line: 2221

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newAddressRegionCode,
						'IBU_CF_SR_CITY',
						'Y', 'N', null);
Line: 2224

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newAddressRegionCode,
						'IBU_CF_SR_STATE',
						'Y', 'N', null);
Line: 2227

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newAddressRegionCode,
						'IBU_CF_SR_PROVINCE',
						'Y', 'N', null);
Line: 2230

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newAddressRegionCode,
						'IBU_CF_SR_POSTAL_CODE',
						'Y', 'N', null);
Line: 2233

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newAddressRegionCode,
						'IBU_CF_SR_COUNTRY',
						'Y', 'N', null);
Line: 2236

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newAddressRegionCode,
						'IBU_CF_SR_COUNTY',
						'Y', 'N', null);
Line: 2240

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newUpdateAddressRegionCode,
                              'IBU_CF_SR_INCIDENT_ADDRESS_HDR',
						'Y', 'N', null);
Line: 2243

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newUpdateAddressRegionCode,
						'IBU_CF_SR_ADDRESS',
						'Y', 'N', null);
Line: 2246

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newUpdateAddressRegionCode,
						'IBU_CF_SR_CITY',
						'Y', 'N', null);
Line: 2249

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newUpdateAddressRegionCode,
						'IBU_CF_SR_STATE',
						'Y', 'N', null);
Line: 2252

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newUpdateAddressRegionCode,
						'IBU_CF_SR_PROVINCE',
						'Y', 'N', null);
Line: 2255

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newUpdateAddressRegionCode,
						'IBU_CF_SR_POSTAL_CODE',
						'Y', 'N', null);
Line: 2258

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newUpdateAddressRegionCode,
						'IBU_CF_SR_COUNTRY',
						'Y', 'N', null);
Line: 2261

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newUpdateAddressRegionCode,
						'IBU_CF_SR_COUNTY',
						'Y', 'N', null);
Line: 2266

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newAddressRegionCode,
					'IBU_CF_SR_INCIDENT_ADDRESS_HDR',
						'N', 'Y', null);
Line: 2269

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newAddressRegionCode,
						'IBU_CF_SR_ADDRESS',
						'N', 'Y', null);
Line: 2272

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newAddressRegionCode,
						'IBU_CF_SR_CITY',
						'N', 'Y', null);
Line: 2275

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newAddressRegionCode,
						'IBU_CF_SR_STATE',
						'N', 'Y', null);
Line: 2278

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newAddressRegionCode,
						'IBU_CF_SR_PROVINCE',
						'N', 'N', null);
Line: 2281

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newAddressRegionCode,
						'IBU_CF_SR_POSTAL_CODE',
						'N', 'N', null);
Line: 2284

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newAddressRegionCode,
						'IBU_CF_SR_COUNTRY',
						'N', 'Y', null);
Line: 2287

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newAddressRegionCode,
						'IBU_CF_SR_COUNTY',
						'N', 'N', null);
Line: 2315

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newIdentifyProductRegionCode,
					   'IBU_CF_SR_ALL_PRODUCT_RG',
					   'N', 'N', null);
Line: 2319

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newTemplateProductRegionCode,
					   'IBU_CF_SR_ALL_PRODUCT_RG',
					   'N', 'N', null);
Line: 2324

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newIdentifyProductRegionCode,
				   'IBU_CF_SR_REG_PRODUCT_RG',
					   'N', 'N', null);
Line: 2328

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newTemplateProductRegionCode,
                                           'IBU_CF_SR_REG_PRODUCT_RG',
                                           'N', 'N', null);
Line: 2340

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newProductFilterRegionCode,
					   'IBU_CF_SR_ALL_PRODUCT_RG',
					   'N', 'N', null);
Line: 2345

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newProductFilterRegionCode,
					   'IBU_CF_SR_REG_PRODUCT_RG',
					   'N', 'N', null);
Line: 2358

      IF (l_displayAttachment = 'DONOTSHOW' OR l_displayAttachment = 'SHOWDURINGUPDATE' OR l_mandatoryProblemCode = 'Y') THEN
        CS_CF_UPG_UTL_PKG.Clone_Region('IBU_CF_SR_40_G',
                                       672,
                                       l_newIdentifyProblemRegionCode,
                                       672, TRUE);
Line: 2364

          CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newIdentifyProblemRegionCode,
                            'IBU_CF_SR_ATTACHMENTS_RG',
					   'N', 'N', null);
Line: 2367

        ELSIF (l_displayAttachment = 'SHOWDURINGUPDATE') THEN
          CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newIdentifyProblemRegionCode,
                            'IBU_CF_SR_ATTACHMENTS_RG',
					   'N', 'N', null);
Line: 2372

          CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newIdentifyProblemRegionCode,
                            'IBU_CF_SR_PROB_TYPE_CODE',
					   'Y', 'Y', null);
Line: 2386

          CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newDtlOverviewRegionCode,
                            'IBU_CF_SR_ATTACHMENTS_RG',
					   'N', 'N', null);
Line: 2390

          CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newDtlOverviewRegionCode,
                            'IBU_CF_SR_ATTACHMENTS_RG',
					   'N', 'N', null);
Line: 2406

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newProblemDetailsRegionCode,
                            'IBU_CF_SR_PROB_DETAILS',
					   'N', 'N', null);
Line: 2419

      CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newDtlProgOptionsRegionCode,
                            'IBU_CF_SR_DTL_PROGRESS_INTRCT',
					   'Y', 'N', null);
Line: 2431

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newDtlResolnRegionCode,
                            'IBU_CF_SR_DTL_ACTS_RG',
					   'Y', 'N', null);
Line: 2483

    select node_display_flag INTO
    l_displayRegProducts
    from ak_region_items
    where region_code = l_newIdentifyProductRegionCode
    and attribute_code = 'IBU_CF_SR_REG_PRODUCT_RG'
    and region_application_id = 672
    and attribute_application_id = 672;
Line: 2491

    select node_display_flag INTO
    l_displayAllProducts
    from ak_region_items
    where region_code = l_newIdentifyProductRegionCode
    and attribute_code = 'IBU_CF_SR_ALL_PRODUCT_RG'
    and region_application_id = 672
    and attribute_application_id = 672;
Line: 2525

  l_newUpdateAddressRegionCode := 'IBU_CF_SR_25_GC';
Line: 2526

  OPEN does_region_already_exists(l_newUpdateAddressRegionCode, 672);
Line: 2531

    l_newUpdateAddressExists := TRUE;
Line: 2549

    select node_display_flag INTO
    l_displayAttachment
    from ak_region_items
    where region_code = l_newIdentifyProblemRegionCode
    and attribute_code = 'IBU_CF_SR_ATTACHMENTS_RG'
    and region_application_id = 672
    and attribute_application_id = 672;
Line: 2579

    select node_display_flag INTO
    l_enableTemplate
    from ak_region_items
    where region_code = l_newProblemDetailsRegionCode
    and attribute_code = 'IBU_CF_SR_PROB_DETAILS'
    and region_application_id = 672
    and attribute_application_id = 672;
Line: 2649

    select node_display_flag INTO
    l_displayTasks
    from ak_region_items
    where region_code = l_newDtlResolnRegionCode
    and attribute_code = 'IBU_CF_SR_DTL_ACTS_RG'
    and region_application_id = 672
    and attribute_application_id = 672;
Line: 2673

          CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newIdentifyProductRegionCode,
                                    'IBU_CF_SR_REG_PRODUCT_RG',
                                    'Y', 'N', l_newRegProductRegionCode);
Line: 2677

          CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newIdentifyProductRegionCode,
                                    'IBU_CF_SR_REG_PRODUCT_RG',
                                    l_displayRegProducts, 'N', l_newRegProductRegionCode);
Line: 2682

          CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newIdentifyProductRegionCode,
                                    'IBU_CF_SR_ALL_PRODUCT_RG',
                                    'Y', 'N', l_newAllProductRegionCode);
Line: 2686

          CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newIdentifyProductRegionCode,
                                    'IBU_CF_SR_ALL_PRODUCT_RG',
                                    l_displayAllProducts, 'N', l_newAllProductRegionCode);
Line: 2703

          CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newTemplateProductRegionCode,
                                    'IBU_CF_SR_REG_PRODUCT_RG',
                                    'N', 'N', 'IBU_CF_SR_REG_PRODUCT');
Line: 2708

          CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newTemplateProductRegionCode,
                                    'IBU_CF_SR_ALL_PRODUCT_RG',
                                    'N', 'N', 'IBU_CF_SR_ALL_PRODUCT');
Line: 2722

          CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newProductFilterRegionCode,
                                    'IBU_CF_SR_REG_PRODUCT_RG',
                                    'N', 'N', 'IBU_CF_SR_REG_PRODUCT');
Line: 2727

          CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newProductFilterRegionCode,
                                    'IBU_CF_SR_ALL_PRODUCT_RG',
                                    'N', 'N', 'IBU_CF_SR_ALL_PRODUCT');
Line: 2736

      CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newIdentifyProblemRegionCode,
				    'IBU_CF_SR_PRIMARY_CONTACT_RG',
				    'Y', 'N', l_newPrimaryContactRegionCode);
Line: 2741

      CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newIdentifyProblemRegionCode,
				    'IBU_CF_SR_IDENTIFY_PRODUCT_RG',
				    'Y', 'N', l_newIdentifyProductRegionCode);
Line: 2747

      CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newIdentifyProblemRegionCode,
				    'IBU_CF_SR_ADDRESS_RG',
				    'N', 'N', l_newAddressRegionCode);
Line: 2755

      CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newProblemDetailsRegionCode,
				    'IBU_CF_SR_PRIMARY_CONTACT_RG',
				    'Y', 'N', l_newPrimaryContactRegionCode);
Line: 2760

      CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newIdentifyProblemRegionCode,
				    'IBU_CF_SR_ATTACHMENTS_RG',
				    'N', 'N', null);
Line: 2768

      CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newProblemDetailsRegionCode,
				    'IBU_CF_SR_ADDRESS_RG',
				    'N', 'N', l_newAddressRegionCode);
Line: 2777

      CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newReviewRegionCode,
				    'IBU_CF_SR_ATTACHMENTS_RG',
	                   'N', 'N', null);
Line: 2782

	 CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newReviewRegionCode,
				    'IBU_CF_SR_ADDRESS_RG',
				    'Y', 'N', l_newAddressRegionCode);
Line: 2787

      CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newReviewRegionCode,
				    'IBU_CF_SR_PROB_DETAILS',
				    'N', 'N', null);
Line: 2795

      CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newContactInfoRegionCode,
				    'IBU_CF_SR_ADDRESS_RG',
	                   'Y', 'N', l_newAddressRegionCode);
Line: 2800

      CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newContactInfoRegionCode,
				    'IBU_CF_SR_PRIMARY_CONTACT_RG',
	                   'Y', 'N', l_newPrimaryContactRegionCode);
Line: 2806

  IF (l_newUpdateAddressExists) THEN

    -- need to clone the IBU_CF_SR_DTL_CONTACT region
    l_newDtlContactAddrRegionCode := 'IBU_CF_SR_210_GC' ;
Line: 2814

    CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newDtlContactAddrRegionCode,
  				    'IBU_CF_SR_ADDRESS_RG',
  	                   'Y', 'N', l_newUpdateAddressRegionCode);
Line: 2828

    CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newDtlProgressRegionCode,
				    'IBU_CF_SR_DTL_PROGRESS_OPT_RG',
	                   'Y', 'N', l_newDtlProgOptionsRegionCode);
Line: 2845

      IF (l_newUpdateAddressExists) THEN
        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newDtlOverviewRegionCode,
      				    'IBU_CF_SR_ADDRESS_RG',
      	                   'N', 'N', l_newUpdateAddressRegionCode);
Line: 2851

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newDtlOverviewRegionCode,
				    'IBU_CF_SR_DTL_PROGRESS_RG',
	                   'Y', 'N', l_newDtlProgressRegionCode);
Line: 2856

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newDtlOverviewRegionCode,
				    'IBU_CF_SR_DTL_ACTS_RG',
	                   'Y', 'N', null);
Line: 2872

      CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newDtlTabsRegionCode,
				    'IBU_CF_SR_DTL_OVERVIEW_TAB_RG',
	                   'Y', 'N', l_newDtlOverviewRegionCode);
Line: 2877

      CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newDtlTabsRegionCode,
  			         'IBU_CF_SR_DTL_RESOLN_TAB_RG',
	                   'N', 'N', l_newDtlResolnRegionCode);
Line: 2892

      CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newDtlDetailsRegionCode,
				    'IBU_CF_SR_DTL_TABS_RG',
	                   'Y', 'N', l_newDtlTabsRegionCode);
Line: 2913

      CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newCreateTemplateRegionCode,
				    'IBU_CF_SR_IDENTIFY_PRODUCT_RG',
	                   'Y', 'N', l_newTemplateProductRegionCode);
Line: 2918

    l_newUpdateTemplateRegionCode := 'IBU_CF_SR_320_GC' ;
Line: 2921

							l_newUpdateTemplateRegionCode,
							672, TRUE);
Line: 2929

      CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newUpdateTemplateRegionCode,
				    'IBU_CF_SR_IDENTIFY_PRODUCT_RG',
	                   'Y', 'N', l_newTemplateProductRegionCode);
Line: 2933

    l_newUpdateTemplateExists := TRUE;
Line: 2944

    CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newFilterRegionCode,
				    'IBU_CF_SR_VW_PRODUCT_FILTER_RG',
	                   'Y', 'N', l_newProductFilterRegionCode);
Line: 2958

    CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newSearchViewRegionCode,
				    'IBU_CF_SR_VW_FILTER_RG',
	                   'Y', 'N', l_newFilterRegionCode);
Line: 2969

    CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newCreateViewRegionCode,
				    'IBU_CF_SR_VW_FILTER_RG',
	                   'Y', 'N', l_newFilterRegionCode);
Line: 2975

    l_newUpdateViewRegionCode := 'IBU_CF_SR_440_GC' ;
Line: 2978

							l_newUpdateViewRegionCode,
							672, TRUE);
Line: 2980

    CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newUpdateViewRegionCode,
				    'IBU_CF_SR_VW_FILTER_RG',
	                   'Y', 'N', l_newFilterRegionCode);
Line: 2984

    l_newUpdateViewExists := TRUE;
Line: 2991

    CS_CF_UPG_UTL_PKG.Insert_New_Target(
	   'IBU_SR_CR_IDENTIFY_PROBLEM',
	   'GLOBAL',
	   NULL,
	   NULL,
	   NULL,
	   NULL,
        l_newIdentifyProblemRegionCode,
        '672');
Line: 3003

    CS_CF_UPG_UTL_PKG.Insert_New_Target(
        'IBU_SR_CR_REVIEW',
	   'GLOBAL',
	   NULL,
	   NULL,
	   NULL,
	   NULL,
        l_newReviewRegionCode,
        '672');
Line: 3015

    CS_CF_UPG_UTL_PKG.Insert_New_Target(
        'IBU_SR_CR_PROBLEM_DETAILS',
	   'GLOBAL',
	   NULL,
	   NULL,
	   NULL,
	   NULL,
        l_newProblemDetailsRegionCode,
        '672');
Line: 3028

    CS_CF_UPG_UTL_PKG.Insert_New_Target(
        'IBU_SR_CR_CONTACT_INFORMATION',
	   'GLOBAL',
	   NULL,
	   NULL,
	   NULL,
	   NULL,
        l_newContactInfoRegionCode,
        '672');
Line: 3040

    CS_CF_UPG_UTL_PKG.Insert_New_Target(
        'IBU_SR_DETAILS',
	   'GLOBAL',
	   NULL,
	   NULL,
	   NULL,
	   NULL,
        l_newDtlDetailsRegionCode,
        '672');
Line: 3052

    CS_CF_UPG_UTL_PKG.Insert_New_Target(
        'IBU_SR_TEMP_CREATE',
	   'GLOBAL',
	   NULL,
	   NULL,
	   NULL,
	   NULL,
        l_newCreateTemplateRegionCode,
        '672');
Line: 3063

  IF (l_newUpdateTemplateExists) THEN
    CS_CF_UPG_UTL_PKG.Insert_New_Target(
        'IBU_SR_TEMP_UPDATE',
	   'GLOBAL',
	   NULL,
	   NULL,
	   NULL,
	   NULL,
        l_newUpdateTemplateRegionCode,
        '672');
Line: 3076

    CS_CF_UPG_UTL_PKG.Insert_New_Target(
        'IBU_SR_VIEW_SUMMARY',
	   'GLOBAL',
	   NULL,
	   NULL,
	   NULL,
	   NULL,
        l_newSearchViewRegionCode,
        '672');
Line: 3088

    CS_CF_UPG_UTL_PKG.Insert_New_Target(
        'IBU_SR_VIEW_CREATE',
	   'GLOBAL',
	   NULL,
	   NULL,
	   NULL,
	   NULL,
        l_newCreateViewRegionCode,
        '672');
Line: 3099

  IF (l_newUpdateViewExists) THEN
    CS_CF_UPG_UTL_PKG.Insert_New_Target(
        'IBU_SR_VIEW_UPDATE',
	   'GLOBAL',
	   NULL,
	   NULL,
	   NULL,
	   NULL,
        l_newUpdateViewRegionCode,
        '672');
Line: 3129

  l_newUpdateAddressRegionCode VARCHAR2(30) := 'IBU_CF_SR_25_G';
Line: 3144

  l_newUpdateTemplateRegionCode VARCHAR2(30) := 'IBU_CF_SR_320_G';
Line: 3146

  l_newUpdateViewRegionCode VARCHAR2(30) := 'IBU_CF_SR_440_G';
Line: 3176

  l_newUpdateAddressExists BOOLEAN := FALSE;
Line: 3189

  l_newUpdateTemplateExists BOOLEAN := FALSE;
Line: 3192

  l_newUpdateViewExists BOOLEAN := FALSE;
Line: 3208

  l_examineProdSelectOption BOOLEAN := TRUE;
Line: 3229

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newPrimaryContactRegionCode,
                                              'IBU_CF_SR_ACCOUNT_NUMBER',
                                              'Y', 'N', null);
Line: 3236

    ELSIF (l_profileOptionName = 'IBU_A_SR_PRODUCT_SELECTION_OPTION' AND l_examineProdSelectOption) THEN
      -- clone the regions
      l_newRegProductRegionCode := 'IBU_CF_SR_80_A' || p_ApplId;
Line: 3247

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newRegProductRegionCode,
                                              'IBU_CF_SR_R_PROD_NAME_LOV',
                                              'Y', 'N', null);
Line: 3260

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newAllProductRegionCode,
                                              'IBU_CF_SR_PROD_BY_NAME_LOV',
                                              'Y', 'N', null);
Line: 3265

      l_examineProdSelectOption := FALSE;
Line: 3266

      CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_PKG.Clone_Regions_For_Appl', 'Done with SR Product Selection Option');
Line: 3286

      l_newUpdateAddressRegionCode := 'IBU_CF_SR_25_A' || p_ApplId;
Line: 3290

							l_newUpdateAddressRegionCode,
							672,FALSE);
Line: 3306

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newAddressRegionCode,
					'IBU_CF_SR_BILL_TO_HDR',
                                        'Y', 'N', null);
Line: 3310

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newUpdateAddressRegionCode,
					'IBU_CF_SR_BILL_TO_HDR',
                                        'Y', 'N', null);
Line: 3317

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newAddressRegionCode,
						'IBU_CF_SR_BILL_TO_ADDRESS',
						l_displayBillToAddress, 'N', null);
Line: 3321

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newUpdateAddressRegionCode,
						'IBU_CF_SR_BILL_TO_ADDRESS',
						l_displayBillToAddress, 'N', null);
Line: 3328

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newAddressRegionCode,
						'IBU_CF_SR_BILL_TO_CONTACT',
						l_displayBillToContact, 'N', null);
Line: 3332

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newUpdateAddressRegionCode,
						'IBU_CF_SR_BILL_TO_CONTACT',
						l_displayBillToContact, 'N', null);
Line: 3340

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newAddressRegionCode,
						'IBU_CF_SR_SHIP_TO_HDR',
						'Y', 'N', null);
Line: 3344

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newUpdateAddressRegionCode,
						'IBU_CF_SR_SHIP_TO_HDR',
						'Y', 'N', null);
Line: 3351

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newAddressRegionCode,
                              'IBU_CF_SR_SHIP_TO_ADDRESS',
						l_displayShipToAddress, 'N', null);
Line: 3355

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newUpdateAddressRegionCode,
                              'IBU_CF_SR_SHIP_TO_ADDRESS',
						l_displayShipToAddress, 'N', null);
Line: 3362

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newAddressRegionCode,
						'IBU_CF_SR_SHIP_TO_CONTACT',
						l_displayShipToContact, 'N', null);
Line: 3366

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newUpdateAddressRegionCode,
						'IBU_CF_SR_SHIP_TO_CONTACT',
						l_displayShipToContact, 'N', null);
Line: 3373

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newAddressRegionCode,
						'IBU_CF_SR_INSTALLED_AT_HDR',
						'Y', 'N', null);
Line: 3377

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newUpdateAddressRegionCode,
						'IBU_CF_SR_INSTALLED_AT_HDR',
						'Y', 'N', null);
Line: 3382

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newAddressRegionCode,
						'IBU_CF_SR_INSTALL_AT_ADDR',
						l_displayInstalledAtAddr, 'N', null);
Line: 3386

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newUpdateAddressRegionCode,
						'IBU_CF_SR_INSTALL_AT_ADDR',
						l_displayInstalledAtAddr, 'N', null);
Line: 3398

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newAddressRegionCode,
						'IBU_CF_SR_INCIDENT_ADDRESS_HDR',
						'Y', 'Y', null);
Line: 3401

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newAddressRegionCode,
						'IBU_CF_SR_ADDRESS',
						'Y', 'Y', null);
Line: 3404

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newAddressRegionCode,
						'IBU_CF_SR_CITY',
						'Y', 'Y', null);
Line: 3407

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newAddressRegionCode,
						'IBU_CF_SR_STATE',
						'Y', 'Y', null);
Line: 3410

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newAddressRegionCode,
						'IBU_CF_SR_PROVINCE',
						'Y', 'N', null);
Line: 3413

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newAddressRegionCode,
						'IBU_CF_SR_POSTAL_CODE',
						'Y', 'N', null);
Line: 3416

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newAddressRegionCode,
						'IBU_CF_SR_COUNTRY',
						'Y', 'Y', null);
Line: 3419

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newAddressRegionCode,
						'IBU_CF_SR_COUNTY',
						'Y', 'N', null);
Line: 3423

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newUpdateAddressRegionCode,
						'IBU_CF_SR_INCIDENT_ADDRESS_HDR',
						'Y', 'N', null);
Line: 3426

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newUpdateAddressRegionCode,
						'IBU_CF_SR_ADDRESS',
						'Y', 'N', null);
Line: 3429

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newUpdateAddressRegionCode,
						'IBU_CF_SR_CITY',
						'Y', 'N', null);
Line: 3432

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newUpdateAddressRegionCode,
						'IBU_CF_SR_STATE',
						'Y', 'N', null);
Line: 3435

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newUpdateAddressRegionCode,
						'IBU_CF_SR_PROVINCE',
						'Y', 'N', null);
Line: 3438

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newUpdateAddressRegionCode,
						'IBU_CF_SR_POSTAL_CODE',
						'Y', 'N', null);
Line: 3441

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newUpdateAddressRegionCode,
						'IBU_CF_SR_COUNTRY',
						'Y', 'N', null);
Line: 3444

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newUpdateAddressRegionCode,
						'IBU_CF_SR_COUNTY',
						'Y', 'N', null);
Line: 3449

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newAddressRegionCode,
                              'IBU_CF_SR_INCIDENT_ADDRESS_HDR',
						'Y', 'N', null);
Line: 3452

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newAddressRegionCode,
						'IBU_CF_SR_ADDRESS',
						'Y', 'N', null);
Line: 3455

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newAddressRegionCode,
						'IBU_CF_SR_CITY',
						'Y', 'N', null);
Line: 3458

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newAddressRegionCode,
						'IBU_CF_SR_STATE',
						'Y', 'N', null);
Line: 3461

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newAddressRegionCode,
						'IBU_CF_SR_PROVINCE',
						'Y', 'N', null);
Line: 3464

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newAddressRegionCode,
						'IBU_CF_SR_POSTAL_CODE',
						'Y', 'N', null);
Line: 3467

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newAddressRegionCode,
						'IBU_CF_SR_COUNTRY',
						'Y', 'N', null);
Line: 3470

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newAddressRegionCode,
						'IBU_CF_SR_COUNTY',
						'Y', 'N', null);
Line: 3474

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newUpdateAddressRegionCode,
                              'IBU_CF_SR_INCIDENT_ADDRESS_HDR',
						'Y', 'N', null);
Line: 3477

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newUpdateAddressRegionCode,
						'IBU_CF_SR_ADDRESS',
						'Y', 'N', null);
Line: 3480

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newUpdateAddressRegionCode,
						'IBU_CF_SR_CITY',
						'Y', 'N', null);
Line: 3483

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newUpdateAddressRegionCode,
						'IBU_CF_SR_STATE',
						'Y', 'N', null);
Line: 3486

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newUpdateAddressRegionCode,
						'IBU_CF_SR_PROVINCE',
						'Y', 'N', null);
Line: 3489

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newUpdateAddressRegionCode,
						'IBU_CF_SR_POSTAL_CODE',
						'Y', 'N', null);
Line: 3492

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newUpdateAddressRegionCode,
						'IBU_CF_SR_COUNTRY',
						'Y', 'N', null);
Line: 3495

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newUpdateAddressRegionCode,
						'IBU_CF_SR_COUNTY',
						'Y', 'N', null);
Line: 3500

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newAddressRegionCode,
					'IBU_CF_SR_INCIDENT_ADDRESS_HDR',
						'N', 'Y', null);
Line: 3503

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newAddressRegionCode,
						'IBU_CF_SR_ADDRESS',
						'N', 'Y', null);
Line: 3506

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newAddressRegionCode,
						'IBU_CF_SR_CITY',
						'N', 'Y', null);
Line: 3509

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newAddressRegionCode,
						'IBU_CF_SR_STATE',
						'N', 'Y', null);
Line: 3512

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newAddressRegionCode,
						'IBU_CF_SR_PROVINCE',
						'N', 'N', null);
Line: 3515

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newAddressRegionCode,
						'IBU_CF_SR_POSTAL_CODE',
						'N', 'N', null);
Line: 3518

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newAddressRegionCode,
						'IBU_CF_SR_COUNTRY',
						'N', 'Y', null);
Line: 3521

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newAddressRegionCode,
						'IBU_CF_SR_COUNTY',
						'N', 'N', null);
Line: 3547

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newIdentifyProductRegionCode,
					   'IBU_CF_SR_ALL_PRODUCT_RG',
					   'N', 'N', null);
Line: 3551

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newTemplateProductRegionCode,
					   'IBU_CF_SR_ALL_PRODUCT_RG',
					   'N', 'N', null);
Line: 3557

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newIdentifyProductRegionCode,
				   'IBU_CF_SR_REG_PRODUCT_RG',
					   'N', 'N', null);
Line: 3561

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newTemplateProductRegionCode,
				   'IBU_CF_SR_REG_PRODUCT_RG',
					   'N', 'N', null);
Line: 3572

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newProductFilterRegionCode,
					   'IBU_CF_SR_ALL_PRODUCT_RG',
					   'N', 'N', null);
Line: 3577

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newProductFilterRegionCode,
					   'IBU_CF_SR_REG_PRODUCT_RG',
					   'N', 'N', null);
Line: 3590

      IF (l_displayAttachment = 'DONOTSHOW' OR l_displayAttachment = 'SHOWDURINGUPDATE' OR l_mandatoryProblemCode = 'Y') THEN
        CS_CF_UPG_UTL_PKG.Clone_Region('IBU_CF_SR_40_G',
                                       672,
                                       l_newIdentifyProblemRegionCode,
                                       672, FALSE);
Line: 3596

          CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newIdentifyProblemRegionCode,
                            'IBU_CF_SR_ATTACHMENTS_RG',
					   'N', 'N', null);
Line: 3599

        ELSIF (l_displayAttachment = 'SHOWDURINGUPDATE') THEN
          CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newIdentifyProblemRegionCode,
                            'IBU_CF_SR_ATTACHMENTS_RG',
					   'N', 'N', null);
Line: 3604

          CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newIdentifyProblemRegionCode,
                            'IBU_CF_SR_PROB_TYPE_CODE',
					   'Y', 'Y', null);
Line: 3618

          CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newDtlOverviewRegionCode,
                            'IBU_CF_SR_ATTACHMENTS_RG',
					   'N', 'N', null);
Line: 3622

          CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newDtlOverviewRegionCode,
                            'IBU_CF_SR_ATTACHMENTS_RG',
					   'N', 'N', null);
Line: 3638

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newProblemDetailsRegionCode,
                            'IBU_CF_SR_PROB_DETAILS',
					   'N', 'N', null);
Line: 3651

      CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newDtlProgOptionsRegionCode,
                            'IBU_CF_SR_DTL_PROGRESS_INTRCT',
					   'Y', 'N', null);
Line: 3663

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newDtlResolnRegionCode,
                            'IBU_CF_SR_DTL_ACTS_RG',
					   'Y', 'N', null);
Line: 3715

    select node_display_flag INTO
    l_displayRegProducts
    from ak_region_items
    where region_code = l_newIdentifyProductRegionCode
    and attribute_code = 'IBU_CF_SR_REG_PRODUCT_RG'
    and region_application_id = 672
    and attribute_application_id = 672;
Line: 3723

    select node_display_flag INTO
    l_displayAllProducts
    from ak_region_items
    where region_code = l_newIdentifyProductRegionCode
    and attribute_code = 'IBU_CF_SR_ALL_PRODUCT_RG'
    and region_application_id = 672
    and attribute_application_id = 672;
Line: 3757

  l_newUpdateAddressRegionCode := 'IBU_CF_SR_25_A' || p_ApplId;
Line: 3758

  OPEN does_region_already_exists(l_newUpdateAddressRegionCode, 672);
Line: 3763

    l_newUpdateAddressExists := TRUE;
Line: 3778

    select node_display_flag INTO
    l_displayAttachment
    from ak_region_items
    where region_code = l_newIdentifyProblemRegionCode
    and attribute_code = 'IBU_CF_SR_ATTACHMENTS_RG'
    and region_application_id = 672
    and attribute_application_id = 672;
Line: 3808

    select node_display_flag INTO
    l_enableTemplate
    from ak_region_items
    where region_code = l_newProblemDetailsRegionCode
    and attribute_code = 'IBU_CF_SR_PROB_DETAILS'
    and region_application_id = 672
    and attribute_application_id = 672;
Line: 3878

    select node_display_flag INTO
    l_displayTasks
    from ak_region_items
    where region_code = l_newDtlResolnRegionCode
    and attribute_code = 'IBU_CF_SR_DTL_ACTS_RG'
    and region_application_id = 672
    and attribute_application_id = 672;
Line: 3902

          CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newIdentifyProductRegionCode,
                                    'IBU_CF_SR_REG_PRODUCT_RG',
                                    'Y', 'N', l_newRegProductRegionCode);
Line: 3906

          CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newIdentifyProductRegionCode,
                                    'IBU_CF_SR_REG_PRODUCT_RG',
                                    l_displayRegProducts, 'N', l_newRegProductRegionCode);
Line: 3911

          CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newIdentifyProductRegionCode,
                                    'IBU_CF_SR_ALL_PRODUCT_RG',
                                    'Y', 'N', l_newAllProductRegionCode);
Line: 3915

          CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newIdentifyProductRegionCode,
                                    'IBU_CF_SR_ALL_PRODUCT_RG',
                                    l_displayAllProducts, 'N', l_newAllProductRegionCode);
Line: 3931

          CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newTemplateProductRegionCode,
                                    'IBU_CF_SR_REG_PRODUCT_RG',
                                    'N', 'N', 'IBU_CF_SR_REG_PRODUCT');
Line: 3936

          CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newTemplateProductRegionCode,
                                    'IBU_CF_SR_ALL_PRODUCT_RG',
                                    'N', 'N', 'IBU_CF_SR_ALL_PRODUCT');
Line: 3950

          CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newProductFilterRegionCode,
                                    'IBU_CF_SR_REG_PRODUCT_RG',
                                    'N', 'N', 'IBU_CF_SR_REG_PRODUCT');
Line: 3955

          CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newProductFilterRegionCode,
                                    'IBU_CF_SR_ALL_PRODUCT_RG',
                                    'N', 'N', 'IBU_CF_SR_ALL_PRODUCT');
Line: 3964

      CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newIdentifyProblemRegionCode,
				    'IBU_CF_SR_PRIMARY_CONTACT_RG',
				    'Y', 'N', l_newPrimaryContactRegionCode);
Line: 3969

      CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newIdentifyProblemRegionCode,
				    'IBU_CF_SR_IDENTIFY_PRODUCT_RG',
				    'Y', 'N', l_newIdentifyProductRegionCode);
Line: 3975

      CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newIdentifyProblemRegionCode,
				    'IBU_CF_SR_ADDRESS_RG',
				    'N', 'N', l_newAddressRegionCode);
Line: 3983

      CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newProblemDetailsRegionCode,
				    'IBU_CF_SR_PRIMARY_CONTACT_RG',
				    'Y', 'N', l_newPrimaryContactRegionCode);
Line: 3988

      CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newIdentifyProblemRegionCode,
				    'IBU_CF_SR_ATTACHMENTS_RG',
				    'N', 'N', null);
Line: 3996

      CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newProblemDetailsRegionCode,
				    'IBU_CF_SR_ADDRESS_RG',
				    'N', 'N', l_newAddressRegionCode);
Line: 4005

      CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newReviewRegionCode,
				    'IBU_CF_SR_ATTACHMENTS_RG',
	                   'N', 'N', null);
Line: 4010

	 CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newReviewRegionCode,
				    'IBU_CF_SR_ADDRESS_RG',
				    'Y', 'N', l_newAddressRegionCode);
Line: 4015

      CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newReviewRegionCode,
				    'IBU_CF_SR_PROB_DETAILS',
				    'N', 'N', null);
Line: 4023

      CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newContactInfoRegionCode,
				    'IBU_CF_SR_ADDRESS_RG',
	                   'Y', 'N', l_newAddressRegionCode);
Line: 4028

      CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newContactInfoRegionCode,
				    'IBU_CF_SR_PRIMARY_CONTACT_RG',
	                   'Y', 'N', l_newPrimaryContactRegionCode);
Line: 4034

  IF (l_newUpdateAddressExists) THEN

    -- need to clone the IBU_CF_SR_DTL_CONTACT region
    l_newDtlContactAddrRegionCode := 'IBU_CF_SR_210_A' || p_ApplId;
Line: 4042

    CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newDtlContactAddrRegionCode,
  				    'IBU_CF_SR_ADDRESS_RG',
  	                   'Y', 'N', l_newUpdateAddressRegionCode);
Line: 4056

    CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newDtlProgressRegionCode,
				    'IBU_CF_SR_DTL_PROGRESS_OPT_RG',
	                   'Y', 'N', l_newDtlProgOptionsRegionCode);
Line: 4073

      IF (l_newUpdateAddressExists) THEN
        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newDtlOverviewRegionCode,
      				    'IBU_CF_SR_ADDRESS_RG',
      	                   'N', 'N', l_newUpdateAddressRegionCode);
Line: 4079

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newDtlOverviewRegionCode,
				    'IBU_CF_SR_DTL_PROGRESS_RG',
	                   'Y', 'N', l_newDtlProgressRegionCode);
Line: 4084

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newDtlOverviewRegionCode,
				    'IBU_CF_SR_DTL_ACTS_RG',
	                   'Y', 'N', null);
Line: 4100

      CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newDtlTabsRegionCode,
				    'IBU_CF_SR_DTL_OVERVIEW_TAB_RG',
	                   'Y', 'N', l_newDtlOverviewRegionCode);
Line: 4105

      CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newDtlTabsRegionCode,
  			         'IBU_CF_SR_DTL_RESOLN_TAB_RG',
	                   'N', 'N', l_newDtlResolnRegionCode);
Line: 4120

      CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newDtlDetailsRegionCode,
				    'IBU_CF_SR_DTL_TABS_RG',
	                   'Y', 'N', l_newDtlTabsRegionCode);
Line: 4144

      CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newCreateTemplateRegionCode,
				    'IBU_CF_SR_IDENTIFY_PRODUCT_RG',
	                   'Y', 'N', l_newTemplateProductRegionCode);
Line: 4149

    l_newUpdateTemplateRegionCode := 'IBU_CF_SR_320_A' || p_ApplId;
Line: 4152

							l_newUpdateTemplateRegionCode,
							672, FALSE);
Line: 4160

      CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newUpdateTemplateRegionCode,
				    'IBU_CF_SR_IDENTIFY_PRODUCT_RG',
	                   'Y', 'N', l_newTemplateProductRegionCode);
Line: 4164

    l_newUpdateTemplateExists := TRUE;
Line: 4175

    CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newFilterRegionCode,
				    'IBU_CF_SR_VW_PRODUCT_FILTER_RG',
	                   'Y', 'N', l_newProductFilterRegionCode);
Line: 4189

    CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newSearchViewRegionCode,
				    'IBU_CF_SR_VW_FILTER_RG',
	                   'Y', 'N', l_newFilterRegionCode);
Line: 4200

    CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newCreateViewRegionCode,
				    'IBU_CF_SR_VW_FILTER_RG',
	                   'Y', 'N', l_newFilterRegionCode);
Line: 4206

    l_newUpdateViewRegionCode := 'IBU_CF_SR_440_A' || p_ApplId;
Line: 4209

							l_newUpdateViewRegionCode,
							672, FALSE);
Line: 4211

    CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newUpdateViewRegionCode,
				    'IBU_CF_SR_VW_FILTER_RG',
	                   'Y', 'N', l_newFilterRegionCode);
Line: 4215

    l_newUpdateViewExists := TRUE;
Line: 4222

    CS_CF_UPG_UTL_PKG.Insert_New_Target(
	   'IBU_SR_CR_IDENTIFY_PROBLEM',
	   'APPLICATION',
	   l_ApplId,
	   NULL,
	   NULL,
	   NULL,
        l_newIdentifyProblemRegionCode,
        '672');
Line: 4234

    CS_CF_UPG_UTL_PKG.Insert_New_Target(
        'IBU_SR_CR_REVIEW',
	   'APPLICATION',
	   l_ApplId,
	   NULL,
	   NULL,
	   NULL,
        l_newReviewRegionCode,
        '672');
Line: 4246

    CS_CF_UPG_UTL_PKG.Insert_New_Target(
        'IBU_SR_CR_PROBLEM_DETAILS',
	   'APPLICATION',
	   l_ApplId,
	   NULL,
	   NULL,
	   NULL,
        l_newProblemDetailsRegionCode,
        '672');
Line: 4259

    CS_CF_UPG_UTL_PKG.Insert_New_Target(
        'IBU_SR_CR_CONTACT_INFORMATION',
	   'APPLICATION',
	   l_ApplId,
	   NULL,
	   NULL,
	   NULL,
        l_newContactInfoRegionCode,
        '672');
Line: 4271

    CS_CF_UPG_UTL_PKG.Insert_New_Target(
        'IBU_SR_DETAILS',
	   'APPLICATION',
	   l_ApplId,
	   NULL,
	   NULL,
	   NULL,
        l_newDtlDetailsRegionCode,
        '672');
Line: 4283

    CS_CF_UPG_UTL_PKG.Insert_New_Target(
        'IBU_SR_TEMP_CREATE',
	   'APPLICATION',
	   l_ApplId,
	   NULL,
	   NULL,
	   NULL,
        l_newCreateTemplateRegionCode,
        '672');
Line: 4294

  IF (l_newUpdateTemplateExists) THEN
    CS_CF_UPG_UTL_PKG.Insert_New_Target(
        'IBU_SR_TEMP_UPDATE',
	   'APPLICATION',
	   l_ApplId,
	   NULL,
	   NULL,
	   NULL,
        l_newUpdateTemplateRegionCode,
        '672');
Line: 4307

    CS_CF_UPG_UTL_PKG.Insert_New_Target(
        'IBU_SR_VIEW_SUMMARY',
	   'APPLICATION',
	   l_ApplId,
	   NULL,
	   NULL,
	   NULL,
        l_newSearchViewRegionCode,
        '672');
Line: 4319

    CS_CF_UPG_UTL_PKG.Insert_New_Target(
        'IBU_SR_VIEW_CREATE',
	   'APPLICATION',
	   l_ApplId,
	   NULL,
	   NULL,
	   NULL,
        l_newCreateViewRegionCode,
        '672');
Line: 4330

  IF (l_newUpdateViewExists) THEN
    CS_CF_UPG_UTL_PKG.Insert_New_Target(
        'IBU_SR_VIEW_UPDATE',
	   'APPLICATION',
	   l_ApplId,
	   NULL,
	   NULL,
	   NULL,
        l_newUpdateViewRegionCode,
        '672');
Line: 4377

  SELECT a.profile_option_name,
	    b.level_value,
	    b.level_value_application_id,
	    b.profile_option_value,
	    1 "PRIORITY"
  FROM fnd_profile_option_values b, fnd_profile_options a
  WHERE b.level_id = 10003
  AND   b.level_value = respId
  AND   b.level_value_application_id = respApplId
  AND   a.profile_option_id = b.profile_option_id
  AND   b.application_id = 672
  AND  a.profile_option_name in ('IBU_A_SR_KB_OPTION')
  UNION
  SELECT a.profile_option_name,
	    b.level_value,
	    b.level_value_application_id,
	    b.profile_option_value,
	    2 "PRIORITY"
  FROM fnd_profile_option_values b, fnd_profile_options a
  WHERE b.level_id = 10002
  AND   b.level_value = respApplId
  AND   a.profile_option_id = b.profile_option_id
  AND   b.application_id = 672
  AND  a.profile_option_name in ('IBU_A_SR_KB_OPTION')
  UNION
  SELECT a.profile_option_name,
	    b.level_value,
	    b.level_value_application_id,
	    b.profile_option_value,
	    3 "PRIORITY"
  FROM fnd_profile_option_values b, fnd_profile_options a
  WHERE b.level_id = 10001
  AND   a.profile_option_id = b.profile_option_id
  AND   b.application_id = 672
  AND  a.profile_option_name in ('IBU_A_SR_KB_OPTION')
  ORDER BY PROFILE_OPTION_NAME, PRIORITY;
Line: 4470

    l_ProfileTable.DELETE;
Line: 4526

      CS_CF_UPG_UTL_PKG.Insert_New_Target('IBU_SR_CRE',
                                          'RESP',
                                          l_respId,
                                          l_respApplId,
                                          NULL,
                                          NULL,
                                          to_char((0-to_number(l_respId || l_respApplId))),
                                          'NULL');
Line: 4554

  SELECT a.profile_option_name,
	    b.level_value,
	    b.level_value_application_id,
	    b.profile_option_value,
	    1 "PRIORITY"
  FROM fnd_profile_option_values b, fnd_profile_options a
  WHERE b.level_id = 10002
  AND   b.level_value = applId
  AND   a.profile_option_id = b.profile_option_id
  AND   b.application_id = 672
  AND  a.profile_option_name in ('IBU_A_SR_KB_OPTION')
  UNION
  SELECT a.profile_option_name,
	    b.level_value,
	    b.level_value_application_id,
	    b.profile_option_value,
	    2 "PRIORITY"
  FROM fnd_profile_option_values b, fnd_profile_options a
  WHERE b.level_id = 10001
  AND   a.profile_option_id = b.profile_option_id
  AND   b.application_id = 672
  AND  a.profile_option_name in ('IBU_A_SR_KB_OPTION')
  ORDER BY PROFILE_OPTION_NAME, PRIORITY;
Line: 4632

    l_ProfileTable.DELETE;
Line: 4685

      CS_CF_UPG_UTL_PKG.Insert_New_Target('IBU_SR_CRE',
                                          'APPLICATION',
                                          l_applId,
                                          NULL,
                                          NULL,
                                          NULL,
                                          to_char(0-l_applId),
                                          NULL);
Line: 4713

  l_last_updated_by NUMBER;
Line: 4717

  SELECT last_updated_by
  FROM cs_cf_source_cxt_targets
  WHERE source_context_type_id = p_source_context_type_id;
Line: 4722

  SELECT count(*)
  FROM cs_cf_source_cxt_targets
  WHERE source_context_type_id = p_source_context_type_id;
Line: 4735

	   SELECT SOURCE_CONTEXT_TYPE_ID
	   INTO l_source_context_type_id
	   FROM cs_cf_source_cxt_types
	   WHERE SOURCE_CODE = 'IBU_SR_CRE'
	   AND CONTEXT_TYPE = 'GLOBAL';
Line: 4742

           FETCH l_cur INTO l_last_updated_by;
Line: 4751

           IF (l_last_updated_by in (-1,1,2) AND l_count2 > 0) THEN

             UPDATE cs_cf_source_cxt_targets
	     SET cust_target_value1 = '10'
	     WHERE source_context_type_id = l_source_context_type_id;