[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;