DBA Data[Home] [Help]

APPS.FUN_RULE_PUB dependencies on FND_DATE

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

372: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
373: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'add_parameter DATE:->name='||name||'**Value='||value, FALSE);
374: end if;
375:
376: add_parameter(name, fnd_date.date_to_canonical(value));
377: END add_parameter;
378:
379:
380: PROCEDURE add_parameter(name VARCHAR2, value NUMBER) IS

Line 414: RETURN fnd_date.canonical_to_date(m_resultValue);

410: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
411: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'get_date :->m_resultValue='||m_resultValue, FALSE);
412: end if;
413:
414: RETURN fnd_date.canonical_to_date(m_resultValue);
415: END;
416:
417: PROCEDURE apply_rule(p_application_short_name IN VARCHAR2, p_rule_object_name IN VARCHAR2)
418: IS

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

2144: ELSIF(FND_NUMBER.CANONICAL_TO_NUMBER(l_Obj1) = FND_NUMBER.CANONICAL_TO_NUMBER(l_Obj2))THEN
2145: RETURN 0;
2146: END IF;
2147: ELSIF (p_DataType = C_DATE) THEN
2148: IF(FND_DATE.CANONICAL_TO_DATE(l_Obj1) > FND_DATE.CANONICAL_TO_DATE(l_Obj2))THEN
2149: RETURN 1;
2150: ELSIF(FND_DATE.CANONICAL_TO_DATE(l_Obj1) < FND_DATE.CANONICAL_TO_DATE(l_Obj2))THEN
2151: RETURN -1;
2152: ELSIF(FND_DATE.CANONICAL_TO_DATE(l_Obj1) = FND_DATE.CANONICAL_TO_DATE(l_Obj2))THEN

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

2146: END IF;
2147: ELSIF (p_DataType = C_DATE) THEN
2148: IF(FND_DATE.CANONICAL_TO_DATE(l_Obj1) > FND_DATE.CANONICAL_TO_DATE(l_Obj2))THEN
2149: RETURN 1;
2150: ELSIF(FND_DATE.CANONICAL_TO_DATE(l_Obj1) < FND_DATE.CANONICAL_TO_DATE(l_Obj2))THEN
2151: RETURN -1;
2152: ELSIF(FND_DATE.CANONICAL_TO_DATE(l_Obj1) = FND_DATE.CANONICAL_TO_DATE(l_Obj2))THEN
2153: RETURN 0;
2154: END IF;

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

2148: IF(FND_DATE.CANONICAL_TO_DATE(l_Obj1) > FND_DATE.CANONICAL_TO_DATE(l_Obj2))THEN
2149: RETURN 1;
2150: ELSIF(FND_DATE.CANONICAL_TO_DATE(l_Obj1) < FND_DATE.CANONICAL_TO_DATE(l_Obj2))THEN
2151: RETURN -1;
2152: ELSIF(FND_DATE.CANONICAL_TO_DATE(l_Obj1) = FND_DATE.CANONICAL_TO_DATE(l_Obj2))THEN
2153: RETURN 0;
2154: END IF;
2155: ELSE
2156: IF(l_Obj1 > l_Obj2)THEN

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

2818: END IF;
2819: /*END: RULES ENGINE ENHANCEMNT FOR CUSTOM PARAMETERS*/
2820:
2821: IF (l_data_type = C_DATE) THEN
2822: l_param_value := fnd_date.canonical_to_date(l_param_value);
2823: ELSIF (l_data_type = C_NUMERIC) THEN
2824: l_param_value := fnd_number.canonical_to_number(l_param_value);
2825: END IF;
2826: