[Home] [Help]
1: package body XDP_WI_PARAMETERS_PKG as
2: /* $Header: XDPWIPAB.pls 120.1 2005/06/16 02:47:20 appldev $ */
3: procedure INSERT_ROW (
4: X_ROWID in OUT NOCOPY VARCHAR2,
5: -- skilaru 7/17/01 WI_PARAMETER_ID column dropped
23: X_LAST_UPDATE_LOGIN in NUMBER
24: ) is
25: cursor C is
26: select ROWID
27: from XDP_WI_PARAMETERS
28: -- skilaru 7/17/01 WI_PARAMETER_ID column dropped
29: -- where WI_PARAMETER_ID = X_WI_PARAMETER_ID
30: where PARAMETER_NAME = X_PARAMETER_NAME
31: and WORKITEM_ID = X_WORKITEM_ID;
30: where PARAMETER_NAME = X_PARAMETER_NAME
31: and WORKITEM_ID = X_WORKITEM_ID;
32:
33: begin
34: insert into XDP_WI_PARAMETERS (
35: WORKITEM_ID,
36: -- skilaru 7/17/01 WI_PARAMETER_ID column dropped
37: -- WI_PARAMETER_ID,
38: PARAMETER_NAME,
105: EVALUATION_SEQ,
106: EVALUATION_PROCEDURE,
107: DISPLAY_SEQ,
108: DEFAULT_VALUE
109: from XDP_WI_PARAMETERS
110: -- skilaru 7/17/01 WI_PARAMETER_ID column dropped
111: -- where WI_PARAMETER_ID = X_WI_PARAMETER_ID
112: where PARAMETER_NAME = X_PARAMETER_NAME
113: and WORKITEM_ID = X_WORKITEM_ID
162: X_LAST_UPDATED_BY in NUMBER,
163: X_LAST_UPDATE_LOGIN in NUMBER
164: ) is
165: begin
166: update XDP_WI_PARAMETERS set
167: REQUIRED_FLAG = X_REQUIRED_FLAG,
168: LOG_IN_AUDIT_TRAIL_FLAG = X_LOG_IN_AUDIT_TRAIL_FLAG,
169: VALUE_LOOKUP_SQL = X_VALUE_LOOKUP_SQL,
170: VALIDATION_PROCEDURE = X_VALIDATION_PROCEDURE,
192: X_PARAMETER_NAME in VARCHAR2,
193: X_WORKITEM_ID in NUMBER
194: ) is
195: begin
196: delete from XDP_WI_PARAMETERS
197: -- skilaru 7/17/01 WI_PARAMETER_ID dropped
198: -- where WI_PARAMETER_ID = X_WI_PARAMETER_ID
199: where PARAMETER_NAME = X_PARAMETER_NAME
200: and WORKITEM_ID = X_WORKITEM_ID;
204: end if;
205:
206: end DELETE_ROW;
207:
208: end XDP_WI_PARAMETERS_PKG;