144: BEGIN
145:
146: SELECT pa_utils.GetWeekEnding(x_expenditure_item_date)
147: INTO x_week_ending_date
148: FROM SYS.DUAL;
149: RETURN x_week_ending_date;
150: EXCEPTION
151: WHEN OTHERS THEN
152: RETURN NULL;
167: BEGIN
168:
169: SELECT LAST_DAY(x_expenditure_item_date)
170: INTO x_month_ending_date
171: FROM SYS.DUAL;
172: RETURN x_month_ending_date;
173: EXCEPTION
174: WHEN OTHERS THEN
175: RETURN NULL;