APPS.CS_CF_UPG_BUGFIX1_PKG SQL Statements

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

Line: 12

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

Line: 42

  SELECT region_code
  FROM ak_regions
  WHERE region_code like p_region_code || p_suffix || '%';

Line: 48

  SELECT count(*)
  FROM ak_regions where region_code = p_region_code;

Line: 53

  SELECT node_display_flag, required_flag
  FROM ak_region_items
  WHERE region_code = p_region_code
  AND   region_application_id = p_region_application_id
  AND   attribute_code = p_attribute_code
  AND   attribute_application_id = p_attribute_application_id;

Line: 94

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newRegionCode,
                                          'IBU_CF_SR_ALL_PRODUCT_RG',
                                          l_node_display_flag,
                                          l_required_flag,
                                          'IBU_CF_SR_ALL_PRODUCT');

Line: 103

        CS_CF_UPG_UTL_PKG.UpdateRegionItems(l_newRegionCode,
                                          'IBU_CF_SR_REG_PRODUCT_RG',
                                          l_node_display_flag,
                                          l_required_flag,
                                          'IBU_CF_SR_REG_PRODUCT');

Line: 121

          CS_CF_UPG_UTL_PKG.UpdateRegionItems('IBU_CF_SR_310_' || p_contextType||l_suffix,
                                          'IBU_CF_SR_IDENTIFY_PRODUCT_RG',
                                          l_node_display_flag,
                                          l_required_flag,
                                          'IBU_CF_SR_35_' || p_contextType||l_suffix);

Line: 138

          CS_CF_UPG_UTL_PKG.UpdateRegionItems('IBU_CF_SR_320_'|| p_contextType||l_suffix,
                                          'IBU_CF_SR_IDENTIFY_PRODUCT_RG',
                                          l_node_display_flag,
                                          l_required_flag,
                                          'IBU_CF_SR_35_'|| p_contextType||l_suffix);

Line: 156

        CS_CF_UPG_UTL_PKG.UpdateRegionItems('IBU_CF_SR_420_' || p_contextType|| l_suffix,
                                          'IBU_CF_SR_ALL_PRODUCT_RG',
                                          l_node_display_flag,
                                          l_required_flag,
                                          'IBU_CF_SR_ALL_PRODUCT');

Line: 165

        CS_CF_UPG_UTL_PKG.UpdateRegionItems('IBU_CF_SR_420_' || p_contextType|| l_suffix,
                                          'IBU_CF_SR_REG_PRODUCT_RG',
                                          l_node_display_flag,
                                          l_required_flag,
                                          'IBU_CF_SR_REG_PRODUCT');

Line: 194

        CS_CF_UPG_UTL_PKG.UpdateRegionItems('IBU_CF_SR_130_' || p_contextType || l_suffix,
                                          'IBU_CF_SR_ADDRESS_RG',
                                          'N', 'N', 'IBU_CF_SR_25_G');

Line: 198

        CS_CF_UPG_UTL_PKG.UpdateRegionItems('IBU_CF_SR_130_' || p_contextType || l_suffix,
                                          'IBU_CF_SR_ADDRESS_RG',
                                          'N', 'N', 'IBU_CF_SR_25_'||p_contextType||l_suffix);

Line: 225

        CS_CF_UPG_UTL_PKG.UpdateRegionItems('IBU_CF_SR_210_' || p_contextType || l_suffix,
                                          'IBU_CF_SR_ADDRESS_RG',
                                          'Y', 'N', 'IBU_CF_SR_25_G');

Line: 229

        CS_CF_UPG_UTL_PKG.UpdateRegionItems('IBU_CF_SR_210_' || p_contextType || l_suffix,
                                          'IBU_CF_SR_ADDRESS_RG',
                                          'Y', 'N', 'IBU_CF_SR_25_' || p_contextType || l_suffix);

Line: 251

      CS_CF_UPG_UTL_PKG.UpdateRegionItems('IBU_CF_SR_310_' || p_contextType || l_suffix,
                                          'IBU_CF_SR_PRIMARY_CONTACT_RG',
                                          'Y', 'N', 'IBU_CF_SR_15_G');

Line: 272

      CS_CF_UPG_UTL_PKG.UpdateRegionItems('IBU_CF_SR_320_' || p_contextType || l_suffix,
                                          'IBU_CF_SR_PRIMARY_CONTACT_RG',
                                          'Y', 'N', 'IBU_CF_SR_15_G');