DBA Data[Home] [Help]

PACKAGE: APPS.MRP_FLOW_DEMAND

Source


1 PACKAGE MRP_FLOW_DEMAND AUTHID CURRENT_USER AS
2 /* $Header: MRPFLOWS.pls 115.8 2002/12/04 21:31:16 pshah ship $ */
3 
4    TYPE number_arr IS TABLE OF number INDEX BY BINARY_INTEGER;
5 
6    TYPE parent_item_type is RECORD (
7       inventory_item_id          number_arr,
8       planned_quantity           number_arr,
9       quantity_completed         number_arr
10    );
11 
12 
13 PROCEDURE Main_Flow_Demand( i_RN             IN NUMBER,
14                             o_return_code    OUT NOCOPY NUMBER,
15                             o_error_message  OUT NOCOPY VARCHAR2);
16 
17 PROCEDURE Get_Bill_Change( i_RN             IN NUMBER,
18                            o_return_code    OUT NOCOPY NUMBER,
19                            o_error_message  OUT NOCOPY VARCHAR2);
20 
21 PROCEDURE Execute_Remained_JOBS( i_RN             IN NUMBER,
22                                  o_return_code    OUT NOCOPY NUMBER,
23                                  o_error_message  OUT NOCOPY VARCHAR2);
24 
25 PROCEDURE Execute_Flow_Demand( i_RN             IN  NUMBER,
26                                o_return_code    OUT NOCOPY NUMBER,
27                                o_error_message  OUT NOCOPY VARCHAR2);
28 
29 PROCEDURE Explode_Flow_Demands(    o_return_code      OUT NOCOPY NUMBER,
30                                    o_error_message    OUT NOCOPY VARCHAR2);
31 
32 PROCEDURE ReExplode_Flow_Demands(  o_return_code      OUT NOCOPY NUMBER,
33                                    o_error_message    OUT NOCOPY VARCHAR2);
34 
35 PROCEDURE Get_Phantoms(  i_parent_items     IN  parent_item_type,
36                          o_phantom_items    OUT NOCOPY parent_item_type,
37                          o_return_code      OUT NOCOPY NUMBER,
38                          o_error_message    OUT NOCOPY VARCHAR2);
39 
40 PROCEDURE Insert_Demands(i_parent_items     IN  PARENT_ITEM_TYPE,
41                          i_level            IN  NUMBER,
42                          o_return_code      OUT NOCOPY NUMBER,
43                          o_error_message    OUT NOCOPY VARCHAR2);
44 
45 END MRP_FLOW_DEMAND;