DBA Data[Home] [Help]

APPS.MSC_WS_SCENARIO_MANAGEMENT dependencies on MSC_WS_COMMON

Line 38: MSC_WS_COMMON.VALIDATE_USER_RESP(l_String, UserId, ResponsibilityId);

34: l_Owner NUMBER;
35: l_ActivityStatus NUMBER;
36: BEGIN
37: -- check user id and responsibility
38: MSC_WS_COMMON.VALIDATE_USER_RESP(l_String, UserId, ResponsibilityId);
39: IF (l_String <> 'OK') THEN
40: Status := l_String;
41: RETURN;
42: END IF;

Line 84: MSC_WS_COMMON.GET_PERMISSION_IDS(l_String, userid, respid, l_SecutirtGroupId, UserName, RespName, RespApplName, SecurityGroupName, Language);

80: error_tracking_num number;
81: l_SecutirtGroupId NUMBER;
82: BEGIN
83: error_tracking_num :=2010;
84: MSC_WS_COMMON.GET_PERMISSION_IDS(l_String, userid, respid, l_SecutirtGroupId, UserName, RespName, RespApplName, SecurityGroupName, Language);
85: IF (l_String <> 'OK') THEN
86: Status := l_String;
87: RETURN;
88: END IF;

Line 91: MSC_WS_COMMON.VALIDATE_USER_RESP_FUNC(l_String, userid, respid, 'MSC_SCN_MANAGE_SCENARIOS',l_SecutirtGroupId);

87: RETURN;
88: END IF;
89:
90: error_tracking_num :=2030;
91: MSC_WS_COMMON.VALIDATE_USER_RESP_FUNC(l_String, userid, respid, 'MSC_SCN_MANAGE_SCENARIOS',l_SecutirtGroupId);
92: IF (l_String <> 'OK') THEN
93: Status := l_String;
94: RETURN;
95: END IF;

Line 157: --MSC_WS_COMMON.VALIDATE_USER_RESP(l_String, UserId, ResponsibilityId);

153: l_AltOwner NUMBER;
154: l_ActivityStatus NUMBER;
155: BEGIN
156: -- check user id and responsibility
157: --MSC_WS_COMMON.VALIDATE_USER_RESP(l_String, UserId, ResponsibilityId);
158: --IF (l_String <> 'OK') THEN
159: -- Status := l_String;
160: -- RETURN;
161: -- END IF;

Line 281: MSC_WS_COMMON.GET_PERMISSION_IDS(l_String, userid, respid, l_SecutirtGroupId, UserName, RespName, RespApplName, SecurityGroupName, Language);

277: error_tracking_num number;
278: l_SecutirtGroupId NUMBER;
279: BEGIN
280: error_tracking_num :=2010;
281: MSC_WS_COMMON.GET_PERMISSION_IDS(l_String, userid, respid, l_SecutirtGroupId, UserName, RespName, RespApplName, SecurityGroupName, Language);
282: IF (l_String <> 'OK') THEN
283: Status := l_String;
284: RETURN;
285: END IF;

Line 288: MSC_WS_COMMON.VALIDATE_USER_RESP_FUNC(l_String, userid, respid, 'MSC_SCN_MANAGE_SCENARIOS',l_SecutirtGroupId);

284: RETURN;
285: END IF;
286:
287: error_tracking_num :=2030;
288: MSC_WS_COMMON.VALIDATE_USER_RESP_FUNC(l_String, userid, respid, 'MSC_SCN_MANAGE_SCENARIOS',l_SecutirtGroupId);
289: IF (l_String <> 'OK') THEN
290: Status := l_String;
291: RETURN;
292: END IF;

Line 441: -- MSC_WS_COMMON.VALIDATE_USER_RESP(l_String, UserId, ResponsibilityId);

437: l_String VARCHAR2(100);
438: l_NewStatus NUMBER;
439: BEGIN
440: -- check user id and responsibility
441: -- MSC_WS_COMMON.VALIDATE_USER_RESP(l_String, UserId, ResponsibilityId);
442: -- IF (l_String <> 'OK') THEN
443: -- Status := l_String;
444: -- RETURN;
445: -- END IF;

Line 505: MSC_WS_COMMON.GET_PERMISSION_IDS(l_String, userid, respid, l_SecutirtGroupId, UserName, RespName, RespApplName, SecurityGroupName, Language);

501: error_tracking_num number;
502: l_SecutirtGroupId NUMBER;
503: BEGIN
504: error_tracking_num :=2010;
505: MSC_WS_COMMON.GET_PERMISSION_IDS(l_String, userid, respid, l_SecutirtGroupId, UserName, RespName, RespApplName, SecurityGroupName, Language);
506: IF (l_String <> 'OK') THEN
507: Status := l_String;
508: RETURN;
509: END IF;

Line 512: MSC_WS_COMMON.VALIDATE_USER_RESP_FUNC(l_String, userid, respid, 'MSC_SCN_MANAGE_SCENARIOS',l_SecutirtGroupId);

508: RETURN;
509: END IF;
510:
511: error_tracking_num :=2030;
512: MSC_WS_COMMON.VALIDATE_USER_RESP_FUNC(l_String, userid, respid, 'MSC_SCN_MANAGE_SCENARIOS',l_SecutirtGroupId);
513: IF (l_String <> 'OK') THEN
514: Status := l_String;
515: RETURN;
516: END IF;

Line 564: -- MSC_WS_COMMON.VALIDATE_USER_RESP(l_String, UserId, ResponsibilityId);

560: l_NextActivityId NUMBER;
561: e_NoDataFound EXCEPTION;
562: BEGIN
563: -- check user id and responsibility
564: -- MSC_WS_COMMON.VALIDATE_USER_RESP(l_String, UserId, ResponsibilityId);
565: -- IF (l_String <> 'OK') THEN
566: -- Status := l_String;
567: -- RETURN;
568: -- END IF;

Line 615: MSC_WS_COMMON.GET_PERMISSION_IDS(l_String, userid, respid, l_SecutirtGroupId, UserName, RespName, RespApplName, SecurityGroupName, Language);

611: error_tracking_num number;
612: l_SecutirtGroupId NUMBER;
613: BEGIN
614: error_tracking_num :=2010;
615: MSC_WS_COMMON.GET_PERMISSION_IDS(l_String, userid, respid, l_SecutirtGroupId, UserName, RespName, RespApplName, SecurityGroupName, Language);
616: IF (l_String <> 'OK') THEN
617: Status := l_String;
618: RETURN;
619: END IF;

Line 622: MSC_WS_COMMON.VALIDATE_USER_RESP_FUNC(l_String, userid, respid, 'MSC_SCN_MANAGE_SCENARIOS',l_SecutirtGroupId);

618: RETURN;
619: END IF;
620:
621: error_tracking_num :=2030;
622: MSC_WS_COMMON.VALIDATE_USER_RESP_FUNC(l_String, userid, respid, 'MSC_SCN_MANAGE_SCENARIOS',l_SecutirtGroupId);
623: IF (l_String <> 'OK') THEN
624: Status := l_String;
625: RETURN;
626: END IF;

Line 738: MSC_WS_COMMON.GET_PERMISSION_IDS(l_String, userid, respid, l_SecutirtGroupId, UserName, RespName, RespApplName, SecurityGroupName, Language);

734: l_SecutirtGroupId NUMBER;
735: BEGIN
736: ParameterValues := MscActivityParaTbl();
737: error_tracking_num :=2010;
738: MSC_WS_COMMON.GET_PERMISSION_IDS(l_String, userid, respid, l_SecutirtGroupId, UserName, RespName, RespApplName, SecurityGroupName, Language);
739: IF (l_String <> 'OK') THEN
740: Status := l_String;
741: RETURN;
742: END IF;

Line 745: MSC_WS_COMMON.VALIDATE_USER_RESP_FUNC(l_String, userid, respid, 'MSC_SCN_MANAGE_SCENARIOS',l_SecutirtGroupId);

741: RETURN;
742: END IF;
743:
744: error_tracking_num :=2030;
745: MSC_WS_COMMON.VALIDATE_USER_RESP_FUNC(l_String, userid, respid, 'MSC_SCN_MANAGE_SCENARIOS',l_SecutirtGroupId);
746: IF (l_String <> 'OK') THEN
747: Status := l_String;
748: RETURN;
749: END IF;

Line 816: MSC_WS_COMMON.GET_PERMISSION_IDS(l_String, g_UserId, l_ResponsibilityId, l_SecurityGroupId, UserName, RespName, RespAppName, SecurityGroupName, Language);

812: g_ErrorCode := '';
813: ProcessId := -1;
814:
815: -- query user id, responsibility id and security group id
816: MSC_WS_COMMON.GET_PERMISSION_IDS(l_String, g_UserId, l_ResponsibilityId, l_SecurityGroupId, UserName, RespName, RespAppName, SecurityGroupName, Language);
817: IF (l_String <> 'OK') THEN
818: Status := l_String;
819: RETURN;
820: END IF;

Line 822: MSC_WS_COMMON.VALIDATE_USER_RESP_FUNC(l_String, g_UserId, l_ResponsibilityId, 'MSC_SCN_MANAGE_SCENARIOS',l_SecurityGroupId);

818: Status := l_String;
819: RETURN;
820: END IF;
821: error_tracking_num :=2030;
822: MSC_WS_COMMON.VALIDATE_USER_RESP_FUNC(l_String, g_UserId, l_ResponsibilityId, 'MSC_SCN_MANAGE_SCENARIOS',l_SecurityGroupId);
823: IF (l_String <> 'OK') THEN
824: Status := l_String;
825: RETURN;
826: END IF;