[Home] [Help]
PACKAGE BODY: APPS.MRP_WORKBENCHLOAD_PUB
Source
1 PACKAGE BODY MRP_WorkbenchLoad_PUB AS
2 /* $Header: MRPPWBLB.pls 120.1 2006/02/17 14:17:10 ahoque noship $ */
3
4 PROCEDURE planner_workbench_load(
5 arg_org_id IN NUMBER,
6 arg_compile_desig IN VARCHAR2,
7 arg_query_id IN NUMBER,
8 arg_user_id IN NUMBER,
9 arg_wip_load IN VARCHAR2,
10 arg_po_load IN VARCHAR2,
11 arg_wip_resched IN VARCHAR2,
12 arg_po_resched IN VARCHAR2,
13 arg_rep_load IN VARCHAR2,
14 arg_po_group_by IN NUMBER,
15 arg_wip_group_id IN NUMBER,
16 arg_launch_process OUT NOCOPY NUMBER)
17 IS
18 REQ_GRP_ALL_ON_ONE CONSTANT INTEGER := 1; /* PO group by */
19 REQ_GRP_ITEM CONSTANT INTEGER := 2;
20 REQ_GRP_BUYER CONSTANT INTEGER := 3;
21 REQ_GRP_PLANNER CONSTANT INTEGER := 4;
22 REQ_GRP_VENDOR CONSTANT INTEGER := 5;
23 REQ_GRP_ONE_EACH CONSTANT INTEGER := 6;
24 REQ_GRP_CATEGORY CONSTANT INTEGER := 7;
25
26 WIP_DIS_MASS_LOAD CONSTANT INTEGER := 1;
27 WIP_REP_MASS_LOAD CONSTANT INTEGER := 2;
28 WIP_DIS_MASS_RESCHEDULE CONSTANT INTEGER := 4;
29 PO_MASS_LOAD CONSTANT INTEGER := 8;
30 PO_MASS_RESCHEDULE CONSTANT INTEGER := 16;
31
32 PURCHASE_ORDER CONSTANT INTEGER := 1; /* order type lookup */
33 PURCH_REQ CONSTANT INTEGER := 2;
34 WORK_ORDER CONSTANT INTEGER := 3;
35 REPETITVE_SCHEDULE CONSTANT INTEGER := 4;
36 PLANNED_ORDER CONSTANT INTEGER := 5;
37 MATERIAL_TRANSFER CONSTANT INTEGER := 6;
38 NONSTD_JOB CONSTANT INTEGER := 7;
39 RECEIPT_PURCH_ORDER CONSTANT INTEGER := 8;
40 REQUIREMENT CONSTANT INTEGER := 9;
41 FPO_SUPPLY CONSTANT INTEGER := 10;
42
43 NOT_UNDER_REV_CONTROL CONSTANT INTEGER := 1;
44 UNDER_REV_CONTROL CONSTANT INTEGER := 2;
45
46 PURCHASING_BY_REV CONSTANT INTEGER := 1;
47 NOT_PURCHASING_BY_REV CONSTANT INTEGER := 2;
48
49 var_launch_process INTEGER;
50 var_calendar_code VARCHAR2(10);
51 var_exception_set_id NUMBER;
52 var_row_id ROWID;
53 var_quantity NUMBER;
54 var_purchasing_by_rev NUMBER;
55
56 BEGIN
57 /* Stubbed out the code, as not required in the new release */
58 NULL;
59
60 END planner_workbench_load;
61
62 END;