32: --
33: Begin
34: hr_utility.set_location('Entering:'||l_proc, 5);
35: --
36: If (p_constraint_name = 'PQP_ANALYZED_ALIEN_DATA_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;
82: citizenship_country_code,
83: object_version_number ,
84: date_8233_signed,
85: date_w4_signed
86: from pqp_analyzed_alien_data
87: where analyzed_data_id = p_analyzed_data_id;
88: --
89: l_proc varchar2(72) := g_package||'api_updating';
90: l_fct_ret boolean;
172: citizenship_country_code,
173: object_version_number ,
174: date_8233_signed,
175: date_w4_signed
176: from pqp_analyzed_alien_data
177: where analyzed_data_id = p_analyzed_data_id
178: for update nowait;
179: --
180: l_proc varchar2(72) := g_package||'lck';
215: -- The object is locked therefore we need to supply a meaningful
216: -- error message.
217: --
218: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
219: hr_utility.set_message_token('TABLE_NAME', 'pqp_analyzed_alien_data');
220: hr_utility.raise_error;
221: End lck;
222: --
223: -- ----------------------------------------------------------------------------