DBA Data[Home] [Help]

APPS.PQP_EARNINGS_TEMPLATE dependencies on PQP_EARNINGS_TEMPLATE

Line 1: PACKAGE BODY pqp_earnings_template AS

1: PACKAGE BODY pqp_earnings_template AS
2: /* $Header: pqeetdrv.pkb 120.2 2006/08/29 10:50:00 jdevasah noship $ */
3:
4:
5: /*========================================================================

Line 69: l_proc varchar2(80) := 'pqp_earnings_template.create_ele_template_objects';

65: l_source_template_id number;
66: l_supp_bal_id number;
67: l_template_id number;
68: --
69: l_proc varchar2(80) := 'pqp_earnings_template.create_ele_template_objects';
70:
71: l_asg_gre_run_dim_id pay_balance_dimensions.balance_dimension_id%TYPE;
72:
73: --

Line 502: l_proc VARCHAR2(60) := 'pqp_earnings_template.get_obj_id';

498: ,p_object_id in number default NULL )
499: RETURN NUMBER is
500: --
501: l_object_id NUMBER := NULL;
502: l_proc VARCHAR2(60) := 'pqp_earnings_template.get_obj_id';
503: --
504: CURSOR c_element IS -- Gets the element type id
505: SELECT element_type_id
506: FROM pay_element_types_f

Line 557: l_proc VARCHAR2(60):= 'pqp_earnings_template.add_flsa_reduce_reg_feeds';

553: ,p_asf_ele_type_id in number
554: ,p_ele_eff_start_date in date
555: ) IS
556: --
557: l_proc VARCHAR2(60):= 'pqp_earnings_template.add_flsa_reduce_reg_feeds';
558: TYPE TypeIdNumber IS TABLE of NUMBER INDEX BY BINARY_INTEGER;
559: t_bal_id TypeIdNumber;
560: t_ipv_id TypeIdNumber;
561: t_scale TypeIdNumber;

Line 673: l_proc VARCHAR2(60) := 'pqp_earnings_template.delete_ele_template_objects';

669: ) IS
670: --
671: l_template_id NUMBER(9);
672: --
673: l_proc VARCHAR2(60) := 'pqp_earnings_template.delete_ele_template_objects';
674: --
675: CURSOR c1 is
676: SELECT template_id
677: FROM pay_template_core_objects

Line 697: END pqp_earnings_template;

693: hr_utility.set_location('Leaving :'||l_proc, 50);
694: --
695: END delete_ele_template_objects;
696: --
697: END pqp_earnings_template;