52: --
53: -- Convert parameters to dates.
54: --
55: IF p_pei_information1 IS NOT NULL THEN
56: l_lower_date := TRUNC(fnd_date.canonical_to_date(p_pei_information1));
57: END IF;
58: IF p_pei_information2 IS NOT NULL THEN
59: l_upper_date := TRUNC(fnd_date.canonical_to_date(p_pei_information2));
60: END IF;
55: IF p_pei_information1 IS NOT NULL THEN
56: l_lower_date := TRUNC(fnd_date.canonical_to_date(p_pei_information1));
57: END IF;
58: IF p_pei_information2 IS NOT NULL THEN
59: l_upper_date := TRUNC(fnd_date.canonical_to_date(p_pei_information2));
60: END IF;
61: --
62: --
63: -- Date From > Date To so error.
74: --
75: -- Convert parameters to dates.
76: --
77: IF p_pei_information6 IS NOT NULL THEN
78: l_lower_date := TRUNC(fnd_date.canonical_to_date(p_pei_information6));
79: END IF;
80: IF p_pei_information7 IS NOT NULL THEN
81: l_upper_date := TRUNC(fnd_date.canonical_to_date(p_pei_information7));
82: END IF;
77: IF p_pei_information6 IS NOT NULL THEN
78: l_lower_date := TRUNC(fnd_date.canonical_to_date(p_pei_information6));
79: END IF;
80: IF p_pei_information7 IS NOT NULL THEN
81: l_upper_date := TRUNC(fnd_date.canonical_to_date(p_pei_information7));
82: END IF;
83: --
84: --
85: -- Effective Date > Expiry Date so error.
96: --
97: -- Convert parameters to dates.
98: --
99: IF p_pei_information6 IS NOT NULL THEN
100: l_lower_date := TRUNC(fnd_date.canonical_to_date(p_pei_information6));
101: END IF;
102: IF p_pei_information7 IS NOT NULL THEN
103: l_upper_date := TRUNC(fnd_date.canonical_to_date(p_pei_information7));
104: END IF;
99: IF p_pei_information6 IS NOT NULL THEN
100: l_lower_date := TRUNC(fnd_date.canonical_to_date(p_pei_information6));
101: END IF;
102: IF p_pei_information7 IS NOT NULL THEN
103: l_upper_date := TRUNC(fnd_date.canonical_to_date(p_pei_information7));
104: END IF;
105: --
106: --
107: -- Effective Date > Expiry Date so error.