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.FND_FLEX_VAL_UTIL dependencies on FND_DATE

Line 889: IF (l_char_in = 'FND_DATE.USER_MASK') THEN

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

Line 890: l_char_out := fnd_date.user_mask;

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;

Line 891: ELSIF (l_char_in = 'FND_DATE.USERDT_MASK') THEN

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

Line 892: l_char_out := fnd_date.userdt_mask;

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;';

Line 952: -- fnd_date.date_to_displayDT() returns in fnd_date.outputDT_mask.

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:

Line 954: l_output := fnd_date.date_to_displayDT(l_input_date);

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: --

Line 955: l_output_date := To_date(l_output, fnd_date.outputDT_mask);

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.

Line 960: -- fnd_date.displayDT_to_date() expects in fnd_date.userDT_mask.

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:

Line 962: l_input := To_char(l_input_date, fnd_date.userDT_mask);

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: ' ||

Line 963: l_output_date := fnd_date.displayDT_to_date(l_input);

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));

Line 994: ', fnd_date.outputDT_mask: ' || fnd_date.outputDT_mask ||

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:

Line 995: ', fnd_date.userDT_mask: ' || fnd_date.userDT_mask);

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: <>

Line 1012: ', fnd_date.outputDT_mask: ' || fnd_date.outputDT_mask ||

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;

Line 1013: ', fnd_date.userDT_mask: ' || fnd_date.userDT_mask));

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:

Line 1063: -- fnd_date.date_to_displayDT() returns in fnd_date.outputDT_mask.

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:

Line 1065: -- === l_output := fnd_date.date_to_displayDT(l_input_date);

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: --

Line 1066: -- === l_output_date := To_date(l_output, fnd_date.outputDT_mask);

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.

Line 1071: -- fnd_date.displayDT_to_date() expects in fnd_date.userDT_mask.

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:

Line 1073: -- === l_input := To_char(l_input_date, fnd_date.userDT_mask);

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: ' ||

Line 1074: -- === l_output_date := fnd_date.displayDT_to_date(l_input);

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));

Line 1117: ', fnd_date.outputDT_mask: ' || fnd_date.outputDT_mask ||

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:

Line 1118: ', fnd_date.userDT_mask: ' || fnd_date.userDT_mask);

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: <>

Line 1136: ', fnd_date.outputDT_mask: ' || fnd_date.outputDT_mask ||

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;

Line 1137: ', fnd_date.userDT_mask: ' || fnd_date.userDT_mask));

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: -- =======================================================================

Line 1905: m_nls_date_in := fnd_date.user_mask;

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';

Line 1906: m_nls_date_out := fnd_date.output_mask;

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';

Line 1907: m_nls_datetime_in := fnd_date.userdt_mask;

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) ||

Line 1908: m_nls_datetime_out := fnd_date.outputdt_mask;

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));