eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_WS_APS_DATA_SERVICES dependencies on MSC_WS_COMMON

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

2363: -- init bad record table
2364: BadRecTbl := MscForecastTbl();
2365:
2366: -- query user id, responsibility id and security group id
2367: MSC_WS_COMMON.GET_PERMISSION_IDS(l_String, g_UserId, l_ResponsibilityId, l_SecurityGroupId, UserName, RespName, RespAppName, SecurityGroupName, Language);
2368: IF (l_String <> 'OK') THEN
2369: Status := l_String;
2370: RETURN;
2371: END IF;

Line 2373: MSC_WS_COMMON.VALIDATE_USER_RESP_FUNC(l_String, g_UserId, l_ResponsibilityId, 'MSC_FNDRSRUN_LEG_COLL',l_SecurityGroupId);

2369: Status := l_String;
2370: RETURN;
2371: END IF;
2372:
2373: MSC_WS_COMMON.VALIDATE_USER_RESP_FUNC(l_String, g_UserId, l_ResponsibilityId, 'MSC_FNDRSRUN_LEG_COLL',l_SecurityGroupId);
2374: IF (l_String <> 'OK') THEN
2375: Status := l_String;
2376: RETURN;
2377: END IF;

Line 2402: IF MSC_WS_COMMON.BOOL_TO_NUMBER(PurgeAllFlag) = MSC_UTIL.SYS_YES THEN

2398: END IF;
2399:
2400: -- if PurgeAllFlag is set, purge all rows in msd_dp_scn_entries_denorm
2401: -- and msd_dp_scenario_output_levels for l_ScenarioId, if it is there.
2402: IF MSC_WS_COMMON.BOOL_TO_NUMBER(PurgeAllFlag) = MSC_UTIL.SYS_YES THEN
2403: IF l_IsNewScenario THEN
2404: CreateNewScenario(l_ScenarioId, ScenarioName);
2405: ELSE
2406: PurgeAllFcstData(l_ScenarioId);

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

2570: -- UnitTest('all MakeSubClause');
2571: -- /*
2572:
2573: -- query user id, responsibility id and security group id
2574: MSC_WS_COMMON.GET_PERMISSION_IDS(l_String, g_UserId, l_ResponsibilityId, l_SecurityGroupId, UserName, RespName, RespAppName, SecurityGroupName, Language);
2575: IF (l_String <> 'OK') THEN
2576: Status := l_String;
2577: RETURN;
2578: END IF;

Line 2580: MSC_WS_COMMON.VALIDATE_USER_RESP_FUNC(l_String, g_UserId, l_ResponsibilityId, 'MSC_FNDRSRUN_LEG_COLL',l_SecurityGroupId);

2576: Status := l_String;
2577: RETURN;
2578: END IF;
2579:
2580: MSC_WS_COMMON.VALIDATE_USER_RESP_FUNC(l_String, g_UserId, l_ResponsibilityId, 'MSC_FNDRSRUN_LEG_COLL',l_SecurityGroupId);
2581: IF (l_String <> 'OK') THEN
2582: Status := l_String;
2583: RETURN;
2584: END IF;

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

2740: -- init bad record table
2741: BadRecTbl := MscSafetyStockTbl();
2742:
2743: -- query user id, responsibility id and security group id
2744: MSC_WS_COMMON.GET_PERMISSION_IDS(l_String, g_UserId, l_ResponsibilityId, l_SecurityGroupId, UserName, RespName, RespAppName, SecurityGroupName, Language);
2745: IF (l_String <> 'OK') THEN
2746: Status := l_String;
2747: RETURN;
2748: END IF;

Line 2750: MSC_WS_COMMON.VALIDATE_USER_RESP_FUNC(l_String, g_UserId, l_ResponsibilityId, 'MSC_FNDRSRUN_LEG_COLL',l_SecurityGroupId);

2746: Status := l_String;
2747: RETURN;
2748: END IF;
2749:
2750: MSC_WS_COMMON.VALIDATE_USER_RESP_FUNC(l_String, g_UserId, l_ResponsibilityId, 'MSC_FNDRSRUN_LEG_COLL',l_SecurityGroupId);
2751: IF (l_String <> 'OK') THEN
2752: Status := l_String;
2753: RETURN;
2754: END IF;

Line 2787: IF MSC_WS_COMMON.BOOL_TO_NUMBER(PurgeAllFlag) = MSC_UTIL.SYS_YES THEN

2783: RETURN;
2784: END IF;
2785:
2786: -- if PurgeAllFlag is set, purge all rows in msc_safety_stocks table for l_PlanId.
2787: IF MSC_WS_COMMON.BOOL_TO_NUMBER(PurgeAllFlag) = MSC_UTIL.SYS_YES THEN
2788: BEGIN
2789: DELETE FROM msc_safety_stocks
2790: WHERE
2791: plan_id = l_PlanId;

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

2885: -- init output table
2886: SafetyStockTbl := MscSafetyStockTbl();
2887:
2888: -- query user id, responsibility id and security group id
2889: MSC_WS_COMMON.GET_PERMISSION_IDS(l_String, g_UserId, l_ResponsibilityId, l_SecurityGroupId, UserName, RespName, RespAppName, SecurityGroupName, Language);
2890: IF (l_String <> 'OK') THEN
2891: Status := l_String;
2892: RETURN;
2893: END IF;

Line 2895: MSC_WS_COMMON.VALIDATE_USER_RESP_FUNC(l_String, g_UserId, l_ResponsibilityId, 'MSC_FNDRSRUN_LEG_COLL',l_SecurityGroupId);

2891: Status := l_String;
2892: RETURN;
2893: END IF;
2894:
2895: MSC_WS_COMMON.VALIDATE_USER_RESP_FUNC(l_String, g_UserId, l_ResponsibilityId, 'MSC_FNDRSRUN_LEG_COLL',l_SecurityGroupId);
2896: IF (l_String <> 'OK') THEN
2897: Status := l_String;
2898: RETURN;
2899: END IF;

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

3000: -- init bad record table
3001: BadRecTbl := MscPlannedSupplyTbl();
3002:
3003: -- query user id, responsibility id and security group id
3004: MSC_WS_COMMON.GET_PERMISSION_IDS(l_String, g_UserId, l_ResponsibilityId, l_SecurityGroupId, UserName, RespName, RespAppName, SecurityGroupName, Language);
3005: IF (l_String <> 'OK') THEN
3006: Status := l_String;
3007: RETURN;
3008: END IF;

Line 3010: MSC_WS_COMMON.VALIDATE_USER_RESP_FUNC(l_String, g_UserId, l_ResponsibilityId, 'MSC_FNDRSRUN_LEG_COLL',l_SecurityGroupId);

3006: Status := l_String;
3007: RETURN;
3008: END IF;
3009:
3010: MSC_WS_COMMON.VALIDATE_USER_RESP_FUNC(l_String, g_UserId, l_ResponsibilityId, 'MSC_FNDRSRUN_LEG_COLL',l_SecurityGroupId);
3011: IF (l_String <> 'OK') THEN
3012: Status := l_String;
3013: RETURN;
3014: END IF;