PACKAGE: APPS.PA_DURATION_UTILS

Source

1 PACKAGE pa_duration_utils AS
2 /*$Header: PADURUTS.pls 120.1 2005/08/19 16:21:48 mwasowic noship $*/
3 
4 --
5 --  PROCEDURE   get_duration_old
6 --
7 --  PURPOSE
8 --              This procedure returns total number of hours and days for given
9 --              start date and end date.
10 
11 g_start_date     DATE;
12 g_end_date       DATE;
13 g_duration_days  NUMBER;
14 g_duration_hours NUMBER;
15 g_sch_record_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
16 g_calendar_id    NUMBER;
17 
18 PROCEDURE get_duration_old(p_calendar_id IN  NUMBER,
19             p_start_date  IN  DATE,
20             p_end_date    IN  DATE,
21             x_duration_days  OUT  NOCOPY NUMBER, --File.Sql.39 bug 4440895
22             x_duration_hours OUT  NOCOPY NUMBER, --File.Sql.39 bug 4440895
23             x_return_status  OUT  NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
24             x_msg_count      OUT  NOCOPY NUMBER, --File.Sql.39 bug 4440895
25             x_msg_data       OUT  NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
26 
27 FUNCTION get_total_hours(p_calendar_id IN NUMBER,
28                          p_start_date IN DATE,
29                          p_end_date IN DATE) return NUMBER;
30 
31 --          07-Mar-2003    Amksingh Bug 2838700 A new procedure get_duration
32 --                                  is added and the previous get_duration is
33 --                                  renamed to get_duration_old.
34 
35 PROCEDURE get_duration(p_calendar_id IN  NUMBER,
36             p_start_date  IN  DATE,
37             p_end_date    IN  DATE,
38             x_duration_days  OUT  NOCOPY NUMBER, --File.Sql.39 bug 4440895
39             x_duration_hours OUT  NOCOPY NUMBER, --File.Sql.39 bug 4440895
40             x_return_status  OUT  NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
41             x_msg_count      OUT  NOCOPY NUMBER, --File.Sql.39 bug 4440895
42             x_msg_data       OUT  NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
43 
44 END PA_DURATION_UTILS ;