APPS.PER_MM_VALID_GRADES_PKG dependencies on PER_MM_VALID_GRADES

Line 1: package body PER_MM_VALID_GRADES_PKG as

1: package body PER_MM_VALID_GRADES_PKG as
2: /* $Header: pemmv04t.pkb 120.1 2008/07/18 07:20:02 brsinha ship $ */
3: --
4: --
5: procedure insert_row

Line 35: per_mm_valid_grades

31: is
32: cursor c is
33: select 'x'
34: from
35: per_mm_valid_grades
36: where mass_move_id = p_mass_move_id;
37: l_dummy varchar(1);
38:
39: begin

Line 40: insert into per_mm_valid_grades

36: where mass_move_id = p_mass_move_id;
37: l_dummy varchar(1);
38:
39: begin
40: insert into per_mm_valid_grades
41: (mass_move_id,
42: position_id,
43: target_grade_id,
44: attribute_category,

Line 125: update per_mm_valid_grades

121: p_attribute20 in varchar2,
122: p_row_id in varchar2)
123: is
124: begin
125: update per_mm_valid_grades
126: set
127: target_grade_id = p_target_grade_id,
128: attribute1 = p_attribute1,
129: attribute2 = p_attribute2,

Line 160: delete from per_mm_valid_grades

156: (p_row_id in varchar2)
157:
158: is
159: begin
160: delete from per_mm_valid_grades
161: where rowid = p_row_id;
162: if (sql%notfound) then
163: raise no_data_found;
164: end if;

Line 180: insert into per_mm_valid_grades

176: select effective_date into l_effective_date
177: from per_mass_moves where mass_move_id = p_mass_move_id;
178: -- added for 7214283
179:
180: insert into per_mm_valid_grades
181: (MASS_MOVE_ID,
182: position_id,
183: TARGET_GRADE_ID,
184: ATTRIBUTE_CATEGORY,

Line 247: hr_utility.set_message_token('PROCEDURE','per_mm_valid_grades_pkg.load_rows');

243: when others THEN
244: hr_utility.set_location('Inside Others ',40);
245: hr_utility.set_location(sqlerrm,50);
246: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
247: hr_utility.set_message_token('PROCEDURE','per_mm_valid_grades_pkg.load_rows');
248: hr_utility.set_message_token('STEP','1');
249: hr_utility.raise_error;
250: end load_rows;
251: --

Line 284: from per_mm_valid_grades

280: is
281: counter number;
282: cursor c is
283: select *
284: from per_mm_valid_grades
285: where rowid = p_row_id
286: for update of target_grade_id nowait;
287: recinfo c%rowtype;
288: begin

Line 298: hr_utility.set_message_token('PROCEDURE','per_mm_valid_grades_pkg.lock_rows');

294: fetch c into recinfo;
295: if (c%notfound) then
296: close c;
297: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
298: hr_utility.set_message_token('PROCEDURE','per_mm_valid_grades_pkg.lock_rows');
299: hr_utility.set_message_token('STEP','1');
300: hr_utility.raise_error;
301: end if;
302: close c;

Line 393: hr_utility.set_message_token('PROCEDURE','per_mm_valid_grades_pkg.lock_rows');

389: ) then
390: return;
391: else
392: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
393: hr_utility.set_message_token('PROCEDURE','per_mm_valid_grades_pkg.lock_rows');
394: hr_utility.set_message_token('STEP','2');
395: hr_utility.raise_error;
396: end if;
397: exception

Line 400: hr_utility.set_message_token('PROCEDURE','per_mm_valid_grades_pkg.lock_rows');

396: end if;
397: exception
398: when app_exceptions.record_lock_exception then
399: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
400: hr_utility.set_message_token('PROCEDURE','per_mm_valid_grades_pkg.lock_rows');
401: hr_utility.set_message_token('STEP','3');
402: hr_utility.raise_error;
403: end;
404: end loop;

Line 408: end per_mm_valid_grades_pkg;

404: end loop;
405: end lock_row ;
406: --
407: --
408: end per_mm_valid_grades_pkg;
409: