DBA Data[Home] [Help]

APPS.IRC_IAD_UPD dependencies on IRC_ASSIGNMENT_DETAILS_F

Line 78: (p_base_table_name => 'irc_assignment_details_f'

74: -- version number.
75: --
76: p_rec.object_version_number :=
77: dt_api.get_object_version_number
78: (p_base_table_name => 'irc_assignment_details_f'
79: ,p_base_key_column => 'assignment_details_id'
80: ,p_base_key_value => p_rec.assignment_details_id
81: );
82: --

Line 85: -- Update the irc_assignment_details_f Row

81: );
82: --
83: --
84: --
85: -- Update the irc_assignment_details_f Row
86: --
87: update irc_assignment_details_f
88: set
89: assignment_details_id = p_rec.assignment_details_id

Line 87: update irc_assignment_details_f

83: --
84: --
85: -- Update the irc_assignment_details_f Row
86: --
87: update irc_assignment_details_f
88: set
89: assignment_details_id = p_rec.assignment_details_id
90: ,assignment_id = p_rec.assignment_id
91: ,details_version = p_rec.details_version

Line 272: (p_base_table_name => 'irc_assignment_details_f'

268: -- Reset the Latest Details flag for the current effective date range rows.
269: hr_utility.set_location(l_proc, 30);
270: p_rec.object_version_number :=
271: dt_api.get_object_version_number
272: (p_base_table_name => 'irc_assignment_details_f'
273: ,p_base_key_column => 'assignment_id'
274: ,p_base_key_value => p_rec.assignment_id
275: );
276: update irc_assignment_details_f

Line 276: update irc_assignment_details_f

272: (p_base_table_name => 'irc_assignment_details_f'
273: ,p_base_key_column => 'assignment_id'
274: ,p_base_key_value => p_rec.assignment_id
275: );
276: update irc_assignment_details_f
277: set latest_details = 'N'
278: ,object_version_number = p_rec.object_version_number
279: where assignment_id = p_rec.assignment_id
280: and latest_details = 'Y'

Line 466: (p_module_name => 'IRC_ASSIGNMENT_DETAILS_F'

462: --
463: when hr_api.cannot_find_prog_unit then
464: --
465: hr_api.cannot_find_prog_unit_error
466: (p_module_name => 'IRC_ASSIGNMENT_DETAILS_F'
467: ,p_hook_type => 'AU');
468: --
469: end;
470: --