APPS.HR_CNP_BUS dependencies on HR_CANVAS_PROPERTIES

Line 62: ,hr_canvas_properties cnp

58: select tmp.legislation_code
59: from hr_form_templates_b tmp
60: ,hr_template_windows_b twn
61: ,hr_template_canvases_b tcn
62: ,hr_canvas_properties cnp
63: where tmp.form_template_id = twn.form_template_id
64: and twn.template_window_id = tcn.template_window_id
65: and tcn.template_canvas_id = cnp.template_canvas_id
66: and cnp.canvas_property_id = p_canvas_property_id;

Line 200: hr_cnp_shd.constraint_error('HR_CANVAS_PROPERTIES_FK1');

196: --
197: -- The form canvas id is invalid therefore we must error
198: --
199: close csr_form_canvas;
200: hr_cnp_shd.constraint_error('HR_CANVAS_PROPERTIES_FK1');
201: end if;
202: hr_utility.set_location(l_proc,30);
203: close csr_form_canvas;
204: --

Line 215: hr_cnp_shd.constraint_error('HR_CANVAS_PROPERTIES_FK2');

211: --
212: -- The template canvas id is invalid therefore we must error
213: --
214: close csr_template_canvas;
215: hr_cnp_shd.constraint_error('HR_CANVAS_PROPERTIES_FK2');
216: end if;
217: hr_utility.set_location(l_proc,40);
218: close csr_template_canvas;
219: --

Line 342: ,p_descflex_name => 'HR_CANVAS_PROPERTIES'

338: -- b) During insert.
339: --
340: hr_dflex_utility.ins_or_upd_descflex_attribs
341: (p_appl_short_name => 'PER'
342: ,p_descflex_name => 'HR_CANVAS_PROPERTIES'
343: ,p_attribute_category => p_rec.information_category
344: ,p_attribute1_name => 'INFORMATION1'
345: ,p_attribute1_value => p_rec.information1
346: ,p_attribute2_name => 'INFORMATION2'