274: G_EXP_TYPE_START_DATE DATE;
275: G_EXP_TYPE_END_DATE DATE;
276:
277: /* Added Procedure check_termination for Bug#4604614 (BaseBug#4118885) */
278: procedure check_termination (p_person_id in per_all_people_f.person_id%type,
279: p_ei_date in pa_expenditure_items_all.expenditure_item_date%type,
280: x_actual_termination_date out nocopy per_periods_of_service.actual_termination_date%type);
281:
282: /* Bug 6156072: Base Bug 6045051: procedure check_termination_for_cwk added */
279: p_ei_date in pa_expenditure_items_all.expenditure_item_date%type,
280: x_actual_termination_date out nocopy per_periods_of_service.actual_termination_date%type);
281:
282: /* Bug 6156072: Base Bug 6045051: procedure check_termination_for_cwk added */
283: procedure check_termination_for_cwk (p_person_id in per_all_people_f.person_id%type,
284: p_ei_date in pa_expenditure_items_all.expenditure_item_date%type,
285: x_actual_termination_date out nocopy per_periods_of_placement.actual_termination_date%type);
286:
287: END PATC;