1 PACKAGE MSD_BOM_COLLECTIONS AUTHID CURRENT_USER AS
2 /* $Header: msdbmcls.pls 115.1 2002/11/28 00:45:04 pinamati noship $ */
3
4 TYPE numberList IS TABLE OF Number;
5 TYPE dateList IS TABLE OF Date;
6 TYPE varchar2List IS TABLE OF Varchar2(255);
7
8 Type parent_type is RECORD (
9 item_id number,
10 planning_factor number,
11 quantity_per number);
12
13 Type parents is TABLE of parent_type index by binary_integer;
14
15 /* Public Procedures */
16 procedure collect_bom_data (
17 errbuf in out nocopy varchar2,
18 retcode in out nocopy varchar2,
19 p_instance_id in number);
20
21
22 END MSD_BOM_COLLECTIONS;