APPS.PQH_FR_STAT_SIT_UTIL dependencies on FND_NUMBER

Line 492: IF l_txn_value_n = fnd_number.canonical_to_number(p_from_value) THEN

488: --dbms_output.put_line(SqlErrm);
489: END;
490: --dbms_output.put_line('txn Value - '||l_txn_value_n);
491: IF l_attr_dtls.value_style_cd = 'EXACT' THEN
492: IF l_txn_value_n = fnd_number.canonical_to_number(p_from_value) THEN
493: IF p_negate = 'Y' THEN
494: RETURN FALSE;
495: ELSE
496: RETURN TRUE;

Line 500: IF l_txn_value_n >= fnd_number.canonical_to_number(p_from_value)

496: RETURN TRUE;
497: END IF;
498: END IF;
499: ELSIF l_attr_dtls.value_style_cd = 'RANGE' THEN
500: IF l_txn_value_n >= fnd_number.canonical_to_number(p_from_value)
501: AND l_txn_value_n <= NVL(fnd_number.canonical_to_number(p_to_value),l_txn_value_n) THEN
502: IF p_negate = 'Y' THEN
503: RETURN FALSE;
504: ELSE

Line 501: AND l_txn_value_n <= NVL(fnd_number.canonical_to_number(p_to_value),l_txn_value_n) THEN

497: END IF;
498: END IF;
499: ELSIF l_attr_dtls.value_style_cd = 'RANGE' THEN
500: IF l_txn_value_n >= fnd_number.canonical_to_number(p_from_value)
501: AND l_txn_value_n <= NVL(fnd_number.canonical_to_number(p_to_value),l_txn_value_n) THEN
502: IF p_negate = 'Y' THEN
503: RETURN FALSE;
504: ELSE
505: RETURN TRUE;