APPS.PON_SOURCING_OPENAPI_GRP dependencies on PO_LINE_TYPES_B

Line 219: v_order_type_lookup_code po_line_types_b.order_type_lookup_code%TYPE;

215: v_trading_partner_contact_id pon_bidding_parties.trading_partner_contact_id%TYPE;
216: v_trading_partner_contact_name pon_bidding_parties.trading_partner_contact_name%TYPE;
217: v_blanket_bidders_curr VARCHAR2(1) := 'N';
218: v_set_as_bidders_curr VARCHAR2(1) := 'N';
219: v_order_type_lookup_code po_line_types_b.order_type_lookup_code%TYPE;
220:
221: -- The v_bidders_currency_rate multiplier is initially defaulted to 1.
222: -- If the auction is in functional currency multiplying with this will
223: -- have no effect.

Line 415: FROM pon_auc_items_interface paii, po_line_types_b polt

411: -- case the bidders currency gets set as a allowable foreigh currency for bidding.
412: IF (g_header_rec.allow_other_bid_currency_flag = 'Y') THEN
413: -- if there are amount based lines, don't allow other currencies.
414: SELECT count(*) INTO v_amount_based_lines
415: FROM pon_auc_items_interface paii, po_line_types_b polt
416: WHERE paii.interface_auction_header_id = p_interface_id
417: AND paii.line_type_id = polt.line_type_id
418: AND polt.order_type_lookup_code = 'AMOUNT';
419:

Line 1300: FROM po_line_types_b polt

1296:
1297: UPDATE pon_auc_items_interface paii
1298: SET paii.order_type_lookup_code =
1299: (SELECT polt.order_type_lookup_code
1300: FROM po_line_types_b polt
1301: WHERE paii.line_type_id = polt.line_type_id)
1302: WHERE paii.interface_auction_header_id = p_interface_id
1303: AND interface_line_number >= l_batch_start
1304: AND interface_line_number <= l_batch_end;