APPS.HXC_TIME_CATEGORY_HOOK dependencies on HXC_TIME_CATEGORIES

Line 20: hxc_time_categories tc

16: tc.time_category_name
17: , tc.time_category_id
18: , tc.object_version_number
19: FROM
20: hxc_time_categories tc
21: WHERE
22: tc.time_Category_name like p_tc_name;
23:
24: CURSOR csr_get_accrual_plan_name ( p_pap_id NUMBER) IS

Line 68: FROM hxc_time_categories tc

64: AND tcc.value_id = TO_CHAR(p_element_type_id);
65:
66: CURSOR csr_chk_tc_comps ( p_tc_id NUMBER ) IS
67: SELECT 'x'
68: FROM hxc_time_categories tc
69: WHERE tc.time_category_id = p_tc_id
70: AND EXISTS ( select 'x'
71: FROM hxc_time_category_comps tcc
72: WHERe tcc.time_category_id = tc.time_category_id );

Line 81: l_dec_tc_name hxc_time_categories.time_category_name%TYPE;

77: WHERE accrual_plan_id = p_pap_id
78: AND add_or_subtract = 1;
79:
80: l_accrual_info csr_get_elements%ROWTYPE;
81: l_dec_tc_name hxc_time_categories.time_category_name%TYPE;
82: l_inc_tc_name hxc_time_categories.time_category_name%TYPE;
83: l_tc_name hxc_time_categories.time_category_name%TYPE;
84:
85: l_dec_tc_id hxc_time_categories.time_category_id%TYPE;

Line 82: l_inc_tc_name hxc_time_categories.time_category_name%TYPE;

78: AND add_or_subtract = 1;
79:
80: l_accrual_info csr_get_elements%ROWTYPE;
81: l_dec_tc_name hxc_time_categories.time_category_name%TYPE;
82: l_inc_tc_name hxc_time_categories.time_category_name%TYPE;
83: l_tc_name hxc_time_categories.time_category_name%TYPE;
84:
85: l_dec_tc_id hxc_time_categories.time_category_id%TYPE;
86: l_dec_tc_ovn hxc_time_categories.object_version_number%TYPE;

Line 83: l_tc_name hxc_time_categories.time_category_name%TYPE;

79:
80: l_accrual_info csr_get_elements%ROWTYPE;
81: l_dec_tc_name hxc_time_categories.time_category_name%TYPE;
82: l_inc_tc_name hxc_time_categories.time_category_name%TYPE;
83: l_tc_name hxc_time_categories.time_category_name%TYPE;
84:
85: l_dec_tc_id hxc_time_categories.time_category_id%TYPE;
86: l_dec_tc_ovn hxc_time_categories.object_version_number%TYPE;
87: l_inc_tc_id hxc_time_categories.time_category_id%TYPE;

Line 85: l_dec_tc_id hxc_time_categories.time_category_id%TYPE;

81: l_dec_tc_name hxc_time_categories.time_category_name%TYPE;
82: l_inc_tc_name hxc_time_categories.time_category_name%TYPE;
83: l_tc_name hxc_time_categories.time_category_name%TYPE;
84:
85: l_dec_tc_id hxc_time_categories.time_category_id%TYPE;
86: l_dec_tc_ovn hxc_time_categories.object_version_number%TYPE;
87: l_inc_tc_id hxc_time_categories.time_category_id%TYPE;
88: l_inc_tc_ovn hxc_time_categories.object_version_number%TYPE;
89:

Line 86: l_dec_tc_ovn hxc_time_categories.object_version_number%TYPE;

82: l_inc_tc_name hxc_time_categories.time_category_name%TYPE;
83: l_tc_name hxc_time_categories.time_category_name%TYPE;
84:
85: l_dec_tc_id hxc_time_categories.time_category_id%TYPE;
86: l_dec_tc_ovn hxc_time_categories.object_version_number%TYPE;
87: l_inc_tc_id hxc_time_categories.time_category_id%TYPE;
88: l_inc_tc_ovn hxc_time_categories.object_version_number%TYPE;
89:
90: l_tcc_id hxc_time_category_comps.time_category_comp_id%TYPE;

Line 87: l_inc_tc_id hxc_time_categories.time_category_id%TYPE;

83: l_tc_name hxc_time_categories.time_category_name%TYPE;
84:
85: l_dec_tc_id hxc_time_categories.time_category_id%TYPE;
86: l_dec_tc_ovn hxc_time_categories.object_version_number%TYPE;
87: l_inc_tc_id hxc_time_categories.time_category_id%TYPE;
88: l_inc_tc_ovn hxc_time_categories.object_version_number%TYPE;
89:
90: l_tcc_id hxc_time_category_comps.time_category_comp_id%TYPE;
91: l_tcc_ovn hxc_time_category_comps.object_version_number%TYPE;

Line 88: l_inc_tc_ovn hxc_time_categories.object_version_number%TYPE;

84:
85: l_dec_tc_id hxc_time_categories.time_category_id%TYPE;
86: l_dec_tc_ovn hxc_time_categories.object_version_number%TYPE;
87: l_inc_tc_id hxc_time_categories.time_category_id%TYPE;
88: l_inc_tc_ovn hxc_time_categories.object_version_number%TYPE;
89:
90: l_tcc_id hxc_time_category_comps.time_category_comp_id%TYPE;
91: l_tcc_ovn hxc_time_category_comps.object_version_number%TYPE;
92: l_mpc_id hxc_mapping_components.mapping_component_id%TYPE;