52: select ASO_SUP_INST_VALUE_S.NEXTVAL from sys.dual;
53:
54: Begin
55:
56: IF (PX_INSTANCE_VALUE_ID IS NULL) OR (PX_INSTANCE_VALUE_ID = FND_API.G_MISS_NUM) THEN
57: OPEN CU_VALUE_ID;
58: FETCH CU_VALUE_ID INTO PX_INSTANCE_VALUE_ID;
59: CLOSE CU_VALUE_ID;
60:
128: P_ATTRIBUTE17,
129: P_ATTRIBUTE18,
130: P_ATTRIBUTE19,
131: P_ATTRIBUTE20,
132: decode ( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM,1,NULL,1, p_OBJECT_VERSION_NUMBER)
133: );
134:
135:
136: open c;
215: ATTRIBUTE17 = P_ATTRIBUTE17,
216: ATTRIBUTE18 = P_ATTRIBUTE18,
217: ATTRIBUTE19 = P_ATTRIBUTE19,
218: ATTRIBUTE20 = P_ATTRIBUTE20,
219: OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, nvl(OBJECT_VERSION_NUMBER,0)+1, nvl(p_OBJECT_VERSION_NUMBER, nvl(OBJECT_VERSION_NUMBER,0))+1)
220: where INSTANCE_VALUE_ID = P_INSTANCE_VALUE_ID;
221:
222: if (sql%notfound) then
223: raise no_data_found;