APPS.FND_OAM_DSCRAM_ARGS_PKG dependencies on FND_DATE

Line 60: l_date := FND_DATE.CANONICAL_TO_DATE(p_canonical_value);

56: null; --no validation
57: WHEN FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_NUMBER THEN
58: l_num := FND_NUMBER.CANONICAL_TO_NUMBER(p_canonical_value);
59: WHEN FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_DATE THEN
60: l_date := FND_DATE.CANONICAL_TO_DATE(p_canonical_value);
61: WHEN FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_ROWID THEN
62: --for some reason, this is refusing to throw an exception on invalid values
63: l_rowid := CHARTOROWID(p_canonical_value);
64: ELSE

Line 346: x_canonical_value := FND_DATE.DATE_TO_CANONICAL(l_date);

342: WHEN FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_DATE THEN
343: DBMS_SQL.VARIABLE_VALUE(p_execution_cursor_id,
344: l_bindvar_name,
345: l_date);
346: x_canonical_value := FND_DATE.DATE_TO_CANONICAL(l_date);
347:
348: WHEN FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_ROWID THEN
349: DBMS_SQL.VARIABLE_VALUE_ROWID(p_execution_cursor_id,
350: l_bindvar_name,

Line 428: l_canonical_value := FND_DATE.DATE_TO_CANONICAL(l_date);

424: EXECUTE IMMEDIATE p_final_sql_stmt INTO l_number;
425: l_canonical_value := FND_NUMBER.NUMBER_TO_CANONICAL(l_number);
426: WHEN FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_DATE THEN
427: EXECUTE IMMEDIATE p_final_sql_stmt INTO l_date;
428: l_canonical_value := FND_DATE.DATE_TO_CANONICAL(l_date);
429: WHEN FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_ROWID THEN
430: EXECUTE IMMEDIATE p_final_sql_stmt INTO l_rowid;
431: l_canonical_value := ROWIDTOCHAR(l_rowid);
432: ELSE

Line 484: l_canonical_value := FND_DATE.DATE_TO_CANONICAL(l_date);

480: WHEN FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_DATE THEN
481: DBMS_SQL.COLUMN_VALUE(px_arg.source_cursor_id,
482: 1,
483: l_date);
484: l_canonical_value := FND_DATE.DATE_TO_CANONICAL(l_date);
485: WHEN FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_ROWID THEN
486: DBMS_SQL.COLUMN_VALUE_ROWID(px_arg.source_cursor_id,
487: 1,
488: l_rowid);

Line 1734: x_value := FND_DATE.CANONICAL_TO_DATE(l_varchar2);

1730: x_return_msg := l_return_msg;
1731: x_value := NULL;
1732: RETURN;
1733: END IF;
1734: x_value := FND_DATE.CANONICAL_TO_DATE(l_varchar2);
1735:
1736: --return success
1737: x_return_status := FND_API.G_RET_STS_SUCCESS;
1738: RETURN;

Line 2273: fnd_oam_debug.log(1, l_ctxt, 'Value(DATE): '||FND_DATE.DATE_TO_CANONICAL(l_date));

2269: l_date,
2270: l_return_status,
2271: l_return_msg);
2272: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2273: fnd_oam_debug.log(1, l_ctxt, 'Value(DATE): '||FND_DATE.DATE_TO_CANONICAL(l_date));
2274: ELSE
2275: --or fail
2276: x_return_status := l_return_status;
2277: x_return_msg := l_return_msg;