DBA Data[Home] [Help]

PACKAGE: APPS.MSC_SUPPLIER_PKG

Source


1 PACKAGE msc_supplier_pkg AS
2 /* $Header: MSCHBSPS.pls 120.3.12010000.2 2008/07/08 20:01:26 pabram ship $ */
3 
4 
5    --function is_plan_constrained (l_daily number,l_weekly number,l_monthly number,l_dailym number,l_weeklym number,l_monthlym number) return number;
6    function supplier_spend_value (p_new_order_quantity number, p_list_price number, p_order_type number) return number;
7    function is_new_buy_order(p_order_type number , p_plan_type number, p_purchasing_enabled_flag number) return number;
8    function is_rescheduled_po(p_order_type number, p_rescheduled_flag number, new_schedule_date date, old_schedule_date date) return number;
9    function is_cancelled_po(p_order_type number, p_disposition_status_type number) return number;
10 
11    procedure populate_details(errbuf out nocopy varchar2, retcode out nocopy number,
12     p_plan_id number, p_plan_run_id number);
13 
14    procedure purge_details(errbuf out nocopy varchar2, retcode out nocopy number,
15     p_plan_id number, p_plan_run_id number);
16 
17     procedure populate_summary(errbuf out nocopy varchar2, retcode out nocopy varchar2,
18         p_plan_id number, p_plan_run_id number);
19 END msc_supplier_pkg;