1 PACKAGE PJM_PROJECT_PARAMS_PKG AUTHID CURRENT_USER AS
2 /* $Header: PJMPPRMS.pls 115.1 2002/10/29 20:13:53 alaw noship $ */
3
4 PROCEDURE insert_row
5 ( X_ROWID IN OUT NOCOPY VARCHAR2
6 , X_PROJECT_ID IN NUMBER
7 , X_ORGANIZATION_ID IN NUMBER
8 , X_SEIBAN_NUMBER_FLAG IN NUMBER
9 , X_COSTING_GROUP_ID IN NUMBER
10 , X_PLANNING_GROUP IN VARCHAR2
11 , X_WIP_ACCT_CLASS_CODE IN VARCHAR2
12 , X_EAM_ACCT_CLASS_CODE IN VARCHAR2
13 , X_START_DATE_ACTIVE IN DATE
14 , X_END_DATE_ACTIVE IN DATE
15 , X_IPV_EXPENDITURE_TYPE IN VARCHAR2
16 , X_ERV_EXPENDITURE_TYPE IN VARCHAR2
17 , X_FREIGHT_EXPENDITURE_TYPE IN VARCHAR2
18 , X_TAX_EXPENDITURE_TYPE IN VARCHAR2
19 , X_MISC_EXPENDITURE_TYPE IN VARCHAR2
20 , X_PPV_EXPENDITURE_TYPE IN VARCHAR2
21 , X_DIR_ITEM_EXPENDITURE_TYPE IN VARCHAR2
22 , X_ATTRIBUTE_CATEGORY IN VARCHAR2
23 , X_ATTRIBUTE1 IN VARCHAR2
24 , X_ATTRIBUTE2 IN VARCHAR2
25 , X_ATTRIBUTE3 IN VARCHAR2
26 , X_ATTRIBUTE4 IN VARCHAR2
27 , X_ATTRIBUTE5 IN VARCHAR2
28 , X_ATTRIBUTE6 IN VARCHAR2
29 , X_ATTRIBUTE7 IN VARCHAR2
30 , X_ATTRIBUTE8 IN VARCHAR2
31 , X_ATTRIBUTE9 IN VARCHAR2
32 , X_ATTRIBUTE10 IN VARCHAR2
33 , X_ATTRIBUTE11 IN VARCHAR2
34 , X_ATTRIBUTE12 IN VARCHAR2
35 , X_ATTRIBUTE13 IN VARCHAR2
36 , X_ATTRIBUTE14 IN VARCHAR2
37 , X_ATTRIBUTE15 IN VARCHAR2
38 , X_CREATION_DATE IN DATE
39 , X_CREATED_BY IN NUMBER
40 , X_LAST_UPDATE_DATE IN DATE
41 , X_LAST_UPDATED_BY IN NUMBER
42 , X_LAST_UPDATE_LOGIN IN NUMBER
43 );
44
45 PROCEDURE lock_row
46 ( X_PROJECT_ID IN NUMBER
47 , X_ORGANIZATION_ID IN NUMBER
48 , X_COSTING_GROUP_ID IN NUMBER
49 , X_WIP_ACCT_CLASS_CODE IN VARCHAR2
50 , X_EAM_ACCT_CLASS_CODE IN VARCHAR2
51 , X_START_DATE_ACTIVE IN DATE
52 , X_END_DATE_ACTIVE IN DATE
53 , X_IPV_EXPENDITURE_TYPE IN VARCHAR2
54 , X_ERV_EXPENDITURE_TYPE IN VARCHAR2
55 , X_FREIGHT_EXPENDITURE_TYPE IN VARCHAR2
56 , X_TAX_EXPENDITURE_TYPE IN VARCHAR2
57 , X_MISC_EXPENDITURE_TYPE IN VARCHAR2
58 , X_PPV_EXPENDITURE_TYPE IN VARCHAR2
59 , X_DIR_ITEM_EXPENDITURE_TYPE IN VARCHAR2
60 , X_ATTRIBUTE_CATEGORY IN VARCHAR2
61 , X_ATTRIBUTE1 IN VARCHAR2
62 , X_ATTRIBUTE2 IN VARCHAR2
63 , X_ATTRIBUTE3 IN VARCHAR2
64 , X_ATTRIBUTE4 IN VARCHAR2
65 , X_ATTRIBUTE5 IN VARCHAR2
66 , X_ATTRIBUTE6 IN VARCHAR2
67 , X_ATTRIBUTE7 IN VARCHAR2
68 , X_ATTRIBUTE8 IN VARCHAR2
69 , X_ATTRIBUTE9 IN VARCHAR2
70 , X_ATTRIBUTE10 IN VARCHAR2
71 , X_ATTRIBUTE11 IN VARCHAR2
72 , X_ATTRIBUTE12 IN VARCHAR2
73 , X_ATTRIBUTE13 IN VARCHAR2
74 , X_ATTRIBUTE14 IN VARCHAR2
75 , X_ATTRIBUTE15 IN VARCHAR2
76 );
77
78 PROCEDURE update_row
79 ( X_PROJECT_ID IN NUMBER
80 , X_ORGANIZATION_ID IN NUMBER
81 , X_COSTING_GROUP_ID IN NUMBER
82 , X_WIP_ACCT_CLASS_CODE IN VARCHAR2
83 , X_EAM_ACCT_CLASS_CODE IN VARCHAR2
84 , X_START_DATE_ACTIVE IN DATE
85 , X_END_DATE_ACTIVE IN DATE
86 , X_IPV_EXPENDITURE_TYPE IN VARCHAR2
87 , X_ERV_EXPENDITURE_TYPE IN VARCHAR2
88 , X_FREIGHT_EXPENDITURE_TYPE IN VARCHAR2
89 , X_TAX_EXPENDITURE_TYPE IN VARCHAR2
90 , X_MISC_EXPENDITURE_TYPE IN VARCHAR2
91 , X_PPV_EXPENDITURE_TYPE IN VARCHAR2
92 , X_DIR_ITEM_EXPENDITURE_TYPE IN VARCHAR2
93 , X_ATTRIBUTE_CATEGORY IN VARCHAR2
94 , X_ATTRIBUTE1 IN VARCHAR2
95 , X_ATTRIBUTE2 IN VARCHAR2
96 , X_ATTRIBUTE3 IN VARCHAR2
97 , X_ATTRIBUTE4 IN VARCHAR2
98 , X_ATTRIBUTE5 IN VARCHAR2
99 , X_ATTRIBUTE6 IN VARCHAR2
100 , X_ATTRIBUTE7 IN VARCHAR2
101 , X_ATTRIBUTE8 IN VARCHAR2
102 , X_ATTRIBUTE9 IN VARCHAR2
103 , X_ATTRIBUTE10 IN VARCHAR2
104 , X_ATTRIBUTE11 IN VARCHAR2
105 , X_ATTRIBUTE12 IN VARCHAR2
106 , X_ATTRIBUTE13 IN VARCHAR2
107 , X_ATTRIBUTE14 IN VARCHAR2
108 , X_ATTRIBUTE15 IN VARCHAR2
109 , X_LAST_UPDATE_DATE IN DATE
110 , X_LAST_UPDATED_BY IN NUMBER
111 , X_LAST_UPDATE_LOGIN IN NUMBER
112 );
113
114 PROCEDURE delete_row
115 ( X_PROJECT_ID IN NUMBER
116 , X_ORGANIZATION_ID IN NUMBER
117 );
118
119 PROCEDURE update_planning_group
120 ( X_PROJECT_ID IN NUMBER
121 , X_PLANNING_GROUP IN VARCHAR2
122 );
123
124 END;
[Home] [Help]