1 package XDP_WI_PARAMETERS_PKG as
2 /* $Header: XDPWIPAS.pls 120.1 2005/06/16 02:48:01 appldev $ */
3 procedure INSERT_ROW (
4 X_ROWID in OUT NOCOPY VARCHAR2,
5 -- skilaru 7/17/01
6 -- X_WI_PARAMETER_ID is dropped in 11.5.6
7 -- X_WI_PARAMETER_ID in NUMBER,
8 X_PARAMETER_NAME in VARCHAR2,
9 X_WORKITEM_ID in NUMBER,
10 X_REQUIRED_FLAG in VARCHAR2,
11 X_LOG_IN_AUDIT_TRAIL_FLAG in VARCHAR2,
12 X_VALUE_LOOKUP_SQL in VARCHAR2,
13 X_VALIDATION_PROCEDURE in VARCHAR2,
14 X_EVALUATION_MODE in VARCHAR2,
15 X_EVALUATION_SEQ in NUMBER,
16 X_EVALUATION_PROCEDURE in VARCHAR2,
17 X_DISPLAY_SEQ in NUMBER,
18 X_DEFAULT_VALUE in VARCHAR2,
19 X_CREATION_DATE in DATE,
20 X_CREATED_BY in NUMBER,
21 X_LAST_UPDATE_DATE in DATE,
22 X_LAST_UPDATED_BY in NUMBER,
23 X_LAST_UPDATE_LOGIN in NUMBER);
24 procedure LOCK_ROW (
25 -- skilaru 7/17/01
26 -- X_WI_PARAMETER_ID is dropped in 11.5.6
27 -- X_WI_PARAMETER_ID in NUMBER,
28 X_PARAMETER_NAME in VARCHAR2,
29 X_WORKITEM_ID in NUMBER,
30 X_REQUIRED_FLAG in VARCHAR2,
31 X_LOG_IN_AUDIT_TRAIL_FLAG in VARCHAR2,
32 X_VALUE_LOOKUP_SQL in VARCHAR2,
33 X_VALIDATION_PROCEDURE in VARCHAR2,
34 X_EVALUATION_MODE in VARCHAR2,
35 X_EVALUATION_SEQ in NUMBER,
36 X_EVALUATION_PROCEDURE in VARCHAR2,
37 X_DISPLAY_SEQ in NUMBER,
38 X_DEFAULT_VALUE in VARCHAR2
39 );
40 procedure UPDATE_ROW (
41 -- skilaru 7/17/01
42 -- X_WI_PARAMETER_ID is dropped in 11.5.6
43 -- X_WI_PARAMETER_ID in NUMBER,
44 X_PARAMETER_NAME in VARCHAR2,
45 X_WORKITEM_ID in NUMBER,
46 X_REQUIRED_FLAG in VARCHAR2,
47 X_LOG_IN_AUDIT_TRAIL_FLAG in VARCHAR2,
48 X_VALUE_LOOKUP_SQL in VARCHAR2,
49 X_VALIDATION_PROCEDURE in VARCHAR2,
50 X_EVALUATION_MODE in VARCHAR2,
51 X_EVALUATION_SEQ in NUMBER,
52 X_EVALUATION_PROCEDURE in VARCHAR2,
53 X_DISPLAY_SEQ in NUMBER,
54 X_DEFAULT_VALUE in VARCHAR2,
55 X_LAST_UPDATE_DATE in DATE,
56 X_LAST_UPDATED_BY in NUMBER,
57 X_LAST_UPDATE_LOGIN in NUMBER
58 );
59 procedure DELETE_ROW (
60 -- skilaru 7/17/01
61 -- X_WI_PARAMETER_ID is dropped in 11.5.6
62 -- X_WI_PARAMETER_ID in NUMBER,
63 X_PARAMETER_NAME in VARCHAR2,
64 X_WORKITEM_ID in NUMBER
65 );
66 end XDP_WI_PARAMETERS_PKG;