PACKAGE: APPS.MSD_DEM_COLLECT_BOM_DATA

Source

1 PACKAGE MSD_DEM_COLLECT_BOM_DATA AUTHID CURRENT_USER AS
2 /* $Header: msddemcbds.pls 120.2 2009/09/23 10:47:51 sjagathe noship $ */
3 
4    /*** GLOBAL VARIABLES ***/
5    G_YES 	NUMBER	:= MSD_DEM_COMMON_UTILITIES.C_YES;
6    G_NO		NUMBER	:= MSD_DEM_COMMON_UTILITIES.C_NO;
7 
8 
9    /*** CUSTOM DATA TYPES ***/
10    TYPE NUMBERLIST               IS TABLE OF NUMBER;
11    TYPE DATELIST                 IS TABLE OF DATE;
12    TYPE VARCHAR2LIST             IS TABLE OF VARCHAR2(255);
13 
14 
15    TYPE PARENT_TYPE IS RECORD (
16    		item_id                    NUMBER,
17      	planning_factor            NUMBER,
18      	quantity_per               NUMBER,
19      	disable_date			   DATE);
20 
21    TYPE PARENTS IS TABLE OF PARENT_TYPE INDEX BY BINARY_INTEGER;
22 
23 
24    /*** PROCEDURES ***
25     *
26     * COLLECT_BOM_DATA
27     *
28     *** PROCEDURES  ***/
29 
30 
31    /*
32     *
33     */
34    PROCEDURE COLLECT_BOM_DATA (
35                         errbuf			OUT NOCOPY 	VARCHAR2,
36       			retcode			OUT NOCOPY 	VARCHAR2,
37       			p_sr_instance_id	IN		NUMBER );
38 
39 
40 END MSD_DEM_COLLECT_BOM_DATA;