APPS.MSC_WS_APS_DATA_SERVICES dependencies on MSCCUSTZONETBL

Line 95: FUNCTION MakeSubClause(Clause OUT NOCOPY VARCHAR2, ColumnName1 IN VARCHAR2, ColumnName2 IN VARCHAR2, IdPairList IN MscCustZoneTbl) RETURN VARCHAR2;

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;
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;

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 1209: IdPairList IN MscCustZoneTbl

1205: FUNCTION MakeSubClause(
1206: Clause OUT NOCOPY VARCHAR2,
1207: ColumnName1 IN VARCHAR2,
1208: ColumnName2 IN VARCHAR2,
1209: IdPairList IN MscCustZoneTbl
1210: ) RETURN VARCHAR2 AS
1211: l_AddOr BOOLEAN;
1212: l_Clause VARCHAR2(1024);
1213: BEGIN

Line 1348: CustZonePairList IN MscCustZoneTbl,

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

Line 2550: CustomerZoneList IN MscCustZoneTbl,

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,
2554: EndDate IN DATE