[Home] [Help]
PACKAGE: APPS.PA_TIMELINE_PVT
Source
1 PACKAGE PA_TIMELINE_PVT as
2 /* $Header: PARLPVTS.pls 120.1 2005/08/19 16:55:42 mwasowic noship $ */
3
4 -- Create timeline (overloaded for assignment)
5 PROCEDURE Create_Timeline (p_assignment_id IN NUMBER,
6 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
7 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
8 x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
9
10 PROCEDURE Create_Timeline (p_start_resource_name IN VARCHAR2,
11 p_end_resource_name IN VARCHAR2,
12 p_resource_id IN NUMBER,
13 p_start_date IN DATE,
14 p_end_date IN DATE,
15 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
16 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
17 x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
18
19 PROCEDURE Create_Timeline (p_calendar_id IN NUMBER,
20 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
21 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
22 x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
23
24 -- Delete timeline
25 PROCEDURE Delete_Timeline(p_assignment_id IN NUMBER,
26 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
27 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
28 x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
29
30
31 -- Procedure : copy_open_asgn_timeline
32 -- Purpose : Copy timeline data, pa_timeline_row_label and
33 -- pa_proj_asgn_time_chart, for a newly created open
34 -- assignment whose timeline has NOT been built.
35 -- Currently, the only API calling this is
36 -- PA_SCHEDULE_PVT.create_opn_asg_schedule.
37 PROCEDURE copy_open_asgn_timeline (p_assignment_id_tbl IN PA_ASSIGNMENTS_PUB.assignment_id_tbl_type,
38 p_assignment_source_id IN NUMBER,
39 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
40 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
41 x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
42
43
44 PROCEDURE populate_time_chart_table (p_timeline_type IN VARCHAR2,
45 p_row_label_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
46 p_resource_id IN NUMBER DEFAULT NULL,
47 p_conflict_group_id IN NUMBER DEFAULT NULL,
48 p_assignment_id IN NUMBER DEFAULT NULL,
49 p_start_date IN DATE,
50 p_end_date IN DATE,
51 p_scale_type IN VARCHAR2,
52 p_delete_flag IN VARCHAR2 DEFAULT 'Y',
53 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
54 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
55 x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
56
57 END PA_TIMELINE_PVT;