APPS.MSC_SUPPLIER_PKG dependencies on MSC_SUPPLIER_PKG

Line 1: PACKAGE BODY msc_supplier_pkg AS

1: PACKAGE BODY msc_supplier_pkg AS
2: /* $Header: MSCHBSPB.pls 120.31.12010000.3 2008/09/03 14:42:52 wexia ship $ */
3: SYS_YES CONSTANT INTEGER := 1;
4: SYS_NO CONSTANT INTEGER := 2;
5:

Line 193: sum(msc_supplier_pkg.is_rescheduled_po(ms.order_type, ms.reschedule_flag,

189: 0),
190:
191: decode(nvl(ms.disposition_status_type,1),1,
192: decode(l_plan_constrained,2,ms.new_order_quantity,0),0)))required_qty,
193: sum(msc_supplier_pkg.is_rescheduled_po(ms.order_type, ms.reschedule_flag,
194: ms.new_schedule_date, ms.old_schedule_date)) po_rescheduled_count,
195: sum(decode(ms.order_type, 1, 1, 0)) po_count,
196: sum(msc_supplier_pkg.is_cancelled_po(ms.order_type,
197: ms.disposition_status_type)) po_cancel_count,

Line 196: sum(msc_supplier_pkg.is_cancelled_po(ms.order_type,

192: decode(l_plan_constrained,2,ms.new_order_quantity,0),0)))required_qty,
193: sum(msc_supplier_pkg.is_rescheduled_po(ms.order_type, ms.reschedule_flag,
194: ms.new_schedule_date, ms.old_schedule_date)) po_rescheduled_count,
195: sum(decode(ms.order_type, 1, 1, 0)) po_count,
196: sum(msc_supplier_pkg.is_cancelled_po(ms.order_type,
197: ms.disposition_status_type)) po_cancel_count,
198: sum(msc_supplier_pkg.supplier_spend_value (ms.new_order_quantity,
199: nvl(ms.DELIVERY_PRICE,msi.list_price), ms.order_type)) buy_order_value,
200: sum(msc_supplier_pkg.is_new_buy_order(ms.order_type, l_plan_type, msi.purchasing_enabled_flag)) buy_order_count

Line 198: sum(msc_supplier_pkg.supplier_spend_value (ms.new_order_quantity,

194: ms.new_schedule_date, ms.old_schedule_date)) po_rescheduled_count,
195: sum(decode(ms.order_type, 1, 1, 0)) po_count,
196: sum(msc_supplier_pkg.is_cancelled_po(ms.order_type,
197: ms.disposition_status_type)) po_cancel_count,
198: sum(msc_supplier_pkg.supplier_spend_value (ms.new_order_quantity,
199: nvl(ms.DELIVERY_PRICE,msi.list_price), ms.order_type)) buy_order_value,
200: sum(msc_supplier_pkg.is_new_buy_order(ms.order_type, l_plan_type, msi.purchasing_enabled_flag)) buy_order_count
201: from
202: MSC_SUPPLIES ms,

Line 200: sum(msc_supplier_pkg.is_new_buy_order(ms.order_type, l_plan_type, msi.purchasing_enabled_flag)) buy_order_count

196: sum(msc_supplier_pkg.is_cancelled_po(ms.order_type,
197: ms.disposition_status_type)) po_cancel_count,
198: sum(msc_supplier_pkg.supplier_spend_value (ms.new_order_quantity,
199: nvl(ms.DELIVERY_PRICE,msi.list_price), ms.order_type)) buy_order_value,
200: sum(msc_supplier_pkg.is_new_buy_order(ms.order_type, l_plan_type, msi.purchasing_enabled_flag)) buy_order_count
201: from
202: MSC_SUPPLIES ms,
203: MSC_SYSTEM_ITEMS msi,
204: msc_plans mp,

Line 854: end msc_supplier_pkg;

850: when others then
851: errbuf := msc_phub_util.get_planning_hub_message('MSC_HUB_PURGE_ERROR')||SQLCODE||' -ERROR- '||SQLERRM;
852: retcode := 2;
853: end purge_details;
854: end msc_supplier_pkg;