[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;