DBA Data[Home] [Help]

APPS.MSC_WS_SCENARIO_MANAGEMENT dependencies on MSC_PLANNING_PROCESS

Line 7: -- Desc: Qurery msc_planning_process table and returns.

3: g_UserId NUMBER;
4: g_ErrorCode VARCHAR2(9);
5:
6: -- =============================================================
7: -- Desc: Qurery msc_planning_process table and returns.
8: -- ProcessName
9: -- ProcessFlowId
10: -- CurrRunSequence
11: --

Line 49: FROM msc_planning_process

45: SELECT
46: process_name, process_flow_id, curr_run_sequence
47: INTO
48: ProcessName, ProcessFlowId, CurrRunSequence
49: FROM msc_planning_process
50: WHERE
51: process_id = ProcessId;
52: EXCEPTION
53: WHEN no_data_found THEN

Line 537: -- Desc: Update msc_planning_process.curr_run_sequence and

533: return;
534: END SET_ACTIVITY_INST_ST_PUBLIC;
535:
536: -- =============================================================
537: -- Desc: Update msc_planning_process.curr_run_sequence and
538: -- msc_process_instances.actual_start_date.
539: -- Input:
540: -- UserId User ID.
541: -- ResponsibilityId Responsibility Id.