DBA Data[Home] [Help]

APPS.FUN_RULE_PUB dependencies on FND_DATE

Line 368: add_parameter(name, fnd_date.date_to_canonical(value));

364: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
365: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'add_parameter DATE:->name='||name||'**Value='||value, FALSE);
366: end if;
367:
368: add_parameter(name, fnd_date.date_to_canonical(value));
369: END add_parameter;
370:
371:
372: PROCEDURE add_parameter(name VARCHAR2, value NUMBER) IS

Line 406: RETURN fnd_date.canonical_to_date(m_resultValue);

402: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
403: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'get_date :->m_resultValue='||m_resultValue, FALSE);
404: end if;
405:
406: RETURN fnd_date.canonical_to_date(m_resultValue);
407: END;
408:
409: PROCEDURE apply_rule(p_application_short_name IN VARCHAR2, p_rule_object_name IN VARCHAR2)
410: IS

Line 2140: IF(FND_DATE.CANONICAL_TO_DATE(l_Obj1) > FND_DATE.CANONICAL_TO_DATE(l_Obj2))THEN

2136: ELSIF(FND_NUMBER.CANONICAL_TO_NUMBER(l_Obj1) = FND_NUMBER.CANONICAL_TO_NUMBER(l_Obj2))THEN
2137: RETURN 0;
2138: END IF;
2139: ELSIF (p_DataType = C_DATE) THEN
2140: IF(FND_DATE.CANONICAL_TO_DATE(l_Obj1) > FND_DATE.CANONICAL_TO_DATE(l_Obj2))THEN
2141: RETURN 1;
2142: ELSIF(FND_DATE.CANONICAL_TO_DATE(l_Obj1) < FND_DATE.CANONICAL_TO_DATE(l_Obj2))THEN
2143: RETURN -1;
2144: ELSIF(FND_DATE.CANONICAL_TO_DATE(l_Obj1) = FND_DATE.CANONICAL_TO_DATE(l_Obj2))THEN

Line 2142: ELSIF(FND_DATE.CANONICAL_TO_DATE(l_Obj1) < FND_DATE.CANONICAL_TO_DATE(l_Obj2))THEN

2138: END IF;
2139: ELSIF (p_DataType = C_DATE) THEN
2140: IF(FND_DATE.CANONICAL_TO_DATE(l_Obj1) > FND_DATE.CANONICAL_TO_DATE(l_Obj2))THEN
2141: RETURN 1;
2142: ELSIF(FND_DATE.CANONICAL_TO_DATE(l_Obj1) < FND_DATE.CANONICAL_TO_DATE(l_Obj2))THEN
2143: RETURN -1;
2144: ELSIF(FND_DATE.CANONICAL_TO_DATE(l_Obj1) = FND_DATE.CANONICAL_TO_DATE(l_Obj2))THEN
2145: RETURN 0;
2146: END IF;

Line 2144: ELSIF(FND_DATE.CANONICAL_TO_DATE(l_Obj1) = FND_DATE.CANONICAL_TO_DATE(l_Obj2))THEN

2140: IF(FND_DATE.CANONICAL_TO_DATE(l_Obj1) > FND_DATE.CANONICAL_TO_DATE(l_Obj2))THEN
2141: RETURN 1;
2142: ELSIF(FND_DATE.CANONICAL_TO_DATE(l_Obj1) < FND_DATE.CANONICAL_TO_DATE(l_Obj2))THEN
2143: RETURN -1;
2144: ELSIF(FND_DATE.CANONICAL_TO_DATE(l_Obj1) = FND_DATE.CANONICAL_TO_DATE(l_Obj2))THEN
2145: RETURN 0;
2146: END IF;
2147: ELSE
2148: IF(l_Obj1 > l_Obj2)THEN

Line 2791: l_param_value := fnd_date.canonical_to_date(l_param_value);

2787: dbms_sql.column_value(params_cursor, 5, l_case_sensitive);
2788: dbms_sql.column_value(params_cursor, 6, l_criteria_id);
2789:
2790: IF (l_data_type = C_DATE) THEN
2791: l_param_value := fnd_date.canonical_to_date(l_param_value);
2792: ELSIF (l_data_type = C_NUMERIC) THEN
2793: l_param_value := fnd_number.canonical_to_number(l_param_value);
2794: END IF;
2795: