1 PACKAGE msc_x_wfnotify_pkg AUTHID CURRENT_USER AS
2 /*$Header: MSCXNFPS.pls 115.30 2004/04/15 21:47:34 yptang ship $ */
3
4 TYPE NUM_TBL_TYPE IS TABLE OF number;
5 TYPE number_arr IS TABLE OF NUMBER;
6 TYPE date_arr IS TABLE of DATE;
7 TYPE designatorList IS TABLE OF msc_sup_dem_entries.designator%TYPE;
8
9 PROCEDURE Launch_WF (p_errbuf OUT NOCOPY Varchar2,
10 p_retcode OUT NOCOPY Number);
11
12 PROCEDURE wfStart(p_wf_type IN Varchar2,
13 p_wf_key IN Varchar2,
14 p_wf_process IN Varchar2,
15 p_user_performer IN Varchar2,
16 p_user_name IN Varchar2,
17 p_message_name IN Varchar2,
18 p_exception_type In Number,
19 p_exception_type_name IN Varchar2,
20 p_item_id In Number,
21 p_item_name IN Varchar2,
22 p_item_description IN varchar2,
23 p_company_id In Number,
24 p_company_name IN Varchar2,
25 p_company_site_id IN Number,
26 p_company_site_name In varchar2,
27 p_supplier_id IN Number,
28 p_supplier_name IN Varchar2,
29 p_supplier_site_id IN Number,
30 p_supplier_site_name In varchar2,
31 p_supplier_item_name In varchar2,
32 p_customer_id IN Number,
33 p_customer_name IN Varchar2,
34 p_customer_site_id IN Number,
35 p_customer_site_name In Varchar2,
36 p_customer_item_name In varchar2,
37 p_transaction_id1 IN Number,
38 p_transaction_id2 IN Number,
39 p_quantity In Number,
40 p_quantity1 IN Number,
41 p_quantity2 IN Number,
42 p_threshold IN Number,
43 p_lead_time In Number,
44 p_item_min_qty In Number,
45 p_item_max_qty In Number,
46 p_date1 IN Date,
47 p_date2 IN Date,
48 p_date3 IN Date,
49 p_date4 IN Date,
50 p_date5 IN Date,
51 p_exception_basis IN Varchar2,
52 p_order_creation_date1 IN Date,
53 p_order_creation_date2 IN Date,
54 p_order_number IN Varchar2,
55 p_release_number IN Varchar2,
56 p_line_number IN Varchar2,
57 p_end_order_number IN Varchar2,
58 p_end_order_rel_number IN Varchar2,
59 p_end_order_line_number IN Varchar2);
60
61
62 FUNCTION getMessage(p_exception_code in Number) RETURN Varchar2;
63
64 PROCEDURE Launch_Publish_WF (p_errbuf OUT NOCOPY Varchar2,
65 p_retcode OUT NOCOPY Number,
66 p_designator IN Varchar2,
67 p_version In Number,
68 p_horizon_start IN date,
69 p_horizon_end IN date,
70 p_plan_id IN Number,
71 p_sr_instance_id IN Number,
72 p_org_id IN Number,
73 p_item_id IN Number,
74 p_supplier_id IN Number,
75 p_supplier_site_id IN Number,
76 p_customer_id IN Number,
77 p_customer_site_id IN Number,
78 p_planner_code IN Varchar2,
79 p_abc_class IN Varchar2,
80 p_planning_gp IN Varchar2,
81 p_project_id IN Number,
82 p_task_id IN Number,
83 p_publish_program_type IN Number);
84
85 END msc_x_wfnotify_pkg;