APPS.HR_MASS_MOVE_API dependencies on PER_MASS_MOVES

Line 2009: per_mass_moves mm,

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

Line 2038: per_mass_moves mm,

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

Line 2496: cursor csr_lock_per_mass_moves is

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

Line 2498: from per_mass_moves

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

Line 2529: from per_mass_moves

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

Line 2715: open csr_lock_per_mass_moves;

2711: savepoint massmove;
2712: --
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;

Line 2716: close csr_lock_per_mass_moves;

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

Line 3153: update per_mass_moves

3149: hr_utility.set_location(l_proc, 270);
3150: --
3151: rollback to massmove;
3152: --
3153: update per_mass_moves
3154: set batch_run_number = l_batch_run_number,
3155: status = 'ER'
3156: where mass_move_id = p_mass_move_id;
3157: --

Line 3162: update per_mass_moves

3158: elsif l_warnings_exist = 'Y' then
3159: --
3160: hr_utility.set_location(l_proc, 280);
3161: --
3162: update per_mass_moves
3163: set batch_run_number = l_batch_run_number,
3164: status = 'WA'
3165: where mass_move_id = p_mass_move_id;
3166: --

Line 3171: update per_mass_moves

3167: else
3168: --
3169: hr_utility.set_location(l_proc, 290);
3170: --
3171: update per_mass_moves
3172: set batch_run_number = l_batch_run_number,
3173: status = 'CO'
3174: where mass_move_id = p_mass_move_id;
3175: --

Line 3236: update per_mass_moves

3232: ,p_extended_error_message => fnd_message.get
3233: ,p_source_row_information => l_position_name
3234: ,p_line_id => l_dummy_line_id);
3235: --
3236: update per_mass_moves
3237: set batch_run_number = l_batch_run_number,
3238: status = 'ER'
3239: where mass_move_id = p_mass_move_id;
3240: --