PACKAGE: APPS.MRP_GRAPH_LINE_CAPACITY

Source

1 PACKAGE MRP_GRAPH_LINE_CAPACITY AUTHID CURRENT_USER AS
2 /* $Header: MRPGLCPS.pls 115.4 99/07/16 12:21:18 porting ship $ */
3 
4 
5 -- Define constants
6 NUM_OF_COLUMNS		CONSTANT INTEGER := 36;
7 
8 -- Define types
9 TYPE mrp_capacity IS RECORD
10 	(department_id	NUMBER,
11 	 resource_id	NUMBER,
12          line_id   	NUMBER,
13          bucket_number  NUMBER,
14 	 bucket_date	DATE,
15 	 bucket_qty	NUMBER);
16 
17 TYPE bucket_number IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
18 TYPE bucket_date IS TABLE OF DATE INDEX BY BINARY_INTEGER;
19 
20 -- Define procedures
21 PROCEDURE Load_Capacity_Records(p_plan_id IN NUMBER,
22 				p_line_id IN NUMBER,
23 				p_org_id IN NUMBER,
24 				p_start_date IN DATE);
25 
26 END MRP_GRAPH_LINE_CAPACITY;