APPS.PA_MAPPING_PVT SQL Statements

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

Line: 55

  SELECT value_map_def_type
  INTO l_value_map_def_type
  FROM PA_VALUE_MAP_DEFS
  WHERE value_map_def_id = p_value_map_def_id;

Line: 117

    PA_VALUE_MAP_DEF_PKG.update_row(p_value_map_def_id => p_value_map_def_id,
      p_record_version_number => p_record_version_number,
      x_return_status   => x_return_status,
      x_msg_count       => x_msg_count,
      x_msg_data        => x_msg_data);

Line: 122

    debug('After update_row');

Line: 127

    debug('Before delete_rows');

Line: 128

    PA_VALUE_MAPS_PKG.delete_rows(p_value_map_def_id => p_value_map_def_id,
      p_value_map_def_type => l_value_map_def_type,
      p_probability_list_id => p_probability_list_id,
      x_return_status   => x_return_status,
      x_msg_count       => x_msg_count,
      x_msg_data        => x_msg_data);

Line: 134

    debug('After delete_rows');

Line: 141

      debug('Before insert_rows');

Line: 142

      PA_VALUE_MAPS_PKG.insert_rows (
        p_value_map_def_id => p_value_map_def_id     ,
        p_source_value_arr => l_source_value_arr     ,
				p_dest_value_arr   => l_dest_value_arr       ,
				p_source_value_pk1_arr  => l_source_value_pk1_arr      ,
				p_source_value_pk2_arr  => l_source_value_pk2_arr      ,
				p_source_value_pk3_arr  => l_source_value_pk3_arr      ,
				p_source_value_pk4_arr  => l_source_value_pk4_arr      ,
				p_source_value_pk5_arr  => l_source_value_pk5_arr      ,
				p_dest_value_pk1_arr    => l_dest_value_pk1_arr      ,
				p_dest_value_pk2_arr    => l_dest_value_pk2_arr      ,
				p_dest_value_pk3_arr    => l_dest_value_pk3_arr      ,
				p_dest_value_pk4_arr    => l_dest_value_pk4_arr      ,
				p_dest_value_pk5_arr    => l_dest_value_pk5_arr      ,
        x_return_status         => x_return_status           ,
        x_msg_count             => x_msg_count               ,
        x_msg_data              => x_msg_data );

Line: 160

    debug('After insert_rows');

Line: 217

    SELECT dest_value, dest_value_pk1, dest_value_pk2, dest_value_pk3, dest_value_pk4, dest_value_pk5
    FROM pa_value_maps map, pa_value_map_defs def
    WHERE map.value_map_def_id = def.value_map_def_id
    AND def.value_map_def_type = p_value_map_def_type
    AND def.def_subtype = p_def_subtype
    AND map.source_value = p_source_value
    AND (map.source_value_pk1 = NVL(p_source_value_pk1, map.source_value_pk1)
         OR map.source_value_pk1 IS NULL)
    AND (map.source_value_pk2 = NVL(p_source_value_pk2, map.source_value_pk2)
         OR map.source_value_pk2 IS NULL)
    AND (map.source_value_pk3 = NVL(p_source_value_pk3, map.source_value_pk3)
         OR map.source_value_pk3 IS NULL)
    AND (map.source_value_pk4 = NVL(p_source_value_pk4, map.source_value_pk4)
         OR map.source_value_pk4 IS NULL)
    AND (map.source_value_pk5 = NVL(p_source_value_pk5, map.source_value_pk5)
         OR map.source_value_pk5 IS NULL);