DBA Data[Home] [Help]

PACKAGE: APPS.BOMPCEDC

Source


1 package BOMPCEDC AUTHID CURRENT_USER as
2 /* $Header: BOMCEDCS.pls 115.0 99/07/16 05:11:03 porting ship $ */
3 /*============================================================================+
4 |  Copyright (c) 1993 Oracle Corporation    Belmont, California, USA          |
5 |                        All rights reserved.                                 |
6 |                        Oracle Manufacturing                                 |
7 +=============================================================================+
8 |									      |
9 | FILE NAME   : BOMCEDCS.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,     /* Demand ID of MTL_DEMAND */
27 	config_item_id	out	number,	    /* Item ID of Configuration */
28         error_message   out     VARCHAR2,   /* 70 bytes to hold returned msg */
29         message_name    out     VARCHAR2,   /* 30 bytes to hold returned name */
30         table_name      out     VARCHAR2    /* 30 bytes to hold returned tbl */
31 	)
32 return integer;					/* 1 = OK
33 						   0 = Error */
34 end BOMPCEDC;