30: NOT_VALID_FLAG)
31: VALUES
32: ( IEU_UWQ_RTNODE_BIND_VALS_S1.NEXTVAL,
33: P_SEL_RT_NODE_ID ,
34: FND_GLOBAL.USER_ID,
35: SYSDATE,
36: FND_GLOBAL.USER_ID,
37: SYSDATE,
38: FND_GLOBAL.LOGIN_ID,
32: ( IEU_UWQ_RTNODE_BIND_VALS_S1.NEXTVAL,
33: P_SEL_RT_NODE_ID ,
34: FND_GLOBAL.USER_ID,
35: SYSDATE,
36: FND_GLOBAL.USER_ID,
37: SYSDATE,
38: FND_GLOBAL.LOGIN_ID,
39: 1,
40: P_RESOURCE_ID ,
34: FND_GLOBAL.USER_ID,
35: SYSDATE,
36: FND_GLOBAL.USER_ID,
37: SYSDATE,
38: FND_GLOBAL.LOGIN_ID,
39: 1,
40: P_RESOURCE_ID ,
41: P_NODE_ID ,
42: P_BIND_VAR_NAME ,
56: ) is
57: begin
58: UPDATE IEU_UWQ_RTNODE_BIND_VALS
59: SET
60: CREATED_BY = FND_GLOBAL.USER_ID,
61: CREATION_DATE = SYSDATE,
62: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
63: LAST_UPDATE_DATE = SYSDATE,
64: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
58: UPDATE IEU_UWQ_RTNODE_BIND_VALS
59: SET
60: CREATED_BY = FND_GLOBAL.USER_ID,
61: CREATION_DATE = SYSDATE,
62: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
63: LAST_UPDATE_DATE = SYSDATE,
64: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
65: BIND_VAR_VALUE = P_BIND_VAR_VALUE,
66: BIND_VAR_DATATYPE = P_BIND_VAR_DATA_TYPE,
60: CREATED_BY = FND_GLOBAL.USER_ID,
61: CREATION_DATE = SYSDATE,
62: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
63: LAST_UPDATE_DATE = SYSDATE,
64: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
65: BIND_VAR_VALUE = P_BIND_VAR_VALUE,
66: BIND_VAR_DATATYPE = P_BIND_VAR_DATA_TYPE,
67: NOT_VALID_FLAG = 'N',
68: SEL_RT_NODE_ID = P_SEL_RT_NODE_ID,