eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_MU_BATCHES_V_PKG dependencies on FND_GLOBAL

Line 417: X_Request_ID := FND_GLOBAL.Conc_Request_ID;

413: AND trunc(sysdate) >= trunc(nvl(effective_date, sysdate));
414:
415: BEGIN
416: RETCODE := '0';
417: X_Request_ID := FND_GLOBAL.Conc_Request_ID;
418:
419: IF (PA_UTILS.GetEmpIdFromUser(FND_GLOBAL.user_id) IS NULL) THEN
420: raise l_NO_EMP_RECORD;
421: END IF;

Line 419: IF (PA_UTILS.GetEmpIdFromUser(FND_GLOBAL.user_id) IS NULL) THEN

415: BEGIN
416: RETCODE := '0';
417: X_Request_ID := FND_GLOBAL.Conc_Request_ID;
418:
419: IF (PA_UTILS.GetEmpIdFromUser(FND_GLOBAL.user_id) IS NULL) THEN
420: raise l_NO_EMP_RECORD;
421: END IF;
422:
423: IF (X_Batch_ID IS NOT NULL) THEN

Line 680: process_run_by = FND_GLOBAL.user_id,

676: UPDATE pa_mass_update_batches
677: SET batch_status_code = 'P',
678: rejection_code = NULL,
679: process_run_date = sysdate,
680: process_run_by = FND_GLOBAL.user_id,
681: request_id = FND_GLOBAL.Conc_Request_ID,
682: program_application_id = FND_GLOBAL.Prog_Appl_ID,
683: program_id = FND_GLOBAL.Conc_Program_ID,
684: last_update_login = FND_GLOBAL.Conc_Login_ID,

Line 681: request_id = FND_GLOBAL.Conc_Request_ID,

677: SET batch_status_code = 'P',
678: rejection_code = NULL,
679: process_run_date = sysdate,
680: process_run_by = FND_GLOBAL.user_id,
681: request_id = FND_GLOBAL.Conc_Request_ID,
682: program_application_id = FND_GLOBAL.Prog_Appl_ID,
683: program_id = FND_GLOBAL.Conc_Program_ID,
684: last_update_login = FND_GLOBAL.Conc_Login_ID,
685: program_update_date = sysdate

Line 682: program_application_id = FND_GLOBAL.Prog_Appl_ID,

678: rejection_code = NULL,
679: process_run_date = sysdate,
680: process_run_by = FND_GLOBAL.user_id,
681: request_id = FND_GLOBAL.Conc_Request_ID,
682: program_application_id = FND_GLOBAL.Prog_Appl_ID,
683: program_id = FND_GLOBAL.Conc_Program_ID,
684: last_update_login = FND_GLOBAL.Conc_Login_ID,
685: program_update_date = sysdate
686: WHERE CURRENT OF l_batch_csr;

Line 683: program_id = FND_GLOBAL.Conc_Program_ID,

679: process_run_date = sysdate,
680: process_run_by = FND_GLOBAL.user_id,
681: request_id = FND_GLOBAL.Conc_Request_ID,
682: program_application_id = FND_GLOBAL.Prog_Appl_ID,
683: program_id = FND_GLOBAL.Conc_Program_ID,
684: last_update_login = FND_GLOBAL.Conc_Login_ID,
685: program_update_date = sysdate
686: WHERE CURRENT OF l_batch_csr;
687: --

Line 684: last_update_login = FND_GLOBAL.Conc_Login_ID,

680: process_run_by = FND_GLOBAL.user_id,
681: request_id = FND_GLOBAL.Conc_Request_ID,
682: program_application_id = FND_GLOBAL.Prog_Appl_ID,
683: program_id = FND_GLOBAL.Conc_Program_ID,
684: last_update_login = FND_GLOBAL.Conc_Login_ID,
685: program_update_date = sysdate
686: WHERE CURRENT OF l_batch_csr;
687: --
688: -- Commit to release the lock

Line 702: last_updated_by = FND_GLOBAL.user_id,

698:
699: -- Reset the rejection reason for all the lines
700: UPDATE pa_mass_update_details
701: SET rejection_reason = NULL,
702: last_updated_by = FND_GLOBAL.user_id,
703: last_update_date = sysdate,
704: last_update_login = FND_GLOBAL.login_id
705: WHERE batch_id = X_Batch_ID
706: AND rejection_reason IS NOT NULL;

Line 704: last_update_login = FND_GLOBAL.login_id

700: UPDATE pa_mass_update_details
701: SET rejection_reason = NULL,
702: last_updated_by = FND_GLOBAL.user_id,
703: last_update_date = sysdate,
704: last_update_login = FND_GLOBAL.login_id
705: WHERE batch_id = X_Batch_ID
706: AND rejection_reason IS NOT NULL;
707:
708: --

Line 777: X_entered_by_user_id => FND_GLOBAL.user_id,

773: X_task_manager_person_id => l_ProjTask_rec.task_manager_person_id,
774: X_Service_type => l_ProjTask_rec.service_type_code,
775: X_task_start_date => l_ProjTask_rec.task_start_date,
776: X_task_end_date => l_ProjTask_rec.task_end_date,
777: X_entered_by_user_id => FND_GLOBAL.user_id,
778: X_attribute_category => l_ProjTask_rec.attribute_category,
779: X_attribute1 => l_ProjTask_rec.attribute1,
780: X_attribute2 => l_ProjTask_rec.attribute2,
781: X_attribute3 => l_ProjTask_rec.attribute3,

Line 813: request_id = FND_GLOBAL.Conc_Request_ID,

809:
810: UPDATE pa_projects_all
811: SET carrying_out_organization_id =
812: to_number(l_BatchLine_rec.new_attribute_value),
813: request_id = FND_GLOBAL.Conc_Request_ID,
814: program_application_id = FND_GLOBAL.Prog_Appl_ID,
815: program_id = FND_GLOBAL.Conc_Program_ID,
816: last_update_login = FND_GLOBAL.Conc_Login_ID,
817: program_update_date = sysdate

Line 814: program_application_id = FND_GLOBAL.Prog_Appl_ID,

810: UPDATE pa_projects_all
811: SET carrying_out_organization_id =
812: to_number(l_BatchLine_rec.new_attribute_value),
813: request_id = FND_GLOBAL.Conc_Request_ID,
814: program_application_id = FND_GLOBAL.Prog_Appl_ID,
815: program_id = FND_GLOBAL.Conc_Program_ID,
816: last_update_login = FND_GLOBAL.Conc_Login_ID,
817: program_update_date = sysdate
818: WHERE project_id = l_BatchLine_rec.project_id;

Line 815: program_id = FND_GLOBAL.Conc_Program_ID,

811: SET carrying_out_organization_id =
812: to_number(l_BatchLine_rec.new_attribute_value),
813: request_id = FND_GLOBAL.Conc_Request_ID,
814: program_application_id = FND_GLOBAL.Prog_Appl_ID,
815: program_id = FND_GLOBAL.Conc_Program_ID,
816: last_update_login = FND_GLOBAL.Conc_Login_ID,
817: program_update_date = sysdate
818: WHERE project_id = l_BatchLine_rec.project_id;
819:

Line 816: last_update_login = FND_GLOBAL.Conc_Login_ID,

812: to_number(l_BatchLine_rec.new_attribute_value),
813: request_id = FND_GLOBAL.Conc_Request_ID,
814: program_application_id = FND_GLOBAL.Prog_Appl_ID,
815: program_id = FND_GLOBAL.Conc_Program_ID,
816: last_update_login = FND_GLOBAL.Conc_Login_ID,
817: program_update_date = sysdate
818: WHERE project_id = l_BatchLine_rec.project_id;
819:
820: ELSE

Line 825: last_updated_by = FND_GLOBAL.User_ID,

821:
822: UPDATE pa_projects_all
823: SET carrying_out_organization_id =
824: to_number(l_BatchLine_rec.new_attribute_value),
825: last_updated_by = FND_GLOBAL.User_ID,
826: last_update_login = FND_GLOBAL.Login_ID,
827: last_update_date = sysdate
828: WHERE project_id = l_BatchLine_rec.project_id;
829:

Line 826: last_update_login = FND_GLOBAL.Login_ID,

822: UPDATE pa_projects_all
823: SET carrying_out_organization_id =
824: to_number(l_BatchLine_rec.new_attribute_value),
825: last_updated_by = FND_GLOBAL.User_ID,
826: last_update_login = FND_GLOBAL.Login_ID,
827: last_update_date = sysdate
828: WHERE project_id = l_BatchLine_rec.project_id;
829:
830: END IF; -- (X_Concurrent = 'Y')

Line 837: request_id = FND_GLOBAL.Conc_Request_ID,

833:
834: UPDATE pa_tasks
835: SET carrying_out_organization_id =
836: to_number(l_BatchLine_rec.new_attribute_value),
837: request_id = FND_GLOBAL.Conc_Request_ID,
838: program_application_id = FND_GLOBAL.Prog_Appl_ID,
839: program_id = FND_GLOBAL.Conc_Program_ID,
840: last_update_login = FND_GLOBAL.Conc_Login_ID,
841: program_update_date = sysdate

Line 838: program_application_id = FND_GLOBAL.Prog_Appl_ID,

834: UPDATE pa_tasks
835: SET carrying_out_organization_id =
836: to_number(l_BatchLine_rec.new_attribute_value),
837: request_id = FND_GLOBAL.Conc_Request_ID,
838: program_application_id = FND_GLOBAL.Prog_Appl_ID,
839: program_id = FND_GLOBAL.Conc_Program_ID,
840: last_update_login = FND_GLOBAL.Conc_Login_ID,
841: program_update_date = sysdate
842: WHERE task_id = l_BatchLine_rec.task_id;

Line 839: program_id = FND_GLOBAL.Conc_Program_ID,

835: SET carrying_out_organization_id =
836: to_number(l_BatchLine_rec.new_attribute_value),
837: request_id = FND_GLOBAL.Conc_Request_ID,
838: program_application_id = FND_GLOBAL.Prog_Appl_ID,
839: program_id = FND_GLOBAL.Conc_Program_ID,
840: last_update_login = FND_GLOBAL.Conc_Login_ID,
841: program_update_date = sysdate
842: WHERE task_id = l_BatchLine_rec.task_id;
843:

Line 840: last_update_login = FND_GLOBAL.Conc_Login_ID,

836: to_number(l_BatchLine_rec.new_attribute_value),
837: request_id = FND_GLOBAL.Conc_Request_ID,
838: program_application_id = FND_GLOBAL.Prog_Appl_ID,
839: program_id = FND_GLOBAL.Conc_Program_ID,
840: last_update_login = FND_GLOBAL.Conc_Login_ID,
841: program_update_date = sysdate
842: WHERE task_id = l_BatchLine_rec.task_id;
843:
844: /* Added for bug#5718668 by anuagraw */

Line 848: request_id = FND_GLOBAL.Conc_Request_ID,

844: /* Added for bug#5718668 by anuagraw */
845: UPDATE pa_proj_elements
846: SET carrying_out_organization_id =
847: to_number(l_BatchLine_rec.new_attribute_value),
848: request_id = FND_GLOBAL.Conc_Request_ID,
849: program_application_id = FND_GLOBAL.Prog_Appl_ID,
850: program_id = FND_GLOBAL.Conc_Program_ID,
851: last_update_login = FND_GLOBAL.Conc_Login_ID,
852: program_update_date = sysdate

Line 849: program_application_id = FND_GLOBAL.Prog_Appl_ID,

845: UPDATE pa_proj_elements
846: SET carrying_out_organization_id =
847: to_number(l_BatchLine_rec.new_attribute_value),
848: request_id = FND_GLOBAL.Conc_Request_ID,
849: program_application_id = FND_GLOBAL.Prog_Appl_ID,
850: program_id = FND_GLOBAL.Conc_Program_ID,
851: last_update_login = FND_GLOBAL.Conc_Login_ID,
852: program_update_date = sysdate
853: WHERE proj_element_id = l_BatchLine_rec.task_id;

Line 850: program_id = FND_GLOBAL.Conc_Program_ID,

846: SET carrying_out_organization_id =
847: to_number(l_BatchLine_rec.new_attribute_value),
848: request_id = FND_GLOBAL.Conc_Request_ID,
849: program_application_id = FND_GLOBAL.Prog_Appl_ID,
850: program_id = FND_GLOBAL.Conc_Program_ID,
851: last_update_login = FND_GLOBAL.Conc_Login_ID,
852: program_update_date = sysdate
853: WHERE proj_element_id = l_BatchLine_rec.task_id;
854: /* Added for bug#5718668 by anuagraw */

Line 851: last_update_login = FND_GLOBAL.Conc_Login_ID,

847: to_number(l_BatchLine_rec.new_attribute_value),
848: request_id = FND_GLOBAL.Conc_Request_ID,
849: program_application_id = FND_GLOBAL.Prog_Appl_ID,
850: program_id = FND_GLOBAL.Conc_Program_ID,
851: last_update_login = FND_GLOBAL.Conc_Login_ID,
852: program_update_date = sysdate
853: WHERE proj_element_id = l_BatchLine_rec.task_id;
854: /* Added for bug#5718668 by anuagraw */
855:

Line 861: last_updated_by = FND_GLOBAL.User_ID,

857:
858: UPDATE pa_tasks
859: SET carrying_out_organization_id =
860: to_number(l_BatchLine_rec.new_attribute_value),
861: last_updated_by = FND_GLOBAL.User_ID,
862: last_update_login = FND_GLOBAL.Login_ID,
863: last_update_date = sysdate
864: WHERE task_id = l_BatchLine_rec.task_id;
865:

Line 862: last_update_login = FND_GLOBAL.Login_ID,

858: UPDATE pa_tasks
859: SET carrying_out_organization_id =
860: to_number(l_BatchLine_rec.new_attribute_value),
861: last_updated_by = FND_GLOBAL.User_ID,
862: last_update_login = FND_GLOBAL.Login_ID,
863: last_update_date = sysdate
864: WHERE task_id = l_BatchLine_rec.task_id;
865:
866: /* Added for bug#5718668 by anuagraw */

Line 870: last_updated_by = FND_GLOBAL.User_ID,

866: /* Added for bug#5718668 by anuagraw */
867: UPDATE pa_proj_elements
868: SET carrying_out_organization_id =
869: to_number(l_BatchLine_rec.new_attribute_value),
870: last_updated_by = FND_GLOBAL.User_ID,
871: last_update_login = FND_GLOBAL.Login_ID,
872: last_update_date = sysdate
873: WHERE proj_element_id = l_BatchLine_rec.task_id;
874: /* Added for bug#5718668 by anuagraw */

Line 871: last_update_login = FND_GLOBAL.Login_ID,

867: UPDATE pa_proj_elements
868: SET carrying_out_organization_id =
869: to_number(l_BatchLine_rec.new_attribute_value),
870: last_updated_by = FND_GLOBAL.User_ID,
871: last_update_login = FND_GLOBAL.Login_ID,
872: last_update_date = sysdate
873: WHERE proj_element_id = l_BatchLine_rec.task_id;
874: /* Added for bug#5718668 by anuagraw */
875:

Line 889: X_user => FND_GLOBAL.User_ID,

885:
886: PA_ADJUSTMENTS.MassAdjust(
887: X_adj_action => 'COST AND REV RECALC',
888: X_module => 'PAXBAUPD',
889: X_user => FND_GLOBAL.User_ID,
890: X_login => FND_GLOBAL.Login_ID,
891: X_project_id => l_BatchLine_rec.project_id,
892: X_task_id => l_BatchLine_rec.task_id,
893: X_ei_date_low => l_effective_date,

Line 890: X_login => FND_GLOBAL.Login_ID,

886: PA_ADJUSTMENTS.MassAdjust(
887: X_adj_action => 'COST AND REV RECALC',
888: X_module => 'PAXBAUPD',
889: X_user => FND_GLOBAL.User_ID,
890: X_login => FND_GLOBAL.Login_ID,
891: X_project_id => l_BatchLine_rec.project_id,
892: X_task_id => l_BatchLine_rec.task_id,
893: X_ei_date_low => l_effective_date,
894: X_outcome => l_mass_adj_outcome,

Line 905: X_user => FND_GLOBAL.User_ID,

901:
902: PA_ADJUSTMENTS.MassAdjust(
903: X_adj_action => 'REPROCESS CROSS CHARGE',
904: X_module => 'PAXBAUPD',
905: X_user => FND_GLOBAL.User_ID,
906: X_login => FND_GLOBAL.Login_ID,
907: X_project_id => l_BatchLine_rec.project_id,
908: X_task_id => l_BatchLine_rec.task_id,
909: X_ei_date_low => l_effective_date,

Line 906: X_login => FND_GLOBAL.Login_ID,

902: PA_ADJUSTMENTS.MassAdjust(
903: X_adj_action => 'REPROCESS CROSS CHARGE',
904: X_module => 'PAXBAUPD',
905: X_user => FND_GLOBAL.User_ID,
906: X_login => FND_GLOBAL.Login_ID,
907: X_project_id => l_BatchLine_rec.project_id,
908: X_task_id => l_BatchLine_rec.task_id,
909: X_ei_date_low => l_effective_date,
910: X_outcome => l_mass_adj_outcome,

Line 924: X_user => FND_GLOBAL.User_ID,

920:
921: PA_ADJUSTMENTS.MassAdjust(
922: X_adj_action => 'INDIRECT COST RECALC',
923: X_module => 'PAXBAUPD',
924: X_user => FND_GLOBAL.User_ID,
925: X_login => FND_GLOBAL.Login_ID,
926: X_project_id => l_BatchLine_rec.project_id,
927: X_task_id => l_BatchLine_rec.task_id,
928: X_system_linkage => 'VI',

Line 925: X_login => FND_GLOBAL.Login_ID,

921: PA_ADJUSTMENTS.MassAdjust(
922: X_adj_action => 'INDIRECT COST RECALC',
923: X_module => 'PAXBAUPD',
924: X_user => FND_GLOBAL.User_ID,
925: X_login => FND_GLOBAL.Login_ID,
926: X_project_id => l_BatchLine_rec.project_id,
927: X_task_id => l_BatchLine_rec.task_id,
928: X_system_linkage => 'VI',
929: X_ei_date_low => l_effective_date,

Line 976: last_updated_by = FND_GLOBAL.user_id,

972:
973: FOR i IN l_Error_Tab.FIRST .. l_Error_Tab.LAST LOOP
974: UPDATE pa_mass_update_details
975: SET rejection_reason = l_Error_Tab(i).rejection_reason,
976: last_updated_by = FND_GLOBAL.user_id,
977: last_update_date = sysdate,
978: last_update_login = FND_GLOBAL.login_id
979: WHERE batch_id = X_Batch_ID
980: AND line_id = l_Error_Tab(i).line_id;

Line 978: last_update_login = FND_GLOBAL.login_id

974: UPDATE pa_mass_update_details
975: SET rejection_reason = l_Error_Tab(i).rejection_reason,
976: last_updated_by = FND_GLOBAL.user_id,
977: last_update_date = sysdate,
978: last_update_login = FND_GLOBAL.login_id
979: WHERE batch_id = X_Batch_ID
980: AND line_id = l_Error_Tab(i).line_id;
981: END LOOP;
982: --

Line 997: process_run_by = FND_GLOBAL.user_id,

993: --
994: UPDATE pa_mass_update_batches
995: SET batch_status_code = l_proc_status,
996: rejection_code = ERRBUF,
997: process_run_by = FND_GLOBAL.user_id,
998: process_run_date = sysdate,
999: program_application_id = FND_GLOBAL.Prog_Appl_ID,
1000: program_id = FND_GLOBAL.Conc_Program_ID,
1001: last_update_login = FND_GLOBAL.Conc_Login_ID,

Line 999: program_application_id = FND_GLOBAL.Prog_Appl_ID,

995: SET batch_status_code = l_proc_status,
996: rejection_code = ERRBUF,
997: process_run_by = FND_GLOBAL.user_id,
998: process_run_date = sysdate,
999: program_application_id = FND_GLOBAL.Prog_Appl_ID,
1000: program_id = FND_GLOBAL.Conc_Program_ID,
1001: last_update_login = FND_GLOBAL.Conc_Login_ID,
1002: program_update_date = sysdate
1003: WHERE batch_id = X_Batch_ID;

Line 1000: program_id = FND_GLOBAL.Conc_Program_ID,

996: rejection_code = ERRBUF,
997: process_run_by = FND_GLOBAL.user_id,
998: process_run_date = sysdate,
999: program_application_id = FND_GLOBAL.Prog_Appl_ID,
1000: program_id = FND_GLOBAL.Conc_Program_ID,
1001: last_update_login = FND_GLOBAL.Conc_Login_ID,
1002: program_update_date = sysdate
1003: WHERE batch_id = X_Batch_ID;
1004:

Line 1001: last_update_login = FND_GLOBAL.Conc_Login_ID,

997: process_run_by = FND_GLOBAL.user_id,
998: process_run_date = sysdate,
999: program_application_id = FND_GLOBAL.Prog_Appl_ID,
1000: program_id = FND_GLOBAL.Conc_Program_ID,
1001: last_update_login = FND_GLOBAL.Conc_Login_ID,
1002: program_update_date = sysdate
1003: WHERE batch_id = X_Batch_ID;
1004:
1005: COMMIT;

Line 1021: process_run_by = FND_GLOBAL.user_id,

1017: ERRBUF := 'INVALID_STATUS';
1018: UPDATE pa_mass_update_batches
1019: SET batch_status_code = 'R',
1020: rejection_code = 'INVALID_STATUS',
1021: process_run_by = FND_GLOBAL.user_id,
1022: process_run_date = sysdate,
1023: program_application_id = FND_GLOBAL.Prog_Appl_ID,
1024: program_id = FND_GLOBAL.Conc_Program_ID,
1025: last_update_login = FND_GLOBAL.Conc_Login_ID,

Line 1023: program_application_id = FND_GLOBAL.Prog_Appl_ID,

1019: SET batch_status_code = 'R',
1020: rejection_code = 'INVALID_STATUS',
1021: process_run_by = FND_GLOBAL.user_id,
1022: process_run_date = sysdate,
1023: program_application_id = FND_GLOBAL.Prog_Appl_ID,
1024: program_id = FND_GLOBAL.Conc_Program_ID,
1025: last_update_login = FND_GLOBAL.Conc_Login_ID,
1026: program_update_date = sysdate
1027: WHERE batch_id = X_Batch_ID;

Line 1024: program_id = FND_GLOBAL.Conc_Program_ID,

1020: rejection_code = 'INVALID_STATUS',
1021: process_run_by = FND_GLOBAL.user_id,
1022: process_run_date = sysdate,
1023: program_application_id = FND_GLOBAL.Prog_Appl_ID,
1024: program_id = FND_GLOBAL.Conc_Program_ID,
1025: last_update_login = FND_GLOBAL.Conc_Login_ID,
1026: program_update_date = sysdate
1027: WHERE batch_id = X_Batch_ID;
1028: COMMIT;

Line 1025: last_update_login = FND_GLOBAL.Conc_Login_ID,

1021: process_run_by = FND_GLOBAL.user_id,
1022: process_run_date = sysdate,
1023: program_application_id = FND_GLOBAL.Prog_Appl_ID,
1024: program_id = FND_GLOBAL.Conc_Program_ID,
1025: last_update_login = FND_GLOBAL.Conc_Login_ID,
1026: program_update_date = sysdate
1027: WHERE batch_id = X_Batch_ID;
1028: COMMIT;
1029: END IF;

Line 1042: process_run_by = FND_GLOBAL.user_id,

1038: ERRBUF := 'EFFECTIVE_DATE';
1039: UPDATE pa_mass_update_batches
1040: SET batch_status_code = 'R',
1041: rejection_code = 'EFFECTIVE_DATE',
1042: process_run_by = FND_GLOBAL.user_id,
1043: process_run_date = sysdate,
1044: program_application_id = FND_GLOBAL.Prog_Appl_ID,
1045: program_id = FND_GLOBAL.Conc_Program_ID,
1046: last_update_login = FND_GLOBAL.Conc_Login_ID,

Line 1044: program_application_id = FND_GLOBAL.Prog_Appl_ID,

1040: SET batch_status_code = 'R',
1041: rejection_code = 'EFFECTIVE_DATE',
1042: process_run_by = FND_GLOBAL.user_id,
1043: process_run_date = sysdate,
1044: program_application_id = FND_GLOBAL.Prog_Appl_ID,
1045: program_id = FND_GLOBAL.Conc_Program_ID,
1046: last_update_login = FND_GLOBAL.Conc_Login_ID,
1047: program_update_date = sysdate
1048: WHERE batch_id = X_Batch_ID;

Line 1045: program_id = FND_GLOBAL.Conc_Program_ID,

1041: rejection_code = 'EFFECTIVE_DATE',
1042: process_run_by = FND_GLOBAL.user_id,
1043: process_run_date = sysdate,
1044: program_application_id = FND_GLOBAL.Prog_Appl_ID,
1045: program_id = FND_GLOBAL.Conc_Program_ID,
1046: last_update_login = FND_GLOBAL.Conc_Login_ID,
1047: program_update_date = sysdate
1048: WHERE batch_id = X_Batch_ID;
1049: COMMIT;

Line 1046: last_update_login = FND_GLOBAL.Conc_Login_ID,

1042: process_run_by = FND_GLOBAL.user_id,
1043: process_run_date = sysdate,
1044: program_application_id = FND_GLOBAL.Prog_Appl_ID,
1045: program_id = FND_GLOBAL.Conc_Program_ID,
1046: last_update_login = FND_GLOBAL.Conc_Login_ID,
1047: program_update_date = sysdate
1048: WHERE batch_id = X_Batch_ID;
1049: COMMIT;
1050: END IF;

Line 1063: process_run_by = FND_GLOBAL.user_id,

1059: IF (X_Concurrent = 'Y') THEN
1060: UPDATE pa_mass_update_batches
1061: SET batch_status_code = 'R',
1062: rejection_code = 'SQL_ERROR',
1063: process_run_by = FND_GLOBAL.user_id,
1064: process_run_date = sysdate,
1065: program_application_id = FND_GLOBAL.Prog_Appl_ID,
1066: program_id = FND_GLOBAL.Conc_Program_ID,
1067: last_update_login = FND_GLOBAL.Conc_Login_ID,

Line 1065: program_application_id = FND_GLOBAL.Prog_Appl_ID,

1061: SET batch_status_code = 'R',
1062: rejection_code = 'SQL_ERROR',
1063: process_run_by = FND_GLOBAL.user_id,
1064: process_run_date = sysdate,
1065: program_application_id = FND_GLOBAL.Prog_Appl_ID,
1066: program_id = FND_GLOBAL.Conc_Program_ID,
1067: last_update_login = FND_GLOBAL.Conc_Login_ID,
1068: program_update_date = sysdate
1069: WHERE batch_id = X_Batch_ID;

Line 1066: program_id = FND_GLOBAL.Conc_Program_ID,

1062: rejection_code = 'SQL_ERROR',
1063: process_run_by = FND_GLOBAL.user_id,
1064: process_run_date = sysdate,
1065: program_application_id = FND_GLOBAL.Prog_Appl_ID,
1066: program_id = FND_GLOBAL.Conc_Program_ID,
1067: last_update_login = FND_GLOBAL.Conc_Login_ID,
1068: program_update_date = sysdate
1069: WHERE batch_id = X_Batch_ID;
1070: COMMIT;

Line 1067: last_update_login = FND_GLOBAL.Conc_Login_ID,

1063: process_run_by = FND_GLOBAL.user_id,
1064: process_run_date = sysdate,
1065: program_application_id = FND_GLOBAL.Prog_Appl_ID,
1066: program_id = FND_GLOBAL.Conc_Program_ID,
1067: last_update_login = FND_GLOBAL.Conc_Login_ID,
1068: program_update_date = sysdate
1069: WHERE batch_id = X_Batch_ID;
1070: COMMIT;
1071: END IF;