APPS.PSP_PRT_SHD dependencies on PSP_REPORT_TEMPLATES

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

28: l_proc varchar2(72) := g_package||'constraint_error';
29: --
30: Begin
31: --
32: If (p_constraint_name = 'PSP_REPORT_TEMPLATES_U2') 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 86: from psp_report_templates

82: ,description
83: ,legislation_code
84: ,hundred_pcent_eff_at_per_asg
85: ,selection_match_level
86: from psp_report_templates
87: where template_id = p_template_id;
88: --
89: l_fct_ret boolean;
90: --

Line 172: from psp_report_templates

168: ,description
169: ,legislation_code
170: ,hundred_pcent_eff_at_per_asg
171: ,selection_match_level
172: from psp_report_templates
173: where template_id = p_template_id
174: for update nowait;
175: --
176: l_proc varchar2(72) := g_package||'lck';

Line 221: fnd_message.set_token('TABLE_NAME', 'psp_report_templates');

217: -- The object is locked therefore we need to supply a meaningful
218: -- error message.
219: --
220: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
221: fnd_message.set_token('TABLE_NAME', 'psp_report_templates');
222: fnd_message.raise_error;
223: End lck;
224: --
225: -- ----------------------------------------------------------------------------