DBA Data[Home] [Help]

APPS.DOM_WS_INTERFACE_PUB dependencies on DOM_REPOSITORIES

Line 58: SELECT Count(*) INTO l_count FROM dom_repositories WHERE protocol = 'WEBSERVICES';

54: (select profile_option_id FROM fnd_profile_options WHERE profile_option_name = 'EGO_ENABLE_PLM')
55: AND LEVEL_ID =10001 AND LEVEL_VALUE=0;
56:
57: IF (l_profile_option_value = '1') THEN
58: SELECT Count(*) INTO l_count FROM dom_repositories WHERE protocol = 'WEBSERVICES';
59:
60: IF(l_count > 0) THEN
61: -- For bug 8401333
62:

Line 204: FROM DOM_REPOSITORIES_VL DomRepositories,

200: DomRepositories.SERVICE_URL,
201: DomRepositories.PROTOCOL,
202: DomRepositories.SEQUENCE,
203: DomRepositories.CERTIFICATE_PATH
204: FROM DOM_REPOSITORIES_VL DomRepositories,
205: FND_LOOKUP_VALUES_VL lkp
206: WHERE lkp.lookup_type='DOM_REPOSITORY_PROTOCOLS'
207: AND lkp.lookup_code = DomRepositories.PROTOCOL
208: AND DomRepositories.ID <>0