1769: cCode NUMBER;
1770: BEGIN
1771:
1772: SELECT lookup_code INTO cCode
1773: FROM fnd_lookup_values_vl flv
1774: WHERE flv.lookup_type = 'MSD_DEM_COLL_METHODS'
1775: AND flv.lookup_code = methodCode;
1776:
1777: RETURN true;
1794: BEGIN
1795: -- If collection method is 2 (Netchange), then the dateRangeType
1796: -- Is required. Otherwise, dateRangeType need to be NULL
1797: IF (CollectionMethod = 2) THEN
1798: SELECT lookup_code into cCode from fnd_lookup_values_vl flv
1799: WHERE flv.lookup_type = 'MSD_DEM_DATE_RANGE_TYPES'
1800: --AND '1' = hiddenParam
1801: AND lookup_code= dateRangeType;
1802: