APPS.PER_ASG_UPD dependencies on PER_ALL_ASSIGNMENTS_F

Line 80: (p_base_table_name => 'per_all_assignments_f',

76: -- version number.
77: --
78: p_rec.object_version_number :=
79: dt_api.get_object_version_number
80: (p_base_table_name => 'per_all_assignments_f',
81: p_base_key_column => 'assignment_id',
82: p_base_key_value => p_rec.assignment_id);
83: --
84: per_asg_shd.g_api_dml := true; -- Set the api dml status

Line 86: -- Update the per_all_assignments_f Row

82: p_base_key_value => p_rec.assignment_id);
83: --
84: per_asg_shd.g_api_dml := true; -- Set the api dml status
85: --
86: -- Update the per_all_assignments_f Row
87: --
88: update per_all_assignments_f
89: set
90: assignment_id = p_rec.assignment_id,

Line 88: update per_all_assignments_f

84: per_asg_shd.g_api_dml := true; -- Set the api dml status
85: --
86: -- Update the per_all_assignments_f Row
87: --
88: update per_all_assignments_f
89: set
90: assignment_id = p_rec.assignment_id,
91: recruiter_id = p_rec.recruiter_id,
92: grade_id = p_rec.grade_id,

Line 203: (p_base_table_name => 'per_all_assignments_f',

199: if nvl(per_asg_shd.g_old_rec.assignment_number, hr_api.g_varchar2) <>
200: nvl(p_rec.assignment_number, hr_api.g_varchar2) then
201: --
202: l_object_version_number := dt_api.get_object_version_number
203: (p_base_table_name => 'per_all_assignments_f',
204: p_base_key_column => 'assignment_id',
205: p_base_key_value => p_rec.assignment_id);
206: --
207: update per_all_assignments_f paaf

Line 207: update per_all_assignments_f paaf

203: (p_base_table_name => 'per_all_assignments_f',
204: p_base_key_column => 'assignment_id',
205: p_base_key_value => p_rec.assignment_id);
206: --
207: update per_all_assignments_f paaf
208: set paaf.assignment_number = p_rec.assignment_number,
209: paaf.object_version_number = l_object_version_number
210: where paaf.assignment_id = p_rec.assignment_id
211: and paaf.person_id = per_asg_shd.g_old_rec.person_id

Line 437: from per_all_assignments_f

433: l_esd date;
434: --
435: Cursor csr_rowid is
436: select rowid, effective_start_date, effective_end_date
437: from per_all_assignments_f
438: where assignment_id = p_rec.assignment_id
439: and p_effective_date between
440: effective_start_date and effective_end_date;
441: --

Line 444: from per_all_assignments_f

440: effective_start_date and effective_end_date;
441: --
442: cursor csr_rowid_u is
443: select rowid
444: from per_all_assignments_f
445: where assignment_id = p_rec.assignment_id
446: and p_effective_date -1 between
447: effective_start_date and effective_end_date;
448: --

Line 456: p_source_table_name => 'PER_ALL_ASSIGNMENTS_F',

452: -- Insert the comment text if comments exist
453: --
454: If (p_rec.comment_text is not null and p_rec.comment_id is null) then
455: hr_comm_api.ins(p_comment_id => p_rec.comment_id,
456: p_source_table_name => 'PER_ALL_ASSIGNMENTS_F',
457: p_comment_text => p_rec.comment_text);
458: -- Update the comments if they have changed
459: ElsIf (p_rec.comment_id is not null and p_rec.comment_text <>
460: per_asg_shd.g_old_rec.comment_text) then

Line 462: p_source_table_name => 'PER_ALL_ASSIGNMENTS_F',

458: -- Update the comments if they have changed
459: ElsIf (p_rec.comment_id is not null and p_rec.comment_text <>
460: per_asg_shd.g_old_rec.comment_text) then
461: hr_comm_api.upd(p_comment_id => p_rec.comment_id,
462: p_source_table_name => 'PER_ALL_ASSIGNMENTS_F',
463: p_comment_text => p_rec.comment_text);
464: End If;
465: hr_utility.set_location(l_proc, 10);
466: --

Line 1048: (p_module_name => 'PER_ALL_ASSIGNMENTS_F'

1044: );
1045: exception
1046: when hr_api.cannot_find_prog_unit then
1047: hr_api.cannot_find_prog_unit_error
1048: (p_module_name => 'PER_ALL_ASSIGNMENTS_F'
1049: ,p_hook_type => 'AU'
1050: );
1051: end;
1052: -- End of API User Hook for post_update.

Line 1940: from per_all_assignments_f

1936: vendor_site_id,
1937: po_header_id,
1938: po_line_id,
1939: projected_assignment_end
1940: from per_all_assignments_f
1941: where assignment_id = p_rec.assignment_id
1942: and p_effective_date between effective_start_date
1943: and effective_end_date;
1944:

Line 1947: from per_all_assignments_f

1943: and effective_end_date;
1944:
1945: cursor c_asg_rowid is
1946: select rowid
1947: from per_all_assignments_f
1948: where assignment_id = p_rec.assignment_id
1949: and p_effective_date between effective_start_date
1950: and effective_end_date;
1951: