APPS.OTA_FOI_SHD dependencies on OTA_FRM_OBJ_INCLUSIONS

Line 26: ElsIf (p_constraint_name = 'OTA_FRM_OBJ_INCLUSIONS_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;
26: ElsIf (p_constraint_name = 'OTA_FRM_OBJ_INCLUSIONS_PK') Then
27: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
28: fnd_message.set_token('PROCEDURE', l_proc);
29: fnd_message.set_token('STEP','10');
30: fnd_message.raise_error;

Line 63: from ota_frm_obj_inclusions

59: ,start_date_active
60: ,end_date_active
61: ,primary_flag
62: ,object_version_number
63: from ota_frm_obj_inclusions
64: where forum_id = p_forum_id
65: and object_id = p_object_id
66: and object_type = p_object_type;
67: --

Line 145: from ota_frm_obj_inclusions

141: ,start_date_active
142: ,end_date_active
143: ,primary_flag
144: ,object_version_number
145: from ota_frm_obj_inclusions
146: where forum_id = p_forum_id
147: and object_id = p_object_id
148: and object_type = p_object_type
149: for update nowait;

Line 208: fnd_message.set_token('TABLE_NAME', 'ota_frm_obj_inclusions');

204: -- The object is locked therefore we need to supply a meaningful
205: -- error message.
206: --
207: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
208: fnd_message.set_token('TABLE_NAME', 'ota_frm_obj_inclusions');
209: fnd_message.raise_error;
210: End lck;
211: --
212: -- ----------------------------------------------------------------------------