APPS.PQH_RNK_SHD dependencies on PQH_RANK_PROCESSES

Line 21: If (p_constraint_name = 'PQH_RANK_PROCESSES_PK') Then

17: l_proc constant varchar2(72) := g_package||'constraint_error';
18: --
19: Begin
20: --
21: If (p_constraint_name = 'PQH_RANK_PROCESSES_PK') Then
22: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
23: fnd_message.set_token('PROCEDURE', l_proc);
24: fnd_message.set_token('STEP','5');
25: fnd_message.raise_error;

Line 63: from pqh_rank_processes

59: ,object_version_number
60: ,request_id
61: ,business_group_id
62: ,per_in_ler_id
63: from pqh_rank_processes
64: where rank_process_id = p_rank_process_id;
65: --
66: l_fct_ret boolean;
67: --

Line 142: from pqh_rank_processes

138: ,object_version_number
139: ,request_id
140: ,business_group_id
141: ,per_in_ler_id
142: from pqh_rank_processes
143: where rank_process_id = p_rank_process_id
144: for update nowait;
145: --
146: l_proc constant varchar2(72) := g_package||'lck';

Line 191: fnd_message.set_token('TABLE_NAME', 'pqh_rank_processes');

187: -- The object is locked therefore we need to supply a meaningful
188: -- error message.
189: --
190: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
191: fnd_message.set_token('TABLE_NAME', 'pqh_rank_processes');
192: fnd_message.raise_error;
193: End lck;
194: --
195: -- ----------------------------------------------------------------------------