[Home] [Help]
311: (p_string IN VARCHAR2
312: ,p_value_index IN NUMBER
313: ) RETURN VARCHAR2 IS
314:
315: l_value HXC_TIME_BUILDING_BLOCKS.COMMENT_TEXT%TYPE;
316: l_proc VARCHAR2(30) := 'GET_VALUE_FROM_STRING';
317: BEGIN
318:
319: IF (INSTR(p_string,g_separator,1,p_value_index+1) = 0) THEN
904: l_pref_end_date DATE := null;
905:
906: cursor c_start_time(p_id in number) is
907: select start_time,stop_time
908: from hxc_time_building_blocks
909: where time_building_block_id = p_id
910: and date_to = hr_general.end_of_time;
911:
912: l_pref_table HXC_PREFERENCE_EVALUATION.T_PREF_TABLE;
1121: l_bad BOOLEAN :=FALSE;
1122:
1123: l_count NUMBER;
1124: l_position NUMBER;
1125: l_result hxc_time_building_blocks.comment_text%TYPE;
1126: l_block_table t_simple_table;
1127:
1128: BEGIN
1129:
1385: l_bad BOOLEAN :=FALSE;
1386:
1387: l_count NUMBER;
1388: l_position NUMBER;
1389: l_result hxc_time_building_blocks.comment_text%TYPE;
1390: l_attr_table t_simple_table;
1391:
1392: BEGIN
1393:
1509: l_bad BOOLEAN :=FALSE;
1510:
1511: l_count NUMBER;
1512: l_position NUMBER;
1513: l_result hxc_time_building_blocks.comment_text%TYPE;
1514: l_attr_table t_simple_table;
1515:
1516: BEGIN
1517:
2157:
2158: l_index_start NUMBER;
2159: l_index_next NUMBER;
2160: l_loop_count NUMBER;
2161: l_result hxc_time_building_blocks.comment_text%TYPE;
2162:
2163:
2164: begin
2165:
3176:
3177: cursor c_max_ovn
3178: (p_tbb_id in number) is
3179: select max(object_version_number)
3180: from hxc_time_building_blocks
3181: where time_building_block_id = p_tbb_id;
3182:
3183: cursor c_tx_id
3184: (p_tbb_id in number,
3585: -- Added a new procedure which would replace the resource_id in case of
3586: -- duplication of public templates.
3587:
3588: procedure replace_resource_id (p_blocks IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE,
3589: p_resource_id IN hxc_time_building_blocks.resource_id%type) is
3590: l_block_index number;
3591: begin
3592:
3593: if (p_blocks.count>0) then