APPS.HZ_IMP_ADDRESS_VAL_PKG dependencies on HZ_LOCATION_SERVICES_PUB

Line 164: (select distinct HZ_LOCATION_SERVICES_PUB.get_adapter_id(null,country)

160: DEFAULT_REPLACE_STATUS_LEVEL
161: from hz_adapters
162: where enabled_flag = 'Y'
163: and adapter_id in
164: (select distinct HZ_LOCATION_SERVICES_PUB.get_adapter_id(null,country)
165: from hz_imp_addresses_int
166: where batch_id = p_batch_id
167: --Bug No:3347996.Added conditions to overcome unnecessary calls to
168: --HZ_LOCATION_SERVICES_PUB.get_adapter_id.

Line 168: --HZ_LOCATION_SERVICES_PUB.get_adapter_id.

164: (select distinct HZ_LOCATION_SERVICES_PUB.get_adapter_id(null,country)
165: from hz_imp_addresses_int
166: where batch_id = p_batch_id
167: --Bug No:3347996.Added conditions to overcome unnecessary calls to
168: --HZ_LOCATION_SERVICES_PUB.get_adapter_id.
169: and country in (select distinct territory_code
170: from hz_adapter_territories t,
171: hz_adapters ad
172: where ad.adapter_id =t.adapter_id

Line 748: -- 2) Pass the xml doc to HZ_LOCATION_SERVICES_PUB.submit_addrval_doc

744: -- address_validation_child Concurrent Program.
745: --
746: -- This function rule will do the following
747: -- 1) Get the generated xml doc by ecx_standard.generate
748: -- 2) Pass the xml doc to HZ_LOCATION_SERVICES_PUB.submit_addrval_doc
749: -- 3) Get returned validated xml doc, raise another wf event to parse
750: -- the validated addresses.
751: ------------------------------------------------------------------------
752: function outboundxml_rule(

Line 795: FND_FILE.put_line(fnd_file.log,'calling HZ_LOCATION_SERVICES_PUB.submit_addrval_doc procedure ');

791: l_adapter_id := p_event.getValueForParameter('P_ADAPTER_ID');
792: --
793: ---Call address validation service API
794: --
795: FND_FILE.put_line(fnd_file.log,'calling HZ_LOCATION_SERVICES_PUB.submit_addrval_doc procedure ');
796: FND_FILE.put_line(fnd_file.log,'BATCH_ID: '||l_batch_id);
797: FND_FILE.put_line(fnd_file.log,'ADAPTER ID: '||l_adapter_id);
798: FND_FILE.put_line(fnd_file.log,'ORIG_SYSTEM: '||l_orig_system);
799: FND_FILE.put_line(fnd_file.log,'SUBSET ID '||l_subset_id);

Line 800: HZ_LOCATION_SERVICES_PUB.submit_addrval_doc(

796: FND_FILE.put_line(fnd_file.log,'BATCH_ID: '||l_batch_id);
797: FND_FILE.put_line(fnd_file.log,'ADAPTER ID: '||l_adapter_id);
798: FND_FILE.put_line(fnd_file.log,'ORIG_SYSTEM: '||l_orig_system);
799: FND_FILE.put_line(fnd_file.log,'SUBSET ID '||l_subset_id);
800: HZ_LOCATION_SERVICES_PUB.submit_addrval_doc(
801: p_addrval_doc => l_event_data,
802: p_adapter_id => l_adapter_id,
803: p_country_code => null,
804: p_module => 'HZ_IMPORT',