DBA Data[Home] [Help]

APPS.OKL_EC_EVALUATE_PVT dependencies on FND_DATE

Line 2548: l_ec1_dateval1 := fnd_date.canonical_to_date(l_ec1_value1);

2544: END IF;
2545: RETURN false;
2546: END IF;
2547: ELSIF ec1_tbl(i).data_type_code = 'DATE' THEN
2548: l_ec1_dateval1 := fnd_date.canonical_to_date(l_ec1_value1);
2549: l_ec1_dateval2 := fnd_date.canonical_to_date(l_ec1_value2);
2550: l_ec2_dateval1 := fnd_date.canonical_to_date(l_ec2_value1);
2551: l_ec2_dateval2 := fnd_date.canonical_to_date(l_ec2_value2);
2552: IF NOT (l_ec1_dateval1 BETWEEN l_ec2_dateval1 AND l_ec2_dateval2

Line 2549: l_ec1_dateval2 := fnd_date.canonical_to_date(l_ec1_value2);

2545: RETURN false;
2546: END IF;
2547: ELSIF ec1_tbl(i).data_type_code = 'DATE' THEN
2548: l_ec1_dateval1 := fnd_date.canonical_to_date(l_ec1_value1);
2549: l_ec1_dateval2 := fnd_date.canonical_to_date(l_ec1_value2);
2550: l_ec2_dateval1 := fnd_date.canonical_to_date(l_ec2_value1);
2551: l_ec2_dateval2 := fnd_date.canonical_to_date(l_ec2_value2);
2552: IF NOT (l_ec1_dateval1 BETWEEN l_ec2_dateval1 AND l_ec2_dateval2
2553: OR l_ec2_dateval1 BETWEEN l_ec1_dateval1 AND l_ec1_dateval2) THEN

Line 2550: l_ec2_dateval1 := fnd_date.canonical_to_date(l_ec2_value1);

2546: END IF;
2547: ELSIF ec1_tbl(i).data_type_code = 'DATE' THEN
2548: l_ec1_dateval1 := fnd_date.canonical_to_date(l_ec1_value1);
2549: l_ec1_dateval2 := fnd_date.canonical_to_date(l_ec1_value2);
2550: l_ec2_dateval1 := fnd_date.canonical_to_date(l_ec2_value1);
2551: l_ec2_dateval2 := fnd_date.canonical_to_date(l_ec2_value2);
2552: IF NOT (l_ec1_dateval1 BETWEEN l_ec2_dateval1 AND l_ec2_dateval2
2553: OR l_ec2_dateval1 BETWEEN l_ec1_dateval1 AND l_ec1_dateval2) THEN
2554: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN

Line 2551: l_ec2_dateval2 := fnd_date.canonical_to_date(l_ec2_value2);

2547: ELSIF ec1_tbl(i).data_type_code = 'DATE' THEN
2548: l_ec1_dateval1 := fnd_date.canonical_to_date(l_ec1_value1);
2549: l_ec1_dateval2 := fnd_date.canonical_to_date(l_ec1_value2);
2550: l_ec2_dateval1 := fnd_date.canonical_to_date(l_ec2_value1);
2551: l_ec2_dateval2 := fnd_date.canonical_to_date(l_ec2_value2);
2552: IF NOT (l_ec1_dateval1 BETWEEN l_ec2_dateval1 AND l_ec2_dateval2
2553: OR l_ec2_dateval1 BETWEEN l_ec1_dateval1 AND l_ec1_dateval2) THEN
2554: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
2555: okl_debug_pub.log_debug(fnd_log.level_procedure

Line 2737: l_ec1_dateval1 := fnd_date.canonical_to_date(l_ec1_value1);

2733: RETURN false;
2734: END IF;
2735: END IF;
2736: ELSIF ec1_tbl(i).data_type_code = 'DATE' THEN
2737: l_ec1_dateval1 := fnd_date.canonical_to_date(l_ec1_value1);
2738: l_ec2_dateval1 := fnd_date.canonical_to_date(l_ec2_value1);
2739: IF l_ec1_operator_code = 'EQ' AND l_ec2_operator_code = 'EQ' THEN
2740: IF l_ec1_dateval1 <> l_ec2_dateval1 THEN
2741: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN

Line 2738: l_ec2_dateval1 := fnd_date.canonical_to_date(l_ec2_value1);

2734: END IF;
2735: END IF;
2736: ELSIF ec1_tbl(i).data_type_code = 'DATE' THEN
2737: l_ec1_dateval1 := fnd_date.canonical_to_date(l_ec1_value1);
2738: l_ec2_dateval1 := fnd_date.canonical_to_date(l_ec2_value1);
2739: IF l_ec1_operator_code = 'EQ' AND l_ec2_operator_code = 'EQ' THEN
2740: IF l_ec1_dateval1 <> l_ec2_dateval1 THEN
2741: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
2742: okl_debug_pub.log_debug(fnd_log.level_procedure