1 PACKAGE PA_TIMELINE_UTIL as
2 /* $Header: PARLUTSS.pls 120.1 2005/08/19 16:56:31 mwasowic noship $ */
3
4 --
5 -- Procedure : Create_time_scale
6 -- Purpose : Creating time scale and time marking and insert record into
7 -- pa_timeline_time_scale.
8
9 PROCEDURE Create_Time_Scale( p_start_date IN DATE,
10 p_end_date IN DATE := null,
11 p_scale_type IN VARCHAR2,
12 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
13 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
14 x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
15
16 -- Function to get the week end date for given org id and given date
17
18 FUNCTION Get_Week_End_Date(p_org_id IN NUMBER,
19 p_given_date IN DATE) RETURN DATE;
20
21 --pragma RESTRICT_REFERENCES (Get_Week_End_Date, WNDS, WNPS);
22
23 -- procedure to get the timeline period for the given date
24
25 PROCEDURE Get_Timeline_Period ( p_current_date IN DATE,
26 p_num_days IN NUMBER := null,
27 p_scale_type IN VARCHAR2,
28 p_navigate_type IN VARCHAR2,
29 p_org_id IN NUMBER,
30 x_period_start_date OUT NOCOPY DATE, --File.Sql.39 bug 4440895
31 x_period_end_date OUT NOCOPY DATE, --File.Sql.39 bug 4440895
32 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
33 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
34 x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
35
36 -- procedure to build array of week start and date for a range of dates
37
38 PROCEDURE Get_Week_Dates_Range( p_org_id IN NUMBER,
39 p_start_date IN DATE,
40 p_end_date IN DATE,
41 x_WeekDatesRangeTab OUT NOCOPY PA_TIMELINE_GLOB.WeekDatesRangeTabTyp, --File.Sql.39 bug 4440895
42 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
43 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
44 x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
45
46 -- function to get color codes
47
48 FUNCTION Get_Color_Pattern_Code(p_lookup_code IN VARCHAR2) RETURN VARCHAR2;
49 pragma RESTRICT_REFERENCES (Get_Color_Pattern_Code, WNDS, WNPS);
50
51 -- function to get the profile information
52
53 FUNCTION Get_Timeline_Profile_Setup RETURN PA_TIMELINE_GLOB.TimelineProfileSetup;
54 -- pragma RESTRICT_REFERENCES (Get_Timeline_Profile_Setup,WNDS,WNPS);
55
56 -- debug procedure
57
58 PROCEDURE debug(p_text IN VARCHAR2);
59
60 PROCEDURE debug(p_module IN VARCHAR2,
61 p_msg IN VARCHAR2,
62 p_log_level IN NUMBER DEFAULT 6);
63
64 END PA_TIMELINE_UTIL;