1 package bompnord as
2 /* $Header: BOMEORDS.pls 120.1 2005/06/21 04:11:33 appldev ship $ */
3
4 PROCEDURE bmxporder_explode_for_order (
5 org_id IN NUMBER,
6 copy_flag IN NUMBER DEFAULT 2,
7 expl_type IN VARCHAR2 DEFAULT 'OPTIONAL',
8 order_by IN NUMBER DEFAULT 1,
9 grp_id IN OUT NOCOPY /* file.sql.39 change */ NUMBER,
10 session_id IN NUMBER DEFAULT 0,
11 levels_to_explode IN NUMBER DEFAULT 60,
12 item_id IN NUMBER,
13 comp_code IN VARCHAR2 DEFAULT '',
14 starting_rev_date IN DATE DEFAULT SYSDATE - 1000,
15 rev_date IN VARCHAR2 DEFAULT NULL,
16 user_id IN NUMBER DEFAULT 0,
17 commit_flag IN VARCHAR2 DEFAULT 'N',
18 err_msg IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
19 error_code IN OUT NOCOPY /* file.sql.39 change */ NUMBER,
20 alt_bom_designator IN VARCHAR2 DEFAULT NULL
21 ) ;
22
23 END bompnord;