APPS.PQP_COPY_UDT SQL Statements

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

Line: 67

  SELECT *
  FROM pay_user_tables
  WHERE user_table_id = p_curr_put_id;

Line: 102

    pay_user_tables_pkg.insert_row
                        (p_rowid                => l_row_id     -- IN OUT
                        ,p_user_table_id        => l_new_put_id -- IN OUT
                        ,p_business_group_id    => g_target_bg_id
                        ,p_legislation_code     => NULL
                        ,p_legislation_subgroup => NULL
                        ,p_range_or_match       => r_user_table.range_or_match
                        ,p_user_key_units       => r_user_table.user_key_units
                        ,p_user_table_name      => l_new_user_table_name
                        ,p_user_row_title       => r_user_table.user_row_title
                        );

Line: 130

  SELECT *
  FROM pay_user_columns
  WHERE user_table_id = p_curr_put_id;

Line: 157

    pay_user_columns_pkg.insert_row
                        (p_rowid                => l_row_id     -- IN OUT
                        ,p_user_column_id       => l_new_puc_id -- IN OUT
                        ,p_user_table_id        => p_new_put_id
                        ,p_business_group_id    => g_target_bg_id
                        ,p_legislation_code     => NULL
                        ,p_legislation_subgroup => NULL
                        ,p_user_column_name     => r_user_columns.user_column_name
                        ,p_formula_id           => r_user_columns.formula_id
                        );

Line: 187

  SELECT *
  FROM pay_user_rows_f
  WHERE user_table_id = p_curr_put_id
  ORDER BY user_row_id, effective_start_date;

Line: 220

      pay_user_rows_pkg.pre_insert
                       (p_rowid                 => l_row_id
                       ,p_user_table_id         => p_new_put_id
                       ,p_row_low_range_or_name => r_user_rows.row_low_range_or_name
                       ,p_user_row_id           => l_new_pur_id -- OUT
                       ,p_business_group_id     => g_target_bg_id
                       );

Line: 231

    INSERT INTO pay_user_rows_f
    (user_row_id
    ,effective_start_date
    ,effective_end_date
    ,business_group_id
    ,legislation_code
    ,user_table_id
    ,row_low_range_or_name
    ,display_sequence
    ,legislation_subgroup
    ,row_high_range
    ,last_update_date
    ,last_updated_by
    ,last_update_login
    ,created_by
    ,creation_date
    )
    values
    (l_new_pur_id
    ,r_user_rows.effective_start_date
    ,r_user_rows.effective_end_date
    ,g_target_bg_id
    ,NULL
    ,p_new_put_id
    ,r_user_rows.row_low_range_or_name
    ,r_user_rows.display_sequence
    ,NULL
    ,r_user_rows.row_high_range
    ,r_user_rows.last_update_date
    ,r_user_rows.last_updated_by
    ,r_user_rows.last_update_login
    ,r_user_rows.created_by
    ,r_user_rows.creation_date
    );

Line: 287

  SELECT *
  FROM pay_user_column_instances_f
  WHERE user_column_id = p_user_column_id
  ORDER BY user_column_instance_id, effective_start_date;

Line: 345

        pay_user_column_instances_pkg.insert_row
                        (p_rowid                   => l_row_id          -- IN OUT
                        ,p_user_column_instance_id => l_new_puci_id     -- IN OUT
                        ,p_effective_start_date    => r_user_ci.effective_start_date
                        ,p_effective_end_date      => r_user_ci.effective_end_date
                        ,p_user_column_id          => l_new_puc_id
                        ,p_user_row_id             => l_new_pur_id
                        ,p_business_group_id       => g_target_bg_id
                        ,p_legislation_code        => NULL
                        ,p_legislation_subgroup    => NULL
                        ,p_value                   => r_user_ci.value
                        );

Line: 367

          pay_user_column_instances_pkg.update_row
                        (p_rowid                   => l_row_id -- IN, used to update row
                        ,p_user_column_instance_id => l_prev_new_puci_id
                        ,p_effective_start_date    => r_user_ci.effective_start_date
                        ,p_effective_end_date      => r_user_ci.effective_end_date
                        ,p_user_column_id          => l_new_puc_id
                        ,p_user_row_id             => l_new_pur_id
                        ,p_business_group_id       => g_target_bg_id
                        ,p_legislation_code        => NULL
                        ,p_legislation_subgroup    => NULL
                        ,p_value                   => r_user_ci.value
                        );