DBA Data[Home] [Help]

APPS.ASO_QUOTE_STATUS_PKG dependencies on DUAL

Line 62: CURSOR C IS SELECT ASO_QUOTE_STATUSES_B_S.nextval FROM sys.dual;

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;

Line 643: CURSOR C IS SELECT ASO_QUOTE_STATUSES_B_S.nextval FROM dual;

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