1 PACKAGE PA_ASSIGNMENT_PROGRESS_PUB AS
2 /* $Header: PAPRASPS.pls 120.1 2005/08/19 16:44:08 mwasowic noship $ */
3
4 PROCEDURE UPDATE_ASSIGNMENT_PROGRESS(
5 p_api_version IN NUMBER := 1.0 ,
6 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
7 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
8 p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
9 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
10 p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
11 p_action IN VARCHAR2 := 'SAVE' ,
12 p_bulk_load_flag IN VARCHAR2 := 'N' ,
13 p_progress_mode IN VARCHAR2 := 'FUTURE' ,
14 p_percent_complete_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
15 p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
16 p_object_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
17 p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
18 p_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
19 p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
20 p_progress_comment IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
21 p_brief_overview IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
22 p_actual_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
23 p_actual_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
24 p_estimated_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
25 p_estimated_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
26 p_record_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
27 p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
28 p_rate_based_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
29 p_resource_class_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
30 p_txn_currency_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
31 p_rbs_element_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
32 -- p_resource_list_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM , --bug# 3764224
33 p_resource_assignment_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
34 p_actual_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
35 p_actual_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
36 p_planned_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
37 p_planned_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
38 p_structure_type IN VARCHAR2 := 'WORKPLAN' ,
39 p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
40 p_actual_cost_this_period IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
41 p_actual_effort_this_period IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
42 p_etc_cost_this_period IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
43 p_etc_effort_this_period IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
44 p_scheduled_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
45 p_scheduled_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
46 x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
47 x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
48 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
49 );
50
51 END PA_ASSIGNMENT_PROGRESS_PUB;