APPS.ASO_SUP_TMPL_INSTANCE_PKG dependencies on FND_API

Line 53: IF (PX_TEMPLATE_INSTANCE_ID IS NULL) OR (PX_TEMPLATE_INSTANCE_ID = FND_API.G_MISS_NUM) THEN

49: select ASO_SUP_TMPL_INSTANCE_S.NEXTVAL from sys.dual;
50:
51: Begin
52:
53: IF (PX_TEMPLATE_INSTANCE_ID IS NULL) OR (PX_TEMPLATE_INSTANCE_ID = FND_API.G_MISS_NUM) THEN
54: OPEN CU_TEMPLATE_INSTANCE_ID;
55: FETCH CU_TEMPLATE_INSTANCE_ID INTO PX_TEMPLATE_INSTANCE_ID ;
56: CLOSE CU_TEMPLATE_INSTANCE_ID;
57:

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

121: P_ATTRIBUTE17,
122: P_ATTRIBUTE18,
123: P_ATTRIBUTE19,
124: P_ATTRIBUTE20,
125: decode ( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM,1,NULL,1, p_OBJECT_VERSION_NUMBER)
126: ) ;
127:
128:
129: open c;

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

204: ATTRIBUTE17 = P_ATTRIBUTE17,
205: ATTRIBUTE18 = P_ATTRIBUTE18,
206: ATTRIBUTE19 = P_ATTRIBUTE19,
207: ATTRIBUTE20 = P_ATTRIBUTE20,
208: 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)
209: where TEMPLATE_INSTANCE_ID = P_TEMPLATE_INSTANCE_ID;
210:
211: if (sql%notfound) then
212: raise no_data_found;