DBA Data[Home] [Help]

APPS.ASO_QUOTE_LINES_PKG dependencies on ASO_QUOTE_LINES_ALL

Line 117: INSERT INTO ASO_QUOTE_LINES_ALL(

113: FETCH C2 INTO px_QUOTE_LINE_ID;
114: CLOSE C2;
115:
116: End If;
117: INSERT INTO ASO_QUOTE_LINES_ALL(
118: QUOTE_LINE_ID,
119: CREATION_DATE,
120: CREATED_BY,
121: LAST_UPDATE_DATE,

Line 384: Update ASO_QUOTE_LINES_ALL

380: )
381:
382: IS
383: BEGIN
384: Update ASO_QUOTE_LINES_ALL
385: SET
386: /* CREATION_DATE = ASO_UTILITY_PVT.decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
387: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY,p_CREATED_BY),*/
388: LAST_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),

Line 486: DELETE FROM ASO_QUOTE_LINES_ALL

482: PROCEDURE Delete_Row(
483: p_QUOTE_LINE_ID NUMBER)
484: IS
485: BEGIN
486: DELETE FROM ASO_QUOTE_LINES_ALL
487: WHERE QUOTE_LINE_ID = p_QUOTE_LINE_ID;
488:
489: If (SQL%NOTFOUND) then
490: RAISE NO_DATA_FOUND;

Line 617: FROM ASO_QUOTE_LINES_ALL

613: PRICED_PRICE_LIST_ID ,
614: AGREEMENT_ID ,
615: COMMITMENT_ID ,
616: DISPLAY_ARITHMETIC_OPERATOR */
617: FROM ASO_QUOTE_LINES_ALL
618: WHERE QUOTE_LINE_ID = p_QUOTE_LINE_ID
619: FOR UPDATE of QUOTE_LINE_ID NOWAIT;
620: Recinfo C%ROWTYPE;
621: BEGIN