APPS.PON_AUCTION_INTERFACE_PKG dependencies on PO_LINE_TYPES_B

Line 496: v_order_type_lookup_code po_line_types_b.order_type_lookup_code%TYPE;

492: v_quantity pon_auction_item_prices_all.quantity%TYPE;
493: v_uom_code pon_auction_item_prices_all.uom_code%TYPE;
494: v_has_attachments pon_auction_item_prices_all.attachment_flag%TYPE:= 'N';
495: v_multi_org fnd_product_groups.multi_org_flag%TYPE := 'Y';
496: v_order_type_lookup_code po_line_types_b.order_type_lookup_code%TYPE;
497: v_purchase_basis po_line_types_b.purchase_basis%TYPE;
498: v_att_category_id fnd_document_categories.category_id%TYPE;
499: v_service_based_line VARCHAR2(1);
500: v_from_ip_catalog VARCHAR2(1);

Line 497: v_purchase_basis po_line_types_b.purchase_basis%TYPE;

493: v_uom_code pon_auction_item_prices_all.uom_code%TYPE;
494: v_has_attachments pon_auction_item_prices_all.attachment_flag%TYPE:= 'N';
495: v_multi_org fnd_product_groups.multi_org_flag%TYPE := 'Y';
496: v_order_type_lookup_code po_line_types_b.order_type_lookup_code%TYPE;
497: v_purchase_basis po_line_types_b.purchase_basis%TYPE;
498: v_att_category_id fnd_document_categories.category_id%TYPE;
499: v_service_based_line VARCHAR2(1);
500: v_from_ip_catalog VARCHAR2(1);
501:

Line 546: FROM po_line_types_b

542: v_debug_status := 'ORDER_TYPE_LOOKUP';
543: BEGIN
544: SELECT order_type_lookup_code
545: INTO v_order_type_lookup_code
546: FROM po_line_types_b
547: WHERE P_LINE_TYPE_ID = line_type_id;
548: EXCEPTION
549: WHEN no_data_found THEN
550: P_RESULT := error;

Line 560: FROM po_line_types_b

556: -- Get the purchase basis for this line type
557: BEGIN
558: SELECT purchase_basis
559: INTO v_purchase_basis
560: FROM po_line_types_b
561: WHERE P_LINE_TYPE_ID = line_type_id;
562: EXCEPTION
563: WHEN no_data_found THEN
564: P_RESULT := error;