DBA Data[Home] [Help]

APPS.PO_NEGOTIATIONS_SV1 dependencies on PON_BID_BACKING_REQUISITIONS

Line 3804: DELETE FROM pon_bid_backing_requisitions

3800: WHERE auction_header_id = p_auction_header_id
3801: AND line_number = p_auction_line_number
3802: AND requisition_line_id = p_requisition_line_id;
3803: else
3804: DELETE FROM pon_bid_backing_requisitions
3805: WHERE auction_header_id = p_auction_header_id
3806: AND auction_line_number = p_auction_line_number
3807: and bid_number = p_bid_number
3808: and bid_line_number = p_bid_line_number

Line 3851: FROM pon_bid_backing_requisitions pbr

3847: last_updated_by = FND_GLOBAL.USER_ID,
3848: last_update_login = FND_GLOBAL.LOGIN_ID
3849: WHERE auction_header_id = p_auction_header_id
3850: AND NOT EXISTS (SELECT requisition_line_id
3851: FROM pon_bid_backing_requisitions pbr
3852: WHERE auction_header_id = p_auction_header_id
3853: AND prl.requisition_line_id = pbr.requisition_line_id
3854: GROUP BY requisition_line_id )
3855: RETURNING requisition_line_id BULK COLLECT INTO l_req_line_ids;