APPS.PON_SOURCING_OPENAPI_GRP dependencies on PO_LINE_TYPES_B

Line 201: v_order_type_lookup_code po_line_types_b.order_type_lookup_code%TYPE;

197: v_trading_partner_contact_id pon_bidding_parties.trading_partner_contact_id%TYPE;
198: v_trading_partner_contact_name pon_bidding_parties.trading_partner_contact_name%TYPE;
199: v_blanket_bidders_curr VARCHAR2(1) := 'N';
200: v_set_as_bidders_curr VARCHAR2(1) := 'N';
201: v_order_type_lookup_code po_line_types_b.order_type_lookup_code%TYPE;
202:
203: -- The v_bidders_currency_rate multiplier is initially defaulted to 1.
204: -- If the auction is in functional currency multiplying with this will
205: -- have no effect.

Line 376: FROM pon_auc_items_interface paii, po_line_types_b polt

372: -- case the bidders currency gets set as a allowable foreigh currency for bidding.
373: IF (g_header_rec.allow_other_bid_currency_flag = 'Y') THEN
374: -- if there are amount based lines, don't allow other currencies.
375: SELECT count(*) INTO v_amount_based_lines
376: FROM pon_auc_items_interface paii, po_line_types_b polt
377: WHERE paii.interface_auction_header_id = p_interface_id
378: AND paii.line_type_id = polt.line_type_id
379: AND polt.order_type_lookup_code = 'AMOUNT';
380:

Line 1051: FROM po_line_types_b polt

1047:
1048: UPDATE pon_auc_items_interface paii
1049: SET paii.order_type_lookup_code =
1050: (SELECT polt.order_type_lookup_code
1051: FROM po_line_types_b polt
1052: WHERE paii.line_type_id = polt.line_type_id)
1053: WHERE paii.interface_auction_header_id = p_interface_id
1054: AND interface_line_number >= l_batch_start
1055: AND interface_line_number <= l_batch_end;