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.16.12020000.3 2013/02/05 10:45:48 jnerella ship $ */
3:
4:
5: -- initialize the global variable

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

3569: l_end_index NUMBER := 0;
3570:
3571: BEGIN
3572: IF (p_index = 1) THEN
3573: IF INSTR(p_str, hxc_alias_utility.ALIAS_SEPARATOR) = 0 THEN
3574: RETURN p_str;
3575: ELSE
3576: RETURN SUBSTR(p_str, 1, (INSTR(p_str, hxc_alias_utility.ALIAS_SEPARATOR) - 1));
3577: END IF;

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

3572: IF (p_index = 1) THEN
3573: IF INSTR(p_str, hxc_alias_utility.ALIAS_SEPARATOR) = 0 THEN
3574: RETURN p_str;
3575: ELSE
3576: RETURN SUBSTR(p_str, 1, (INSTR(p_str, hxc_alias_utility.ALIAS_SEPARATOR) - 1));
3577: END IF;
3578: END IF;
3579:
3580: LOOP

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

3581: EXIT WHEN l_end_index = LENGTH(p_str);
3582:
3583: l_pos := l_pos + 1;
3584:
3585: l_current_index := INSTR(p_str, hxc_alias_utility.ALIAS_SEPARATOR, (l_current_index + 1) );
3586:
3587: IF (l_current_index = -1) THEN
3588: RETURN SUBSTR(p_str, l_end_index + 1, length(p_str) - l_end_index);
3589: ELSE

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

3586:
3587: IF (l_current_index = -1) THEN
3588: RETURN SUBSTR(p_str, l_end_index + 1, length(p_str) - l_end_index);
3589: ELSE
3590: l_end_index := INSTR(p_str, hxc_alias_utility.ALIAS_SEPARATOR, (l_current_index + 1));
3591:
3592: IF (l_end_index = 0) THEN
3593: l_end_index := LENGTH(p_str);
3594: ELSE

Line 4632: ,'HXC_ALIAS_UTILITY.alias_def_comma_list'

4628:
4629: BEGIN
4630: IF(1>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4631: fnd_log.string(1
4632: ,'HXC_ALIAS_UTILITY.alias_def_comma_list'
4633: ,'p_alias_type:'||p_alias_type||
4634: ' p_start_time:'||p_start_time||
4635: ' p_stop_time :'||p_stop_time||
4636: ' p_resource_id:'||p_resource_id);

Line 4659: ,'HXC_ALIAS_UTILITY.alias_def_comma_list'

4655: l_alias_def_comma := ','||l_alias_definition(l_index).ALIAS_DEFINITION_ID;
4656:
4657: IF(1>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4658: fnd_log.string(1
4659: ,'HXC_ALIAS_UTILITY.alias_def_comma_list'
4660: ,'l_alias_def_comma1:'||l_alias_def_comma);
4661: END IF;
4662: ELSE
4663: l_alias_def_comma := l_alias_def_comma||','||l_alias_definition(l_index).ALIAS_DEFINITION_ID;

Line 4666: ,'HXC_ALIAS_UTILITY.alias_def_comma_list'

4662: ELSE
4663: l_alias_def_comma := l_alias_def_comma||','||l_alias_definition(l_index).ALIAS_DEFINITION_ID;
4664: IF(1>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4665: fnd_log.string(1
4666: ,'HXC_ALIAS_UTILITY.alias_def_comma_list'
4667: ,'l_alias_def_comma2:'||l_alias_def_comma);
4668: END IF;
4669: END IF;
4670: END IF;

Line 4679: ,'HXC_ALIAS_UTILITY.alias_def_comma_list'

4675:
4676: l_alias_def_comma := l_alias_def_comma||',';
4677: IF(1>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4678: fnd_log.string(1
4679: ,'HXC_ALIAS_UTILITY.alias_def_comma_list'
4680: ,'l_alias_def_comma3:'||l_alias_def_comma);
4681: END IF;
4682:
4683: p_alias_def_comma := l_alias_def_comma;

Line 4701: ,'HXC_ALIAS_UTILITY.alias_def_comma_list'

4697:
4698: BEGIN
4699:
4700: fnd_log.string(1
4701: ,'HXC_ALIAS_UTILITY.alias_def_comma_list'
4702: ,'p_alias_type:'||p_alias_type||
4703: ' p_start_time:'||p_start_time||
4704: ' p_stop_time :'||p_stop_time||
4705: ' p_resource_id:'||p_resource_id);

Line 5238: ,'HXC_ALIAS_UTILITY.get_list_alias_id'

5234:
5235: BEGIN
5236: /*
5237: fnd_log.string(1
5238: ,'HXC_ALIAS_UTILITY.get_list_alias_id'
5239: ,'arrived:');
5240:
5241: fnd_log.string(1
5242: ,'HXC_ALIAS_UTILITY.get_list_alias_id'

Line 5242: ,'HXC_ALIAS_UTILITY.get_list_alias_id'

5238: ,'HXC_ALIAS_UTILITY.get_list_alias_id'
5239: ,'arrived:');
5240:
5241: fnd_log.string(1
5242: ,'HXC_ALIAS_UTILITY.get_list_alias_id'
5243: ,'p_alias_type:'||p_alias_type||
5244: ' p_start_time:'||p_start_time||
5245: ' p_stop_time :'||p_stop_time||
5246: ' p_resource_id:'||p_resource_id);

Line 5259: ,'HXC_ALIAS_UTILITY.get_list_alias_id'

5255:
5256: l_index:=l_pref_table.FIRST;
5257: /*
5258: fnd_log.string(1
5259: ,'HXC_ALIAS_UTILITY.get_list_alias_id'
5260: ,'passed the pref :');
5261: */
5262:
5263: LOOP

Line 5334: -- ,'HXC_ALIAS_UTILITY.get_list_alias_id'

5330: l_pref_value(l_index_pref_val).ALIAS_DEFINITION_ID := l_pref_table(l_index).attribute30;
5331: l_index_pref_val := l_index_pref_val + 1;
5332:
5333: --fnd_log.string(1
5334: -- ,'HXC_ALIAS_UTILITY.get_list_alias_id'
5335: -- ,'l_index_pref_val1:'||l_index_pref_val);
5336:
5337: l_index_pref_val := l_pref_value.first;
5338:

Line 5340: -- ,'HXC_ALIAS_UTILITY.get_list_alias_id'

5336:
5337: l_index_pref_val := l_pref_value.first;
5338:
5339: --fnd_log.string(1
5340: -- ,'HXC_ALIAS_UTILITY.get_list_alias_id'
5341: -- ,'l_index_pref_val2:'||l_index_pref_val);
5342:
5343:
5344: LOOP

Line 5351: --,'HXC_ALIAS_UTILITY.get_list_alias_id'

5347:
5348: IF (l_pref_value(l_index_pref_val).ALIAS_DEFINITION_ID is not null) THEN
5349:
5350: --fnd_log.string(1
5351: --,'HXC_ALIAS_UTILITY.get_list_alias_id'
5352: --,'l_pref_value(l_index_pref_val).ALIAS_DEFINITION_ID :'||
5353: -- l_pref_value(l_index_pref_val).ALIAS_DEFINITION_ID);
5354:
5355:

Line 5364: --,'HXC_ALIAS_UTILITY.get_list_alias_id'

5360: and alias_definition_id =
5361: l_pref_value(l_index_pref_val).ALIAS_DEFINITION_ID;
5362:
5363: --fnd_log.string(1
5364: --,'HXC_ALIAS_UTILITY.get_list_alias_id'
5365: --,'l_alias_type:'||l_alias_type||
5366: --' p_alias_type:'||p_alias_type);
5367:
5368:

Line 5380: --,'HXC_ALIAS_UTILITY.get_list_alias_id'

5376: l_pref_table(l_index).END_DATE;
5377: l_alias_index := l_alias_index + 1;
5378: l_found := true;
5379: --fnd_log.string(1
5380: --,'HXC_ALIAS_UTILITY.get_list_alias_id'
5381: --,'l_pref_value(l_index_pref_val).ALIAS_DEFINITION_ID'||
5382: -- l_pref_value(l_index_pref_val).ALIAS_DEFINITION_ID||
5383: --' l_alias_definition(l_alias_index).START_DATE'||
5384: -- l_pref_table(l_index).START_DATE);

Line 5952: ,p_processing_mode => hxc_alias_utility.c_ss_processing

5948: ,p_blocks => l_tbb_block
5949: ,p_start_time => c_tbb_info.tc_start_time
5950: ,p_stop_time => c_tbb_info.tc_stop_time
5951: ,p_resource_id => p_resource_id
5952: ,p_processing_mode => hxc_alias_utility.c_ss_processing
5953: ,p_add_alias_display_value => true
5954: ,p_add_alias_ref_object => true
5955: ,p_messages => p_messages
5956: );

Line 5964: END HXC_ALIAS_UTILITY;

5960:
5961: END get_translated_detail;
5962:
5963:
5964: END HXC_ALIAS_UTILITY;