DBA Data[Home] [Help]

APPS.EGO_IMPORT_PVT dependencies on EGO_USER_ATTRS_BULK_PVT

Line 32: G_EXCEL_MISS_NUM_STR CONSTANT VARCHAR2(20) := EGO_USER_ATTRS_BULK_PVT.G_NULL_NUM_VAL;

28:
29: G_EXCEL_MISS_DATE_VAL CONSTANT DATE := to_date( '9999-12-31', 'YYYY-MM-DD' );
30: G_EXCEL_MISS_DATE_STR CONSTANT VARCHAR2(50) := 'to_date(''9999-12-31'', ''YYYY-MM-DD'') ';
31:
32: G_EXCEL_MISS_NUM_STR CONSTANT VARCHAR2(20) := EGO_USER_ATTRS_BULK_PVT.G_NULL_NUM_VAL;
33: G_EXCEL_MISS_CHAR_VAL CONSTANT VARCHAR2(30) := EGO_USER_ATTRS_BULK_PVT.G_NULL_CHAR_VAL;
34:
35: G_EXCEL_MISS_VS_VAL CONSTANT VARCHAR2(30) := ''''||G_EXCEL_MISS_CHAR_VAL||'''';
36:

Line 33: G_EXCEL_MISS_CHAR_VAL CONSTANT VARCHAR2(30) := EGO_USER_ATTRS_BULK_PVT.G_NULL_CHAR_VAL;

29: G_EXCEL_MISS_DATE_VAL CONSTANT DATE := to_date( '9999-12-31', 'YYYY-MM-DD' );
30: G_EXCEL_MISS_DATE_STR CONSTANT VARCHAR2(50) := 'to_date(''9999-12-31'', ''YYYY-MM-DD'') ';
31:
32: G_EXCEL_MISS_NUM_STR CONSTANT VARCHAR2(20) := EGO_USER_ATTRS_BULK_PVT.G_NULL_NUM_VAL;
33: G_EXCEL_MISS_CHAR_VAL CONSTANT VARCHAR2(30) := EGO_USER_ATTRS_BULK_PVT.G_NULL_CHAR_VAL;
34:
35: G_EXCEL_MISS_VS_VAL CONSTANT VARCHAR2(30) := ''''||G_EXCEL_MISS_CHAR_VAL||'''';
36:
37: -- Confirm Status Constants Available in package spec

Line 10650: ||', '|| EGO_USER_ATTRS_BULK_PVT.G_NULL_DATE_VAL ||', '|| l_miss_str

10646: l_select_sql := CASE
10647: WHEN p_attr_type = G_DATE_DATA_TYPE OR p_attr_type = G_DATE_TIME_DATA_TYPE THEN
10648: 'DECODE( EIUAI.ATTR_VALUE_DATE'
10649: ||', NULL, ' || l_miss_str
10650: ||', '|| EGO_USER_ATTRS_BULK_PVT.G_NULL_DATE_VAL ||', '|| l_miss_str
10651: ||', TO_CHAR( EIUAI.ATTR_VALUE_DATE, '''|| l_date_format || ''')'
10652: ||')'
10653: WHEN p_attr_type = G_NUMBER_DATA_TYPE THEN
10654: -- ignore UOM column completely ... the assumption is that this