DBA Data[Home] [Help]

APPS.ASO_SUP_INSTANCE_VALUE_PKG dependencies on FND_API

Line 56: IF (PX_INSTANCE_VALUE_ID IS NULL) OR (PX_INSTANCE_VALUE_ID = FND_API.G_MISS_NUM) THEN

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:

Line 132: decode ( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM,1,NULL,1, p_OBJECT_VERSION_NUMBER)

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;

Line 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)

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;