APPS.HXC_LOAD_PKG dependencies on HXC_TIME_CATEGORIES

Line 955: FROM hxc_time_categories

951: procedure set_dynamic_sql_string ( p_time_category_id NUMBER ) IS
952:
953: CURSOR csr_get_operator ( p_time_category_id NUMBER ) IS
954: SELECT operator
955: FROM hxc_time_categories
956: WHERE time_category_id = p_time_category_id;
957:
958:
959: CURSOR csr_get_category_comps ( p_time_category_id NUMBER ) IS

Line 981: l_time_category_id hxc_time_Categories.time_category_id%TYPE;

977: bbit.bld_blk_info_type_id (+) = mpc.bld_blk_info_type_id;
978:
979:
980: l_time_sql CLOB; -- Bug 15977687
981: l_time_category_id hxc_time_Categories.time_category_id%TYPE;
982: l_operator hxc_time_categories.operator%TYPE;
983:
984: l_last_update_date DATE;
985: l_first_time_round BOOLEAN;

Line 982: l_operator hxc_time_categories.operator%TYPE;

978:
979:
980: l_time_sql CLOB; -- Bug 15977687
981: l_time_category_id hxc_time_Categories.time_category_id%TYPE;
982: l_operator hxc_time_categories.operator%TYPE;
983:
984: l_last_update_date DATE;
985: l_first_time_round BOOLEAN;
986: l_comps_r csr_get_category_comps%ROWTYPE;

Line 1507: UPDATE hxc_time_categories

1503: if g_debug then
1504: hr_utility.trace('set dyn sql string string is '||l_time_sql);
1505: end if;
1506:
1507: UPDATE hxc_time_categories
1508: SET time_sql = l_time_sql
1509: WHERE time_category_id = p_time_category_id;
1510:
1511: exception when others then