[Home] [Help]
PACKAGE: APPS.PA_TASK_TYPE_PUB
Source
1 PACKAGE PA_TASK_TYPE_PUB AUTHID CURRENT_USER AS
2 /*$Header: PATTPUBS.pls 120.1 2005/08/19 17:06:27 mwasowic noship $*/
3
4 PROCEDURE create_task_type
5 (p_task_type IN pa_task_types.task_type%TYPE
6 ,p_start_date_active IN pa_task_types.start_date_active%TYPE
7 ,p_end_date_active IN pa_task_types.end_date_active%TYPE := NULL
8 ,p_description IN pa_task_types.description%TYPE := NULL
9 ,p_task_type_class_code IN pa_task_types.task_type_class_code%TYPE
10 ,p_initial_status_code IN pa_task_types.initial_status_code%TYPE := NULL
11 ,p_prog_entry_enable_flag IN pa_task_types.prog_entry_enable_flag%TYPE := NULL
12 ,p_prog_entry_req_flag IN pa_task_types.prog_entry_req_flag%TYPE := NULL
13 ,p_initial_progress_status_code IN pa_task_types.initial_progress_status_code%TYPE := NULL
14 ,p_task_prog_entry_page_id IN pa_task_types.task_progress_entry_page_id%TYPE := NULL
15 ,p_task_prog_entry_page_name IN pa_page_layouts.page_name%TYPE := NULL
16 ,p_wq_enable_flag IN pa_task_types.wq_enable_flag%TYPE := NULL
17 ,p_work_item_code IN pa_task_types.work_item_code%TYPE := NULL
18 ,p_uom_code IN pa_task_types.uom_code%TYPE := NULL
19 ,p_actual_wq_entry_code IN pa_task_types.actual_wq_entry_code%TYPE := NULL
20 ,p_percent_comp_enable_flag IN pa_task_types.percent_comp_enable_flag%TYPE := NULL
21 ,p_base_percent_comp_deriv_code IN pa_task_types.base_percent_comp_deriv_code%TYPE := NULL
22 ,p_task_weighting_deriv_code IN pa_task_types.task_weighting_deriv_code%TYPE := NULL
23 ,p_remain_effort_enable_flag IN pa_task_types.remain_effort_enable_flag%TYPE := NULL
24 ,p_attribute_category IN pa_task_types.attribute_category%TYPE := NULL
25 ,p_attribute1 IN pa_task_types.attribute1%TYPE := NULL
26 ,p_attribute2 IN pa_task_types.attribute2%TYPE := NULL
27 ,p_attribute3 IN pa_task_types.attribute3%TYPE := NULL
28 ,p_attribute4 IN pa_task_types.attribute4%TYPE := NULL
29 ,p_attribute5 IN pa_task_types.attribute5%TYPE := NULL
30 ,p_attribute6 IN pa_task_types.attribute6%TYPE := NULL
31 ,p_attribute7 IN pa_task_types.attribute7%TYPE := NULL
32 ,p_attribute8 IN pa_task_types.attribute8%TYPE := NULL
33 ,p_attribute9 IN pa_task_types.attribute9%TYPE := NULL
34 ,p_attribute10 IN pa_task_types.attribute10%TYPE := NULL
35 ,p_attribute11 IN pa_task_types.attribute11%TYPE := NULL
36 ,p_attribute12 IN pa_task_types.attribute12%TYPE := NULL
37 ,p_attribute13 IN pa_task_types.attribute13%TYPE := NULL
38 ,p_attribute14 IN pa_task_types.attribute14%TYPE := NULL
39 ,p_attribute15 IN pa_task_types.attribute15%TYPE := NULL
40 ,p_api_version IN NUMBER := 1.0
41 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
42 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
43 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
44 ,p_object_type IN pa_task_types.object_type%TYPE := 'PA_TASKS' -- 3279978 : Added Object Type and Progress Rollup Method
45 ,p_wf_item_type IN pa_task_types.wf_item_type%TYPE :=NULL
46 ,p_wf_process IN pa_task_types.wf_process%TYPE :=NULL
47 ,p_wf_lead_days IN pa_task_types.wf_start_lead_days%TYPE :=NULL
48 ,x_task_type_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
49 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
50 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
51 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
52 );
53
54
55 PROCEDURE Update_Task_Type
56 ( p_task_type_id IN pa_task_types.task_type_id%TYPE
57 ,p_task_type IN pa_task_types.task_type%TYPE
58 ,p_start_date_active IN pa_task_types.start_date_active%TYPE
59 ,p_end_date_active IN pa_task_types.end_date_active%TYPE := NULL
60 ,p_description IN pa_task_types.description%TYPE := NULL
61 ,p_task_type_class_code IN pa_task_types.task_type_class_code%TYPE
62 ,p_initial_status_code IN pa_task_types.initial_status_code%TYPE := NULL
63 ,p_prog_entry_enable_flag IN pa_task_types.prog_entry_enable_flag%TYPE := NULL
64 ,p_prog_entry_req_flag IN pa_task_types.prog_entry_req_flag%TYPE := NULL
65 ,p_initial_progress_status_code IN pa_task_types.initial_progress_status_code%TYPE := NULL
66 ,p_task_prog_entry_page_id IN pa_task_types.task_progress_entry_page_id%TYPE := NULL
67 ,p_task_prog_entry_page_name IN pa_page_layouts.page_name%TYPE := NULL
68 ,p_wq_enable_flag IN pa_task_types.wq_enable_flag%TYPE := NULL
69 ,p_work_item_code IN pa_task_types.work_item_code%TYPE := NULL
70 ,p_uom_code IN pa_task_types.uom_code%TYPE := NULL
71 ,p_actual_wq_entry_code IN pa_task_types.actual_wq_entry_code%TYPE := NULL
72 ,p_percent_comp_enable_flag IN pa_task_types.percent_comp_enable_flag%TYPE := NULL
73 ,p_base_percent_comp_deriv_code IN pa_task_types.base_percent_comp_deriv_code%TYPE := NULL
74 ,p_task_weighting_deriv_code IN pa_task_types.task_weighting_deriv_code%TYPE := NULL
75 ,p_remain_effort_enable_flag IN pa_task_types.remain_effort_enable_flag%TYPE := NULL
76 ,p_attribute_category IN pa_task_types.attribute_category%TYPE := NULL
77 ,p_attribute1 IN pa_task_types.attribute1%TYPE := NULL
78 ,p_attribute2 IN pa_task_types.attribute2%TYPE := NULL
79 ,p_attribute3 IN pa_task_types.attribute3%TYPE := NULL
80 ,p_attribute4 IN pa_task_types.attribute4%TYPE := NULL
81 ,p_attribute5 IN pa_task_types.attribute5%TYPE := NULL
82 ,p_attribute6 IN pa_task_types.attribute6%TYPE := NULL
83 ,p_attribute7 IN pa_task_types.attribute7%TYPE := NULL
84 ,p_attribute8 IN pa_task_types.attribute8%TYPE := NULL
85 ,p_attribute9 IN pa_task_types.attribute9%TYPE := NULL
86 ,p_attribute10 IN pa_task_types.attribute10%TYPE := NULL
87 ,p_attribute11 IN pa_task_types.attribute11%TYPE := NULL
88 ,p_attribute12 IN pa_task_types.attribute12%TYPE := NULL
89 ,p_attribute13 IN pa_task_types.attribute13%TYPE := NULL
90 ,p_attribute14 IN pa_task_types.attribute14%TYPE := NULL
91 ,p_attribute15 IN pa_task_types.attribute15%TYPE := NULL
92 ,p_object_type IN pa_task_types.object_type%TYPE := 'PA_TASKS' -- 3279978 : Added Object Type and Progress Rollup Method
93 ,p_api_version IN NUMBER := 1.0
94 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
95 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
96 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
97 ,p_wf_item_type IN pa_task_types.wf_item_type%TYPE :=NULL
98 ,p_wf_process IN pa_task_types.wf_process%TYPE :=NULL
99 ,p_wf_lead_days IN pa_task_types.wf_start_lead_days%TYPE :=NULL
100 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
101 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
102 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
103 );
104
105
106 PROCEDURE Delete_Task_Type
107 (p_Task_Type_id IN pa_task_types.Task_Type_id%TYPE := NULL
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 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
113 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
114 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
115 );
116
117 PROCEDURE CREATE_DELIVERABLE_TYPE
118 (p_api_version IN NUMBER := 1.0
119 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
120 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
121 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
122 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
123 ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
124 ,p_debug_mode IN VARCHAR2 := 'N'
125 ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
126 ,p_deliverable_type_name IN PA_TASK_TYPES.TASK_TYPE%TYPE
127 ,p_prog_entry_enable_flag IN PA_TASK_TYPES.PROG_ENTRY_ENABLE_FLAG%TYPE := 'N'
128 ,p_initial_deliverable_status IN PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE := 'DLVR_NOT_STARTED'
129 ,p_deliverable_type_class IN PA_TASK_TYPES.TASK_TYPE_CLASS_CODE%TYPE := 'ITEM'
130 ,p_enable_dlvr_actions_flag IN PA_TASK_TYPES.ENABLE_DLVR_ACTIONS_FLAG%TYPE := 'N'
131 ,p_effective_from IN PA_TASK_TYPES.START_DATE_ACTIVE%TYPE
132 ,p_effective_to IN PA_TASK_TYPES. END_DATE_ACTIVE %TYPE := NULL
133 ,p_description IN PA_TASK_TYPES.DESCRIPTION%TYPE := NULL
134 ,p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE := NULL
135 ,p_record_version_number IN PA_TASK_TYPES.RECORD_VERSION_NUMBER%TYPE := 1
136 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
137 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
138 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
139 );
140
141 PROCEDURE UPDATE_DELIVERABLE_TYPE
142 (p_api_version IN NUMBER := 1.0
143 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
144 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
145 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
146 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
147 ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
148 ,p_debug_mode IN VARCHAR2 := 'N'
149 ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
150 ,p_deliverable_type_name IN PA_TASK_TYPES.TASK_TYPE%TYPE
151 ,p_prog_entry_enable_flag IN PA_TASK_TYPES.PROG_ENTRY_ENABLE_FLAG%TYPE := 'N'
152 ,p_initial_deliverable_status IN PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE := 'DLVR_NOT_STARTED'
153 ,p_deliverable_type_class IN PA_TASK_TYPES.TASK_TYPE_CLASS_CODE%TYPE := 'ITEM'
154 ,p_enable_dlvr_actions_flag IN PA_TASK_TYPES.ENABLE_DLVR_ACTIONS_FLAG%TYPE := 'N'
155 ,p_effective_from IN PA_TASK_TYPES.START_DATE_ACTIVE%TYPE
156 ,p_effective_to IN PA_TASK_TYPES. END_DATE_ACTIVE %TYPE := NULL
157 ,p_description IN PA_TASK_TYPES.DESCRIPTION%TYPE := NULL
158 ,p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE
159 ,p_record_version_number IN PA_TASK_TYPES.RECORD_VERSION_NUMBER%TYPE
160 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
161 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
162 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
163 );
164
165 PROCEDURE DELETE_DELIVERABLE_TYPE
166 (p_api_version IN NUMBER := 1.0
167 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
168 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
169 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
170 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
171 ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
172 ,p_debug_mode IN VARCHAR2 := 'N'
173 ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
174 ,p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE
175 ,p_record_version_number IN PA_TASK_TYPES.RECORD_VERSION_NUMBER%TYPE
176 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
177 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
178 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
179 );
180
181 PROCEDURE CR_UP_DELIVERABLE_TYPE
182 (p_api_version IN NUMBER := 1.0
183 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
184 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
185 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
186 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
187 ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
188 ,p_debug_mode IN VARCHAR2 := 'N'
189 ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
190 ,p_deliverable_type_name IN PA_TASK_TYPES.TASK_TYPE%TYPE
191 ,p_prog_entry_enable_flag IN PA_TASK_TYPES.PROG_ENTRY_ENABLE_FLAG%TYPE := 'N'
192 ,p_initial_deliverable_status IN PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE := 'DLVR_NOT_STARTED'
193 ,p_deliverable_type_class IN PA_TASK_TYPES.TASK_TYPE_CLASS_CODE%TYPE := 'ITEM'
194 ,p_enable_dlvr_actions_flag IN PA_TASK_TYPES.ENABLE_DLVR_ACTIONS_FLAG%TYPE := 'N'
195 ,p_effective_from IN PA_TASK_TYPES.START_DATE_ACTIVE%TYPE
196 ,p_effective_to IN PA_TASK_TYPES. END_DATE_ACTIVE %TYPE := NULL
197 ,p_description IN PA_TASK_TYPES.DESCRIPTION%TYPE := NULL
198 ,p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE := NULL
199 ,p_insert_or_update IN VARCHAR2 := 'INSERT'
200 ,p_record_version_number IN PA_TASK_TYPES.RECORD_VERSION_NUMBER%TYPE :=1
201 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
202 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
203 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
204 );
205
206 END PA_TASK_TYPE_PUB;