DBA Data[Home] [Help]

APPS.MSC_WS_APS_DATA_SERVICES dependencies on MSCCHAR255ARR

Line 96: FUNCTION MakeSubClause(Clause OUT NOCOPY VARCHAR2, ColumnName IN VARCHAR2, IdList IN MscChar255Arr) 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;
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);

Line 1255: IdList IN MscChar255Arr

1251: -- =============================================================
1252: FUNCTION MakeSubClause(
1253: Clause OUT NOCOPY VARCHAR2,
1254: ColumnName IN VARCHAR2,
1255: IdList IN MscChar255Arr
1256: ) RETURN VARCHAR2 AS
1257: l_AddComma BOOLEAN;
1258: BEGIN
1259: IF IdList.COUNT = 1 THEN

Line 2552: DemandClassList IN MscChar255Arr,

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
2556: l_String VARCHAR2(100);