APPS.PO_MOD_UTIL_PVT dependencies on PON_AUCTION_HEADERS_ALL

Line 293: UPDATE pon_auction_headers_all

289: l_auction_header_id := p_doc_id;
290:
291: -- The following code is invoked if change description is generated
292: IF(p_changeDescGenerated = 'Y') THEN
293: UPDATE pon_auction_headers_all
294: SET CHANGEDESCRIPTION_DATA = p_changedescription,
295: CD_EDITBYUSER_FLAG = p_editbyuserflag,
296: CD_GENERATED_DATE = SYSDATE,
297: CD_GENERATED_FLAG = p_changeDescGenerated,

Line 303: UPDATE pon_auction_headers_all

299: WHERE auction_header_id=l_auction_header_id;
300: END IF;
301: -- The following code is invoked if change description is saved
302: IF(p_changeDescGenerated = 'N') THEN
303: UPDATE pon_auction_headers_all
304: SET CHANGEDESCRIPTION_DATA = p_changedescription,
305: CD_EDITBYUSER_FLAG = p_editbyuserflag
306: WHERE auction_header_id=l_auction_header_id;
307: END IF;

Line 393: FROM pon_auction_headers_all WHERE auction_header_id = l_auction_header_id;

389: l_auction_header_id := p_doc_id;
390:
391: SELECT AMENDUPDATED_AFTERCDGENERATED
392: INTO l_isAmendupdated
393: FROM pon_auction_headers_all WHERE auction_header_id = l_auction_header_id;
394:
395: -- Bug 9868103 - SGD Issue fix
396: -- Fetch the value from the column amendupdated_aftercdgenerated, if value exists
397: -- else compare the last update of the document with change description

Line 406: FROM pon_auction_headers_all

402: RETURN l_isAmendupdated;
403: ELSE
404: SELECT Count(*)
405: INTO l_count
406: FROM pon_auction_headers_all
407: WHERE auction_header_id = l_auction_header_id
408: AND CD_GENERATED_DATE IS NOT NULL
409: AND last_update_date > CD_GENERATED_DATE;
410:

Line 436: FROM pon_auction_headers_all WHERE AUCTION_HEADER_ID = p_auction_hdr_id;

432: BEGIN
433:
434: SELECT AUCTION_HEADER_ID_PREV_AMEND
435: INTO l_prv_auction_header_id
436: FROM pon_auction_headers_all WHERE AUCTION_HEADER_ID = p_auction_hdr_id;
437:
438: RETURN l_prv_auction_header_id;
439:
440: EXCEPTION