1 PACKAGE pa_percent_complete_pkg AS
2 /*$Header: PAXPRPCS.pls 120.1 2005/08/19 17:17:47 mwasowic noship $*/
3
4 -- -------------------------------------------------------------------------------------------------------
5 -- Globals
6 -- -------------------------------------------------------------------------------------------------------
7
8 G_PKG_NAME CONSTANT VARCHAR2(30) := 'PA_PERCENT_COMPLETE_PKG';
9
10 G_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
11 G_COMMIT CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
12 G_INIT_MSG_LIST CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
13
14 -- -------------------------------------------------------------------------------------------------------
15 -- Procedures
16 -- -------------------------------------------------------------------------------------------------------
17
18 PROCEDURE Lock_Row
19 (
20 x_rowid IN VARCHAR2
21 , x_project_id IN NUMBER
22 , x_task_id IN NUMBER
23 , x_percent_complete IN NUMBER
24 , x_as_of_date IN DATE
25 , x_current_flag IN VARCHAR2
26 , x_pm_product_code IN VARCHAR2
27 , x_description IN VARCHAR2
28 , x_last_update_date IN DATE
29 , x_last_updated_by IN NUMBER
30 , x_creation_date IN DATE
31 , x_created_by IN NUMBER
32 , x_last_update_login IN NUMBER
33 );
34
35
36 PROCEDURE Insert_Row
37 (
38 x_project_id IN NUMBER
39 , x_task_id IN NUMBER
40 , x_percent_complete IN NUMBER
41 , x_as_of_date IN DATE
42 , x_description IN VARCHAR2
43 , x_last_update_date IN DATE
44 , x_last_updated_by IN NUMBER
45 , x_creation_date IN DATE
46 , x_created_by IN NUMBER
47 , x_last_update_login IN NUMBER
48 , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
49 , x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
50 );
51
52
53 PROCEDURE Delete_Row (x_rowid IN VARCHAR2);
54
55
56
57
58 END pa_percent_complete_pkg ;