APPS.PAY_ELEMENT_TEMPLATE_UTIL dependencies on PAY_ELEMENT_TEMPLATES

Line 17: select template_type from pay_element_templates pet

13: -- |------------------------< get_template_type >-----------------|
14: -- -----------------------------------------------------------------------
15: function get_template_type(p_template_id in number) return varchar2 is
16: cursor get_template_type is
17: select template_type from pay_element_templates pet
18: where pet.template_id = p_template_id;
19: --
20: l_template_type varchar2(2000);
21: begin

Line 250: from pay_element_templates

246: configuration_information28,
247: configuration_information29,
248: configuration_information30,
249: object_version_number
250: from pay_element_templates
251: where template_id = p_template_id
252: for update of template_id;
253: --
254: begin

Line 2494: -- Create row in pay_element_templates. --

2490: i number;
2491: begin
2492: hr_utility.set_location('Entering:'|| l_proc, 10);
2493: ------------------------------------------
2494: -- Create row in pay_element_templates. --
2495: ------------------------------------------
2496: p_element_template.template_id := null;
2497: p_element_template.object_version_number := null;
2498: pay_etm_ins.ins(p_effective_date, p_element_template);

Line 3466: -- pay_element_templates --

3462: ----------------------------------
3463: delete from pay_template_exclusion_rules
3464: where template_id = p_template_id;
3465: ---------------------------
3466: -- pay_element_templates --
3467: ---------------------------
3468: delete from pay_element_templates
3469: where template_id = p_template_id;
3470: --

Line 3468: delete from pay_element_templates

3464: where template_id = p_template_id;
3465: ---------------------------
3466: -- pay_element_templates --
3467: ---------------------------
3468: delete from pay_element_templates
3469: where template_id = p_template_id;
3470: --
3471: hr_utility.set_location('Leaving:'|| l_proc, 200);
3472: end delete_template;