[Home] [Help]
596: paip.auction_header_id = paa.auction_header_id AND
597: paip.line_number = paa.bid_line_number AND
598: paip.order_type_lookup_code IN ('AMOUNT', 'QUANTITY')
599: GROUP BY paa.orig_req_line_id
600: HAVING SUM (nvl(paa.allocated_qty,0)) > max(prlsv.requisition_quantity) -- Clin Slin- Will work for info lines. SELECT Max(NULL) FROM dual gives null and comparision of null will gives false
601: AND COUNT(distinct bid_number) > 1;
602:
603: -- The following cursor is to select line related info to be printed in the
604: -- Allocation Failure notification, if line fails to be auto-allocated.
1621: --check if the negotiation has requistion based line
1622: BEGIN
1623: SELECT 'REQUISITION'
1624: INTO x_requistion_based
1625: FROM DUAL
1626: WHERE EXISTS(
1627: SELECT '1'
1628: FROM pon_auction_item_prices_all
1629: WHERE auction_header_id = p_auction_header_id
1925: , pbip.recoupment_rate_percent
1926: , pbip.progress_pymt_rate_percent
1927: , pbip.retainage_rate_percent
1928: , pbip.bid_curr_max_retainage_amt
1929: , decode(pbip.has_bid_payments_flag, 'Y', decode((select 1 from dual where exists
1930: ( select 1 from pon_bid_payments_shipments where
1931: auction_header_id = pbip.auction_header_id and
1932: bid_number= pbip.bid_number and bid_line_number=pbip.line_number
1933: and bid_currency_price <> 0
2073:
2074:
2075: SELECT po_headers_interface_s.nextval
2076: INTO x_interface_header_id
2077: FROM dual;
2078:
2079: OPEN headerLevelInfo;
2080: FETCH headerLevelInfo
2081: INTO x_pdoi_header;
2972: , pbip.recoupment_rate_percent
2973: , pbip.progress_pymt_rate_percent
2974: , pbip.retainage_rate_percent
2975: , pbip.Bid_curr_max_retainage_amt
2976: , decode(pbip.has_bid_payments_flag, 'Y', decode((select 1 from dual where exists
2977: ( select 1 from pon_bid_payments_shipments where
2978: auction_header_id = pbip.auction_header_id and
2979: bid_number= pbip.bid_number and bid_line_number=pbip.line_number
2980: and bid_currency_price <> 0
4272: l_cur_interface_line_id := descriptor.interface_line_id;
4273:
4274: select po_attr_values_interface_s.nextval
4275: into l_cur_attr_values_id
4276: from dual;
4277:
4278: select po_attr_values_tlp_interface_s.nextval
4279: into l_cur_attr_values_tlp_id
4280: from dual;
4276: from dual;
4277:
4278: select po_attr_values_tlp_interface_s.nextval
4279: into l_cur_attr_values_tlp_id
4280: from dual;
4281:
4282: l_cur_item_description := descriptor.item_description;
4283: l_cur_ip_category_id := descriptor.ip_category_id;
4284: l_cur_item_id := descriptor.item_id;
4926: /* Get the unique sequence to make sure item key will be unique */
4927:
4928: SELECT to_char(PO_WF_ITEMKEY_S.NEXTVAL)
4929: INTO x_seq_for_item_key
4930: FROM dual;
4931:
4932: SELECT employee_id
4933: INTO x_preparer_id
4934: FROM fnd_user
5591: --check if the negotiation has requistion based line
5592: BEGIN
5593: SELECT 'REQUISITION'
5594: INTO x_requistion_based
5595: FROM DUAL
5596: WHERE EXISTS(
5597: SELECT '1'
5598: FROM pon_auction_item_prices_all
5599: WHERE auction_header_id = p_auction_header_id
5880: -- Get next value in sequence for itemkey
5881:
5882: SELECT pon_auction_wf_createpo_s.nextval
5883: INTO x_sequence
5884: FROM dual;
5885:
5886: x_itemkey := (to_char(p_auction_header_id)||'-'||to_char(x_sequence));
5887:
5888: -- update pon_auction_headers_all.wf_poncompl_current_round by incrementing by one