DBA Data[Home] [Help]

APPS.IEU_UWQ_RTNODE_BIND_VAL_PKG dependencies on IEU_UWQ_RTNODE_BIND_VALS

Line 16: INSERT INTO IEU_UWQ_RTNODE_BIND_VALS

12: ) is
13: l_not_valid_flag VARCHAR2(1);
14: begin
15: l_not_valid_flag := 'N';
16: INSERT INTO IEU_UWQ_RTNODE_BIND_VALS
17: (RTNODE_BIND_VAR_ID,
18: SEL_RT_NODE_ID,
19: CREATED_BY,
20: CREATION_DATE,

Line 32: ( IEU_UWQ_RTNODE_BIND_VALS_S1.NEXTVAL,

28: BIND_VAR_VALUE,
29: BIND_VAR_DATATYPE,
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,

Line 58: UPDATE IEU_UWQ_RTNODE_BIND_VALS

54: P_BIND_VAR_DATA_TYPE in VARCHAR2
55:
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,

Line 120: delete from IEU_UWQ_RTNODE_BIND_VALS

116: P_SEL_RT_NODE_ID in NUMBER,
117: P_BIND_VAR_NAME in VARCHAR2
118: ) is
119: begin
120: delete from IEU_UWQ_RTNODE_BIND_VALS
121: where RESOURCE_ID = P_RESOURCE_ID
122: and NODE_ID = P_NODE_ID
123: and BIND_VAR_NAME = P_BIND_VAR_NAME
124: and SEL_RT_NODE_ID = P_SEL_RT_NODE_ID;