63: END IF;
64: --
65: --Retrieve the dummy (unidentified) customer id which is used by EMC
66: --
67: IF (FND_PROFILE.DEFINED('IEM_DEFAULT_CUSTOMER_ID')) THEN
68: l_dummy_cust := TO_NUMBER(FND_PROFILE.VALUE('IEM_DEFAULT_CUSTOMER_ID'));
69: END IF;
70:
71: --
64: --
65: --Retrieve the dummy (unidentified) customer id which is used by EMC
66: --
67: IF (FND_PROFILE.DEFINED('IEM_DEFAULT_CUSTOMER_ID')) THEN
68: l_dummy_cust := TO_NUMBER(FND_PROFILE.VALUE('IEM_DEFAULT_CUSTOMER_ID'));
69: END IF;
70:
71: --
72: --If it is null then set it to some invalid value so the SQL does not error