APPS.HXC_TIME_CATEGORY_UTILS_PKG dependencies on HXC_TIME_CATEGORY_COMPS

Line 23: TYPE rec_time_category_component IS RECORD ( type hxc_time_category_comps.type%TYPE

19: TYPE tab_time_category_cache IS TABLE OF rec_time_category_cache INDEX BY BINARY_INTEGER;
20:
21: g_tc_cache tab_time_category_cache;
22:
23: TYPE rec_time_category_component IS RECORD ( type hxc_time_category_comps.type%TYPE
24: , ref_tc_id hxc_time_category_comps.time_category_id%TYPE
25: , sql_string CLOB );
26:
27: TYPE tab_time_category_component IS TABLE OF rec_time_category_component INDEX BY BINARY_INTEGER;

Line 24: , ref_tc_id hxc_time_category_comps.time_category_id%TYPE

20:
21: g_tc_cache tab_time_category_cache;
22:
23: TYPE rec_time_category_component IS RECORD ( type hxc_time_category_comps.type%TYPE
24: , ref_tc_id hxc_time_category_comps.time_category_id%TYPE
25: , sql_string CLOB );
26:
27: TYPE tab_time_category_component IS TABLE OF rec_time_category_component INDEX BY BINARY_INTEGER;
28:

Line 106: , hxc_time_category_comps tcc

102: , tcc.equal_to
103: FROM
104: hxc_bld_blk_info_types bbit
105: , hxc_mapping_components mpc
106: , hxc_time_category_comps tcc
107: WHERE tcc.time_category_id = p_time_category_id AND
108: tcc.type = 'MC'
109: AND
110: mpc.mapping_component_id (+) = tcc.component_type_id

Line 189: from hxc_time_category_comps tcc

185: , htc.operator
186: FROM hxc_time_categories htc
187: WHERE htc.time_category_id = p_time_category_id
188: AND EXISTS ( select 'x'
189: from hxc_time_category_comps tcc
190: where tcc.time_category_id = htc.time_category_id );
191:
192: l_comps_r csr_get_category_comps%ROWTYPE;
193: l_alternate_name_comps_r csr_get_alternate_name_comps%ROWTYPE;

Line 370: UPDATE hxc_time_category_comps tcc

366: update_time_category_comp_sql ( p_rec => l_rec );
367:
368: -- touch tcc row
369:
370: UPDATE hxc_time_category_comps tcc
371: SET time_category_comp_id = l_rec.time_category_comp_id
372: WHERE time_category_comp_id = l_rec.time_category_comp_id;
373:
374: OPEN csr_get_new_sql_string ( l_rec.time_category_comp_id );

Line 3250: , hxc_time_category_comps tcc

3246: FROM
3247: hxc_time_category_comp_sql tccs
3248: , hxc_bld_blk_info_types bbit
3249: , hxc_mapping_components mpc
3250: , hxc_time_category_comps tcc
3251: WHERE tcc.time_category_id = p_time_category_id AND
3252: tcc.type <> 'MC'
3253: AND
3254: mpc.mapping_component_id (+) = tcc.component_type_id

Line 4539: -- used in the hxc_time_category_comps_v view.

4535: -- get_flex_value
4536: --
4537: -- description
4538: -- retrieves the value based on the id and flex value set id
4539: -- used in the hxc_time_category_comps_v view.
4540:
4541: FUNCTION get_flex_value ( p_flex_value_set_id NUMBER
4542: , p_id VARCHAR2 ) RETURN VARCHAR2 IS
4543:

Line 5269: , hxc_time_category_comps tcc

5265: , tcc.equal_to
5266: , tcc.type
5267: , tcc.object_version_number
5268: FROM hxc_time_categories htc
5269: , hxc_time_category_comps tcc
5270: WHERE tcc.time_category_id = htc.time_category_id
5271: AND tcc.type = 'AN'
5272: AND tcc.component_type_id = p_alias_value_id
5273: ORDER BY htc.time_category_id;

Line 5338: , hxc_time_category_comps tcc

5334:
5335: CURSOR csr_get_time_category IS
5336: SELECT htc.time_category_name
5337: FROM hxc_time_categories htc
5338: , hxc_time_category_comps tcc
5339: , hxc_alias_values av
5340: , hxc_alias_definitions ad
5341: WHERE
5342: ad.alias_definition_id = p_alias_definition_id

Line 5405: FROM hxc_time_category_comps tcc

5401: , tcc.is_null
5402: , tcc.equal_to
5403: , tcc.type
5404: , tcc.object_version_number
5405: FROM hxc_time_category_comps tcc
5406: , hxc_alias_values av
5407: , hxc_alias_definitions ad
5408: , hxc_alias_types hat
5409: WHERE