[Home] [Help]
1: PACKAGE BODY pqp_gb_professional_body_temp AS
2: /* $Header: pqgbpbtp.pkb 115.3 2003/10/01 09:01:00 bsamuel noship $ */
3:
4: /*========================================================================
5: * CREATE_USER_TEMPLATE
44: l_base_element_type_id pay_template_core_objects.core_object_id%TYPE;
45: l_source_template_id pay_element_templates.template_id%TYPE;
46: l_object_version_number NUMBER(9);
47: l_proc VARCHAR2(80) :=
48: 'pqp_gb_professional_body_temp.create_user_template';
49: l_override_amount VARCHAR2(1);
50: l_eei_info_id NUMBER;
51: l_ovn_eei NUMBER;
52: l_element_type_id NUMBER;
147: RETURN number IS
148: --
149: -- l_template_id NUMBER(9);
150: l_template_name VARCHAR2(80);
151: l_proc varchar2(60) := 'pqp_gb_professional_body_temp.get_template_id';
152: --
153: CURSOR csr_get_temp_id is
154: SELECT template_id
155: FROM pay_element_templates
198: OR
199: (business_group_id is null and legislation_code = 'GB'));
200:
201: l_bd_baldmn_id pay_balance_dimensions.balance_dimension_id%TYPE;
202: l_proc varchar2(80) := 'pqp_gb_professional_body_temp.get_balance_dimension_id';
203:
204: BEGIN
205:
206: hr_utility.set_location('Entering: '||l_proc, 10);
227: ,p_shadow_id in number default null)
228: RETURN NUMBER is
229: --
230: l_object_id NUMBER := NULL;
231: l_proc varchar2(60) := 'pqp_gb_professional_body_temp.get_object_id';
232: --
233: CURSOR csr_get_ele_type_id (c_object_name varchar2) is
234: SELECT element_type_id
235: FROM pay_element_types_f
631: ,p_effective_date in date
632: ) IS
633: --
634: l_template_id NUMBER(9);
635: l_proc varchar2(60) :='pqp_gb_professional_body_temp.delete_user_template';
636: l_eei_info_id number;
637: l_ovn_eei number;
638: l_del_pbd_level_balance_yn varchar2(1) := 'Y';
639: --
811: hr_utility.set_location('Leaving :'||l_proc, 100);
812: --
813: END delete_user_template;
814: --
815: END pqp_gb_professional_body_temp;
816: