PACKAGE: APPS.BOM_DELETE_GROUPS_API

Source

1 PACKAGE  Bom_Delete_Groups_Api 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;