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.45 2007/07/12 19:20:17 asjohal 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.45 2007/07/12 19:20:17 asjohal 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 865: l_dynamic_sql := l_dynamic_sql ||'''' || ENG_CHANGE_ATTR_UTIL.G_ATTR_NULL_CHAR ||'''';

861: ',DECODE(PEND.'||l_attr_db_col||
862: ',';
863: IF l_attr_meta_data(i).DATA_TYPE_CODE ='A' OR l_attr_meta_data(i).DATA_TYPE_CODE = 'C'
864: THEN
865: l_dynamic_sql := l_dynamic_sql ||'''' || ENG_CHANGE_ATTR_UTIL.G_ATTR_NULL_CHAR ||'''';
866:
867: ELSIF l_attr_meta_data(i).DATA_TYPE_CODE = 'N'
868: THEN
869: l_dynamic_sql := l_dynamic_sql || TO_CHAR(ENG_CHANGE_ATTR_UTIL.G_ATTR_NULL_NUM);

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

865: l_dynamic_sql := l_dynamic_sql ||'''' || ENG_CHANGE_ATTR_UTIL.G_ATTR_NULL_CHAR ||'''';
866:
867: ELSIF l_attr_meta_data(i).DATA_TYPE_CODE = 'N'
868: THEN
869: l_dynamic_sql := l_dynamic_sql || TO_CHAR(ENG_CHANGE_ATTR_UTIL.G_ATTR_NULL_NUM);
870:
871: ELSIF l_attr_meta_data(i).DATA_TYPE_CODE = 'X' OR l_attr_meta_data(i).DATA_TYPE_CODE = 'Y'
872: THEN
873: l_dynamic_sql := l_dynamic_sql || ' ''' || TO_CHAR(ENG_CHANGE_ATTR_UTIL.G_ATTR_NULL_DATE) || '''';

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

869: l_dynamic_sql := l_dynamic_sql || TO_CHAR(ENG_CHANGE_ATTR_UTIL.G_ATTR_NULL_NUM);
870:
871: ELSIF l_attr_meta_data(i).DATA_TYPE_CODE = 'X' OR l_attr_meta_data(i).DATA_TYPE_CODE = 'Y'
872: THEN
873: l_dynamic_sql := l_dynamic_sql || ' ''' || TO_CHAR(ENG_CHANGE_ATTR_UTIL.G_ATTR_NULL_DATE) || '''';
874: END IF;
875:
876: l_dynamic_sql := l_dynamic_sql || ', NULL , PEND.'|| l_attr_db_col || ')) '|| l_attr_db_col;
877:

Line 1498: AND p_api_caller = ENG_CHANGE_ATTR_UTIL.G_EXEC_MODE_IMPORT

1494: -- This is passed thr Import in case of below condition
1495: --
1496: /* IF p_mode = 'CREATE'
1497: AND p_acd_type ='ADD'
1498: AND p_api_caller = ENG_CHANGE_ATTR_UTIL.G_EXEC_MODE_IMPORT
1499: THEN
1500:
1501: l_row_identifier := -1000 ;
1502:

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

1895: -- Copy whole prod attribute data beause there is no change for this attr
1896: x_setup_attr_data (i) := l_attributes_data_table(j);
1897:
1898: elsif x_setup_attr_data(i).ATTR_VALUE_STR is NOT NULL
1899: and x_setup_attr_data(i).ATTR_VALUE_STR = ENG_CHANGE_ATTR_UTIL.G_ATTR_NULL_CHAR
1900: then
1901:
1902: x_setup_attr_data(i).ATTR_VALUE_STR := NULL;
1903:

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

1901:
1902: x_setup_attr_data(i).ATTR_VALUE_STR := NULL;
1903:
1904: elsif x_setup_attr_data(i).ATTR_VALUE_NUM is NOT NULL
1905: and x_setup_attr_data(i).ATTR_VALUE_NUM = ENG_CHANGE_ATTR_UTIL.G_ATTR_NULL_NUM
1906: then
1907:
1908: x_setup_attr_data(i).ATTR_VALUE_NUM := NULL;
1909:

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

1907:
1908: x_setup_attr_data(i).ATTR_VALUE_NUM := NULL;
1909:
1910: elsif x_setup_attr_data(i).ATTR_VALUE_DATE is NOT NULL
1911: and x_setup_attr_data(i).ATTR_VALUE_DATE = ENG_CHANGE_ATTR_UTIL.G_ATTR_NULL_DATE
1912: then
1913:
1914: x_setup_attr_data(i).ATTR_VALUE_DATE := NULL;
1915:

Line 2874: END ENG_CHANGE_ATTR_UTIL;

2870:
2871:
2872: END SAVE_ITEM_NUM_DESC;
2873:
2874: END ENG_CHANGE_ATTR_UTIL;