1 package body BOMPCEDC as
2 /* $Header: BOMCEDCB.pls 115.0 99/07/16 05:11:00 porting ship $ */
3 /*============================================================================+
4 | Copyright (c) 1993 Oracle Corporation Belmont, California, USA |
5 | All rights reserved. |
6 | Oracle Manufacturing |
7 +=============================================================================+
8 | |
9 | FILE NAME : BOMCEDCB.pls |
10 | DESCRIPTION : |
11 | This file creates packaged functions that check for |
12 | exsisting matching configurations. |
13 | |
14 | BOMPCEDC.bomfcdec_ch_du_ext_config - Searches for a matching |
15 | configuration in the Item/BOM/Rtg tables. |
16 | |
17 | It is called by BOMPCHDU.bomfchdu_check_dupl_config. |
18 | |
19 | HISTORY : |
20 | 2/21/94 Manish Modi |
21 | Transfered the code from BOMPCHDU.sql |
22 | |
23 *============================================================================*/
24
25 function bomfcdec_ch_du_ext_config (
26 demand_id number,
27 config_item_id out number,
28 error_message out VARCHAR2,
29 message_name out VARCHAR2,
30 table_name out VARCHAR2
31 )
32 return integer
33 is
34 begin
35 /*
36 ** This function can be replaced by custom code that will search
37 ** for an existing configuration that meets the requirements
38 ** specified by the demand for a new configuration.
39 ** This function should search through existing items, bills
40 ** and routings to find a matching configuration item.
41 */
42 config_item_id := NULL;
43 return (1);
44 end;
45
46 end BOMPCEDC;