DBA Data[Home] [Help]

PACKAGE: APPS.BOMPNORD

Source


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;