[Home] [Help]
151: where TERRITORY_CODE = country)
152: );
153: OR
154: country not in
155: (select territory_code from hz_adapter_territories
156: where adapter_id = v_adapter_id
157: and default_flag = 'Y');*/
158:
159: cursor adapter_cur is select adapter_id,adapter_content_source,nvl(MAXIMUM_BATCH_SIZE,DEFAULT_BATCH_SIZE),
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
173: and ad.enabled_flag='Y'
174: and t.enabled_flag='Y'
181: cursor addresss_cur(v_adapter_id number) is select rowid
182: from hz_imp_addresses_int
183: where batch_id = p_batch_id
184: and country in
185: (select territory_code from hz_adapter_territories t,
186: hz_adapters ad
187: where t.adapter_id = v_adapter_id
188: and ad.adapter_id =t.adapter_id
189: and ad.enabled_flag='Y'
196: from hz_imp_addresses_int
197: where batch_id = p_batch_id
198: --Bug No:3347996
199: and country not in ((select distinct territory_code
200: from hz_adapter_territories t,
201: hz_adapters ad
202: where ad.adapter_id=t.adapter_id
203: and ad.enabled_flag='Y'
204: and t.enabled_flag='Y'
384: 1.If any adapters are defined in hz_imp_adapters then
385: a) Get the adapters from hz_imp_adapters for this batch and process
386: those country records with the adapters defined in the hz_imp_adapters.
387: b) Process the remaining records(countries not in hz_imp_adapters and
388: not in hz_adapter_territories) with the default adapter.
389:
390: Note: We should not process the countries in hz_adapter_territories
391: if adapters are defined in hz_imp_adapters for this batch.
392:
386: those country records with the adapters defined in the hz_imp_adapters.
387: b) Process the remaining records(countries not in hz_imp_adapters and
388: not in hz_adapter_territories) with the default adapter.
389:
390: Note: We should not process the countries in hz_adapter_territories
391: if adapters are defined in hz_imp_adapters for this batch.
392:
393: 2.If no adapters are defined in hz_imp_adapters then
394: a) Get the country's default adapter from hz_adapter_territories
390: Note: We should not process the countries in hz_adapter_territories
391: if adapters are defined in hz_imp_adapters for this batch.
392:
393: 2.If no adapters are defined in hz_imp_adapters then
394: a) Get the country's default adapter from hz_adapter_territories
395: and process those country records with the adapters defined in the hz_adapters.
396: b) Process the remaining records(countries not in hz_adapter_territories)
397: with the default adapter
398: 3. If the above cases 1 and 2 fails then
392:
393: 2.If no adapters are defined in hz_imp_adapters then
394: a) Get the country's default adapter from hz_adapter_territories
395: and process those country records with the adapters defined in the hz_adapters.
396: b) Process the remaining records(countries not in hz_adapter_territories)
397: with the default adapter
398: 3. If the above cases 1 and 2 fails then
399: a) Process all the records with the system default adapter
400: */