APPS.HXC_TIME_CATEGORY_UTILS_PKG dependencies on HXC_TMP_ATTS

Line 823: l_sql LONG := 'select distinct ta.bb_id from hxc_tmp_atts ta where ';

819:
820:
821: PROCEDURE validate_time_category_sql ( p_sql_string IN LONG ) IS
822:
823: l_sql LONG := 'select distinct ta.bb_id from hxc_tmp_atts ta where ';
824:
825: t_bb_id dbms_sql.Number_Table;
826:
827: l_csr INTEGER;

Line 852: INSERT INTO hxc_tmp_atts (

848: -- the SQL MUST returns rows to show all possible errors
849: -- particularly implicit character to number and vice
850: -- versa
851:
852: INSERT INTO hxc_tmp_atts (
853: ta_id
854: , bb_id
855: , attribute1
856: , attribute2

Line 925: l_sql := 'select distinct ta.bb_id from hxc_tmp_atts ta where '||l_parse_time_sql;

921: , 'Dummy' );
922:
923: l_parse_time_sql := parse_time_sql_to_bind(p_sql_string);
924:
925: l_sql := 'select distinct ta.bb_id from hxc_tmp_atts ta where '||l_parse_time_sql;
926:
927: BEGIN
928: l_rows_fetched := 100;
929:

Line 1892: INSERT INTO hxc_tmp_atts (

1888: -- attribute insert
1889:
1890: FORALL attx IN 1 .. x
1891:
1892: INSERT INTO hxc_tmp_atts (
1893: ta_id
1894: , bb_id
1895: , attribute1
1896: , attribute2

Line 2028: from hxc_tmp_atts;

2024: from hxc_tmp_blks;
2025:
2026: CURSOR gaz_att IS
2027: SELECT *
2028: from hxc_tmp_atts;
2029:
2030: l_blk gaz_blk%ROWTYPE;
2031: l_att gaz_att%ROWTYPE;
2032:

Line 2127: l_trunc_atts VARCHAR2(30) := 'delete from hxc_tmp_atts';

2123: l_start_time DATE;
2124: l_stop_time DATE;
2125:
2126: l_trunc_blks VARCHAR2(30) := 'delete from hxc_tmp_blks';
2127: l_trunc_atts VARCHAR2(30) := 'delete from hxc_tmp_atts';
2128:
2129: BEGIN
2130:
2131: g_debug := hr_utility.debug_enabled;

Line 2346: FROM hxc_tmp_atts ta

2342:
2343:
2344: l_select VARCHAR2(75) := '
2345: SELECT DISTINCT ta.bb_id
2346: FROM hxc_tmp_atts ta
2347: WHERE ';
2348:
2349: l_live_detail VARCHAR2(300) := '
2350: SELECT DISTINCT tau.time_building_block_id bb_id