[Home] [Help]
PACKAGE: APPS.MRP_PLANNER_PK
Source
1 PACKAGE mrp_planner_pk AUTHID CURRENT_USER AS
2 /* $Header: MRPPPLNS.pls 115.2 1999/11/15 18:25:04 pkm ship $ */
3 PROCEDURE mb_delete_ms_outside_tf(
4 arg_compile_desig VARCHAR2,
5 arg_org_id NUMBER,
6 arg_jcurr_date NUMBER);
7 PROCEDURE mb_delete_ms_outside_tf(
8 arg_compile_desig VARCHAR2,
9 arg_org_id NUMBER,
10 arg_jcurr_date NUMBER,
11 arg_query_id NUMBER);
12 PROCEDURE create_new_planner_mps_entries(
13 arg_compile_desig VARCHAR2,
14 arg_sched_desig VARCHAR2,
15 arg_org_id NUMBER);
16 PROCEDURE create_orig_mps_entries(
17 arg_sched_desig VARCHAR2,
18 arg_org_id NUMBER);
19 PROCEDURE create_mbp_orig_mps_entries(
20 arg_sched_desig VARCHAR2,
21 arg_org_id NUMBER);
22 /*-------------------------------------------------------------------------+
23 | Defined constants |
24 +-------------------------------------------------------------------------*/
25 SYS_YES CONSTANT INTEGER := 1; /* sys yes no */
26 SYS_NO CONSTANT INTEGER := 2;
27
28 ORIG_SCHEDULE CONSTANT INTEGER := 1; /* schedule level */
29 UPDATED_SCHEDULE CONSTANT INTEGER := 2;
30 MRP_SCHEDULE CONSTANT INTEGER := 3;
31
32 REORDER_POINT_PLANNING CONSTANT INTEGER := 1;/* Inventory Planning Codes */
33 MIN_MAX_PLANNING CONSTANT INTEGER := 2;
34 MRP_PLANNING CONSTANT INTEGER := 3;
35 MPS_PLANNING CONSTANT INTEGER := 4;
36 MMS_PLANNING CONSTANT INTEGER := 5;
37 NO_PLANNING CONSTANT INTEGER := 6;
38
39 DISCRETE_DEMAND CONSTANT INTEGER := 1; /* MRP_REPETITIVE_DEMAND_TYPE*/
40 REPET_DEMAND CONSTANT INTEGER := 2;
41
42 SCHED_MANUAL CONSTANT INTEGER := 1; /* origination types */
43 SCHED_ITEM_FORECAST CONSTANT INTEGER := 2;
44 SCHED_SALES_ORDER CONSTANT INTEGER := 3;
45 SCHED_COPY CONSTANT INTEGER := 4;
46 SCHED_MPS_PLAN CONSTANT INTEGER := 6;
47 SCHED_OUTSIDE CONSTANT INTEGER := 7;
48
49 PURCHASE_ORDER CONSTANT INTEGER := 1; /* order type lookup */
50 PURCH_REQ CONSTANT INTEGER := 2;
51 WORK_ORDER CONSTANT INTEGER := 3;
52 REPETITVE_SCHEDULE CONSTANT INTEGER := 4;
53 PLANNED_ORDER CONSTANT INTEGER := 5;
54 MATERIAL_TRANSFER CONSTANT INTEGER := 6;
55 NONSTD_JOB CONSTANT INTEGER := 7;
56 RECEIPT_PURCH_ORDER CONSTANT INTEGER := 8;
57 REQUIREMENT CONSTANT INTEGER := 9;
58 FPO_SUPPLY CONSTANT INTEGER := 10;
59
60 SCHEDULE_DEMAND CONSTANT INTEGER := 1; /* DEMAND_SUPPLY_TYPE */
61 SCHEDULE_SUPPLY CONSTANT INTEGER := 2;
62
63 STATUS_INITIALIZING CONSTANT INTEGER := 1;
64 STATUS_PROCESSING CONSTANT INTEGER := 2;
65 STATUS_IDLE CONSTANT INTEGER := 3;
66 STATUS_COMPLETE CONSTANT INTEGER := 4;
67
68 NULL_VALUE CONSTANT INTEGER := -23453;
69
70 PHANTOM_ASSY CONSTANT INTEGER := 6;
71
72 CUM_TOTAL_LT CONSTANT INTEGER := 1;
73 CUM_MFG_LT CONSTANT INTEGER := 2;
74 TOTAL_LT CONSTANT INTEGER := 3;
75 USER_TF CONSTANT INTEGER := 4;
76
77
78 END mrp_planner_pk;