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 1932: l_data_type = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE) OR

1928: -----------------------------------------------------------------
1929: IF ((UPPER(p_which_attrs) = 'ALL') OR
1930: (UPPER(p_which_attrs) = 'UNIQUE_KEY' AND l_unique_key_flag = 'Y') OR
1931: (UPPER(p_which_attrs) = 'TRANS' AND
1932: l_data_type = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE) OR
1933: (UPPER(p_which_attrs) = 'NONTRANS' AND
1934: l_data_type <> EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE)) THEN
1935:
1936: ---------------------------------------------------------------------------

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

1930: (UPPER(p_which_attrs) = 'UNIQUE_KEY' AND l_unique_key_flag = 'Y') OR
1931: (UPPER(p_which_attrs) = 'TRANS' AND
1932: l_data_type = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE) OR
1933: (UPPER(p_which_attrs) = 'NONTRANS' AND
1934: l_data_type <> EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE)) THEN
1935:
1936: ---------------------------------------------------------------------------
1937: -- Reset UOM, column name, default and value variables each time through --
1938: ---------------------------------------------------------------------------

Line 1955: l_data_type = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE OR

1951: ---------------------------------------------------------------
1952: -- First, try to use the value appropriate for the data type --
1953: ---------------------------------------------------------------
1954: IF (l_data_type IS NULL OR
1955: l_data_type = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE OR
1956: l_data_type = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE) THEN
1957:
1958: l_candidate_value := l_attr_data_obj.ATTR_VALUE_STR;
1959: Debug_Msg('Candidate value:'||l_candidate_value);

Line 1956: l_data_type = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE) THEN

1952: -- First, try to use the value appropriate for the data type --
1953: ---------------------------------------------------------------
1954: IF (l_data_type IS NULL OR
1955: l_data_type = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE OR
1956: l_data_type = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE) THEN
1957:
1958: l_candidate_value := l_attr_data_obj.ATTR_VALUE_STR;
1959: Debug_Msg('Candidate value:'||l_candidate_value);
1960:

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

1957:
1958: l_candidate_value := l_attr_data_obj.ATTR_VALUE_STR;
1959: Debug_Msg('Candidate value:'||l_candidate_value);
1960:
1961: ELSIF (l_data_type = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
1962:
1963: l_candidate_value := TO_CHAR(l_attr_data_obj.ATTR_VALUE_NUM);
1964:
1965: --------------------------------------------------------------------

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

1975: l_uom_value := '''' || l_attr_data_obj.ATTR_UNIT_OF_MEASURE || '''';
1976:
1977: END IF;
1978:
1979: ELSIF (l_data_type = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE) THEN
1980:
1981: l_candidate_value := TO_CHAR(TRUNC(l_attr_data_obj.ATTR_VALUE_DATE),
1982: EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);
1983:

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

1980:
1981: l_candidate_value := TO_CHAR(TRUNC(l_attr_data_obj.ATTR_VALUE_DATE),
1982: EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);
1983:
1984: ELSIF (l_data_type = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
1985:
1986: l_candidate_value := TO_CHAR(l_attr_data_obj.ATTR_VALUE_DATE,
1987: EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);
1988:

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

1996:
1997: ---------------------------------------
1998: -- Format default value if necessary --
1999: ---------------------------------------
2000: IF ((l_data_type = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR
2001: l_data_type = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) AND
2002: INSTR(UPPER(l_default_value), 'SYSDATE') > 0) THEN
2003: l_default_value := Format_Sysdate_Expression(l_default_value);
2004: END IF;

Line 2001: l_data_type = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) AND

1997: ---------------------------------------
1998: -- Format default value if necessary --
1999: ---------------------------------------
2000: IF ((l_data_type = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR
2001: l_data_type = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) AND
2002: INSTR(UPPER(l_default_value), 'SYSDATE') > 0) THEN
2003: l_default_value := Format_Sysdate_Expression(l_default_value);
2004: END IF;
2005:

Line 2058: l_data_type = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE OR

2054:
2055: FND_DSQL.Add_Text(' NULL ');
2056:
2057: ELSIF (l_data_type IS NULL OR
2058: l_data_type = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE OR
2059: l_data_type = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE) THEN
2060:
2061: Add_Bind(p_bind_identifier => l_attr_metadata_obj.ATTR_GROUP_NAME||'$$'||l_attr_metadata_obj.ATTR_NAME
2062: ,p_value => l_candidate_value);

Line 2059: l_data_type = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE) THEN

2055: FND_DSQL.Add_Text(' NULL ');
2056:
2057: ELSIF (l_data_type IS NULL OR
2058: l_data_type = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE OR
2059: l_data_type = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE) THEN
2060:
2061: Add_Bind(p_bind_identifier => l_attr_metadata_obj.ATTR_GROUP_NAME||'$$'||l_attr_metadata_obj.ATTR_NAME
2062: ,p_value => l_candidate_value);
2063:

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

2060:
2061: Add_Bind(p_bind_identifier => l_attr_metadata_obj.ATTR_GROUP_NAME||'$$'||l_attr_metadata_obj.ATTR_NAME
2062: ,p_value => l_candidate_value);
2063:
2064: ELSIF (l_data_type = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
2065:
2066: Add_Bind(p_bind_identifier => l_attr_metadata_obj.ATTR_GROUP_NAME||'$$'||l_attr_metadata_obj.ATTR_NAME
2067: ,p_value => TO_NUMBER(l_candidate_value));
2068:

Line 2069: ELSIF (l_data_type = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR

2065:
2066: Add_Bind(p_bind_identifier => l_attr_metadata_obj.ATTR_GROUP_NAME||'$$'||l_attr_metadata_obj.ATTR_NAME
2067: ,p_value => TO_NUMBER(l_candidate_value));
2068:
2069: ELSIF (l_data_type = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR
2070: l_data_type = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
2071:
2072: Add_Bind(p_bind_identifier => l_attr_metadata_obj.ATTR_GROUP_NAME||'$$'||l_attr_metadata_obj.ATTR_NAME
2073: ,p_value => TO_DATE(l_candidate_value, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT));

Line 2070: l_data_type = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN

2066: Add_Bind(p_bind_identifier => l_attr_metadata_obj.ATTR_GROUP_NAME||'$$'||l_attr_metadata_obj.ATTR_NAME
2067: ,p_value => TO_NUMBER(l_candidate_value));
2068:
2069: ELSIF (l_data_type = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR
2070: l_data_type = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
2071:
2072: Add_Bind(p_bind_identifier => l_attr_metadata_obj.ATTR_GROUP_NAME||'$$'||l_attr_metadata_obj.ATTR_NAME
2073: ,p_value => TO_DATE(l_candidate_value, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT));
2074:

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

2374: --------------------------------------------------------------------------------
2375: -- We only process the query if the Attribute has a Value Set of type "Table" --
2376: -- (because that's the only case in which there may be tokens to replace) --
2377: --------------------------------------------------------------------------------
2378: IF (p_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_TABLE_VALIDATION_CODE) THEN
2379:
2380: l_has_tokens_left := (INSTR(UPPER(l_tail_of_query), ':$OBJECT$.') > 0 OR
2381: INSTR(UPPER(l_tail_of_query), ':$ATTRIBUTEGROUP$.') > 0);
2382:

Line 2538: l_replacement_attr_metadata.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE OR

2534:
2535: IF (l_replacement_attr_data IS NOT NULL) THEN
2536:
2537: IF (l_replacement_attr_metadata.DATA_TYPE_CODE IS NULL OR
2538: l_replacement_attr_metadata.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE OR
2539: l_replacement_attr_metadata.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE) THEN
2540:
2541: --l_token_replacement := l_replacement_attr_data.ATTR_VALUE_STR;
2542: l_token_replacement := l_replacement_attr_data.ATTR_DISP_VALUE; -- Bug 6456697

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

2535: IF (l_replacement_attr_data IS NOT NULL) THEN
2536:
2537: IF (l_replacement_attr_metadata.DATA_TYPE_CODE IS NULL OR
2538: l_replacement_attr_metadata.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE OR
2539: l_replacement_attr_metadata.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE) THEN
2540:
2541: --l_token_replacement := l_replacement_attr_data.ATTR_VALUE_STR;
2542: l_token_replacement := l_replacement_attr_data.ATTR_DISP_VALUE; -- Bug 6456697
2543:

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

2540:
2541: --l_token_replacement := l_replacement_attr_data.ATTR_VALUE_STR;
2542: l_token_replacement := l_replacement_attr_data.ATTR_DISP_VALUE; -- Bug 6456697
2543:
2544: ELSIF (l_replacement_attr_metadata.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
2545:
2546: l_token_replacement := TO_CHAR(l_replacement_attr_data.ATTR_VALUE_NUM);
2547:
2548: ELSIF (l_replacement_attr_metadata.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR

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

2544: ELSIF (l_replacement_attr_metadata.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
2545:
2546: l_token_replacement := TO_CHAR(l_replacement_attr_data.ATTR_VALUE_NUM);
2547:
2548: ELSIF (l_replacement_attr_metadata.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR
2549: l_replacement_attr_metadata.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
2550:
2551: l_token_replacement := TO_CHAR(l_replacement_attr_data.ATTR_VALUE_DATE, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);
2552:

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

2545:
2546: l_token_replacement := TO_CHAR(l_replacement_attr_data.ATTR_VALUE_NUM);
2547:
2548: ELSIF (l_replacement_attr_metadata.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR
2549: l_replacement_attr_metadata.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
2550:
2551: l_token_replacement := TO_CHAR(l_replacement_attr_data.ATTR_VALUE_DATE, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);
2552:
2553: END IF;

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

2717: l_disp_value := p_attr_value_obj.ATTR_DISP_VALUE;
2718:
2719: Debug_Msg('In Get_Int_Val_For_Disp_Val, starting for l_disp_value '||l_disp_value, 2);
2720:
2721: IF (p_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_INDEPENDENT_VALIDATION_CODE OR
2722: p_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_TRANS_IND_VALIDATION_CODE ) THEN
2723: --PERF TUNING 4957648
2724: l_dynamic_sql := 'SELECT DISTINCT FLEX_VALUE '||
2725: ' FROM FND_FLEX_VALUES_VL '||

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

2718:
2719: Debug_Msg('In Get_Int_Val_For_Disp_Val, starting for l_disp_value '||l_disp_value, 2);
2720:
2721: IF (p_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_INDEPENDENT_VALIDATION_CODE OR
2722: p_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_TRANS_IND_VALIDATION_CODE ) THEN
2723: --PERF TUNING 4957648
2724: l_dynamic_sql := 'SELECT DISTINCT FLEX_VALUE '||
2725: ' FROM FND_FLEX_VALUES_VL '||
2726: ' WHERE FLEX_VALUE_SET_ID = :1 '||

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

2732: EXECUTE IMMEDIATE l_dynamic_sql
2733: INTO l_int_value
2734: USING p_attr_metadata_obj.VALUE_SET_ID, l_disp_value;
2735:
2736: ELSIF (p_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_TABLE_VALIDATION_CODE) THEN
2737:
2738: ---------------------------------------------------------------------
2739: -- If the Table Value Set doesn't have an Additional Where Clause --
2740: -- with bind values, we can go ahead and execute the query without --

Line 2832: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE OR

2828:
2829: l_attr_int_value := p_attr_int_value;
2830:
2831: ELSIF (p_attr_metadata_obj.DATA_TYPE_CODE IS NULL OR
2832: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE OR
2833: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE) THEN
2834:
2835: l_attr_int_value := p_attr_value_obj.ATTR_VALUE_STR;
2836:

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

2829: l_attr_int_value := p_attr_int_value;
2830:
2831: ELSIF (p_attr_metadata_obj.DATA_TYPE_CODE IS NULL OR
2832: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE OR
2833: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE) THEN
2834:
2835: l_attr_int_value := p_attr_value_obj.ATTR_VALUE_STR;
2836:
2837: ELSIF (p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN

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

2833: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE) THEN
2834:
2835: l_attr_int_value := p_attr_value_obj.ATTR_VALUE_STR;
2836:
2837: ELSIF (p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
2838:
2839: l_attr_int_value := TO_CHAR(p_attr_value_obj.ATTR_VALUE_NUM);
2840:
2841: ELSIF (p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR

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

2837: ELSIF (p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
2838:
2839: l_attr_int_value := TO_CHAR(p_attr_value_obj.ATTR_VALUE_NUM);
2840:
2841: ELSIF (p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR
2842: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
2843:
2844: l_attr_int_value := TO_CHAR(p_attr_value_obj.ATTR_VALUE_DATE, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);
2845:

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

2838:
2839: l_attr_int_value := TO_CHAR(p_attr_value_obj.ATTR_VALUE_NUM);
2840:
2841: ELSIF (p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR
2842: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
2843:
2844: l_attr_int_value := TO_CHAR(p_attr_value_obj.ATTR_VALUE_DATE, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);
2845:
2846: END IF;

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

2851: -- Next we handle the simple cases (i.e., all queries without an --
2852: -- Additional Where Clause containing user-defined bind values) --
2853: -------------------------------------------------------------------
2854: -- fix for bug 4543638 included translatable independent validation code to get disp value
2855: IF (p_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_INDEPENDENT_VALIDATION_CODE OR
2856: p_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_TRANS_IND_VALIDATION_CODE
2857: ) THEN
2858:
2859: ---------------------------------------------------------------

Line 2856: p_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_TRANS_IND_VALIDATION_CODE

2852: -- Additional Where Clause containing user-defined bind values) --
2853: -------------------------------------------------------------------
2854: -- fix for bug 4543638 included translatable independent validation code to get disp value
2855: IF (p_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_INDEPENDENT_VALIDATION_CODE OR
2856: p_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_TRANS_IND_VALIDATION_CODE
2857: ) THEN
2858:
2859: ---------------------------------------------------------------
2860: -- Even though our Attribute metadata object has this query --

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

2875: EXECUTE IMMEDIATE l_val_set_query
2876: INTO l_attr_disp_value
2877: USING p_attr_metadata_obj.VALUE_SET_ID, l_attr_int_value;
2878:
2879: ELSIF (p_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_TABLE_VALIDATION_CODE AND
2880: (p_attr_metadata_obj.VS_BIND_VALUES_CODE IS NULL OR
2881: p_attr_metadata_obj.VS_BIND_VALUES_CODE = 'N')) THEN
2882:
2883: EXECUTE IMMEDIATE p_attr_metadata_obj.INT_TO_DISP_VAL_QUERY||' :1 AND ROWNUM < 2'

Line 3193: l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE OR

3189: -----------------------------------------------------
3190: IF (l_attr_metadata_obj.UNIQUE_KEY_FLAG = 'Y') THEN
3191:
3192: IF (l_attr_metadata_obj.DATA_TYPE_CODE IS NULL OR
3193: l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE OR
3194: l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE) THEN
3195:
3196: l_uk_attr_values_table(l_uk_attr_values_table_index) := p_attr_name_value_pairs(l_table_index).ATTR_VALUE_STR;
3197:

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

3190: IF (l_attr_metadata_obj.UNIQUE_KEY_FLAG = 'Y') THEN
3191:
3192: IF (l_attr_metadata_obj.DATA_TYPE_CODE IS NULL OR
3193: l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE OR
3194: l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE) THEN
3195:
3196: l_uk_attr_values_table(l_uk_attr_values_table_index) := p_attr_name_value_pairs(l_table_index).ATTR_VALUE_STR;
3197:
3198: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN

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

3194: l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE) THEN
3195:
3196: l_uk_attr_values_table(l_uk_attr_values_table_index) := p_attr_name_value_pairs(l_table_index).ATTR_VALUE_STR;
3197:
3198: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
3199:
3200: l_uk_attr_values_table(l_uk_attr_values_table_index) := TO_CHAR(p_attr_name_value_pairs(l_table_index).ATTR_VALUE_NUM);
3201:
3202: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR

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

3198: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
3199:
3200: l_uk_attr_values_table(l_uk_attr_values_table_index) := TO_CHAR(p_attr_name_value_pairs(l_table_index).ATTR_VALUE_NUM);
3201:
3202: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR
3203: l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
3204:
3205: l_uk_attr_values_table(l_uk_attr_values_table_index) := TO_CHAR(p_attr_name_value_pairs(l_table_index).ATTR_VALUE_DATE
3206: ,EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);

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

3199:
3200: l_uk_attr_values_table(l_uk_attr_values_table_index) := TO_CHAR(p_attr_name_value_pairs(l_table_index).ATTR_VALUE_NUM);
3201:
3202: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR
3203: l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
3204:
3205: l_uk_attr_values_table(l_uk_attr_values_table_index) := TO_CHAR(p_attr_name_value_pairs(l_table_index).ATTR_VALUE_DATE
3206: ,EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);
3207:

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

4467: x_token_table(1).TOKEN_NAME := 'AG_NAME';
4468: x_token_table(1).TOKEN_VALUE := p_attr_group_disp_name;
4469: x_token_table(2).TOKEN_NAME := 'CLASS_MEANING';
4470: BEGIN
4471: SELECT EGO_EXT_FWK_PUB.Get_Class_Meaning(p_object_id, p_class_code_name_value_pairs(1).VALUE)
4472: INTO x_token_table(2).TOKEN_VALUE
4473: FROM DUAL;
4474: EXCEPTION
4475: WHEN OTHERS THEN

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

4492:
4493: Debug_Msg('In Disp_Val_Replacement_Is_Bad, starting', 2);
4494:
4495: IF (p_attr_metadata_obj.VALIDATION_CODE IS NULL OR
4496: NOT (p_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_INDEPENDENT_VALIDATION_CODE OR
4497: p_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_TABLE_VALIDATION_CODE)) THEN
4498:
4499: IF (px_attr_value_obj.ATTR_DISP_VALUE IS NOT NULL) THEN
4500:

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

4493: Debug_Msg('In Disp_Val_Replacement_Is_Bad, starting', 2);
4494:
4495: IF (p_attr_metadata_obj.VALIDATION_CODE IS NULL OR
4496: NOT (p_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_INDEPENDENT_VALIDATION_CODE OR
4497: p_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_TABLE_VALIDATION_CODE)) THEN
4498:
4499: IF (px_attr_value_obj.ATTR_DISP_VALUE IS NOT NULL) THEN
4500:
4501: IF ((p_attr_metadata_obj.DATA_TYPE_CODE IS NULL OR

Line 4502: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE OR

4498:
4499: IF (px_attr_value_obj.ATTR_DISP_VALUE IS NOT NULL) THEN
4500:
4501: IF ((p_attr_metadata_obj.DATA_TYPE_CODE IS NULL OR
4502: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE OR
4503: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE) AND
4504: px_attr_value_obj.ATTR_VALUE_STR IS NULL) THEN
4505:
4506: Debug_Msg('In Disp_Val_Replacement_Is_Bad, putting '||

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

4499: IF (px_attr_value_obj.ATTR_DISP_VALUE IS NOT NULL) THEN
4500:
4501: IF ((p_attr_metadata_obj.DATA_TYPE_CODE IS NULL OR
4502: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE OR
4503: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE) AND
4504: px_attr_value_obj.ATTR_VALUE_STR IS NULL) THEN
4505:
4506: Debug_Msg('In Disp_Val_Replacement_Is_Bad, putting '||
4507: px_attr_value_obj.ATTR_DISP_VALUE||

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

4507: px_attr_value_obj.ATTR_DISP_VALUE||
4508: ' into ATTR_VALUE_STR column', 3);
4509: px_attr_value_obj.ATTR_VALUE_STR := px_attr_value_obj.ATTR_DISP_VALUE;
4510:
4511: ELSIF (p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE AND
4512: px_attr_value_obj.ATTR_VALUE_NUM IS NULL) THEN
4513:
4514: Debug_Msg('In Disp_Val_Replacement_Is_Bad, putting '||
4515: px_attr_value_obj.ATTR_DISP_VALUE||

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

4515: px_attr_value_obj.ATTR_DISP_VALUE||
4516: ' into ATTR_VALUE_NUM column', 3);
4517: px_attr_value_obj.ATTR_VALUE_NUM := TO_NUMBER(px_attr_value_obj.ATTR_DISP_VALUE);
4518:
4519: ELSIF (p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE AND
4520: px_attr_value_obj.ATTR_VALUE_DATE IS NULL) THEN
4521:
4522: Debug_Msg('In Disp_Val_Replacement_Is_Bad, putting '||
4523: px_attr_value_obj.ATTR_DISP_VALUE||

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

4523: px_attr_value_obj.ATTR_DISP_VALUE||
4524: ' into ATTR_VALUE_DATE column', 3);
4525: 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));
4526:
4527: ELSIF (p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE AND
4528: px_attr_value_obj.ATTR_VALUE_DATE IS NULL) THEN
4529:
4530: Debug_Msg('In Disp_Val_Replacement_Is_Bad, putting '||
4531: px_attr_value_obj.ATTR_DISP_VALUE||

Line 4577: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE OR

4573:
4574: Debug_Msg('In Is_Required_Flag_Respected, starting', 2);
4575:
4576: IF (p_attr_metadata_obj.DATA_TYPE_CODE IS NULL OR
4577: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE OR
4578: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE) THEN
4579: l_value := p_attr_value_obj.ATTR_VALUE_STR;
4580: ELSIF (p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
4581: l_value := p_attr_value_obj.ATTR_VALUE_NUM;

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

4574: Debug_Msg('In Is_Required_Flag_Respected, starting', 2);
4575:
4576: IF (p_attr_metadata_obj.DATA_TYPE_CODE IS NULL OR
4577: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE OR
4578: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE) THEN
4579: l_value := p_attr_value_obj.ATTR_VALUE_STR;
4580: ELSIF (p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
4581: l_value := p_attr_value_obj.ATTR_VALUE_NUM;
4582: ELSE

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

4576: IF (p_attr_metadata_obj.DATA_TYPE_CODE IS NULL OR
4577: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE OR
4578: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE) THEN
4579: l_value := p_attr_value_obj.ATTR_VALUE_STR;
4580: ELSIF (p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
4581: l_value := p_attr_value_obj.ATTR_VALUE_NUM;
4582: ELSE
4583: l_value := p_attr_value_obj.ATTR_VALUE_DATE;
4584: END IF;

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

4590: -- Display Value (which we will later convert to an Internal --
4591: -- Value in Is_Value_Set_Respected) --
4592: ------------------------------------------------------------------
4593: IF (l_value IS NULL AND
4594: (p_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_INDEPENDENT_VALIDATION_CODE OR
4595: p_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_TRANS_IND_VALIDATION_CODE OR
4596: p_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_TABLE_VALIDATION_CODE)) THEN
4597: l_value := p_attr_value_obj.ATTR_DISP_VALUE;
4598: END IF;

Line 4595: p_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_TRANS_IND_VALIDATION_CODE OR

4591: -- Value in Is_Value_Set_Respected) --
4592: ------------------------------------------------------------------
4593: IF (l_value IS NULL AND
4594: (p_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_INDEPENDENT_VALIDATION_CODE OR
4595: p_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_TRANS_IND_VALIDATION_CODE OR
4596: p_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_TABLE_VALIDATION_CODE)) THEN
4597: l_value := p_attr_value_obj.ATTR_DISP_VALUE;
4598: END IF;
4599:

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

4592: ------------------------------------------------------------------
4593: IF (l_value IS NULL AND
4594: (p_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_INDEPENDENT_VALIDATION_CODE OR
4595: p_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_TRANS_IND_VALIDATION_CODE OR
4596: p_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_TABLE_VALIDATION_CODE)) THEN
4597: l_value := p_attr_value_obj.ATTR_DISP_VALUE;
4598: END IF;
4599:
4600: --------------------------------------------------------------

Line 4651: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE OR

4647:
4648: IF
4649: (
4650: (
4651: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE OR
4652: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE
4653: ) AND
4654: (
4655: p_attr_value_obj.ATTR_VALUE_STR IS NULL AND

Line 4652: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE

4648: IF
4649: (
4650: (
4651: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE OR
4652: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE
4653: ) AND
4654: (
4655: p_attr_value_obj.ATTR_VALUE_STR IS NULL AND
4656: (

Line 4668: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE

4664: TO_CHAR(p_attr_value_obj.ATTR_VALUE_DATE, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT));
4665:
4666: ELSIF (
4667: (
4668: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE
4669: ) AND
4670: (
4671: p_attr_value_obj.ATTR_VALUE_NUM IS NULL AND
4672: (

Line 4684: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR

4680: TO_CHAR(p_attr_value_obj.ATTR_VALUE_DATE, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT));
4681:
4682: ELSIF (
4683: (
4684: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR
4685: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE
4686: ) AND
4687: (
4688: p_attr_value_obj.ATTR_VALUE_DATE IS NULL AND

Line 4685: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE

4681:
4682: ELSIF (
4683: (
4684: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR
4685: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE
4686: ) AND
4687: (
4688: p_attr_value_obj.ATTR_VALUE_DATE IS NULL AND
4689: (

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

4754:
4755: -----------------
4756: -- Number case --
4757: -----------------
4758: IF (p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
4759:
4760: IF ((p_min_or_max = 'MIN' AND
4761: p_attr_value_obj.ATTR_VALUE_NUM < TO_NUMBER(l_value_bound_string)) OR
4762: (p_min_or_max = 'MAX' AND

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

4766:
4767: ---------------
4768: -- Date case --
4769: ---------------
4770: ELSIF (p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR
4771: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
4772:
4773: -----------------------------------------------------------------
4774: -- We store Min/Max Values in Timestamp format, which includes --

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

4767: ---------------
4768: -- Date case --
4769: ---------------
4770: ELSIF (p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR
4771: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
4772:
4773: -----------------------------------------------------------------
4774: -- We store Min/Max Values in Timestamp format, which includes --
4775: -- a decimal millisecond component; but since the TO_DATE --

Line 4794: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE AND

4790:
4791: IF (
4792: (
4793: (
4794: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE AND
4795: (
4796: p_min_or_max = 'MIN' AND
4797: p_attr_value_obj.ATTR_VALUE_DATE < TRUNC(TO_DATE(l_value_bound_string, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT))
4798: )

Line 4809: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE AND

4805: )
4806: OR
4807: (
4808: (
4809: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE AND
4810: (
4811: p_min_or_max = 'MIN' AND
4812: p_attr_value_obj.ATTR_VALUE_DATE < TO_DATE(l_value_bound_string, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT)
4813: )

Line 4874: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE OR

4870: -- than the number of bytes (for multi-byte support). --
4871: ---------------------------------------------------------------
4872:
4873: IF (p_attr_metadata_obj.DATA_TYPE_CODE IS NULL OR
4874: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE OR
4875: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE) THEN
4876:
4877: IF (p_attr_metadata_obj.MAXIMUM_SIZE > 0 AND
4878: p_attr_metadata_obj.MAXIMUM_SIZE <

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

4871: ---------------------------------------------------------------
4872:
4873: IF (p_attr_metadata_obj.DATA_TYPE_CODE IS NULL OR
4874: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE OR
4875: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE) THEN
4876:
4877: IF (p_attr_metadata_obj.MAXIMUM_SIZE > 0 AND
4878: p_attr_metadata_obj.MAXIMUM_SIZE <
4879: LENGTH(p_attr_value_obj.ATTR_VALUE_STR)) THEN

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

4880: l_is_max_size_respected := FALSE;
4881: l_value := p_attr_value_obj.ATTR_VALUE_STR;
4882: END IF;
4883:
4884: ELSIF (p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
4885:
4886: IF (p_attr_metadata_obj.MAXIMUM_SIZE > 0 AND
4887: p_attr_metadata_obj.MAXIMUM_SIZE <
4888: LENGTH(TO_CHAR(p_attr_value_obj.ATTR_VALUE_NUM))) THEN

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

4998: ,'MIN');
4999:
5000: IF (NOT l_is_val_set_respected) THEN
5001:
5002: IF (p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
5003:
5004: l_err_msg_name := 'EGO_EF_MIN_VAL_NUM_VIOLATED';
5005:
5006: l_token_table(1).TOKEN_NAME := 'ATTR_NAME';

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

5030: ,'MAX');
5031:
5032: IF (NOT l_is_val_set_respected) THEN
5033:
5034: IF (p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
5035:
5036: l_err_msg_name := 'EGO_EF_MAX_VAL_NUM_VIOLATED';
5037:
5038: l_token_table(1).TOKEN_NAME := 'ATTR_NAME';

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

5061: -- If the Attribute has a Value Set whose Values have different Internal --
5062: -- and Display Values, we need to validate the passed-in value (which has --
5063: -- to be either an Internal Value or a Display Value for the Value Set) --
5064: ----------------------------------------------------------------------------
5065: ELSIF (p_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_INDEPENDENT_VALIDATION_CODE OR
5066: p_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_TRANS_IND_VALIDATION_CODE OR
5067: p_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_TABLE_VALIDATION_CODE) THEN
5068:
5069: -------------------------------------------

Line 5066: p_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_TRANS_IND_VALIDATION_CODE OR

5062: -- and Display Values, we need to validate the passed-in value (which has --
5063: -- to be either an Internal Value or a Display Value for the Value Set) --
5064: ----------------------------------------------------------------------------
5065: ELSIF (p_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_INDEPENDENT_VALIDATION_CODE OR
5066: p_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_TRANS_IND_VALIDATION_CODE OR
5067: p_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_TABLE_VALIDATION_CODE) THEN
5068:
5069: -------------------------------------------
5070: -- If the user passed the Display Value, --

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

5063: -- to be either an Internal Value or a Display Value for the Value Set) --
5064: ----------------------------------------------------------------------------
5065: ELSIF (p_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_INDEPENDENT_VALIDATION_CODE OR
5066: p_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_TRANS_IND_VALIDATION_CODE OR
5067: p_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_TABLE_VALIDATION_CODE) THEN
5068:
5069: -------------------------------------------
5070: -- If the user passed the Display Value, --
5071: -- we will try to get the Internal Value --

Line 5093: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE OR

5089: );
5090:
5091: IF (l_int_value IS NOT NULL) THEN
5092: IF (p_attr_metadata_obj.DATA_TYPE_CODE IS NULL OR
5093: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE OR
5094: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE) THEN
5095:
5096: px_attr_value_obj.ATTR_VALUE_STR := l_int_value;
5097:

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

5090:
5091: IF (l_int_value IS NOT NULL) THEN
5092: IF (p_attr_metadata_obj.DATA_TYPE_CODE IS NULL OR
5093: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE OR
5094: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE) THEN
5095:
5096: px_attr_value_obj.ATTR_VALUE_STR := l_int_value;
5097:
5098: ELSIF (p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN

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

5094: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE) THEN
5095:
5096: px_attr_value_obj.ATTR_VALUE_STR := l_int_value;
5097:
5098: ELSIF (p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
5099:
5100: px_attr_value_obj.ATTR_VALUE_NUM := TO_NUMBER(l_int_value);
5101:
5102: ELSIF (p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE) THEN

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

5098: ELSIF (p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
5099:
5100: px_attr_value_obj.ATTR_VALUE_NUM := TO_NUMBER(l_int_value);
5101:
5102: ELSIF (p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE) THEN
5103:
5104: px_attr_value_obj.ATTR_VALUE_DATE := TRUNC(TO_DATE(l_int_value, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT));
5105:
5106: ELSIF (p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN

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

5102: ELSIF (p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE) THEN
5103:
5104: px_attr_value_obj.ATTR_VALUE_DATE := TRUNC(TO_DATE(l_int_value, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT));
5105:
5106: ELSIF (p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
5107:
5108: px_attr_value_obj.ATTR_VALUE_DATE := TO_DATE(l_int_value, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);
5109:
5110: END IF;

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

5483: -- and display values, we only want to try getting the internal value if --
5484: -- the caller has passed in the display value and nothing else; otherwise --
5485: -- we want to use the passed-in internal value and thus avoid a query. --
5486: ----------------------------------------------------------------------------
5487: IF ((l_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_INDEPENDENT_VALIDATION_CODE OR
5488: l_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_TRANS_IND_VALIDATION_CODE OR
5489: l_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_TABLE_VALIDATION_CODE) AND
5490: (px_attr_name_value_pairs(l_attr_value_index).ATTR_DISP_VALUE IS NOT NULL) AND
5491: (px_attr_name_value_pairs(l_attr_value_index).ATTR_VALUE_STR IS NULL AND

Line 5488: l_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_TRANS_IND_VALIDATION_CODE OR

5484: -- the caller has passed in the display value and nothing else; otherwise --
5485: -- we want to use the passed-in internal value and thus avoid a query. --
5486: ----------------------------------------------------------------------------
5487: IF ((l_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_INDEPENDENT_VALIDATION_CODE OR
5488: l_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_TRANS_IND_VALIDATION_CODE OR
5489: l_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_TABLE_VALIDATION_CODE) AND
5490: (px_attr_name_value_pairs(l_attr_value_index).ATTR_DISP_VALUE IS NOT NULL) AND
5491: (px_attr_name_value_pairs(l_attr_value_index).ATTR_VALUE_STR IS NULL AND
5492: px_attr_name_value_pairs(l_attr_value_index).ATTR_VALUE_NUM IS NULL AND

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

5485: -- we want to use the passed-in internal value and thus avoid a query. --
5486: ----------------------------------------------------------------------------
5487: IF ((l_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_INDEPENDENT_VALIDATION_CODE OR
5488: l_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_TRANS_IND_VALIDATION_CODE OR
5489: l_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_TABLE_VALIDATION_CODE) AND
5490: (px_attr_name_value_pairs(l_attr_value_index).ATTR_DISP_VALUE IS NOT NULL) AND
5491: (px_attr_name_value_pairs(l_attr_value_index).ATTR_VALUE_STR IS NULL AND
5492: px_attr_name_value_pairs(l_attr_value_index).ATTR_VALUE_NUM IS NULL AND
5493: px_attr_name_value_pairs(l_attr_value_index).ATTR_VALUE_DATE IS NULL)) THEN

Line 5510: l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE OR

5506: );
5507:
5508: IF (l_int_value IS NOT NULL) THEN
5509: IF (l_attr_metadata_obj.DATA_TYPE_CODE IS NULL OR
5510: l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE OR
5511: l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE) THEN
5512: px_attr_name_value_pairs(l_attr_value_index).ATTR_VALUE_STR := l_int_value;
5513: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
5514: px_attr_name_value_pairs(l_attr_value_index).ATTR_VALUE_NUM := TO_NUMBER(l_int_value);

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

5507:
5508: IF (l_int_value IS NOT NULL) THEN
5509: IF (l_attr_metadata_obj.DATA_TYPE_CODE IS NULL OR
5510: l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE OR
5511: l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE) THEN
5512: px_attr_name_value_pairs(l_attr_value_index).ATTR_VALUE_STR := l_int_value;
5513: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
5514: px_attr_name_value_pairs(l_attr_value_index).ATTR_VALUE_NUM := TO_NUMBER(l_int_value);
5515: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE) THEN

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

5509: IF (l_attr_metadata_obj.DATA_TYPE_CODE IS NULL OR
5510: l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE OR
5511: l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE) THEN
5512: px_attr_name_value_pairs(l_attr_value_index).ATTR_VALUE_STR := l_int_value;
5513: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
5514: px_attr_name_value_pairs(l_attr_value_index).ATTR_VALUE_NUM := TO_NUMBER(l_int_value);
5515: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE) THEN
5516: 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));
5517: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN

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

5511: l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE) THEN
5512: px_attr_name_value_pairs(l_attr_value_index).ATTR_VALUE_STR := l_int_value;
5513: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
5514: px_attr_name_value_pairs(l_attr_value_index).ATTR_VALUE_NUM := TO_NUMBER(l_int_value);
5515: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE) THEN
5516: 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));
5517: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
5518: 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);
5519: END IF;

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

5513: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
5514: px_attr_name_value_pairs(l_attr_value_index).ATTR_VALUE_NUM := TO_NUMBER(l_int_value);
5515: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE) THEN
5516: 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));
5517: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
5518: 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);
5519: END IF;
5520: ELSE
5521:

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

5560: -- Finally, we check for the much less common case where the Attribute is a --
5561: -- Date, but the value passed in is a $SYSDATE$ expression of some sort; in --
5562: -- such a case, we want to replace the expression with the appropriate Date --
5563: ------------------------------------------------------------------------------
5564: ELSIF ((l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR
5565: l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE)
5566: AND
5567: (px_attr_name_value_pairs(l_attr_value_index).ATTR_VALUE_STR IS NOT NULL AND
5568: px_attr_name_value_pairs(l_attr_value_index).ATTR_VALUE_DATE IS NULL)) THEN

Line 5565: l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE)

5561: -- Date, but the value passed in is a $SYSDATE$ expression of some sort; in --
5562: -- such a case, we want to replace the expression with the appropriate Date --
5563: ------------------------------------------------------------------------------
5564: ELSIF ((l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR
5565: l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE)
5566: AND
5567: (px_attr_name_value_pairs(l_attr_value_index).ATTR_VALUE_STR IS NOT NULL AND
5568: px_attr_name_value_pairs(l_attr_value_index).ATTR_VALUE_DATE IS NULL)) THEN
5569:

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

5571: l_formatted_expression VARCHAR2(150);
5572: BEGIN
5573: l_formatted_expression := Format_Sysdate_Expression(px_attr_name_value_pairs(l_attr_value_index).ATTR_VALUE_STR);
5574:
5575: IF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE) THEN
5576: 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));
5577: ELSE
5578: 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);
5579: END IF;

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

5867: NVL(px_attr_diffs(L_ATTRS_INDEX).NEW_ATTR_VALUE_DATE,FND_API.G_MISS_DATE))THEN
5868: l_attr_name_val.EXTEND();
5869: -- l_attr_rec.attr_value := to_char(px_attr_diffs(L_ATTRS_INDEX).NEW_ATTR_VALUE_DATE);
5870: -- abedajna Bug 6134504 begin
5871: if ( l_curr_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE ) then -- timestamp
5872: 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);
5873: elsif ( l_curr_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE) then -- date
5874: l_attr_rec.attr_value := to_char(px_attr_diffs(L_ATTRS_INDEX).NEW_ATTR_VALUE_DATE);
5875: end if;

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

5869: -- l_attr_rec.attr_value := to_char(px_attr_diffs(L_ATTRS_INDEX).NEW_ATTR_VALUE_DATE);
5870: -- abedajna Bug 6134504 begin
5871: if ( l_curr_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE ) then -- timestamp
5872: 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);
5873: elsif ( l_curr_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE) then -- date
5874: l_attr_rec.attr_value := to_char(px_attr_diffs(L_ATTRS_INDEX).NEW_ATTR_VALUE_DATE);
5875: end if;
5876: -- abedajna Bug 6134504 end
5877: l_attr_name_val(l_attr_name_val.LAST) := l_attr_rec;

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

5894: l_attr_rec.attr_value := TO_CHAR(px_attr_diffs(L_ATTRS_INDEX).NEW_ATTR_VALUE_num);
5895: ELSIF px_attr_diffs(L_ATTRS_INDEX).NEW_ATTR_VALUE_DATE IS NOT NULL THEN
5896: -- l_attr_rec.attr_value := TO_CHAR(px_attr_diffs(L_ATTRS_INDEX).NEW_ATTR_VALUE_DATE);
5897: -- abedajna Bug 6134504 begin
5898: if ( l_curr_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE ) then -- timestamp
5899: 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);
5900: elsif ( l_curr_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE) then -- date
5901: l_attr_rec.attr_value := to_char(px_attr_diffs(L_ATTRS_INDEX).NEW_ATTR_VALUE_DATE);
5902: end if;

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

5896: -- l_attr_rec.attr_value := TO_CHAR(px_attr_diffs(L_ATTRS_INDEX).NEW_ATTR_VALUE_DATE);
5897: -- abedajna Bug 6134504 begin
5898: if ( l_curr_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE ) then -- timestamp
5899: 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);
5900: elsif ( l_curr_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE) then -- date
5901: l_attr_rec.attr_value := to_char(px_attr_diffs(L_ATTRS_INDEX).NEW_ATTR_VALUE_DATE);
5902: end if;
5903: -- abedajna Bug 6134504 end
5904: ELSE

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

5925: l_attr_rec.attr_value := TO_CHAR(px_attr_diffs(L_ATTRS_INDEX).OLD_ATTR_VALUE_num);
5926: ELSIF px_attr_diffs(L_ATTRS_INDEX).OLD_ATTR_VALUE_DATE IS NOT NULL THEN
5927: -- l_attr_rec.attr_value := TO_CHAR(px_attr_diffs(L_ATTRS_INDEX).OLD_ATTR_VALUE_DATE);
5928: -- abedajna Bug 6134504 begin
5929: if ( l_curr_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) then -- timestamp
5930: 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);
5931: elsif ( l_curr_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE) then -- date
5932: l_attr_rec.attr_value := to_char(px_attr_diffs(L_ATTRS_INDEX).OLD_ATTR_VALUE_DATE);
5933: end if;

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

5927: -- l_attr_rec.attr_value := TO_CHAR(px_attr_diffs(L_ATTRS_INDEX).OLD_ATTR_VALUE_DATE);
5928: -- abedajna Bug 6134504 begin
5929: if ( l_curr_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) then -- timestamp
5930: 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);
5931: elsif ( l_curr_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE) then -- date
5932: l_attr_rec.attr_value := to_char(px_attr_diffs(L_ATTRS_INDEX).OLD_ATTR_VALUE_DATE);
5933: end if;
5934: -- abedajna Bug 6134504 end
5935: ELSE

Line 10700: EGO_EXT_FWK_PUB.G_INDEPENDENT_VALIDATION_CODE,

10696: -- we build or update a DECODE query for the Database Column (so --
10697: -- that each AG's use of the column gets the correct Disp value) --
10698: --------------------------------------------------------------------
10699: IF (l_curr_attr_metadata_obj.VALIDATION_CODE IN (
10700: EGO_EXT_FWK_PUB.G_INDEPENDENT_VALIDATION_CODE,
10701: EGO_EXT_FWK_PUB.G_TRANS_IND_VALIDATION_CODE)
10702: ) THEN
10703:
10704: l_int_to_disp_val_string := l_curr_attr_metadata_obj.INT_TO_DISP_VAL_QUERY;

Line 10701: EGO_EXT_FWK_PUB.G_TRANS_IND_VALIDATION_CODE)

10697: -- that each AG's use of the column gets the correct Disp value) --
10698: --------------------------------------------------------------------
10699: IF (l_curr_attr_metadata_obj.VALIDATION_CODE IN (
10700: EGO_EXT_FWK_PUB.G_INDEPENDENT_VALIDATION_CODE,
10701: EGO_EXT_FWK_PUB.G_TRANS_IND_VALIDATION_CODE)
10702: ) THEN
10703:
10704: l_int_to_disp_val_string := l_curr_attr_metadata_obj.INT_TO_DISP_VAL_QUERY;
10705:

Line 10707: EGO_EXT_FWK_PUB.G_TABLE_VALIDATION_CODE) THEN

10703:
10704: l_int_to_disp_val_string := l_curr_attr_metadata_obj.INT_TO_DISP_VAL_QUERY;
10705:
10706: ELSIF (l_curr_attr_metadata_obj.VALIDATION_CODE =
10707: EGO_EXT_FWK_PUB.G_TABLE_VALIDATION_CODE) THEN
10708:
10709: ----------------------------------------------------------------
10710: -- In this case we DON'T want to cast the result to a string, --
10711: -- so we revert our expression to being the database column --

Line 10775: ( EGO_EXT_FWK_PUB.G_INDEPENDENT_VALIDATION_CODE,

10771: -- Syalaman - Fix for bug 5859465.
10772: -- Fix made to take care Independent Value set Type
10773: -- For Bug id 5859465
10774: IF (l_curr_attr_metadata_obj.VALIDATION_CODE IN
10775: ( EGO_EXT_FWK_PUB.G_INDEPENDENT_VALIDATION_CODE,
10776: EGO_EXT_FWK_PUB.G_TRANS_IND_VALIDATION_CODE)) THEN
10777:
10778: l_temp_db_query_string := 'DECODE(ATTR_GROUP_ID,'||
10779: l_curr_attr_metadata_obj.ATTR_GROUP_ID||' ,('||

Line 10776: EGO_EXT_FWK_PUB.G_TRANS_IND_VALIDATION_CODE)) THEN

10772: -- Fix made to take care Independent Value set Type
10773: -- For Bug id 5859465
10774: IF (l_curr_attr_metadata_obj.VALIDATION_CODE IN
10775: ( EGO_EXT_FWK_PUB.G_INDEPENDENT_VALIDATION_CODE,
10776: EGO_EXT_FWK_PUB.G_TRANS_IND_VALIDATION_CODE)) THEN
10777:
10778: l_temp_db_query_string := 'DECODE(ATTR_GROUP_ID,'||
10779: l_curr_attr_metadata_obj.ATTR_GROUP_ID||' ,('||
10780: l_int_to_disp_val_string||

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

15101:
15102: ------------------------
15103: -- Define the outputs --
15104: ------------------------
15105: IF (p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
15106: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, x_num_val);
15107: ELSIF (p_attr_metadata_obj.DATA_TYPE_CODE = 'X' OR p_attr_metadata_obj.DATA_TYPE_CODE = 'Y') THEN
15108: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, l_str,150);
15109: ELSE

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

15411: -- At this point I have the internal value; if the Attr --
15412: -- has a display value, I need to try to get it instead --
15413: ----------------------------------------------------------
15414: -- fix for bug 4543638 included translatable independent validation code to get disp value
15415: IF (l_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_INDEPENDENT_VALIDATION_CODE OR
15416: l_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_TRANS_IND_VALIDATION_CODE OR
15417: l_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_TABLE_VALIDATION_CODE) THEN
15418:
15419: ------------------------------------------------------------

Line 15416: l_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_TRANS_IND_VALIDATION_CODE OR

15412: -- has a display value, I need to try to get it instead --
15413: ----------------------------------------------------------
15414: -- fix for bug 4543638 included translatable independent validation code to get disp value
15415: IF (l_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_INDEPENDENT_VALIDATION_CODE OR
15416: l_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_TRANS_IND_VALIDATION_CODE OR
15417: l_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_TABLE_VALIDATION_CODE) THEN
15418:
15419: ------------------------------------------------------------
15420: -- We must query up the rest of the attribute data in the --

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

15413: ----------------------------------------------------------
15414: -- fix for bug 4543638 included translatable independent validation code to get disp value
15415: IF (l_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_INDEPENDENT_VALIDATION_CODE OR
15416: l_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_TRANS_IND_VALIDATION_CODE OR
15417: l_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_TABLE_VALIDATION_CODE) THEN
15418:
15419: ------------------------------------------------------------
15420: -- We must query up the rest of the attribute data in the --
15421: -- same group in case there are binds --

Line 15491: (EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE,

15487: -- change the format to user preferences, else we return --
15488: -- the obtained String as it is. --
15489: ------------------------------------------------------------
15490: IF ( l_attr_metadata_obj.DATA_TYPE_CODE IN
15491: (EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE,
15492: EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) )
15493: THEN
15494: l_attr_disp_value := EGO_USER_ATTRS_COMMON_PVT.Get_User_Pref_Date_Time_Val(
15495: p_date => TO_DATE(l_attr_int_value,EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT)

Line 15492: EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) )

15488: -- the obtained String as it is. --
15489: ------------------------------------------------------------
15490: IF ( l_attr_metadata_obj.DATA_TYPE_CODE IN
15491: (EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE,
15492: EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) )
15493: THEN
15494: l_attr_disp_value := EGO_USER_ATTRS_COMMON_PVT.Get_User_Pref_Date_Time_Val(
15495: p_date => TO_DATE(l_attr_int_value,EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT)
15496: ,p_attr_type => l_attr_metadata_obj.DATA_TYPE_CODE

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

15508: -- or DateTime and is coming from a Independent Type
15509: -- of Valueset then we change the format to user preferences,
15510: -- else we return the obtained String as it is.
15511: ------------------------------------------------------------
15512: IF ((l_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_INDEPENDENT_VALIDATION_CODE )
15513: AND (l_attr_metadata_obj.DATA_TYPE_CODE IN
15514: (EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE,
15515: EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE)))
15516: THEN

Line 15514: (EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE,

15510: -- else we return the obtained String as it is.
15511: ------------------------------------------------------------
15512: IF ((l_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_INDEPENDENT_VALIDATION_CODE )
15513: AND (l_attr_metadata_obj.DATA_TYPE_CODE IN
15514: (EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE,
15515: EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE)))
15516: THEN
15517: l_attr_disp_value := EGO_USER_ATTRS_COMMON_PVT.Get_User_Pref_Date_Time_Val(
15518: p_date => TO_DATE(l_attr_disp_value,EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT)

Line 15515: EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE)))

15511: ------------------------------------------------------------
15512: IF ((l_attr_metadata_obj.VALIDATION_CODE = EGO_EXT_FWK_PUB.G_INDEPENDENT_VALIDATION_CODE )
15513: AND (l_attr_metadata_obj.DATA_TYPE_CODE IN
15514: (EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE,
15515: EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE)))
15516: THEN
15517: l_attr_disp_value := EGO_USER_ATTRS_COMMON_PVT.Get_User_Pref_Date_Time_Val(
15518: p_date => TO_DATE(l_attr_disp_value,EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT)
15519: ,p_attr_type => l_attr_metadata_obj.DATA_TYPE_CODE

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

16062: IF l_attr_metadata_obj.VALUE_SET_ID IS NULL THEN
16063: -- if the data is coming from intf table we have a possibility that its not
16064: -- valid in terms of datatype. We return a null in such a case.
16065: IF p_return_intf_col IS NOT NULL THEN
16066: IF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE)
16067: AND (p_return_intf_col = 'ATTR_VALUE_NUM') THEN
16068: RETURN TO_CHAR(TO_NUMBER(p_attr_disp_value));
16069: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE
16070: OR l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE)

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

16065: IF p_return_intf_col IS NOT NULL THEN
16066: IF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE)
16067: AND (p_return_intf_col = 'ATTR_VALUE_NUM') THEN
16068: RETURN TO_CHAR(TO_NUMBER(p_attr_disp_value));
16069: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE
16070: OR l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE)
16071: AND (p_return_intf_col = 'ATTR_VALUE_DATE') THEN
16072: 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);
16073: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE

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

16066: IF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE)
16067: AND (p_return_intf_col = 'ATTR_VALUE_NUM') THEN
16068: RETURN TO_CHAR(TO_NUMBER(p_attr_disp_value));
16069: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE
16070: OR l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE)
16071: AND (p_return_intf_col = 'ATTR_VALUE_DATE') THEN
16072: 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);
16073: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE
16074: OR l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE)

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

16069: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE
16070: OR l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE)
16071: AND (p_return_intf_col = 'ATTR_VALUE_DATE') THEN
16072: 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);
16073: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE
16074: OR l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE)
16075: AND (p_return_intf_col = 'ATTR_VALUE_STR') THEN
16076: RETURN p_attr_disp_value;
16077: ELSE

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

16070: OR l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE)
16071: AND (p_return_intf_col = 'ATTR_VALUE_DATE') THEN
16072: 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);
16073: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE
16074: OR l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE)
16075: AND (p_return_intf_col = 'ATTR_VALUE_STR') THEN
16076: RETURN p_attr_disp_value;
16077: ELSE
16078: RETURN NULL;

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

16093: -- the appropriate column.
16094: IF p_return_intf_col IS NOT NULL THEN
16095:
16096: IF p_return_intf_col = 'ATTR_VALUE_STR' THEN
16097: IF (l_attr_metadata_obj.DATA_TYPE_CODE <> EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE
16098: AND l_attr_metadata_obj.DATA_TYPE_CODE <> EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE) THEN
16099: RETURN NULL;
16100: END IF;
16101:

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

16094: IF p_return_intf_col IS NOT NULL THEN
16095:
16096: IF p_return_intf_col = 'ATTR_VALUE_STR' THEN
16097: IF (l_attr_metadata_obj.DATA_TYPE_CODE <> EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE
16098: AND l_attr_metadata_obj.DATA_TYPE_CODE <> EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE) THEN
16099: RETURN NULL;
16100: END IF;
16101:
16102: ELSIF p_return_intf_col = 'ATTR_VALUE_NUM' THEN

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

16099: RETURN NULL;
16100: END IF;
16101:
16102: ELSIF p_return_intf_col = 'ATTR_VALUE_NUM' THEN
16103: IF l_attr_metadata_obj.DATA_TYPE_CODE <> EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE THEN
16104: RETURN NULL;
16105: END IF;
16106:
16107: ELSIF p_return_intf_col = 'ATTR_VALUE_DATE' THEN

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

16104: RETURN NULL;
16105: END IF;
16106:
16107: ELSIF p_return_intf_col = 'ATTR_VALUE_DATE' THEN
16108: IF (l_attr_metadata_obj.DATA_TYPE_CODE <> EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE
16109: AND l_attr_metadata_obj.DATA_TYPE_CODE <> EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
16110: RETURN NULL;
16111: END IF;
16112:

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

16105: END IF;
16106:
16107: ELSIF p_return_intf_col = 'ATTR_VALUE_DATE' THEN
16108: IF (l_attr_metadata_obj.DATA_TYPE_CODE <> EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE
16109: AND l_attr_metadata_obj.DATA_TYPE_CODE <> EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
16110: RETURN NULL;
16111: END IF;
16112:
16113: END IF;

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

16151:
16152:
16153: BEGIN
16154: IF p_return_intf_col IS NOT NULL THEN
16155: IF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE)
16156: AND (p_return_intf_col = 'ATTR_VALUE_NUM') THEN
16157: l_attr_internal_value := TO_CHAR(TO_NUMBER(l_attr_internal_value));
16158: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE
16159: OR l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE)

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

16154: IF p_return_intf_col IS NOT NULL THEN
16155: IF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE)
16156: AND (p_return_intf_col = 'ATTR_VALUE_NUM') THEN
16157: l_attr_internal_value := TO_CHAR(TO_NUMBER(l_attr_internal_value));
16158: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE
16159: OR l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE)
16160: AND (p_return_intf_col = 'ATTR_VALUE_DATE') THEN
16161: 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);
16162: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE

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

16155: IF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE)
16156: AND (p_return_intf_col = 'ATTR_VALUE_NUM') THEN
16157: l_attr_internal_value := TO_CHAR(TO_NUMBER(l_attr_internal_value));
16158: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE
16159: OR l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE)
16160: AND (p_return_intf_col = 'ATTR_VALUE_DATE') THEN
16161: 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);
16162: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE
16163: OR l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE)

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

16158: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE
16159: OR l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE)
16160: AND (p_return_intf_col = 'ATTR_VALUE_DATE') THEN
16161: 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);
16162: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE
16163: OR l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE)
16164: AND (p_return_intf_col = 'ATTR_VALUE_STR') THEN
16165: l_attr_internal_value := l_attr_internal_value;
16166: END IF;

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

16159: OR l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE)
16160: AND (p_return_intf_col = 'ATTR_VALUE_DATE') THEN
16161: 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);
16162: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE
16163: OR l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE)
16164: AND (p_return_intf_col = 'ATTR_VALUE_STR') THEN
16165: l_attr_internal_value := l_attr_internal_value;
16166: END IF;
16167: END IF;

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

17424: LOOP
17425: FETCH attr_rec_cursor INTO l_attr_record;
17426: EXIT WHEN attr_rec_cursor%NOTFOUND;
17427:
17428: IF(l_attr_record.DATA_TYPE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE)THEN
17429: l_number_val := TO_NUMBER(l_attr_record.DEFAULT_VALUE);
17430: l_str_val := NULL;
17431: l_date_val := NULL;
17432: ELSIF (l_attr_record.DATA_TYPE = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE OR

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

17428: IF(l_attr_record.DATA_TYPE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE)THEN
17429: l_number_val := TO_NUMBER(l_attr_record.DEFAULT_VALUE);
17430: l_str_val := NULL;
17431: l_date_val := NULL;
17432: ELSIF (l_attr_record.DATA_TYPE = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE OR
17433: l_attr_record.DATA_TYPE = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE) THEN
17434: l_number_val := NULL;
17435: l_str_val := l_attr_record.DEFAULT_VALUE;
17436: l_date_val := NULL;

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

17429: l_number_val := TO_NUMBER(l_attr_record.DEFAULT_VALUE);
17430: l_str_val := NULL;
17431: l_date_val := NULL;
17432: ELSIF (l_attr_record.DATA_TYPE = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE OR
17433: l_attr_record.DATA_TYPE = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE) THEN
17434: l_number_val := NULL;
17435: l_str_val := l_attr_record.DEFAULT_VALUE;
17436: l_date_val := NULL;
17437: ELSIF(l_attr_record.DATA_TYPE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR

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

17433: l_attr_record.DATA_TYPE = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE) THEN
17434: l_number_val := NULL;
17435: l_str_val := l_attr_record.DEFAULT_VALUE;
17436: l_date_val := NULL;
17437: ELSIF(l_attr_record.DATA_TYPE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR
17438: l_attr_record.DATA_TYPE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
17439: l_number_val := NULL;
17440: l_str_val := NULL;
17441: IF(INSTR(UPPER(l_attr_record.DEFAULT_VALUE),'$SYSDATE$') <> 0) THEN

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

17434: l_number_val := NULL;
17435: l_str_val := l_attr_record.DEFAULT_VALUE;
17436: l_date_val := NULL;
17437: ELSIF(l_attr_record.DATA_TYPE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR
17438: l_attr_record.DATA_TYPE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
17439: l_number_val := NULL;
17440: l_str_val := NULL;
17441: IF(INSTR(UPPER(l_attr_record.DEFAULT_VALUE),'$SYSDATE$') <> 0) THEN
17442: l_temp_date_str := REPLACE(UPPER(l_attr_record.DEFAULT_VALUE),'$'); --bugfix:5228308