APPS.MSC_SUPPLIER_HORIZONTAL_PLAN dependencies on MSC_SUPPLIER_HORIZONTAL_PLAN

Line 1: PACKAGE BODY msc_supplier_horizontal_plan AS

1: PACKAGE BODY msc_supplier_horizontal_plan AS
2: /* $Header: MSCHSPLB.pls 120.13 2011/12/15 23:53:44 cnazarma ship $ */
3:
4: SYS_YES CONSTANT INTEGER := 1;
5: SYS_NO CONSTANT INTEGER := 2;

Line 911: -- ',msc_get_name.supplier(supplier_id) || msc_supplier_horizontal_plan.get_order_type_label('||l_supplier_site || '), '||

907: 'supplier_id, '||
908: 'supplier_site_id, '||
909: NODE_ITEM_SUPPLIER ||' , ' ||
910: l_base_item|| -- base_ato in case of config
911: -- ',msc_get_name.supplier(supplier_id) || msc_supplier_horizontal_plan.get_order_type_label('||l_supplier_site || '), '||
912: ',msc_get_name.supplier(supplier_id) || msc_supplier_horizontal_plan.get_order_type_label(supplier_site_id ), '||
913: 'msc_get_name.item_name(' ||l_base_item|| ' ,null,null,null) '||
914: 'FROM msc_item_suppliers '||
915: 'WHERE inventory_item_id in ('||l_item_list||') ' ||

Line 912: ',msc_get_name.supplier(supplier_id) || msc_supplier_horizontal_plan.get_order_type_label(supplier_site_id ), '||

908: 'supplier_site_id, '||
909: NODE_ITEM_SUPPLIER ||' , ' ||
910: l_base_item|| -- base_ato in case of config
911: -- ',msc_get_name.supplier(supplier_id) || msc_supplier_horizontal_plan.get_order_type_label('||l_supplier_site || '), '||
912: ',msc_get_name.supplier(supplier_id) || msc_supplier_horizontal_plan.get_order_type_label(supplier_site_id ), '||
913: 'msc_get_name.item_name(' ||l_base_item|| ' ,null,null,null) '||
914: 'FROM msc_item_suppliers '||
915: 'WHERE inventory_item_id in ('||l_item_list||') ' ||
916: 'AND supplier_id in ('||p_supplier_list||') ' ||

Line 973: END msc_supplier_horizontal_plan;

969: FND_MESSAGE.set_name('MSC','MSC_Order_date_type');
970: return '('||FND_MESSAGE.get||': '||l_shipping_control||')';
971: END;
972:
973: END msc_supplier_horizontal_plan;