APPS.PON_ATTR_MAPPING dependencies on PON_AUCTION_HEADERS_ALL

Line 234: l_document_number pon_auction_headers_all.document_number%TYPE;

230: , x_err_msg OUT NOCOPY VARCHAR2
231: ) AS
232:
233: l_auction_title VARCHAR2(80) := NULL;
234: l_document_number pon_auction_headers_all.document_number%TYPE;
235:
236: l_extension_id NUMBER := NULL;
237: l_mode VARCHAR2(2000) := NULL;
238: l_return_status VARCHAR2(1) := NULL;

Line 364: FROM PON_AUCTION_HEADERS_ALL

360: , l_intgr_hdr_flag
361: , l_intgr_cat_line_flag
362: , l_intgr_item_line_flag
363: , l_hdr_enable_weights_flag
364: FROM PON_AUCTION_HEADERS_ALL
365: WHERE AUCTION_HEADER_ID = p_auction_header_id;
366:
367: /* PARTY ID, SUPPLIER ID, SUPPLIER SITE ID IF ANY */
368: SELECT HZ1.PARTY_NAME

Line 990: FROM PON_AUCTION_HEADERS_ALL

986:
987: BEGIN
988: SELECT INTGR_CAT_LINE_ASL_FLAG
989: INTO l_intgr_cat_line_asl
990: FROM PON_AUCTION_HEADERS_ALL
991: WHERE AUCTION_HEADER_ID = p_auction_header_id;
992:
993: IF (l_intgr_cat_line_asl <> 'Y') THEN
994: RETURN;

Line 1154: , PON_AUCTION_HEADERS_ALL AUCTION

1150: IS
1151: SELECT BID.AUCTION_HEADER_ID
1152: , BID.BID_NUMBER
1153: FROM PON_BID_HEADERS BID
1154: , PON_AUCTION_HEADERS_ALL AUCTION
1155: WHERE BID.VENDOR_ID = p_v_id
1156: AND BID.AUCTION_HEADER_ID = AUCTION.AUCTION_HEADER_ID
1157: AND AUCTION.AUCTION_STATUS = 'AUCTION_CLOSED'
1158: ORDER BY AUCTION_HEADER_ID,