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_ADAPTERS

Line 29: l_adapter_content_source hz_adapters.ADAPTER_CONTENT_SOURCE%type;

25: l_msg_count NUMBER;
26: l_msg_data VARCHAR2(2000);
27: l_request_id NUMBER;
28: l_event_key VARCHAR2(30);
29: l_adapter_content_source hz_adapters.ADAPTER_CONTENT_SOURCE%type;
30: l_adapter_id hz_adapters.adapter_id%type;
31: p_subset_id NUMBER;
32: begin
33: --

Line 30: l_adapter_id hz_adapters.adapter_id%type;

26: l_msg_data VARCHAR2(2000);
27: l_request_id NUMBER;
28: l_event_key VARCHAR2(30);
29: l_adapter_content_source hz_adapters.ADAPTER_CONTENT_SOURCE%type;
30: l_adapter_id hz_adapters.adapter_id%type;
31: p_subset_id NUMBER;
32: begin
33: --
34: ---Set parameter mapcode in parameter list

Line 110: TYPE ADAPTER_ID IS TABLE OF HZ_ADAPTERS.ADAPTER_ID%TYPE;

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);
114: TYPE REQUEST_ID IS TABLE OF NUMBER;

Line 111: TYPE ADAPTER_CONTENT_SOURCE IS TABLE OF HZ_ADAPTERS.ADAPTER_CONTENT_SOURCE%TYPE;

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);
114: TYPE REQUEST_ID IS TABLE OF NUMBER;
115: TYPE THRESHOLD_STATUS IS TABLE OF HZ_ADAPTERS.DEFAULT_REPLACE_STATUS_LEVEL%TYPE;

Line 112: TYPE BATCH_SIZE IS TABLE OF HZ_ADAPTERS.DEFAULT_BATCH_SIZE%TYPE;

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);
114: TYPE REQUEST_ID IS TABLE OF NUMBER;
115: TYPE THRESHOLD_STATUS IS TABLE OF HZ_ADAPTERS.DEFAULT_REPLACE_STATUS_LEVEL%TYPE;
116: l_adapter_id ADAPTER_ID;

Line 115: TYPE THRESHOLD_STATUS IS TABLE OF HZ_ADAPTERS.DEFAULT_REPLACE_STATUS_LEVEL%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);
114: TYPE REQUEST_ID IS TABLE OF NUMBER;
115: TYPE THRESHOLD_STATUS IS TABLE OF HZ_ADAPTERS.DEFAULT_REPLACE_STATUS_LEVEL%TYPE;
116: l_adapter_id ADAPTER_ID;
117: l_adapter_content_source ADAPTER_CONTENT_SOURCE;
118: l_batch_size BATCH_SIZE;
119: l_batch_id NUMBER := p_batch_id;

Line 133: from hz_adapters

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),
132: DEFAULT_REPLACE_STATUS_LEVEL
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

Line 161: from hz_adapters

157: and default_flag = 'Y');*/
158:
159: cursor adapter_cur is select adapter_id,adapter_content_source,nvl(MAXIMUM_BATCH_SIZE,DEFAULT_BATCH_SIZE),
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

Line 171: hz_adapters ad

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'
175: and t.default_flag = 'Y')

Line 186: hz_adapters ad

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'
190: and t.enabled_flag='Y' --Bug No:3347996

Line 201: hz_adapters ad

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'
205: and t.default_flag = 'Y'

Line 219: from hz_adapters

215: --Bug No:3347996 where TERRITORY_CODE = country);
216:
217: cursor default_adapter is select adapter_id,adapter_content_source,nvl(MAXIMUM_BATCH_SIZE,DEFAULT_BATCH_SIZE),
218: DEFAULT_REPLACE_STATUS_LEVEL
219: from hz_adapters
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

Line 395: and process those country records with the adapters defined in the hz_adapters.

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
399: a) Process all the records with the system default adapter

Line 416: -- the adapters from hz_adapters.

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;
420: FND_FILE.put_line(fnd_file.log,'l_adapter_id count:'|| l_adapter_id.count);

Line 425: FND_FILE.put_line(fnd_file.log,'No valid adapter found in hz_adapters for this batch.');

421: IF adapter_cur%NOTFOUND THEN
422: l_adapter_last_fetch := TRUE;
423: END IF;
424: IF l_adapter_id.count = 0 AND l_adapter_last_fetch THEN
425: FND_FILE.put_line(fnd_file.log,'No valid adapter found in hz_adapters for this batch.');
426: --RETURN; Bug no:3365035.Commented return to continue the execution.
427: END IF;
428: CLOSE adapter_cur;
429: END IF;