[Home] [Help]
PACKAGE: APPS.BOM_DELETE_GROUPS_API
Source
1 PACKAGE Bom_Delete_Groups_Api AUTHID CURRENT_USER AS
2 /* $Header: BOMPDELS.pls 120.2.12000000.2 2007/02/20 11:26:55 bbpatel ship $ */
3 /***************************************************************************
4 --
5 -- Copyright (c) 1996 Oracle Corporation, Redwood Shores, CA, USA
6 -- All rights reserved.
7 --
8 -- FILENAME
9 --
10 -- BOMPDELB.pls
11 --
12 -- DESCRIPTION
13 --
14 -- Body of package Bom_Delete_Groups_Api
15 --
16 -- NOTES
17 --
18 -- HISTORY
19 --
20 -- 02-SEP-02 Vani Hymavathi Initial Creation
21 ***************************************************************************/
22
23 TYPE TOKEN_RECORD is RECORD(
24 inventory_item_id NUMBER,
25 organization_id NUMBER,
26 bill_sequence_id NUMBER,
27 routing_sequence_id NUMBER,
28 component_sequence_id NUMBER,
29 operation_sequence_id NUMBER,
30 del_group_seq_id NUMBER, -- added for bug 5546629
31 component_item_id NUMBER /* Token added for bug 5726408 */
32 );
33
34 TYPE BIND_RECORD is RECORD(
35 bind_name VARCHAR2(50),
36 bind_value NUMBER);
37
38 TYPE BIND_TABLE is TABLE of BIND_RECORD INDEX BY BINARY_INTEGER;
39
40
41 /*****************************************************************
42 * Procedure : delete groups
43 * Parameters IN :
44 * delete_group_id,action_type,delete_type,archive
45 * Parameters OUT: ERRBUF, RETCODE
46 * Purpose : Main procedure for checking and deleting a delete group
47 ******************************************************************/
48
49 PROCEDURE delete_groups
50 (ERRBUF OUT NOCOPY VARCHAR2,
51 RETCODE OUT NOCOPY VARCHAR2,
52 delete_group_id IN NUMBER:= '0',
53 action_type IN NUMBER:='1',
54 delete_type IN NUMBER:= '1',
55 archive IN NUMBER:='1',
56 process_errored_rows IN VARCHAR2
57 ) ;
58
59 PROCEDURE delete_groups
60 (ERRBUF OUT NOCOPY VARCHAR2,
61 RETCODE OUT NOCOPY VARCHAR2,
62 delete_group_id IN NUMBER:= '0',
63 action_type IN NUMBER:='1',
64 delete_type IN NUMBER:= '1',
65 archive IN NUMBER:='1'
66 ) ;
67
68 END;