APPS.HXC_TIME_CATEGORY_UTILS_PKG dependencies on HXC_TIME_CATEGORY_COMP_SQL

Line 180: FROM hxc_time_category_comp_sql

176:
177:
178: CURSOR csr_chk_tcc_sql_exists ( p_tcc_id NUMBER ) IS
179: SELECT time_category_comp_sql_id tcc_sql_id
180: FROM hxc_time_category_comp_sql
181: WHERE time_category_comp_id = p_tcc_id;
182:
183: CURSOR csr_get_time_category ( p_time_category_id NUMBER ) IS
184: SELECT htc.time_sql

Line 218: FROM hxc_time_category_comp_sql

214: l_start_index PLS_INTEGER;
215:
216: CURSOR csr_get_new_sql_string ( p_tcc_id NUMBER ) IS
217: SELECT sql_string
218: FROM hxc_time_category_comp_sql
219: WHERE time_category_comp_id = p_tcc_id;
220:
221: -- private function to check if the value set has been
222: -- changed since the TCC row was updated

Line 3247: hxc_time_category_comp_sql tccs

3243: , tcc.equal_to
3244: , tccs.sql_string
3245: , tcc.last_update_date
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

Line 4073: INSERT INTO hxc_time_category_comp_sql (

4069: END IF;
4070:
4071: validate_time_category_sql ( l_sql );
4072:
4073: INSERT INTO hxc_time_category_comp_sql (
4074: time_category_comp_sql_id
4075: , time_category_comp_id
4076: , sql_string )
4077: VALUES (

Line 4078: hxc_time_category_comp_sql_s.nextval

4074: time_category_comp_sql_id
4075: , time_category_comp_id
4076: , sql_string )
4077: VALUES (
4078: hxc_time_category_comp_sql_s.nextval
4079: , p_rec.time_category_comp_id
4080: , l_sql );
4081:
4082: IF ( g_debug ) THEN

Line 4149: UPDATE hxc_time_category_comp_sql

4145: END IF;
4146:
4147: validate_time_category_sql ( l_sql );
4148:
4149: UPDATE hxc_time_category_comp_sql
4150: SET sql_string = l_sql
4151: WHERE time_category_comp_id = p_rec.time_category_comp_id;
4152:
4153: ELSE

Line 4158: DELETE from hxc_time_category_comp_sql

4154:
4155: -- rows exists but TCC row no longer of type which uses
4156: -- TCC SQL therefore delete redundant row
4157:
4158: DELETE from hxc_time_category_comp_sql
4159: WHERE time_category_comp_sql_id = l_tcc_sql.tcc_sql_id;
4160:
4161: END IF; -- IF ( p_rec.type IN ( 'MC_VS', 'AN' )
4162:

Line 4206: DELETE from hxc_time_category_comp_sql

4202:
4203: FOR tcc_sql IN csr_chk_tcc_sql_exists ( p_rec.time_category_comp_id )
4204: LOOP
4205:
4206: DELETE from hxc_time_category_comp_sql
4207: WHERE time_category_comp_sql_id = tcc_sql.tcc_sql_id;
4208:
4209: END LOOP;
4210: