APPS.HR_MASS_MOVE_API dependencies on PER_MASS_MOVES

Line 2007: per_mass_moves mm,

2003: --
2004: cursor csr_future_asg_changes is
2005: select null
2006: from per_assignments_f asg,
2007: per_mass_moves mm,
2008: per_mm_assignments mmasg
2009: where mmasg.assignment_id = l_mm_assignment_id
2010: and asg.assignment_id = mmasg.assignment_id
2011: and mmasg.mass_move_id = p_mass_move_id

Line 2036: per_mass_moves mm,

2032: from per_mm_assignments mm_asg,
2033: per_assignments_f asg,
2034: per_people_f per,
2035: per_organization_units org,
2036: per_mass_moves mm,
2037: per_organization_units neworg
2038: where mm_asg.position_id = p_old_position_id
2039: and mm_asg.assignment_id = asg.assignment_id
2040: and mm_asg.mass_move_id = p_mass_move_id

Line 2494: cursor csr_lock_per_mass_moves is

2490: cursor csr_batch_run_number is
2491: select hr_api_batch_message_lines_s.nextval
2492: from dual;
2493: --
2494: cursor csr_lock_per_mass_moves is
2495: select null
2496: from per_mass_moves
2497: where mass_move_id = p_mass_move_id
2498: for update nowait;

Line 2496: from per_mass_moves

2492: from dual;
2493: --
2494: cursor csr_lock_per_mass_moves is
2495: select null
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

Line 2527: from per_mass_moves

2523: --
2524: cursor csr_get_mass_move_info is
2525: select new_organization_id,
2526: effective_date
2527: from per_mass_moves
2528: where mass_move_id = p_mass_move_id;
2529: --
2530: cursor csr_get_org_defaults is
2531: select business_group_id,

Line 2713: open csr_lock_per_mass_moves;

2709: savepoint massmove;
2710: --
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;

Line 2714: close csr_lock_per_mass_moves;

2710: --
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;

Line 3145: update per_mass_moves

3141: hr_utility.set_location(l_proc, 270);
3142: --
3143: rollback to massmove;
3144: --
3145: update per_mass_moves
3146: set batch_run_number = l_batch_run_number,
3147: status = 'ER'
3148: where mass_move_id = p_mass_move_id;
3149: --

Line 3154: update per_mass_moves

3150: elsif l_warnings_exist = 'Y' then
3151: --
3152: hr_utility.set_location(l_proc, 280);
3153: --
3154: update per_mass_moves
3155: set batch_run_number = l_batch_run_number,
3156: status = 'WA'
3157: where mass_move_id = p_mass_move_id;
3158: --

Line 3163: update per_mass_moves

3159: else
3160: --
3161: hr_utility.set_location(l_proc, 290);
3162: --
3163: update per_mass_moves
3164: set batch_run_number = l_batch_run_number,
3165: status = 'CO'
3166: where mass_move_id = p_mass_move_id;
3167: --

Line 3228: update per_mass_moves

3224: ,p_extended_error_message => fnd_message.get
3225: ,p_source_row_information => l_position_name
3226: ,p_line_id => l_dummy_line_id);
3227: --
3228: update per_mass_moves
3229: set batch_run_number = l_batch_run_number,
3230: status = 'ER'
3231: where mass_move_id = p_mass_move_id;
3232: --