PACKAGE: APPS.MRP_OE

Source

1 PACKAGE MRP_OE AUTHID CURRENT_USER AS
2 /* $Header: MRPPNOES.pls 120.0 2005/05/25 03:51:01 appldev noship $ */
3 
4 /*-------------------------------------------------------------------+
5  | Define constants                                                  |
6  +------------------------------------------------------------------*/
7 
8     MTL_SALES_ORDER         CONSTANT INTEGER := 2;      /* sales order */
9     MTL_INT_SALES_ORDER     CONSTANT INTEGER := 8;      /* internal sales
10                                                            order */
11 
12     IN_PROCESS              CONSTANT INTEGER := 3;
13 
14 /*-------------------------------------------------------------------+
15  | Define functions                                                  |
16  +------------------------------------------------------------------*/
17 
18 FUNCTION mrp_quantity(p_demand_id IN NUMBER) RETURN NUMBER;
19 pragma restrict_references(mrp_quantity, WNDS,WNPS);
20 
21 FUNCTION mrp_date(p_demand_id IN NUMBER) RETURN DATE;
22 pragma restrict_references(mrp_date, WNDS,WNPS);
23 
24 FUNCTION available_to_mrp(p_demand_id IN NUMBER) RETURN NUMBER;
25 pragma restrict_references(available_to_mrp, WNDS,WNPS);
26 
27 FUNCTION updated_flag(p_demand_id IN NUMBER) RETURN NUMBER;
28 pragma restrict_references(updated_flag, WNDS,WNPS);
29 
30 FUNCTION available_to_atp(p_demand_id IN NUMBER) RETURN NUMBER;
31 pragma restrict_references(available_to_atp, WNDS,WNPS);
32 
33 FUNCTION total_reserv_qty (p_demand_id IN NUMBER) RETURN NUMBER;
34 pragma restrict_references(total_reserv_qty, WNDS,WNPS);
35 
36 END MRP_OE;