1 PACKAGE MRP_CALENDAR AUTHID CURRENT_USER AS
2 /* $Header: MRPCALDS.pls 115.4 2002/12/01 05:41:23 rashteka ship $ */
3
4 FUNCTION NEXT_WORK_DAY(arg_org_id IN NUMBER,
5 arg_bucket IN NUMBER,
6 arg_date IN DATE) RETURN DATE;
7 FUNCTION PREV_WORK_DAY(arg_org_id IN NUMBER,
8 arg_bucket IN NUMBER,
9 arg_date IN DATE) RETURN DATE;
10 FUNCTION DATE_OFFSET( arg_org_id IN NUMBER,
11 arg_bucket IN NUMBER,
12 arg_date IN DATE,
13 arg_offset IN NUMBER) RETURN DATE;
14 FUNCTION DAYS_BETWEEN( arg_org_id IN NUMBER,
15 arg_bucket IN NUMBER,
16 arg_date1 IN DATE,
17 arg_date2 IN DATE) RETURN NUMBER;
18 PROCEDURE SELECT_CALENDAR_DEFAULTS( arg_org_id IN NUMBER,
19 arg_calendar_code OUT NOCOPY VARCHAR2,
20 arg_exception_set_id OUT NOCOPY NUMBER);
21
22 END MRP_CALENDAR;