APPS.CNSYSP_SYSTEM_PARAMETERS_PKG SQL Statements

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

Line: 24

    SELECT name,
           period_set_name,
           accounted_period_type,
           currency_code
      INTO x_sob_name,
           x_sob_calendar,
           x_sob_period_type,
           x_sob_currency
      FROM gl_sets_of_books_v
     WHERE set_of_books_id = x_set_of_books_id;

Line: 43

    SELECT meaning
      INTO x_trx_rollup_method_string
      FROM cn_lookups
     WHERE LOOKUP_CODE = x_trx_rollup_method
       AND LOOKUP_TYPE = 'TRX_ROLLUP_METHOD';

Line: 51

    SELECT meaning into x_usage_string
      FROM cn_lookups
     WHERE LOOKUP_CODE = x_usage_flag
       AND LOOKUP_TYPE = 'REPOSITORY_USAGE';

Line: 58

    SELECT meaning into x_status_string
      FROM cn_lookups
     WHERE LOOKUP_CODE = x_status
       AND LOOKUP_TYPE = 'REPOSITORY_STATUS';

Line: 78

  SELECT dim.dimension_id
    INTO x_rev_class_dimension_id
    FROM cn_dimensions dim,
         cn_objects obj
   WHERE dim.source_table_id = obj.object_id
     AND obj.name = 'CN_REVENUE_CLASSES' ;

Line: 86

/*  SELECT dim.dimension_id
    INTO x_srp_rollup_dimension_id
    FROM cn_dimensions dim,
         cn_objects obj
   WHERE dim.source_table_id = obj.object_id
     AND obj.name = 'CN_SALESREPS' ; */

Line: 95

     SELECT name
       INTO x_rev_class_hierarchy_name
       FROM cn_head_hierarchies
      WHERE head_hierarchy_id = x_rev_class_hierarchy_id ;

Line: 105

     SELECT name
       INTO x_srp_rollup_hierarchy_name
       FROM cn_head_hierarchies
      WHERE head_hierarchy_id = x_srp_rollup_hierarchy_id ;

Line: 133

          update cn_repositories
             set system_batch_size = 5000
          where repository_id = X_repository_id;

Line: 143

        update cn_repositories
           set transfer_batch_size = 5000
        where repository_id = X_repository_id;

Line: 153

        update cn_repositories
           set clawback_grace_days = 0
        where repository_id = X_repository_id;

Line: 162

       update cn_repositories
           set trx_rollup_method = 'INV'
        where repository_id = X_repository_id;

Line: 172

       update cn_repositories
           set srp_rollup_flag = 'N'
        where repository_id = X_repository_id;

Line: 190

  update cn_repositories
  set ( last_set_of_books_id,
        last_current_period,
        last_system_start_period,
        last_system_end_period,
        last_system_batch_size,
        last_transfer_batch_size,
        last_clawback_grace_days,
        last_trx_rollup_method,
        last_srp_rollup_flag ) =
        ( select set_of_books_id,
                 current_period,
                 system_start_period,
                 system_end_period,
                 system_batch_size,
                 transfer_batch_size,
                 clawback_grace_days,
                 trx_rollup_method,
                 srp_rollup_flag
          from cn_repositories
          where repository_id = X_repository_id )
  where repository_id = X_repository_id;

Line: 226

   update cn_repositories
  set ( set_of_books_id,
        current_period,
        system_start_period,
        system_end_period,
        system_batch_size,
        transfer_batch_size,
        clawback_grace_days,
        trx_rollup_method,
        srp_rollup_flag ) =
        ( select last_set_of_books_id,
                 last_current_period,
                 last_system_start_period,
                 last_system_end_period,
                 last_system_batch_size,
                 last_transfer_batch_size,
                 last_clawback_grace_days,
                 last_trx_rollup_method,
                 last_srp_rollup_flag
          from cn_repositories
          where repository_id = X_repository_id )
  where repository_id = X_repository_id;