PACKAGE: APPS.BOM_DELETE_ITEMS

Source

1 PACKAGE BOM_DELETE_ITEMS AUTHID CURRENT_USER AS
2 /* $Header: BOMDELTS.pls 115.1 99/07/16 05:12:08 porting ship $ */
3 -- +==========================================================================+
4 -- | Copyright (c) 1993 Oracle Corporation Belmont, California, USA           |
5 -- |                          All rights reserved.                            |
6 -- +==========================================================================+
7 -- |                                                                          |
8 -- | File Name   : BOMDELTS.pls                                               |
9 -- | Description : Populate BOM_DELETE_ENTITIES and BOM_DELETE_SUB_ENTITIES   |
10 -- |               when called by BOMFDDEL (Item, BOM and Routing Delete Form |
11 -- |               under the following conditions:                            |
12 -- |               - called on return from Item Catalog Search                |
13 -- |               - Component or Routing Where Used request                  |
14 -- |               - Master Org to Child Org explosion                        |
15 -- |               - BOM and Routing explosion                                |
16 -- | Parameters  : org_id	organization_id                               |
17 -- |               err_msg	error message out buffer                      |
18 -- |               error_code	error code out. returns sql error code        |
19 -- |                         	if sql error.                                 |
20 -- | Revision                                                                 |
21 -- |  08-MAR-95	Anand Rajaraman	Creation                                      |
22 -- |  07-JUL-95 Anand Rajaraman Changes after Code Review (Shreyas Shah)      |
23 -- |                            Removed expiration_time (Calvin Siew)         |
24 -- +==========================================================================+
25 
26 -- +------------------------------- POPULATE_DELETE --------------------------+
27 
28 -- NAME
29 -- POPULATE_DELETE
30 
31 -- DESCRIPTION
32 -- Populate BOM_DELETE_ENTITIES and BOM_DELETE_SUB_ENTITIES
33 
34 -- REQUIRES
35 -- org_id: organization id
36 -- last_login_id
37 -- catalog_search_id: item catalog search id
38 -- component_id
39 -- delete_group_id
40 -- delete_type
41 -- "1" - ITEM
42 -- "2" - BOM
43 -- "3" - ROUTING
44 -- "4" - COMPONENT
45 -- "5" - OPERATION
46 -- "6" - BOM and ROUTING
47 -- "7" - ITEM/BOM and ROUTING
48 -- del_grp_type
49 -- "1" - Non-ENG items only
50 -- "2" - ENG items only
51 -- process_type
52 -- "1" - called from form
53 -- "2" - called from search region
54 -- expiration_date
55 
56 -- OUTPUT
57 
58 -- RETURNS
59 
60 -- NOTES
61 
62 -- +--------------------------------------------------------------------------+
63 
64 PROCEDURE POPULATE_DELETE
65 (
66 org_id			IN NUMBER,
67 last_login_id		IN NUMBER DEFAULT -1,
68 catalog_search_id	IN NUMBER,
69 component_id		IN NUMBER,
70 delete_group_id		IN NUMBER,
71 delete_type		IN NUMBER,
72 del_grp_type		IN NUMBER,
73 process_type		IN NUMBER,
74 expiration_date		IN DATE);
75 
76 END BOM_DELETE_ITEMS;