DBA Data[Home] [Help]

APPS.HZ_BATCH_ACTION_PUB dependencies on HZ_IMP_FINNUMBERS_INT

Line 590: UPDATE HZ_IMP_FINNUMBERS_INT

586: AND party_orig_system_reference = l_record_osr(i);
587:
588: --Update Financial Numbers
589: FORALL i in l_record_osr.FIRST..l_record_osr.LAST
590: UPDATE HZ_IMP_FINNUMBERS_INT
591: SET interface_status = 'R'
592: WHERE batch_id = p_batch_id
593: AND party_orig_system = l_record_os(i)
594: AND party_orig_system_reference = l_record_osr(i);

Line 1520: UPDATE HZ_IMP_FINNUMBERS_INT

1516: EXIT;
1517: END IF;
1518:
1519: FORALL i in l_int_rowid.FIRST..l_int_rowid.LAST
1520: UPDATE HZ_IMP_FINNUMBERS_INT
1521: SET interface_status = 'R'
1522: WHERE rowid = l_int_rowid(i) ;
1523:
1524: IF l_last_fetch = TRUE THEN

Line 1726: UPDATE HZ_IMP_FINNUMBERS_INT

1722: AND interface_status = 'R' ;
1723:
1724: --Financial Numbers
1725: FORALL i in l_dup_osr_party.FIRST..l_dup_osr_party.LAST
1726: UPDATE HZ_IMP_FINNUMBERS_INT
1727: SET interface_status = NULL
1728: WHERE batch_id = p_batch_id
1729: AND party_orig_system = l_dup_os_party(i)
1730: AND party_orig_system_reference = l_dup_osr_party(i)

Line 2378: UPDATE HZ_IMP_FINNUMBERS_INT

2374:
2375: --Financial Numbers
2376:
2377: FORALL i in l_party_orig_osr.FIRST..l_party_orig_osr.LAST
2378: UPDATE HZ_IMP_FINNUMBERS_INT
2379: SET interface_status = 'R'
2380: WHERE batch_id = p_batch_id
2381: AND party_orig_system = l_party_orig_os(i)
2382: AND party_orig_system_reference = l_party_orig_osr(i) ;