2700: l_complete_blocks(l_old_block_index).COMMENT_TEXT
2701: :=
2702: -- Bug 8937768
2703: SUBSTR(l_complete_blocks(l_old_block_index).COMMENT_TEXT
2704: || fnd_global.local_chr(10)
2705: || l_new_blocks_array(l_new_block_index).COMMENT_TEXT,1,2000);
2706: END IF;
2707: END IF;
2708:
3031: hr_utility.trace ('p_template_procedure='||p_template_procedure);
3032: END IF;
3033: hxc_timecard_message_helper.initializeErrors;
3034:
3035: l_dyn_template_sql := 'BEGIN '||fnd_global.newline
3036: ||p_template_procedure ||fnd_global.newline
3037: ||'(p_resource_id => :1' ||fnd_global.newline
3038: ||',p_start_date => :2' ||fnd_global.newline
3039: ||',p_stop_date => :3' ||fnd_global.newline
3032: END IF;
3033: hxc_timecard_message_helper.initializeErrors;
3034:
3035: l_dyn_template_sql := 'BEGIN '||fnd_global.newline
3036: ||p_template_procedure ||fnd_global.newline
3037: ||'(p_resource_id => :1' ||fnd_global.newline
3038: ||',p_start_date => :2' ||fnd_global.newline
3039: ||',p_stop_date => :3' ||fnd_global.newline
3040: ||',p_attributes => :4' ||fnd_global.newline
3033: hxc_timecard_message_helper.initializeErrors;
3034:
3035: l_dyn_template_sql := 'BEGIN '||fnd_global.newline
3036: ||p_template_procedure ||fnd_global.newline
3037: ||'(p_resource_id => :1' ||fnd_global.newline
3038: ||',p_start_date => :2' ||fnd_global.newline
3039: ||',p_stop_date => :3' ||fnd_global.newline
3040: ||',p_attributes => :4' ||fnd_global.newline
3041: ||',p_timecard => :5' ||fnd_global.newline
3034:
3035: l_dyn_template_sql := 'BEGIN '||fnd_global.newline
3036: ||p_template_procedure ||fnd_global.newline
3037: ||'(p_resource_id => :1' ||fnd_global.newline
3038: ||',p_start_date => :2' ||fnd_global.newline
3039: ||',p_stop_date => :3' ||fnd_global.newline
3040: ||',p_attributes => :4' ||fnd_global.newline
3041: ||',p_timecard => :5' ||fnd_global.newline
3042: ||',p_messages => :6);'||fnd_global.newline
3035: l_dyn_template_sql := 'BEGIN '||fnd_global.newline
3036: ||p_template_procedure ||fnd_global.newline
3037: ||'(p_resource_id => :1' ||fnd_global.newline
3038: ||',p_start_date => :2' ||fnd_global.newline
3039: ||',p_stop_date => :3' ||fnd_global.newline
3040: ||',p_attributes => :4' ||fnd_global.newline
3041: ||',p_timecard => :5' ||fnd_global.newline
3042: ||',p_messages => :6);'||fnd_global.newline
3043: ||'END;';
3036: ||p_template_procedure ||fnd_global.newline
3037: ||'(p_resource_id => :1' ||fnd_global.newline
3038: ||',p_start_date => :2' ||fnd_global.newline
3039: ||',p_stop_date => :3' ||fnd_global.newline
3040: ||',p_attributes => :4' ||fnd_global.newline
3041: ||',p_timecard => :5' ||fnd_global.newline
3042: ||',p_messages => :6);'||fnd_global.newline
3043: ||'END;';
3044:
3037: ||'(p_resource_id => :1' ||fnd_global.newline
3038: ||',p_start_date => :2' ||fnd_global.newline
3039: ||',p_stop_date => :3' ||fnd_global.newline
3040: ||',p_attributes => :4' ||fnd_global.newline
3041: ||',p_timecard => :5' ||fnd_global.newline
3042: ||',p_messages => :6);'||fnd_global.newline
3043: ||'END;';
3044:
3045: IF g_debug THEN
3038: ||',p_start_date => :2' ||fnd_global.newline
3039: ||',p_stop_date => :3' ||fnd_global.newline
3040: ||',p_attributes => :4' ||fnd_global.newline
3041: ||',p_timecard => :5' ||fnd_global.newline
3042: ||',p_messages => :6);'||fnd_global.newline
3043: ||'END;';
3044:
3045: IF g_debug THEN
3046: hr_utility.trace ('l_dyn_template_sql='||l_dyn_template_sql);
3261: CLOSE c_dyn_template_procedure;
3262:
3263:
3264: -- call the procedure to get the blocks info
3265: /* l_dyn_template_sql := 'BEGIN '||fnd_global.newline
3266: ||l_template_procedure ||fnd_global.newline
3267: ||'(p_resource_id => :1' ||fnd_global.newline
3268: ||',p_start_date => :2' ||fnd_global.newline
3269: ||',p_stop_date => :3' ||fnd_global.newline
3262:
3263:
3264: -- call the procedure to get the blocks info
3265: /* l_dyn_template_sql := 'BEGIN '||fnd_global.newline
3266: ||l_template_procedure ||fnd_global.newline
3267: ||'(p_resource_id => :1' ||fnd_global.newline
3268: ||',p_start_date => :2' ||fnd_global.newline
3269: ||',p_stop_date => :3' ||fnd_global.newline
3270: ||',p_attributes => :4' ||fnd_global.newline
3263:
3264: -- call the procedure to get the blocks info
3265: /* l_dyn_template_sql := 'BEGIN '||fnd_global.newline
3266: ||l_template_procedure ||fnd_global.newline
3267: ||'(p_resource_id => :1' ||fnd_global.newline
3268: ||',p_start_date => :2' ||fnd_global.newline
3269: ||',p_stop_date => :3' ||fnd_global.newline
3270: ||',p_attributes => :4' ||fnd_global.newline
3271: ||',p_timecard => :5' ||fnd_global.newline
3264: -- call the procedure to get the blocks info
3265: /* l_dyn_template_sql := 'BEGIN '||fnd_global.newline
3266: ||l_template_procedure ||fnd_global.newline
3267: ||'(p_resource_id => :1' ||fnd_global.newline
3268: ||',p_start_date => :2' ||fnd_global.newline
3269: ||',p_stop_date => :3' ||fnd_global.newline
3270: ||',p_attributes => :4' ||fnd_global.newline
3271: ||',p_timecard => :5' ||fnd_global.newline
3272: ||',p_messages => :6);'||fnd_global.newline
3265: /* l_dyn_template_sql := 'BEGIN '||fnd_global.newline
3266: ||l_template_procedure ||fnd_global.newline
3267: ||'(p_resource_id => :1' ||fnd_global.newline
3268: ||',p_start_date => :2' ||fnd_global.newline
3269: ||',p_stop_date => :3' ||fnd_global.newline
3270: ||',p_attributes => :4' ||fnd_global.newline
3271: ||',p_timecard => :5' ||fnd_global.newline
3272: ||',p_messages => :6);'||fnd_global.newline
3273: ||'END;';
3266: ||l_template_procedure ||fnd_global.newline
3267: ||'(p_resource_id => :1' ||fnd_global.newline
3268: ||',p_start_date => :2' ||fnd_global.newline
3269: ||',p_stop_date => :3' ||fnd_global.newline
3270: ||',p_attributes => :4' ||fnd_global.newline
3271: ||',p_timecard => :5' ||fnd_global.newline
3272: ||',p_messages => :6);'||fnd_global.newline
3273: ||'END;';
3274:
3267: ||'(p_resource_id => :1' ||fnd_global.newline
3268: ||',p_start_date => :2' ||fnd_global.newline
3269: ||',p_stop_date => :3' ||fnd_global.newline
3270: ||',p_attributes => :4' ||fnd_global.newline
3271: ||',p_timecard => :5' ||fnd_global.newline
3272: ||',p_messages => :6);'||fnd_global.newline
3273: ||'END;';
3274:
3275: EXECUTE IMMEDIATE l_dyn_template_sql
3268: ||',p_start_date => :2' ||fnd_global.newline
3269: ||',p_stop_date => :3' ||fnd_global.newline
3270: ||',p_attributes => :4' ||fnd_global.newline
3271: ||',p_timecard => :5' ||fnd_global.newline
3272: ||',p_messages => :6);'||fnd_global.newline
3273: ||'END;';
3274:
3275: EXECUTE IMMEDIATE l_dyn_template_sql
3276: using IN l_tp_resource_id, IN l_tp_start_time, IN