1 PACKAGE wip_wf_update_date AUTHID CURRENT_USER AS
2 /*$Header: wipwfdts.pls 115.8 2002/12/03 12:31:10 simishra ship $ */
3
4 /* THe procedure to start a need_by_date change workflow process */
5 PROCEDURE StartNBDWFProcess (item_type in varchar2 default null,
6 item_key in varchar2,
7 workflow_process in varchar2 default null,
8 p_init_scheduler in varchar2,
9 p_wip_entity_id in number,
10 p_wip_entity_name in varchar2,
11 p_organization_id in number,
12 p_rep_schedule_id in number,
13 p_wip_line_id in number,
14 p_wip_line_code in varchar2,
15 p_end_assembly_num in varchar2,
16 p_end_assembly_desc in varchar2,
17 p_po_number in varchar2,
18 p_new_need_by_date in date,
19 p_old_need_by_date in date,
20 p_comments in varchar2,
21 p_po_distribution_id in number,
22 p_operation_seq_num in number);
23
24
25 PROCEDURE update_promise_date( itemtype in varchar2,
26 itemkey in varchar2,
27 actid in number,
28 funcmode in varchar2,
29 resultout out NOCOPY varchar2);
30
31 PROCEDURE update_need_by_date( itemtype in varchar2,
32 itemkey in varchar2,
33 actid in number,
34 funcmode in varchar2,
35 resultout out NOCOPY varchar2);
36
37 /* called at AK region, custom calls */
38 PROCEDURE promise_date(c_inputs1 in varchar2 default null,
39 c_inputs2 in varchar2 default null,
40 c_inputs3 in varchar2 default null,
41 c_inputs4 in varchar2 default null,
42 c_inputs5 in varchar2 default null,
43 c_inputs6 in varchar2 default null,
44 c_inputs7 in varchar2 default null,
45 c_inputs8 in varchar2 default null,
46 c_inputs9 in varchar2 default null,
47 c_inputs10 in varchar2 default null,
48 c_outputs1 out nocopy varchar2,
49 c_outputs2 out nocopy varchar2,
50 c_outputs3 out nocopy varchar2,
51 c_outputs4 out nocopy varchar2,
52 c_outputs5 out nocopy varchar2,
53 c_outputs6 out nocopy varchar2,
54 c_outputs7 out nocopy varchar2,
55 c_outputs8 out nocopy varchar2,
56 c_outputs9 out nocopy varchar2,
57 c_outputs10 out nocopy varchar2);
58
59
60 END wip_wf_update_date;