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;
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
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;
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);
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;