1 PACKAGE MSC_X_CP_FLOW AUTHID CURRENT_USER AS
2 /* $Header: MSCXCPFS.pls 115.7 2003/08/05 21:54:49 pdandapa ship $ */
3
4
5 -- This procedure will start the Workflow process to run the SCEM engine
6 PROCEDURE Start_SCEM_Engine_WF;
7
8 -- This procedure will lanuch the SCEM engine
9 PROCEDURE Launch_SCEM_Engine
10 ( itemtype in varchar2
11 , itemkey in varchar2
12 , actid in number
13 , funcmode in varchar2
14 , resultout out nocopy varchar2
15 );
16
17 PROCEDURE Start_DP_Receive_Forecast_WF
18 ( p_customer_id in number
19 , p_horizon_start in date
20 , p_horizon_days in number
21 --, p_recipient_name IN VARCHAR2
22 --, p_responsibility_id IN NUMBER
23 , p_resp_key IN varchar2
24 , p_message_to_tp IN VARCHAR2
25 , p_tp_name IN VARCHAR2
26 );
27
28 PROCEDURE DP_Receive_Forecast
29 ( itemtype in varchar2
30 , itemkey in varchar2
31 , actid in number
32 , funcmode in varchar2
33 , resultout out nocopy varchar2
34 );
35
36 PROCEDURE Receive_Supplier_Capacity_WF
37 ( p_supplier_id IN Number
38 , p_horizon_start_date In date
39 , p_horizon_end_date In date
40 --, p_recipient_name IN VARCHAR2
41 --, p_responsibility_id IN NUMBER
42 , p_resp_key IN varchar2
43 , p_message_to_tp IN VARCHAR2
44 , p_tp_name IN VARCHAR2
45 );
46
47 PROCEDURE Receive_Supplier_Capacity
48 ( itemtype in varchar2
49 , itemkey in varchar2
50 , actid in number
51 , funcmode in varchar2
52 , resultout out nocopy varchar2
53 );
54
55 PROCEDURE Start_ASCP_Engine_WF
56 ( p_constrained_plan_flag IN NUMBER
57 );
58
59 PROCEDURE Launch_ASCP_Engine
60 ( itemtype in varchar2
61 , itemkey in varchar2
62 , actid in number
63 , funcmode in varchar2
64 , resultout out nocopy varchar2
65 );
66
67 FUNCTION auto_scem_mode
68 RETURN NUMBER;
69
70 PROCEDURE Publish_Supply_Commits_WF
71 ( p_plan_id in number
72 );
73
74 PROCEDURE Publish_Supply_Commits
75 ( itemtype in varchar2
76 , itemkey in varchar2
77 , actid in number
78 , funcmode in varchar2
79 , resultout out nocopy varchar2
80 );
81
82 PROCEDURE Publish_Order_Forecast_WF
83 ( p_plan_id in number
84 );
85
86 PROCEDURE Publish_Order_Forecast
87 ( itemtype in varchar2
88 , itemkey in varchar2
89 , actid in number
90 , funcmode in varchar2
91 , resultout out nocopy varchar2
92 );
93
94 -- This procesure prints out debug info.
95 PROCEDURE print_debug_info(
96 p_debug_info IN VARCHAR2
97 );
98
99 -- This procesure prints out message to user
100 PROCEDURE print_user_info(
101 p_user_info IN VARCHAR2
102 );
103
104 END MSC_X_CP_FLOW;