PACKAGE: APPS.OKS_COVERAGE_UTIL_PVT

Source

1 PACKAGE OKS_COVERAGE_UTIL_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKSRCUTS.pls 120.2 2005/07/28 14:22:44 sasethi noship $ */
3 
4   -- Global Constants
5   G_PACKAGE_NAME             CONSTANT VARCHAR2(200) := 'OKS_COVERAGE_UTIL_PVT';
6   G_MODULE                   CONSTANT VARCHAR2(250) := 'oks.plsql.'||G_PACKAGE_NAME||'.';
7 
8   G_RET_STS_ERROR            CONSTANT   VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
9   G_RET_STS_UNEXP_ERROR      CONSTANT   VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
10 
11   -- Utility Functions and Procedures
12 
13     /**
14      * Coverage Times record and table declaration, for the UI
15      */
16     TYPE ui_coverage_times_rec IS RECORD
17     (
18      MONDAY_YN         OKS_COVERAGE_TIMES.monday_yn%TYPE,
19      TUESDAY_YN        OKS_COVERAGE_TIMES.tuesday_yn%TYPE,
20      WEDNESDAY_YN      OKS_COVERAGE_TIMES.wednesday_yn%TYPE,
21      THURSDAY_YN       OKS_COVERAGE_TIMES.thursday_yn%TYPE,
22      FRIDAY_YN         OKS_COVERAGE_TIMES.friday_yn%TYPE,
23      SATURDAY_YN       OKS_COVERAGE_TIMES.saturday_yn%TYPE,
24      SUNDAY_YN         OKS_COVERAGE_TIMES.sunday_yn%TYPE,
25      COV_TZE_LINE_ID   OKS_COVERAGE_TIMES.COV_TZE_LINE_ID%TYPE,
26      START_TIME        VARCHAR2(10),
27      END_TIME          VARCHAR2(10),
28      START_HOUR_MINUTE NUMBER,
29      END_HOUR_MINUTE   NUMBER);
30 
31      TYPE ui_coverage_times_tbl IS TABLE OF ui_coverage_times_rec
32      INDEX BY BINARY_INTEGER;
33 
34     /**
35      * Flattened Start and Time record and table declaration, for processing new
36      * Coverage Times
37      */
38     TYPE flattened_time_limits IS RECORD
39     (TIME               NUMBER,
40      CONCATENATE_TIME   VARCHAR2(10));
41 
42     TYPE flattened_time_limits_TBL IS TABLE OF flattened_time_limits
43     INDEX BY BINARY_INTEGER;
44 
45    PROCEDURE init_coverage_times_view
46    (    p_api_version           IN NUMBER,
47         p_init_msg_list         IN VARCHAR2 :=FND_API.G_FALSE,
48         cov_timezone_id         IN NUMBER,
49         x_msg_data              OUT NOCOPY VARCHAR2,
50         x_msg_count             OUT NOCOPY NUMBER,
51         x_return_status         OUT NOCOPY VARCHAR2);
52 
53 
54   -- End - Added by SASETHI
55 
56     /**
57      * Returns Timezone value appended with (Default)
58      * @param p_timezone_name Timezone name
59      */
60 	FUNCTION Get_Default_Timezone_Msg
61 	(p_timezone_name  IN VARCHAR2) RETURN VARCHAR2;
62 
63 END OKS_COVERAGE_UTIL_PVT;
64