APPS.OTA_FRM_SHD dependencies on OTA_FORUMS_B

Line 21: If (p_constraint_name = 'OTA_FORUMS_B_PK') Then

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

Line 64: from ota_forums_b

60: ,allow_attachment_flag
61: ,auto_notification_flag
62: ,public_flag
63: ,object_version_number
64: from ota_forums_b
65: where forum_id = p_forum_id;
66: --
67: l_fct_ret boolean;
68: --

Line 139: from ota_forums_b

135: ,allow_attachment_flag
136: ,auto_notification_flag
137: ,public_flag
138: ,object_version_number
139: from ota_forums_b
140: where forum_id = p_forum_id
141: for update nowait;
142: --
143: l_proc varchar2(72) := g_package||'lck';

Line 188: fnd_message.set_token('TABLE_NAME', 'ota_forums_b');

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