APPS.OTA_THG_SHD dependencies on OTA_HR_GL_FLEX_MAPS

Line 24: ElsIf (p_constraint_name = 'OTA_HR_GL_FLEX_MAPS_PK') Then

20: --
21: If (p_constraint_name = 'OTA_GL_HR_FLEX_MAPS_FK1') Then
22: fnd_message.set_name('OTA','OTA_13217_THG_NO_TCC');
23: fnd_message.raise_error;
24: ElsIf (p_constraint_name = 'OTA_HR_GL_FLEX_MAPS_PK') Then
25: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
26: fnd_message.set_token('PROCEDURE', l_proc);
27: fnd_message.set_token('STEP','10');
28: fnd_message.raise_error;

Line 29: ElsIf (p_constraint_name = 'OTA_HR_GL_FLEX_MAPS_UK1') Then

25: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
26: fnd_message.set_token('PROCEDURE', l_proc);
27: fnd_message.set_token('STEP','10');
28: fnd_message.raise_error;
29: ElsIf (p_constraint_name = 'OTA_HR_GL_FLEX_MAPS_UK1') Then
30: fnd_message.set_name('OTA','OTA_13396_THG_DUPLICATE');
31: fnd_message.raise_error;
32: Else
33: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');

Line 63: from ota_hr_gl_flex_maps

59: ,hr_data_source
60: ,constant
61: ,hr_cost_segment
62: ,object_version_number
63: from ota_hr_gl_flex_maps
64: where gl_default_segment_id = p_gl_default_segment_id;
65: --
66: l_fct_ret boolean;
67: --

Line 136: from ota_hr_gl_flex_maps

132: ,hr_data_source
133: ,constant
134: ,hr_cost_segment
135: ,object_version_number
136: from ota_hr_gl_flex_maps
137: where gl_default_segment_id = p_gl_default_segment_id
138: for update nowait;
139: --
140: l_proc varchar2(72) := g_package||'lck';

Line 179: fnd_message.set_token('TABLE_NAME', 'ota_hr_gl_flex_maps');

175: -- The object is locked therefore we need to supply a meaningful
176: -- error message.
177: --
178: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
179: fnd_message.set_token('TABLE_NAME', 'ota_hr_gl_flex_maps');
180: fnd_message.raise_error;
181: End lck;
182: --
183: -- ----------------------------------------------------------------------------