DBA Data[Home] [Help]

APPS.FA_CUA_MASS_UPDATE1_PKG dependencies on FA_MASS_UPDATE_BATCH_HEADERS

Line 653: FROM fa_mass_update_batch_headers

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

Line 677: update fa_mass_update_batch_headers

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

Line 743: update fa_mass_update_batch_headers

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

Line 751: update fa_mass_update_batch_headers

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