1 PACKAGE WIP_MRP_RELIEF AUTHID CURRENT_USER AS
2 /* $Header: wipmrps.pls 115.8 2002/12/12 15:10:01 rmahidha ship $ */
3
4 PROCEDURE WIP_DISCRETE_JOBS_PROC
5 (item_id IN NUMBER,
6 org_id IN NUMBER,
7 last_upd_date IN DATE,
8 last_upd_by IN NUMBER,
9 creat_date IN DATE,
10 creat_by IN NUMBER,
11 new_mps_quantity IN NUMBER,
12 old_mps_quantity IN NUMBER,
13 new_sched_compl_date IN DATE,
14 old_sched_compl_date IN DATE,
15 wip_enty_id IN NUMBER,
16 srce_code IN VARCHAR2,
17 srce_line_id IN NUMBER,
18 new_bill_desig IN VARCHAR2,
19 old_bill_desig IN VARCHAR2,
20 new_bill_rev_date IN DATE,
21 old_bill_rev_date IN DATE,
22 new_dmd_class IN VARCHAR2,
23 old_dmd_class IN VARCHAR2,
24 new_status_type IN NUMBER,
25 old_status_type IN NUMBER,
26 new_qty_completed IN NUMBER,
27 old_qty_completed IN NUMBER,
28 new_date_completed IN DATE,
29 old_date_completed IN DATE,
30 new_project_id IN NUMBER,
31 old_project_id IN NUMBER,
32 new_task_id IN NUMBER,
33 old_task_id IN NUMBER);
34
35 PROCEDURE WIP_FLOW_SCHEDULES_PROC
36 (item_id IN NUMBER,
37 org_id IN NUMBER,
38 last_upd_date IN DATE,
39 last_upd_by IN NUMBER,
40 creat_date IN DATE,
41 creat_by IN NUMBER,
42 new_request_id IN NUMBER,
43 old_request_id IN NUMBER,
44 dmd_src_type IN NUMBER,
45 dmd_src_line IN VARCHAR2,
46 new_mps_quantity IN NUMBER,
47 old_mps_quantity IN NUMBER,
48 new_sched_compl_date IN DATE,
49 old_sched_compl_date IN DATE,
50 wip_enty_id IN NUMBER,
51 new_dmd_class IN VARCHAR2,
52 old_dmd_class IN VARCHAR2,
53 new_bill_desig IN VARCHAR2,
54 old_bill_desig IN VARCHAR2,
55 new_status_type IN NUMBER,
56 old_status_type IN NUMBER,
57 new_qty_completed IN NUMBER,
58 old_qty_completed IN NUMBER,
59 new_date_completed IN DATE,
60 old_date_completed IN DATE,
61 new_project_id IN NUMBER,
62 old_project_id IN NUMBER,
63 new_task_id IN NUMBER,
64 old_task_id IN NUMBER);
65
66 END WIP_MRP_RELIEF;