[Home] [Help]
PACKAGE: APPS.PA_PROJ_STRUCTURE_PUB
Source
1 package PA_PROJ_STRUCTURE_PUB AUTHID CURRENT_USER as
2 /* $Header: PAXSTRPS.pls 120.3 2005/12/19 16:06:58 rakragha noship $ */
3
4 --bug 4448499
5 global_sequence_number NUMBER := 0;
6 global_sub_proj_task_count NUMBER :=0;
7 --bug 4448499
8 procedure CREATE_RELATIONSHIP
9 (
10 p_api_version IN NUMBER := 1.0,
11 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
12 p_commit IN VARCHAR2 := FND_API.G_FALSE,
13 p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
14 p_debug_mode IN VARCHAR2 := 'N',
15 p_task_id IN NUMBER,
16 p_project_id IN NUMBER,
17 x_return_status OUT NOCOPY VARCHAR2,
18 x_msg_count OUT NOCOPY NUMBER,
19 x_msg_data OUT NOCOPY VARCHAR2
20 );
21
22 function CHECK_SUBPROJ_CONTRACT_ASSO
23 (
24 p_project_id IN NUMBER
25 )
26 return VARCHAR2;
27
28 function CHECK_TASK_CONTRACT_ASSO
29 (
30 p_task_id IN NUMBER
31 )
32 return VARCHAR2;
33
34 procedure DELETE_RELATIONSHIP
35 (
36 p_api_version IN NUMBER := 1.0,
37 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
38 p_commit IN VARCHAR2 := FND_API.G_FALSE,
39 p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
40 p_debug_mode IN VARCHAR2 := 'N',
41 p_task_id IN NUMBER,
42 p_project_id IN NUMBER,
43 x_return_status OUT NOCOPY VARCHAR2,
44 x_msg_count OUT NOCOPY NUMBER,
45 x_msg_data OUT NOCOPY VARCHAR2
46 );
47
48
49 --bug
50 procedure POPULATE_STRUCTURES_TMP_TAB
51 (
52 p_api_version IN NUMBER := 1.0,
53 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
54 p_commit IN VARCHAR2 := FND_API.G_FALSE,
55 p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
56 p_debug_mode IN VARCHAR2 := 'N',
57 p_project_id IN NUMBER,
58 p_structure_version_id IN NUMBER,
59 p_task_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
60 p_calling_page_name IN VARCHAR2,
61 p_populate_tmp_tab_flag IN VARCHAR2 := 'Y',
62 p_parent_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
63 p_sequence_offset IN NUMBER := 0, --bug 4448499
64 p_wbs_display_depth IN NUMBER := -1, -- Bug # 4875311.
65 x_return_status OUT NOCOPY VARCHAR2,
66 x_msg_count OUT NOCOPY NUMBER,
67 x_msg_data OUT NOCOPY VARCHAR2
68 );
69
70 procedure INSERT_PUBLISHED_RECORDS
71 (
72 p_api_version IN NUMBER := 1.0,
73 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
74 p_commit IN VARCHAR2 := FND_API.G_FALSE,
75 p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
76 p_debug_mode IN VARCHAR2 := 'N',
77 p_project_id IN NUMBER,
78 p_structure_version_id IN NUMBER,
79 p_parent_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
80 p_sequence_offset IN NUMBER := 0, --bug 4448499
81 p_wbs_display_depth IN NUMBER := -1, -- Bug # 4875311.
82 p_task_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, -- Bug # 4875311.
83 x_return_status OUT NOCOPY VARCHAR2,
84 x_msg_count OUT NOCOPY NUMBER,
85 x_msg_data OUT NOCOPY VARCHAR2
86 );
87
88
89 procedure INSERT_WORKING_RECORDS
90 (
91 p_api_version IN NUMBER := 1.0,
92 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
93 p_commit IN VARCHAR2 := FND_API.G_FALSE,
94 p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
95 p_debug_mode IN VARCHAR2 := 'N',
96 p_project_id IN NUMBER,
97 p_structure_version_id IN NUMBER,
98 p_parent_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
99 p_sequence_offset IN NUMBER := 0, --bug 4448499
100 p_wbs_display_depth IN NUMBER := -1, -- Bug # 4875311.
101 p_task_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, -- Bug # 4875311.
102 x_return_status OUT NOCOPY VARCHAR2,
103 x_msg_count OUT NOCOPY NUMBER,
104 x_msg_data OUT NOCOPY VARCHAR2
105 );
106
107 procedure INSERT_SUBPROJECTS
108 (
109 p_api_version IN NUMBER := 1.0,
110 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
111 p_commit IN VARCHAR2 := FND_API.G_FALSE,
112 p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
113 p_debug_mode IN VARCHAR2 := 'N',
114 p_calling_page_name IN VARCHAR2,
115 p_project_id IN NUMBER,
116 p_structure_version_id IN NUMBER,
117 p_parent_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
118 p_wbs_display_depth IN NUMBER := -1, -- Bug # 4875311.
119 x_return_status OUT NOCOPY VARCHAR2,
120 x_msg_count OUT NOCOPY NUMBER,
121 x_msg_data OUT NOCOPY VARCHAR2
122 );
123
124
125 procedure INSERT_PUBLISHED_RECORD
126 (
127 p_api_version IN NUMBER := 1.0,
128 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
129 p_commit IN VARCHAR2 := FND_API.G_FALSE,
130 p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
131 p_debug_mode IN VARCHAR2 := 'N',
132 p_project_id IN NUMBER,
133 p_structure_version_id IN NUMBER,
134 p_task_version_id IN NUMBER,
135 p_parent_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
136 x_return_status OUT NOCOPY VARCHAR2,
137 x_msg_count OUT NOCOPY NUMBER,
138 x_msg_data OUT NOCOPY VARCHAR2
139 );
140
141 procedure INSERT_WORKING_RECORD
142 (
143 p_api_version IN NUMBER := 1.0,
144 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
145 p_commit IN VARCHAR2 := FND_API.G_FALSE,
146 p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
147 p_debug_mode IN VARCHAR2 := 'N',
148 p_project_id IN NUMBER,
149 p_structure_version_id IN NUMBER,
150 p_task_version_id IN NUMBER,
151 p_parent_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
152 x_return_status OUT NOCOPY VARCHAR2,
153 x_msg_count OUT NOCOPY NUMBER,
154 x_msg_data OUT NOCOPY VARCHAR2
155 );
156
157 procedure INSERT_UPD_WORKING_RECORDS
158 (
159 p_api_version IN NUMBER := 1.0,
160 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
161 p_commit IN VARCHAR2 := FND_API.G_FALSE,
162 p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
163 p_debug_mode IN VARCHAR2 := 'N',
164 p_project_id IN NUMBER,
165 p_structure_version_id IN NUMBER,
166 p_parent_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
167 p_wbs_display_depth IN NUMBER := -1, -- Bug # 4875311.
168 p_task_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, -- Bug # 4875311.
169 x_return_status OUT NOCOPY VARCHAR2,
170 x_msg_count OUT NOCOPY NUMBER,
171 x_msg_data OUT NOCOPY VARCHAR2
172 );
173
174 procedure INSERT_UPD_PUBLISHED_RECORDS
175 (
176 p_api_version IN NUMBER := 1.0,
177 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
178 p_commit IN VARCHAR2 := FND_API.G_FALSE,
179 p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
180 p_debug_mode IN VARCHAR2 := 'N',
181 p_project_id IN NUMBER,
182 p_structure_version_id IN NUMBER,
183 p_parent_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
184 p_wbs_display_depth IN NUMBER := -1, -- Bug # 4875311.
185 p_task_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, -- Bug # 4875311.
186 x_return_status OUT NOCOPY VARCHAR2,
187 x_msg_count OUT NOCOPY NUMBER,
188 x_msg_data OUT NOCOPY VARCHAR2
189 );
190
191 -- Bug # 4875311.
192
193 procedure populate_pji_tab_for_plan_prj
194 (p_api_version IN NUMBER :=1.0
195 ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
196 ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
197 ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
198 ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
199 ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
200 ,p_debug_mode IN VARCHAR2 :='N'
201 ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
202 ,p_project_id IN NUMBER
203 ,p_project_element_id IN NUMBER DEFAULT NULL
204 ,p_structure_version_id IN NUMBER DEFAULT NULL
205 ,p_baselined_str_ver_id IN NUMBER DEFAULT NULL
206 ,p_structure_type IN VARCHAR2 := 'WORKPLAN'
207 ,p_populate_tmp_tab_flag IN VARCHAR2 := 'Y'
208 ,p_program_rollup_flag IN VARCHAR2 := 'Y'
209 ,p_calling_context IN VARCHAR2 := 'ROLLUP'
210 ,p_as_of_date IN DATE := null
211 ,p_wbs_display_depth IN NUMBER := -1
212 ,p_structure_flag IN VARCHAR2 := 'Y'
213 ,x_return_status OUT NOCOPY VARCHAR2
214 ,x_msg_count OUT NOCOPY NUMBER
215 ,x_msg_data OUT NOCOPY VARCHAR2);
216
217 -- Bug # 4875311.
218
219 end PA_PROJ_STRUCTURE_PUB;
220