eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_IMP_ADDRESS_VAL_PKG dependencies on HZ_IMP_ADAPTERS

Line 127: from hz_imp_adapters

123: l_request_id number;--REQUEST_ID;
124: l_default_replace_level THRESHOLD_STATUS;
125:
126: cursor verify_imp_adapter is select count(ADAPTER_CONTENT_SOURCE)
127: from hz_imp_adapters
128: where batch_id = p_batch_id
129: and send_flag = 'Y';
130:
131: cursor imp_adapter_cur is select adapter_id,adapter_content_source,nvl(MAXIMUM_BATCH_SIZE,DEFAULT_BATCH_SIZE),

Line 137: from hz_imp_adapters

133: from hz_adapters
134: where enabled_flag = 'Y'
135: and adapter_content_source in
136: (select distinct ADAPTER_CONTENT_SOURCE
137: from hz_imp_adapters
138: where batch_id = p_batch_id
139: and send_flag = 'Y') ;
140:
141: cursor imp_addresss_cur(v_adapter varchar2) is select rowid

Line 145: (select country_code from hz_imp_adapters

141: cursor imp_addresss_cur(v_adapter varchar2) is select rowid
142: from hz_imp_addresses_int
143: where batch_id = p_batch_id
144: and country in
145: (select country_code from hz_imp_adapters
146: where adapter_content_source = v_adapter
147: and batch_id = p_batch_id
148: and send_flag = 'Y');
149: /* or

Line 208: from hz_imp_adapters

204: and t.enabled_flag='Y'
205: and t.default_flag = 'Y'
206: )UNION
207: (select distinct country_code
208: from hz_imp_adapters
209: where batch_id = p_batch_id
210: and send_flag= 'Y')
211: );
212: --End of --Bug No:3347996

Line 232: cursor find_imp_country(p_country_code varchar2) is select 'X' from hz_imp_adapters

228: where batch_id = p_batch_id
229: and ACCEPT_STANDARDIZED_FLAG is not null
230: group by country;
231:
232: cursor find_imp_country(p_country_code varchar2) is select 'X' from hz_imp_adapters
233: where batch_id = p_batch_id
234: and country_code = p_country_code;
235: l_count NUMBER;
236: l_counter NUMBER :=0;

Line 341: --bug 3908043: Populate counts in HZ_IMP_ADAPTERS

337: */
338: --End of 3546295--------
339: END LOOP;
340:
341: --bug 3908043: Populate counts in HZ_IMP_ADAPTERS
342: OPEN verify_imp_adapter;
343: FETCH verify_imp_adapter into l_count;
344: CLOSE verify_imp_adapter;
345:

Line 351: -- update/insert count to hz_imp_adapters table.

347: -- Adapter defined for import for this batch
348: l_import_adapter_def := 'Y';
349: END IF;
350:
351: -- update/insert count to hz_imp_adapters table.
352: if l_import_adapter_def = 'Y' then
353: for rec in validated_address_cur loop
354: open find_imp_country(rec.country);
355: fetch find_imp_country into l_dummy1;

Line 358: update hz_imp_adapters

354: open find_imp_country(rec.country);
355: fetch find_imp_country into l_dummy1;
356: close find_imp_country;
357: if l_dummy1 is not null then
358: update hz_imp_adapters
359: set RECORDS_PASSED_VALIDATION = rec.Validated_rec,
360: RECORDS_FAILED_VALIDATION = rec.Failed_rec,
361: TOTAL_RECORDS_VALIDATED = rec.Total_rec
362: where batch_id = p_batch_id

Line 365: insert into hz_imp_adapters

361: TOTAL_RECORDS_VALIDATED = rec.Total_rec
362: where batch_id = p_batch_id
363: and COUNTRY_CODE = rec.country;
364: else
365: insert into hz_imp_adapters
366: (batch_id,country_code,RECORDS_PASSED_VALIDATION,
367: RECORDS_FAILED_VALIDATION,TOTAL_RECORDS_VALIDATED,
368: CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,
369: LAST_UPDATE_DATE)

Line 384: 1.If any adapters are defined in hz_imp_adapters then

380: -------------------------------------
381: ELSE
382: /*
383: Logic to process the records to address validation is as follows
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.

Line 385: a) Get the adapters from hz_imp_adapters for this batch and process

381: ELSE
382: /*
383: Logic to process the records to address validation is as follows
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:

Line 386: those country records with the adapters defined in the hz_imp_adapters.

382: /*
383: Logic to process the records to address validation is as follows
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

Line 387: b) Process the remaining records(countries not in hz_imp_adapters and

383: Logic to process the records to address validation is as follows
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.

Line 391: if adapters are defined in hz_imp_adapters for this batch.

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
395: and process those country records with the adapters defined in the hz_adapters.

Line 393: 2.If no adapters are defined in hz_imp_adapters then

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
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

Line 406: -- Adapter defined for import for this batch;so get the adapters from hz_imp_adapters

402: FETCH verify_imp_adapter into l_count;
403: CLOSE verify_imp_adapter;
404:
405: IF l_count > 0 then
406: -- Adapter defined for import for this batch;so get the adapters from hz_imp_adapters
407: l_import_adapter_def := 'Y';
408: OPEN imp_adapter_cur;
409: FETCH imp_adapter_cur BULK COLLECT into
410: l_adapter_id,l_adapter_content_source,l_batch_size,l_default_replace_level;

Line 415: -- No Adapter defined for import in hz_imp_adapters for this batch;so get

411: CLOSE imp_adapter_cur;
412: FND_FILE.put_line(fnd_file.log,'adapter count:'|| l_adapter_id.count);
413: ELSE
414:
415: -- No Adapter defined for import in hz_imp_adapters for this batch;so get
416: -- the adapters from hz_adapters.
417: OPEN adapter_cur;
418: FETCH adapter_cur BULK COLLECT into
419: l_adapter_id,l_adapter_content_source,l_batch_size,l_default_replace_level;