1 PACKAGE mrp_exp_wf AUTHID CURRENT_USER AS
2 /*$Header: MRPEXWFS.pls 115.8 2002/11/22 19:15:23 ichoudhu ship $ */
3
4 PROCEDURE launch_workflow(errbuf OUT NOCOPY VARCHAR2,
5 retcode OUT NOCOPY NUMBER,
6 p_owning_org_id IN NUMBER,
7 p_designator IN VARCHAR2);
8
9 PROCEDURE StartWFProcess ( item_type in varchar2 default null,
10 item_key in varchar2,
11 compile_designator in varchar2,
12 organization_id in number,
13 inventory_item_id in number,
14 exception_type in number,
15 organization_code in varchar2,
16 item_segments in varchar2,
17 exception_type_text in varchar2,
18 project_number in varchar2,
19 to_project_number in varchar2,
20 task_number in varchar2,
21 to_task_number in varchar2,
22 planning_group in varchar2,
23 due_date in date,
24 from_date in date,
25 to_date in date,
26 days_compressed in number,
27 quantity in varchar2,
28 lot_number in varchar2,
29 order_number in varchar2,
30 order_type_code in number,
31 supply_type in varchar2,
32 end_item_segments in varchar2,
33 end_order_number in varchar2,
34 department_line_code in varchar2,
35 resource_code in varchar2,
36 utilization_rate in number,
37 supplier_id in number,
38 supplier_name in varchar2,
39 supplier_site_id in number,
40 supplier_site_code in varchar2,
41 customer_id in number,
42 customer_name in varchar2,
43 workbench_function in varchar2,
44 workflow_process in varchar2 default null);
45
46 PROCEDURE DetermineProceed( itemtype in varchar2,
47 itemkey in varchar2,
48 actid in number,
49 funcmode in varchar2,
50 resultout out NOCOPY varchar2 );
51
52
53 PROCEDURE SelectPlanner( itemtype in varchar2,
54 itemkey in varchar2,
55 actid in number,
56 funcmode in varchar2,
57 resultout out NOCOPY varchar2 );
58
59 PROCEDURE SelectBuyer( itemtype in varchar2,
60 itemkey in varchar2,
61 actid in number,
62 funcmode in varchar2,
63 resultout out NOCOPY varchar2);
64
65 PROCEDURE SelectSupplierCnt( itemtype in varchar2,
66 itemkey in varchar2,
67 actid in number,
68 funcmode in varchar2,
69 resultout out NOCOPY varchar2);
70
71 PROCEDURE SelectSalesRep( itemtype in varchar2,
72 itemkey in varchar2,
73 actid in number,
74 funcmode in varchar2,
75 resultout out NOCOPY varchar2);
76
77 PROCEDURE SelectCustomerCnt( itemtype in varchar2,
78 itemkey in varchar2,
79 actid in number,
80 funcmode in varchar2,
81 resultout out NOCOPY varchar2);
82
83 PROCEDURE SelectTaskMgr( itemtype in varchar2,
84 itemkey in varchar2,
85 actid in number,
86 funcmode in varchar2,
87 resultout out NOCOPY varchar2);
88
89 FUNCTION GetMessageName(p_exception_type in number,
90 p_order_type in number,
91 p_recipient in varchar2) RETURN varchar2;
92
93 PROCEDURE DetermineExceptionType( itemtype in varchar2,
94 itemkey in varchar2,
95 actid in number,
96 funcmode in varchar2,
97 resultout out NOCOPY varchar2);
98
99 PROCEDURE DetermineOrderType( itemtype in varchar2,
100 itemkey in varchar2,
101 actid in number,
102 funcmode in varchar2,
103 resultout out NOCOPY varchar2);
104
105 PROCEDURE Reschedule( itemtype in varchar2,
106 itemkey in varchar2,
107 actid in number,
108 funcmode in varchar2,
109 resultout out NOCOPY varchar2);
110
111 PROCEDURE IsType19( itemtype in varchar2,
112 itemkey in varchar2,
113 actid in number,
114 funcmode in varchar2,
115 resultout out NOCOPY varchar2);
116
117 PROCEDURE DeleteActivities( arg_compile_desig in varchar2,
118 arg_organization_id in number);
119
120 END mrp_exp_wf;