APPS.PQH_CPD_SHD dependencies on PQH_CORPS_DEFINITIONS

Line 33: If (p_constraint_name = 'PQH_CORPS_DEFINITIONS_PK') Then

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

Line 116: from pqh_corps_definitions

112: ,starting_grade_id
113: ,ben_pgm_id
114: ,probation_period
115: ,probation_units
116: from pqh_corps_definitions
117: where corps_definition_id = p_corps_definition_id;
118: --
119: l_fct_ret boolean;
120: --

Line 236: from pqh_corps_definitions

232: ,starting_grade_id
233: ,ben_pgm_id
234: ,probation_period
235: ,probation_units
236: from pqh_corps_definitions
237: where corps_definition_id = p_corps_definition_id
238: for update nowait;
239: --
240: l_proc varchar2(72) ;

Line 293: fnd_message.set_token('TABLE_NAME', 'pqh_corps_definitions');

289: -- The object is locked therefore we need to supply a meaningful
290: -- error message.
291: --
292: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
293: fnd_message.set_token('TABLE_NAME', 'pqh_corps_definitions');
294: fnd_message.raise_error;
295: End lck;
296: --
297: -- ----------------------------------------------------------------------------