APPS.HZ_IMP_ADDRESS_VAL_PKG dependencies on STANDARD

Line 224: select country,count(decode(ACCEPT_STANDARDIZED_FLAG,'Y','Y',null))Validated_rec,

220: where enabled_flag = 'Y'
221: and adapter_id = to_number(fnd_profile.value('HZ_DEFAULT_LOC_ADAPTER'));
222:
223: cursor validated_address_cur is
224: select country,count(decode(ACCEPT_STANDARDIZED_FLAG,'Y','Y',null))Validated_rec,
225: count(decode(ACCEPT_STANDARDIZED_FLAG,'N','N',null))Failed_rec,
226: count(ACCEPT_STANDARDIZED_FLAG)Total_rec
227: from hz_imp_addresses_int
228: where batch_id = p_batch_id

Line 225: count(decode(ACCEPT_STANDARDIZED_FLAG,'N','N',null))Failed_rec,

221: and adapter_id = to_number(fnd_profile.value('HZ_DEFAULT_LOC_ADAPTER'));
222:
223: cursor validated_address_cur is
224: select country,count(decode(ACCEPT_STANDARDIZED_FLAG,'Y','Y',null))Validated_rec,
225: count(decode(ACCEPT_STANDARDIZED_FLAG,'N','N',null))Failed_rec,
226: count(ACCEPT_STANDARDIZED_FLAG)Total_rec
227: from hz_imp_addresses_int
228: where batch_id = p_batch_id
229: and ACCEPT_STANDARDIZED_FLAG is not null

Line 226: count(ACCEPT_STANDARDIZED_FLAG)Total_rec

222:
223: cursor validated_address_cur is
224: select country,count(decode(ACCEPT_STANDARDIZED_FLAG,'Y','Y',null))Validated_rec,
225: count(decode(ACCEPT_STANDARDIZED_FLAG,'N','N',null))Failed_rec,
226: count(ACCEPT_STANDARDIZED_FLAG)Total_rec
227: from hz_imp_addresses_int
228: where batch_id = p_batch_id
229: and ACCEPT_STANDARDIZED_FLAG is not null
230: group by country;

Line 229: and ACCEPT_STANDARDIZED_FLAG is not null

225: count(decode(ACCEPT_STANDARDIZED_FLAG,'N','N',null))Failed_rec,
226: count(ACCEPT_STANDARDIZED_FLAG)Total_rec
227: from hz_imp_addresses_int
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

Line 663: ACCEPT_STANDARDIZED_FLAG = compare_treshhold(p_status,P_OVERWRITE_THRESHOLD),

659: county_std = p_county,
660: PROV_STATE_ADMIN_CODE_STD = p_CountrySubEntity,
661: country_std = nvl(upper(p_country), upper(country)),
662: postal_code_std = p_postal_code,
663: ACCEPT_STANDARDIZED_FLAG = compare_treshhold(p_status,P_OVERWRITE_THRESHOLD),
664: DATE_VALIDATED = trunc(sysdate),
665: ADDR_VALID_STATUS_CODE = p_status
666: WHERE SITE_ORIG_SYSTEM_REFERENCE = P_SITE_ORIG_SYSTEM_REFERENCE
667: AND SITE_ORIG_SYSTEM = P_SITE_ORIG_SYSTEM

Line 711: ecx_standard.processXMLCover(

707: IF(l_event_data IS NOT NULL) THEN
708: l_ecx_map_code := p_event.getValueForParameter('ECX_MAP_CODE');
709: FND_FILE.put_line(fnd_file.log,'ECX Map Code: '||l_ecx_map_code);
710:
711: ecx_standard.processXMLCover(
712: i_map_code =>l_ecx_map_code,
713: i_inpayload =>l_event_data,
714: i_debug_level =>3);
715: commit;

Line 747: -- 1) Get the generated xml doc by ecx_standard.generate

743: --'oracle.apps.ar.hz.import.outboundxml' which is raised by
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: ------------------------------------------------------------------------