DBA Data[Home] [Help]

APPS.MSC_WS_COLLECTIONS dependencies on MSCCHAR255ARR

Line 19: FUNCTION isValid_RMA_Types( types IN MscChar255Arr, InstanceId IN Number) RETURN BOOLEAN;

15: FUNCTION isValid_DEM_COLLECTION_METHOD( methodCode IN NUMBER) RETURN BOOLEAN ;
16: FUNCTION isValid_DATE_RANGE_TYPE(CollectionMethod IN NUMBER, dateRangeType IN NUMBER) RETURN BOOLEAN;
17: FUNCTION isValid_Dates( DateRangeType in NUMBER, DateFrom in DATE, DateTo IN DATE) RETURN BOOLEAN;
18: FUNCTION isValid_Sel_Of_OrderTypes( CollectAllOrderTypes in Varchar2, IncludeOrderTypes in VARCHAR2, ExcludeOrderTypes in VARCHAR2) RETURN BOOLEAN;
19: FUNCTION isValid_RMA_Types( types IN MscChar255Arr, InstanceId IN Number) RETURN BOOLEAN;
20: FUNCTION SaveRMATypesIntoTable(RMATypes IN MscChar255Arr) RETURN BOOLEAN;
21:
22:
23:

Line 20: FUNCTION SaveRMATypesIntoTable(RMATypes IN MscChar255Arr) RETURN BOOLEAN;

16: FUNCTION isValid_DATE_RANGE_TYPE(CollectionMethod IN NUMBER, dateRangeType IN NUMBER) RETURN BOOLEAN;
17: FUNCTION isValid_Dates( DateRangeType in NUMBER, DateFrom in DATE, DateTo IN DATE) RETURN BOOLEAN;
18: FUNCTION isValid_Sel_Of_OrderTypes( CollectAllOrderTypes in Varchar2, IncludeOrderTypes in VARCHAR2, ExcludeOrderTypes in VARCHAR2) RETURN BOOLEAN;
19: FUNCTION isValid_RMA_Types( types IN MscChar255Arr, InstanceId IN Number) RETURN BOOLEAN;
20: FUNCTION SaveRMATypesIntoTable(RMATypes IN MscChar255Arr) RETURN BOOLEAN;
21:
22:
23:
24: -- =============================================================

Line 1500: RMATypes IN MscChar255Arr

1496: DateRangeType IN VARCHAR2 DEFAULT NULL,
1497: HistoryCollectionWindow IN NUMBER DEFAULT NULL,
1498: DateFrom IN DATE DEFAULT NULL,
1499: DateTo IN DATE DEFAULT NULL,
1500: RMATypes IN MscChar255Arr
1501: ) is
1502: L_VAL_RESULT VARCHAR2(30);
1503: result BOOLEAN := false;
1504: req_id NUMBER:=0;

Line 1606: RMATypes IN MscChar255Arr

1602: DateRangeType IN VARCHAR2 DEFAULT NULL,
1603: HistoryCollectionWindow IN NUMBER DEFAULT NULL,
1604: DateFrom IN DATE DEFAULT NULL,
1605: DateTo IN DATE DEFAULT NULL,
1606: RMATypes IN MscChar255Arr
1607: ) AS
1608: userid number;
1609: respid number;
1610: l_String VARCHAR2(30);

Line 1896: FUNCTION isValid_RMA_Types( types IN MscChar255Arr, InstanceId IN Number) RETURN BOOLEAN is

1892: INTO cCode FROM dual;
1893: RETURN cCode;
1894: END GetRH_DateRangeTypeAsNumber;
1895:
1896: FUNCTION isValid_RMA_Types( types IN MscChar255Arr, InstanceId IN Number) RETURN BOOLEAN is
1897: v_number NUMBER :=0;
1898: dbLink varchar2(128);
1899: dbLink2 varchar2(129);
1900: tableName varchar2(180);

Line 1945: FUNCTION SaveRMATypesIntoTable(RMATypes IN MscChar255Arr) RETURN BOOLEAN IS

1941: return true;
1942:
1943: end isValid_RMA_Types;
1944:
1945: FUNCTION SaveRMATypesIntoTable(RMATypes IN MscChar255Arr) RETURN BOOLEAN IS
1946: i NUMBER;
1947: begin
1948: if ( RMATypes is NULL or RMATypes.COUNT =0) then
1949: return true;