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;