1 PACKAGE MSD_SCE_RECEIVE_FORECAST_PKG AS
2 /* $Header: msdxrcfs.pls 120.1.12000000.1 2007/01/16 18:32:54 appldev ship $ */
3
4 /* PL/SQL table types */
5 TYPE srInstIdList IS TABLE OF msc_trading_partners.sr_instance_id%TYPE;
6 TYPE srLevelPkList IS TABLE OF msd_level_values.sr_level_pk%TYPE;
7 TYPE levelPkList IS TABLE OF msd_level_values.level_pk%TYPE;
8 TYPE levelIdList IS TABLE OF msd_level_values.level_id%TYPE;
9 TYPE levelValList IS TABLE OF msd_level_values.level_value%TYPE;
10 TYPE itemUomList IS TABLE OF msc_system_items.uom_code%TYPE;
11 TYPE fndMeaningList IS TABLE OF fnd_lookup_values.meaning%TYPE;
12 TYPE plannerCodeList IS TABLE OF msc_system_items.planner_code%TYPE;
13 TYPE numberList IS TABLE OF Number;
14 TYPE dateList IS TABLE OF Date;
15
16 PROCEDURE receive_customer_forecast (
17 p_errbuf out NOCOPY varchar2,
18 p_retcode out NOCOPY varchar2,
19 p_designator in varchar2,
20 p_order_type in number,
21 p_org_code in varchar2,
22 p_planner_code in varchar2,
23 -- p_abc_class in varchar2,
24 p_item_id in number,
25 p_customer_id in number,
26 p_customer_site_id in number default null,
27 p_horizon_start in varchar2,
28 p_horizon_days in number
29 );
30
31 PROCEDURE delete_old_forecast (
32 p_sr_instance_id in number,
33 p_cs_definition_id in number,
34 p_designator in varchar2,
35 p_org_id in number,
36 p_item_id in number, --Bug 4710643
37 p_customer_id in number, --Bug 4710643
38 p_customer_site_id in number, --Bug 4710643
39 l_horizon_start in date,
40 l_horizon_end in date,
41 p_new_fresh_num in number
42 );
43
44 FUNCTION get_sr_tp_site_id(
45 p_customer_site_id in number,
46 p_sr_instance_id in number
47 ) return number;
48
49 FUNCTION get_intrasit_lead_time(
50 p_from_instance_id in number,
51 p_from_organization_id in number,
52 p_to_location_id in number
53 ) return number;
54
55
56 END MSD_SCE_RECEIVE_FORECAST_PKG;