APPS.ASO_STATUS_TRANS_PKG dependencies on ASO_QUOTE_STATUS_TRANSITIONS

Line 53: CURSOR C2 IS SELECT ASO_QUOTE_STATUS_TRANSITIONS_S.nextval FROM sys.dual;

49: p_ATTRIBUTE19 VARCHAR2,
50: p_ATTRIBUTE20 VARCHAR2)
51:
52: IS
53: CURSOR C2 IS SELECT ASO_QUOTE_STATUS_TRANSITIONS_S.nextval FROM sys.dual;
54: BEGIN
55: If (px_TRANSITION_ID IS NULL) OR (px_TRANSITION_ID = FND_API.G_MISS_NUM) then
56: OPEN C2;
57: FETCH C2 INTO px_TRANSITION_ID;

Line 60: INSERT INTO ASO_QUOTE_STATUS_TRANSITIONS(

56: OPEN C2;
57: FETCH C2 INTO px_TRANSITION_ID;
58: CLOSE C2;
59: End If;
60: INSERT INTO ASO_QUOTE_STATUS_TRANSITIONS(
61: TRANSITION_ID,
62: CREATION_DATE,
63: CREATED_BY,
64: LAST_UPDATED_BY,

Line 177: Update ASO_QUOTE_STATUS_TRANSITIONS

173: )
174:
175: IS
176: BEGIN
177: Update ASO_QUOTE_STATUS_TRANSITIONS
178: SET
179: CREATION_DATE = ASO_UTILITY_PVT.decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
180: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
181: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),

Line 225: DELETE FROM ASO_QUOTE_STATUS_TRANSITIONS

221: PROCEDURE Delete_Row(
222: p_TRANSITION_ID NUMBER)
223: IS
224: BEGIN
225: DELETE FROM ASO_QUOTE_STATUS_TRANSITIONS
226: WHERE TRANSITION_ID = p_TRANSITION_ID;
227: If (SQL%NOTFOUND) then
228: RAISE NO_DATA_FOUND;
229: End If;

Line 298: FROM ASO_QUOTE_STATUS_TRANSITIONS

294: ATTRIBUTE12,
295: ATTRIBUTE13,
296: ATTRIBUTE14,
297: ATTRIBUTE15
298: FROM ASO_QUOTE_STATUS_TRANSITIONS
299: WHERE TRANSITION_ID = p_TRANSITION_ID
300: FOR UPDATE of TRANSITION_ID NOWAIT;
301: Recinfo C%ROWTYPE;
302: BEGIN