eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_CREDIT_CHECKLIST_PVT dependencies on FND_DATE

Line 546: and trunc(FND_DATE.CANONICAL_TO_DATE(rulh.RULE_INFORMATION1)) > trunc(FND_DATE.CANONICAL_TO_DATE(rulh.RULE_INFORMATION2))

542: is select 1
543: FROM
544: OKC_RULES_B rulh
545: where rulh.RULE_INFORMATION1 is not null
546: and trunc(FND_DATE.CANONICAL_TO_DATE(rulh.RULE_INFORMATION1)) > trunc(FND_DATE.CANONICAL_TO_DATE(rulh.RULE_INFORMATION2))
547: --and rulh.rule_information_category = 'LACLFM'
548: and rulh.id = p_id;
549:
550: /*

Line 1727: lp_rulv_rec.rule_information1 := FND_DATE.date_to_canonical(to_date(p_rulv_rec.rule_information1,G_UI_DATE_MASK));

1723:
1724: -- effective from
1725: IF (p_rulv_rec.rule_information1 IS NOT NULL AND
1726: p_rulv_rec.rule_information1 <> TO_CHAR(OKC_API.G_MISS_DATE,G_UI_DATE_MASK) ) THEN
1727: lp_rulv_rec.rule_information1 := FND_DATE.date_to_canonical(to_date(p_rulv_rec.rule_information1,G_UI_DATE_MASK));
1728: END IF;
1729:
1730: -- effective to
1731: IF (p_rulv_rec.rule_information2 IS NOT NULL AND

Line 1733: lp_rulv_rec.rule_information2 := FND_DATE.date_to_canonical(to_date(p_rulv_rec.rule_information2,G_UI_DATE_MASK));

1729:
1730: -- effective to
1731: IF (p_rulv_rec.rule_information2 IS NOT NULL AND
1732: p_rulv_rec.rule_information2 <> TO_CHAR(OKC_API.G_MISS_DATE,G_UI_DATE_MASK) ) THEN
1733: lp_rulv_rec.rule_information2 := FND_DATE.date_to_canonical(to_date(p_rulv_rec.rule_information2,G_UI_DATE_MASK));
1734: END IF;
1735:
1736: -- status
1737: IF (p_rulv_rec.rule_information3 IS NOT NULL AND