APPS.PON_LARGE_AUCTION_UTIL_PKG dependencies on PON_AUCTION_HEADERS_ALL

Line 140: FROM pon_auction_headers_all ah

136:
137: -- Determine the maximum line number for the negotiation
138: SELECT ah.max_internal_line_num
139: INTO l_max_line_number
140: FROM pon_auction_headers_all ah
141: WHERE ah.auction_header_id = p_auc_header_id;
142:
143: -- Define the initial batch range (line numbers are indexed from 1)
144: l_batch_start := 1;

Line 449: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE

445: -- the auction is pending or completed
446: -- ======================================================================
447: FUNCTION is_auction_request_pending
448: (
449: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE
450: ) RETURN VARCHAR2 IS
451: l_request_id pon_auction_headers_all.request_id%TYPE;
452: BEGIN
453:

Line 451: l_request_id pon_auction_headers_all.request_id%TYPE;

447: FUNCTION is_auction_request_pending
448: (
449: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE
450: ) RETURN VARCHAR2 IS
451: l_request_id pon_auction_headers_all.request_id%TYPE;
452: BEGIN
453:
454: SELECT request_id
455: INTO l_request_id

Line 456: FROM pon_auction_headers_all

452: BEGIN
453:
454: SELECT request_id
455: INTO l_request_id
456: FROM pon_auction_headers_all
457: WHERE auction_header_id = p_auc_header_id;
458:
459: IF (l_request_id IS null) THEN
460: RETURN 'N';

Line 565: pon_auction_headers_all ah

561:
562: SELECT '_' || dt.message_suffix
563: INTO l_suffix
564: FROM pon_auc_doctypes dt,
565: pon_auction_headers_all ah
566: WHERE dt.doctype_id = ah.doctype_id
567: AND ah.auction_header_id = p_auction_id
568: AND rownum =1;
569:

Line 628: UPDATE PON_AUCTION_HEADERS_ALL

624:
625:
626: IF( IS_AUCTION_NOT_UPDATED( p_auction_id , p_last_update_date)) THEN
627:
628: UPDATE PON_AUCTION_HEADERS_ALL
629: SET
630: REQUEST_ID = p_request_id,
631: REQUESTED_BY = p_requested_by,
632: REQUEST_DATE = p_request_date,

Line 709: FROM pon_auction_headers_all

705: l_return_value := TRUE;
706:
707: SELECT last_update_date
708: INTO l_current_update_date
709: FROM pon_auction_headers_all
710: WHERE auction_header_id = p_auction_header_id;
711:
712: IF (l_current_update_date = p_last_update_date) THEN
713: l_return_value := TRUE;

Line 766: from pon_auction_headers_all

762: */
763:
764: delete from pon_auction_summary
765: where auction_id in (select auction_header_id
766: from pon_auction_headers_all
767: where last_update_date < sysdate - 7);
768:
769: retCode := '0';
770: errbuf := 'PURGE_INTERFACE_ERRORS_CP exited successfully';

Line 805: FROM pon_auction_headers_all

801: BEGIN
802:
803: SELECT number_of_lines, trading_partner_id
804: INTO v_num_lines, v_tpid
805: FROM pon_auction_headers_all
806: WHERE auction_header_id = p_auction_header_id;
807:
808: BEGIN
809: SELECT to_number(preference_value)

Line 842: FROM pon_auction_headers_all

838: BEGIN
839:
840: SELECT large_neg_enabled_flag
841: INTO v_large_neg_flag
842: FROM pon_auction_headers_all
843: WHERE auction_header_id = p_auction_header_id;
844:
845: IF (v_large_neg_flag = 'Y') THEN
846: RETURN TRUE;

Line 867: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE

863: -- It checks the complete flag
864: -- ======================================================================
865: FUNCTION IS_AUCTION_COMPLETE
866: (
867: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE
868: ) RETURN VARCHAR2
869: IS
870: v_complete_flag VARCHAR2(1) := 'N';
871: BEGIN

Line 875: FROM pon_auction_headers_all

871: BEGIN
872:
873: SELECT nvl(complete_flag,'Y')
874: INTO v_complete_flag
875: FROM pon_auction_headers_all
876: WHERE auction_header_id = p_auc_header_id;
877:
878: RETURN v_complete_flag;
879:

Line 895: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE

891: -- is completed or not
892: -- ======================================================================
893: FUNCTION IS_REQUEST_COMPLETE
894: (
895: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE
896: ) RETURN VARCHAR2
897: IS
898: v_request_complete VARCHAR2(1) := 'Y';
899: l_request_id NUMBER;

Line 909: FROM PON_AUCTION_HEADERS_ALL

905: l_success BOOLEAN;
906:
907: BEGIN
908: SELECT REQUEST_ID INTO l_request_id
909: FROM PON_AUCTION_HEADERS_ALL
910: WHERE AUCTION_HEADER_ID = p_auc_header_id;
911:
912: IF (l_request_id IS NULL) THEN
913: v_request_complete := 'Y';

Line 997: from pon_auction_headers_all

993:
994:
995: -- Delete contract terms
996: select conterms_exist_flag into l_conterms_exist_flag
997: from pon_auction_headers_all
998: where auction_header_id = p_auc_header_id;
999:
1000: if ( ( PON_CONTERMS_UTL_GRP.is_contracts_installed()= FND_API.G_TRUE ) and
1001: l_conterms_exist_flag = 'Y' ) then