1 PACKAGE CSP_PLAN_DETAILS_PKG AUTHID CURRENT_USER AS
2 /* $Header: csptplds.pls 120.8 2007/12/09 20:38:51 hhaugeru ship $ */
3
4 -- Start of comments
5 --
6 -- API name : create_pick
7 -- Type : Type of API (Eg. Public, simple entity)
8 -- Purpose : This API creates picklist headers and lines for spares.
9 -- It calls the auto_detail API of Oracle Inventory which
10 -- creates pick based on the picking rules
11 --
12 -- Modification History
13 -- Date Userid Comments
14 -- --------- ------ ------------------------------------------
15 -- 12/27/99 phegde Created
16 --
17 -- Note :
18 -- End of comments
19
20 procedure order_automation;
21
22 procedure main(errbuf out nocopy varchar2,
23 retcode out nocopy number,
24 p_organization_id in number default null,
25 p_save_system_plan in varchar2 default 'N',
26 p_save_planner_plan in varchar2 default 'N',
27 p_purge_saved_plans in number default 0,
28 p_inventory_item_id in number default null,
29 p_forecast_rule_id in number default null,
30 p_forecast_periods in number default null,
31 p_period_size in number default null);
32
33 procedure regenerate(
34 p_organization_id in number default null,
35 p_inventory_item_id in number default null,
36 p_forecast_rule_id in number default null,
37 p_forecast_periods in number default null,
38 p_period_size in number default null);
39
40 procedure current_onhand(
41 p_organization_id in number default null,
42 p_inventory_item_id in number default null);
43
44 procedure reorders(
45 p_organization_id in number default null,
46 p_inventory_item_id in number default null);
47
48 procedure copy_plan_history(
49 p_organization_id in number,
50 p_inventory_item_id in number,
51 p_history_date in date);
52 end;