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 MSCNUMBERARR

Line 74: PROCEDURE MakeOutputLevelSet(OutputLevels OUT NOCOPY MscNumberArr, ItemOutputLevel IN VARCHAR2, OrganizationOutputLevel IN VARCHAR2, CustomerOutputLevel IN VARCHAR2, DemandClassOutputLevel IN VARCHAR2);

70: FUNCTION GetScenarioId(ScenarioId OUT NOCOPY NUMBER, DemandPlanId IN NUMBER, ScenarioName IN VARCHAR2) RETURN VARCHAR2;
71:
72: -- Private helper functions used by UPLOAD_FORECAST only.
73: PROCEDURE CreateNewScenario(ScenarioId OUT NOCOPY NUMBER, ScenarioName IN VARCHAR2);
74: PROCEDURE MakeOutputLevelSet(OutputLevels OUT NOCOPY MscNumberArr, ItemOutputLevel IN VARCHAR2, OrganizationOutputLevel IN VARCHAR2, CustomerOutputLevel IN VARCHAR2, DemandClassOutputLevel IN VARCHAR2);
75: PROCEDURE PurgeAllFcstData(ScenarioId IN NUMBER);
76: PROCEDURE InsertOutputLevels(ScenarioId IN NUMBER, ItemOutputLevel IN VARCHAR2, OrganizationOutputLevel IN VARCHAR2, CustomerOutputLevel IN VARCHAR2, DemandClassOutputLevel IN VARCHAR2);
77: FUNCTION ValidateOutputLevels(ScenarioId IN NUMBER, ItemOutputLevel IN VARCHAR2, OrganizationOutputLevel IN VARCHAR2, CustomerOutputLevel IN VARCHAR2, DemandClassOutputLevel IN VARCHAR2) RETURN VARCHAR2;
78: FUNCTION ValidateBucketType(BucketType IN NUMBER) RETURN VARCHAR2;

Line 92: FUNCTION MakeSubClause(Clause OUT NOCOPY VARCHAR2, ColumnName IN VARCHAR2, IdList IN MscNumberArr) RETURN VARCHAR2;

88: FUNCTION ProcessForecast(ScenarioId IN NUMBER, OutputToItem IN VARCHAR2, OutputToOrganization IN VARCHAR2, OutputToCustomer IN VARCHAR2, OutputToDemandClass IN VARCHAR2, ForecastData IN MscForecastRec) RETURN VARCHAR2;
89:
90: -- Private helper functions used by DOWNLOAD_FORECAST and DOWNLOAD_SAFETY_STOCK.
91: FUNCTION GetDemandPlanId(DemandPlanId OUT NOCOPY NUMBER, DemandPlanName IN VARCHAR2) RETURN VARCHAR2;
92: FUNCTION MakeSubClause(Clause OUT NOCOPY VARCHAR2, ColumnName IN VARCHAR2, IdList IN MscNumberArr) RETURN VARCHAR2;
93:
94: -- Private helper functions used by DOWNLOAD_FORECAST only.
95: FUNCTION MakeSubClause(Clause OUT NOCOPY VARCHAR2, ColumnName1 IN VARCHAR2, ColumnName2 IN VARCHAR2, IdPairList IN MscCustZoneTbl) RETURN VARCHAR2;
96: FUNCTION MakeSubClause(Clause OUT NOCOPY VARCHAR2, ColumnName IN VARCHAR2, IdList IN MscChar255Arr) RETURN VARCHAR2;

Line 97: FUNCTION GetItemClause(Clause OUT NOCOPY VARCHAR2, ItemIdList IN MscNumberArr, ProductFamilyIdList IN MscNumberArr) RETURN VARCHAR2;

93:
94: -- Private helper functions used by DOWNLOAD_FORECAST only.
95: FUNCTION MakeSubClause(Clause OUT NOCOPY VARCHAR2, ColumnName1 IN VARCHAR2, ColumnName2 IN VARCHAR2, IdPairList IN MscCustZoneTbl) RETURN 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:

Line 98: FUNCTION GetCustomerClause(Clause OUT NOCOPY VARCHAR2, ShipToLocIdList IN MscNumberArr, CustomerIdList IN MscNumberArr, CustZonePairList IN MscCustZoneTbl, ZoneIdList IN MscNumberArr) RETURN VARCHAR2;

94: -- Private helper functions used by DOWNLOAD_FORECAST only.
95: FUNCTION MakeSubClause(Clause OUT NOCOPY VARCHAR2, ColumnName1 IN VARCHAR2, ColumnName2 IN VARCHAR2, IdPairList IN MscCustZoneTbl) RETURN 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: -- =============================================================

Line 249: OutputLevels OUT NOCOPY MscNumberArr,

245: --
246: -- Output: No output.
247: -- =============================================================
248: PROCEDURE MakeOutputLevelSet(
249: OutputLevels OUT NOCOPY MscNumberArr,
250: ItemOutputLevel IN VARCHAR2,
251: OrganizationOutputLevel
252: IN VARCHAR2,
253: CustomerOutputLevel IN VARCHAR2,

Line 259: OutputLevels := MscNumberArr(1);

255: IN VARCHAR2
256: ) AS
257: BEGIN
258: -- all the output levels are restricted by xsd
259: OutputLevels := MscNumberArr(1);
260: IF ItemOutputLevel = 'PRODUCT_FAMILY' THEN
261: OutputLevels(1) := 3;
262: END IF;
263: IF OrganizationOutputLevel = 'Y' THEN

Line 341: l_OutputLevels MscNumberArr;

337: IN VARCHAR2,
338: DemandClassOutputLevel
339: IN VARCHAR2
340: ) AS
341: l_OutputLevels MscNumberArr;
342: BEGIN
343: l_OutputLevels := MscNumberArr();
344: MakeOutputLevelSet(l_OutputLevels, ItemOutputLevel, OrganizationOutputLevel, CustomerOutputLevel, DemandClassOutputLevel);
345: FOR I IN l_OutputLevels.first..l_OutputLevels.last

Line 343: l_OutputLevels := MscNumberArr();

339: IN VARCHAR2
340: ) AS
341: l_OutputLevels MscNumberArr;
342: BEGIN
343: l_OutputLevels := MscNumberArr();
344: MakeOutputLevelSet(l_OutputLevels, ItemOutputLevel, OrganizationOutputLevel, CustomerOutputLevel, DemandClassOutputLevel);
345: FOR I IN l_OutputLevels.first..l_OutputLevels.last
346: LOOP
347: INSERT INTO msd_dp_scenario_output_levels

Line 392: l_OutputLevels MscNumberArr;

388: IN VARCHAR2,
389: DemandClassOutputLevel
390: IN VARCHAR2
391: ) RETURN VARCHAR2 AS
392: l_OutputLevels MscNumberArr;
393: l_Count NUMBER;
394: BEGIN
395: l_OutputLevels := MscNumberArr();
396: MakeOutputLevelSet(l_OutputLevels, ItemOutputLevel, OrganizationOutputLevel, CustomerOutputLevel, DemandClassOutputLevel);

Line 395: l_OutputLevels := MscNumberArr();

391: ) RETURN VARCHAR2 AS
392: l_OutputLevels MscNumberArr;
393: l_Count NUMBER;
394: BEGIN
395: l_OutputLevels := MscNumberArr();
396: MakeOutputLevelSet(l_OutputLevels, ItemOutputLevel, OrganizationOutputLevel, CustomerOutputLevel, DemandClassOutputLevel);
397:
398: BEGIN
399: -- check number of output levels

Line 1163: IdList IN MscNumberArr

1159: -- =============================================================
1160: FUNCTION MakeSubClause(
1161: Clause OUT NOCOPY VARCHAR2,
1162: ColumnName IN VARCHAR2,
1163: IdList IN MscNumberArr
1164: ) RETURN VARCHAR2 AS
1165: l_AddComma BOOLEAN;
1166: BEGIN
1167: IF IdList.COUNT = 1 THEN

Line 1299: ItemIdList IN MscNumberArr,

1295: -- INVALID_PRODUCT_FAMILY_ID
1296: -- =============================================================
1297: FUNCTION GetItemClause(
1298: Clause OUT NOCOPY VARCHAR2,
1299: ItemIdList IN MscNumberArr,
1300: ProductFamilyIdList IN MscNumberArr
1301: ) RETURN VARCHAR2 AS
1302: l_String VARCHAR2(100);
1303: BEGIN

Line 1300: ProductFamilyIdList IN MscNumberArr

1296: -- =============================================================
1297: FUNCTION GetItemClause(
1298: Clause OUT NOCOPY VARCHAR2,
1299: ItemIdList IN MscNumberArr,
1300: ProductFamilyIdList IN MscNumberArr
1301: ) RETURN VARCHAR2 AS
1302: l_String VARCHAR2(100);
1303: BEGIN
1304: -- If any item or product family id is specified, make sure it is consistantent

Line 1346: ShipToLocIdList IN MscNumberArr,

1342: -- INVALID_SR_ZONE_ID
1343: -- =============================================================
1344: FUNCTION GetCustomerClause(
1345: Clause OUT NOCOPY VARCHAR2,
1346: ShipToLocIdList IN MscNumberArr,
1347: CustomerIdList IN MscNumberArr,
1348: CustZonePairList IN MscCustZoneTbl,
1349: ZoneIdList IN MscNumberArr
1350: ) RETURN VARCHAR2 AS

Line 1347: CustomerIdList IN MscNumberArr,

1343: -- =============================================================
1344: FUNCTION GetCustomerClause(
1345: Clause OUT NOCOPY VARCHAR2,
1346: ShipToLocIdList IN MscNumberArr,
1347: CustomerIdList IN MscNumberArr,
1348: CustZonePairList IN MscCustZoneTbl,
1349: ZoneIdList IN MscNumberArr
1350: ) RETURN VARCHAR2 AS
1351: l_HasCustomer BOOLEAN;

Line 1349: ZoneIdList IN MscNumberArr

1345: Clause OUT NOCOPY VARCHAR2,
1346: ShipToLocIdList IN MscNumberArr,
1347: CustomerIdList IN MscNumberArr,
1348: CustZonePairList IN MscCustZoneTbl,
1349: ZoneIdList IN MscNumberArr
1350: ) RETURN VARCHAR2 AS
1351: l_HasCustomer BOOLEAN;
1352: l_String VARCHAR2(100);
1353: BEGIN

Line 2544: ItemIdList IN MscNumberArr,

2540: SecurityGroupName IN VARCHAR2,
2541: Language IN VARCHAR2,
2542: DemandPlanName IN VARCHAR2,
2543: ScenarioName IN VARCHAR2,
2544: ItemIdList IN MscNumberArr,
2545: ProductFamilyIdList
2546: IN MscNumberArr,
2547: OrganizationIdList IN MscNumberArr,
2548: ShipToLocIdList IN MscNumberArr,

Line 2546: IN MscNumberArr,

2542: DemandPlanName IN VARCHAR2,
2543: ScenarioName IN VARCHAR2,
2544: ItemIdList IN MscNumberArr,
2545: ProductFamilyIdList
2546: IN MscNumberArr,
2547: OrganizationIdList IN MscNumberArr,
2548: ShipToLocIdList IN MscNumberArr,
2549: CustomerIdList IN MscNumberArr,
2550: CustomerZoneList IN MscCustZoneTbl,

Line 2547: OrganizationIdList IN MscNumberArr,

2543: ScenarioName IN VARCHAR2,
2544: ItemIdList IN MscNumberArr,
2545: ProductFamilyIdList
2546: IN MscNumberArr,
2547: OrganizationIdList IN MscNumberArr,
2548: ShipToLocIdList IN MscNumberArr,
2549: CustomerIdList IN MscNumberArr,
2550: CustomerZoneList IN MscCustZoneTbl,
2551: ZoneIdList IN MscNumberArr,

Line 2548: ShipToLocIdList IN MscNumberArr,

2544: ItemIdList IN MscNumberArr,
2545: ProductFamilyIdList
2546: IN MscNumberArr,
2547: OrganizationIdList IN MscNumberArr,
2548: ShipToLocIdList IN MscNumberArr,
2549: CustomerIdList IN MscNumberArr,
2550: CustomerZoneList IN MscCustZoneTbl,
2551: ZoneIdList IN MscNumberArr,
2552: DemandClassList IN MscChar255Arr,

Line 2549: CustomerIdList IN MscNumberArr,

2545: ProductFamilyIdList
2546: IN MscNumberArr,
2547: OrganizationIdList IN MscNumberArr,
2548: ShipToLocIdList IN MscNumberArr,
2549: CustomerIdList IN MscNumberArr,
2550: CustomerZoneList IN MscCustZoneTbl,
2551: ZoneIdList IN MscNumberArr,
2552: DemandClassList IN MscChar255Arr,
2553: StartDate IN DATE,

Line 2551: ZoneIdList IN MscNumberArr,

2547: OrganizationIdList IN MscNumberArr,
2548: ShipToLocIdList IN MscNumberArr,
2549: CustomerIdList IN MscNumberArr,
2550: CustomerZoneList IN MscCustZoneTbl,
2551: ZoneIdList IN MscNumberArr,
2552: DemandClassList IN MscChar255Arr,
2553: StartDate IN DATE,
2554: EndDate IN DATE
2555: ) AS

Line 2875: ItemIdList IN MscNumberArr,

2871: Language IN VARCHAR2,
2872: PlanName IN VARCHAR2,
2873: OwningOrgId IN NUMBER,
2874: SrInstanceId IN NUMBER,
2875: ItemIdList IN MscNumberArr,
2876: OrganizationIdList IN MscNumberArr
2877: ) AS
2878: l_String VARCHAR2(100);
2879: l_ResponsibilityId NUMBER;

Line 2876: OrganizationIdList IN MscNumberArr

2872: PlanName IN VARCHAR2,
2873: OwningOrgId IN NUMBER,
2874: SrInstanceId IN NUMBER,
2875: ItemIdList IN MscNumberArr,
2876: OrganizationIdList IN MscNumberArr
2877: ) AS
2878: l_String VARCHAR2(100);
2879: l_ResponsibilityId NUMBER;
2880: l_SecurityGroupId NUMBER;