APPS.CSE_CSEBOFLD_XMLP_PKG dependencies on FND_DATE

Line 17: L_STRING1 := L_STRING1 || ' AND mmt.transaction_date >= fnd_date.canonical_to_date(:P_FROM)

13: IF P_ORGANIZATION_NAME IS NOT NULL THEN
14: L_STRING1 := L_STRING1 || ' AND hr2.name = :P_ORGANIZATION_NAME';
15: END IF;
16: IF P_FROM IS NOT NULL THEN
17: L_STRING1 := L_STRING1 || ' AND mmt.transaction_date >= fnd_date.canonical_to_date(:P_FROM)
18: and mmt.transaction_date <= nvl(fnd_date.canonical_to_date(:P_TO), mmt.transaction_date)';
19: ELSE
20: L_STRING1 := L_STRING1 || ' AND mmt.transaction_date <= nvl(fnd_date.canonical_to_date(:P_TO),mmt.transaction_date)';
21: END IF;

Line 18: and mmt.transaction_date <= nvl(fnd_date.canonical_to_date(:P_TO), mmt.transaction_date)';

14: L_STRING1 := L_STRING1 || ' AND hr2.name = :P_ORGANIZATION_NAME';
15: END IF;
16: IF P_FROM IS NOT NULL THEN
17: L_STRING1 := L_STRING1 || ' AND mmt.transaction_date >= fnd_date.canonical_to_date(:P_FROM)
18: and mmt.transaction_date <= nvl(fnd_date.canonical_to_date(:P_TO), mmt.transaction_date)';
19: ELSE
20: L_STRING1 := L_STRING1 || ' AND mmt.transaction_date <= nvl(fnd_date.canonical_to_date(:P_TO),mmt.transaction_date)';
21: END IF;
22: IF P_LOCATION_CODE IS NOT NULL THEN

Line 20: L_STRING1 := L_STRING1 || ' AND mmt.transaction_date <= nvl(fnd_date.canonical_to_date(:P_TO),mmt.transaction_date)';

16: IF P_FROM IS NOT NULL THEN
17: L_STRING1 := L_STRING1 || ' AND mmt.transaction_date >= fnd_date.canonical_to_date(:P_FROM)
18: and mmt.transaction_date <= nvl(fnd_date.canonical_to_date(:P_TO), mmt.transaction_date)';
19: ELSE
20: L_STRING1 := L_STRING1 || ' AND mmt.transaction_date <= nvl(fnd_date.canonical_to_date(:P_TO),mmt.transaction_date)';
21: END IF;
22: IF P_LOCATION_CODE IS NOT NULL THEN
23: L_STRING1 := L_STRING1 || ' AND hrl.location_code = :P_LOCATION_CODE';
24: END IF;

Line 45: IF NVL(FND_DATE.CANONICAL_TO_DATE(P_TO)

41:
42: FUNCTION P_TOVALIDTRIGGER RETURN BOOLEAN IS
43: BEGIN
44: IF P_FROM IS NOT NULL THEN
45: IF NVL(FND_DATE.CANONICAL_TO_DATE(P_TO)
46: ,SYSDATE) < FND_DATE.CANONICAL_TO_DATE(P_FROM) THEN
47: RETURN (FALSE);
48: ELSE
49: RETURN (TRUE);

Line 46: ,SYSDATE) < FND_DATE.CANONICAL_TO_DATE(P_FROM) THEN

42: FUNCTION P_TOVALIDTRIGGER RETURN BOOLEAN IS
43: BEGIN
44: IF P_FROM IS NOT NULL THEN
45: IF NVL(FND_DATE.CANONICAL_TO_DATE(P_TO)
46: ,SYSDATE) < FND_DATE.CANONICAL_TO_DATE(P_FROM) THEN
47: RETURN (FALSE);
48: ELSE
49: RETURN (TRUE);
50: END IF;