APPS.JTF_TERR_TASK_PUB SQL Statements

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

Line: 146

  /* insert all the attributes into the trans table as name - value pair */
  DELETE jty_terr_nvp_trans_gt;

Line: 148

  INSERT INTO jty_terr_nvp_trans_gt (
     attribute_name
    ,num_value
    ,char_value
    ,date_value )
  ( SELECT 'COUNTRY'               attribute_name
          ,null                    num_value
          ,p_TerrTask_rec.COUNTRY  char_value
          ,null                    date_value
    FROM  DUAL
    UNION ALL
    SELECT 'CITY'                  attribute_name
          ,null                    num_value
          ,p_TerrTask_rec.CITY     char_value
          ,null                    date_value
    FROM  DUAL
    UNION ALL
    SELECT 'POSTAL_CODE'              attribute_name
          ,null                       num_value
          ,p_TerrTask_rec.POSTAL_CODE char_value
          ,null                       date_value
    FROM  DUAL
    UNION ALL
    SELECT 'STATE'               attribute_name
          ,null                  num_value
          ,p_TerrTask_rec.STATE  char_value
          ,null                  date_value
    FROM  DUAL
    UNION ALL
    SELECT 'AREA_CODE'               attribute_name
          ,null                      num_value
          ,p_TerrTask_rec.AREA_CODE  char_value
          ,null                      date_value
    FROM  DUAL
    UNION ALL
    SELECT 'COUNTY'               attribute_name
          ,null                   num_value
          ,p_TerrTask_rec.COUNTY  char_value
          ,null                   date_value
    FROM  DUAL
    UNION ALL
    SELECT 'COMP_NAME_RANGE'               attribute_name
          ,null                            num_value
          ,p_TerrTask_rec.COMP_NAME_RANGE  char_value
          ,null                            date_value
    FROM  DUAL
    UNION ALL
    SELECT 'PROVINCE'               attribute_name
          ,null                     num_value
          ,p_TerrTask_rec.PROVINCE  char_value
          ,null                     date_value
    FROM  DUAL
    UNION ALL
    SELECT 'PARTY_ID'               attribute_name
          ,p_TerrTask_rec.PARTY_ID  num_value
          ,null                     char_value
          ,null                     date_value
    FROM  DUAL
    UNION ALL
    SELECT 'PARTY_SITE_ID'               attribute_name
          ,p_TerrTask_rec.PARTY_SITE_ID  num_value
          ,null                          char_value
          ,null                          date_value
    FROM  DUAL
    UNION ALL
    SELECT 'NUM_OF_EMPLOYEES'               attribute_name
          ,p_TerrTask_rec.NUM_OF_EMPLOYEES  num_value
          ,null                             char_value
          ,null                             date_value
    FROM  DUAL
    UNION ALL
    SELECT 'TASK_TYPE_ID'               attribute_name
          ,p_TerrTask_rec.TASK_TYPE_ID  num_value
          ,null                         char_value
          ,null                         date_value
    FROM  DUAL
    UNION ALL
    SELECT 'TASK_STATUS_ID'               attribute_name
          ,p_TerrTask_rec.TASK_STATUS_ID  num_value
          ,null                           char_value
          ,null                           date_value
    FROM  DUAL
    UNION ALL
    SELECT 'TASK_PRIORITY_ID'               attribute_name
          ,p_TerrTask_rec.TASK_PRIORITY_ID  num_value
          ,null                             char_value
          ,null                             date_value
    FROM  DUAL
    UNION ALL
    SELECT 'TASK_ID'                        attribute_name
          ,p_TerrTask_rec.TASK_ID           num_value
          ,null                             char_value
          ,null                             date_value
    FROM  DUAL
    UNION ALL
    SELECT 'ORGANIZATION_ID'                attribute_name
          ,p_TerrTask_rec.ORGANIZATION_ID   num_value
          ,null                             char_value
          ,null                             date_value
    FROM  DUAL
  );