885: l_plsql VARCHAR2(32000);
886: l_char_in VARCHAR2(2000) := Upper(p_char_in);
887: BEGIN
888: internal_init();
889: IF (l_char_in = 'FND_DATE.USER_MASK') THEN
890: l_char_out := fnd_date.user_mask;
891: ELSIF (l_char_in = 'FND_DATE.USERDT_MASK') THEN
892: l_char_out := fnd_date.userdt_mask;
893: ELSIF (l_char_in = 'FND_NUMBER.DECIMAL_CHAR') THEN
886: l_char_in VARCHAR2(2000) := Upper(p_char_in);
887: BEGIN
888: internal_init();
889: IF (l_char_in = 'FND_DATE.USER_MASK') THEN
890: l_char_out := fnd_date.user_mask;
891: ELSIF (l_char_in = 'FND_DATE.USERDT_MASK') THEN
892: l_char_out := fnd_date.userdt_mask;
893: ELSIF (l_char_in = 'FND_NUMBER.DECIMAL_CHAR') THEN
894: l_char_out := fnd_number.decimal_char;
887: BEGIN
888: internal_init();
889: IF (l_char_in = 'FND_DATE.USER_MASK') THEN
890: l_char_out := fnd_date.user_mask;
891: ELSIF (l_char_in = 'FND_DATE.USERDT_MASK') THEN
892: l_char_out := fnd_date.userdt_mask;
893: ELSIF (l_char_in = 'FND_NUMBER.DECIMAL_CHAR') THEN
894: l_char_out := fnd_number.decimal_char;
895: ELSE
888: internal_init();
889: IF (l_char_in = 'FND_DATE.USER_MASK') THEN
890: l_char_out := fnd_date.user_mask;
891: ELSIF (l_char_in = 'FND_DATE.USERDT_MASK') THEN
892: l_char_out := fnd_date.userdt_mask;
893: ELSIF (l_char_in = 'FND_NUMBER.DECIMAL_CHAR') THEN
894: l_char_out := fnd_number.decimal_char;
895: ELSE
896: l_plsql := 'BEGIN :l_char_out := ' || p_char_in || '; END;';
948: --
949: IF (p_tz_direction = g_tz_server_to_local) THEN
950: --
951: -- Server to Local Time Zone conversion.
952: -- fnd_date.date_to_displayDT() returns in fnd_date.outputDT_mask.
953: --
954: l_output := fnd_date.date_to_displayDT(l_input_date);
955: l_output_date := To_date(l_output, fnd_date.outputDT_mask);
956:
950: --
951: -- Server to Local Time Zone conversion.
952: -- fnd_date.date_to_displayDT() returns in fnd_date.outputDT_mask.
953: --
954: l_output := fnd_date.date_to_displayDT(l_input_date);
955: l_output_date := To_date(l_output, fnd_date.outputDT_mask);
956:
957: ELSIF (p_tz_direction = g_tz_local_to_server) THEN
958: --
951: -- Server to Local Time Zone conversion.
952: -- fnd_date.date_to_displayDT() returns in fnd_date.outputDT_mask.
953: --
954: l_output := fnd_date.date_to_displayDT(l_input_date);
955: l_output_date := To_date(l_output, fnd_date.outputDT_mask);
956:
957: ELSIF (p_tz_direction = g_tz_local_to_server) THEN
958: --
959: -- Local to Server Time Zone conversion.
956:
957: ELSIF (p_tz_direction = g_tz_local_to_server) THEN
958: --
959: -- Local to Server Time Zone conversion.
960: -- fnd_date.displayDT_to_date() expects in fnd_date.userDT_mask.
961: --
962: l_input := To_char(l_input_date, fnd_date.userDT_mask);
963: l_output_date := fnd_date.displayDT_to_date(l_input);
964:
958: --
959: -- Local to Server Time Zone conversion.
960: -- fnd_date.displayDT_to_date() expects in fnd_date.userDT_mask.
961: --
962: l_input := To_char(l_input_date, fnd_date.userDT_mask);
963: l_output_date := fnd_date.displayDT_to_date(l_input);
964:
965: ELSE
966: ssv_exception(l_code_name, ('Invalid p_tz_direction: ' ||
959: -- Local to Server Time Zone conversion.
960: -- fnd_date.displayDT_to_date() expects in fnd_date.userDT_mask.
961: --
962: l_input := To_char(l_input_date, fnd_date.userDT_mask);
963: l_output_date := fnd_date.displayDT_to_date(l_input);
964:
965: ELSE
966: ssv_exception(l_code_name, ('Invalid p_tz_direction: ' ||
967: p_tz_direction));
990: ', p_input: ' || p_input ||
991: ', p_input_mask: ' || p_input_mask ||
992: ', l_otput: ' || l_output ||
993: ', p_output_mask: ' || p_output_mask ||
994: ', fnd_date.outputDT_mask: ' || fnd_date.outputDT_mask ||
995: ', fnd_date.userDT_mask: ' || fnd_date.userDT_mask);
996: x_output := l_output;
997: RETURN;
998:
991: ', p_input_mask: ' || p_input_mask ||
992: ', l_otput: ' || l_output ||
993: ', p_output_mask: ' || p_output_mask ||
994: ', fnd_date.outputDT_mask: ' || fnd_date.outputDT_mask ||
995: ', fnd_date.userDT_mask: ' || fnd_date.userDT_mask);
996: x_output := l_output;
997: RETURN;
998:
999: <
1008: ', p_tz_direction: ' || p_tz_direction ||
1009: ', p_input: ' || p_input ||
1010: ', p_input_mask: ' || p_input_mask ||
1011: ', p_output_mask: ' || p_output_mask ||
1012: ', fnd_date.outputDT_mask: ' || fnd_date.outputDT_mask ||
1013: ', fnd_date.userDT_mask: ' || fnd_date.userDT_mask));
1014:
1015: x_message := Substrb(fnd_message.get_encoded,1,1998);
1016: END flex_date_converter;
1009: ', p_input: ' || p_input ||
1010: ', p_input_mask: ' || p_input_mask ||
1011: ', p_output_mask: ' || p_output_mask ||
1012: ', fnd_date.outputDT_mask: ' || fnd_date.outputDT_mask ||
1013: ', fnd_date.userDT_mask: ' || fnd_date.userDT_mask));
1014:
1015: x_message := Substrb(fnd_message.get_encoded,1,1998);
1016: END flex_date_converter;
1017:
1059: --
1060: -- === IF (p_tz_direction = g_tz_server_to_local) THEN
1061: --
1062: -- Server to Local Time Zone conversion.
1063: -- fnd_date.date_to_displayDT() returns in fnd_date.outputDT_mask.
1064: --
1065: -- === l_output := fnd_date.date_to_displayDT(l_input_date);
1066: -- === l_output_date := To_date(l_output, fnd_date.outputDT_mask);
1067:
1061: --
1062: -- Server to Local Time Zone conversion.
1063: -- fnd_date.date_to_displayDT() returns in fnd_date.outputDT_mask.
1064: --
1065: -- === l_output := fnd_date.date_to_displayDT(l_input_date);
1066: -- === l_output_date := To_date(l_output, fnd_date.outputDT_mask);
1067:
1068: -- === ELSIF (p_tz_direction = g_tz_local_to_server) THEN
1069: --
1062: -- Server to Local Time Zone conversion.
1063: -- fnd_date.date_to_displayDT() returns in fnd_date.outputDT_mask.
1064: --
1065: -- === l_output := fnd_date.date_to_displayDT(l_input_date);
1066: -- === l_output_date := To_date(l_output, fnd_date.outputDT_mask);
1067:
1068: -- === ELSIF (p_tz_direction = g_tz_local_to_server) THEN
1069: --
1070: -- Local to Server Time Zone conversion.
1067:
1068: -- === ELSIF (p_tz_direction = g_tz_local_to_server) THEN
1069: --
1070: -- Local to Server Time Zone conversion.
1071: -- fnd_date.displayDT_to_date() expects in fnd_date.userDT_mask.
1072: --
1073: -- === l_input := To_char(l_input_date, fnd_date.userDT_mask);
1074: -- === l_output_date := fnd_date.displayDT_to_date(l_input);
1075:
1069: --
1070: -- Local to Server Time Zone conversion.
1071: -- fnd_date.displayDT_to_date() expects in fnd_date.userDT_mask.
1072: --
1073: -- === l_input := To_char(l_input_date, fnd_date.userDT_mask);
1074: -- === l_output_date := fnd_date.displayDT_to_date(l_input);
1075:
1076: -- === ELSE
1077: -- === ssv_exception(l_code_name, ('Invalid p_tz_direction: ' ||
1070: -- Local to Server Time Zone conversion.
1071: -- fnd_date.displayDT_to_date() expects in fnd_date.userDT_mask.
1072: --
1073: -- === l_input := To_char(l_input_date, fnd_date.userDT_mask);
1074: -- === l_output_date := fnd_date.displayDT_to_date(l_input);
1075:
1076: -- === ELSE
1077: -- === ssv_exception(l_code_name, ('Invalid p_tz_direction: ' ||
1078: -- === p_tz_direction));
1113: ', p_input: ' || p_input ||
1114: ', p_mask: ' || p_mask ||
1115: ', l_output: ' || l_output ||
1116: ', p_calendar: ' || p_calendar ||
1117: ', fnd_date.outputDT_mask: ' || fnd_date.outputDT_mask ||
1118: ', fnd_date.userDT_mask: ' || fnd_date.userDT_mask);
1119: x_output := l_output;
1120: RETURN;
1121:
1114: ', p_mask: ' || p_mask ||
1115: ', l_output: ' || l_output ||
1116: ', p_calendar: ' || p_calendar ||
1117: ', fnd_date.outputDT_mask: ' || fnd_date.outputDT_mask ||
1118: ', fnd_date.userDT_mask: ' || fnd_date.userDT_mask);
1119: x_output := l_output;
1120: RETURN;
1121:
1122: <
1132: ', p_cal_direction: ' || p_cal_direction ||
1133: ', p_input: ' || p_input ||
1134: ', p_mask: ' || p_mask ||
1135: ', p_calendar: ' || p_calendar ||
1136: ', fnd_date.outputDT_mask: ' || fnd_date.outputDT_mask ||
1137: ', fnd_date.userDT_mask: ' || fnd_date.userDT_mask));
1138:
1139: x_message := Substrb(fnd_message.get_encoded,1,1998);
1140: END flex_date_converter_cal;
1133: ', p_input: ' || p_input ||
1134: ', p_mask: ' || p_mask ||
1135: ', p_calendar: ' || p_calendar ||
1136: ', fnd_date.outputDT_mask: ' || fnd_date.outputDT_mask ||
1137: ', fnd_date.userDT_mask: ' || fnd_date.userDT_mask));
1138:
1139: x_message := Substrb(fnd_message.get_encoded,1,1998);
1140: END flex_date_converter_cal;
1141: -- =======================================================================
1901: BEGIN
1902: --
1903: -- Default NLS masks.
1904: --
1905: m_nls_date_in := fnd_date.user_mask;
1906: m_nls_date_out := fnd_date.output_mask;
1907: m_nls_datetime_in := fnd_date.userdt_mask;
1908: m_nls_datetime_out := fnd_date.outputdt_mask;
1909: m_nls_time_in := 'HH24:MI:SS';
1902: --
1903: -- Default NLS masks.
1904: --
1905: m_nls_date_in := fnd_date.user_mask;
1906: m_nls_date_out := fnd_date.output_mask;
1907: m_nls_datetime_in := fnd_date.userdt_mask;
1908: m_nls_datetime_out := fnd_date.outputdt_mask;
1909: m_nls_time_in := 'HH24:MI:SS';
1910: m_nls_time_out := 'HH24:MI:SS';
1903: -- Default NLS masks.
1904: --
1905: m_nls_date_in := fnd_date.user_mask;
1906: m_nls_date_out := fnd_date.output_mask;
1907: m_nls_datetime_in := fnd_date.userdt_mask;
1908: m_nls_datetime_out := fnd_date.outputdt_mask;
1909: m_nls_time_in := 'HH24:MI:SS';
1910: m_nls_time_out := 'HH24:MI:SS';
1911: m_db_numeric_chars := (Substr(To_char(1234.5,'FM9G999D9'), 6, 1) ||
1904: --
1905: m_nls_date_in := fnd_date.user_mask;
1906: m_nls_date_out := fnd_date.output_mask;
1907: m_nls_datetime_in := fnd_date.userdt_mask;
1908: m_nls_datetime_out := fnd_date.outputdt_mask;
1909: m_nls_time_in := 'HH24:MI:SS';
1910: m_nls_time_out := 'HH24:MI:SS';
1911: m_db_numeric_chars := (Substr(To_char(1234.5,'FM9G999D9'), 6, 1) ||
1912: Substr(To_char(1234.5,'FM9G999D9'), 2, 1));