52:
53: BEGIN
54: UPDATE IEU_UWQ_SEL_RT_NODES
55: SET
56: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
57: LAST_UPDATE_DATE = SYSDATE,
58: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
59: NODE_LABEL = P_NODE_LABEL,
60: DATA_SOURCE = P_DATA_SOURCE,
54: UPDATE IEU_UWQ_SEL_RT_NODES
55: SET
56: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
57: LAST_UPDATE_DATE = SYSDATE,
58: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
59: NODE_LABEL = P_NODE_LABEL,
60: DATA_SOURCE = P_DATA_SOURCE,
61: VIEW_NAME = P_VIEW_NAME,
62: REFRESH_VIEW_NAME = P_REFRESH_VIEW_NAME,
104: NOT_VALID,
105: NODE_DEPTH) -- Added for bug 4389449
106: VALUES (
107: IEU_UWQ_SEL_RT_NODES_S1.NEXTVAL,
108: FND_GLOBAL.USER_ID,
109: SYSDATE,
110: FND_GLOBAL.USER_ID,
111: SYSDATE,
112: FND_GLOBAL.LOGIN_ID,
106: VALUES (
107: IEU_UWQ_SEL_RT_NODES_S1.NEXTVAL,
108: FND_GLOBAL.USER_ID,
109: SYSDATE,
110: FND_GLOBAL.USER_ID,
111: SYSDATE,
112: FND_GLOBAL.LOGIN_ID,
113: P_RESOURCE_ID,
114: P_SEL_ENUM_ID,
108: FND_GLOBAL.USER_ID,
109: SYSDATE,
110: FND_GLOBAL.USER_ID,
111: SYSDATE,
112: FND_GLOBAL.LOGIN_ID,
113: P_RESOURCE_ID,
114: P_SEL_ENUM_ID,
115: l_node_id,
116: P_NODE_TYPE,