APPS.HXC_TIME_CATEGORY_UTILS_PKG dependencies on HXC_TIME_CATEGORY_COMPS2

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: