APPS.RRS_ATTR_PANE dependencies on DUAL

Line 22: FROM DUAL;

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*/
25: --Add RBAC on Site Object View
26: IF UPPER(p_object_type) = 'SITE' AND RRS_SECURITY_PUB.Check_Object_View_Privilege(1.0, 'RRS_SITE', p_object_id) = 'T' THEN

Line 774: FROM DUAL;

770:
771: /* construct the display value at the proper uom*/
772: SELECT ((l_code_value / l_uom_conversion_rate) || ' ' || l_uom)
773: INTO x_display_value
774: FROM DUAL;
775: --Bug 9247705: Use display_code rather than display_meaning.
776: x_display_type := l_attr_info.display_code || ' of ' || l_attr_info.data_type_code || ' with UOM';
777:
778: --DBMS_OUTPUT.PUT_LINE(x_display_value || ' is displayed as ' || x_display_type);

Line 849: FROM DUAL;

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
852: l_date_format_mask := l_date_format_mask || ' HH24:MI:SS';
853: END IF;

Line 876: FROM DUAL;

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
879: l_date_format_mask := l_date_format_mask || ' HH24:MI:SS';
880: END IF;

Line 1028: FROM DUAL;

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
1031: l_date_format_mask := l_date_format_mask || ' HH24:MI:SS';
1032: END IF;

Line 1071: FROM DUAL;

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
1074: l_date_format_mask := l_date_format_mask || ' HH24:MI:SS';
1075: END IF;

Line 1102: FROM DUAL;

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
1105: l_date_format_mask := l_date_format_mask || ' HH24:MI:SS';
1106: END IF;

Line 1318: FROM DUAL;

1314: --END IF;
1315:
1316: SELECT FROM_TZ(CAST(p_date AS TIMESTAMP), FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE) AT TIME ZONE FND_TIMEZONES.GET_CLIENT_TIMEZONE_CODE
1317: INTO l_timestamp
1318: FROM DUAL;
1319:
1320: --SELECT TO_TIMESTAMP(p_date) AT TIME ZONE FND_TIMEZONES.GET_CLIENT_TIMEZONE_CODE
1321: -- INTO l_timestamp
1322: -- FROM DUAL;

Line 1322: -- FROM DUAL;

1318: FROM DUAL;
1319:
1320: --SELECT TO_TIMESTAMP(p_date) AT TIME ZONE FND_TIMEZONES.GET_CLIENT_TIMEZONE_CODE
1321: -- INTO l_timestamp
1322: -- FROM DUAL;
1323:
1324: --IF p_date IS NULL THEN
1325: --DBMS_OUTPUT.PUT_LINE('p_date is null');
1326: --ELSIF l_timestamp IS NULL THEN