APPS.IEU_UWQ_SEL_RT_NODES_PKG dependencies on IEU_UWQ_SEL_RT_NODES

Line 1: package body IEU_UWQ_SEL_RT_NODES_PKG as

1: package body IEU_UWQ_SEL_RT_NODES_PKG as
2: /* $Header: IEUSRTNB.pls 120.0 2005/06/02 15:44:00 appldev noship $ */
3: procedure INSERT_ROW (
4: X_RESOURCE_ID in NUMBER,
5: X_SEL_ENUM_ID in NUMBER,

Line 31: insert into IEU_UWQ_SEL_RT_NODES (

27: X_REFRESH_VIEW_SUM_COL in VARCHAR2
28: ) is
29:
30: begin
31: insert into IEU_UWQ_SEL_RT_NODES (
32: SEL_ENUM_ID,
33: NODE_LABEL,
34: NODE_WEIGHT,
35: SEL_ENUM_PID,

Line 111: update IEU_UWQ_SEL_RT_NODES set

107: X_RES_CAT_ENUM_FLAG IN VARCHAR2,
108: X_REFRESH_VIEW_SUM_COL in VARCHAR2
109: ) is
110: begin
111: update IEU_UWQ_SEL_RT_NODES set
112: SEL_ENUM_ID = X_SEL_ENUM_ID,
113: NODE_ID = X_NODE_ID,
114: NODE_TYPE = X_NODE_TYPE,
115: NODE_PID = X_NODE_PID,

Line 164: update IEU_UWQ_SEL_RT_NODES set

160:
161: ) is
162:
163: begin
164: update IEU_UWQ_SEL_RT_NODES set
165: SEL_ENUM_ID = X_SEL_ENUM_ID,
166: NODE_ID = X_NODE_ID,
167: NODE_TYPE = X_NODE_TYPE,
168: NODE_PID = X_NODE_PID,

Line 196: insert into IEU_UWQ_SEL_RT_NODES (

192:
193: exception
194: when no_data_found then
195: -- dbms_output.put_line('inserting');
196: insert into IEU_UWQ_SEL_RT_NODES (
197: SEL_RT_NODE_ID,
198: SEL_ENUM_ID,
199: NODE_LABEL,
200: NODE_WEIGHT,

Line 224: IEU_UWQ_SEL_RT_NODES_S1.NEXTVAL,

220: RES_CAT_ENUM_FLAG,
221: NOT_VALID
222: ) values
223: (
224: IEU_UWQ_SEL_RT_NODES_S1.NEXTVAL,
225: X_SEL_ENUM_ID,
226: X_NODE_LABEL,
227: X_NODE_WEIGHT,
228: X_NODE_DEPTH,

Line 261: delete from IEU_UWQ_SEL_RT_NODES

257: X_NODE_TYPE in NUMBER,
258: X_NODE_PID in NUMBER
259: ) is
260: begin
261: delete from IEU_UWQ_SEL_RT_NODES
262: where RESOURCE_ID = X_RESOURCE_ID
263: and SEL_ENUM_ID = X_SEL_ENUM_ID
264: and NODE_ID = X_NODE_ID
265: and NODE_TYPE = X_NODE_TYPE

Line 274: end IEU_UWQ_SEL_RT_NODES_PKG;

270: end if;
271:
272: end DELETE_ROW;
273:
274: end IEU_UWQ_SEL_RT_NODES_PKG;