APPS.MST_LAUNCH_PLAN_PKG SQL Statements

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

Line: 42

    SELECT
           Plan_Type, request_id, plan_completion_date,
           compile_designator,audit_request_id
    FROM mst_plans
    WHERE plan_id = p_plan_id;

Line: 151

             UPDATE mst_plans
             SET     request_id =  var_snapshot_req_id
             WHERE   plan_id =     v_plan_id;

Line: 206

      SELECT  DECODE(NVL(fnd_profile.value('MST_SOURCE_SETUP') ,'1'), '1',1 ,2)
      INTO    lv_setup_source_objs
      FROM    DUAL;

Line: 224

      SELECT  owner,master
      INTO  lv_snap_schema,lv_base_table_name
     FROM  ALL_SNAPSHOTS
     WHERE  name = pSNAPName
     AND OWNER = l_wsh_schema ;

Line: 260

     SELECT COUNT(object_name)
     INTO  l_objs_count
     FROM  ALL_OBJECTS
     WHERE UPPER(object_name) = 'MST_DELIVERY_DETAILS_SN_V' AND
           UPPER(object_type) = 'VIEW' AND
           UPPER(owner)       = 'APPS';

Line: 334

         UPDATE FND_PROFILE_OPTION_VALUES
         SET    PROFILE_OPTION_VALUE = '2'
         WHERE  PROFILE_OPTION_ID = (SELECT PROFILE_OPTION_ID
                                  FROM FND_PROFILE_OPTIONS
                                  WHERE PROFILE_OPTION_NAME = 'MST_SOURCE_SETUP');

Line: 339

          MSC_UTIL.MSC_LOG('Profile Option MSC_SOURCE_SETUP has been updated No ');