APPS.GCS_DIMENSION_SET_LINES_PKG SQL Statements

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

Line: 25

    insert_clause VARCHAR2(1500);

Line: 26

    select_clause VARCHAR2(600);

Line: 31

      SELECT column_name
      FROM   gcs_dimension_set_dims
      WHERE  dimension_set_id = p_dimension_set_id
      ORDER BY column_name;

Line: 52

    SELECT set_type_code
    INTO   l_dimension_set_type
    FROM   GCS_DIMENSION_SETS_B
    WHERE  dimension_set_id = p_dimension_set_id;

Line: 58

    insert_clause := '';

Line: 59

    select_clause := '';

Line: 84

      insert_clause := insert_clause || '
    SRC_' || l_col_name || ',
    TGT_' || l_col_name || ',';

Line: 88

      select_clause := select_clause || '
    grp' || l_num_of_dimensions || '.source_member_id,
    grp' || l_num_of_dimensions || '.target_member_id,';

Line: 121

    DELETE FROM GCS_DIMENSION_SET_LINES
    WHERE  dimension_set_id = p_dimension_set_id;

Line: 127

                     'Deleted ' || to_char(SQL%ROWCOUNT) || ' row(s)');

Line: 137

'INSERT INTO GCS_DIMENSION_SET_LINES
   (dimension_set_id,' ||
    insert_clause || '
    creation_date, created_by,
    last_update_date, last_updated_by,
    last_update_login)
SELECT
    :dim_set_id,' ||
    select_clause || '
    sysdate, :user_id,
    sysdate, :user_id,
    :login_id
FROM
    GCS_DIMENSION_SETS_B ds' ||
    from_clause || '
WHERE ds.dimension_set_id = :dim_set_id' ||
    where_clause;

Line: 171

                     'Inserted ' || to_char(SQL%ROWCOUNT) || ' row(s)');