DBA Data[Home] [Help]

PACKAGE: APPS.MSD_COMPOSITE_GROUPING

Source


1 PACKAGE MSD_COMPOSITE_GROUPING AUTHID CURRENT_USER AS
2 /* $Header: MSDCMGRS.pls 115.1 2004/02/17 07:28:59 jarora noship $ */
3 
4 
5    SYS_YES                      CONSTANT NUMBER := 1;
6    SYS_NO                       CONSTANT NUMBER := 2;
7 
8 
9    G_SUCCESS                    CONSTANT NUMBER := 0;
10    G_WARNING                    CONSTANT NUMBER := 1;
11    G_ERROR                      CONSTANT NUMBER := 2;
12 
13    G_MSC_DEBUG   VARCHAR2(1) := nvl(FND_PROFILE.Value('MRP_DEBUG'),'N');
14 
15 PROCEDURE MSD_GROUP_STREAMS (  ERRBUF   OUT NOCOPY VARCHAR2,
16 			       RETCODE  OUT NOCOPY NUMBER,
17 			       p_mode IN NUMBER DEFAULT SYS_NO,
18 			       p_threshold_overlap IN NUMBER DEFAULT NULL);
19 /*
20 PROCEDURE MSD_ASSIGN_GROUPS (stream_tbl IN stream_tbl_type);
21 */
22 
23 FUNCTION GET_DIM_CODE (p_level_id IN NUMBER)
24 RETURN VARCHAR2	;
25 
26 FUNCTION GET_STREAM_COUNT (p_cs_definition_id IN NUMBER)
27 RETURN NUMBER ;
28 
29 FUNCTION number_of_designators (p_cs_definition_id IN NUMBER)
30 RETURN NUMBER;
31 
32 END MSD_COMPOSITE_GROUPING;