APPS.HR_MASS_MOVE_API dependencies on PER_MM_POSITIONS

Line 2500: cursor csr_lock_per_mm_positions is

2496: from per_mass_moves
2497: where mass_move_id = p_mass_move_id
2498: for update nowait;
2499: --
2500: cursor csr_lock_per_mm_positions is
2501: select null
2502: from per_mm_positions
2503: where mass_move_id = p_mass_move_id
2504: for update nowait;

Line 2502: from per_mm_positions

2498: for update nowait;
2499: --
2500: cursor csr_lock_per_mm_positions is
2501: select null
2502: from per_mm_positions
2503: where mass_move_id = p_mass_move_id
2504: for update nowait;
2505: --
2506: cursor csr_lock_per_mm_assignments is

Line 2641: from per_mm_positions mmpos,

2637: mmpos.segment27,
2638: mmpos.segment28,
2639: mmpos.segment29,
2640: mmpos.segment30
2641: from per_mm_positions mmpos,
2642: hr_positions_f pos
2643: where mmpos.mass_move_id = p_mass_move_id
2644: and mmpos.position_id = pos.position_id
2645: and mmpos.select_position = 'Y'

Line 2715: open csr_lock_per_mm_positions;

2711: -- Lock all tables holding mass move information
2712: --
2713: open csr_lock_per_mass_moves;
2714: close csr_lock_per_mass_moves;
2715: open csr_lock_per_mm_positions;
2716: close csr_lock_per_mm_positions;
2717: open csr_lock_per_mm_assignments;
2718: close csr_lock_per_mm_assignments;
2719: open csr_lock_per_mm_valid_grades;

Line 2716: close csr_lock_per_mm_positions;

2712: --
2713: open csr_lock_per_mass_moves;
2714: close csr_lock_per_mass_moves;
2715: open csr_lock_per_mm_positions;
2716: close csr_lock_per_mm_positions;
2717: open csr_lock_per_mm_assignments;
2718: close csr_lock_per_mm_assignments;
2719: open csr_lock_per_mm_valid_grades;
2720: close csr_lock_per_mm_valid_grades;

Line 2786: -- Loop through the position records in per_mm_positions, and

2782: (p_mass_move_id => p_mass_move_id);
2783: --
2784: hr_utility.set_location(l_proc, 60);
2785: --
2786: -- Loop through the position records in per_mm_positions, and
2787: -- process the position, applicant assignments, and employee
2788: -- assignment records.
2789: --
2790: for mmposrec in csr_get_mm_positions loop

Line 2930: update per_mm_positions

2926: if (l_new_position_id is not null) then
2927: --
2928: -- If it made it this far, update the position to 'moved'
2929: --
2930: update per_mm_positions
2931: set position_moved = 'Y',
2932: target_job_id = l_new_job_id,
2933: new_position_id = l_new_position_id
2934: where position_id = mmposrec.position_id

Line 3116: end loop; /* end loop through positions in per_mm_positions */

3112: end if;
3113: --
3114: end; --begin
3115: --
3116: end loop; /* end loop through positions in per_mm_positions */
3117: --
3118: hr_utility.set_location(l_proc, 250);
3119: --
3120: -- Call Customer-Specific stub to handle post-mass move validation