[Home] [Help]
403: --If Solicitation has lines with linked PR's then copy these ref also
404: IF (PON_CLM_UTIL_PKG.get_line_structure_enabled(p_auction_header_id => p_auction_header_id_prev_doc) = 'Y') THEN
405: BEGIN
406: SELECT 'Y' INTO l_back_req_exists
407: FROM pon_backing_requisitions
408: WHERE auction_header_id = p_auction_header_id_prev_doc
409: AND ROWNUM = 1;
410: EXCEPTION
411: WHEN No_Data_Found THEN
414: END IF;
415:
416: -- when saving the document for the first time...
417: -- change the status of the previous round document
418: -- copy negotiation references in our tables (pon_backing_requisitions)
419:
420:
421: if (p_is_new = 'Y') then
422:
1441: l_prev_auction_header_id pon_auction_headers_all.auction_header_id%TYPE;
1442:
1443: --Line Type and STructute Changes Project
1444: CURSOR c_has_linked_pr_refs IS
1445: SELECT Count(*) FROM pon_backing_requisitions
1446: WHERE auction_header_id = p_auction_header_id;
1447:
1448: l_linked_pr_refs_count NUMBER;
1449: l_return_status VARCHAR2(1);
1502: BEGIN
1503:
1504: UPDATE PO_REQUISITION_LINES_ALL
1505: SET AUCTION_DISPLAY_NUMBER = p_document_number
1506: WHERE REQUISITION_LINE_ID IN (SELECT REQUISITION_LINE_ID FROM PON_BACKING_REQUISITIONS WHERE AUCTION_HEADER_ID = p_auction_header_id)
1507: AND AUCTION_HEADER_ID = p_auction_header_id;
1508:
1509: EXCEPTION
1510: WHEN OTHERS THEN