1: Package hxc_time_entry_rules_utils_pkg as
2: /* $Header: hxcterutl.pkh 120.5 2006/12/08 09:16:38 sgadipal noship $ */
3: --
4: -- Package Variables
5: --
2: /* $Header: hxcterutl.pkh 120.5 2006/12/08 09:16:38 sgadipal noship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' hxc_time_entry_rules_utils_pkg.';
7: --
8:
9: CURSOR csr_get_rules ( p_terg_id VARCHAR2
10: , p_start_date DATE
31: , dar.attribute15
32: , ff.formula_name
33: , terc.attribute1 rule_outcome
34: FROM ff_formulas_f ff
35: , hxc_time_entry_rules dar
36: , hxc_time_entry_rule_comps_v terc
37: WHERE
38: terc.time_entry_rule_group_id = TO_NUMBER(p_terg_id)
39: AND
87: , deleted varchar2(1) );
88:
89: -- record for TER information
90:
91: TYPE r_ter_record IS RECORD ( ter_name hxc_time_entry_rules.name%TYPE,
92: ter_message_name hxc_time_entry_rules.description%TYPE,
93: ter_usage hxc_time_entry_rules.rule_usage%TYPE,
94: ter_formula_name ff_formulas_f.formula_name%TYPE,
95: ter_inc_pto_plan_id pay_accrual_plans.accrual_plan_id%TYPE );
88:
89: -- record for TER information
90:
91: TYPE r_ter_record IS RECORD ( ter_name hxc_time_entry_rules.name%TYPE,
92: ter_message_name hxc_time_entry_rules.description%TYPE,
93: ter_usage hxc_time_entry_rules.rule_usage%TYPE,
94: ter_formula_name ff_formulas_f.formula_name%TYPE,
95: ter_inc_pto_plan_id pay_accrual_plans.accrual_plan_id%TYPE );
96: g_ter_record r_ter_record;
89: -- record for TER information
90:
91: TYPE r_ter_record IS RECORD ( ter_name hxc_time_entry_rules.name%TYPE,
92: ter_message_name hxc_time_entry_rules.description%TYPE,
93: ter_usage hxc_time_entry_rules.rule_usage%TYPE,
94: ter_formula_name ff_formulas_f.formula_name%TYPE,
95: ter_inc_pto_plan_id pay_accrual_plans.accrual_plan_id%TYPE );
96: g_ter_record r_ter_record;
97:
534: function check_valid_calc_date_accrual(
535: p_resource_id NUMBER
536: , p_calculate_date DATE) return varchar2;
537:
538: end hxc_time_entry_rules_utils_pkg;
539:
540: