1 package PA_PERCENT_COMPLETES_PKG as
2 /* $Header: PAPCPKGS.pls 120.1 2005/08/05 03:38:41 lveerubh noship $*/
3
4 procedure INSERT_ROW( p_TASK_ID IN NUMBER,
5 p_DATE_COMPUTED IN DATE,
6 p_LAST_UPDATE_DATE IN DATE,
7 p_LAST_UPDATED_BY IN NUMBER,
8 p_CREATION_DATE IN DATE,
9 p_CREATED_BY IN NUMBER,
10 p_LAST_UPDATE_LOGIN IN NUMBER,
11 p_COMPLETED_PERCENTAGE IN NUMBER,
12 p_DESCRIPTION IN VARCHAR2,
13 p_PROJECT_ID IN NUMBER,
14 p_PM_PRODUCT_CODE IN VARCHAR2,
15 p_CURRENT_FLAG IN VARCHAR2,
16 p_OBJECT_TYPE IN VARCHAR2,
17 p_OBJECT_ID IN NUMBER,
18 p_OBJECT_VERSION_ID IN NUMBER,
19 p_PROGRESS_STATUS_CODE IN VARCHAR2,
20 p_ACTUAL_START_DATE IN DATE,
21 p_ACTUAL_FINISH_DATE IN DATE,
22 p_ESTIMATED_START_DATE IN DATE,
23 p_ESTIMATED_FINISH_DATE IN DATE,
24 p_PUBLISHED_FLAG IN VARCHAR2,
25 p_PUBLISHED_BY_PARTY_ID IN NUMBER,
26 p_PROGRESS_COMMENT IN VARCHAR2,
27 p_HISTORY_FLAG IN VARCHAR2,
28 p_status_code IN VARCHAR2,
29 x_PERCENT_COMPLETE_ID IN OUT NOCOPY NUMBER
30 ,p_ATTRIBUTE_CATEGORY IN VARCHAR2
31 ,p_ATTRIBUTE1 IN VARCHAR2
32 ,p_ATTRIBUTE2 IN VARCHAR2
33 ,p_ATTRIBUTE3 IN VARCHAR2
34 ,p_ATTRIBUTE4 IN VARCHAR2
35 ,p_ATTRIBUTE5 IN VARCHAR2
36 ,p_ATTRIBUTE6 IN VARCHAR2
37 ,p_ATTRIBUTE7 IN VARCHAR2
38 ,p_ATTRIBUTE8 IN VARCHAR2
39 ,p_ATTRIBUTE9 IN VARCHAR2
40 ,p_ATTRIBUTE10 IN VARCHAR2
41 ,p_ATTRIBUTE11 IN VARCHAR2
42 ,p_ATTRIBUTE12 IN VARCHAR2
43 ,p_ATTRIBUTE13 IN VARCHAR2
44 ,p_ATTRIBUTE14 IN VARCHAR2
45 ,p_ATTRIBUTE15 IN VARCHAR2
46 ,p_structure_type IN VARCHAR2
47 );
48
49 procedure UPDATE_ROW(
50 p_task_id IN NUMBER,
51 p_DATE_COMPUTED IN DATE,
52 p_LAST_UPDATE_DATE IN DATE,
53 p_LAST_UPDATED_BY IN NUMBER,
54 p_LAST_UPDATE_LOGIN IN NUMBER,
55 p_COMPLETED_PERCENTAGE IN NUMBER,
56 p_DESCRIPTION IN VARCHAR2,
57 p_PM_PRODUCT_CODE IN VARCHAR2,
58 p_CURRENT_FLAG IN VARCHAR2,
59 p_PERCENT_COMPLETE_ID IN NUMBER,
60 p_project_id IN NUMBER,
61 p_OBJECT_TYPE IN VARCHAR2,
62 p_OBJECT_ID IN NUMBER,
63 p_OBJECT_VERSION_ID IN NUMBER,
64 p_PROGRESS_STATUS_CODE IN VARCHAR2,
65 p_ACTUAL_START_DATE IN DATE,
66 p_ACTUAL_FINISH_DATE IN DATE,
67 p_ESTIMATED_START_DATE IN DATE,
68 p_ESTIMATED_FINISH_DATE IN DATE,
69 p_PUBLISHED_FLAG IN VARCHAR2,
70 p_PUBLISHED_BY_PARTY_ID IN NUMBER,
71 p_PROGRESS_COMMENT IN VARCHAR2,
72 p_HISTORY_FLAG IN VARCHAR2,
73 p_status_code IN VARCHAR2,
74 p_RECORD_VERSION_NUMBER IN NUMBER
75 ,p_ATTRIBUTE_CATEGORY IN VARCHAR2
76 ,p_ATTRIBUTE1 IN VARCHAR2
77 ,p_ATTRIBUTE2 IN VARCHAR2
78 ,p_ATTRIBUTE3 IN VARCHAR2
79 ,p_ATTRIBUTE4 IN VARCHAR2
80 ,p_ATTRIBUTE5 IN VARCHAR2
81 ,p_ATTRIBUTE6 IN VARCHAR2
82 ,p_ATTRIBUTE7 IN VARCHAR2
83 ,p_ATTRIBUTE8 IN VARCHAR2
84 ,p_ATTRIBUTE9 IN VARCHAR2
85 ,p_ATTRIBUTE10 IN VARCHAR2
86 ,p_ATTRIBUTE11 IN VARCHAR2
87 ,p_ATTRIBUTE12 IN VARCHAR2
88 ,p_ATTRIBUTE13 IN VARCHAR2
89 ,p_ATTRIBUTE14 IN VARCHAR2
90 ,p_ATTRIBUTE15 IN VARCHAR2
91 ,p_structure_type IN VARCHAR2
92 );
93
94 Procedure DELETE_ROW(
95 p_row_id VARCHAR2 );
96
97 end PA_PERCENT_COMPLETES_PKG;
98