2400: := l_new_blocks_array(l_new_block_index).COMMENT_TEXT;
2401: ELSE
2402: l_complete_blocks(l_old_block_index).COMMENT_TEXT
2403: := l_complete_blocks(l_old_block_index).COMMENT_TEXT
2404: || fnd_global.local_chr(10)
2405: || l_new_blocks_array(l_new_block_index).COMMENT_TEXT;
2406: END IF;
2407: END IF;
2408:
2731: hr_utility.trace ('p_template_procedure='||p_template_procedure);
2732: END IF;
2733: hxc_timecard_message_helper.initializeErrors;
2734:
2735: l_dyn_template_sql := 'BEGIN '||fnd_global.newline
2736: ||p_template_procedure ||fnd_global.newline
2737: ||'(p_resource_id => :1' ||fnd_global.newline
2738: ||',p_start_date => :2' ||fnd_global.newline
2739: ||',p_stop_date => :3' ||fnd_global.newline
2732: END IF;
2733: hxc_timecard_message_helper.initializeErrors;
2734:
2735: l_dyn_template_sql := 'BEGIN '||fnd_global.newline
2736: ||p_template_procedure ||fnd_global.newline
2737: ||'(p_resource_id => :1' ||fnd_global.newline
2738: ||',p_start_date => :2' ||fnd_global.newline
2739: ||',p_stop_date => :3' ||fnd_global.newline
2740: ||',p_attributes => :4' ||fnd_global.newline
2733: hxc_timecard_message_helper.initializeErrors;
2734:
2735: l_dyn_template_sql := 'BEGIN '||fnd_global.newline
2736: ||p_template_procedure ||fnd_global.newline
2737: ||'(p_resource_id => :1' ||fnd_global.newline
2738: ||',p_start_date => :2' ||fnd_global.newline
2739: ||',p_stop_date => :3' ||fnd_global.newline
2740: ||',p_attributes => :4' ||fnd_global.newline
2741: ||',p_timecard => :5' ||fnd_global.newline
2734:
2735: l_dyn_template_sql := 'BEGIN '||fnd_global.newline
2736: ||p_template_procedure ||fnd_global.newline
2737: ||'(p_resource_id => :1' ||fnd_global.newline
2738: ||',p_start_date => :2' ||fnd_global.newline
2739: ||',p_stop_date => :3' ||fnd_global.newline
2740: ||',p_attributes => :4' ||fnd_global.newline
2741: ||',p_timecard => :5' ||fnd_global.newline
2742: ||',p_messages => :6);'||fnd_global.newline
2735: l_dyn_template_sql := 'BEGIN '||fnd_global.newline
2736: ||p_template_procedure ||fnd_global.newline
2737: ||'(p_resource_id => :1' ||fnd_global.newline
2738: ||',p_start_date => :2' ||fnd_global.newline
2739: ||',p_stop_date => :3' ||fnd_global.newline
2740: ||',p_attributes => :4' ||fnd_global.newline
2741: ||',p_timecard => :5' ||fnd_global.newline
2742: ||',p_messages => :6);'||fnd_global.newline
2743: ||'END;';
2736: ||p_template_procedure ||fnd_global.newline
2737: ||'(p_resource_id => :1' ||fnd_global.newline
2738: ||',p_start_date => :2' ||fnd_global.newline
2739: ||',p_stop_date => :3' ||fnd_global.newline
2740: ||',p_attributes => :4' ||fnd_global.newline
2741: ||',p_timecard => :5' ||fnd_global.newline
2742: ||',p_messages => :6);'||fnd_global.newline
2743: ||'END;';
2744:
2737: ||'(p_resource_id => :1' ||fnd_global.newline
2738: ||',p_start_date => :2' ||fnd_global.newline
2739: ||',p_stop_date => :3' ||fnd_global.newline
2740: ||',p_attributes => :4' ||fnd_global.newline
2741: ||',p_timecard => :5' ||fnd_global.newline
2742: ||',p_messages => :6);'||fnd_global.newline
2743: ||'END;';
2744:
2745: IF g_debug THEN
2738: ||',p_start_date => :2' ||fnd_global.newline
2739: ||',p_stop_date => :3' ||fnd_global.newline
2740: ||',p_attributes => :4' ||fnd_global.newline
2741: ||',p_timecard => :5' ||fnd_global.newline
2742: ||',p_messages => :6);'||fnd_global.newline
2743: ||'END;';
2744:
2745: IF g_debug THEN
2746: hr_utility.trace ('l_dyn_template_sql='||l_dyn_template_sql);
2961: CLOSE c_dyn_template_procedure;
2962:
2963:
2964: -- call the procedure to get the blocks info
2965: /* l_dyn_template_sql := 'BEGIN '||fnd_global.newline
2966: ||l_template_procedure ||fnd_global.newline
2967: ||'(p_resource_id => :1' ||fnd_global.newline
2968: ||',p_start_date => :2' ||fnd_global.newline
2969: ||',p_stop_date => :3' ||fnd_global.newline
2962:
2963:
2964: -- call the procedure to get the blocks info
2965: /* l_dyn_template_sql := 'BEGIN '||fnd_global.newline
2966: ||l_template_procedure ||fnd_global.newline
2967: ||'(p_resource_id => :1' ||fnd_global.newline
2968: ||',p_start_date => :2' ||fnd_global.newline
2969: ||',p_stop_date => :3' ||fnd_global.newline
2970: ||',p_attributes => :4' ||fnd_global.newline
2963:
2964: -- call the procedure to get the blocks info
2965: /* l_dyn_template_sql := 'BEGIN '||fnd_global.newline
2966: ||l_template_procedure ||fnd_global.newline
2967: ||'(p_resource_id => :1' ||fnd_global.newline
2968: ||',p_start_date => :2' ||fnd_global.newline
2969: ||',p_stop_date => :3' ||fnd_global.newline
2970: ||',p_attributes => :4' ||fnd_global.newline
2971: ||',p_timecard => :5' ||fnd_global.newline
2964: -- call the procedure to get the blocks info
2965: /* l_dyn_template_sql := 'BEGIN '||fnd_global.newline
2966: ||l_template_procedure ||fnd_global.newline
2967: ||'(p_resource_id => :1' ||fnd_global.newline
2968: ||',p_start_date => :2' ||fnd_global.newline
2969: ||',p_stop_date => :3' ||fnd_global.newline
2970: ||',p_attributes => :4' ||fnd_global.newline
2971: ||',p_timecard => :5' ||fnd_global.newline
2972: ||',p_messages => :6);'||fnd_global.newline
2965: /* l_dyn_template_sql := 'BEGIN '||fnd_global.newline
2966: ||l_template_procedure ||fnd_global.newline
2967: ||'(p_resource_id => :1' ||fnd_global.newline
2968: ||',p_start_date => :2' ||fnd_global.newline
2969: ||',p_stop_date => :3' ||fnd_global.newline
2970: ||',p_attributes => :4' ||fnd_global.newline
2971: ||',p_timecard => :5' ||fnd_global.newline
2972: ||',p_messages => :6);'||fnd_global.newline
2973: ||'END;';
2966: ||l_template_procedure ||fnd_global.newline
2967: ||'(p_resource_id => :1' ||fnd_global.newline
2968: ||',p_start_date => :2' ||fnd_global.newline
2969: ||',p_stop_date => :3' ||fnd_global.newline
2970: ||',p_attributes => :4' ||fnd_global.newline
2971: ||',p_timecard => :5' ||fnd_global.newline
2972: ||',p_messages => :6);'||fnd_global.newline
2973: ||'END;';
2974:
2967: ||'(p_resource_id => :1' ||fnd_global.newline
2968: ||',p_start_date => :2' ||fnd_global.newline
2969: ||',p_stop_date => :3' ||fnd_global.newline
2970: ||',p_attributes => :4' ||fnd_global.newline
2971: ||',p_timecard => :5' ||fnd_global.newline
2972: ||',p_messages => :6);'||fnd_global.newline
2973: ||'END;';
2974:
2975: EXECUTE IMMEDIATE l_dyn_template_sql
2968: ||',p_start_date => :2' ||fnd_global.newline
2969: ||',p_stop_date => :3' ||fnd_global.newline
2970: ||',p_attributes => :4' ||fnd_global.newline
2971: ||',p_timecard => :5' ||fnd_global.newline
2972: ||',p_messages => :6);'||fnd_global.newline
2973: ||'END;';
2974:
2975: EXECUTE IMMEDIATE l_dyn_template_sql
2976: using IN l_tp_resource_id, IN l_tp_start_time, IN