[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;