DBA Data[Home] [Help]

APPS.PON_AUCTION_INTERFACE_PKG dependencies on PO_LINE_TYPES_B

Line 909: v_order_type_lookup_code po_line_types_b.order_type_lookup_code%TYPE;

905: v_quantity pon_auction_item_prices_all.quantity%TYPE;
906: v_uom_code pon_auction_item_prices_all.uom_code%TYPE;
907: v_has_attachments pon_auction_item_prices_all.attachment_flag%TYPE:= 'N';
908: v_multi_org fnd_product_groups.multi_org_flag%TYPE := 'Y';
909: v_order_type_lookup_code po_line_types_b.order_type_lookup_code%TYPE;
910: v_purchase_basis po_line_types_b.purchase_basis%TYPE;
911: v_att_category_id fnd_document_categories.category_id%TYPE;
912: v_contract_type VARCHAR2(25);
913: v_service_based_line VARCHAR2(1);

Line 910: v_purchase_basis po_line_types_b.purchase_basis%TYPE;

906: v_uom_code pon_auction_item_prices_all.uom_code%TYPE;
907: v_has_attachments pon_auction_item_prices_all.attachment_flag%TYPE:= 'N';
908: v_multi_org fnd_product_groups.multi_org_flag%TYPE := 'Y';
909: v_order_type_lookup_code po_line_types_b.order_type_lookup_code%TYPE;
910: v_purchase_basis po_line_types_b.purchase_basis%TYPE;
911: v_att_category_id fnd_document_categories.category_id%TYPE;
912: v_contract_type VARCHAR2(25);
913: v_service_based_line VARCHAR2(1);
914: v_from_ip_catalog VARCHAR2(1);

Line 1021: FROM po_line_types_b

1017: IF (NVL(P_CLM_INFO_FLAG,'N') <> 'Y') THEN -- Clin - Slin Change : check relaxed for CLM info lines
1018: BEGIN
1019: SELECT order_type_lookup_code
1020: INTO v_order_type_lookup_code
1021: FROM po_line_types_b
1022: WHERE P_LINE_TYPE_ID = line_type_id;
1023: EXCEPTION
1024: WHEN no_data_found THEN
1025: P_RESULT := error;

Line 1037: FROM po_line_types_b

1033: IF (NVL(P_CLM_INFO_FLAG,'N') <> 'Y') THEN -- Clin - Slin Change : check relaxed for CLM info lines
1034: BEGIN
1035: SELECT purchase_basis
1036: INTO v_purchase_basis
1037: FROM po_line_types_b
1038: WHERE P_LINE_TYPE_ID = line_type_id;
1039: EXCEPTION
1040: WHEN no_data_found THEN
1041: P_RESULT := error;