APPS.PER_MASS_MOVES_PKG dependencies on PER_MASS_MOVES

Line 1: package body PER_MASS_MOVES_PKG as

1: package body PER_MASS_MOVES_PKG as
2: /* $Header: pemmv01t.pkb 115.0 99/07/18 14:02:06 porting ship $ */
3: --
4: --
5: procedure insert_row

Line 20: select per_mass_moves_s.nextval

16: l_mass_move_id number(15);
17: l_row_id varchar2(18) ;
18:
19: cursor c1 is
20: select per_mass_moves_s.nextval
21: from sys.dual;
22:
23: cursor c is
24: select rowid

Line 25: from per_mass_moves

21: from sys.dual;
22:
23: cursor c is
24: select rowid
25: from per_mass_moves
26: where mass_move_id = l_mass_move_id;
27:
28: begin
29: open c1;

Line 34: hr_utility.set_message_token('PROCEDURE','per_mass_moves_pkg.insert_rows');

30: fetch c1 into l_mass_move_id;
31: if (C1%NOTFOUND) then
32: CLOSE C1;
33: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
34: hr_utility.set_message_token('PROCEDURE','per_mass_moves_pkg.insert_rows');
35: hr_utility.set_message_token('STEP','1');
36: end if;
37: close c1;
38:

Line 40: insert into per_mass_moves

36: end if;
37: close c1;
38:
39:
40: insert into per_mass_moves
41: (mass_move_id,
42: business_group_id,
43: effective_date,
44: new_organization_id,

Line 61: hr_utility.set_message_token('PROCEDURE','per_mass_moves_pkg.insert_rows');

57: fetch c into l_row_id;
58: if (c%notfound) then
59: close c;
60: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
61: hr_utility.set_message_token('PROCEDURE','per_mass_moves_pkg.insert_rows');
62: hr_utility.set_message_token('STEP','2');
63: end if;
64: close c;
65: p_mass_move_id := l_mass_move_id;

Line 84: update per_mass_moves

80: p_row_id in varchar2)
81: is
82:
83: begin
84: update per_mass_moves
85: set effective_date = p_effective_date,
86: new_organization_id = p_new_organization_id,
87: old_organization_id = p_source_organization_id,
88: reason = p_reason

Line 102: delete from per_mass_moves

98: p_row_id in varchar2)
99: is
100:
101: begin
102: delete from per_mass_moves
103: where rowid = p_row_id;
104: if sql%notfound then
105: raise no_data_found;
106: end if;

Line 124: from per_mass_moves

120:
121: counter number;
122: cursor c is
123: select *
124: from per_mass_moves
125: where mass_move_id = p_mass_move_id
126: for update of status nowait;
127: recinfo c%rowtype;
128:

Line 139: hr_utility.set_message_token('PROCEDURE','per_mass_moves_pkg.lock_rows');

135: fetch c into recinfo;
136: if (c%notfound) then
137: close c;
138: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
139: hr_utility.set_message_token('PROCEDURE','per_mass_moves_pkg.lock_rows');
140: hr_utility.set_message_token('STEP','1');
141: hr_utility.raise_error;
142: end if;
143: close c;

Line 166: hr_utility.set_message_token('PROCEDURE','per_mass_moves_pkg.lock_rows');

162: ) then
163: return;
164: else
165: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
166: hr_utility.set_message_token('PROCEDURE','per_mass_moves_pkg.lock_rows');
167: hr_utility.set_message_token('STEP','2');
168: hr_utility.raise_error;
169: end if;
170: exception

Line 173: hr_utility.set_message_token('PROCEDURE','per_mass_moves_pkg.lock_rows');

169: end if;
170: exception
171: when app_exceptions.record_lock_exception then
172: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
173: hr_utility.set_message_token('PROCEDURE','per_mass_moves_pkg.lock_rows');
174: hr_utility.set_message_token('STEP','3');
175: hr_utility.raise_error;
176: end;
177: end loop;

Line 180: end per_mass_moves_pkg ;

176: end;
177: end loop;
178: end lock_row ;
179:
180: end per_mass_moves_pkg ;
181: