APPS.PQH_OPS_SHD dependencies on PQH_DE_WRKPLC_VLDTN_OPS

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

17: l_proc varchar2(72) := g_package||'constraint_error';
18: --
19: Begin
20: --
21: If (p_constraint_name = 'PQH_DE_WRKPLC_VLDTN_OPS_FK') 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_DE_WRKPLC_VLDTN_OPS_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_DE_WRKPLC_VLDTN_OPS_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 61: from pqh_de_wrkplc_vldtn_ops

57: ,business_group_id
58: ,description
59: ,unit_percentage
60: ,object_version_number
61: from pqh_de_wrkplc_vldtn_ops
62: where wrkplc_vldtn_op_id = p_wrkplc_vldtn_op_id;
63: --
64: l_fct_ret boolean;
65: --

Line 133: from pqh_de_wrkplc_vldtn_ops

129: ,business_group_id
130: ,description
131: ,unit_percentage
132: ,object_version_number
133: from pqh_de_wrkplc_vldtn_ops
134: where wrkplc_vldtn_op_id = p_wrkplc_vldtn_op_id
135: for update nowait;
136: --
137: l_proc varchar2(72) := g_package||'lck';

Line 182: fnd_message.set_token('TABLE_NAME', 'pqh_de_wrkplc_vldtn_ops');

178: -- The object is locked therefore we need to supply a meaningful
179: -- error message.
180: --
181: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
182: fnd_message.set_token('TABLE_NAME', 'pqh_de_wrkplc_vldtn_ops');
183: fnd_message.raise_error;
184: End lck;
185: --
186: -- ----------------------------------------------------------------------------