DBA Data[Home] [Help]

APPS.HXC_ALIAS_UTILITY dependencies on HXC_ALIAS_UTILITY

Line 1: PACKAGE BODY HXC_ALIAS_UTILITY AS

1: PACKAGE BODY HXC_ALIAS_UTILITY AS
2: /* $Header: hxcaltutl.pkb 120.13.12010000.4 2008/12/30 09:02:27 sabvenug ship $ */
3:
4:
5: -- initialize the global variable

Line 3257: IF INSTR(p_str, hxc_alias_utility.ALIAS_SEPARATOR) = 0 THEN

3253: l_end_index NUMBER := 0;
3254:
3255: BEGIN
3256: IF (p_index = 1) THEN
3257: IF INSTR(p_str, hxc_alias_utility.ALIAS_SEPARATOR) = 0 THEN
3258: RETURN p_str;
3259: ELSE
3260: RETURN SUBSTR(p_str, 1, (INSTR(p_str, hxc_alias_utility.ALIAS_SEPARATOR) - 1));
3261: END IF;

Line 3260: RETURN SUBSTR(p_str, 1, (INSTR(p_str, hxc_alias_utility.ALIAS_SEPARATOR) - 1));

3256: IF (p_index = 1) THEN
3257: IF INSTR(p_str, hxc_alias_utility.ALIAS_SEPARATOR) = 0 THEN
3258: RETURN p_str;
3259: ELSE
3260: RETURN SUBSTR(p_str, 1, (INSTR(p_str, hxc_alias_utility.ALIAS_SEPARATOR) - 1));
3261: END IF;
3262: END IF;
3263:
3264: LOOP

Line 3269: l_current_index := INSTR(p_str, hxc_alias_utility.ALIAS_SEPARATOR, (l_current_index + 1) );

3265: EXIT WHEN l_end_index = LENGTH(p_str);
3266:
3267: l_pos := l_pos + 1;
3268:
3269: l_current_index := INSTR(p_str, hxc_alias_utility.ALIAS_SEPARATOR, (l_current_index + 1) );
3270:
3271: IF (l_current_index = -1) THEN
3272: RETURN SUBSTR(p_str, l_end_index + 1, length(p_str) - l_end_index);
3273: ELSE

Line 3274: l_end_index := INSTR(p_str, hxc_alias_utility.ALIAS_SEPARATOR, (l_current_index + 1));

3270:
3271: IF (l_current_index = -1) THEN
3272: RETURN SUBSTR(p_str, l_end_index + 1, length(p_str) - l_end_index);
3273: ELSE
3274: l_end_index := INSTR(p_str, hxc_alias_utility.ALIAS_SEPARATOR, (l_current_index + 1));
3275:
3276: IF (l_end_index = 0) THEN
3277: l_end_index := LENGTH(p_str);
3278: ELSE

Line 4316: ,'HXC_ALIAS_UTILITY.alias_def_comma_list'

4312:
4313: BEGIN
4314: IF(1>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4315: fnd_log.string(1
4316: ,'HXC_ALIAS_UTILITY.alias_def_comma_list'
4317: ,'p_alias_type:'||p_alias_type||
4318: ' p_start_time:'||p_start_time||
4319: ' p_stop_time :'||p_stop_time||
4320: ' p_resource_id:'||p_resource_id);

Line 4343: ,'HXC_ALIAS_UTILITY.alias_def_comma_list'

4339: l_alias_def_comma := ','||l_alias_definition(l_index).ALIAS_DEFINITION_ID;
4340:
4341: IF(1>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4342: fnd_log.string(1
4343: ,'HXC_ALIAS_UTILITY.alias_def_comma_list'
4344: ,'l_alias_def_comma1:'||l_alias_def_comma);
4345: END IF;
4346: ELSE
4347: l_alias_def_comma := l_alias_def_comma||','||l_alias_definition(l_index).ALIAS_DEFINITION_ID;

Line 4350: ,'HXC_ALIAS_UTILITY.alias_def_comma_list'

4346: ELSE
4347: l_alias_def_comma := l_alias_def_comma||','||l_alias_definition(l_index).ALIAS_DEFINITION_ID;
4348: IF(1>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4349: fnd_log.string(1
4350: ,'HXC_ALIAS_UTILITY.alias_def_comma_list'
4351: ,'l_alias_def_comma2:'||l_alias_def_comma);
4352: END IF;
4353: END IF;
4354: END IF;

Line 4363: ,'HXC_ALIAS_UTILITY.alias_def_comma_list'

4359:
4360: l_alias_def_comma := l_alias_def_comma||',';
4361: IF(1>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4362: fnd_log.string(1
4363: ,'HXC_ALIAS_UTILITY.alias_def_comma_list'
4364: ,'l_alias_def_comma3:'||l_alias_def_comma);
4365: END IF;
4366:
4367: p_alias_def_comma := l_alias_def_comma;

Line 4385: ,'HXC_ALIAS_UTILITY.alias_def_comma_list'

4381:
4382: BEGIN
4383:
4384: fnd_log.string(1
4385: ,'HXC_ALIAS_UTILITY.alias_def_comma_list'
4386: ,'p_alias_type:'||p_alias_type||
4387: ' p_start_time:'||p_start_time||
4388: ' p_stop_time :'||p_stop_time||
4389: ' p_resource_id:'||p_resource_id);

Line 4922: ,'HXC_ALIAS_UTILITY.get_list_alias_id'

4918:
4919: BEGIN
4920: /*
4921: fnd_log.string(1
4922: ,'HXC_ALIAS_UTILITY.get_list_alias_id'
4923: ,'arrived:');
4924:
4925: fnd_log.string(1
4926: ,'HXC_ALIAS_UTILITY.get_list_alias_id'

Line 4926: ,'HXC_ALIAS_UTILITY.get_list_alias_id'

4922: ,'HXC_ALIAS_UTILITY.get_list_alias_id'
4923: ,'arrived:');
4924:
4925: fnd_log.string(1
4926: ,'HXC_ALIAS_UTILITY.get_list_alias_id'
4927: ,'p_alias_type:'||p_alias_type||
4928: ' p_start_time:'||p_start_time||
4929: ' p_stop_time :'||p_stop_time||
4930: ' p_resource_id:'||p_resource_id);

Line 4943: ,'HXC_ALIAS_UTILITY.get_list_alias_id'

4939:
4940: l_index:=l_pref_table.FIRST;
4941: /*
4942: fnd_log.string(1
4943: ,'HXC_ALIAS_UTILITY.get_list_alias_id'
4944: ,'passed the pref :');
4945: */
4946:
4947: LOOP

Line 5018: -- ,'HXC_ALIAS_UTILITY.get_list_alias_id'

5014: l_pref_value(l_index_pref_val).ALIAS_DEFINITION_ID := l_pref_table(l_index).attribute30;
5015: l_index_pref_val := l_index_pref_val + 1;
5016:
5017: --fnd_log.string(1
5018: -- ,'HXC_ALIAS_UTILITY.get_list_alias_id'
5019: -- ,'l_index_pref_val1:'||l_index_pref_val);
5020:
5021: l_index_pref_val := l_pref_value.first;
5022:

Line 5024: -- ,'HXC_ALIAS_UTILITY.get_list_alias_id'

5020:
5021: l_index_pref_val := l_pref_value.first;
5022:
5023: --fnd_log.string(1
5024: -- ,'HXC_ALIAS_UTILITY.get_list_alias_id'
5025: -- ,'l_index_pref_val2:'||l_index_pref_val);
5026:
5027:
5028: LOOP

Line 5035: --,'HXC_ALIAS_UTILITY.get_list_alias_id'

5031:
5032: IF (l_pref_value(l_index_pref_val).ALIAS_DEFINITION_ID is not null) THEN
5033:
5034: --fnd_log.string(1
5035: --,'HXC_ALIAS_UTILITY.get_list_alias_id'
5036: --,'l_pref_value(l_index_pref_val).ALIAS_DEFINITION_ID :'||
5037: -- l_pref_value(l_index_pref_val).ALIAS_DEFINITION_ID);
5038:
5039:

Line 5048: --,'HXC_ALIAS_UTILITY.get_list_alias_id'

5044: and alias_definition_id =
5045: l_pref_value(l_index_pref_val).ALIAS_DEFINITION_ID;
5046:
5047: --fnd_log.string(1
5048: --,'HXC_ALIAS_UTILITY.get_list_alias_id'
5049: --,'l_alias_type:'||l_alias_type||
5050: --' p_alias_type:'||p_alias_type);
5051:
5052:

Line 5064: --,'HXC_ALIAS_UTILITY.get_list_alias_id'

5060: l_pref_table(l_index).END_DATE;
5061: l_alias_index := l_alias_index + 1;
5062: l_found := true;
5063: --fnd_log.string(1
5064: --,'HXC_ALIAS_UTILITY.get_list_alias_id'
5065: --,'l_pref_value(l_index_pref_val).ALIAS_DEFINITION_ID'||
5066: -- l_pref_value(l_index_pref_val).ALIAS_DEFINITION_ID||
5067: --' l_alias_definition(l_alias_index).START_DATE'||
5068: -- l_pref_table(l_index).START_DATE);

Line 5636: ,p_processing_mode => hxc_alias_utility.c_ss_processing

5632: ,p_blocks => l_tbb_block
5633: ,p_start_time => c_tbb_info.tc_start_time
5634: ,p_stop_time => c_tbb_info.tc_stop_time
5635: ,p_resource_id => p_resource_id
5636: ,p_processing_mode => hxc_alias_utility.c_ss_processing
5637: ,p_add_alias_display_value => true
5638: ,p_add_alias_ref_object => true
5639: ,p_messages => p_messages
5640: );

Line 5648: END HXC_ALIAS_UTILITY;

5644:
5645: END get_translated_detail;
5646:
5647:
5648: END HXC_ALIAS_UTILITY;