APPS.MSC_WS_SCENARIO_MANAGEMENT SQL Statements

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

Line: 45

        SELECT
            process_name, process_flow_id, curr_run_sequence
        INTO
            ProcessName, ProcessFlowId, CurrRunSequence
        FROM msc_planning_process
        WHERE
            process_id = ProcessId;

Line: 164

        SELECT
            plan_id, skip, owner,
            nvl(time_out,1440),
            alternate_owner,
            status, activity_type
        INTO
            PlanId, l_Skip, l_Owner, TimeOut,
            l_AltOwner, l_ActivityStatus, ActivityType
        FROM msc_planning_proc_activities
        WHERE
            process_id = ProcessId AND
            run_sequence = RunSequence AND
            process_scope = ProcessScope;

Line: 202

        SELECT user_name
        INTO   OwnerName
        FROM   fnd_user
        where  user_id = l_Owner;

Line: 220

            SELECT user_name
            INTO   AlternateOwnerName
            FROM   fnd_user
            WHERE  user_id = l_AltOwner;

Line: 337

        SELECT status
        INTO   ActivityStatus
        FROM msc_planning_proc_activities
        WHERE
            process_id = ProcessId AND
            run_sequence = RunSequence AND
            Process_Scope = ProcessScope;

Line: 464

        UPDATE msc_planning_proc_activities
        SET status = l_NewStatus
        WHERE
            process_id = ProcessId AND
            run_sequence = RunSequence AND
            Process_Scope = ProcessScope;

Line: 552

PROCEDURE UPDATE_PROCESS(
        Status             OUT NOCOPY VARCHAR2,
        UserId             IN         NUMBER,
        ResponsibilityId   IN         NUMBER,
        ProcessId          IN         NUMBER,
        RunSequence        IN         NUMBER
        ) AS
l_String            VARCHAR2(100);

Line: 572

    UPDATE msc_process_instances
    SET actual_start_date = sysdate,
        last_update_date = sysdate,
        last_updated_by = userid,
        last_update_login = userid
    WHERE
        process_id = ProcessId AND
        run_sequence = RunSequence;

Line: 595

END UPDATE_PROCESS;

Line: 598

PROCEDURE UPDATE_PROCESS_PUBLIC(
        Status             OUT NOCOPY VARCHAR2,
        UserName               IN VARCHAR2,
		   RespName     IN VARCHAR2,
		   RespApplName IN VARCHAR2,
		   SecurityGroupName      IN VARCHAR2,
		   Language            IN VARCHAR2,
        ProcessId          IN         NUMBER,
        RunSequence        IN         NUMBER
        ) AS
		     userid    number;

Line: 629

		      UPDATE_PROCESS( status,
                                      userId ,
                                    respid,
                                    ProcessId,
                                    RunSequence );

Line: 642

END UPDATE_PROCESS_PUBLIC;

Line: 668

    SELECT param_name, param_value
    FROM   msc_proc_inst_act_params
    WHERE  process_id = idProcess AND
           run_sequence = seqRun AND
           activity_id =
               ( SELECT activity_id FROM msc_planning_proc_activities
                 WHERE  process_id = idProcess AND
                        run_sequence = seqRun AND
                        process_scope = nameActivity)
    ORDER BY parameterSequence;

Line: 695

            SELECT count(*) INTO l_Dummy
            FROM   msc_proc_inst_act_params
            WHERE  process_id = ProcessId AND
                   run_sequence = RunSequence AND
                   activity_id =
                       ( SELECT activity_id FROM msc_planning_proc_activities
                         WHERE  process_id = RunSequence AND
                                run_sequence = RunSequence AND
                                process_scope = ProcessScope);

Line: 830

        SELECT 1 INTO l_Dummy
        FROM msc_scenarios
        WHERE
            NVL(valid_from, TRUNC(SYSDATE) - 1) < TRUNC(SYSDATE) AND
            NVL(valid_to, TRUNC(SYSDATE) + 1) > TRUNC(SYSDATE) AND
            scenario_id = ScenarioId;