APPS.FND_OAM_DSCRAM_DIAG_PKG dependencies on FND_DATE

Line 111: v4 DATE := FND_DATE.CANONICAL_TO_DATE('2005/08/30 11:22:33');

107: l_stmt VARCHAR2(2000);
108: k NUMBER;
109: v2 NUMBER := 1;
110: v3 VARCHAR2(30) := 'ROWNAME';
111: v4 DATE := FND_DATE.CANONICAL_TO_DATE('2005/08/30 11:22:33');
112: v5 VARCHAR2(2000) := 'ROWDESC';
113: v5_len NUMBER := 993;
114: v5_tmp VARCHAR2(2000);
115:

Line 319: l_c4 DATE := FND_DATE.CANONICAL_TO_DATE('2005/08/30 11:22:33');

315: l_stmt VARCHAR2(2000);
316: l_row_count NUMBER;
317: l_c2_sum NUMBER;
318: l_c3_bad_count NUMBER;
319: l_c4 DATE := FND_DATE.CANONICAL_TO_DATE('2005/08/30 11:22:33');
320: l_c4_bad_count NUMBER;
321: BEGIN
322: fnd_oam_debug.log(1, l_ctxt, 'Validating table: '||p_owner||'.'||p_table_name||'('||p_tablespace||')');
323:

Line 407: l_c4 DATE := FND_DATE.CANONICAL_TO_DATE('2005/08/30 11:22:33');

403: l_canonical_value VARCHAR2(4000);
404: l_stmt VARCHAR2(2000);
405: l_c2_sum NUMBER;
406: l_c3_bad_count NUMBER;
407: l_c4 DATE := FND_DATE.CANONICAL_TO_DATE('2005/08/30 11:22:33');
408: l_c4_bad_count NUMBER;
409: BEGIN
410: fnd_oam_debug.log(1, l_ctxt, 'Validating Arg Values for table: '||p_owner||'.'||p_table_name||'('||p_tablespace||')');
411:

Line 3491: p_src_text => 'SELECT FND_DATE.CANONICAL_TO_DATE('''||l_c4_val||''') FROM dual',

3487: p_datatype => FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_DATE,
3488: p_permissions => FND_OAM_DSCRAM_UTILS_PKG.G_PERMISSION_READ_WRITE,
3489: p_write_policy => FND_OAM_DSCRAM_UTILS_PKG.G_WRITE_POLICY_ONCE,
3490: p_src_type => FND_OAM_DSCRAM_UTILS_PKG.G_SOURCE_SQL,
3491: p_src_text => 'SELECT FND_DATE.CANONICAL_TO_DATE('''||l_c4_val||''') FROM dual',
3492: p_src_where_clause => NULL,
3493: x_arg_id => l_c4_run_in_id) THEN
3494: RAISE INIT_FAILED;
3495: END IF;

Line 3602: p_src_where_clause => 'C4 IS NOT NULL AND C4 <> FND_DATE.CANONICAL_TO_DATE('''||l_c4_val||''')',

3598: p_permissions => FND_OAM_DSCRAM_UTILS_PKG.G_PERMISSION_WRITE,
3599: p_write_policy => FND_OAM_DSCRAM_UTILS_PKG.G_WRITE_POLICY_PER_RANGE,
3600: p_src_type => FND_OAM_DSCRAM_UTILS_PKG.G_SOURCE_SQL_RESTRICTABLE,
3601: p_src_text => 'SELECT COUNT(ROWID) FROM '||l_test_table_name,
3602: p_src_where_clause => 'C4 IS NOT NULL AND C4 <> FND_DATE.CANONICAL_TO_DATE('''||l_c4_val||''')',
3603: x_arg_id => l_c4_arg_out_id) THEN
3604: RAISE INIT_FAILED;
3605: END IF;
3606: