APPS.BEN_ASG_UPD dependencies on PER_ALL_ASSIGNMENTS_F

Line 77: (p_base_table_name => 'per_all_assignments_f',

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

Line 83: -- Update the per_all_assignments_f Row

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

Line 85: update per_all_assignments_f

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

Line 407: from per_all_assignments_f

403: l_esd date;
404: --
405: Cursor csr_rowid is
406: select rowid, effective_start_date, effective_end_date
407: from per_all_assignments_f
408: where assignment_id = p_rec.assignment_id
409: and p_effective_date between
410: effective_start_date and effective_end_date;
411: --

Line 414: from per_all_assignments_f

410: effective_start_date and effective_end_date;
411: --
412: cursor csr_rowid_u is
413: select rowid
414: from per_all_assignments_f
415: where assignment_id = p_rec.assignment_id
416: and p_effective_date -1 between
417: effective_start_date and effective_end_date;
418: --

Line 426: p_source_table_name => 'PER_ALL_ASSIGNMENTS_F',

422: -- Insert the comment text if comments exist
423: --
424: If (p_rec.comment_text is not null and p_rec.comment_id is null) then
425: hr_comm_api.ins(p_comment_id => p_rec.comment_id,
426: p_source_table_name => 'PER_ALL_ASSIGNMENTS_F',
427: p_comment_text => p_rec.comment_text);
428: -- Update the comments if they have changed
429: ElsIf (p_rec.comment_id is not null and p_rec.comment_text <>
430: per_asg_shd.g_old_rec.comment_text) then

Line 432: p_source_table_name => 'PER_ALL_ASSIGNMENTS_F',

428: -- Update the comments if they have changed
429: ElsIf (p_rec.comment_id is not null and p_rec.comment_text <>
430: per_asg_shd.g_old_rec.comment_text) then
431: hr_comm_api.upd(p_comment_id => p_rec.comment_id,
432: p_source_table_name => 'PER_ALL_ASSIGNMENTS_F',
433: p_comment_text => p_rec.comment_text);
434: End If;
435: hr_utility.set_location(l_proc, 10);
436: --

Line 936: (p_module_name => 'PER_ALL_ASSIGNMENTS_F'

932: );
933: exception
934: when hr_api.cannot_find_prog_unit then
935: hr_api.cannot_find_prog_unit_error
936: (p_module_name => 'PER_ALL_ASSIGNMENTS_F'
937: ,p_hook_type => 'AU'
938: );
939: end;
940: -- End of API User Hook for post_update.