APPS.PA_PURGE_VALIDATE dependencies on PA_PURGE_BATCHES

Line 57: from pa_purge_batches pb

53: -- one batch should not be picked by two batches simultaneously
54: -- for validation
55: cursor GetBatchDet is
56: select pb.active_closed_flag
57: from pa_purge_batches pb
58: where pb.purge_batch_id = p_purge_batch_id
59: for update of pb.purge_batch_id nowait ;
60:
61: -- This cursor fetches all the projects in the batch.

Line 246: update pa_purge_batches pb

242:
243: end loop ;
244:
245: -- Update the batch status to working.
246: update pa_purge_batches pb
247: set pb.batch_status_code = 'W',
248: pb.request_id = pa_purge_validate.g_request_id,
249: pb.program_application_id = pa_purge_validate.g_program_application_id,
250: pb.program_id = pa_purge_validate.g_program_id ,