1 PACKAGE WIP_MRP_RELIEF AUTHID CURRENT_USER AS
2 /* $Header: wipmrps.pls 120.0.12010000.2 2010/02/11 04:10:58 pding 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_start_quantity IN NUMBER, /*add for bug 8979443 (FP of 8420494)*/
14 old_start_quantity IN NUMBER, /*add for bug 8979443 (FP of 8420494)*/
15 new_sched_compl_date IN DATE,
16 old_sched_compl_date IN DATE,
17 wip_enty_id IN NUMBER,
18 srce_code IN VARCHAR2,
19 srce_line_id IN NUMBER,
20 new_bill_desig IN VARCHAR2,
21 old_bill_desig IN VARCHAR2,
22 new_bill_rev_date IN DATE,
23 old_bill_rev_date IN DATE,
24 new_dmd_class IN VARCHAR2,
25 old_dmd_class IN VARCHAR2,
26 new_status_type IN NUMBER,
27 old_status_type IN NUMBER,
28 new_qty_completed IN NUMBER,
29 old_qty_completed IN NUMBER,
30 new_date_completed IN DATE,
31 old_date_completed IN DATE,
32 new_project_id IN NUMBER,
33 old_project_id IN NUMBER,
34 new_task_id IN NUMBER,
35 old_task_id IN NUMBER);
36
37 PROCEDURE WIP_FLOW_SCHEDULES_PROC
38 (item_id IN NUMBER,
39 org_id IN NUMBER,
40 last_upd_date IN DATE,
41 last_upd_by IN NUMBER,
42 creat_date IN DATE,
43 creat_by IN NUMBER,
44 new_request_id IN NUMBER,
45 old_request_id IN NUMBER,
46 dmd_src_type IN NUMBER,
47 dmd_src_line IN VARCHAR2,
48 new_mps_quantity IN NUMBER,
49 old_mps_quantity IN NUMBER,
50 new_sched_compl_date IN DATE,
51 old_sched_compl_date IN DATE,
52 wip_enty_id IN NUMBER,
53 new_dmd_class IN VARCHAR2,
54 old_dmd_class IN VARCHAR2,
55 new_bill_desig IN VARCHAR2,
56 old_bill_desig IN VARCHAR2,
57 new_status_type IN NUMBER,
58 old_status_type IN NUMBER,
59 new_qty_completed IN NUMBER,
60 old_qty_completed IN NUMBER,
61 new_date_completed IN DATE,
62 old_date_completed IN DATE,
63 new_project_id IN NUMBER,
64 old_project_id IN NUMBER,
65 new_task_id IN NUMBER,
66 old_task_id IN NUMBER);
67
68 END WIP_MRP_RELIEF;