eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 3367: , hxc_time_category_comps tcc

3363: FROM
3364: hxc_time_category_comp_sql tccs
3365: , hxc_bld_blk_info_types bbit
3366: , hxc_mapping_components mpc
3367: , hxc_time_category_comps tcc
3368: WHERE tcc.time_category_id = p_time_category_id AND
3369: tcc.type <> 'MC'
3370: AND
3371: mpc.mapping_component_id (+) = tcc.component_type_id

Line 4656: -- used in the hxc_time_category_comps_v view.

4652: -- get_flex_value
4653: --
4654: -- description
4655: -- retrieves the value based on the id and flex value set id
4656: -- used in the hxc_time_category_comps_v view.
4657:
4658: FUNCTION get_flex_value ( p_flex_value_set_id NUMBER
4659: , p_id VARCHAR2 ) RETURN VARCHAR2 IS
4660:

Line 5386: , hxc_time_category_comps tcc

5382: , tcc.equal_to
5383: , tcc.type
5384: , tcc.object_version_number
5385: FROM hxc_time_categories htc
5386: , hxc_time_category_comps tcc
5387: WHERE tcc.time_category_id = htc.time_category_id
5388: AND tcc.type = 'AN'
5389: AND tcc.component_type_id = p_alias_value_id
5390: ORDER BY htc.time_category_id;

Line 5455: , hxc_time_category_comps tcc

5451:
5452: CURSOR csr_get_time_category IS
5453: SELECT htc.time_category_name
5454: FROM hxc_time_categories htc
5455: , hxc_time_category_comps tcc
5456: , hxc_alias_values av
5457: , hxc_alias_definitions ad
5458: WHERE
5459: ad.alias_definition_id = p_alias_definition_id

Line 5522: FROM hxc_time_category_comps tcc

5518: , tcc.is_null
5519: , tcc.equal_to
5520: , tcc.type
5521: , tcc.object_version_number
5522: FROM hxc_time_category_comps tcc
5523: , hxc_alias_values av
5524: , hxc_alias_definitions ad
5525: , hxc_alias_types hat
5526: WHERE

Line 5668: 'UPDATE hxc_time_category_comps2

5664: AND hmc.bld_blk_info_type_id = bbit.bld_blk_info_type_id
5665: ORDER BY hmc.segment ;
5666:
5667: l_sql VARCHAR2(4000) :=
5668: 'UPDATE hxc_time_category_comps2
5669: SET COLUMN = :1,
5670: bld_blk_info_type_id = :2,
5671: attribute_category = :3
5672: WHERE rowid = :4 ';

Line 5676: 'UPDATE hxc_time_category_comps2

5672: WHERE rowid = :4 ';
5673:
5674:
5675: l_dummy_sql VARCHAR2(4000) :=
5676: 'UPDATE hxc_time_category_comps2
5677: SET attribute_category = :1,
5678: bld_blk_info_type_id = :2
5679: WHERE rowid = :3';
5680:

Line 5688: DELETE FROM hxc_time_category_comps2

5684:
5685: BEGIN
5686:
5687: -- Delete if the component exists already.
5688: DELETE FROM hxc_time_category_comps2
5689: WHERE time_category_id = p_tc_id
5690: AND time_category_comp_id = p_tcc_id;
5691:
5692:

Line 5708: INSERT INTO hxc_time_category_comps2

5704: -- htcc2.atttribute1 = hta.attribute1
5705: -- uses an INDEX on the column if available.
5706: --
5707:
5708: INSERT INTO hxc_time_category_comps2
5709: (time_category_id,
5710: time_category_comp_id,
5711: ATTRIBUTE1,
5712: ATTRIBUTE2,

Line 5852: -- Procedure deletes any entry in hxc_time_category_comps2 for this component.

5848: END IF;
5849:
5850: END insert_tc_comps2;
5851:
5852: -- Procedure deletes any entry in hxc_time_category_comps2 for this component.
5853:
5854: PROCEDURE delete_tc_comps2(p_tcc_id IN NUMBER)
5855: IS
5856:

Line 5858: DELETE FROM hxc_time_category_comps2

5854: PROCEDURE delete_tc_comps2(p_tcc_id IN NUMBER)
5855: IS
5856:
5857: BEGIN
5858: DELETE FROM hxc_time_category_comps2
5859: WHERE time_category_comp_id = p_tcc_id;
5860:
5861: END delete_tc_comps2;
5862: