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 2769: PROCEDURE value_set_string ( p_rec hxc_tcc_shd.g_rec_type

2765: -- p_rec - Time Category Component record
2766: -- p_vs_sql - dynamic sql string
2767:
2768:
2769: PROCEDURE value_set_string ( p_rec hxc_tcc_shd.g_rec_type
2770: , p_vs_sql IN OUT NOCOPY LONG ) IS
2771:
2772: CURSOR csr_get_mpc_info ( p_mapping_component_id NUMBER ) IS
2773: SELECT

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

4021: END chk_tc_bb_ok;
4022:
4023:
4024:
4025: PROCEDURE insert_time_category_comp_sql ( p_rec hxc_tcc_shd.g_rec_type ) IS
4026:
4027: l_proc VARCHAR2(72);
4028:
4029: l_sql VARCHAR2(32000);

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

4085:
4086: END insert_time_category_comp_sql;
4087:
4088:
4089: PROCEDURE update_time_category_comp_sql ( p_rec hxc_tcc_shd.g_rec_type ) IS
4090:
4091: l_proc VARCHAR2(72);
4092:
4093: l_sql VARCHAR2(32000);

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

4183:
4184: END update_time_category_comp_sql;
4185:
4186:
4187: PROCEDURE delete_time_category_comp_sql ( p_rec hxc_tcc_shd.g_rec_type ) IS
4188:
4189: l_proc VARCHAR2(72);
4190:
4191: BEGIN

Line 5277: l_rec hxc_tcc_shd.g_rec_type;

5273: ORDER BY htc.time_category_id;
5274:
5275: l_time_category_name hxc_time_categories.time_category_name%TYPE;
5276:
5277: l_rec hxc_tcc_shd.g_rec_type;
5278:
5279: BEGIN
5280:
5281: FOR tc IN csr_get_time_category

Line 5419: l_rec hxc_tcc_shd.g_rec_type;

5415: AND
5416: tcc.component_type_id = av.alias_value_id AND
5417: tcc.type = 'AN';
5418:
5419: l_rec hxc_tcc_shd.g_rec_type;
5420:
5421: BEGIN
5422:
5423: g_debug := hr_utility.debug_enabled;