APPS.PQP_GB_PENSIONS_TEMPLATE dependencies on PQP_GB_PENSIONS_TEMPLATE

Line 1: PACKAGE BODY pqp_gb_pensions_template AS

1: PACKAGE BODY pqp_gb_pensions_template AS
2: /* $Header: pqgbpatp.pkb 120.1 2005/05/30 00:12:07 rvishwan noship $ */
3:
4: /*========================================================================
5: * CREATE_USER_TEMPLATE

Line 70: 'pqp_gb_pensions_template.create_user_template';

66: l_base_element_type_id pay_template_core_objects.core_object_id%TYPE;
67: l_source_template_id pay_element_templates.template_id%TYPE;
68: l_object_version_number NUMBER(9);
69: l_proc VARCHAR2(80) :=
70: 'pqp_gb_pensions_template.create_user_template';
71: l_flat_rate VARCHAR2(3);
72: l_per_contribution VARCHAR2(3);
73: l_adl_contribution VARCHAR2(3);
74: l_eer_contribution VARCHAR2(3);

Line 147: l_proc varchar2(60) := 'pqp_gb_pensions_template.get_template_id';

143: RETURN number IS
144: --
145: -- l_template_id NUMBER(9);
146: l_template_name VARCHAR2(80);
147: l_proc varchar2(60) := 'pqp_gb_pensions_template.get_template_id';
148: --
149: CURSOR c4 is
150: SELECT template_id
151: FROM pay_element_templates

Line 309: l_proc varchar2(60) := 'pqp_gb_pensions_template.get_object_id';

305: p_object_name in varchar2)
306: RETURN NUMBER is
307: --
308: l_object_id NUMBER := NULL;
309: l_proc varchar2(60) := 'pqp_gb_pensions_template.get_object_id';
310: --
311: CURSOR c2 (c_object_name varchar2) is
312: SELECT element_type_id
313: FROM pay_element_types_f

Line 712: l_proc varchar2(60) :='pqp_gb_pensions_template.delete_user_template';

708: ,p_effective_date in date
709: ) IS
710: --
711: l_template_id NUMBER(9);
712: l_proc varchar2(60) :='pqp_gb_pensions_template.delete_user_template';
713: l_eei_info_id number;
714: l_ovn_eei number;
715: --
716: CURSOR eei is

Line 763: END pqp_gb_pensions_template;

759: hr_utility.set_location('Leaving :'||l_proc, 50);
760: --
761: END delete_user_template;
762: --
763: END pqp_gb_pensions_template;
764: