APPS.ENG_CHANGE_ATTR_UTIL dependencies on ENG_CHANGE_ATTR_UTIL

Line 1: PACKAGE BODY ENG_CHANGE_ATTR_UTIL AS

1: PACKAGE BODY ENG_CHANGE_ATTR_UTIL AS
2: /* $Header: ENGVCAUB.pls 120.48.12020000.2 2012/07/13 02:21:07 mshirkol ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'ENG_CHANGE_ATTR_UTIL' ;
5:

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'ENG_CHANGE_ATTR_UTIL' ;

1: PACKAGE BODY ENG_CHANGE_ATTR_UTIL AS
2: /* $Header: ENGVCAUB.pls 120.48.12020000.2 2012/07/13 02:21:07 mshirkol ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'ENG_CHANGE_ATTR_UTIL' ;
5:
6: -- For Debug
7: g_debug_file UTL_FILE.FILE_TYPE ;
8: g_debug_flag BOOLEAN := FALSE ; -- For Debug, set TRUE

Line 873: l_dynamic_sql := l_dynamic_sql ||'''' || ENG_CHANGE_ATTR_UTIL.G_ATTR_NULL_CHAR ||'''';

869: ',DECODE(PEND.'||l_attr_db_col||
870: ',';
871: IF l_attr_meta_data(i).DATA_TYPE_CODE ='A' OR l_attr_meta_data(i).DATA_TYPE_CODE = 'C'
872: THEN
873: l_dynamic_sql := l_dynamic_sql ||'''' || ENG_CHANGE_ATTR_UTIL.G_ATTR_NULL_CHAR ||'''';
874:
875: ELSIF l_attr_meta_data(i).DATA_TYPE_CODE = 'N'
876: THEN
877: l_dynamic_sql := l_dynamic_sql || TO_CHAR(ENG_CHANGE_ATTR_UTIL.G_ATTR_NULL_NUM);

Line 877: l_dynamic_sql := l_dynamic_sql || TO_CHAR(ENG_CHANGE_ATTR_UTIL.G_ATTR_NULL_NUM);

873: l_dynamic_sql := l_dynamic_sql ||'''' || ENG_CHANGE_ATTR_UTIL.G_ATTR_NULL_CHAR ||'''';
874:
875: ELSIF l_attr_meta_data(i).DATA_TYPE_CODE = 'N'
876: THEN
877: l_dynamic_sql := l_dynamic_sql || TO_CHAR(ENG_CHANGE_ATTR_UTIL.G_ATTR_NULL_NUM);
878:
879: ELSIF l_attr_meta_data(i).DATA_TYPE_CODE = 'X' OR l_attr_meta_data(i).DATA_TYPE_CODE = 'Y'
880: THEN
881: l_dynamic_sql := l_dynamic_sql || ' ''' || TO_CHAR(ENG_CHANGE_ATTR_UTIL.G_ATTR_NULL_DATE) || '''';

Line 881: l_dynamic_sql := l_dynamic_sql || ' ''' || TO_CHAR(ENG_CHANGE_ATTR_UTIL.G_ATTR_NULL_DATE) || '''';

877: l_dynamic_sql := l_dynamic_sql || TO_CHAR(ENG_CHANGE_ATTR_UTIL.G_ATTR_NULL_NUM);
878:
879: ELSIF l_attr_meta_data(i).DATA_TYPE_CODE = 'X' OR l_attr_meta_data(i).DATA_TYPE_CODE = 'Y'
880: THEN
881: l_dynamic_sql := l_dynamic_sql || ' ''' || TO_CHAR(ENG_CHANGE_ATTR_UTIL.G_ATTR_NULL_DATE) || '''';
882: END IF;
883:
884: l_dynamic_sql := l_dynamic_sql || ', NULL , PEND.'|| l_attr_db_col || ')) '|| l_attr_db_col;
885:

Line 1529: AND p_api_caller = ENG_CHANGE_ATTR_UTIL.G_EXEC_MODE_IMPORT

1525: -- This is passed thr Import in case of below condition
1526: --
1527: /* IF p_mode = 'CREATE'
1528: AND p_acd_type ='ADD'
1529: AND p_api_caller = ENG_CHANGE_ATTR_UTIL.G_EXEC_MODE_IMPORT
1530: THEN
1531:
1532: l_row_identifier := -1000 ;
1533:

Line 1930: and x_setup_attr_data(i).ATTR_VALUE_STR = ENG_CHANGE_ATTR_UTIL.G_ATTR_NULL_CHAR

1926: -- Copy whole prod attribute data beause there is no change for this attr
1927: x_setup_attr_data (i) := l_attributes_data_table(j);
1928:
1929: elsif x_setup_attr_data(i).ATTR_VALUE_STR is NOT NULL
1930: and x_setup_attr_data(i).ATTR_VALUE_STR = ENG_CHANGE_ATTR_UTIL.G_ATTR_NULL_CHAR
1931: then
1932:
1933: x_setup_attr_data(i).ATTR_VALUE_STR := NULL;
1934:

Line 1936: and x_setup_attr_data(i).ATTR_VALUE_NUM = ENG_CHANGE_ATTR_UTIL.G_ATTR_NULL_NUM

1932:
1933: x_setup_attr_data(i).ATTR_VALUE_STR := NULL;
1934:
1935: elsif x_setup_attr_data(i).ATTR_VALUE_NUM is NOT NULL
1936: and x_setup_attr_data(i).ATTR_VALUE_NUM = ENG_CHANGE_ATTR_UTIL.G_ATTR_NULL_NUM
1937: then
1938:
1939: x_setup_attr_data(i).ATTR_VALUE_NUM := NULL;
1940:

Line 1942: and x_setup_attr_data(i).ATTR_VALUE_DATE = ENG_CHANGE_ATTR_UTIL.G_ATTR_NULL_DATE

1938:
1939: x_setup_attr_data(i).ATTR_VALUE_NUM := NULL;
1940:
1941: elsif x_setup_attr_data(i).ATTR_VALUE_DATE is NOT NULL
1942: and x_setup_attr_data(i).ATTR_VALUE_DATE = ENG_CHANGE_ATTR_UTIL.G_ATTR_NULL_DATE
1943: then
1944:
1945: x_setup_attr_data(i).ATTR_VALUE_DATE := NULL;
1946:

Line 2905: END ENG_CHANGE_ATTR_UTIL;

2901:
2902:
2903: END SAVE_ITEM_NUM_DESC;
2904:
2905: END ENG_CHANGE_ATTR_UTIL;