APPS.FND_FLEX_UPD_FMT dependencies on STANDARD

Line 34: specified table to conform to the new date and time standards.

30:
31: /* START_PUBLIC */
32:
33: /* Change the date format in the specified column of the
34: specified table to conform to the new date and time standards.
35: The new_format_type is one of Date, DateTime, or Time.
36: If the old format is not specified (as a format string
37: in the to_char format), then the old standard conrresponding
38: to the new format type is used.

Line 37: in the to_char format), then the old standard conrresponding

33: /* Change the date format in the specified column of the
34: specified table to conform to the new date and time standards.
35: The new_format_type is one of Date, DateTime, or Time.
36: If the old format is not specified (as a format string
37: in the to_char format), then the old standard conrresponding
38: to the new format type is used.
39: */
40: /* old 'standard' formats
41: old_date_fmt := 'DD-MON-YY HH24:MI:SS';

Line 40: /* old 'standard' formats

36: If the old format is not specified (as a format string
37: in the to_char format), then the old standard conrresponding
38: to the new format type is used.
39: */
40: /* old 'standard' formats
41: old_date_fmt := 'DD-MON-YY HH24:MI:SS';
42: old_datetime_fmt := 'DD-MON-YY HH24:MI:SS';
43: old_time_fmt := 'HH24:MI:SS';
44: */

Line 51: /* new standard formats */

47: column_name IN VARCHAR2,
48: new_format_type IN VARCHAR2,
49: old_format IN VARCHAR2 DEFAULT null)
50: IS
51: /* new standard formats */
52: std_date_fmt VARCHAR2(100) := 'YYYY/MM/DD HH24:MI:SS';
53: std_datetime_fmt VARCHAR2(100) := 'YYYY/MM/DD HH24:MI:SS';
54: std_time_fmt VARCHAR2(100) := 'HH24:MI:SS';
55: /* old 'standard' formats */

Line 55: /* old 'standard' formats */

51: /* new standard formats */
52: std_date_fmt VARCHAR2(100) := 'YYYY/MM/DD HH24:MI:SS';
53: std_datetime_fmt VARCHAR2(100) := 'YYYY/MM/DD HH24:MI:SS';
54: std_time_fmt VARCHAR2(100) := 'HH24:MI:SS';
55: /* old 'standard' formats */
56: old_date_fmt VARCHAR2(100) := 'DD-MON-YY HH24:MI:SS';
57: old_datetime_fmt VARCHAR2(100) := 'DD-MON-YY HH24:MI:SS';
58: old_time_fmt VARCHAR2(100) := 'HH24:MI:SS';
59: cursor_handle INTEGER;