APPS.PON_EXHIBITS_PKG dependencies on PON_AUCTION_HEADERS_ALL

Line 41: FROM pon_auction_headers_all

37:
38: SELECT created_by,last_updated_by
39: INTO
40: p_CREATED_BY,p_LAST_UPDATED_BY
41: FROM pon_auction_headers_all
42: WHERE auction_header_id=p_auction_header_id;
43:
44: begin
45:

Line 483: UPDATE PON_AUCTION_HEADERS_ALL

479: INTO P_NO_OF_LINES
480: FROM pon_auction_item_prices_all
481: WHERE auction_header_id = p_source_auction_header_id;
482:
483: UPDATE PON_AUCTION_HEADERS_ALL
484: SET NUMBER_OF_LINES = P_NO_OF_LINES,
485: LAST_LINE_NUMBER = P_LINE_NUMBER
486: WHERE AUCTION_HEADER_ID = p_source_auction_header_id;
487:

Line 554: UPDATE PON_AUCTION_HEADERS_ALL

550: INTO P_NO_OF_LINES
551: FROM pon_auction_item_prices_all
552: WHERE auction_header_id = p_source_auction_header_id;
553:
554: UPDATE PON_AUCTION_HEADERS_ALL
555: SET NUMBER_OF_LINES = P_NO_OF_LINES,
556: LAST_LINE_NUMBER = P_LINE_NUMBER
557: WHERE AUCTION_HEADER_ID = p_source_auction_header_id;
558:

Line 620: l_org_id pon_auction_headers_all.org_id%TYPE;

616:
617: FUNCTION IS_EXHIBITS_ENABLED_FOR_AUC(p_auction_header_id NUMBER)
618: RETURN VARCHAR2 IS
619:
620: l_org_id pon_auction_headers_all.org_id%TYPE;
621: l_doctype_id pon_auction_headers_all.doctype_id%TYPE;
622:
623: BEGIN
624: SELECT org_id, doctype_id

Line 621: l_doctype_id pon_auction_headers_all.doctype_id%TYPE;

617: FUNCTION IS_EXHIBITS_ENABLED_FOR_AUC(p_auction_header_id NUMBER)
618: RETURN VARCHAR2 IS
619:
620: l_org_id pon_auction_headers_all.org_id%TYPE;
621: l_doctype_id pon_auction_headers_all.doctype_id%TYPE;
622:
623: BEGIN
624: SELECT org_id, doctype_id
625: INTO l_org_id,l_doctype_id

Line 626: FROM pon_auction_headers_all

622:
623: BEGIN
624: SELECT org_id, doctype_id
625: INTO l_org_id,l_doctype_id
626: FROM pon_auction_headers_all
627: WHERE auction_header_id = p_auction_header_id;
628:
629: RETURN IS_EXHIBITS_ENABLED(l_org_id, l_doctype_id);
630: