APPS.HZ_BATCH_ACTION_PUB dependencies on HZ_IMP_ADDRESSUSES_INT

Line 530: UPDATE HZ_IMP_ADDRESSUSES_INT

526: AND party_orig_system_reference = l_record_osr(i);
527:
528: --Update site uses
529: /*FORALL i in l_record_osr.FIRST..l_record_osr.LAST
530: UPDATE HZ_IMP_ADDRESSUSES_INT
531: SET interface_status = 'R'
532: WHERE batch_id = p_batch_id
533: AND party_orig_system = l_record_os(i)
534: AND party_orig_system_reference = l_record_osr(i);

Line 638: UPDATE HZ_IMP_ADDRESSUSES_INT

634: END IF;
635:
636: --Update Site Uses
637: FORALL i in l_record_osr.FIRST..l_record_osr.LAST
638: UPDATE HZ_IMP_ADDRESSUSES_INT
639: SET interface_status = 'R'
640: WHERE batch_id = p_batch_id
641: AND site_orig_system = l_record_os(i)
642: AND site_orig_system_reference = l_record_osr(i);

Line 1238: UPDATE HZ_IMP_ADDRESSUSES_INT

1234: EXIT;
1235: END IF;
1236:
1237: FORALL i in l_int_rowid.FIRST..l_int_rowid.LAST
1238: UPDATE HZ_IMP_ADDRESSUSES_INT
1239: SET interface_status = 'R'
1240: WHERE rowid = l_int_rowid(i) ;
1241:
1242: IF l_last_fetch = TRUE THEN

Line 1782: UPDATE HZ_IMP_ADDRESSUSES_INT

1778:
1779: --Party site Uses
1780:
1781: FORALL i in l_dup_osr_sites.FIRST..l_dup_osr_sites.LAST
1782: UPDATE HZ_IMP_ADDRESSUSES_INT
1783: SET interface_status = NULL
1784: WHERE batch_id = p_batch_id
1785: AND site_orig_system = l_dup_os_sites(i)
1786: AND site_orig_system_reference = l_dup_osr_sites(i)

Line 2422: UPDATE HZ_IMP_ADDRESSUSES_INT

2418: RETURNING site_orig_system,site_orig_system_Reference BULK COLLECT into l_site_orig_os,l_site_orig_osr;
2419:
2420: -- Child entitites for Addresses
2421: FORALL i in l_site_orig_osr.FIRST..l_site_orig_osr.LAST
2422: UPDATE HZ_IMP_ADDRESSUSES_INT
2423: SET INTERFACE_STATUS = 'R'
2424: WHERE batch_id = p_batch_id
2425: AND site_orig_system = l_site_orig_os(i)
2426: AND site_orig_system_reference = l_site_orig_osr(i) ;

Line 2570: UPDATE HZ_IMP_ADDRESSUSES_INT

2566: AND site_orig_system_reference = l_site_orig_osr(i) ;
2567:
2568: --Child entities for Party
2569: FORALL i in l_site_orig_osr.FIRST..l_site_orig_osr.LAST
2570: UPDATE HZ_IMP_ADDRESSUSES_INT
2571: SET INTERFACE_STATUS = 'R'
2572: WHERE batch_id = p_batch_id
2573: AND site_orig_system = l_site_orig_os(i)
2574: AND site_orig_system_reference = l_site_orig_osr(i) ;