DBA Data[Home] [Help]

PACKAGE: APPS.BOMDELEX

Source


1 PACKAGE BOMDELEX AUTHID CURRENT_USER AS
2 /* $Header: BOMDEXPS.pls 120.1 2005/06/21 04:44:14 appldev ship $ */
3 /*==========================================================================+
4 |   Copyright (c) 1993 Oracle Corporation Belmont, California, USA          |
5 |                          All rights reserved.                             |
6 +===========================================================================+
7 |                                                                           |
8 | File Name    : BOMDELES.pls                                               |
9 | DESCRIPTION  : This file is a packaged specification for deleting
10 |		 records from bom_explosions table where the rexplode flag
11 |		 is set to 1
12 | Parameters:   1 - top bill sequence id , 2-explosion type
13 |               error_code      error code
14 |               error_msg       error message
15 |History :
16 |23-JUN-03	Sangeetha	CREATED
17 +==========================================================================*/
18 
19 PROCEDURE DELETE_BOM_EXPLOSIONS(
20 	ERRBUF                  IN OUT NOCOPY /* file.sql.39 change */ 	VARCHAR2,
21 	RETCODE                 IN OUT NOCOPY /* file.sql.39 change */ 	VARCHAR2,
22 	top_bill_seq_id         IN      Number  ,
23         expl_type          	IN      Varchar2
24         ) ;
25 
26 PROCEDURE Get_Top_Bill(
27 	Item_Id 	 	 IN     NUMBER,
28         Org_Id  	         IN     NUMBER,
29         Alt_Bom_Desg		 IN	VARCHAR2,
30         Return_Status    	 IN OUT NOCOPY /* file.sql.39 change */    VARCHAR2 ,
31 	Err_Buf		 	 IN OUT NOCOPY /* file.sql.39 change */ 	VARCHAR2
32 	);
33 
34 END BOMDELEX;