[Home] [Help]
63: v_doctype_id pon_auc_doctypes.doctype_id%TYPE;
64: v_transaction_type pon_auc_doctypes.transaction_type%TYPE;
65: v_site_id pon_auction_headers_all.trading_partner_id%TYPE;
66: v_site_name pon_auction_headers_all.trading_partner_name%TYPE;
67: v_multi_org fnd_product_groups.multi_org_flag%TYPE := 'Y';
68: v_price_tiers_indicator pon_auction_headers_all.price_tiers_indicator%type;
69: l_price_break_response pon_auction_headers_all.price_break_response%type;
70: l_style_name po_doc_style_headers.style_name%TYPE;
71: l_style_description po_doc_style_headers.style_description%TYPE;
158: END IF;
159: -- Is this multiorg?
160: v_debug_status := 'MULTIORG';
161: BEGIN
162: SELECT multi_org_flag INTO v_multi_org FROM fnd_product_groups;
163: EXCEPTION
164: WHEN no_data_found THEN
165: P_RESULT := error;
166: P_ERROR_CODE := 'CREATE_DRAFT:MULTI_ORG_QUERY';
904: v_ip_category_id pon_auction_item_prices_all.ip_category_id%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);
1085: END IF;
1086: -- Is this multiorg?
1087: v_debug_status := 'MULTIORG';
1088: BEGIN
1089: SELECT multi_org_flag INTO v_multi_org FROM fnd_product_groups;
1090: EXCEPTION
1091: WHEN no_data_found THEN
1092: P_RESULT := error;
1093: P_ERROR_CODE := 'ADD_NEG_LINE:MULTI_ORG_QUERY';