1 PACKAGE JTY_TERR_DENORM_RULES_PVT AUTHID CURRENT_USER AS
2 /* $Header: jtfytdrs.pls 120.2.12010000.1 2008/07/24 18:32:26 appldev ship $ */
3 -- Start of Comments
4 -- ---------------------------------------------------
5 -- PACKAGE NAME: JTY_TERR_DENORM_RULES_PVT
6 -- ---------------------------------------------------
7 -- PURPOSE
8 -- This package is used for the following prposes :
9 -- a) denormalize the territory hierarchy
10 -- b) denormalize the territory qualifier values
11 -- c) calculate absolute rank, number of qualifiers and qual relation product
12 --
13 -- Procedures:
14 -- (see below for specification)
15 --
16 -- NOTES
17 -- This package is publicly available for use
18 --
19 -- HISTORY
20 -- 06/13/05 ACHANDA CREATED
21 --
22 --
23 -- End of Comments
24 --
25
26 PROCEDURE process_attr_and_rank (
27 p_source_id IN NUMBER,
28 p_mode IN VARCHAR2,
29 p_terr_change_tab IN JTY_TERR_ENGINE_GEN_PVT.terr_change_type,
30 errbuf OUT NOCOPY VARCHAR2,
31 retcode OUT NOCOPY VARCHAR2);
32
33 PROCEDURE CREATE_DNMVAL_INDEX (
34 p_table_name IN VARCHAR2,
35 p_source_id IN NUMBER,
36 p_mode IN VARCHAR2,
37 x_Return_Status OUT NOCOPY VARCHAR2);
38
39 FUNCTION get_level_from_root(p_terr_id IN number) RETURN NUMBER;
40
41 END JTY_TERR_DENORM_RULES_PVT;