APPS.HXC_TIME_CATEGORY_UTILS_PKG dependencies on HXC_TMP_ATTS

Line 839: l_sql CLOB := 'select distinct ta.bb_id from hxc_tmp_atts ta where '; -- Bug 15977687

835:
836:
837: PROCEDURE validate_time_category_sql ( p_sql_string IN CLOB ) IS -- Bug 15977687
838:
839: l_sql CLOB := 'select distinct ta.bb_id from hxc_tmp_atts ta where '; -- Bug 15977687
840:
841: t_bb_id dbms_sql.Number_Table;
842:
843: l_csr INTEGER;

Line 869: INSERT INTO hxc_tmp_atts (

865: -- the SQL MUST returns rows to show all possible errors
866: -- particularly implicit character to number and vice
867: -- versa
868:
869: INSERT INTO hxc_tmp_atts (
870: ta_id
871: , bb_id
872: , attribute1
873: , attribute2

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

938: , 'Dummy' );
939:
940: l_parse_time_sql := parse_time_sql_to_bind(p_sql_string);
941:
942: l_sql := 'select distinct ta.bb_id from hxc_tmp_atts ta where '||l_parse_time_sql;
943:
944: BEGIN
945: l_rows_fetched := 100;
946:

Line 1913: INSERT INTO hxc_tmp_atts (

1909: -- attribute insert
1910:
1911: FORALL attx IN 1 .. x
1912:
1913: INSERT INTO hxc_tmp_atts (
1914: ta_id
1915: , bb_id
1916: , attribute1
1917: , attribute2

Line 2049: from hxc_tmp_atts;

2045: from hxc_tmp_blks;
2046:
2047: CURSOR gaz_att IS
2048: SELECT *
2049: from hxc_tmp_atts;
2050:
2051: l_blk gaz_blk%ROWTYPE;
2052: l_att gaz_att%ROWTYPE;
2053:

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

2144: l_start_time DATE;
2145: l_stop_time DATE;
2146:
2147: l_trunc_blks VARCHAR2(30) := 'delete from hxc_tmp_blks';
2148: l_trunc_atts VARCHAR2(30) := 'delete from hxc_tmp_atts';
2149:
2150: BEGIN
2151:
2152: g_debug := hr_utility.debug_enabled;

Line 2367: FROM hxc_tmp_atts ta

2363:
2364:
2365: l_select VARCHAR2(75) := '
2366: SELECT DISTINCT ta.bb_id
2367: FROM hxc_tmp_atts ta
2368: WHERE ';
2369:
2370: l_live_detail VARCHAR2(300) := '
2371: SELECT DISTINCT tau.time_building_block_id bb_id