126: RES_CAT_ENUM_FLAG = X_RES_CAT_ENUM_FLAG,
127: NOT_VALID = X_NOT_VALID,
128: NODE_LABEL = X_NODE_LABEL,
129: LAST_UPDATE_DATE = sysdate,
130: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
131: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
132: where RESOURCE_ID = X_RESOURCE_ID
133: and NODE_ID = X_NODE_ID;
134:
127: NOT_VALID = X_NOT_VALID,
128: NODE_LABEL = X_NODE_LABEL,
129: LAST_UPDATE_DATE = sysdate,
130: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
131: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
132: where RESOURCE_ID = X_RESOURCE_ID
133: and NODE_ID = X_NODE_ID;
134:
135: if (sql%notfound) then
180: RES_CAT_ENUM_FLAG = X_RES_CAT_ENUM_FLAG,
181: NOT_VALID = X_NOT_VALID,
182: NODE_LABEL = X_NODE_LABEL,
183: LAST_UPDATE_DATE = sysdate,
184: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
185: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
186: where RESOURCE_ID = X_RESOURCE_ID
187: and NODE_ID = X_NODE_ID;
188:
181: NOT_VALID = X_NOT_VALID,
182: NODE_LABEL = X_NODE_LABEL,
183: LAST_UPDATE_DATE = sysdate,
184: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
185: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
186: where RESOURCE_ID = X_RESOURCE_ID
187: and NODE_ID = X_NODE_ID;
188:
189: if (sql%notfound) then --dbms_output.put_line('proc load row');
226: X_NODE_LABEL,
227: X_NODE_WEIGHT,
228: X_NODE_DEPTH,
229: X_SEL_ENUM_PID,
230: FND_GLOBAL.USER_ID,
231: sysdate,
232: FND_GLOBAL.USER_ID,
233: sysdate,
234: FND_GLOBAL.LOGIN_ID,
228: X_NODE_DEPTH,
229: X_SEL_ENUM_PID,
230: FND_GLOBAL.USER_ID,
231: sysdate,
232: FND_GLOBAL.USER_ID,
233: sysdate,
234: FND_GLOBAL.LOGIN_ID,
235: X_MEDIA_TYPE_ID,
236: X_RESOURCE_ID,
230: FND_GLOBAL.USER_ID,
231: sysdate,
232: FND_GLOBAL.USER_ID,
233: sysdate,
234: FND_GLOBAL.LOGIN_ID,
235: X_MEDIA_TYPE_ID,
236: X_RESOURCE_ID,
237: X_NODE_ID,
238: X_NODE_TYPE,