PACKAGE: APPS.ONT_OS_CATEGORIES

Source

1 PACKAGE ont_os_categories AUTHID CURRENT_USER AS
2  /* $Header: ontcatis.pls 120.1 2006/03/29 16:54:22 spooruli noship $ */
3 
4 --------------------------------------------------------------------------------
5 -- Parameters p_structure_name and p_level is currently defaulted for Oracle IT,
6 -- it will be used in future to flatten any hiearical value  set like GL#Product
7 -- to create Categories in applications. This program can be run in test mode to
8 -- see what categories it will create when parameter p_mode is passed other then
9 -- 2.
10 --------------------------------------------------------------------------------
11 
12 PROCEDURE catinsert( errbuf OUT NOCOPY VARCHAR2,
13 
14 retcode OUT NOCOPY NUMBER,
15 
16                   p_valueset_name      IN VARCHAR2 DEFAULT 'GL#Product',
17                   p_top_level_value    IN VARCHAR2 DEFAULT '0Y53',
18                   p_mode               IN NUMBER   DEFAULT 2,
19                   p_structure_name     IN VARCHAR2 DEFAULT 'Product Reporting Hierarchy',
20                   p_level              IN NUMBER   DEFAULT 8);
21 
22 END ont_os_categories;