DBA Data[Home] [Help]

PACKAGE: APPS.XDP_WI_PARAMETERS_PKG

Source


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;