APPS.HZ_IMP_ADDRESS_VAL_PKG dependencies on HZ_IMP_ADDRESSES_INT

Line 109: TYPE BATCH_ID IS TABLE OF HZ_IMP_ADDRESSES_INT.BATCH_ID%TYPE;

105: Errbuf OUT NOCOPY VARCHAR2,
106: Retcode OUT NOCOPY VARCHAR2,
107: p_batch_id IN NUMBER) is
108:
109: TYPE BATCH_ID IS TABLE OF HZ_IMP_ADDRESSES_INT.BATCH_ID%TYPE;
110: TYPE ADAPTER_ID IS TABLE OF HZ_ADAPTERS.ADAPTER_ID%TYPE;
111: TYPE ADAPTER_CONTENT_SOURCE IS TABLE OF HZ_ADAPTERS.ADAPTER_CONTENT_SOURCE%TYPE;
112: TYPE BATCH_SIZE IS TABLE OF HZ_ADAPTERS.DEFAULT_BATCH_SIZE%TYPE;
113: TYPE ROWID IS TABLE OF VARCHAR2(50);

Line 142: from hz_imp_addresses_int

138: where batch_id = p_batch_id
139: and send_flag = 'Y') ;
140:
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

Line 165: from hz_imp_addresses_int

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.
169: and country in (select distinct territory_code

Line 182: from hz_imp_addresses_int

178: ----End of Bug No:3347996
179: );
180:
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

Line 196: from hz_imp_addresses_int

192: and exists (select 'X' from fnd_territories
193: where TERRITORY_CODE = country);
194:
195: cursor addresss_cur_default is select rowid
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,

Line 227: from hz_imp_addresses_int

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;
231:

Line 465: update hz_imp_addresses_int

461: END IF;
462: END IF;
463:
464: FORALL j IN l_row_id.FIRST..l_row_id.LAST
465: update hz_imp_addresses_int
466: set validation_subset_id = l_counter,
467: adapter_content_source = l_adapter_content_source(i)
468: where rowid = l_row_id(j);
469: commit;

Line 549: UPDATE hz_imp_addresses_int

545: EXIT;
546: END IF;
547:
548: FORALL j IN l_row_id.FIRST..l_row_id.LAST
549: UPDATE hz_imp_addresses_int
550: SET validation_subset_id = l_counter,
551: adapter_content_source = l_adapter_content_source(i)
552: WHERE rowid = l_row_id(j);
553: COMMIT;

Line 653: UPDATE HZ_IMP_ADDRESSES_INT SET

649: P_OVERWRITE_THRESHOLD in VARCHAR2 DEFAULT NULL )is
650:
651: begin
652:
653: UPDATE HZ_IMP_ADDRESSES_INT SET
654: Address1_std = p_Address1,
655: Address2_std = p_Address2,
656: Address3_std = p_Address3,
657: Address4_std = p_Address4,

Line 672: FND_FILE.put_line(fnd_file.log,'Can not find record for update HZ_IMP_ADDRESSES_INT: ');

668: AND BATCH_ID = p_batch_id;
669:
670: exception
671: WHEN NO_DATA_FOUND THEN
672: FND_FILE.put_line(fnd_file.log,'Can not find record for update HZ_IMP_ADDRESSES_INT: ');
673: FND_FILE.put_line(fnd_file.log,'Batch_Id,:'||p_batch_id);
674: FND_FILE.put_line(fnd_file.log,'SITE_ORIG_SYSTEM,:'||P_SITE_ORIG_SYSTEM);
675: FND_FILE.put_line(fnd_file.log,'SITE_ORIG_SYSTEM_REFERENCE:'||P_SITE_ORIG_SYSTEM_REFERENCE);
676: RAISE FND_API.G_EXC_ERROR;

Line 692: -- the hz_imp_addresses_int table with validated address components.

688: --'oracle.apps.ar.hz.import.inboundxml' which is raised by
689: -- another rule function outboundxml_rule.
690: --
691: -- This function rule will process the inbound xml doc and update
692: -- the hz_imp_addresses_int table with validated address components.
693: ------------------------------------------------------------------------
694: FUNCTION inboundxml_rule (
695: p_subscription_guid IN RAW,
696: p_event IN OUT NOCOPY wf_event_t )