1775:
1776: CURSOR C_LOCK(P_QUOTE_HEADER_ID NUMBER, P_QUOTE_STATUS_ID NUMBER) IS
1777: SELECT QUOTE_HEADER_ID,
1778: QUOTE_STATUS_ID
1779: FROM ASO_QUOTE_HEADERS_ALL
1780: WHERE QUOTE_HEADER_ID = P_QUOTE_HEADER_ID
1781: AND QUOTE_STATUS_ID = P_QUOTE_STATUS_ID
1782: FOR UPDATE OF QUOTE_STATUS_ID NOWAIT;
1783:
2050: If P_Qte_Rec.QUOTE_HEADER_ID is not null then
2051:
2052: SELECT QUOTE_HEADER_ID, QUOTE_STATUS_ID
2053: INTO L_QUOTE_HEADER_ID, L_QUOTE_STATUS_ID
2054: FROM ASO_QUOTE_HEADERS_ALL
2055: WHERE QUOTE_HEADER_ID = P_Qte_Rec.QUOTE_HEADER_ID
2056: and QUOTE_STATUS_ID = P_Qte_Rec.QUOTE_STATUS_ID
2057: FOR UPDATE OF QUOTE_STATUS_ID NOWAIT;
2058: