APPS.PER_ASG_SHD dependencies on PER_ALL_ASSIGNMENTS_F

Line 177: from per_all_assignments_f

173: vendor_site_id,
174: po_header_id,
175: po_line_id,
176: projected_assignment_end
177: from per_all_assignments_f
178: where assignment_id = p_assignment_id
179: and p_effective_date between effective_start_date
180: and effective_end_date;
181: --

Line 248: from per_all_assignments_f asg

244: --
245: Cursor C_Sel1 Is
246: select asg.payroll_id,
247: asg.person_id
248: from per_all_assignments_f asg
249: where asg.assignment_id = p_base_key_value
250: and p_effective_date between asg.effective_start_date
251: and asg.effective_end_date;
252: --

Line 270: p_base_table_name => 'per_all_assignments_f',

266: -- Call the corresponding datetrack api
267: --
268: dt_api.find_dt_del_modes
269: (p_effective_date => p_effective_date,
270: p_base_table_name => 'per_all_assignments_f',
271: p_base_key_column => 'assignment_id',
272: p_base_key_value => p_base_key_value,
273: p_parent_table_name1 => 'pay_all_payrolls_f', -- bug fix 2679167
274: p_parent_key_column1 => 'payroll_id',

Line 303: p_base_table_name => 'per_all_assignments_f',

299: -- Call the corresponding datetrack api
300: --
301: dt_api.find_dt_upd_modes
302: (p_effective_date => p_effective_date,
303: p_base_table_name => 'per_all_assignments_f',
304: p_base_key_column => 'assignment_id',
305: p_base_key_value => p_base_key_value,
306: p_correction => p_correction,
307: p_update => p_update,

Line 333: (p_base_table_name => 'per_all_assignments_f',

329: -- version number.
330: --
331: l_object_version_number :=
332: dt_api.get_object_version_number
333: (p_base_table_name => 'per_all_assignments_f',
334: p_base_key_column => 'assignment_id',
335: p_base_key_value => p_base_key_value);
336: --
337: g_api_dml := true; -- Set the api dml status

Line 342: update per_all_assignments_f asg

338: --
339: -- Update the specified datetrack row setting the effective
340: -- end date to the specified new effective end date.
341: --
342: update per_all_assignments_f asg
343: set asg.effective_end_date = p_new_effective_end_date,
344: asg.object_version_number = l_object_version_number
345: where asg.assignment_id = p_base_key_value
346: and p_effective_date between asg.effective_start_date

Line 492: from per_all_assignments_f

488: vendor_site_id,
489: po_header_id,
490: po_line_id,
491: projected_assignment_end
492: from per_all_assignments_f
493: where assignment_id = p_assignment_id
494: and p_effective_date between effective_start_date
495: and effective_end_date
496: for update nowait;

Line 595: p_base_table_name => 'per_all_assignments_f',

591:
592: dt_api.validate_dt_mode
593: (p_effective_date => p_effective_date,
594: p_datetrack_mode => p_datetrack_mode,
595: p_base_table_name => 'per_all_assignments_f',
596: p_base_key_column => 'assignment_id',
597: p_base_key_value => p_assignment_id,
598: p_parent_table_name1 => 'per_people_f',
599: p_parent_key_column1 => 'person_id',

Line 650: hr_utility.set_message_token('TABLE_NAME', 'per_all_assignments_f');

646: -- The object is locked therefore we need to supply a meaningful
647: -- error message.
648: --
649: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
650: hr_utility.set_message_token('TABLE_NAME', 'per_all_assignments_f');
651: hr_utility.raise_error;
652: When l_object_invalid then
653: --
654: -- The object doesn't exist or is invalid

Line 657: hr_utility.set_message_token('TABLE_NAME', 'per_all_assignments_f');

653: --
654: -- The object doesn't exist or is invalid
655: --
656: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
657: hr_utility.set_message_token('TABLE_NAME', 'per_all_assignments_f');
658: hr_utility.raise_error;
659: End lck;
660: --
661: -- ----------------------------------------------------------------------------