APPS.POS_BATCH_IMPORT_PKG dependencies on HZ_IMP_ADDRESSES_INT

Line 255: --and will not be language code((varchar 4). So it needs to be converted to language_code before inserting to hz_imp_addresses_int .

251: AND sdh_batch_id = p_batch_id
252: AND nvl(status, 'ACTIVE') <> 'PROCESSED';
253:
254: --Bug 13086851 language code issue: The input language that we get from ap_supplier_sites_int will be NLS_LANGUAGE(varchar 30)
255: --and will not be language code((varchar 4). So it needs to be converted to language_code before inserting to hz_imp_addresses_int .
256:
257: --bug 12689121 missing address_line4, county, language during insert to interface
258:
259: --Bug 14772702: party_id should be populated into hz_imp_address_int as it is part of unique index

Line 261: INSERT INTO hz_imp_addresses_int

257: --bug 12689121 missing address_line4, county, language during insert to interface
258:
259: --Bug 14772702: party_id should be populated into hz_imp_address_int as it is part of unique index
260: --Same site orig reference can exist under different suppliers
261: INSERT INTO hz_imp_addresses_int
262: (batch_id,
263: party_orig_system,
264: party_orig_system_reference,
265: site_orig_system,

Line 347: FROM hz_imp_addresses_int hp

343: sdh_batch_id = p_batch_id AND supp.language = lang.nls_language(+)
344: AND nvl(status, 'ACTIVE') <> 'PROCESSED'
345: AND NOT EXISTS
346: (SELECT *
347: FROM hz_imp_addresses_int hp
348: WHERE hp.batch_id = supp.sdh_batch_id
349: AND hp.party_orig_system = supp.party_orig_system
350: AND hp.party_orig_system_reference =
351: supp.party_orig_system_reference

Line 362: ' Rows inserted in hz_imp_addresses_int: ' ||

358:
359: fnd_file.put_line(fnd_file.log,
360: ' Message: Inside PROCEDURE check_party_site_exist' ||
361: ' Parameters: ' || ' p_batch_id: ' || p_batch_id ||
362: ' Rows inserted in hz_imp_addresses_int: ' ||
363: l_insert_count);
364:
365: IF (l_insert_count > 0) THEN
366: -- Update hz_imp_batch_summary with the count of the records inserted into interface table.

Line 3043: FROM hz_imp_addresses_int party

3039: AND sdh_batch_id = p_batch_id
3040: AND nvl(status, 'ACTIVE') NOT IN ('PROCESSED', 'REMOVED')
3041: AND NOT EXISTS
3042: (SELECT 1
3043: FROM hz_imp_addresses_int party
3044: WHERE batch_id = p_batch_id
3045: AND supp.sdh_batch_id = party.batch_id
3046: AND supp.party_orig_system = party.party_orig_system
3047: AND supp.party_orig_system_reference =

Line 3142: FROM hz_imp_addresses_int party

3138: WHERE sdh_batch_id = p_batch_id
3139: AND nvl(status, 'ACTIVE') <> 'PROCESSED'
3140: AND EXISTS
3141: (SELECT 1
3142: FROM hz_imp_addresses_int party
3143: WHERE batch_id = p_batch_id
3144: AND supp.sdh_batch_id = party.batch_id
3145: AND supp.party_orig_system = party.party_orig_system
3146: AND supp.party_orig_system_reference =

Line 3156: ' records. Reason interface_status in hz_imp_addresses_int = R');

3152:
3153: fnd_file.put_line(fnd_file.log,
3154: ' Message: Inside PROCEDURE IMPORT_VENDOR_SITES' ||
3155: ' Not imported(marked REMOVED) : ' || SQL%ROWCOUNT ||
3156: ' records. Reason interface_status in hz_imp_addresses_int = R');
3157:
3158: INSERT INTO pos_supplier_int_rejections
3159: (SELECT p_batch_id,
3160: l_request_id,

Line 3446: FROM hz_imp_addresses_int

3442:
3443: BEGIN
3444: SELECT insert_update_flag
3445: INTO l_insert_update_flag
3446: FROM hz_imp_addresses_int
3447: WHERE batch_id = p_batch_id
3448: AND party_orig_system = site_int_rec.party_orig_system
3449: AND party_orig_system_reference =
3450: site_int_rec.party_orig_system_reference