[Home] [Help]
PACKAGE: APPS.PA_STRUCT_TASK_ROLLUP_PUB
Source
1 package PA_STRUCT_TASK_ROLLUP_PUB AUTHID DEFINER as
2 /* $Header: PATKRUPS.pls 120.4 2007/03/08 09:21:13 maansari ship $ */
3
4 TYPE pa_element_version_id_tbl_typ IS TABLE OF NUMBER
5 INDEX BY BINARY_INTEGER;
6
7 Procedure Tasks_Rollup_Unlimited(
8 p_api_version IN NUMBER := 1.0
9 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
10 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
11 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
12 ,p_validation_level IN VARCHAR2 := 100
13 ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
14 ,p_debug_mode IN VARCHAR2 := 'N'
15 ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
16 ,p_element_versions IN pa_element_version_id_tbl_typ
17 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
18 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
19 ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
20
21
22 Procedure Tasks_Rollup(
23 p_api_version IN NUMBER := 1.0
24 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
25 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
26 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
27 ,p_validation_level IN VARCHAR2 := 100
28 ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
29 ,p_debug_mode IN VARCHAR2 := 'N'
30 ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
31 ,p_element_versions IN PA_NUM_1000_NUM
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
37 Procedure Task_Status_Rollup(
38 p_api_version IN NUMBER := 1.0
39 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
40 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
41 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
42 ,p_validation_level IN VARCHAR2 := 100
43 ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
44 ,p_debug_mode IN VARCHAR2 := 'N'
45 ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
46 ,p_structure_version_id IN NUMBER
47 ,p_element_version_id IN NUMBER := NULL
48 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
49 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
50 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
51 );
52
53 Procedure Task_Stat_Pushdown_Rollup(
54 p_api_version IN NUMBER := 1.0
55 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
56 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
57 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
58 ,p_validation_level IN VARCHAR2 := 100
59 ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
60 ,p_debug_mode IN VARCHAR2 := 'N'
61 ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
62 ,p_structure_version_id IN NUMBER
63 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
64 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
65 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
66 );
67
68 -- API name : Rollup_From_Subproject
69 -- Type : Public procedure
70 -- Pre-reqs : None
71 -- Return Value : N/A
72 -- Prameters
73 -- p_api_version IN NUMBER := 1.0
74 -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
75 -- p_commit IN VARCHAR2 := FND_API.G_FALSE
76 -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
77 -- p_validation_level IN VARCHAR2 := 100
78 -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
79 -- p_debug_mode IN VARCHAR2 := 'N'
80 -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
81 -- p_element_versions IN PA_NUM_1000_NUM
82 -- x_return_status OUT VARCHAR2
83 -- x_msg_count OUT NUMBER
84 -- x_msg_data OUT VARCHAR2
85 --
86 --
87 PROCEDURE Rollup_From_Subproject(
88 p_api_version IN NUMBER := 1.0
89 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
90 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
91 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
92 ,p_validation_level IN VARCHAR2 := 100
93 ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
94 ,p_debug_mode IN VARCHAR2 := 'N'
95 ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
96 ,p_element_versions IN PA_NUM_1000_NUM
97 ,p_published_str_ver_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --bug5861729
98 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
99 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
100 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
101 );
102
103 -- API name : Program_Schedule_dates_rollup
104 -- Type : Public procedure
105 -- Pre-reqs : None
106 -- Return Value : N/A
107 -- Prameters
108 -- p_api_version IN NUMBER := 1.0
109 -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
110 -- p_commit IN VARCHAR2 := FND_API.G_FALSE
111 -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
112 -- p_validation_level IN VARCHAR2 := 100
113 -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
114 -- p_debug_mode IN VARCHAR2 := 'N'
115 -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
116 -- p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
117 -- x_return_status OUT VARCHAR2
118 -- x_msg_count OUT NUMBER
119 -- x_msg_data OUT VARCHAR2
120 --
121 --
122 PROCEDURE Program_Schedule_dates_rollup(
123 p_api_version IN NUMBER := 1.0
124 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
125 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
126 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
127 ,p_validation_level IN VARCHAR2 := 100
128 ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
129 ,p_debug_mode IN VARCHAR2 := 'N'
130 ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
131 ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
132 ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
133 ,p_published_str_ver_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
134 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
135 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
136 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
137 );
138
139
140 END PA_STRUCT_TASK_ROLLUP_PUB;