APPS.PQP_SHP_SHD dependencies on PQP_SERVICE_HISTORY_PERIODS

Line 32: If (p_constraint_name = 'PQP_SERVICE_HISTORY_PERIODS_PK') Then

28: l_proc varchar2(72) := g_package||'constraint_error';
29: --
30: Begin
31: --
32: If (p_constraint_name = 'PQP_SERVICE_HISTORY_PERIODS_PK') Then
33: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
34: fnd_message.set_token('PROCEDURE', l_proc);
35: fnd_message.set_token('STEP','5');
36: fnd_message.raise_error;

Line 117: from pqp_service_history_periods

113: ,shp_information17
114: ,shp_information18
115: ,shp_information19
116: ,shp_information20
117: from pqp_service_history_periods
118: where service_history_period_id = p_service_history_period_id;
119: --
120: l_fct_ret boolean;
121: --

Line 239: from pqp_service_history_periods

235: ,shp_information17
236: ,shp_information18
237: ,shp_information19
238: ,shp_information20
239: from pqp_service_history_periods
240: where service_history_period_id = p_service_history_period_id
241: for update nowait;
242: --
243: l_proc varchar2(72) := g_package||'lck';

Line 282: fnd_message.set_token('TABLE_NAME', 'pqp_service_history_periods');

278: -- The object is locked therefore we need to supply a meaningful
279: -- error message.
280: --
281: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
282: fnd_message.set_token('TABLE_NAME', 'pqp_service_history_periods');
283: fnd_message.raise_error;
284: End lck;
285: --
286: -- ----------------------------------------------------------------------------