DBA Data[Home] [Help]

APPS.PON_AUCTION_INTERFACE_PKG dependencies on FND_PRODUCT_GROUPS

Line 54: v_multi_org fnd_product_groups.multi_org_flag%TYPE := 'Y';

50: v_doctype_id pon_auc_doctypes.doctype_id%TYPE;
51: v_transaction_type pon_auc_doctypes.transaction_type%TYPE;
52: v_site_id pon_auction_headers_all.trading_partner_id%TYPE;
53: v_site_name pon_auction_headers_all.trading_partner_name%TYPE;
54: v_multi_org fnd_product_groups.multi_org_flag%TYPE := 'Y';
55: v_price_tiers_indicator pon_auction_headers_all.price_tiers_indicator%type;
56:
57: l_price_break_response pon_auction_headers_all.price_break_response%type;
58:

Line 120: FROM fnd_product_groups;

116: v_debug_status := 'MULTIORG';
117: BEGIN
118: SELECT multi_org_flag
119: INTO v_multi_org
120: FROM fnd_product_groups;
121: EXCEPTION
122: WHEN no_data_found THEN
123: P_RESULT := error;
124: P_ERROR_CODE := 'CREATE_DRAFT:MULTI_ORG_QUERY';

Line 495: v_multi_org fnd_product_groups.multi_org_flag%TYPE := 'Y';

491: v_ip_category_id pon_auction_item_prices_all.ip_category_id%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);

Line 610: FROM fnd_product_groups;

606: v_debug_status := 'MULTIORG';
607: BEGIN
608: SELECT multi_org_flag
609: INTO v_multi_org
610: FROM fnd_product_groups;
611: EXCEPTION
612: WHEN no_data_found THEN
613: P_RESULT := error;
614: P_ERROR_CODE := 'ADD_NEG_LINE:MULTI_ORG_QUERY';