[Home] [Help]
PACKAGE: APPS.OKS_COVERAGE_UTIL_PVT
Source
1 PACKAGE OKS_COVERAGE_UTIL_PVT 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