APPS.EGO_USER_ATTRS_COMMON_PVT dependencies on EGO_EXT_FWK_PUB

Line 686: 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

682: l_where_clause LONG;
683:
684: BEGIN
685:
686: 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
687:
688: --------------------------------------------------------------------
689: -- We only use this query, which has the Value Set ID hard-coded, --
690: -- in Get_User_Attrs_Data; elsewhere we use a dynamic version of --

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

698: 'AND (NVL(START_DATE, SYSDATE - 1) < SYSDATE) '||
699: 'AND (NVL(END_DATE, SYSDATE + 1) > SYSDATE) '||
700: 'AND INTERNAL_NAME = ';
701:
702: ELSIF (p_validation_code = EGO_EXT_FWK_PUB.G_TABLE_VALIDATION_CODE) THEN
703: SELECT APPLICATION_TABLE_NAME
704: ,ID_COLUMN_NAME
705: ,VALUE_COLUMN_NAME
706: ,ADDITIONAL_WHERE_CLAUSE

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

933: px_attr_group_metadata_obj.UNIQUE_KEY_ATTRS_COUNT + 1;
934:
935: END IF;
936:
937: IF (attrs_rec.DATA_TYPE = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE) THEN
938:
939: px_attr_group_metadata_obj.TRANS_ATTRS_COUNT :=
940: px_attr_group_metadata_obj.TRANS_ATTRS_COUNT + 1;
941:

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

940: px_attr_group_metadata_obj.TRANS_ATTRS_COUNT + 1;
941:
942: END IF;
943:
944: IF (attrs_rec.VALIDATION_TYPE = EGO_EXT_FWK_PUB.G_INDEPENDENT_VALIDATION_CODE OR
945: attrs_rec.VALIDATION_TYPE = EGO_EXT_FWK_PUB.G_TABLE_VALIDATION_CODE OR
946: attrs_rec.VALIDATION_TYPE = EGO_EXT_FWK_PUB.G_TRANS_IND_VALIDATION_CODE) THEN--Bug fix 4645598
947:
948: -----------------------------------------------------------------

Line 945: attrs_rec.VALIDATION_TYPE = EGO_EXT_FWK_PUB.G_TABLE_VALIDATION_CODE OR

941:
942: END IF;
943:
944: IF (attrs_rec.VALIDATION_TYPE = EGO_EXT_FWK_PUB.G_INDEPENDENT_VALIDATION_CODE OR
945: attrs_rec.VALIDATION_TYPE = EGO_EXT_FWK_PUB.G_TABLE_VALIDATION_CODE OR
946: attrs_rec.VALIDATION_TYPE = EGO_EXT_FWK_PUB.G_TRANS_IND_VALIDATION_CODE) THEN--Bug fix 4645598
947:
948: -----------------------------------------------------------------
949: -- If this Attribute has a Value Set with Internal and Display --

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

942: END IF;
943:
944: IF (attrs_rec.VALIDATION_TYPE = EGO_EXT_FWK_PUB.G_INDEPENDENT_VALIDATION_CODE OR
945: attrs_rec.VALIDATION_TYPE = EGO_EXT_FWK_PUB.G_TABLE_VALIDATION_CODE OR
946: attrs_rec.VALIDATION_TYPE = EGO_EXT_FWK_PUB.G_TRANS_IND_VALIDATION_CODE) THEN--Bug fix 4645598
947:
948: -----------------------------------------------------------------
949: -- If this Attribute has a Value Set with Internal and Display --
950: -- Values, we build SQL to transform one into the other (and --

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

1841:
1842: -------------------------------------------------------------------------
1843: -- Set up an alias to convert Date, Number values to formatted strings --
1844: -------------------------------------------------------------------------
1845: IF (p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
1846:
1847: l_db_column_alias := 'TO_CHAR('||p_attr_metadata_obj.DATABASE_COLUMN||')';
1848:
1849: ---------------------------------------------------------------

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

1850: -- In the Date and Date Time case, use SUBSTR to get around --
1851: -- the strange PL/SQL behavior of adding an initial space to --
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

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

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)';
1861:
1862: END IF;