PACKAGE: APPS.BOMPECOD

Source

1 PACKAGE BOMPECOD AUTHID CURRENT_USER AS
2 /* $Header: BOMECODS.pls 115.1 99/07/16 05:12:15 porting ship $ */
3 
4 
5 -- ==========================================================================
6 --   Copyright (c) 1993 Oracle Corporation Belmont, California, USA
7 --                          All rights reserved.
8 -- ==========================================================================
9 --
10 -- File Name    : BOMPECOD.sql
11 -- DESCRIPTION  :
12 --              This file creates a stored procedure that deletes an ECO
13 --              and all the associated data from the following tables:
14 --                   ENG_ENGINEERING_CHANGES
15 --                   ENG_CHANGE_ORDER_REVISIONS
16 --                   ENG_REVISED_ITEMS
17 --                   ENG_CURRENT_SCHEDULED_DATES
18 --                   BOM_INVENTORY_COMPONENTS
19 --                   BOM_REFERENCE_DESIGNATORS
20 --                   BOM_SUBSTITUTE_COMPONENTS
21 --                   ENG_REVISED_COMPONENTS
22 --                   MTL_ITEM_REVISIONS
23 --                   BOM_BILL_OF_MATERIALS
24 -- INPUTS       :  P_CHANGE_NOTICE - engineering change order to be deleted
25 --                 P_ORGANIZATION_ID - organization id
26 --
27 -- ==========================================================================
28 
29    PROCEDURE BOM_DELETE_ECO
30    (P_CHANGE_NOTICE             IN      VARCHAR2,
31     P_ORGANIZATION_ID		IN	NUMBER);
32 
33 END BOMPECOD;
34