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_DATA_PVT dependencies on EGO_EXT_FWK_PUB

Line 2079: l_data_type = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE) OR

2075: -----------------------------------------------------------------
2076: IF ((UPPER(p_which_attrs) = 'ALL') OR
2077: (UPPER(p_which_attrs) = 'UNIQUE_KEY' AND l_unique_key_flag = 'Y') OR
2078: (UPPER(p_which_attrs) = 'TRANS' AND
2079: l_data_type = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE) OR
2080: (UPPER(p_which_attrs) = 'NONTRANS' AND
2081: l_data_type <> EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE)) THEN
2082:
2083: ---------------------------------------------------------------------------

Line 2081: l_data_type <> EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE)) THEN

2077: (UPPER(p_which_attrs) = 'UNIQUE_KEY' AND l_unique_key_flag = 'Y') OR
2078: (UPPER(p_which_attrs) = 'TRANS' AND
2079: l_data_type = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE) OR
2080: (UPPER(p_which_attrs) = 'NONTRANS' AND
2081: l_data_type <> EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE)) THEN
2082:
2083: ---------------------------------------------------------------------------
2084: -- Reset UOM, column name, default and value variables each time through --
2085: ---------------------------------------------------------------------------

Line 2102: l_data_type = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE OR

2098: ---------------------------------------------------------------
2099: -- First, try to use the value appropriate for the data type --
2100: ---------------------------------------------------------------
2101: IF (l_data_type IS NULL OR
2102: l_data_type = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE OR
2103: l_data_type = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE) THEN
2104:
2105: l_candidate_value := l_attr_data_obj.ATTR_VALUE_STR;
2106: Debug_Msg('Candidate value:'||l_candidate_value);

Line 2103: l_data_type = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE) THEN

2099: -- First, try to use the value appropriate for the data type --
2100: ---------------------------------------------------------------
2101: IF (l_data_type IS NULL OR
2102: l_data_type = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE OR
2103: l_data_type = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE) THEN
2104:
2105: l_candidate_value := l_attr_data_obj.ATTR_VALUE_STR;
2106: Debug_Msg('Candidate value:'||l_candidate_value);
2107:

Line 2108: ELSIF (l_data_type = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN

2104:
2105: l_candidate_value := l_attr_data_obj.ATTR_VALUE_STR;
2106: Debug_Msg('Candidate value:'||l_candidate_value);
2107:
2108: ELSIF (l_data_type = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
2109:
2110: l_candidate_value := TO_CHAR(l_attr_data_obj.ATTR_VALUE_NUM);
2111:
2112: --------------------------------------------------------------------

Line 2126: ELSIF (l_data_type = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE) THEN

2122: l_uom_value := '''' || l_attr_data_obj.ATTR_UNIT_OF_MEASURE || '''';
2123:
2124: END IF;
2125:
2126: ELSIF (l_data_type = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE) THEN
2127:
2128: l_candidate_value := TO_CHAR(TRUNC(l_attr_data_obj.ATTR_VALUE_DATE),
2129: EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);
2130:

Line 2131: ELSIF (l_data_type = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN

2127:
2128: l_candidate_value := TO_CHAR(TRUNC(l_attr_data_obj.ATTR_VALUE_DATE),
2129: EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);
2130:
2131: ELSIF (l_data_type = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
2132:
2133: l_candidate_value := TO_CHAR(l_attr_data_obj.ATTR_VALUE_DATE,
2134: EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);
2135:

Line 2147: IF ((l_data_type = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR

2143:
2144: ---------------------------------------
2145: -- Format default value if necessary --
2146: ---------------------------------------
2147: IF ((l_data_type = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR
2148: l_data_type = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) AND
2149: INSTR(UPPER(l_default_value), 'SYSDATE') > 0) THEN
2150: l_default_value := Format_Sysdate_Expression(l_default_value);
2151: END IF;

Line 2148: l_data_type = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) AND

2144: ---------------------------------------
2145: -- Format default value if necessary --
2146: ---------------------------------------
2147: IF ((l_data_type = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR
2148: l_data_type = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) AND
2149: INSTR(UPPER(l_default_value), 'SYSDATE') > 0) THEN
2150: l_default_value := Format_Sysdate_Expression(l_default_value);
2151: END IF;
2152:

Line 2205: l_data_type = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE OR

2201:
2202: FND_DSQL.Add_Text(' NULL ');
2203:
2204: ELSIF (l_data_type IS NULL OR
2205: l_data_type = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE OR
2206: l_data_type = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE) THEN
2207:
2208: /* Bug 9204753. RTRIM() the Attribute Value, for Char and Translatable Text Data Types,
2209: before adding it to SQL statement, so that spaces at the end will be truncated. */

Line 2206: l_data_type = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE) THEN

2202: FND_DSQL.Add_Text(' NULL ');
2203:
2204: ELSIF (l_data_type IS NULL OR
2205: l_data_type = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE OR
2206: l_data_type = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE) THEN
2207:
2208: /* Bug 9204753. RTRIM() the Attribute Value, for Char and Translatable Text Data Types,
2209: before adding it to SQL statement, so that spaces at the end will be truncated. */
2210: Add_Bind(p_bind_identifier => l_attr_metadata_obj.ATTR_GROUP_NAME||'$$'||l_attr_metadata_obj.ATTR_NAME

Line 2213: ELSIF (l_data_type = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN

2209: before adding it to SQL statement, so that spaces at the end will be truncated. */
2210: Add_Bind(p_bind_identifier => l_attr_metadata_obj.ATTR_GROUP_NAME||'$$'||l_attr_metadata_obj.ATTR_NAME
2211: ,p_value => RTRIM(l_candidate_value));
2212:
2213: ELSIF (l_data_type = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
2214:
2215: Add_Bind(p_bind_identifier => l_attr_metadata_obj.ATTR_GROUP_NAME||'$$'||l_attr_metadata_obj.ATTR_NAME
2216: ,p_value => TO_NUMBER(l_candidate_value));
2217:

Line 2218: ELSIF (l_data_type = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR

2214:
2215: Add_Bind(p_bind_identifier => l_attr_metadata_obj.ATTR_GROUP_NAME||'$$'||l_attr_metadata_obj.ATTR_NAME
2216: ,p_value => TO_NUMBER(l_candidate_value));
2217:
2218: ELSIF (l_data_type = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR
2219: l_data_type = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
2220:
2221: Add_Bind(p_bind_identifier => l_attr_metadata_obj.ATTR_GROUP_NAME||'$$'||l_attr_metadata_obj.ATTR_NAME
2222: ,p_value => TO_DATE(l_candidate_value, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT));

Line 2219: l_data_type = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN

2215: Add_Bind(p_bind_identifier => l_attr_metadata_obj.ATTR_GROUP_NAME||'$$'||l_attr_metadata_obj.ATTR_NAME
2216: ,p_value => TO_NUMBER(l_candidate_value));
2217:
2218: ELSIF (l_data_type = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR
2219: l_data_type = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
2220:
2221: Add_Bind(p_bind_identifier => l_attr_metadata_obj.ATTR_GROUP_NAME||'$$'||l_attr_metadata_obj.ATTR_NAME
2222: ,p_value => TO_DATE(l_candidate_value, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT));
2223:

Line 2599: IF (p_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_TABLE_VALIDATION_CODE) THEN

2595: --------------------------------------------------------------------------------
2596: -- We only process the query if the Attribute has a Value Set of type "Table" --
2597: -- (because that's the only case in which there may be tokens to replace) --
2598: --------------------------------------------------------------------------------
2599: IF (p_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_TABLE_VALIDATION_CODE) THEN
2600:
2601: l_has_tokens_left := (INSTR(UPPER(l_tail_of_query), ':$OBJECT$.') > 0 OR
2602: INSTR(UPPER(l_tail_of_query), ':$ATTRIBUTEGROUP$.') > 0);
2603:

Line 2759: l_replacement_attr_metadata.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE OR

2755:
2756: IF (l_replacement_attr_data IS NOT NULL) THEN
2757:
2758: IF (l_replacement_attr_metadata.DATA_TYPE_CODE IS NULL OR
2759: l_replacement_attr_metadata.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE OR
2760: l_replacement_attr_metadata.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE) THEN
2761:
2762: /* FP bug 8499883 with base bug 8215594
2763: l_token_replacement := l_replacement_attr_data.ATTR_VALUE_STR; */

Line 2760: l_replacement_attr_metadata.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE) THEN

2756: IF (l_replacement_attr_data IS NOT NULL) THEN
2757:
2758: IF (l_replacement_attr_metadata.DATA_TYPE_CODE IS NULL OR
2759: l_replacement_attr_metadata.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE OR
2760: l_replacement_attr_metadata.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE) THEN
2761:
2762: /* FP bug 8499883 with base bug 8215594
2763: l_token_replacement := l_replacement_attr_data.ATTR_VALUE_STR; */
2764: l_token_replacement := nvl(l_replacement_attr_data.ATTR_VALUE_STR,l_replacement_attr_data.ATTR_DISP_VALUE);

Line 2766: ELSIF (l_replacement_attr_metadata.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN

2762: /* FP bug 8499883 with base bug 8215594
2763: l_token_replacement := l_replacement_attr_data.ATTR_VALUE_STR; */
2764: l_token_replacement := nvl(l_replacement_attr_data.ATTR_VALUE_STR,l_replacement_attr_data.ATTR_DISP_VALUE);
2765:
2766: ELSIF (l_replacement_attr_metadata.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
2767:
2768: l_token_replacement := TO_CHAR(l_replacement_attr_data.ATTR_VALUE_NUM);
2769:
2770: ELSIF (l_replacement_attr_metadata.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR

Line 2770: ELSIF (l_replacement_attr_metadata.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR

2766: ELSIF (l_replacement_attr_metadata.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
2767:
2768: l_token_replacement := TO_CHAR(l_replacement_attr_data.ATTR_VALUE_NUM);
2769:
2770: ELSIF (l_replacement_attr_metadata.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR
2771: l_replacement_attr_metadata.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
2772:
2773: l_token_replacement := TO_CHAR(l_replacement_attr_data.ATTR_VALUE_DATE, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);
2774:

Line 2771: l_replacement_attr_metadata.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN

2767:
2768: l_token_replacement := TO_CHAR(l_replacement_attr_data.ATTR_VALUE_NUM);
2769:
2770: ELSIF (l_replacement_attr_metadata.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR
2771: l_replacement_attr_metadata.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
2772:
2773: l_token_replacement := TO_CHAR(l_replacement_attr_data.ATTR_VALUE_DATE, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);
2774:
2775: END IF;

Line 2787: (l_replacement_attr_metadata.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_TABLE_VALIDATION_CODE OR

2783: -- possibly tricky pseudo-recursion --
2784: -----------------------------------------------------------------------
2785: --for bug 10428782, if l_token_replacement is still a display value from a value set, we need get internal value for it.
2786: IF ((l_token_replacement IS NULL or
2787: (l_replacement_attr_metadata.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_TABLE_VALIDATION_CODE OR
2788: l_replacement_attr_metadata.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_TRANS_IND_VALIDATION_CODE OR
2789: l_replacement_attr_metadata.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_INDEPENDENT_VALIDATION_CODE)) AND
2790: l_replacement_attr_data.ATTR_DISP_VALUE IS NOT NULL AND
2791: (l_replacement_attr_metadata.VS_BIND_VALUES_CODE IS NULL OR

Line 2788: l_replacement_attr_metadata.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_TRANS_IND_VALIDATION_CODE OR

2784: -----------------------------------------------------------------------
2785: --for bug 10428782, if l_token_replacement is still a display value from a value set, we need get internal value for it.
2786: IF ((l_token_replacement IS NULL or
2787: (l_replacement_attr_metadata.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_TABLE_VALIDATION_CODE OR
2788: l_replacement_attr_metadata.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_TRANS_IND_VALIDATION_CODE OR
2789: l_replacement_attr_metadata.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_INDEPENDENT_VALIDATION_CODE)) AND
2790: l_replacement_attr_data.ATTR_DISP_VALUE IS NOT NULL AND
2791: (l_replacement_attr_metadata.VS_BIND_VALUES_CODE IS NULL OR
2792: l_replacement_attr_metadata.VS_BIND_VALUES_CODE = 'N' OR

Line 2789: l_replacement_attr_metadata.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_INDEPENDENT_VALIDATION_CODE)) AND

2785: --for bug 10428782, if l_token_replacement is still a display value from a value set, we need get internal value for it.
2786: IF ((l_token_replacement IS NULL or
2787: (l_replacement_attr_metadata.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_TABLE_VALIDATION_CODE OR
2788: l_replacement_attr_metadata.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_TRANS_IND_VALIDATION_CODE OR
2789: l_replacement_attr_metadata.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_INDEPENDENT_VALIDATION_CODE)) AND
2790: l_replacement_attr_data.ATTR_DISP_VALUE IS NOT NULL AND
2791: (l_replacement_attr_metadata.VS_BIND_VALUES_CODE IS NULL OR
2792: l_replacement_attr_metadata.VS_BIND_VALUES_CODE = 'N' OR
2793: l_replacement_attr_metadata.VS_BIND_VALUES_CODE = 'O')) THEN --bug 13478195

Line 2949: IF (p_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_INDEPENDENT_VALIDATION_CODE OR

2945: l_disp_value := p_attr_value_obj.ATTR_DISP_VALUE;
2946:
2947: Debug_Msg('In Get_Int_Val_For_Disp_Val, starting for l_disp_value '||l_disp_value, 2);
2948:
2949: IF (p_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_INDEPENDENT_VALIDATION_CODE OR
2950: p_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_TRANS_IND_VALIDATION_CODE ) THEN
2951: --PERF TUNING 4957648
2952: l_dynamic_sql := 'SELECT DISTINCT FLEX_VALUE '||
2953: ' FROM FND_FLEX_VALUES_VL '||

Line 2950: p_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_TRANS_IND_VALIDATION_CODE ) THEN

2946:
2947: Debug_Msg('In Get_Int_Val_For_Disp_Val, starting for l_disp_value '||l_disp_value, 2);
2948:
2949: IF (p_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_INDEPENDENT_VALIDATION_CODE OR
2950: p_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_TRANS_IND_VALIDATION_CODE ) THEN
2951: --PERF TUNING 4957648
2952: l_dynamic_sql := 'SELECT DISTINCT FLEX_VALUE '||
2953: ' FROM FND_FLEX_VALUES_VL '||
2954: ' WHERE FLEX_VALUE_SET_ID = :1 '||

Line 2964: ELSIF (p_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_TABLE_VALIDATION_CODE) THEN

2960: EXECUTE IMMEDIATE l_dynamic_sql
2961: INTO l_int_value
2962: USING p_attr_metadata_obj.VALUE_SET_ID, l_disp_value;
2963:
2964: ELSIF (p_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_TABLE_VALIDATION_CODE) THEN
2965:
2966: ---------------------------------------------------------------------
2967: -- If the Table Value Set doesn't have an Additional Where Clause --
2968: -- with bind values, we can go ahead and execute the query without --

Line 3060: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE OR

3056:
3057: l_attr_int_value := p_attr_int_value;
3058:
3059: ELSIF (p_attr_metadata_obj.DATA_TYPE_CODE IS NULL OR
3060: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE OR
3061: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE) THEN
3062:
3063: l_attr_int_value := p_attr_value_obj.ATTR_VALUE_STR;
3064:

Line 3061: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE) THEN

3057: l_attr_int_value := p_attr_int_value;
3058:
3059: ELSIF (p_attr_metadata_obj.DATA_TYPE_CODE IS NULL OR
3060: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE OR
3061: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE) THEN
3062:
3063: l_attr_int_value := p_attr_value_obj.ATTR_VALUE_STR;
3064:
3065: ELSIF (p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN

Line 3065: ELSIF (p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN

3061: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE) THEN
3062:
3063: l_attr_int_value := p_attr_value_obj.ATTR_VALUE_STR;
3064:
3065: ELSIF (p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
3066:
3067: l_attr_int_value := TO_CHAR(p_attr_value_obj.ATTR_VALUE_NUM);
3068:
3069: ELSIF (p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR

Line 3069: ELSIF (p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR

3065: ELSIF (p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
3066:
3067: l_attr_int_value := TO_CHAR(p_attr_value_obj.ATTR_VALUE_NUM);
3068:
3069: ELSIF (p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR
3070: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
3071:
3072: l_attr_int_value := TO_CHAR(p_attr_value_obj.ATTR_VALUE_DATE, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);
3073:

Line 3070: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN

3066:
3067: l_attr_int_value := TO_CHAR(p_attr_value_obj.ATTR_VALUE_NUM);
3068:
3069: ELSIF (p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR
3070: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
3071:
3072: l_attr_int_value := TO_CHAR(p_attr_value_obj.ATTR_VALUE_DATE, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);
3073:
3074: END IF;

Line 3083: IF (p_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_INDEPENDENT_VALIDATION_CODE OR

3079: -- Next we handle the simple cases (i.e., all queries without an --
3080: -- Additional Where Clause containing user-defined bind values) --
3081: -------------------------------------------------------------------
3082: -- fix for bug 4543638 included translatable independent validation code to get disp value
3083: IF (p_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_INDEPENDENT_VALIDATION_CODE OR
3084: p_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_TRANS_IND_VALIDATION_CODE
3085: ) THEN
3086:
3087: ---------------------------------------------------------------

Line 3084: p_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_TRANS_IND_VALIDATION_CODE

3080: -- Additional Where Clause containing user-defined bind values) --
3081: -------------------------------------------------------------------
3082: -- fix for bug 4543638 included translatable independent validation code to get disp value
3083: IF (p_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_INDEPENDENT_VALIDATION_CODE OR
3084: p_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_TRANS_IND_VALIDATION_CODE
3085: ) THEN
3086:
3087: ---------------------------------------------------------------
3088: -- Even though our Attribute metadata object has this query --

Line 3096: IF(p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN --bug 14268474

3092: -- version is only for use in Get_User_Attrs_Data --
3093: ---------------------------------------------------------------
3094: --PERF TUNING 4957648
3095:
3096: IF(p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN --bug 14268474
3097:
3098: l_val_set_query := 'SELECT DISTINCT FLEX_VALUE_MEANING '||
3099: ' FROM FND_FLEX_VALUES_VL '||
3100: ' WHERE FLEX_VALUE_SET_ID = :1 '||

Line 3121: ELSIF (p_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_TABLE_VALIDATION_CODE AND

3117: EXECUTE IMMEDIATE l_val_set_query
3118: INTO l_attr_disp_value
3119: USING p_attr_metadata_obj.VALUE_SET_ID, l_attr_int_value;
3120:
3121: ELSIF (p_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_TABLE_VALIDATION_CODE AND
3122: (p_attr_metadata_obj.VS_BIND_VALUES_CODE IS NULL OR
3123: p_attr_metadata_obj.VS_BIND_VALUES_CODE = 'N')) THEN
3124:
3125: EXECUTE IMMEDIATE p_attr_metadata_obj.INT_TO_DISP_VAL_QUERY||' :1 AND ROWNUM < 2'

Line 3595: l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE OR

3591: -----------------------------------------------------
3592: IF (l_attr_metadata_obj.UNIQUE_KEY_FLAG = 'Y') THEN
3593:
3594: IF (l_attr_metadata_obj.DATA_TYPE_CODE IS NULL OR
3595: l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE OR
3596: l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE) THEN
3597:
3598: l_uk_attr_values_table(l_uk_attr_values_table_index) := Fetch_UK_Attr_Display_Values(p_attr_group_metadata_obj,
3599: p_ext_table_metadata_obj,

Line 3596: l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE) THEN

3592: IF (l_attr_metadata_obj.UNIQUE_KEY_FLAG = 'Y') THEN
3593:
3594: IF (l_attr_metadata_obj.DATA_TYPE_CODE IS NULL OR
3595: l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE OR
3596: l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE) THEN
3597:
3598: l_uk_attr_values_table(l_uk_attr_values_table_index) := Fetch_UK_Attr_Display_Values(p_attr_group_metadata_obj,
3599: p_ext_table_metadata_obj,
3600: p_pk_column_name_value_pairs,

Line 3609: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN

3605: p_attr_name_value_pairs,
3606: p_attr_name_value_pairs(l_table_index)
3607: .ATTR_VALUE_STR,
3608: l_table_index);
3609: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
3610:
3611: l_uk_attr_values_table(l_uk_attr_values_table_index) := Fetch_UK_Attr_Display_Values(p_attr_group_metadata_obj,
3612: p_ext_table_metadata_obj,
3613: p_pk_column_name_value_pairs,

Line 3623: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR

3619: p_attr_name_value_pairs(l_table_index)
3620: .ATTR_VALUE_NUM,
3621: l_table_index);
3622:
3623: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR
3624: l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
3625:
3626: l_uk_attr_values_table(l_uk_attr_values_table_index) := Fetch_UK_Attr_Display_Values(p_attr_group_metadata_obj,
3627: p_ext_table_metadata_obj,

Line 3624: l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN

3620: .ATTR_VALUE_NUM,
3621: l_table_index);
3622:
3623: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR
3624: l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
3625:
3626: l_uk_attr_values_table(l_uk_attr_values_table_index) := Fetch_UK_Attr_Display_Values(p_attr_group_metadata_obj,
3627: p_ext_table_metadata_obj,
3628: p_pk_column_name_value_pairs,

Line 4937: SELECT EGO_EXT_FWK_PUB.Get_Class_Meaning(p_object_id, p_class_code_name_value_pairs(1).VALUE)

4933: x_token_table(1).TOKEN_NAME := 'AG_NAME';
4934: x_token_table(1).TOKEN_VALUE := p_attr_group_disp_name;
4935: x_token_table(2).TOKEN_NAME := 'CLASS_MEANING';
4936: BEGIN
4937: SELECT EGO_EXT_FWK_PUB.Get_Class_Meaning(p_object_id, p_class_code_name_value_pairs(1).VALUE)
4938: INTO x_token_table(2).TOKEN_VALUE
4939: FROM DUAL;
4940: EXCEPTION
4941: WHEN OTHERS THEN

Line 4962: NOT (p_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_INDEPENDENT_VALIDATION_CODE OR

4958:
4959: Debug_Msg('In Disp_Val_Replacement_Is_Bad, starting', 2);
4960:
4961: IF (p_attr_metadata_obj.VALIDATION_CODE IS NULL OR
4962: NOT (p_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_INDEPENDENT_VALIDATION_CODE OR
4963: p_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_TABLE_VALIDATION_CODE)) THEN
4964:
4965: IF (px_attr_value_obj.ATTR_DISP_VALUE IS NOT NULL) THEN
4966:

Line 4963: p_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_TABLE_VALIDATION_CODE)) THEN

4959: Debug_Msg('In Disp_Val_Replacement_Is_Bad, starting', 2);
4960:
4961: IF (p_attr_metadata_obj.VALIDATION_CODE IS NULL OR
4962: NOT (p_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_INDEPENDENT_VALIDATION_CODE OR
4963: p_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_TABLE_VALIDATION_CODE)) THEN
4964:
4965: IF (px_attr_value_obj.ATTR_DISP_VALUE IS NOT NULL) THEN
4966:
4967: IF ((p_attr_metadata_obj.DATA_TYPE_CODE IS NULL OR

Line 4968: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE OR

4964:
4965: IF (px_attr_value_obj.ATTR_DISP_VALUE IS NOT NULL) THEN
4966:
4967: IF ((p_attr_metadata_obj.DATA_TYPE_CODE IS NULL OR
4968: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE OR
4969: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE) AND
4970: px_attr_value_obj.ATTR_VALUE_STR IS NULL) THEN
4971:
4972: Debug_Msg('In Disp_Val_Replacement_Is_Bad, putting '||

Line 4969: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE) AND

4965: IF (px_attr_value_obj.ATTR_DISP_VALUE IS NOT NULL) THEN
4966:
4967: IF ((p_attr_metadata_obj.DATA_TYPE_CODE IS NULL OR
4968: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE OR
4969: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE) AND
4970: px_attr_value_obj.ATTR_VALUE_STR IS NULL) THEN
4971:
4972: Debug_Msg('In Disp_Val_Replacement_Is_Bad, putting '||
4973: px_attr_value_obj.ATTR_DISP_VALUE||

Line 4977: ELSIF (p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE AND

4973: px_attr_value_obj.ATTR_DISP_VALUE||
4974: ' into ATTR_VALUE_STR column', 3);
4975: px_attr_value_obj.ATTR_VALUE_STR := px_attr_value_obj.ATTR_DISP_VALUE;
4976:
4977: ELSIF (p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE AND
4978: px_attr_value_obj.ATTR_VALUE_NUM IS NULL) THEN
4979:
4980: Debug_Msg('In Disp_Val_Replacement_Is_Bad, putting '||
4981: px_attr_value_obj.ATTR_DISP_VALUE||

Line 5005: ELSIF (p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE AND

5001: END IF;
5002: px_attr_value_obj.ATTR_VALUE_NUM := l_conv_rate * TO_NUMBER(px_attr_value_obj.ATTR_DISP_VALUE);
5003: -- Bug 16502567 End
5004:
5005: ELSIF (p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE AND
5006: px_attr_value_obj.ATTR_VALUE_DATE IS NULL) THEN
5007:
5008: Debug_Msg('In Disp_Val_Replacement_Is_Bad, putting '||
5009: px_attr_value_obj.ATTR_DISP_VALUE||

Line 5013: ELSIF (p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE AND

5009: px_attr_value_obj.ATTR_DISP_VALUE||
5010: ' into ATTR_VALUE_DATE column', 3);
5011: px_attr_value_obj.ATTR_VALUE_DATE := TRUNC(TO_DATE(px_attr_value_obj.ATTR_DISP_VALUE, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT));
5012:
5013: ELSIF (p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE AND
5014: px_attr_value_obj.ATTR_VALUE_DATE IS NULL) THEN
5015:
5016: Debug_Msg('In Disp_Val_Replacement_Is_Bad, putting '||
5017: px_attr_value_obj.ATTR_DISP_VALUE||

Line 5063: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE OR

5059:
5060: Debug_Msg('In Is_Required_Flag_Respected, starting', 2);
5061:
5062: IF (p_attr_metadata_obj.DATA_TYPE_CODE IS NULL OR
5063: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE OR
5064: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE) THEN
5065: l_value := p_attr_value_obj.ATTR_VALUE_STR;
5066: ELSIF (p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
5067: l_value := p_attr_value_obj.ATTR_VALUE_NUM;

Line 5064: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE) THEN

5060: Debug_Msg('In Is_Required_Flag_Respected, starting', 2);
5061:
5062: IF (p_attr_metadata_obj.DATA_TYPE_CODE IS NULL OR
5063: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE OR
5064: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE) THEN
5065: l_value := p_attr_value_obj.ATTR_VALUE_STR;
5066: ELSIF (p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
5067: l_value := p_attr_value_obj.ATTR_VALUE_NUM;
5068: ELSE

Line 5066: ELSIF (p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN

5062: IF (p_attr_metadata_obj.DATA_TYPE_CODE IS NULL OR
5063: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE OR
5064: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE) THEN
5065: l_value := p_attr_value_obj.ATTR_VALUE_STR;
5066: ELSIF (p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
5067: l_value := p_attr_value_obj.ATTR_VALUE_NUM;
5068: ELSE
5069: l_value := p_attr_value_obj.ATTR_VALUE_DATE;
5070: END IF;

Line 5080: (p_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_INDEPENDENT_VALIDATION_CODE OR

5076: -- Display Value (which we will later convert to an Internal --
5077: -- Value in Is_Value_Set_Respected) --
5078: ------------------------------------------------------------------
5079: IF (l_value IS NULL AND
5080: (p_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_INDEPENDENT_VALIDATION_CODE OR
5081: p_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_TRANS_IND_VALIDATION_CODE OR
5082: p_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_TABLE_VALIDATION_CODE)) THEN
5083: l_value := p_attr_value_obj.ATTR_DISP_VALUE;
5084: END IF;

Line 5081: p_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_TRANS_IND_VALIDATION_CODE OR

5077: -- Value in Is_Value_Set_Respected) --
5078: ------------------------------------------------------------------
5079: IF (l_value IS NULL AND
5080: (p_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_INDEPENDENT_VALIDATION_CODE OR
5081: p_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_TRANS_IND_VALIDATION_CODE OR
5082: p_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_TABLE_VALIDATION_CODE)) THEN
5083: l_value := p_attr_value_obj.ATTR_DISP_VALUE;
5084: END IF;
5085:

Line 5082: p_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_TABLE_VALIDATION_CODE)) THEN

5078: ------------------------------------------------------------------
5079: IF (l_value IS NULL AND
5080: (p_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_INDEPENDENT_VALIDATION_CODE OR
5081: p_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_TRANS_IND_VALIDATION_CODE OR
5082: p_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_TABLE_VALIDATION_CODE)) THEN
5083: l_value := p_attr_value_obj.ATTR_DISP_VALUE;
5084: END IF;
5085:
5086: --------------------------------------------------------------

Line 5137: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE OR

5133:
5134: IF
5135: (
5136: (
5137: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE OR
5138: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE
5139: ) AND
5140: (
5141: p_attr_value_obj.ATTR_VALUE_STR IS NULL AND

Line 5138: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE

5134: IF
5135: (
5136: (
5137: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE OR
5138: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE
5139: ) AND
5140: (
5141: p_attr_value_obj.ATTR_VALUE_STR IS NULL AND
5142: (

Line 5154: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE

5150: TO_CHAR(p_attr_value_obj.ATTR_VALUE_DATE, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT));
5151:
5152: ELSIF (
5153: (
5154: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE
5155: ) AND
5156: (
5157: p_attr_value_obj.ATTR_VALUE_NUM IS NULL AND
5158: (

Line 5170: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR

5166: TO_CHAR(p_attr_value_obj.ATTR_VALUE_DATE, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT));
5167:
5168: ELSIF (
5169: (
5170: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR
5171: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE
5172: ) AND
5173: (
5174: p_attr_value_obj.ATTR_VALUE_DATE IS NULL AND

Line 5171: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE

5167:
5168: ELSIF (
5169: (
5170: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR
5171: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE
5172: ) AND
5173: (
5174: p_attr_value_obj.ATTR_VALUE_DATE IS NULL AND
5175: (

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

5240:
5241: -----------------
5242: -- Number case --
5243: -----------------
5244: IF (p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
5245:
5246: IF ((p_min_or_max = 'MIN' AND
5247: p_attr_value_obj.ATTR_VALUE_NUM < TO_NUMBER(l_value_bound_string)) OR
5248: (p_min_or_max = 'MAX' AND

Line 5256: ELSIF (p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR

5252:
5253: ---------------
5254: -- Date case --
5255: ---------------
5256: ELSIF (p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR
5257: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
5258:
5259: -----------------------------------------------------------------
5260: -- We store Min/Max Values in Timestamp format, which includes --

Line 5257: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN

5253: ---------------
5254: -- Date case --
5255: ---------------
5256: ELSIF (p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR
5257: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
5258:
5259: -----------------------------------------------------------------
5260: -- We store Min/Max Values in Timestamp format, which includes --
5261: -- a decimal millisecond component; but since the TO_DATE --

Line 5280: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE AND

5276:
5277: IF (
5278: (
5279: (
5280: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE AND
5281: (
5282: p_min_or_max = 'MIN' AND
5283: p_attr_value_obj.ATTR_VALUE_DATE < TRUNC(TO_DATE(l_value_bound_string, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT))
5284: )

Line 5295: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE AND

5291: )
5292: OR
5293: (
5294: (
5295: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE AND
5296: (
5297: p_min_or_max = 'MIN' AND
5298: p_attr_value_obj.ATTR_VALUE_DATE < TO_DATE(l_value_bound_string, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT)
5299: )

Line 5360: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE OR

5356: -- than the number of bytes (for multi-byte support). --
5357: ---------------------------------------------------------------
5358:
5359: IF (p_attr_metadata_obj.DATA_TYPE_CODE IS NULL OR
5360: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE OR
5361: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE) THEN
5362:
5363: IF (p_attr_metadata_obj.MAXIMUM_SIZE > 0 AND
5364: p_attr_metadata_obj.MAXIMUM_SIZE <

Line 5361: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE) THEN

5357: ---------------------------------------------------------------
5358:
5359: IF (p_attr_metadata_obj.DATA_TYPE_CODE IS NULL OR
5360: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE OR
5361: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE) THEN
5362:
5363: IF (p_attr_metadata_obj.MAXIMUM_SIZE > 0 AND
5364: p_attr_metadata_obj.MAXIMUM_SIZE <
5365: LENGTHB(p_attr_value_obj.ATTR_VALUE_STR)) THEN --for bug 9748517, use byte size to determin size for multi-byte language

Line 5370: ELSIF (p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN

5366: l_is_max_size_respected := FALSE;
5367: l_value := p_attr_value_obj.ATTR_VALUE_STR;
5368: END IF;
5369:
5370: ELSIF (p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
5371:
5372: IF (p_attr_metadata_obj.MAXIMUM_SIZE > 0 AND
5373: p_attr_metadata_obj.MAXIMUM_SIZE <
5374: LENGTH(TO_CHAR(p_attr_value_obj.ATTR_VALUE_NUM))) THEN

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

5493: ,'MIN');
5494:
5495: IF (NOT l_is_val_set_respected) THEN
5496:
5497: IF (p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
5498:
5499: l_err_msg_name := 'EGO_EF_MIN_VAL_NUM_VIOLATED';
5500:
5501: l_token_table(1).TOKEN_NAME := 'ATTR_NAME';

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

5525: ,'MAX');
5526:
5527: IF (NOT l_is_val_set_respected) THEN
5528:
5529: IF (p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
5530:
5531: l_err_msg_name := 'EGO_EF_MAX_VAL_NUM_VIOLATED';
5532:
5533: l_token_table(1).TOKEN_NAME := 'ATTR_NAME';

Line 5560: ELSIF (p_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_INDEPENDENT_VALIDATION_CODE OR

5556: -- If the Attribute has a Value Set whose Values have different Internal --
5557: -- and Display Values, we need to validate the passed-in value (which has --
5558: -- to be either an Internal Value or a Display Value for the Value Set) --
5559: ----------------------------------------------------------------------------
5560: ELSIF (p_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_INDEPENDENT_VALIDATION_CODE OR
5561: p_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_TRANS_IND_VALIDATION_CODE OR
5562: p_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_TABLE_VALIDATION_CODE) THEN
5563:
5564: -------------------------------------------

Line 5561: p_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_TRANS_IND_VALIDATION_CODE OR

5557: -- and Display Values, we need to validate the passed-in value (which has --
5558: -- to be either an Internal Value or a Display Value for the Value Set) --
5559: ----------------------------------------------------------------------------
5560: ELSIF (p_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_INDEPENDENT_VALIDATION_CODE OR
5561: p_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_TRANS_IND_VALIDATION_CODE OR
5562: p_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_TABLE_VALIDATION_CODE) THEN
5563:
5564: -------------------------------------------
5565: -- If the user passed the Display Value, --

Line 5562: p_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_TABLE_VALIDATION_CODE) THEN

5558: -- to be either an Internal Value or a Display Value for the Value Set) --
5559: ----------------------------------------------------------------------------
5560: ELSIF (p_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_INDEPENDENT_VALIDATION_CODE OR
5561: p_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_TRANS_IND_VALIDATION_CODE OR
5562: p_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_TABLE_VALIDATION_CODE) THEN
5563:
5564: -------------------------------------------
5565: -- If the user passed the Display Value, --
5566: -- we will try to get the Internal Value --

Line 5588: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE OR

5584: );
5585:
5586: IF (l_int_value IS NOT NULL) THEN
5587: IF (p_attr_metadata_obj.DATA_TYPE_CODE IS NULL OR
5588: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE OR
5589: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE) THEN
5590:
5591: px_attr_value_obj.ATTR_VALUE_STR := l_int_value;
5592:

Line 5589: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE) THEN

5585:
5586: IF (l_int_value IS NOT NULL) THEN
5587: IF (p_attr_metadata_obj.DATA_TYPE_CODE IS NULL OR
5588: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE OR
5589: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE) THEN
5590:
5591: px_attr_value_obj.ATTR_VALUE_STR := l_int_value;
5592:
5593: ELSIF (p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN

Line 5593: ELSIF (p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN

5589: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE) THEN
5590:
5591: px_attr_value_obj.ATTR_VALUE_STR := l_int_value;
5592:
5593: ELSIF (p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
5594:
5595: px_attr_value_obj.ATTR_VALUE_NUM := TO_NUMBER(l_int_value);
5596:
5597: ELSIF (p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE) THEN

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

5593: ELSIF (p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
5594:
5595: px_attr_value_obj.ATTR_VALUE_NUM := TO_NUMBER(l_int_value);
5596:
5597: ELSIF (p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE) THEN
5598:
5599: px_attr_value_obj.ATTR_VALUE_DATE := TRUNC(TO_DATE(l_int_value, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT));
5600:
5601: ELSIF (p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN

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

5597: ELSIF (p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE) THEN
5598:
5599: px_attr_value_obj.ATTR_VALUE_DATE := TRUNC(TO_DATE(l_int_value, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT));
5600:
5601: ELSIF (p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
5602:
5603: px_attr_value_obj.ATTR_VALUE_DATE := TO_DATE(l_int_value, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);
5604:
5605: END IF;

Line 5982: IF ((l_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_INDEPENDENT_VALIDATION_CODE OR

5978: -- and display values, we only want to try getting the internal value if --
5979: -- the caller has passed in the display value and nothing else; otherwise --
5980: -- we want to use the passed-in internal value and thus avoid a query. --
5981: ----------------------------------------------------------------------------
5982: IF ((l_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_INDEPENDENT_VALIDATION_CODE OR
5983: l_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_TRANS_IND_VALIDATION_CODE OR
5984: l_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_TABLE_VALIDATION_CODE) AND
5985: (px_attr_name_value_pairs(l_attr_value_index).ATTR_DISP_VALUE IS NOT NULL) AND
5986: (px_attr_name_value_pairs(l_attr_value_index).ATTR_VALUE_STR IS NULL AND

Line 5983: l_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_TRANS_IND_VALIDATION_CODE OR

5979: -- the caller has passed in the display value and nothing else; otherwise --
5980: -- we want to use the passed-in internal value and thus avoid a query. --
5981: ----------------------------------------------------------------------------
5982: IF ((l_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_INDEPENDENT_VALIDATION_CODE OR
5983: l_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_TRANS_IND_VALIDATION_CODE OR
5984: l_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_TABLE_VALIDATION_CODE) AND
5985: (px_attr_name_value_pairs(l_attr_value_index).ATTR_DISP_VALUE IS NOT NULL) AND
5986: (px_attr_name_value_pairs(l_attr_value_index).ATTR_VALUE_STR IS NULL AND
5987: px_attr_name_value_pairs(l_attr_value_index).ATTR_VALUE_NUM IS NULL AND

Line 5984: l_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_TABLE_VALIDATION_CODE) AND

5980: -- we want to use the passed-in internal value and thus avoid a query. --
5981: ----------------------------------------------------------------------------
5982: IF ((l_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_INDEPENDENT_VALIDATION_CODE OR
5983: l_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_TRANS_IND_VALIDATION_CODE OR
5984: l_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_TABLE_VALIDATION_CODE) AND
5985: (px_attr_name_value_pairs(l_attr_value_index).ATTR_DISP_VALUE IS NOT NULL) AND
5986: (px_attr_name_value_pairs(l_attr_value_index).ATTR_VALUE_STR IS NULL AND
5987: px_attr_name_value_pairs(l_attr_value_index).ATTR_VALUE_NUM IS NULL AND
5988: px_attr_name_value_pairs(l_attr_value_index).ATTR_VALUE_DATE IS NULL)) THEN

Line 6005: l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE OR

6001: );
6002:
6003: IF (l_int_value IS NOT NULL) THEN
6004: IF (l_attr_metadata_obj.DATA_TYPE_CODE IS NULL OR
6005: l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE OR
6006: l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE) THEN
6007: px_attr_name_value_pairs(l_attr_value_index).ATTR_VALUE_STR := l_int_value;
6008: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
6009: px_attr_name_value_pairs(l_attr_value_index).ATTR_VALUE_NUM := TO_NUMBER(l_int_value);

Line 6006: l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE) THEN

6002:
6003: IF (l_int_value IS NOT NULL) THEN
6004: IF (l_attr_metadata_obj.DATA_TYPE_CODE IS NULL OR
6005: l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE OR
6006: l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE) THEN
6007: px_attr_name_value_pairs(l_attr_value_index).ATTR_VALUE_STR := l_int_value;
6008: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
6009: px_attr_name_value_pairs(l_attr_value_index).ATTR_VALUE_NUM := TO_NUMBER(l_int_value);
6010: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE) THEN

Line 6008: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN

6004: IF (l_attr_metadata_obj.DATA_TYPE_CODE IS NULL OR
6005: l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE OR
6006: l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE) THEN
6007: px_attr_name_value_pairs(l_attr_value_index).ATTR_VALUE_STR := l_int_value;
6008: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
6009: px_attr_name_value_pairs(l_attr_value_index).ATTR_VALUE_NUM := TO_NUMBER(l_int_value);
6010: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE) THEN
6011: px_attr_name_value_pairs(l_attr_value_index).ATTR_VALUE_DATE := TRUNC(TO_DATE(l_int_value, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT));
6012: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN

Line 6010: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE) THEN

6006: l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE) THEN
6007: px_attr_name_value_pairs(l_attr_value_index).ATTR_VALUE_STR := l_int_value;
6008: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
6009: px_attr_name_value_pairs(l_attr_value_index).ATTR_VALUE_NUM := TO_NUMBER(l_int_value);
6010: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE) THEN
6011: px_attr_name_value_pairs(l_attr_value_index).ATTR_VALUE_DATE := TRUNC(TO_DATE(l_int_value, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT));
6012: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
6013: px_attr_name_value_pairs(l_attr_value_index).ATTR_VALUE_DATE := TO_DATE(l_int_value, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);
6014: END IF;

Line 6012: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN

6008: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
6009: px_attr_name_value_pairs(l_attr_value_index).ATTR_VALUE_NUM := TO_NUMBER(l_int_value);
6010: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE) THEN
6011: px_attr_name_value_pairs(l_attr_value_index).ATTR_VALUE_DATE := TRUNC(TO_DATE(l_int_value, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT));
6012: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
6013: px_attr_name_value_pairs(l_attr_value_index).ATTR_VALUE_DATE := TO_DATE(l_int_value, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);
6014: END IF;
6015: ELSE
6016:

Line 6059: ELSIF ((l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR

6055: -- Finally, we check for the much less common case where the Attribute is a --
6056: -- Date, but the value passed in is a $SYSDATE$ expression of some sort; in --
6057: -- such a case, we want to replace the expression with the appropriate Date --
6058: ------------------------------------------------------------------------------
6059: ELSIF ((l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR
6060: l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE)
6061: AND
6062: (px_attr_name_value_pairs(l_attr_value_index).ATTR_VALUE_STR IS NOT NULL AND
6063: px_attr_name_value_pairs(l_attr_value_index).ATTR_VALUE_DATE IS NULL)) THEN

Line 6060: l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE)

6056: -- Date, but the value passed in is a $SYSDATE$ expression of some sort; in --
6057: -- such a case, we want to replace the expression with the appropriate Date --
6058: ------------------------------------------------------------------------------
6059: ELSIF ((l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR
6060: l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE)
6061: AND
6062: (px_attr_name_value_pairs(l_attr_value_index).ATTR_VALUE_STR IS NOT NULL AND
6063: px_attr_name_value_pairs(l_attr_value_index).ATTR_VALUE_DATE IS NULL)) THEN
6064:

Line 6070: IF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE) THEN

6066: l_formatted_expression VARCHAR2(150);
6067: BEGIN
6068: l_formatted_expression := Format_Sysdate_Expression(px_attr_name_value_pairs(l_attr_value_index).ATTR_VALUE_STR);
6069:
6070: IF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE) THEN
6071: px_attr_name_value_pairs(l_attr_value_index).ATTR_VALUE_DATE := TRUNC(TO_DATE(l_formatted_expression, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT));
6072: ELSE
6073: px_attr_name_value_pairs(l_attr_value_index).ATTR_VALUE_DATE := TO_DATE(l_formatted_expression, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);
6074: END IF;

Line 6366: if ( l_curr_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE ) then -- timestamp

6362: NVL(px_attr_diffs(L_ATTRS_INDEX).NEW_ATTR_VALUE_DATE,FND_API.G_MISS_DATE))THEN
6363: l_attr_name_val.EXTEND();
6364: -- l_attr_rec.attr_value := to_char(px_attr_diffs(L_ATTRS_INDEX).NEW_ATTR_VALUE_DATE);
6365: -- abedajna Bug 6134504 begin
6366: if ( l_curr_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE ) then -- timestamp
6367: l_attr_rec.attr_value := to_char(px_attr_diffs(L_ATTRS_INDEX).NEW_ATTR_VALUE_DATE, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);
6368: elsif ( l_curr_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE) then -- date
6369: l_attr_rec.attr_value := to_char(px_attr_diffs(L_ATTRS_INDEX).NEW_ATTR_VALUE_DATE);
6370: end if;

Line 6368: elsif ( l_curr_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE) then -- date

6364: -- l_attr_rec.attr_value := to_char(px_attr_diffs(L_ATTRS_INDEX).NEW_ATTR_VALUE_DATE);
6365: -- abedajna Bug 6134504 begin
6366: if ( l_curr_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE ) then -- timestamp
6367: l_attr_rec.attr_value := to_char(px_attr_diffs(L_ATTRS_INDEX).NEW_ATTR_VALUE_DATE, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);
6368: elsif ( l_curr_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE) then -- date
6369: l_attr_rec.attr_value := to_char(px_attr_diffs(L_ATTRS_INDEX).NEW_ATTR_VALUE_DATE);
6370: end if;
6371: -- abedajna Bug 6134504 end
6372: l_attr_name_val(l_attr_name_val.LAST) := l_attr_rec;

Line 6393: if ( l_curr_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE ) then -- timestamp

6389: l_attr_rec.attr_value := TO_CHAR(px_attr_diffs(L_ATTRS_INDEX).NEW_ATTR_VALUE_num);
6390: ELSIF px_attr_diffs(L_ATTRS_INDEX).NEW_ATTR_VALUE_DATE IS NOT NULL THEN
6391: -- l_attr_rec.attr_value := TO_CHAR(px_attr_diffs(L_ATTRS_INDEX).NEW_ATTR_VALUE_DATE);
6392: -- abedajna Bug 6134504 begin
6393: if ( l_curr_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE ) then -- timestamp
6394: l_attr_rec.attr_value := to_char(px_attr_diffs(L_ATTRS_INDEX).NEW_ATTR_VALUE_DATE, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);
6395: elsif ( l_curr_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE) then -- date
6396: l_attr_rec.attr_value := to_char(px_attr_diffs(L_ATTRS_INDEX).NEW_ATTR_VALUE_DATE);
6397: end if;

Line 6395: elsif ( l_curr_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE) then -- date

6391: -- l_attr_rec.attr_value := TO_CHAR(px_attr_diffs(L_ATTRS_INDEX).NEW_ATTR_VALUE_DATE);
6392: -- abedajna Bug 6134504 begin
6393: if ( l_curr_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE ) then -- timestamp
6394: l_attr_rec.attr_value := to_char(px_attr_diffs(L_ATTRS_INDEX).NEW_ATTR_VALUE_DATE, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);
6395: elsif ( l_curr_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE) then -- date
6396: l_attr_rec.attr_value := to_char(px_attr_diffs(L_ATTRS_INDEX).NEW_ATTR_VALUE_DATE);
6397: end if;
6398: -- abedajna Bug 6134504 end
6399: ELSE

Line 6424: if ( l_curr_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) then -- timestamp

6420: l_attr_rec.attr_value := TO_CHAR(px_attr_diffs(L_ATTRS_INDEX).OLD_ATTR_VALUE_num);
6421: ELSIF px_attr_diffs(L_ATTRS_INDEX).OLD_ATTR_VALUE_DATE IS NOT NULL THEN
6422: -- l_attr_rec.attr_value := TO_CHAR(px_attr_diffs(L_ATTRS_INDEX).OLD_ATTR_VALUE_DATE);
6423: -- abedajna Bug 6134504 begin
6424: if ( l_curr_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) then -- timestamp
6425: l_attr_rec.attr_value := to_char(px_attr_diffs(L_ATTRS_INDEX).OLD_ATTR_VALUE_DATE, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);
6426: elsif ( l_curr_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE) then -- date
6427: l_attr_rec.attr_value := to_char(px_attr_diffs(L_ATTRS_INDEX).OLD_ATTR_VALUE_DATE);
6428: end if;

Line 6426: elsif ( l_curr_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE) then -- date

6422: -- l_attr_rec.attr_value := TO_CHAR(px_attr_diffs(L_ATTRS_INDEX).OLD_ATTR_VALUE_DATE);
6423: -- abedajna Bug 6134504 begin
6424: if ( l_curr_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) then -- timestamp
6425: l_attr_rec.attr_value := to_char(px_attr_diffs(L_ATTRS_INDEX).OLD_ATTR_VALUE_DATE, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);
6426: elsif ( l_curr_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE) then -- date
6427: l_attr_rec.attr_value := to_char(px_attr_diffs(L_ATTRS_INDEX).OLD_ATTR_VALUE_DATE);
6428: end if;
6429: -- abedajna Bug 6134504 end
6430: ELSE

Line 11753: EGO_EXT_FWK_PUB.G_INDEPENDENT_VALIDATION_CODE,

11749: -- we build or update a DECODE query for the Database Column (so --
11750: -- that each AG's use of the column gets the correct Disp value) --
11751: --------------------------------------------------------------------
11752: IF (l_curr_attr_metadata_obj.VALIDATION_CODE IN (
11753: EGO_EXT_FWK_PUB.G_INDEPENDENT_VALIDATION_CODE,
11754: EGO_EXT_FWK_PUB.G_TRANS_IND_VALIDATION_CODE)
11755: ) THEN
11756:
11757: l_int_to_disp_val_string := l_curr_attr_metadata_obj.INT_TO_DISP_VAL_QUERY;

Line 11754: EGO_EXT_FWK_PUB.G_TRANS_IND_VALIDATION_CODE)

11750: -- that each AG's use of the column gets the correct Disp value) --
11751: --------------------------------------------------------------------
11752: IF (l_curr_attr_metadata_obj.VALIDATION_CODE IN (
11753: EGO_EXT_FWK_PUB.G_INDEPENDENT_VALIDATION_CODE,
11754: EGO_EXT_FWK_PUB.G_TRANS_IND_VALIDATION_CODE)
11755: ) THEN
11756:
11757: l_int_to_disp_val_string := l_curr_attr_metadata_obj.INT_TO_DISP_VAL_QUERY;
11758:

Line 11760: EGO_EXT_FWK_PUB.G_TABLE_VALIDATION_CODE) THEN

11756:
11757: l_int_to_disp_val_string := l_curr_attr_metadata_obj.INT_TO_DISP_VAL_QUERY;
11758:
11759: ELSIF (l_curr_attr_metadata_obj.VALIDATION_CODE =
11760: EGO_EXT_FWK_PUB.G_TABLE_VALIDATION_CODE) THEN
11761:
11762: ----------------------------------------------------------------
11763: -- In this case we DON'T want to cast the result to a string, --
11764: -- so we revert our expression to being the database column --

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

16251:
16252: ------------------------
16253: -- Define the outputs --
16254: ------------------------
16255: IF (p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
16256: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, x_num_val);
16257: ELSIF (p_attr_metadata_obj.DATA_TYPE_CODE = 'X' OR p_attr_metadata_obj.DATA_TYPE_CODE = 'Y') THEN
16258: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, l_str,150);
16259: ELSE

Line 16571: IF (l_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_INDEPENDENT_VALIDATION_CODE OR

16567: -- At this point I have the internal value; if the Attr --
16568: -- has a display value, I need to try to get it instead --
16569: ----------------------------------------------------------
16570: -- fix for bug 4543638 included translatable independent validation code to get disp value
16571: IF (l_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_INDEPENDENT_VALIDATION_CODE OR
16572: l_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_TRANS_IND_VALIDATION_CODE OR
16573: l_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_TABLE_VALIDATION_CODE) THEN
16574:
16575: ------------------------------------------------------------

Line 16572: l_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_TRANS_IND_VALIDATION_CODE OR

16568: -- has a display value, I need to try to get it instead --
16569: ----------------------------------------------------------
16570: -- fix for bug 4543638 included translatable independent validation code to get disp value
16571: IF (l_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_INDEPENDENT_VALIDATION_CODE OR
16572: l_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_TRANS_IND_VALIDATION_CODE OR
16573: l_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_TABLE_VALIDATION_CODE) THEN
16574:
16575: ------------------------------------------------------------
16576: -- We must query up the rest of the attribute data in the --

Line 16573: l_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_TABLE_VALIDATION_CODE) THEN

16569: ----------------------------------------------------------
16570: -- fix for bug 4543638 included translatable independent validation code to get disp value
16571: IF (l_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_INDEPENDENT_VALIDATION_CODE OR
16572: l_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_TRANS_IND_VALIDATION_CODE OR
16573: l_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_TABLE_VALIDATION_CODE) THEN
16574:
16575: ------------------------------------------------------------
16576: -- We must query up the rest of the attribute data in the --
16577: -- same group in case there are binds --

Line 16647: (EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE,

16643: -- change the format to user preferences, else we return --
16644: -- the obtained String as it is. --
16645: ------------------------------------------------------------
16646: IF ( l_attr_metadata_obj.DATA_TYPE_CODE IN
16647: (EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE,
16648: EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) )
16649: THEN
16650: l_attr_disp_value := EGO_USER_ATTRS_COMMON_PVT.Get_User_Pref_Date_Time_Val(
16651: p_date => TO_DATE(l_attr_int_value,EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT)

Line 16648: EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) )

16644: -- the obtained String as it is. --
16645: ------------------------------------------------------------
16646: IF ( l_attr_metadata_obj.DATA_TYPE_CODE IN
16647: (EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE,
16648: EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) )
16649: THEN
16650: l_attr_disp_value := EGO_USER_ATTRS_COMMON_PVT.Get_User_Pref_Date_Time_Val(
16651: p_date => TO_DATE(l_attr_int_value,EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT)
16652: ,p_attr_type => l_attr_metadata_obj.DATA_TYPE_CODE

Line 16668: IF ((l_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_INDEPENDENT_VALIDATION_CODE )

16664: -- or DateTime and is coming from a Independent Type
16665: -- of Valueset then we change the format to user preferences,
16666: -- else we return the obtained String as it is.
16667: ------------------------------------------------------------
16668: IF ((l_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_INDEPENDENT_VALIDATION_CODE )
16669: AND (l_attr_metadata_obj.DATA_TYPE_CODE IN
16670: (EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE,
16671: EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE)))
16672: THEN

Line 16670: (EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE,

16666: -- else we return the obtained String as it is.
16667: ------------------------------------------------------------
16668: IF ((l_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_INDEPENDENT_VALIDATION_CODE )
16669: AND (l_attr_metadata_obj.DATA_TYPE_CODE IN
16670: (EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE,
16671: EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE)))
16672: THEN
16673: l_attr_disp_value := EGO_USER_ATTRS_COMMON_PVT.Get_User_Pref_Date_Time_Val(
16674: p_date => TO_DATE(l_attr_disp_value,EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT)

Line 16671: EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE)))

16667: ------------------------------------------------------------
16668: IF ((l_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_INDEPENDENT_VALIDATION_CODE )
16669: AND (l_attr_metadata_obj.DATA_TYPE_CODE IN
16670: (EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE,
16671: EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE)))
16672: THEN
16673: l_attr_disp_value := EGO_USER_ATTRS_COMMON_PVT.Get_User_Pref_Date_Time_Val(
16674: p_date => TO_DATE(l_attr_disp_value,EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT)
16675: ,p_attr_type => l_attr_metadata_obj.DATA_TYPE_CODE

Line 17227: IF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE)

17223: IF l_attr_metadata_obj.VALUE_SET_ID IS NULL THEN
17224: -- if the data is coming from intf table we have a possibility that its not
17225: -- valid in terms of datatype. We return a null in such a case.
17226: IF p_return_intf_col IS NOT NULL THEN
17227: IF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE)
17228: AND (p_return_intf_col = 'ATTR_VALUE_NUM') THEN
17229: RETURN TO_CHAR(TO_NUMBER(p_attr_disp_value));
17230: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE
17231: OR l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE)

Line 17230: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE

17226: IF p_return_intf_col IS NOT NULL THEN
17227: IF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE)
17228: AND (p_return_intf_col = 'ATTR_VALUE_NUM') THEN
17229: RETURN TO_CHAR(TO_NUMBER(p_attr_disp_value));
17230: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE
17231: OR l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE)
17232: AND (p_return_intf_col = 'ATTR_VALUE_DATE') THEN
17233: RETURN TO_CHAR(TO_DATE(p_attr_disp_value,EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT),EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);
17234: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE

Line 17231: OR l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE)

17227: IF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE)
17228: AND (p_return_intf_col = 'ATTR_VALUE_NUM') THEN
17229: RETURN TO_CHAR(TO_NUMBER(p_attr_disp_value));
17230: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE
17231: OR l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE)
17232: AND (p_return_intf_col = 'ATTR_VALUE_DATE') THEN
17233: RETURN TO_CHAR(TO_DATE(p_attr_disp_value,EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT),EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);
17234: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE
17235: OR l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE)

Line 17234: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE

17230: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE
17231: OR l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE)
17232: AND (p_return_intf_col = 'ATTR_VALUE_DATE') THEN
17233: RETURN TO_CHAR(TO_DATE(p_attr_disp_value,EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT),EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);
17234: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE
17235: OR l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE)
17236: AND (p_return_intf_col = 'ATTR_VALUE_STR') THEN
17237: RETURN p_attr_disp_value;
17238: ELSE

Line 17235: OR l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE)

17231: OR l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE)
17232: AND (p_return_intf_col = 'ATTR_VALUE_DATE') THEN
17233: RETURN TO_CHAR(TO_DATE(p_attr_disp_value,EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT),EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);
17234: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE
17235: OR l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE)
17236: AND (p_return_intf_col = 'ATTR_VALUE_STR') THEN
17237: RETURN p_attr_disp_value;
17238: ELSE
17239: RETURN NULL;

Line 17258: IF (l_attr_metadata_obj.DATA_TYPE_CODE <> EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE

17254: -- the appropriate column.
17255: IF p_return_intf_col IS NOT NULL THEN
17256:
17257: IF p_return_intf_col = 'ATTR_VALUE_STR' THEN
17258: IF (l_attr_metadata_obj.DATA_TYPE_CODE <> EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE
17259: AND l_attr_metadata_obj.DATA_TYPE_CODE <> EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE) THEN
17260: RETURN NULL;
17261: END IF;
17262:

Line 17259: AND l_attr_metadata_obj.DATA_TYPE_CODE <> EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE) THEN

17255: IF p_return_intf_col IS NOT NULL THEN
17256:
17257: IF p_return_intf_col = 'ATTR_VALUE_STR' THEN
17258: IF (l_attr_metadata_obj.DATA_TYPE_CODE <> EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE
17259: AND l_attr_metadata_obj.DATA_TYPE_CODE <> EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE) THEN
17260: RETURN NULL;
17261: END IF;
17262:
17263: ELSIF p_return_intf_col = 'ATTR_VALUE_NUM' THEN

Line 17264: IF l_attr_metadata_obj.DATA_TYPE_CODE <> EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE THEN

17260: RETURN NULL;
17261: END IF;
17262:
17263: ELSIF p_return_intf_col = 'ATTR_VALUE_NUM' THEN
17264: IF l_attr_metadata_obj.DATA_TYPE_CODE <> EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE THEN
17265: RETURN NULL;
17266: END IF;
17267:
17268: ELSIF p_return_intf_col = 'ATTR_VALUE_DATE' THEN

Line 17269: IF (l_attr_metadata_obj.DATA_TYPE_CODE <> EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE

17265: RETURN NULL;
17266: END IF;
17267:
17268: ELSIF p_return_intf_col = 'ATTR_VALUE_DATE' THEN
17269: IF (l_attr_metadata_obj.DATA_TYPE_CODE <> EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE
17270: AND l_attr_metadata_obj.DATA_TYPE_CODE <> EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
17271: RETURN NULL;
17272: END IF;
17273:

Line 17270: AND l_attr_metadata_obj.DATA_TYPE_CODE <> EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN

17266: END IF;
17267:
17268: ELSIF p_return_intf_col = 'ATTR_VALUE_DATE' THEN
17269: IF (l_attr_metadata_obj.DATA_TYPE_CODE <> EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE
17270: AND l_attr_metadata_obj.DATA_TYPE_CODE <> EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
17271: RETURN NULL;
17272: END IF;
17273:
17274: END IF;

Line 17316: IF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE)

17312:
17313:
17314: BEGIN
17315: IF p_return_intf_col IS NOT NULL THEN
17316: IF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE)
17317: AND (p_return_intf_col = 'ATTR_VALUE_NUM') THEN
17318: l_attr_internal_value := TO_CHAR(TO_NUMBER(l_attr_internal_value));
17319: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE
17320: OR l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE)

Line 17319: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE

17315: IF p_return_intf_col IS NOT NULL THEN
17316: IF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE)
17317: AND (p_return_intf_col = 'ATTR_VALUE_NUM') THEN
17318: l_attr_internal_value := TO_CHAR(TO_NUMBER(l_attr_internal_value));
17319: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE
17320: OR l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE)
17321: AND (p_return_intf_col = 'ATTR_VALUE_DATE') THEN
17322: l_attr_internal_value := TO_CHAR(TO_DATE(l_attr_internal_value,EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT),EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);
17323: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE

Line 17320: OR l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE)

17316: IF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE)
17317: AND (p_return_intf_col = 'ATTR_VALUE_NUM') THEN
17318: l_attr_internal_value := TO_CHAR(TO_NUMBER(l_attr_internal_value));
17319: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE
17320: OR l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE)
17321: AND (p_return_intf_col = 'ATTR_VALUE_DATE') THEN
17322: l_attr_internal_value := TO_CHAR(TO_DATE(l_attr_internal_value,EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT),EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);
17323: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE
17324: OR l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE)

Line 17323: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE

17319: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE
17320: OR l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE)
17321: AND (p_return_intf_col = 'ATTR_VALUE_DATE') THEN
17322: l_attr_internal_value := TO_CHAR(TO_DATE(l_attr_internal_value,EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT),EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);
17323: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE
17324: OR l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE)
17325: AND (p_return_intf_col = 'ATTR_VALUE_STR') THEN
17326: l_attr_internal_value := l_attr_internal_value;
17327: END IF;

Line 17324: OR l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE)

17320: OR l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE)
17321: AND (p_return_intf_col = 'ATTR_VALUE_DATE') THEN
17322: l_attr_internal_value := TO_CHAR(TO_DATE(l_attr_internal_value,EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT),EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);
17323: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE
17324: OR l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE)
17325: AND (p_return_intf_col = 'ATTR_VALUE_STR') THEN
17326: l_attr_internal_value := l_attr_internal_value;
17327: END IF;
17328: END IF;

Line 18591: IF(l_attr_record.DATA_TYPE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE)THEN

18587: LOOP
18588: FETCH attr_rec_cursor INTO l_attr_record;
18589: EXIT WHEN attr_rec_cursor%NOTFOUND;
18590:
18591: IF(l_attr_record.DATA_TYPE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE)THEN
18592: l_number_val := TO_NUMBER(l_attr_record.DEFAULT_VALUE);
18593: l_str_val := NULL;
18594: l_date_val := NULL;
18595: ELSIF (l_attr_record.DATA_TYPE = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE OR

Line 18595: ELSIF (l_attr_record.DATA_TYPE = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE OR

18591: IF(l_attr_record.DATA_TYPE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE)THEN
18592: l_number_val := TO_NUMBER(l_attr_record.DEFAULT_VALUE);
18593: l_str_val := NULL;
18594: l_date_val := NULL;
18595: ELSIF (l_attr_record.DATA_TYPE = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE OR
18596: l_attr_record.DATA_TYPE = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE) THEN
18597: l_number_val := NULL;
18598: l_str_val := l_attr_record.DEFAULT_VALUE;
18599: l_date_val := NULL;

Line 18596: l_attr_record.DATA_TYPE = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE) THEN

18592: l_number_val := TO_NUMBER(l_attr_record.DEFAULT_VALUE);
18593: l_str_val := NULL;
18594: l_date_val := NULL;
18595: ELSIF (l_attr_record.DATA_TYPE = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE OR
18596: l_attr_record.DATA_TYPE = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE) THEN
18597: l_number_val := NULL;
18598: l_str_val := l_attr_record.DEFAULT_VALUE;
18599: l_date_val := NULL;
18600: ELSIF(l_attr_record.DATA_TYPE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR

Line 18600: ELSIF(l_attr_record.DATA_TYPE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR

18596: l_attr_record.DATA_TYPE = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE) THEN
18597: l_number_val := NULL;
18598: l_str_val := l_attr_record.DEFAULT_VALUE;
18599: l_date_val := NULL;
18600: ELSIF(l_attr_record.DATA_TYPE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR
18601: l_attr_record.DATA_TYPE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
18602: l_number_val := NULL;
18603: l_str_val := NULL;
18604: IF(INSTR(UPPER(l_attr_record.DEFAULT_VALUE),'$SYSDATE$') <> 0) THEN

Line 18601: l_attr_record.DATA_TYPE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN

18597: l_number_val := NULL;
18598: l_str_val := l_attr_record.DEFAULT_VALUE;
18599: l_date_val := NULL;
18600: ELSIF(l_attr_record.DATA_TYPE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR
18601: l_attr_record.DATA_TYPE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
18602: l_number_val := NULL;
18603: l_str_val := NULL;
18604: IF(INSTR(UPPER(l_attr_record.DEFAULT_VALUE),'$SYSDATE$') <> 0) THEN
18605: l_temp_date_str := REPLACE(UPPER(l_attr_record.DEFAULT_VALUE),'$'); --bugfix:5228308