[Home] [Help]
16: l_date_format_mask VARCHAR2(100);
17:
18: BEGIN
19: --Bug Fix for Bug 9027024, need display the start/end date in the format as set in user preference
20: SELECT FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK')
21: INTO l_date_format_mask
22: FROM DUAL;
23:
24: /* decide which object type we are processing*/
843: IF l_attr_info.validation_code = 'I' THEN
844: /*If the attribute is DATE type, we need convert the format*/
845: IF l_attr_info.data_type_code = 'X' OR l_attr_info.data_type_code = 'Y' THEN
846:
847: SELECT FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK')
848: INTO l_date_format_mask
849: FROM DUAL;
850:
851: IF l_attr_info.data_type_code = 'Y' THEN
870: FROM FND_FLEX_VALUES_VL
871: WHERE FLEX_VALUE_SET_ID = l_attr_info.value_set_id
872: AND FLEX_VALUE = l_date_value;
873:
874: SELECT FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK')
875: INTO l_date_format_mask
876: FROM DUAL;
877:
878: IF l_attr_info.data_type_code = 'Y' THEN
1022: ELSE
1023: -- for the POPLIST value set, the display value is stored directly in the EXT TABLE
1024: x_display_value := l_date_value;
1025: END IF;
1026: SELECT FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK')
1027: INTO l_date_format_mask
1028: FROM DUAL;
1029:
1030: IF l_attr_info.data_type_code = 'Y' THEN
1065: /*Do nothing for the None Validation Type*/
1066: ELSIF l_attr_info.validation_code = 'N' THEN
1067: --DATE OR DATETIME data type
1068: IF (l_attr_info.data_type_code = 'X' OR l_attr_info.data_type_code = 'Y') AND l_date_value IS NOT NULL THEN
1069: SELECT FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK')
1070: INTO l_date_format_mask
1071: FROM DUAL;
1072:
1073: IF l_attr_info.data_type_code = 'Y' THEN
1096: /*For the DATE or DATETIME data types, the value stored in EXT table is the same as the value in value set meaning column*/
1097: /*What we need to do is to format the date value into the right format for the environment the user is in*/
1098: ELSIF l_attr_info.data_type_code = 'X' OR l_attr_info.data_type_code = 'Y' THEN
1099:
1100: SELECT FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK')
1101: INTO l_date_format_mask
1102: FROM DUAL;
1103:
1104: IF l_attr_info.data_type_code = 'Y' THEN