APPS.PER_MM_ASSIGNMENTS_PKG dependencies on PER_MM_ASSIGNMENTS

Line 1: package body PER_MM_ASSIGNMENTS_PKG as

1: package body PER_MM_ASSIGNMENTS_PKG as
2: /* $Header: pemmv03t.pkb 120.1 2005/11/07 02:39:04 pchowdav noship $ */
3: --
4: --
5: procedure update_row

Line 14: update per_mm_assignments

10: p_row_id in varchar2)
11:
12: is
13: begin
14: update per_mm_assignments
15: set default_from = p_default_from,
16: select_assignment = p_select_assignment,
17: grade_id = p_grade_id,
18: tax_unit_id = p_tax_unit_id

Line 51: insert into per_mm_assignments

47:
48: if nvl(l_rule_mode,'N') = 'Y'
49: then
50: -- fix for bug 4704865 ends here.
51: insert into per_mm_assignments
52: (MASS_MOVE_ID,
53: ASSIGNMENT_ID,
54: OBJECT_VERSION_NUMBER,
55: POSITION_ID,

Line 94: insert into per_mm_assignments

90: and asg.assignment_type in ('E','A','C');
91:
92: -- fix for bug 4704865 starts here.
93: else
94: insert into per_mm_assignments
95: (MASS_MOVE_ID,
96: ASSIGNMENT_ID,
97: OBJECT_VERSION_NUMBER,
98: POSITION_ID,

Line 139: hr_utility.set_message_token('PROCEDURE','per_mm_assignments_pkg.load_rows');

135: when no_data_found then
136: null;
137: when others then
138: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
139: hr_utility.set_message_token('PROCEDURE','per_mm_assignments_pkg.load_rows');
140: hr_utility.set_message_token('STEP','1');
141: hr_utility.raise_error;
142:
143: end load_rows;

Line 160: from per_mm_assignments

156: is
157: counter number;
158: cursor c is
159: select *
160: from per_mm_assignments
161: where rowid = p_row_id
162: for update of select_assignment nowait;
163: recinfo c%rowtype;
164: begin

Line 234: l_tax_unit_name per_mm_assignments_v.tax_unit_name%type;

230:
231: -- 4385302 starts here
232: -- previously defined local var has been commented and newly defined
233: --l_tax_unit_name varchar(30);
234: l_tax_unit_name per_mm_assignments_v.tax_unit_name%type;
235: -- 4385302 ends here
236:
237: cursor c is
238: select grade_id,

Line 242: from per_mm_assignments_v

238: select grade_id,
239: grade_name,
240: tax_unit_id,
241: tax_unit_name
242: from per_mm_assignments_v
243: where mass_move_id = p_mass_move_id
244: and assignment_id = p_assignment_id;
245:
246: begin

Line 270: end per_mm_assignments_pkg;

266:
267: end restore_defaults;
268: --
269: --
270: end per_mm_assignments_pkg;