DBA Data[Home] [Help]

APPS.ASO_QUOTE_HEADERS_PKG dependencies on ASO_QUOTE_HEADERS_ALL

Line 136: INSERT INTO ASO_QUOTE_HEADERS_ALL(

132: FETCH C2 INTO px_QUOTE_HEADER_ID;
133: CLOSE C2;
134: End If;
135:
136: INSERT INTO ASO_QUOTE_HEADERS_ALL(
137: QUOTE_HEADER_ID,
138: CREATION_DATE,
139: CREATED_BY,
140: LAST_UPDATE_DATE,

Line 477: Update ASO_QUOTE_HEADERS_ALL

473: )
474:
475: IS
476: BEGIN
477: Update ASO_QUOTE_HEADERS_ALL
478: SET
479: /* CREATION_DATE = ASO_UTILITY_PVT.decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
480: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),*/
481: LAST_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),

Line 605: DELETE FROM ASO_QUOTE_HEADERS_ALL

601: PROCEDURE Delete_Row(
602: p_QUOTE_HEADER_ID NUMBER)
603: IS
604: BEGIN
605: DELETE FROM ASO_QUOTE_HEADERS_ALL
606: WHERE QUOTE_HEADER_ID = p_QUOTE_HEADER_ID;
607: If (SQL%NOTFOUND) then
608: RAISE NO_DATA_FOUND;
609: End If;

Line 777: FROM ASO_QUOTE_HEADERS_ALL

773: /*
774: QUOTE_TYPE,
775: QUOTE_DESCRIPTION
776: */
777: FROM ASO_QUOTE_HEADERS_ALL
778: WHERE QUOTE_HEADER_ID = p_QUOTE_HEADER_ID
779: FOR UPDATE of QUOTE_HEADER_ID NOWAIT;
780: Recinfo C%ROWTYPE;
781: BEGIN