APPS.PON_UNSOL_UTIL_PKG dependencies on PON_BID_ITEM_REFERENCES

Line 24: pon_bid_item_references

20: WHERE auction_header_id = p_auction_header_id;
21:
22: --Delete item references.
23: DELETE FROM
24: pon_bid_item_references
25: WHERE
26: bid_number = p_bid_number AND
27: line_number = p_line_number;
28:

Line 176: pon_bid_item_references

172: WHERE auction_header_id = p_auction_header_id;
173:
174: --Delete item references.
175: DELETE FROM
176: pon_bid_item_references
177: WHERE
178: bid_number = p_bid_number;
179:
180: IF PON_CLM_UTIL_PKG.IS_UDA_ENABLED(l_doctype_id) = 1 THEN

Line 234: (SELECT 1 FROM pon_bid_item_references WHERE bid_number = p_bid_number AND line_number = p_line_number);

230: SELECT 'Y'
231: INTO l_has_ref
232: FROM dual
233: WHERE EXISTS
234: (SELECT 1 FROM pon_bid_item_references WHERE bid_number = p_bid_number AND line_number = p_line_number);
235:
236: RETURN l_has_ref;
237:
238: EXCEPTION

Line 585: INSERT INTO pon_bid_item_references

581: p_user_id IN NUMBER)
582: IS
583:
584: BEGIN
585: INSERT INTO pon_bid_item_references
586: (BID_NUMBER,
587: LINE_NUMBER ,
588: AUCTION_HEADER_ID,
589: AUCTION_LINE_NUMBER,

Line 610: pon_bid_item_references reference

606: SYSDATE,
607: p_user_id,
608: p_user_id
609: FROM
610: pon_bid_item_references reference
611: WHERE reference.bid_number = p_source_bid_num);
612:
613: END COPY_ITEM_REFERENCES;
614:

Line 764: FROM pon_bid_item_references

760:
761: BEGIN
762: SELECT 1
763: INTO l_has_supplier_data
764: FROM pon_bid_item_references
765: WHERE
766: AUCTION_HEADER_ID = p_auction_id
767: AND LINK_DONE_BY = 'SUPPLIER'
768: AND ROWNUM = 1;

Line 787: UPDATE pon_bid_item_references

783: IF(l_has_buyer_data <> 1) THEN
784: BEGIN
785:
786: --Mark all unsol awarded lines as supplier as link_done_by
787: UPDATE pon_bid_item_references
788: SET LINK_DONE_BY = 'SUPPLIER'
789: WHERE AUCTION_HEADER_ID = p_auction_id
790: AND LINE_NUMBER IN
791: (SELECT LINE_NUMBER FROM pon_bid_item_prices

Line 804: INSERT INTO pon_bid_item_references (BID_NUMBER,

800: l_user_id := fnd_global.user_id;
801: l_login_id := fnd_global.login_id;
802:
803: --Create duplicate records of unsol awarded lines with buyer as link_done_by
804: INSERT INTO pon_bid_item_references (BID_NUMBER,
805: LINE_NUMBER,
806: AUCTION_HEADER_ID,
807: AUCTION_LINE_NUMBER,
808: LINK_TYPE,

Line 827: FROM pon_bid_item_references

823: CREATED_BY,
824: sysdate,
825: l_user_id,
826: l_login_id
827: FROM pon_bid_item_references
828: WHERE AUCTION_HEADER_ID = p_auction_id
829: AND LINE_NUMBER IN
830: (SELECT LINE_NUMBER FROM pon_bid_item_prices
831: WHERE AUCTION_HEADER_ID = p_auction_id

Line 887: pon_bid_item_references pbir

883: FROM dual
884: WHERE EXISTS
885: (SELECT 1
886: FROM pon_bid_item_prices pbip,
887: pon_bid_item_references pbir
888: WHERE pbip.auction_header_id = p_auction_header_id
889: AND pbip.auction_line_number = -1
890: AND Nvl(pbip.award_status,'NO') = 'AWARDED'
891: AND pbir.auction_header_id = pbip.auction_header_id