APPS.PA_PURGE dependencies on PA_PURGE_PRJ_DETAILS

Line 580: Update PA_PURGE_PRJ_DETAILS

576:
577: -- update the pa_project_details with statistics
578: pa_debug.debug('Before update of pa_project_details' );
579:
580: Update PA_PURGE_PRJ_DETAILS
581: Set num_recs_purged = nvl(num_recs_purged,0) + nvl(p_NoOfRecordsDel,0)
582: ,num_recs_archived = nvl(num_recs_archived,0) + nvl(p_NoOfRecordsIns,0)
583: ,last_update_date=sysdate
584: ,last_updated_by=fnd_global.user_id

Line 600: Insert into PA_PURGE_PRJ_DETAILS

596: --
597: IF SQL%Rowcount = 0 Then
598:
599: pa_debug.debug('Before insert into pa_project_details' );
600: Insert into PA_PURGE_PRJ_DETAILS
601: (
602: purge_batch_id,
603: project_id,
604: table_name,

Line 648: Update PA_PURGE_PRJ_DETAILS

644:
645: -- update the pa_project_details with MRC statistics
646: pa_debug.debug('Before update of pa_project_details for MRC' );
647:
648: Update PA_PURGE_PRJ_DETAILS
649: Set num_recs_purged = nvl(num_recs_purged,0) + nvl(p_MRC_NoOfRecordsDel,0)
650: ,num_recs_archived = nvl(num_recs_archived,0) + nvl(p_MRC_NoOfRecordsIns,0)
651: ,last_update_date=sysdate
652: ,last_updated_by=fnd_global.user_id

Line 668: Insert into PA_PURGE_PRJ_DETAILS

664: --
665: IF SQL%Rowcount = 0 Then
666:
667: pa_debug.debug('Before insert MRC into pa_project_details' );
668: Insert into PA_PURGE_PRJ_DETAILS
669: (
670: purge_batch_id,
671: project_id,
672: table_name,