eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EGO_USER_ATTRS_COMMON_PVT dependencies on EGO_EXT_FWK_PUB

Line 796: IF (p_validation_code = EGO_EXT_FWK_PUB.G_INDEPENDENT_VALIDATION_CODE OR p_validation_code = EGO_EXT_FWK_PUB.G_TRANS_IND_VALIDATION_CODE) THEN

792: l_where_clause LONG;
793:
794: BEGIN
795:
796: IF (p_validation_code = EGO_EXT_FWK_PUB.G_INDEPENDENT_VALIDATION_CODE OR p_validation_code = EGO_EXT_FWK_PUB.G_TRANS_IND_VALIDATION_CODE) THEN
797:
798: --------------------------------------------------------------------
799: -- We only use this query, which has the Value Set ID hard-coded, --
800: -- in Get_User_Attrs_Data; elsewhere we use a dynamic version of --

Line 812: ELSIF (p_validation_code = EGO_EXT_FWK_PUB.G_TABLE_VALIDATION_CODE) THEN

808: 'AND (NVL(START_DATE, SYSDATE - 1) < SYSDATE) '||
809: 'AND (NVL(END_DATE, SYSDATE + 1) > SYSDATE) '||
810: 'AND INTERNAL_NAME = ';
811:
812: ELSIF (p_validation_code = EGO_EXT_FWK_PUB.G_TABLE_VALIDATION_CODE) THEN
813: SELECT APPLICATION_TABLE_NAME
814: ,ID_COLUMN_NAME
815: ,VALUE_COLUMN_NAME
816: ,ADDITIONAL_WHERE_CLAUSE

Line 1048: IF (attrs_rec.DATA_TYPE = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE) THEN

1044: px_attr_group_metadata_obj.UNIQUE_KEY_ATTRS_COUNT + 1;
1045:
1046: END IF;
1047:
1048: IF (attrs_rec.DATA_TYPE = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE) THEN
1049:
1050: px_attr_group_metadata_obj.TRANS_ATTRS_COUNT :=
1051: px_attr_group_metadata_obj.TRANS_ATTRS_COUNT + 1;
1052:

Line 1055: IF (attrs_rec.VALIDATION_TYPE = EGO_EXT_FWK_PUB.G_INDEPENDENT_VALIDATION_CODE OR

1051: px_attr_group_metadata_obj.TRANS_ATTRS_COUNT + 1;
1052:
1053: END IF;
1054:
1055: IF (attrs_rec.VALIDATION_TYPE = EGO_EXT_FWK_PUB.G_INDEPENDENT_VALIDATION_CODE OR
1056: attrs_rec.VALIDATION_TYPE = EGO_EXT_FWK_PUB.G_TABLE_VALIDATION_CODE OR
1057: attrs_rec.VALIDATION_TYPE = EGO_EXT_FWK_PUB.G_TRANS_IND_VALIDATION_CODE) THEN--Bug fix 4645598
1058:
1059: -----------------------------------------------------------------

Line 1056: attrs_rec.VALIDATION_TYPE = EGO_EXT_FWK_PUB.G_TABLE_VALIDATION_CODE OR

1052:
1053: END IF;
1054:
1055: IF (attrs_rec.VALIDATION_TYPE = EGO_EXT_FWK_PUB.G_INDEPENDENT_VALIDATION_CODE OR
1056: attrs_rec.VALIDATION_TYPE = EGO_EXT_FWK_PUB.G_TABLE_VALIDATION_CODE OR
1057: attrs_rec.VALIDATION_TYPE = EGO_EXT_FWK_PUB.G_TRANS_IND_VALIDATION_CODE) THEN--Bug fix 4645598
1058:
1059: -----------------------------------------------------------------
1060: -- If this Attribute has a Value Set with Internal and Display --

Line 1057: attrs_rec.VALIDATION_TYPE = EGO_EXT_FWK_PUB.G_TRANS_IND_VALIDATION_CODE) THEN--Bug fix 4645598

1053: END IF;
1054:
1055: IF (attrs_rec.VALIDATION_TYPE = EGO_EXT_FWK_PUB.G_INDEPENDENT_VALIDATION_CODE OR
1056: attrs_rec.VALIDATION_TYPE = EGO_EXT_FWK_PUB.G_TABLE_VALIDATION_CODE OR
1057: attrs_rec.VALIDATION_TYPE = EGO_EXT_FWK_PUB.G_TRANS_IND_VALIDATION_CODE) THEN--Bug fix 4645598
1058:
1059: -----------------------------------------------------------------
1060: -- If this Attribute has a Value Set with Internal and Display --
1061: -- Values, we build SQL to transform one into the other (and --

Line 1956: IF (p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN

1952:
1953: -------------------------------------------------------------------------
1954: -- Set up an alias to convert Date, Number values to formatted strings --
1955: -------------------------------------------------------------------------
1956: IF (p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
1957:
1958: l_db_column_alias := 'TO_CHAR('||p_attr_metadata_obj.DATABASE_COLUMN||')';
1959:
1960: ---------------------------------------------------------------

Line 1965: ELSIF (p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE) THEN

1961: -- In the Date and Date Time case, use SUBSTR to get around --
1962: -- the strange PL/SQL behavior of adding an initial space to --
1963: -- Dates that have been TO_CHAR'ed --
1964: ---------------------------------------------------------------
1965: ELSIF (p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE) THEN
1966:
1967: l_db_column_alias := 'SUBSTR(TO_CHAR(TRUNC('||p_attr_metadata_obj.DATABASE_COLUMN||'), '''||EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT||'''), 2)';
1968:
1969: ELSIF (p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN

Line 1969: ELSIF (p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN

1965: ELSIF (p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE) THEN
1966:
1967: l_db_column_alias := 'SUBSTR(TO_CHAR(TRUNC('||p_attr_metadata_obj.DATABASE_COLUMN||'), '''||EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT||'''), 2)';
1968:
1969: ELSIF (p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
1970:
1971: l_db_column_alias := 'SUBSTR(TO_CHAR('||p_attr_metadata_obj.DATABASE_COLUMN||', '''||EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT||'''), 2)';
1972:
1973: END IF;

Line 2001: IF (p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN

1997:
1998: -------------------------------------------------------------------------
1999: -- Set up an alias to convert Date, Number values to formatted strings --
2000: -------------------------------------------------------------------------
2001: IF (p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
2002:
2003: l_db_column_alias := 'TO_CHAR('||table_view_alias||'.'||p_attr_metadata_obj.DATABASE_COLUMN||')';
2004:
2005: ---------------------------------------------------------------

Line 2010: ELSIF (p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE) THEN

2006: -- In the Date and Date Time case, use SUBSTR to get around --
2007: -- the strange PL/SQL behavior of adding an initial space to --
2008: -- Dates that have been TO_CHAR'ed --
2009: ---------------------------------------------------------------
2010: ELSIF (p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE) THEN
2011:
2012: l_db_column_alias := 'SUBSTR(TO_CHAR(TRUNC('||table_view_alias||'.'||p_attr_metadata_obj.DATABASE_COLUMN||'), '''||EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT||'''), 2)';
2013:
2014: ELSIF (p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN

Line 2014: ELSIF (p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN

2010: ELSIF (p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE) THEN
2011:
2012: l_db_column_alias := 'SUBSTR(TO_CHAR(TRUNC('||table_view_alias||'.'||p_attr_metadata_obj.DATABASE_COLUMN||'), '''||EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT||'''), 2)';
2013:
2014: ELSIF (p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
2015:
2016: l_db_column_alias := 'SUBSTR(TO_CHAR('||table_view_alias||'.'||p_attr_metadata_obj.DATABASE_COLUMN||', '''||EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT||'''), 2)';
2017:
2018: END IF;