DBA Data[Home] [Help]

APPS.ASO_RELATED_OBJ_PVT dependencies on ASO_QUOTE_RELATED_OBJECTS

Line 144: -- Invoke table handler(ASO_QUOTE_RELATED_OBJECTS_PKG.Insert_Row)

140: end if;
141:
142: END IF;
143:
144: -- Invoke table handler(ASO_QUOTE_RELATED_OBJECTS_PKG.Insert_Row)
145: ASO_QUOTE_RELATED_OBJECTS_PKG.Insert_Row(
146: px_RELATED_OBJECT_ID => x_RELATED_OBJECT_ID,
147: p_CREATION_DATE => SYSDATE,
148: p_CREATED_BY => G_USER_ID,

Line 145: ASO_QUOTE_RELATED_OBJECTS_PKG.Insert_Row(

141:
142: END IF;
143:
144: -- Invoke table handler(ASO_QUOTE_RELATED_OBJECTS_PKG.Insert_Row)
145: ASO_QUOTE_RELATED_OBJECTS_PKG.Insert_Row(
146: px_RELATED_OBJECT_ID => x_RELATED_OBJECT_ID,
147: p_CREATION_DATE => SYSDATE,
148: p_CREATED_BY => G_USER_ID,
149: p_LAST_UPDATE_DATE => SYSDATE,

Line 259: From ASO_QUOTE_RELATED_OBJECTS

255: OBJECT_ID,
256: RELATIONSHIP_TYPE_CODE,
257: RECIPROCAL_FLAG
258: -- QUOTE_OBJECT_CODE
259: From ASO_QUOTE_RELATED_OBJECTS
260: where related_object_id = P_RELATED_OBJ_Rec.related_object_id;
261: --For Update NOWAIT;
262:
263: l_api_name CONSTANT VARCHAR2(30) := 'Update_related_obj';

Line 418: -- Invoke table handler(ASO_QUOTE_RELATED_OBJECTS_PKG.Update_Row)

414: end if;
415:
416: END IF;
417:
418: -- Invoke table handler(ASO_QUOTE_RELATED_OBJECTS_PKG.Update_Row)
419: ASO_QUOTE_RELATED_OBJECTS_PKG.Update_Row(
420: p_RELATED_OBJECT_ID => p_RELATED_OBJ_rec.RELATED_OBJECT_ID,
421: p_CREATION_DATE => SYSDATE,
422: p_CREATED_BY => G_USER_ID,

Line 419: ASO_QUOTE_RELATED_OBJECTS_PKG.Update_Row(

415:
416: END IF;
417:
418: -- Invoke table handler(ASO_QUOTE_RELATED_OBJECTS_PKG.Update_Row)
419: ASO_QUOTE_RELATED_OBJECTS_PKG.Update_Row(
420: p_RELATED_OBJECT_ID => p_RELATED_OBJ_rec.RELATED_OBJECT_ID,
421: p_CREATION_DATE => SYSDATE,
422: p_CREATED_BY => G_USER_ID,
423: p_LAST_UPDATE_DATE => SYSDATE,

Line 521: from aso_quote_related_objects

517: l_quote_object_id number;
518:
519: cursor quote_object is
520: select quote_object_type_code, quote_object_id
521: from aso_quote_related_objects
522: where related_object_id = p_related_obj_rec.related_object_id;
523:
524: BEGIN
525: -- Standard Start of API savepoint

Line 581: -- Invoke table handler(ASO_QUOTE_RELATED_OBJECTS_PKG.Delete_Row)

577: end if;
578:
579: END IF;
580:
581: -- Invoke table handler(ASO_QUOTE_RELATED_OBJECTS_PKG.Delete_Row)
582: ASO_QUOTE_RELATED_OBJECTS_PKG.Delete_Row(
583: p_RELATED_OBJECT_ID => p_RELATED_OBJ_rec.RELATED_OBJECT_ID);
584:
585: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 582: ASO_QUOTE_RELATED_OBJECTS_PKG.Delete_Row(

578:
579: END IF;
580:
581: -- Invoke table handler(ASO_QUOTE_RELATED_OBJECTS_PKG.Delete_Row)
582: ASO_QUOTE_RELATED_OBJECTS_PKG.Delete_Row(
583: p_RELATED_OBJECT_ID => p_RELATED_OBJ_rec.RELATED_OBJECT_ID);
584:
585: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
586: RAISE FND_API.G_EXC_ERROR;