APPS.PA_PURGE dependencies on FND_GLOBAL

Line 280: ,last_updated_by=fnd_global.user_id

276: update pa_purge_projects
277: set
278: purged_date=sysdate
279: ,last_update_date=sysdate
280: ,last_updated_by=fnd_global.user_id
281: ,last_update_login=fnd_global.login_id
282: ,program_id = fnd_global.conc_program_id
283: ,program_application_id = fnd_global.prog_appl_id
284: ,request_id = fnd_global.conc_request_id

Line 281: ,last_update_login=fnd_global.login_id

277: set
278: purged_date=sysdate
279: ,last_update_date=sysdate
280: ,last_updated_by=fnd_global.user_id
281: ,last_update_login=fnd_global.login_id
282: ,program_id = fnd_global.conc_program_id
283: ,program_application_id = fnd_global.prog_appl_id
284: ,request_id = fnd_global.conc_request_id
285: ,program_update_date = sysdate

Line 282: ,program_id = fnd_global.conc_program_id

278: purged_date=sysdate
279: ,last_update_date=sysdate
280: ,last_updated_by=fnd_global.user_id
281: ,last_update_login=fnd_global.login_id
282: ,program_id = fnd_global.conc_program_id
283: ,program_application_id = fnd_global.prog_appl_id
284: ,request_id = fnd_global.conc_request_id
285: ,program_update_date = sysdate
286: where purge_batch_id = p_batch_id

Line 283: ,program_application_id = fnd_global.prog_appl_id

279: ,last_update_date=sysdate
280: ,last_updated_by=fnd_global.user_id
281: ,last_update_login=fnd_global.login_id
282: ,program_id = fnd_global.conc_program_id
283: ,program_application_id = fnd_global.prog_appl_id
284: ,request_id = fnd_global.conc_request_id
285: ,program_update_date = sysdate
286: where purge_batch_id = p_batch_id
287: and project_id = p_project_id;

Line 284: ,request_id = fnd_global.conc_request_id

280: ,last_updated_by=fnd_global.user_id
281: ,last_update_login=fnd_global.login_id
282: ,program_id = fnd_global.conc_program_id
283: ,program_application_id = fnd_global.prog_appl_id
284: ,request_id = fnd_global.conc_request_id
285: ,program_update_date = sysdate
286: where purge_batch_id = p_batch_id
287: and project_id = p_project_id;
288:

Line 390: request_id = fnd_global.conc_request_id

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:
393: Commit;
394: pa_debug.debug('After update of pa_purge_batches to pending');

Line 402: and request_id = fnd_global.conc_request_id

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:
405: pa_debug.debug('After locking table pa_purge_batches');
406:

Line 499: ,last_updated_by=fnd_global.user_id

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
500: ,last_update_login=fnd_global.login_id
501: Where purge_batch_id = p_batch_id;
502:
503: Commit;

Line 500: ,last_update_login=fnd_global.login_id

496: Set batch_status_code='C'
497: ,purged_date=sysdate
498: ,last_update_date=sysdate
499: ,last_updated_by=fnd_global.user_id
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');

Line 584: ,last_updated_by=fnd_global.user_id

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
585: ,last_update_login=fnd_global.login_id
586: ,program_id = fnd_global.conc_program_id
587: ,program_application_id = fnd_global.prog_appl_id
588: ,request_id = fnd_global.conc_request_id

Line 585: ,last_update_login=fnd_global.login_id

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
585: ,last_update_login=fnd_global.login_id
586: ,program_id = fnd_global.conc_program_id
587: ,program_application_id = fnd_global.prog_appl_id
588: ,request_id = fnd_global.conc_request_id
589: ,program_update_date = sysdate

Line 586: ,program_id = fnd_global.conc_program_id

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
585: ,last_update_login=fnd_global.login_id
586: ,program_id = fnd_global.conc_program_id
587: ,program_application_id = fnd_global.prog_appl_id
588: ,request_id = fnd_global.conc_request_id
589: ,program_update_date = sysdate
590: Where purge_batch_id = p_purge_batch_id

Line 587: ,program_application_id = fnd_global.prog_appl_id

583: ,last_update_date=sysdate
584: ,last_updated_by=fnd_global.user_id
585: ,last_update_login=fnd_global.login_id
586: ,program_id = fnd_global.conc_program_id
587: ,program_application_id = fnd_global.prog_appl_id
588: ,request_id = fnd_global.conc_request_id
589: ,program_update_date = sysdate
590: Where purge_batch_id = p_purge_batch_id
591: And project_id = p_project_id

Line 588: ,request_id = fnd_global.conc_request_id

584: ,last_updated_by=fnd_global.user_id
585: ,last_update_login=fnd_global.login_id
586: ,program_id = fnd_global.conc_program_id
587: ,program_application_id = fnd_global.prog_appl_id
588: ,request_id = fnd_global.conc_request_id
589: ,program_update_date = sysdate
590: Where purge_batch_id = p_purge_batch_id
591: And project_id = p_project_id
592: And Table_name = p_table_name;

Line 624: fnd_global.user_id,

620: p_project_id,
621: p_table_name,
622: p_NoOfRecordsDel,
623: p_NoOfRecordsIns,
624: fnd_global.user_id,
625: sysdate,
626: fnd_global.user_id,
627: fnd_global.user_id,
628: sysdate,

Line 626: fnd_global.user_id,

622: p_NoOfRecordsDel,
623: p_NoOfRecordsIns,
624: fnd_global.user_id,
625: sysdate,
626: fnd_global.user_id,
627: fnd_global.user_id,
628: sysdate,
629: fnd_global.conc_program_id,
630: fnd_global.prog_appl_id,

Line 627: fnd_global.user_id,

623: p_NoOfRecordsIns,
624: fnd_global.user_id,
625: sysdate,
626: fnd_global.user_id,
627: fnd_global.user_id,
628: sysdate,
629: fnd_global.conc_program_id,
630: fnd_global.prog_appl_id,
631: fnd_global.conc_request_id,

Line 629: fnd_global.conc_program_id,

625: sysdate,
626: fnd_global.user_id,
627: fnd_global.user_id,
628: sysdate,
629: fnd_global.conc_program_id,
630: fnd_global.prog_appl_id,
631: fnd_global.conc_request_id,
632: sysdate
633: );

Line 630: fnd_global.prog_appl_id,

626: fnd_global.user_id,
627: fnd_global.user_id,
628: sysdate,
629: fnd_global.conc_program_id,
630: fnd_global.prog_appl_id,
631: fnd_global.conc_request_id,
632: sysdate
633: );
634:

Line 631: fnd_global.conc_request_id,

627: fnd_global.user_id,
628: sysdate,
629: fnd_global.conc_program_id,
630: fnd_global.prog_appl_id,
631: fnd_global.conc_request_id,
632: sysdate
633: );
634:
635: pa_debug.debug('After insert into pa_project_details' );

Line 652: ,last_updated_by=fnd_global.user_id

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
653: ,last_update_login=fnd_global.login_id
654: ,program_id = fnd_global.conc_program_id
655: ,program_application_id = fnd_global.prog_appl_id
656: ,request_id = fnd_global.conc_request_id

Line 653: ,last_update_login=fnd_global.login_id

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
653: ,last_update_login=fnd_global.login_id
654: ,program_id = fnd_global.conc_program_id
655: ,program_application_id = fnd_global.prog_appl_id
656: ,request_id = fnd_global.conc_request_id
657: ,program_update_date = sysdate

Line 654: ,program_id = fnd_global.conc_program_id

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
653: ,last_update_login=fnd_global.login_id
654: ,program_id = fnd_global.conc_program_id
655: ,program_application_id = fnd_global.prog_appl_id
656: ,request_id = fnd_global.conc_request_id
657: ,program_update_date = sysdate
658: Where purge_batch_id = p_purge_batch_id

Line 655: ,program_application_id = fnd_global.prog_appl_id

651: ,last_update_date=sysdate
652: ,last_updated_by=fnd_global.user_id
653: ,last_update_login=fnd_global.login_id
654: ,program_id = fnd_global.conc_program_id
655: ,program_application_id = fnd_global.prog_appl_id
656: ,request_id = fnd_global.conc_request_id
657: ,program_update_date = sysdate
658: Where purge_batch_id = p_purge_batch_id
659: And project_id = p_project_id

Line 656: ,request_id = fnd_global.conc_request_id

652: ,last_updated_by=fnd_global.user_id
653: ,last_update_login=fnd_global.login_id
654: ,program_id = fnd_global.conc_program_id
655: ,program_application_id = fnd_global.prog_appl_id
656: ,request_id = fnd_global.conc_request_id
657: ,program_update_date = sysdate
658: Where purge_batch_id = p_purge_batch_id
659: And project_id = p_project_id
660: And Table_name = p_MRC_table_name;

Line 692: fnd_global.user_id,

688: p_project_id,
689: p_MRC_table_name,
690: p_MRC_NoOfRecordsDel,
691: p_MRC_NoOfRecordsIns,
692: fnd_global.user_id,
693: sysdate,
694: fnd_global.user_id,
695: fnd_global.user_id,
696: sysdate,

Line 694: fnd_global.user_id,

690: p_MRC_NoOfRecordsDel,
691: p_MRC_NoOfRecordsIns,
692: fnd_global.user_id,
693: sysdate,
694: fnd_global.user_id,
695: fnd_global.user_id,
696: sysdate,
697: fnd_global.conc_program_id,
698: fnd_global.prog_appl_id,

Line 695: fnd_global.user_id,

691: p_MRC_NoOfRecordsIns,
692: fnd_global.user_id,
693: sysdate,
694: fnd_global.user_id,
695: fnd_global.user_id,
696: sysdate,
697: fnd_global.conc_program_id,
698: fnd_global.prog_appl_id,
699: fnd_global.conc_request_id,

Line 697: fnd_global.conc_program_id,

693: sysdate,
694: fnd_global.user_id,
695: fnd_global.user_id,
696: sysdate,
697: fnd_global.conc_program_id,
698: fnd_global.prog_appl_id,
699: fnd_global.conc_request_id,
700: sysdate
701: );

Line 698: fnd_global.prog_appl_id,

694: fnd_global.user_id,
695: fnd_global.user_id,
696: sysdate,
697: fnd_global.conc_program_id,
698: fnd_global.prog_appl_id,
699: fnd_global.conc_request_id,
700: sysdate
701: );
702:

Line 699: fnd_global.conc_request_id,

695: fnd_global.user_id,
696: sysdate,
697: fnd_global.conc_program_id,
698: fnd_global.prog_appl_id,
699: fnd_global.conc_request_id,
700: sysdate
701: );
702:
703: pa_debug.debug('After insert MRC into pa_project_details' );

Line 720: and request_id = fnd_global.conc_request_id

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:
723: pa_debug.debug('After locking pa_purge_batches again');
724: