DBA Data[Home] [Help]

APPS.HZ_BATCH_ACTION_PUB dependencies on HZ_IMP_RELSHIPS_INT

Line 560: UPDATE HZ_IMP_RELSHIPS_INT

556: AND party_orig_system_reference = l_record_osr(i);
557:
558: -- Update relationship records
559: FORALL i in l_record_osr.FIRST..l_record_osr.LAST
560: UPDATE HZ_IMP_RELSHIPS_INT
561: SET interface_status = 'R'
562: WHERE batch_id = p_batch_id
563: AND ((sub_orig_system = l_record_os(i)
564: AND sub_orig_system_reference = l_record_osr(i))

Line 1377: UPDATE HZ_IMP_RELSHIPS_INT

1373: EXIT;
1374: END IF;
1375:
1376: FORALL i in l_int_rowid.FIRST..l_int_rowid.LAST
1377: UPDATE HZ_IMP_RELSHIPS_INT
1378: SET interface_status = 'R'
1379: WHERE rowid = l_int_rowid(i) ;
1380:
1381: IF l_last_fetch = TRUE THEN

Line 2440: UPDATE HZ_IMP_RELSHIPS_INT

2436:
2437: -- Relationships
2438:
2439: FORALL i in l_party_orig_osr.FIRST..l_party_orig_osr.LAST
2440: UPDATE HZ_IMP_RELSHIPS_INT
2441: SET interface_status = 'R'
2442: WHERE batch_id = p_batch_id
2443: AND (sub_orig_system = l_party_orig_os(i)
2444: AND sub_orig_system_reference = l_party_orig_osr(i))