APPS.HR_MASS_MOVE_API dependencies on PER_MM_POSITIONS

Line 2502: cursor csr_lock_per_mm_positions is

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

Line 2504: from per_mm_positions

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

Line 2643: from per_mm_positions mmpos,

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

Line 2717: open csr_lock_per_mm_positions;

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

Line 2718: close csr_lock_per_mm_positions;

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

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

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

Line 2932: update per_mm_positions

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

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

3120: end if;
3121: --
3122: end; --begin
3123: --
3124: end loop; /* end loop through positions in per_mm_positions */
3125: --
3126: hr_utility.set_location(l_proc, 250);
3127: --
3128: -- Call Customer-Specific stub to handle post-mass move validation