1 package PA_PROJ_PROGRESS_ATTR_PKG as
2 /* $Header: PAPPPKGS.pls 120.1 2005/08/19 16:43:31 mwasowic noship $*/
3
4 procedure INSERT_ROW(
5 X_PROJ_PROGRESS_ATTR_ID IN OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
6 ,X_PROJECT_ID IN NUMBER
7 ,X_OBJECT_TYPE IN VARCHAR2
8 ,X_OBJECT_ID IN NUMBER
9 ,X_LAST_UPDATE_DATE IN DATE
10 ,X_LAST_UPDATED_BY IN NUMBER
11 ,X_CREATION_DATE IN DATE
12 ,X_CREATED_BY IN NUMBER
13 ,X_LAST_UPDATE_LOGIN IN NUMBER
14 ,X_PROGRESS_CYCLE_ID IN NUMBER
15 ,X_WQ_ENABLE_FLAG IN VARCHAR2
16 ,X_REMAIN_EFFORT_ENABLE_FLAG IN VARCHAR2
17 ,X_PERCENT_COMP_ENABLE_FLAG IN VARCHAR2
18 ,X_NEXT_PROGRESS_UPDATE_DATE IN DATE
19 ,X_TASK_WEIGHT_BASIS_CODE IN VARCHAR2
20 ,X_ALLOW_COLLAB_PROG_ENTRY IN VARCHAR2
21 ,X_ALLW_PHY_PRCNT_CMP_OVERRIDES IN VARCHAR2
22 ,X_STRUCTURE_TYPE IN VARCHAR2
23 );
24
25 procedure UPDATE_ROW(
26 X_PROJ_PROGRESS_ATTR_ID IN NUMBER
27 ,X_PROJECT_ID IN NUMBER
28 ,X_OBJECT_TYPE IN VARCHAR2
29 ,X_OBJECT_ID IN NUMBER
30 ,X_LAST_UPDATE_DATE IN DATE
31 ,X_LAST_UPDATED_BY IN NUMBER
32 ,X_LAST_UPDATE_LOGIN IN NUMBER
33 ,X_PROGRESS_CYCLE_ID IN NUMBER
34 ,X_WQ_ENABLE_FLAG IN VARCHAR2
35 ,X_REMAIN_EFFORT_ENABLE_FLAG IN VARCHAR2
36 ,X_PERCENT_COMP_ENABLE_FLAG IN VARCHAR2
37 ,X_NEXT_PROGRESS_UPDATE_DATE IN DATE
38 ,X_RECORD_VERSION_NUMBER IN NUMBER
39 ,X_TASK_WEIGHT_BASIS_CODE IN VARCHAR2
40 ,X_ALLOW_COLLAB_PROG_ENTRY IN VARCHAR2
41 ,X_ALLW_PHY_PRCNT_CMP_OVERRIDES IN VARCHAR2
42 ,X_STRUCTURE_TYPE IN VARCHAR2
43 );
44
45 Procedure DELETE_ROW(
46 p_row_id VARCHAR2 );
47
48 end PA_PROJ_PROGRESS_ATTR_PKG;
49
[Home] [Help]