DBA Data[Home] [Help]

APPS.HXC_SELF_SERVICE_TIMECARD dependencies on FND_GLOBAL

Line 2704: || fnd_global.local_chr(10)

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:

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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