APPS.PA_PURGE dependencies on PA_PURGE_BATCHES

Line 387: pa_debug.debug('Before update of pa_purge_batches to pending');

383: pa_debug.debug('Calculate ARPUR_Commit_Size and ARPUR_MRC_Commit_Size');
384:
385:
386: -- Set working status for the batch
387: pa_debug.debug('Before update of pa_purge_batches to pending');
388: Update pa_purge_batches
389: Set batch_status_code='P' ,
390: request_id = fnd_global.conc_request_id
391: Where purge_batch_id = p_batch_id;

Line 388: Update pa_purge_batches

384:
385:
386: -- Set working status for the batch
387: pa_debug.debug('Before update of pa_purge_batches to pending');
388: Update pa_purge_batches
389: Set batch_status_code='P' ,
390: request_id = fnd_global.conc_request_id
391: Where purge_batch_id = p_batch_id;
392:

Line 394: pa_debug.debug('After update of pa_purge_batches to pending');

390: request_id = fnd_global.conc_request_id
391: Where purge_batch_id = p_batch_id;
392:
393: Commit;
394: pa_debug.debug('After update of pa_purge_batches to pending');
395:
396: -- Lock the batch row
397: pa_debug.debug('Before locking table pa_purge_batches');
398: Select active_closed_flag , purge_release

Line 397: pa_debug.debug('Before locking table pa_purge_batches');

393: Commit;
394: pa_debug.debug('After update of pa_purge_batches to pending');
395:
396: -- Lock the batch row
397: pa_debug.debug('Before locking table pa_purge_batches');
398: Select active_closed_flag , purge_release
399: Into l_active_closed_flag , l_purge_release
400: From pa_purge_batches
401: Where purge_batch_id = p_batch_id

Line 400: From pa_purge_batches

396: -- Lock the batch row
397: pa_debug.debug('Before locking table pa_purge_batches');
398: Select active_closed_flag , purge_release
399: Into l_active_closed_flag , l_purge_release
400: From pa_purge_batches
401: Where purge_batch_id = p_batch_id
402: and request_id = fnd_global.conc_request_id
403: For update;
404:

Line 405: pa_debug.debug('After locking table pa_purge_batches');

401: Where purge_batch_id = p_batch_id
402: and request_id = fnd_global.conc_request_id
403: For update;
404:
405: pa_debug.debug('After locking table pa_purge_batches');
406:
407: -- Select the projects in the batch that have not been purged
408: -- (Purged date is Null)
409:

Line 494: pa_debug.debug('Before update of pa_purge_batches to complete ');

490: ) ;
491:
492: */
493: -- Set completed status for the batch
494: pa_debug.debug('Before update of pa_purge_batches to complete ');
495: Update pa_purge_batches
496: Set batch_status_code='C'
497: ,purged_date=sysdate
498: ,last_update_date=sysdate

Line 495: Update pa_purge_batches

491:
492: */
493: -- Set completed status for the batch
494: pa_debug.debug('Before update of pa_purge_batches to complete ');
495: Update pa_purge_batches
496: Set batch_status_code='C'
497: ,purged_date=sysdate
498: ,last_update_date=sysdate
499: ,last_updated_by=fnd_global.user_id

Line 504: pa_debug.debug('After update of pa_purge_batches to complete');

500: ,last_update_login=fnd_global.login_id
501: Where purge_batch_id = p_batch_id;
502:
503: Commit;
504: pa_debug.debug('After update of pa_purge_batches to complete');
505:
506:
507: Exception
508:

Line 714: pa_debug.debug('Before locking pa_purge_batches again');

710: --
711: /* Added the condition for the bug#2510609 */
712: if p_table_name not in ('PA_FORECAST_ITEMS', 'PA_FORECAST_ITEM_DETAILS', 'PA_FI_AMOUNT_DETAILS') then
713:
714: pa_debug.debug('Before locking pa_purge_batches again');
715:
716: Select 'x'
717: Into l_dummy
718: From pa_purge_batches

Line 718: From pa_purge_batches

714: pa_debug.debug('Before locking pa_purge_batches again');
715:
716: Select 'x'
717: Into l_dummy
718: From pa_purge_batches
719: Where purge_batch_id = p_purge_batch_id
720: and request_id = fnd_global.conc_request_id
721: For update;
722:

Line 723: pa_debug.debug('After locking pa_purge_batches again');

719: Where purge_batch_id = p_purge_batch_id
720: and request_id = fnd_global.conc_request_id
721: For update;
722:
723: pa_debug.debug('After locking pa_purge_batches again');
724:
725: end if;
726:
727: x_err_stack := l_old_err_stack;

Line 793: from pa_purge_batches

789: pa_debug.debug(' In function get_post_purge_status ');
790:
791: Select active_closed_flag
792: into l_active_closed_flag
793: from pa_purge_batches
794: where purge_batch_id = p_batch_id;
795:
796: IF l_active_closed_flag = 'C' THEN
797: -- Select MAX of the flags for all rows of the project