1 PACKAGE MRP_SCHEDULE AUTHID CURRENT_USER AS
2 /* $Header: MRSCHDBS.pls 120.1 2005/06/16 14:01:53 ichoudhu noship $*/
3
4 PROCEDURE BUCKET_ENTRIES
5 ( arg_query_id1 IN NUMBER,
6 arg_query_id2 IN NUMBER,
7 arg_org_id IN NUMBER,
8 arg_schedule_designator IN VARCHAR2,
9 arg_inventory_item_id IN NUMBER,
10 arg_bucket_type IN NUMBER,
11 arg_quantity_type IN NUMBER,
12 arg_version_type IN NUMBER,
13 arg_past_due IN NUMBER,
14 arg_start_date IN DATE,
15 arg_cutoff_date IN DATE );
16
17
18 PROCEDURE Get_Nextval( X_query_id1 IN OUT NOCOPY NUMBER,
19 X_query_id2 IN OUT NOCOPY NUMBER );
20
21
22 PROCEDURE Get_Cost( X_org_id IN NUMBER,
23 X_inventory_item_id IN NUMBER,
24 X_cost IN OUT NOCOPY NUMBER );
25
26 PROCEDURE Get_Max_BOM_Level( X_organization_id NUMBER,
27 X_mps_explosion_level IN OUT NOCOPY NUMBER);
28
29
30 END MRP_SCHEDULE;