DBA Data[Home] [Help]

APPS.HXC_SELF_SERVICE_TIMECARD dependencies on FND_GLOBAL

Line 2404: || fnd_global.local_chr(10)

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:

Line 2735: l_dyn_template_sql := 'BEGIN '||fnd_global.newline

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

Line 2736: ||p_template_procedure ||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

Line 2737: ||'(p_resource_id => :1' ||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

Line 2738: ||',p_start_date => :2' ||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

Line 2739: ||',p_stop_date => :3' ||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;';

Line 2740: ||',p_attributes => :4' ||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;';
2744:

Line 2741: ||',p_timecard => :5' ||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:
2745: IF g_debug THEN

Line 2742: ||',p_messages => :6);'||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
2746: hr_utility.trace ('l_dyn_template_sql='||l_dyn_template_sql);

Line 2965: /* l_dyn_template_sql := 'BEGIN '||fnd_global.newline

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

Line 2966: ||l_template_procedure ||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

Line 2967: ||'(p_resource_id => :1' ||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

Line 2968: ||',p_start_date => :2' ||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

Line 2969: ||',p_stop_date => :3' ||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;';

Line 2970: ||',p_attributes => :4' ||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;';
2974:

Line 2971: ||',p_timecard => :5' ||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:
2975: EXECUTE IMMEDIATE l_dyn_template_sql

Line 2972: ||',p_messages => :6);'||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
2976: using IN l_tp_resource_id, IN l_tp_start_time, IN