APPS.MSC_WS_SCENARIO_MANAGEMENT dependencies on MSC_PLANNING_PROC_ACTIVITIES

Line 110: -- Desc: Qurery msc_planning_proc_activities table and returns.

106: return;
107: END GET_PROCESS_INFO_PUBLIC;
108:
109: -- =============================================================
110: -- Desc: Qurery msc_planning_proc_activities table and returns.
111: -- PlanId
112: -- Skip
113: -- Owner (Name)
114: -- Time_Out

Line 172: FROM msc_planning_proc_activities

168: status, activity_type
169: INTO
170: PlanId, l_Skip, l_Owner, TimeOut,
171: l_AltOwner, l_ActivityStatus, ActivityType
172: FROM msc_planning_proc_activities
173: WHERE
174: process_id = ProcessId AND
175: run_sequence = RunSequence AND
176: process_scope = ProcessScope;

Line 339: FROM msc_planning_proc_activities

335: BEGIN
336: -- SELECT status
337: SELECT status
338: INTO ActivityStatus
339: FROM msc_planning_proc_activities
340: WHERE
341: process_id = ProcessId AND
342: run_sequence = RunSequence AND
343: Process_Scope = ProcessScope;

Line 411: -- Desc: Update activity_status in msc_planning_proc_activities table.

407: RETURN 'OK';
408: END VALIDATE_ACTIVITY_STATUS;
409:
410: -- =============================================================
411: -- Desc: Update activity_status in msc_planning_proc_activities table.
412: -- Input:
413: -- UserId User ID.
414: -- ResponsibilityId Responsibility Id.
415: -- ProcessInstanceId Process instance Id.

Line 462: -- update msc_planning_proc_activities

458: Status := l_String;
459: RETURN;
460: END IF;
461:
462: -- update msc_planning_proc_activities
463: BEGIN
464: UPDATE msc_planning_proc_activities
465: SET status = l_NewStatus
466: WHERE

Line 464: UPDATE msc_planning_proc_activities

460: END IF;
461:
462: -- update msc_planning_proc_activities
463: BEGIN
464: UPDATE msc_planning_proc_activities
465: SET status = l_NewStatus
466: WHERE
467: process_id = ProcessId AND
468: run_sequence = RunSequence AND

Line 673: ( SELECT activity_id FROM msc_planning_proc_activities

669: FROM msc_proc_inst_act_params
670: WHERE process_id = idProcess AND
671: run_sequence = seqRun AND
672: activity_id =
673: ( SELECT activity_id FROM msc_planning_proc_activities
674: WHERE process_id = idProcess AND
675: run_sequence = seqRun AND
676: process_scope = nameActivity)
677: ORDER BY parameterSequence;

Line 700: ( SELECT activity_id FROM msc_planning_proc_activities

696: FROM msc_proc_inst_act_params
697: WHERE process_id = ProcessId AND
698: run_sequence = RunSequence AND
699: activity_id =
700: ( SELECT activity_id FROM msc_planning_proc_activities
701: WHERE process_id = RunSequence AND
702: run_sequence = RunSequence AND
703: process_scope = ProcessScope);
704: IF l_Dummy = 0 THEN