1: PACKAGE BODY EGO_USER_ATTRS_COMMON_PVT AS
2: /* $Header: EGOPEFCB.pls 120.13 2007/05/19 08:07:09 srajapar ship $ */
3:
4:
5:
90: ------------------------------
91: -- Private Global Variables --
92: ------------------------------
93:
94: G_PKG_NAME CONSTANT VARCHAR2(30) := 'EGO_USER_ATTRS_COMMON_PVT';
95: G_CURRENT_USER_ID NUMBER := FND_GLOBAL.User_Id;
96: G_CURRENT_LOGIN_ID NUMBER := FND_GLOBAL.Login_Id;
97:
98: G_AG_METADATA_BATCH_1 EGO_ATTR_GROUP_BATCH_REC;
1852: -- Dates that have been TO_CHAR'ed --
1853: ---------------------------------------------------------------
1854: ELSIF (p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE) THEN
1855:
1856: l_db_column_alias := 'SUBSTR(TO_CHAR(TRUNC('||p_attr_metadata_obj.DATABASE_COLUMN||'), '''||EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT||'''), 2)';
1857:
1858: ELSIF (p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
1859:
1860: l_db_column_alias := 'SUBSTR(TO_CHAR('||p_attr_metadata_obj.DATABASE_COLUMN||', '''||EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT||'''), 2)';
1856: l_db_column_alias := 'SUBSTR(TO_CHAR(TRUNC('||p_attr_metadata_obj.DATABASE_COLUMN||'), '''||EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT||'''), 2)';
1857:
1858: ELSIF (p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
1859:
1860: l_db_column_alias := 'SUBSTR(TO_CHAR('||p_attr_metadata_obj.DATABASE_COLUMN||', '''||EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT||'''), 2)';
1861:
1862: END IF;
1863:
1864: RETURN l_db_column_alias;
1906: RETURN p_date;
1907: END IF;
1908:
1909: --process only if the attribute is of type date or date time
1910: l_attr_int_value := TRIM(TO_CHAR(p_date,EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT));
1911: l_space_pos := Instr(l_attr_int_value,' ');
1912: l_time_factor := SUBSTR(l_attr_int_value,l_space_pos+1);
1913: l_attr_int_value := TO_CHAR(p_date);
1914: IF p_attr_type = 'Y' THEN
2340: RETURN FND_API.G_FALSE;
2341: END has_column_in_table;
2342:
2343:
2344: END EGO_USER_ATTRS_COMMON_PVT;