APPS.HXC_HAN_SHD dependencies on HXC_APP_COMP_NOTIFICATIONS

Line 22: If (p_constraint_name = 'HXC_APP_COMP_NOTIFICATIONS_PK') Then

18: l_proc varchar2(72) := g_package||'constraint_error';
19: --
20: Begin
21: --
22: If (p_constraint_name = 'HXC_APP_COMP_NOTIFICATIONS_PK') Then
23: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
24: fnd_message.set_token('PROCEDURE', l_proc);
25: fnd_message.set_token('STEP','5');
26: fnd_message.raise_error;

Line 56: from hxc_app_comp_notifications

52: ,notification_number_retries
53: ,notification_timeout_value
54: ,notification_action_code
55: ,notification_recipient_code
56: from hxc_app_comp_notifications
57: where comp_notification_id = p_comp_notification_id
58: and object_version_number = p_object_version_number;
59: --
60: l_fct_ret boolean;

Line 128: from hxc_app_comp_notifications

124: ,notification_number_retries
125: ,notification_timeout_value
126: ,notification_action_code
127: ,notification_recipient_code
128: from hxc_app_comp_notifications
129: where comp_notification_id = p_comp_notification_id
130: and object_version_number = p_object_version_number
131: for update nowait;
132: --

Line 185: fnd_message.set_token('TABLE_NAME', 'hxc_app_comp_notifications');

181: -- The object is locked therefore we need to supply a meaningful
182: -- error message.
183: --
184: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
185: fnd_message.set_token('TABLE_NAME', 'hxc_app_comp_notifications');
186: fnd_message.raise_error;
187: End lck;
188: --
189: -- ----------------------------------------------------------------------------