APPS.OTA_TSP_SHD dependencies on OTA_SKILL_PROVISIONS

Line 36: If (p_constraint_name = 'OTA_SKILL_PROVISIONS_PK') Then

32: --
33: Begin
34: hr_utility.set_location('Entering:'||l_proc, 5);
35: --
36: If (p_constraint_name = 'OTA_SKILL_PROVISIONS_PK') Then
37: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
38: hr_utility.set_message_token('PROCEDURE', l_proc);
39: hr_utility.set_message_token('STEP','5');
40: hr_utility.raise_error;

Line 97: from ota_skill_provisions

93: tsp_information18,
94: tsp_information19,
95: tsp_information20,
96: analysis_criteria_id
97: from ota_skill_provisions
98: where skill_provision_id = p_skill_provision_id;
99: --
100: l_proc varchar2(72) := g_package||'api_updating';
101: l_fct_ret boolean;

Line 193: from ota_skill_provisions

189: tsp_information18,
190: tsp_information19,
191: tsp_information20,
192: analysis_criteria_id
193: from ota_skill_provisions
194: where skill_provision_id = p_skill_provision_id
195: for update nowait;
196: --
197: l_proc varchar2(72) := g_package||'lck';

Line 236: hr_utility.set_message_token('TABLE_NAME', 'ota_skill_provisions');

232: -- The object is locked therefore we need to supply a meaningful
233: -- error message.
234: --
235: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
236: hr_utility.set_message_token('TABLE_NAME', 'ota_skill_provisions');
237: hr_utility.raise_error;
238: End lck;
239: --
240: -- ----------------------------------------------------------------------------

Line 363: from ota_skill_provisions

359: tsp_information18,
360: tsp_information19,
361: tsp_information20,
362: analysis_criteria_id
363: from ota_skill_provisions
364: where activity_version_id = p_activity_version_from;
365: --
366: Begin
367: --