APPS.HZ_BATCH_ACTION_PUB dependencies on HZ_IMP_CREDITRTNGS_INT

Line 582: UPDATE HZ_IMP_CREDITRTNGS_INT

578: AND party_orig_system_reference = l_record_osr(i);
579:
580: --Update Credit Ratings
581: FORALL i in l_record_osr.FIRST..l_record_osr.LAST
582: UPDATE HZ_IMP_CREDITRTNGS_INT
583: SET interface_status = 'R'
584: WHERE batch_id = p_batch_id
585: AND party_orig_system = l_record_os(i)
586: AND party_orig_system_reference = l_record_osr(i);

Line 1567: UPDATE HZ_IMP_CREDITRTNGS_INT

1563: EXIT;
1564: END IF;
1565:
1566: FORALL i in l_int_rowid.FIRST..l_int_rowid.LAST
1567: UPDATE HZ_IMP_CREDITRTNGS_INT
1568: SET interface_status = 'R'
1569: WHERE rowid = l_int_rowid(i) ;
1570:
1571: IF l_last_fetch = TRUE THEN

Line 1717: UPDATE HZ_IMP_CREDITRTNGS_INT

1713: AND interface_status = 'R' ;
1714:
1715: --Credit Ratings
1716: FORALL i in l_dup_osr_party.FIRST..l_dup_osr_party.LAST
1717: UPDATE HZ_IMP_CREDITRTNGS_INT
1718: SET interface_status = NULL
1719: WHERE batch_id = p_batch_id
1720: AND party_orig_system = l_dup_os_party(i)
1721: AND party_orig_system_reference = l_dup_osr_party(i)

Line 2369: UPDATE HZ_IMP_CREDITRTNGS_INT

2365:
2366: --Credit Ratings
2367:
2368: FORALL i in l_party_orig_osr.FIRST..l_party_orig_osr.LAST
2369: UPDATE HZ_IMP_CREDITRTNGS_INT
2370: SET interface_status = 'R'
2371: WHERE batch_id = p_batch_id
2372: AND party_orig_system = l_party_orig_os(i)
2373: AND party_orig_system_reference = l_party_orig_osr(i) ;