APPS.HXC_TIME_ENTRY_RULES_UTILS_PKG dependencies on HXC_TIME_ENTRY_RULES

Line 1: Package hxc_time_entry_rules_utils_pkg AUTHID CURRENT_USER as

1: Package hxc_time_entry_rules_utils_pkg AUTHID CURRENT_USER as
2: /* $Header: hxcterutl.pkh 120.5 2006/12/08 09:16:38 sgadipal noship $ */
3: --
4: -- Package Variables
5: --

Line 6: g_package varchar2(33) := ' hxc_time_entry_rules_utils_pkg.';

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

Line 35: , hxc_time_entry_rules dar

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

Line 91: TYPE r_ter_record IS RECORD ( ter_name hxc_time_entry_rules.name%TYPE,

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 );

Line 92: ter_message_name hxc_time_entry_rules.description%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;

Line 93: ter_usage hxc_time_entry_rules.rule_usage%TYPE,

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:

Line 538: end hxc_time_entry_rules_utils_pkg;

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: