PACKAGE: APPS.MRP_MANAGER_PK

Source

1 PACKAGE mrp_manager_pk AUTHID CURRENT_USER AS
2 /* $Header: MRPPPMGS.pls 115.10 2003/03/04 01:49:09 schaudha ship $ */
3 
4     PROCEDURE   compute_sales_order_changes(
5                 arg_request_id  IN NUMBER,
6                 arg_user_id     IN NUMBER);
7 
8     PROCEDURE   update_sales_orders(
9                 arg_request_id IN NUMBER,
10                 arg_user_id IN NUMBER);
11 
12     PROCEDURE   create_forecast_items(
13                 arg_request_id IN NUMBER,
14                 arg_user_id    IN NUMBER,
15                 arg_desig      IN VARCHAR2);
16 
17     PROCEDURE   explode_in_process(
18                 arg_in_process_id OUT NOCOPY NUMBER,
19                 arg_request_id IN NUMBER,
20                 arg_user_id    IN NUMBER);
21 
22     PROCEDURE   mds_explode_in_process(
23                 arg_in_process_id OUT NOCOPY NUMBER,
24                 arg_request_id IN NUMBER,
25                 arg_user_id    IN NUMBER);
26 
27     PROCEDURE   update_forecast_desc_flex(
28                 arg_row_count  IN OUT NOCOPY   NUMBER);
29 
30     PROCEDURE   update_schedule_desc_flex(
31                 arg_row_count  IN OUT NOCOPY   NUMBER,
32                 arg_schedule_count IN NUMBER,
33                 arg_forecast_count IN NUMBER,
34                 arg_so_count       IN NUMBER,
35                 arg_interorg_count IN NUMBER);
36 
37     FUNCTION get_customer_name(
38                 p_customer_id   IN  NUMBER)RETURN VARCHAR2;
39 
40     FUNCTION get_ship_address(
41 		p_ship_id      	IN NUMBER)RETURN VARCHAR2;
42 
43     FUNCTION get_bill_address(
44 		p_bill_id 	IN NUMBER)RETURN VARCHAR2;
45 
46     FUNCTION get_project_id(
47 		p_demand_id 	IN NUMBER)RETURN NUMBER;
48 
49     FUNCTION get_task_id(
50 		p_demand_id 	IN NUMBER)RETURN NUMBER;
51 
52     FUNCTION get_unit_number(
53 		p_demand_id 	IN NUMBER)RETURN VARCHAR2;
54 
55     PRAGMA RESTRICT_REFERENCES(get_customer_name, WNDS, WNPS);
56     PRAGMA RESTRICT_REFERENCES(get_ship_address, WNDS, WNPS);
57     PRAGMA RESTRICT_REFERENCES(get_bill_address, WNDS, WNPS);
58     PRAGMA RESTRICT_REFERENCES(get_project_id, WNDS, WNPS);
59     PRAGMA RESTRICT_REFERENCES(get_task_id, WNDS, WNPS);
60 -- Removed because 8.1.5 does not need this
61 --    PRAGMA RESTRICT_REFERENCES(get_unit_number, WNDS, WNPS);
62 
63     /*------------------------------------------------------------------+
64     | Define constants                                                  |
65     +------------------------------------------------------------------*/
66     var_watch_id            NUMBER;
67 
68     VERSION                 CONSTANT CHAR(80) := '$Header: MRPPPMGS.pls 115.10 2003/03/04 01:49:09 schaudha ship $';
69 
70     NO_PLANNING             CONSTANT INTEGER := 6;      /* planning */
71 
72     ITEM_TYPE_MODEL         CONSTANT INTEGER := 1;      /* BOM Item type */
73     ITEM_TYPE_OPTION_CLASS  CONSTANT INTEGER := 2;
74     ITEM_TYPE_PLANNING      CONSTANT INTEGER := 3;
75     ITEM_TYPE_STANDARD      CONSTANT INTEGER := 4;
76     ITEM_TYPE_PRODUCT_FAMILY CONSTANT INTEGER := 5;
77 
78     MAGIC_STRING            CONSTANT VARCHAR2(10) := '734jkhJK24';
79 
80     SYS_YES                 CONSTANT INTEGER := 1;      /* sys yes no */
81     SYS_NO                  CONSTANT INTEGER := 2;
82 
83     MTL_SALES_ORDER         CONSTANT INTEGER := 2;      /* sales order */
84     MTL_INT_SALES_ORDER     CONSTANT INTEGER := 8;      /* internal sales
85                                                            order */
86 
87     DO_NOT_PROCESS          CONSTANT INTEGER := 1;
88     TO_BE_PROCESSED         CONSTANT INTEGER := 2;      /* process status */
89     ALREADY_PROCESSED       CONSTANT INTEGER := 5;
90     IN_PROCESS              CONSTANT INTEGER := 3;
91 
92     UPDATE_BATCH_SIZE       CONSTANT INTEGER := 100000;
93 
94     ATO_NONE                CONSTANT INTEGER := 3;
95 END mrp_manager_pk;