APPS.HXC_TIME_CATEGORY_UTILS_PKG dependencies on HXC_TCC_SHD

Line 210: l_rec hxc_tcc_shd.g_rec_type;

206: l_tc_comp_ind PLS_INTEGER;
207:
208: l_ind PLS_INTEGER;
209:
210: l_rec hxc_tcc_shd.g_rec_type;
211:
212: l_sql_string CLOB;
213:
214: l_start_index PLS_INTEGER;

Line 226: , p_rec IN OUT NOCOPY hxc_tcc_shd.g_rec_type )

222: -- changed since the TCC row was updated
223: -- If so populate and return l_rec
224:
225: FUNCTION value_set_changed ( p_vs_comp_rec r_vs_comp
226: , p_rec IN OUT NOCOPY hxc_tcc_shd.g_rec_type )
227: RETURN BOOLEAN IS
228:
229: CURSOR get_value_set_last_update_date ( p_flex_value_set_id NUMBER ) IS
230: SELECT vs.last_update_date

Line 2794: PROCEDURE value_set_string ( p_rec hxc_tcc_shd.g_rec_type

2790: -- p_rec - Time Category Component record
2791: -- p_vs_sql - dynamic sql string
2792:
2793:
2794: PROCEDURE value_set_string ( p_rec hxc_tcc_shd.g_rec_type
2795: , p_vs_sql IN OUT NOCOPY LONG ) IS
2796:
2797: CURSOR csr_get_mpc_info ( p_mapping_component_id NUMBER ) IS
2798: SELECT

Line 4142: PROCEDURE insert_time_category_comp_sql ( p_rec hxc_tcc_shd.g_rec_type ) IS

4138: END chk_tc_bb_ok;
4139:
4140:
4141:
4142: PROCEDURE insert_time_category_comp_sql ( p_rec hxc_tcc_shd.g_rec_type ) IS
4143:
4144: l_proc VARCHAR2(72);
4145:
4146: l_sql CLOB; -- Bug 15977687

Line 4206: PROCEDURE update_time_category_comp_sql ( p_rec hxc_tcc_shd.g_rec_type ) IS

4202:
4203: END insert_time_category_comp_sql;
4204:
4205:
4206: PROCEDURE update_time_category_comp_sql ( p_rec hxc_tcc_shd.g_rec_type ) IS
4207:
4208: l_proc VARCHAR2(72);
4209:
4210: l_sql CLOB; -- Bug 15977687

Line 4304: PROCEDURE delete_time_category_comp_sql ( p_rec hxc_tcc_shd.g_rec_type ) IS

4300:
4301: END update_time_category_comp_sql;
4302:
4303:
4304: PROCEDURE delete_time_category_comp_sql ( p_rec hxc_tcc_shd.g_rec_type ) IS
4305:
4306: l_proc VARCHAR2(72);
4307:
4308: BEGIN

Line 5394: l_rec hxc_tcc_shd.g_rec_type;

5390: ORDER BY htc.time_category_id;
5391:
5392: l_time_category_name hxc_time_categories.time_category_name%TYPE;
5393:
5394: l_rec hxc_tcc_shd.g_rec_type;
5395:
5396: BEGIN
5397:
5398: FOR tc IN csr_get_time_category

Line 5536: l_rec hxc_tcc_shd.g_rec_type;

5532: AND
5533: tcc.component_type_id = av.alias_value_id AND
5534: tcc.type = 'AN';
5535:
5536: l_rec hxc_tcc_shd.g_rec_type;
5537:
5538: BEGIN
5539:
5540: g_debug := hr_utility.debug_enabled;