APPS.FND_CONC_DATE dependencies on DUAL

Line 43: from sys.dual;

39: base_len + 6, to_date(string, nls_date_fmt || ' HH24:MI'),
40: base_len + 9, to_date(string, nls_date_fmt || ' HH24:MI:SS'),
41: to_date(string, 'ABC')) -- Intentional exception!
42: into out_date
43: from sys.dual;
44:
45: return out_date;
46:
47: exception

Line 61: from Sys.Dual;

57: base_len + 8, To_Date (string, 'DD-MON-YYYY HH24:MI'),
58: base_len + 9, To_Date (string, 'DD-MON-RR HH24:MI:SS'),
59: To_Date (string, 'DD-MON-YYYY HH24:MI:SS'))
60: into out_date
61: from Sys.Dual;
62:
63: return out_date;
64:
65: exception

Line 79: from Sys.Dual;

75: base_len + 8, To_Date (string, 'DD-MM-YYYY HH24:MI'),
76: base_len + 9, To_Date (string, 'DD-MM-RR HH24:MI:SS'),
77: To_Date (string, 'DD-MM-YYYY HH24:MI:SS'))
78: into out_date
79: from Sys.Dual;
80:
81: return out_date;
82:
83: exception

Line 92: from Sys.Dual;

88: 10, To_Date (string, 'YYYY/MM/DD'),
89: 16, To_Date (string, 'YYYY/MM/DD HH24:MI'),
90: 19, To_Date (string, 'YYYY/MM/DD HH24:MI:SS'))
91: into out_date
92: from Sys.Dual;
93:
94: return out_date;
95:
96: exception

Line 137: from sys.dual;

133: base_len + 6, nls_date_fmt || ' HH24:MI',
134: base_len + 9, nls_date_fmt || ' HH24:MI:SS',
135: NULL)
136: into out_fmt
137: from sys.dual;
138:
139: IF out_fmt IS NOT NULL then
140: return out_fmt;
141: END IF;

Line 165: from Sys.Dual;

161: base_len + 9, 'DD-MON-RR HH24:MI:SS',
162: base_len + 11, 'DD-MON-YYYY HH24:MI:SS',
163: NULL)
164: into out_fmt
165: from Sys.Dual;
166: end if;
167:
168: IF out_fmt IS NOT NULL then
169: return out_fmt;

Line 185: from Sys.Dual;

181: base_len + 9, 'DD-MM-RR HH24:MI:SS',
182: base_len + 11, 'DD-MM-YYYY HH24:MI:SS',
183: NULL)
184: into out_fmt
185: from Sys.Dual;
186:
187: IF (out_fmt IS NOT NULL and INSTR(string,'-') > 0) then
188: return out_fmt;
189: END IF;

Line 200: from Sys.Dual;

196: 16, 'YYYY/MM/DD HH24:MI',
197: 19, 'YYYY/MM/DD HH24:MI:SS',
198: NULL)
199: into out_fmt
200: from Sys.Dual;
201:
202:
203: return out_fmt;
204: