1 PACKAGE BOM_CALENDAR_API_BK AS
2 -- $Header: BOMCALAS.pls 120.1 2005/06/21 05:29:08 appldev ship $
3 -- =========================================================================+
4 -- Copyright (c) 1993 Oracle Corporation Belmont, California, USA |
5 -- All rights reserved. |
6 -- =========================================================================+
7 -- |
8 -- File Name : BOMCALAS.pls |
9 -- Description : This API will validate the input date against input |
10 -- calendar as a valid working day. |
11 -- Parameters: x_calendar_code the calendar user wants to use |
12 -- x_date input date user wants to verify |
13 -- x_working_day show is this date a working date |
14 -- err_code error code, if any error happens |
15 -- err_meg error message, if any error happens |
16 -- Revision |
17 -- Jen-Ya Ku Creation |
18 -- =========================================================================
19 PROCEDURE CHECK_WORKING_DAY (
20 x_calendar_code IN VARCHAR2,
21 x_date IN DATE,
22 x_working_day IN OUT NOCOPY /* file.sql.39 change */ BOOLEAN,
23 err_code IN OUT NOCOPY /* file.sql.39 change */ NUMBER,
24 err_meg IN OUT NOCOPY /* file.sql.39 change */ VARCHAR);
25
26 FUNCTION CHECK_WORKING_SHIFT (
27 x_calendar_code IN VARCHAR2,
28 x_date IN DATE,
29 err_code IN OUT NOCOPY /* file.sql.39 change */ NUMBER,
30 err_meg IN OUT NOCOPY /* file.sql.39 change */ VARCHAR)
31 return BOOLEAN;
32 END BOM_CALENDAR_API_BK;