APPS.HZ_LOCATION_SERVICES_PUB dependencies on HZ_ADAPTERS

Line 115: FROM HZ_ADAPTERS

111: l_password VARCHAR2(100);
112:
113: CURSOR get_username_password(l_adapter_id NUMBER) IS
114: SELECT username, encrypted_password
115: FROM HZ_ADAPTERS
116: WHERE adapter_id = l_adapter_id;
117: BEGIN
118:
119: -- as password is encrypted, we may need to decrypt it

Line 209: FROM hz_adapters

205:
206: -- get adapter_id base on adapter_content_source
207: CURSOR get_adapter_id_from_cont(l_adapter_content_source VARCHAR2) IS
208: SELECT adapter_id
209: FROM hz_adapters
210: WHERE ltrim(rtrim(adapter_content_source)) = ltrim(rtrim(l_adapter_content_source));
211:
212: -- get default batch size base on adapter_id
213: CURSOR get_def_batch(l_adapter_id NUMBER) IS

Line 215: FROM hz_adapters

211:
212: -- get default batch size base on adapter_id
213: CURSOR get_def_batch(l_adapter_id NUMBER) IS
214: SELECT maximum_batch_size
215: FROM hz_adapters
216: WHERE adapter_id = l_adapter_id;
217:
218: -- get the min creation_date from HZ_LOCATIONS
219: CURSOR get_min_cr_date IS

Line 683: from HZ_ADAPTERS

679: where location_id = l_location_id;
680:
681: CURSOR get_content_source(l_adapter_id NUMBER) IS
682: select adapter_content_source
683: from HZ_ADAPTERS
684: where adapter_id = l_adapter_id;
685:
686: CURSOR is_active_profile(l_location_id NUMBER, l_adapter_content_source VARCHAR2) IS
687: select 'X'

Line 1685: from HZ_ADAPTERS la, HZ_ADAPTER_TERRITORIES t

1681: l_dummy VARCHAR2(1);
1682:
1683: CURSOR get_country_adapter(l_country_code VARCHAR2) IS
1684: select la.adapter_id
1685: from HZ_ADAPTERS la, HZ_ADAPTER_TERRITORIES t
1686: where la.adapter_id = t.adapter_id
1687: and t.territory_code = l_country_code
1688: and t.enabled_flag = 'Y'
1689: and t.default_flag = 'Y'

Line 1695: from HZ_ADAPTERS

1691: and rownum = 1;
1692:
1693: CURSOR is_adapter_good(l_adapter_id NUMBER) IS
1694: select 'X'
1695: from HZ_ADAPTERS
1696: where adapter_id = l_adapter_id
1697: and enabled_flag = 'Y';
1698:
1699: BEGIN

Line 1949: FROM HZ_ADAPTERS

1945: l_adapter_link VARCHAR2(2000);
1946: BEGIN
1947: SELECT host_address
1948: INTO l_adapter_url
1949: FROM HZ_ADAPTERS
1950: WHERE ADAPTER_ID = p_adapter_id;
1951:
1952: IF(l_adapter_url IS NOT NULL) THEN
1953: l_adapter_link := rtrim(ltrim(l_adapter_url));