APPS.GHR_MTI_APP dependencies on GHR_MASS_TRANSFERS

Line 111: FROM GHR_MASS_TRANSFERS

107: and pa_request_id = p_pa_request_id;
108:
109: CURSOR GHR_MTI_CUR (p_mt_id number) is
110: SELECT PA_REQUEST_ID
111: FROM GHR_MASS_TRANSFERS
112: WHERE MASS_TRANSFER_ID = p_mt_id
113: and TRANSFER_TYPE = 'IN';
114:
115: CURSOR c_asg_by_per_id_not_prim (p_per_id number, p_eff_date date) IS

Line 723: update ghr_mass_transfers

719: exception
720: when others then null;
721: end;
722:
723: update ghr_mass_transfers
724: set status = 'E'
725: where mass_transfer_id = p_mtin_id;
726: commit;
727: l_recs_failed := l_recs_failed + 1;

Line 750: update ghr_mass_transfers

746: exception
747: when others then null;
748: end;
749:
750: update ghr_mass_transfers
751: set status = 'E'
752: where mass_transfer_id = p_mtin_id;
753: commit;
754:

Line 778: update ghr_mass_transfers

774: end loop;
775:
776: if (l_recs_failed = 0) then
777: begin
778: update ghr_mass_transfers
779: set status = decode(l_mt_status_err_cnt,0,'P','E')
780: where mass_transfer_id = p_mtin_id;
781: commit;
782: EXCEPTION

Line 789: update ghr_mass_transfers

785: hr_utility.set_message(8301, 'GHR_38476_UPD_GHR_MSL_FAILURE');
786: hr_utility.raise_error;
787: END;
788: else
789: update ghr_mass_transfers
790: set status = 'E'
791: where mass_transfer_id = p_mtin_id;
792: commit;
793:

Line 803: update ghr_mass_transfers

799: when mass_error then
800: hr_utility.set_location('Mass error raised' || l_mass_errbuf , 245);
801: ROLLBACK TO EXECUTE_MRE_IN_SP;
802:
803: update ghr_mass_transfers
804: set status = 'E'
805: where mass_transfer_id = p_mtin_id;
806: commit;
807: l_recs_failed := l_recs_failed + 1;

Line 830: update ghr_mass_transfers

826: exception
827: when others then null;
828: end;
829:
830: update ghr_mass_transfers
831: set status = 'E'
832: where mass_transfer_id = p_mtin_id;
833: commit;
834: