[Home] [Help]
2505: END IF;
2506: BEGIN
2507: SELECT MAX(sequence)
2508: INTO l_max_sequence
2509: FROM PON_BIDDING_PARTIES
2510: WHERE AUCTION_HEADER_ID = P_DOCUMENT_NUMBER;
2511: EXCEPTION
2512: WHEN OTHERS THEN
2513: NULL;
2512: WHEN OTHERS THEN
2513: NULL;
2514: END;
2515: INSERT
2516: INTO PON_BIDDING_PARTIES
2517: (
2518: AUCTION_HEADER_ID,
2519: List_ID,
2520: LAST_UPDATE_DATE,