DBA Data[Home] [Help]

APPS.HZ_BATCH_ACTION_PUB dependencies on HZ_IMP_FINREPORTS_INT

Line 598: UPDATE HZ_IMP_FINREPORTS_INT

594: AND party_orig_system_reference = l_record_osr(i);
595:
596: --Update Financial Reports
597: FORALL i in l_record_osr.FIRST..l_record_osr.LAST
598: UPDATE HZ_IMP_FINREPORTS_INT
599: SET interface_status = 'R'
600: WHERE batch_id = p_batch_id
601: AND party_orig_system = l_record_os(i)
602: AND party_orig_system_reference = l_record_osr(i);

Line 1475: UPDATE HZ_IMP_FINREPORTS_INT

1471: EXIT;
1472: END IF;
1473:
1474: FORALL i in l_int_rowid.FIRST..l_int_rowid.LAST
1475: UPDATE HZ_IMP_FINREPORTS_INT
1476: SET interface_status = 'R'
1477: WHERE rowid = l_int_rowid(i) ;
1478:
1479: IF l_last_fetch = TRUE THEN

Line 1735: UPDATE HZ_IMP_FINREPORTS_INT

1731: AND interface_status = 'R' ;
1732:
1733: --Financial Reports
1734: FORALL i in l_dup_osr_party.FIRST..l_dup_osr_party.LAST
1735: UPDATE HZ_IMP_FINREPORTS_INT
1736: SET interface_status = NULL
1737: WHERE batch_id = p_batch_id
1738: AND party_orig_system = l_dup_os_party(i)
1739: AND party_orig_system_reference = l_dup_osr_party(i)

Line 2387: UPDATE HZ_IMP_FINREPORTS_INT

2383:
2384: --Financial Reports
2385:
2386: FORALL i in l_party_orig_osr.FIRST..l_party_orig_osr.LAST
2387: UPDATE HZ_IMP_FINREPORTS_INT
2388: SET interface_status = 'R'
2389: WHERE batch_id = p_batch_id
2390: AND party_orig_system = l_party_orig_os(i)
2391: AND party_orig_system_reference = l_party_orig_osr(i) ;