APPS.PON_AUCTION_PKG dependencies on PO_REQUISITION_LINES_ALL

Line 9701: l_requisition_line_id po_requisition_lines_all.requisition_line_id%TYPE;

9697:
9698: l_line_number number;
9699: l_amendment_flag pon_auction_headers_all.amendment_flag%TYPE;
9700: l_auction_header_id pon_auction_headers_all.auction_header_id%TYPE;
9701: l_requisition_line_id po_requisition_lines_all.requisition_line_id%TYPE;
9702:
9703: CURSOR deletedItems IS
9704: SELECT LINE_NUMBER
9705: FROM PON_AUCTION_ITEM_PRICES_ALL

Line 9801: SELECT Nvl((SELECT REQUISITION_LINE_ID FROM po_requisition_lines_all

9797: FOR rec IN deletedItems LOOP
9798: BEGIN
9799: /* check whether the delted line is Clin or Slin/Option */
9800:
9801: SELECT Nvl((SELECT REQUISITION_LINE_ID FROM po_requisition_lines_all
9802: WHERE auction_header_id = x_old_negotiation_id
9803: AND auction_line_number = rec.line_number
9804: AND group_line_id IS NULL
9805: AND clm_base_line_num IS NULL),-1) INTO l_requisition_line_id FROM dual ;

Line 9811: UPDATE po_requisition_lines_all prla

9807:
9808: /* if Line is Clin then make complete structure to return the pool */
9809:
9810: IF(l_requisition_line_id <> -1)THEN
9811: UPDATE po_requisition_lines_all prla
9812: SET reqs_in_pool_flag = 'Y',
9813: at_sourcing_flag = NULL,
9814: auction_header_id = null,
9815: auction_display_number = null,

Line 9854: /* bug#10295849: Added the code to delete the negotiation references in po_requisition_lines_all table, if the requisition lines are deleted in the solicitation */

9850: X_ERROR_CODE => x_error_code);
9851:
9852:
9853:
9854: /* bug#10295849: Added the code to delete the negotiation references in po_requisition_lines_all table, if the requisition lines are deleted in the solicitation */
9855: IF (x_error_code = FND_API.G_RET_STS_SUCCESS) THEN
9856: update po_requisition_lines_all
9857: set auction_header_id = null,
9858: auction_display_number = null,

Line 9856: update po_requisition_lines_all

9852:
9853:
9854: /* bug#10295849: Added the code to delete the negotiation references in po_requisition_lines_all table, if the requisition lines are deleted in the solicitation */
9855: IF (x_error_code = FND_API.G_RET_STS_SUCCESS) THEN
9856: update po_requisition_lines_all
9857: set auction_header_id = null,
9858: auction_display_number = null,
9859: auction_line_number = null
9860: where auction_header_id = x_old_negotiation_id;

Line 17801: FROM po_requisition_lines_all l, po_requisition_headers_all h

17797: FOR j in 1..p_requisition_line_id.COUNT LOOP
17798:
17799: SELECT h.requisition_header_id, h.segment1
17800: INTO l_req_header_id, l_req_number
17801: FROM po_requisition_lines_all l, po_requisition_headers_all h
17802: WHERE requisition_line_id = p_requisition_line_id(j)
17803: and h.requisition_header_id = l.requisition_header_id;
17804:
17805: BEGIN