APPS.MSC_MANAGE_PLAN_PARTITIONS SQL Statements

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

Line: 72

                                            'RP_ITEM_UPDATES',
                                            'RP_RELEASED_ORDERS',
                                            'ANALYSIS_AGGREGATE', --minduvad
							  'ORP_RESOURCE_PLANS',
							  'ORP_MATERIAL_PLANS',
							  'PLAN_CONSTRAINTS'
                                            );

Line: 144

    SELECT a.oracle_username
      FROM FND_ORACLE_USERID a, FND_PRODUCT_INSTALLATIONS b
     WHERE a.oracle_id = b.oracle_id
       AND b.application_id = 724;

Line: 230

    SELECT a.oracle_username
      FROM FND_ORACLE_USERID a, FND_PRODUCT_INSTALLATIONS b
     WHERE a.oracle_id = b.oracle_id
       AND b.application_id = 724;

Line: 297

        OR cur_table = 'MSC_RP_ITEM_UPDATES'
        OR cur_table = 'MSC_ANALYSIS_AGGREGATE'
        OR cur_table = 'MSC_SINGLE_LVL_PEG'
        OR cur_table = 'MSC_ORP_RESOURCE_PLANS'
        OR cur_table = 'MSC_ORP_MATERIAL_PLANS'
        OR cur_table = 'MSC_PLAN_CONSTRAINTS'
        OR cur_table = 'MSC_PART_DEMANDS'
        OR cur_table = 'MSC_PART_SUPPLIES'
        OR cur_table = 'MSC_PART_PEGGING'
        ) THEN -- dsting

      sql_stmt := 'alter table ' || cur_table || ' add partition '
		|| l_partition_name
		|| ' VALUES LESS THAN ('
		|| to_char(plan_num+1)
		|| ')';

Line: 391

    SELECT a.oracle_username
      FROM FND_ORACLE_USERID a, FND_PRODUCT_INSTALLATIONS b
     WHERE a.oracle_id = b.oracle_id
       AND b.application_id = 724;

Line: 478

  INSERT INTO MSC_INST_PARTITIONS (
     INSTANCE_ID,
     FREE_FLAG,
     LAST_UPDATE_DATE,
     LAST_UPDATED_BY,
     CREATION_DATE,
     CREATED_BY,
     LAST_UPDATE_LOGIN
   )
  VALUES (
     p_instance_id,
     2,			/* used partition */
     sysdate,
     FND_GLOBAL.USER_ID,
     sysdate,
     FND_GLOBAL.USER_ID,
     FND_GLOBAL.LOGIN_ID
       );

Line: 556

   SELECT plan_id
     FROM MSC_PLAN_PARTITIONS
    WHERE free_flag = 1
    FOR UPDATE;

Line: 563

   SELECT count(*)
     FROM MSC_PLAN_PARTITIONS;

Line: 567

   SELECT max(plan_id)
     FROM MSC_PLAN_PARTITIONS;

Line: 595

    SELECT MSC_PLANS_S.nextval
    INTO l_plan_id
    from dual;

Line: 627

        SELECT msc_plans_s.nextval
        INTO   l_plan_id
        FROm   dual;

Line: 649

            INSERT INTO MSC_PLAN_PARTITIONS (
                PLAN_ID,
                PLAN_NAME,
                FREE_FLAG,
                PARTITION_NUMBER,
                LAST_UPDATE_DATE,
                LAST_UPDATED_BY,
                CREATION_DATE,
                CREATED_BY,
                LAST_UPDATE_LOGIN
                )
            VALUES (
                l_plan_id,
                p_plan_name,
                2,
                l_plan_id,
                sysdate,
                X_User_Id,
                sysdate,
                X_User_Id,
                X_Login_Id
                );

Line: 690

                UPDATE MSC_PLAN_PARTITIONS
                SET plan_name = p_plan_name,
                    free_flag = 2
                WHERE plan_id = l_plan_id;

Line: 696

                UPDATE MSC_PLAN_PARTITIONS
                SET plan_name = '*UNUSABLE*',
                    free_flag = 2
                WHERE plan_id = l_plan_id;

Line: 749

      INSERT INTO MSC_INST_PARTITIONS (
        INSTANCE_ID,
        FREE_FLAG,
        LAST_UPDATE_DATE,
        LAST_UPDATED_BY,
        CREATION_DATE,
        CREATED_BY,
        LAST_UPDATE_LOGIN
      )
      VALUES (
        i,
        1,			/* free partition */
        sysdate,
        1,
        sysdate,
        1,
        1
       );

Line: 790

   SELECT instance_id
     FROM MSC_INST_PARTITIONS
    WHERE free_flag = 1;

Line: 818

    SELECT msc_apps_instances_s.nextval
      INTO l_inst_id
      FROM DUAL;

Line: 835

      UPDATE MSC_INST_PARTITIONS
         SET free_flag = 2
       WHERE instance_id = l_inst_id;

Line: 875

    SELECT count(*)
    FROM   MSC_PLAN_PARTITIONS
    WHERE  plan_id = P_plan_id;

Line: 880

    SELECT count(*)
    FROM   MSC_INST_PARTITIONS
    WHERE  instance_id = P_instance_id;

Line: 947

       UPDATE MSC_PLAN_PARTITIONS
       SET free_flag = 1
       WHERE plan_id = P_plan_id;

Line: 953

         fnd_message.set_name('MSC','MSC_PART_UPDATE_FAILED');

Line: 993

         INSERT INTO MSC_PLAN_PARTITIONS (
         PLAN_ID,
         PLAN_NAME,
         FREE_FLAG,
         PARTITION_NUMBER,
         LAST_UPDATE_DATE,
         LAST_UPDATED_BY,
         CREATION_DATE,
         CREATED_BY,
         LAST_UPDATE_LOGIN
       )
       VALUES (
         partition_num,
         to_char(partition_num),
         1,			/* free partition */
         partition_num,
         sysdate,
         1,
         sysdate,
         1,
         1
       );

Line: 1016

       INSERT INTO MSC_INST_PARTITIONS (
         INSTANCE_ID,
         FREE_FLAG,
         LAST_UPDATE_DATE,
         LAST_UPDATED_BY,
         CREATION_DATE,
         CREATED_BY,
         LAST_UPDATE_LOGIN
       )
       VALUES (
         partition_num,
         1,			/* free partition */
         sysdate,
         1,
         sysdate,
         1,
         1
       );

Line: 1051

        fnd_message.set_name('MSC','MSC_PART_INSERT_FAILED');

Line: 1090

     DELETE FROM MSC_PLAN_PARTITIONS
     WHERE plan_id = partition_num;

Line: 1094

    DELETE FROM MSC_INST_PARTITIONS
     WHERE instance_id = partition_num;

Line: 1101

      errbuf := 'delete failed'||to_char(partition_num) || '  ' ||
	        to_char(sqlcode) ||':'|| substr(sqlerrm,1,90);

Line: 1110

   SELECT plan_id, compile_designator
     FROM MSC_PLANS
    WHERE plan_id <> -1
    ORDER BY plan_id;

Line: 1165

    INSERT INTO MSC_PLAN_PARTITIONS (
      PLAN_ID,
      PLAN_NAME,
      FREE_FLAG,
      PARTITION_NUMBER,
      LAST_UPDATE_DATE,
      LAST_UPDATED_BY,
      CREATION_DATE,
      CREATED_BY,
      LAST_UPDATE_LOGIN
    )
    VALUES (
      l_plan_id,
      l_plan_name,
      2,			/* used partition */
      l_plan_id,
      sysdate,
      1,
      sysdate,
      1,
      1
     );

Line: 1202

      SELECT msc_plans_s.nextval
      INTO   l_plan_id
      FROm   dual;

Line: 1214

      INSERT INTO MSC_PLAN_PARTITIONS (
        PLAN_ID,
        PLAN_NAME,
        FREE_FLAG,
        PARTITION_NUMBER,
        LAST_UPDATE_DATE,
        LAST_UPDATED_BY,
        CREATION_DATE,
        CREATED_BY,
        LAST_UPDATE_LOGIN
       )
      VALUES (
        l_plan_id,
        to_char(l_plan_id),
        1,			/* free partition */
        l_plan_id,
        sysdate,
        1,
        sysdate,
        1,
        1
       );

Line: 1255

   SELECT plan_id
     FROM MSC_PLANS
    WHERE plan_id <> -1;

Line: 1287

  DELETE FROM MSC_PLAN_PARTITIONS;

Line: 1296

   SELECT instance_id
     FROM MSC_apps_instances
    ORDER BY instance_id;

Line: 1343

     SELECT msc_apps_instances_s.nextval
      INTO l_instance_id
      FROM DUAL;

Line: 1354

      UPDATE MSC_INST_PARTITIONS
      SET    free_flag = 1
      WHERE  instance_id = l_instance_id;

Line: 1376

   SELECT partition_number
   INTO   part_number
   FROM   MSC_PLAN_PARTITIONS
   WHERE  plan_id = x_plan_id;

Line: 1409

    SELECT a.oracle_username
    FROM   FND_ORACLE_USERID a, FND_PRODUCT_INSTALLATIONS b
    WHERE  a.oracle_id = b.oracle_id
    AND    b.application_id= 724;

Line: 1416

    SELECT 1
    FROM   all_objects
    WHERE  object_name like 'MSC_ATP_PLAN_SN'
    AND    owner = lv_msc_schema;

Line: 1423

    SELECT 1
    FROM   all_objects
    WHERE  object_name = 'MSC_SUPPLIER_TREE_MV'
    AND    owner = lv_msc_schema;

Line: 1461

  SELECT partitioned
  INTO   is_partitioned
  FROM   dba_tables
  WHERE table_name = 'MSC_SUPPLIES'
  AND   owner = lv_msc_schema;

Line: 1576

        SELECT msc_plans_s.nextval
        INTO   l_plan_id
        FROm   dual;

Line: 1604

         INSERT INTO MSC_PLAN_PARTITIONS (
         PLAN_ID,
         PLAN_NAME,
         FREE_FLAG,
         PARTITION_NUMBER,
         LAST_UPDATE_DATE,
         LAST_UPDATED_BY,
         CREATION_DATE,
         CREATED_BY,
         LAST_UPDATE_LOGIN
        )
        VALUES (
         l_plan_id,
         to_char(l_plan_id),
         1,
         l_plan_id,
         sysdate,
         X_User_Id,
         sysdate,
         X_User_Id,
         X_Login_Id
        );

Line: 1650

        SELECT msc_apps_instances_s.nextval
        INTO l_inst_id
        FROM DUAL;

Line: 1665

        UPDATE MSC_INST_PARTITIONS
        SET    free_flag = 1
        WHERE  instance_id = l_inst_id;