APPS.MSC_WS_APS_DATA_SERVICES dependencies on MSCFORECASTTBL

Line 100: PROCEDURE QueryForecasts(ForecastTbl OUT NOCOPY MscForecastTbl, WhereClause IN VARCHAR2);

96: FUNCTION MakeSubClause(Clause OUT NOCOPY VARCHAR2, ColumnName IN VARCHAR2, IdList IN MscChar255Arr) RETURN VARCHAR2;
97: FUNCTION GetItemClause(Clause OUT NOCOPY VARCHAR2, ItemIdList IN MscNumberArr, ProductFamilyIdList IN MscNumberArr) RETURN VARCHAR2;
98: FUNCTION GetCustomerClause(Clause OUT NOCOPY VARCHAR2, ShipToLocIdList IN MscNumberArr, CustomerIdList IN MscNumberArr, CustZonePairList IN MscCustZoneTbl, ZoneIdList IN MscNumberArr) RETURN VARCHAR2;
99: FUNCTION GetStartEndDateClause(Clause OUT NOCOPY VARCHAR2, StartDate IN DATE, EndDate IN DATE)RETURN VARCHAR2;
100: PROCEDURE QueryForecasts(ForecastTbl OUT NOCOPY MscForecastTbl, WhereClause IN VARCHAR2);
101:
102: -- =============================================================
103: --
104: -- Private helper functions for Safety Stock.

Line 1452: ForecastTbl OUT NOCOPY MscForecastTbl,

1448: --
1449: -- Output: No output.
1450: -- =============================================================
1451: PROCEDURE QueryForecasts(
1452: ForecastTbl OUT NOCOPY MscForecastTbl,
1453: WhereClause IN VARCHAR2
1454: ) AS
1455: TYPE FCSTCurType IS REF CURSOR;
1456: fcst_cursor FCSTCurType;

Line 1476: ForecastTbl := MscForecastTbl();

1472: l_Uom VARCHAR2(10);
1473: l_DemandClass VARCHAR2(240);
1474: l_UnitPrice NUMBER;
1475: BEGIN
1476: ForecastTbl := MscForecastTbl();
1477: l_Sql := 'SELECT ' ||
1478: 'nvl(bucket_type, -23453), ' ||
1479: 'nvl(start_time, to_date(''1970-01-01'', ''YYYY-MM-DD'')), ' ||
1480: 'nvl(end_time, to_date(''1970-01-01'', ''YYYY-MM-DD'')), ' ||

Line 2329: BadRecTbl OUT NOCOPY MscForecastTbl,

2325: -- BadRecTbl List of forecasts that are failed the validation.
2326: -- =============================================================
2327: PROCEDURE UPLOAD_FORECAST(
2328: Status OUT NOCOPY VARCHAR2,
2329: BadRecTbl OUT NOCOPY MscForecastTbl,
2330: -- UserId IN NUMBER,
2331: -- ResponsibilityId IN NUMBER,
2332: UserName IN VARCHAR2,
2333: RespName IN VARCHAR2,

Line 2346: ForecastTbl IN MscForecastTbl

2342: IN VARCHAR2,
2343: DemandClassOutputLevel
2344: IN VARCHAR2,
2345: PurgeAllFlag IN VARCHAR2,
2346: ForecastTbl IN MscForecastTbl
2347: ) AS
2348: l_String VARCHAR2(100);
2349: l_ResponsibilityId NUMBER;
2350: l_SecurityGroupId NUMBER;

Line 2364: BadRecTbl := MscForecastTbl();

2360: g_DummyDemandPlanName := 'Default';
2361: g_ErrorCode := '';
2362:
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

Line 2534: ForecastTbl OUT NOCOPY MscForecastTbl,

2530: -- ForecastTbl List of forecasts that are downloaded.
2531: -- =============================================================
2532: PROCEDURE DOWNLOAD_FORECAST(
2533: Status OUT NOCOPY VARCHAR2,
2534: ForecastTbl OUT NOCOPY MscForecastTbl,
2535: -- UserId IN NUMBER,
2536: -- ResponsibilityId IN NUMBER,
2537: UserName IN VARCHAR2,
2538: RespName IN VARCHAR2,

Line 2568: ForecastTbl := MscForecastTbl();

2564: -- init global variables
2565: g_ErrorCode := '';
2566:
2567: -- init output table
2568: ForecastTbl := MscForecastTbl();
2569:
2570: -- UnitTest('all MakeSubClause');
2571: -- /*
2572: