58: p_MEANING VARCHAR2,
59: p_DESCRIPTION VARCHAR2)
60:
61: IS
62: CURSOR C IS SELECT ASO_QUOTE_STATUSES_B_S.nextval FROM sys.dual;
63: BEGIN
64: If (px_QUOTE_STATUS_ID IS NULL) OR (px_QUOTE_STATUS_ID = FND_API.G_MISS_NUM) then
65: OPEN C;
66: FETCH C INTO px_QUOTE_STATUS_ID;
65: OPEN C;
66: FETCH C INTO px_QUOTE_STATUS_ID;
67: CLOSE C;
68: End If;
69: INSERT INTO ASO_QUOTE_STATUSES_B(
70: QUOTE_STATUS_ID,
71: CREATION_DATE,
72: CREATED_BY,
73: LAST_UPDATED_BY,
241: p_MEANING VARCHAR2,
242: p_DESCRIPTION VARCHAR2)
243: IS
244: BEGIN
245: Update ASO_QUOTE_STATUSES_B
246: SET
247: CREATION_DATE = ASO_UTILITY_PVT.decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
248: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
249: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
315: PROCEDURE Delete_Row(
316: p_QUOTE_STATUS_ID NUMBER)
317: IS
318: BEGIN
319: DELETE FROM ASO_QUOTE_STATUSES_B
320: WHERE QUOTE_STATUS_ID = p_QUOTE_STATUS_ID;
321: If (SQL%NOTFOUND) then
322: RAISE NO_DATA_FOUND;
323: End If;
373:
374: IS
375: CURSOR C IS
376: SELECT *
377: FROM ASO_QUOTE_STATUSES_B
378: WHERE QUOTE_STATUS_ID = p_QUOTE_STATUS_ID
379: FOR UPDATE of QUOTE_STATUS_ID NOWAIT;
380: Recinfo C%ROWTYPE;
381:
524: begin
525: delete from ASO_QUOTE_STATUSES_TL T
526: where not exists
527: (select NULL
528: from ASO_QUOTE_STATUSES_B B
529: where B.QUOTE_STATUS_ID = T.QUOTE_STATUS_ID
530: );
531:
532: update ASO_QUOTE_STATUSES_TL T set (
639: user_id number := 0;
640: row_id varchar2(64);
641: lx_quote_id number;
642: l_quote_status_id number;
643: CURSOR C IS SELECT ASO_QUOTE_STATUSES_B_S.nextval FROM dual;
644: CURSOR C2 IS SELECT QUOTE_STATUS_ID FROM ASO_QUOTE_STATUSES_VL
645: WHERE STATUS_CODE= X_STATUS_CODE;
646:
647: begin