APPS.PQH_RMV_SHD dependencies on PQH_RT_MATRIX_NODE_VALUES

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

17: l_proc varchar2(72) := g_package||'constraint_error';
18: --
19: Begin
20: --
21: If (p_constraint_name = 'PQH_RT_MATRIX_NODE_VALUES_UK1') 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 26: ElsIf (p_constraint_name = 'pqh_rt_matrix_node_values_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;
26: ElsIf (p_constraint_name = 'pqh_rt_matrix_node_values_pk') Then
27: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
28: fnd_message.set_token('PROCEDURE', l_proc);
29: fnd_message.set_token('STEP','10');
30: fnd_message.raise_error;

Line 72: from pqh_rt_matrix_node_values

68: ,date_value4
69: ,business_group_id
70: ,legislation_code
71: ,object_version_number
72: from pqh_rt_matrix_node_values
73: where node_value_id = p_node_value_id;
74: --
75: l_fct_ret boolean;
76: --

Line 155: from pqh_rt_matrix_node_values

151: ,date_value4
152: ,business_group_id
153: ,legislation_code
154: ,object_version_number
155: from pqh_rt_matrix_node_values
156: where node_value_id = p_node_value_id
157: for update nowait;
158: --
159: l_proc varchar2(72) := g_package||'lck';

Line 204: fnd_message.set_token('TABLE_NAME', 'pqh_rt_matrix_node_values');

200: -- The object is locked therefore we need to supply a meaningful
201: -- error message.
202: --
203: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
204: fnd_message.set_token('TABLE_NAME', 'pqh_rt_matrix_node_values');
205: fnd_message.raise_error;
206: End lck;
207: --
208: -- ----------------------------------------------------------------------------