PACKAGE: APPS.BOM_CALENDARS_PKG

Source

1 PACKAGE BOM_CALENDARS_PKG AUTHID CURRENT_USER as
2 /* $Header: bompbcls.pls 115.1 99/07/16 05:47:13 porting ship $ */
3 
4 
5 FUNCTION Workday_Pattern_Exist (x_calendar_code VARCHAR2,
6 				x_shift_num NUMBER,
7 			     	x_calendar_or_shift NUMBER) RETURN NUMBER;
8 
9 PROCEDURE Calendar_Check_Unique (x_calendar_code VARCHAR2);
10 
11 PROCEDURE Check_Exception_Range (x_calendar_code 	       VARCHAR2,
12 				 x_lo_except_date	IN OUT DATE,
13 				 x_hi_except_date	IN OUT DATE);
14 
15 PROCEDURE Cal_Exception_Check_Unique (x_calendar_Code   VARCHAR2,
16 				      x_exception_date	DATE);
17 
18 PROCEDURE Shift_Check_Unique (x_calendar_code VARCHAR2,
19 	 		      x_shift_num     NUMBER);
20 
21 PROCEDURE Shift_Exception_Check_Unique (x_calendar_code	  VARCHAR2,
22 					x_shift_num	  NUMBER,
23 				 	x_exception_date  DATE);
24 
25 PROCEDURE Times_Check_Unique (x_calendar_code VARCHAR2,
26 			      x_row_id        VARCHAR2,
27 			      x_shift_num     NUMBER,
28 			      x_start_time    NUMBER,
29 			      x_end_time      NUMBER);
30 
31 FUNCTION Shift_Times_Overlap (x_calendar_code	VARCHAR2,
32 			      x_shift_num	NUMBER,
33 			      x_start_time	NUMBER,
34 			      x_end_time	NUMBER,
35 			      x_rowid		VARCHAR2,
36 			      x_flag		NUMBER) RETURN NUMBER;
37 
38 END BOM_CALENDARS_PKG;