APPS.MSC_WS_COLLECTIONS dependencies on DUAL

Line 1657: INTO cCode FROM dual;

1653: BEGIN
1654: --SELECT lookup_code INTO cCode FROM mfg_lookups WHERE lookup_type = 'PARTIAL_YES_NO' AND meaning = CollectionMethod;
1655:
1656: SELECT to_number(decode(CollectionMethod,'COMPLETE_REFRESH',1,'NET_CHANGE_REFRESH',2,'TARGETED_REFRESH',3, -1))
1657: INTO cCode FROM dual;
1658:
1659: RETURN cCode;
1660:
1661:

Line 1671: INTO cCode FROM dual;

1667: BEGIN
1668: --SELECT lookup_code INTO cCode FROM mfg_lookupsWHERE lookup_type = 'MSC_X_ASL_SYS_YES_NO' AND meaning = ApprovedSupplierList;
1669: -- bnaghi bug 6861953
1670: SELECT to_number(decode(ApprovedSupplierList,'YES_REPLACE',1,'NO',2,'YES_BUT_RETAIN_CP', 3,-1))
1671: INTO cCode FROM dual;
1672:
1673: RETURN cCode;
1674:
1675: END GetLookupCodeForAppSuppList;

Line 1684: INTO cCode FROM dual;

1680: BEGIN
1681: --SELECT lookup_code INTO cCode FROM fnd_lookups WHERE lookup_type = 'MSC_X_USER_COMPANY' AND meaning = UserCompanyAssoc;
1682:
1683: SELECT to_number(decode(UserCompanyAssoc,'CREATE_USERS_ENABLE_UCA',3,'NO',1,'ENABLE_UCA', 2,-1))
1684: INTO cCode FROM dual;
1685:
1686: RETURN cCode;
1687:
1688: END GetUserCompAssoc;

Line 1697: INTO cCode FROM dual;

1693: BEGIN
1694: --SELECT lookup_type, meaning, lookup_code FROM mfg_lookups WHERE lookup_type = 'MSC_NRA_ENABLED'
1695: -- bnaghi bug 6861953
1696: SELECT to_number(decode(ResourceAvailability,'COLLECT_DATA',1,'DO_NOT_COLLECT_DATA',2,'REGENERATE_DATA', 3,-1))
1697: INTO cCode FROM dual;
1698:
1699: RETURN cCode;
1700:
1701: END GetResAvail;

Line 1874: SELECT msd_dem_common_utilities.get_lookup_value ('MSD_DEM_DM_STAGING_TABLES', 'SALES_STAGING_TABLE') into value from dual;

1870:
1871: FUNCTION Dem_ULC_GetDestTableName RETURN VARCHAR2 is
1872: value varchar(80);
1873: BEGIN
1874: SELECT msd_dem_common_utilities.get_lookup_value ('MSD_DEM_DM_STAGING_TABLES', 'SALES_STAGING_TABLE') into value from dual;
1875: RETURN value;
1876: END Dem_ULC_GetDestTableName;
1877:
1878: FUNCTION GetRH_CollectionMethodAsNumber( CollectionMethod IN VARCHAR2) RETURN NUMBER IS

Line 1883: INTO cCode FROM dual;

1879: cCode NUMBER;
1880: BEGIN
1881:
1882: SELECT to_number(decode(CollectionMethod,'COMPLETE',1,'NET_CHANGE',2, -1))
1883: INTO cCode FROM dual;
1884: RETURN cCode;
1885: END GetRH_CollectionMethodAsNumber;
1886:
1887: FUNCTION GetRH_DateRangeTypeAsNumber(DateRangeType IN Varchar2) RETURN NUMBER IS

Line 1892: INTO cCode FROM dual;

1888: cCode NUMBER;
1889: BEGIN
1890:
1891: SELECT to_number(decode(DateRangeType,'ABSOLUTE',1,'ROLLING',2, -1))
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

Line 1914: select DECODE(dbLink, NULL,'', '@' || dbLink) into dbLink2 from dual;

1910: select a2m_dblink into dbLink
1911: from msc_apps_instances
1912: where instance_id = InstanceId;
1913:
1914: select DECODE(dbLink, NULL,'', '@' || dbLink) into dbLink2 from dual;
1915: tableName := 'oe_transaction_types_tl' || dbLink2;
1916: tableNameAll := 'oe_transaction_types_all' || dbLink2;
1917:
1918: