DBA Data[Home] [Help]

APPS.FA_CUA_MASS_UPDATE1_PKG dependencies on FA_MASS_UPDATE_BATCH_HEADERS

Line 651: FROM fa_mass_update_batch_headers

647: attribute12,
648: attribute13,
649: attribute14,
650: attribute15
651: FROM fa_mass_update_batch_headers
652: WHERE status_code in ('IP','P','PP','R')
653: AND batch_number >= nvl(X_from_Batch_number,batch_number)
654: AND batch_number <= nvl(X_to_batch_number,batch_number)
655: order by creation_date;

Line 675: update fa_mass_update_batch_headers

671:
672:
673: FOR l_batch_rec IN l_batch_csr LOOP
674:
675: update fa_mass_update_batch_headers
676: set status_code = 'IP'
677: where batch_id = l_batch_rec.batch_id;
678:
679: -- assign attribute values to global_variables

Line 740: update fa_mass_update_batch_headers

736: End ;
737:
738: if l_dummy = 'Y' then
739:
740: update fa_mass_update_batch_headers
741: set status_code = 'R' -- Rejected Processed
742: , concurrent_request_id = l_Request_ID
743: , last_updated_by = fnd_global.login_id
744: , last_update_date = sysdate

Line 748: update fa_mass_update_batch_headers

744: , last_update_date = sysdate
745: , last_update_login = fnd_global.login_id
746: where batch_id = l_batch_rec.batch_id;
747: else
748: update fa_mass_update_batch_headers
749: set status_code = 'CP' -- Completetly Processed
750: , concurrent_request_id = l_Request_ID
751: , last_updated_by = fnd_global.login_id
752: , last_update_date = sysdate