APPS.GHR_MTI_APP dependencies on GHR_MASS_TRANSFERS

Line 134: FROM GHR_MASS_TRANSFERS

130: --End Bug# 8724192
131:
132: CURSOR GHR_MTI_CUR (p_mt_id number) is
133: SELECT PA_REQUEST_ID
134: FROM GHR_MASS_TRANSFERS
135: WHERE MASS_TRANSFER_ID = p_mt_id
136: and TRANSFER_TYPE = 'IN';
137:
138: CURSOR c_asg_by_per_id_not_prim (p_per_id number, p_eff_date date) IS

Line 836: update ghr_mass_transfers

832: exception
833: when others then null;
834: end;
835:
836: update ghr_mass_transfers
837: set status = 'E'
838: where mass_transfer_id = p_mtin_id;
839: commit;
840: l_recs_failed := l_recs_failed + 1;

Line 863: update ghr_mass_transfers

859: exception
860: when others then null;
861: end;
862:
863: update ghr_mass_transfers
864: set status = 'E'
865: where mass_transfer_id = p_mtin_id;
866: commit;
867:

Line 891: update ghr_mass_transfers

887: end loop;
888:
889: if (l_recs_failed = 0) then
890: begin
891: update ghr_mass_transfers
892: set status = decode(l_mt_status_err_cnt,0,'P','E')
893: where mass_transfer_id = p_mtin_id;
894: commit;
895: EXCEPTION

Line 902: update ghr_mass_transfers

898: hr_utility.set_message(8301, 'GHR_38476_UPD_GHR_MSL_FAILURE');
899: hr_utility.raise_error;
900: END;
901: else
902: update ghr_mass_transfers
903: set status = 'E'
904: where mass_transfer_id = p_mtin_id;
905: commit;
906:

Line 916: update ghr_mass_transfers

912: when mass_error then
913: hr_utility.set_location('Mass error raised' || l_mass_errbuf , 245);
914: ROLLBACK TO EXECUTE_MRE_IN_SP;
915:
916: update ghr_mass_transfers
917: set status = 'E'
918: where mass_transfer_id = p_mtin_id;
919: commit;
920: l_recs_failed := l_recs_failed + 1;

Line 943: update ghr_mass_transfers

939: exception
940: when others then null;
941: end;
942:
943: update ghr_mass_transfers
944: set status = 'E'
945: where mass_transfer_id = p_mtin_id;
946: commit;
947: