DBA Data[Home] [Help]

APPS.HZ_BATCH_ACTION_PUB dependencies on HZ_IMP_CLASSIFICS_INT

Line 574: UPDATE HZ_IMP_CLASSIFICS_INT

570: -- End of Bug No: 3770319
571:
572: --Update Classifications
573: FORALL i in l_record_osr.FIRST..l_record_osr.LAST
574: UPDATE HZ_IMP_CLASSIFICS_INT
575: SET interface_status = 'R'
576: WHERE batch_id = p_batch_id
577: AND party_orig_system = l_record_os(i)
578: AND party_orig_system_reference = l_record_osr(i);

Line 1284: UPDATE HZ_IMP_CLASSIFICS_INT

1280: EXIT;
1281: END IF;
1282:
1283: FORALL i in l_int_rowid.FIRST..l_int_rowid.LAST
1284: UPDATE HZ_IMP_CLASSIFICS_INT
1285: SET interface_status = 'R'
1286: WHERE rowid = l_int_rowid(i) ;
1287:
1288: IF l_last_fetch = TRUE THEN

Line 1708: UPDATE HZ_IMP_CLASSIFICS_INT

1704: AND ( interface_status = 'R' OR dqm_action_flag is not NULL );
1705:
1706: --Classifications
1707: FORALL i in l_dup_osr_party.FIRST..l_dup_osr_party.LAST
1708: UPDATE HZ_IMP_CLASSIFICS_INT
1709: SET interface_status = NULL
1710: WHERE batch_id = p_batch_id
1711: AND party_orig_system = l_dup_os_party(i)
1712: AND party_orig_system_reference = l_dup_osr_party(i)

Line 2360: UPDATE HZ_IMP_CLASSIFICS_INT

2356: --Child entities for Party
2357: -- Classifications
2358:
2359: FORALL i in l_party_orig_osr.FIRST..l_party_orig_osr.LAST
2360: UPDATE HZ_IMP_CLASSIFICS_INT
2361: SET interface_status = 'R'
2362: WHERE batch_id = p_batch_id
2363: AND party_orig_system = l_party_orig_os(i)
2364: AND party_orig_system_reference = l_party_orig_osr(i) ;