1 Package JTF_TERR_ENGINE_GEN_PVT AUTHID CURRENT_USER AS
2 /* $Header: jtfvtegs.pls 120.1 2005/07/02 01:44:57 appldev ship $ */
3 -- Start of Comments
4 -- ---------------------------------------------------
5 -- PACKAGE NAME: JTF_TERR_ENGINE_GEN_PVT
6 -- ---------------------------------------------------
7 -- PURPOSE
8 -- Joint task force core territory manager public api's.
9 -- This packe is used to generate the complete territory
10 -- Engine based on tha data setup in the JTF territory tables
11 --
12 -- Procedures:
13 -- (see below for specification)
14 --
15 -- NOTES
16 -- This package is publicly available for use
17 --
18 -- HISTORY
19 -- 01/27/00 VNEDUNGA Created
20 --
21 -- End of Comments
22
23 -- Identifies the Package associated with
24 -- a territory with child nodes
25 --
26 TYPE Terr_Package_Spec IS RECORD
27 (
28 TERR_ID NUMBER,
29 PACKAGE_COUNT NUMBER
30 );
31 TYPE Terr_PkgSpec_Tbl_Type IS TABLE OF Terr_Package_Spec
32 INDEX BY BINARY_INTEGER;
33
34
35 TYPE TERR_VALUE_REC_TYPE IS RECORD
36 (
37 COMPARISON_OPERATOR VARCHAR2(30),
38 INCLUDE_FLAG VARCHAR2(15),
39 QUAL_COL1 VARCHAR2(30),
40 QUAL_COL1_TABLE VARCHAR2(30),
41 QUAL_COL1_ALIAS VARCHAR2(60),
42 PRIM_INT_CDE_COL_ALIAS VARCHAR2(60),
43 SEC_INT_CDE_COL_ALIAS VARCHAR2(60),
44 LOW_VALUE_CHAR VARCHAR2(60),
45 HIGH_VALUE_CHAR VARCHAR2(60),
46 LOW_VALUE_NUMBER NUMBER,
47 HIGH_VALUE_NUMBER NUMBER,
48 INTEREST_TYPE_ID NUMBER,
49 PRIMARY_INTEREST_CODE_ID NUMBER,
50 SECONDARY_INTEREST_CODE_ID NUMBER,
51 DISPLAY_TYPE VARCHAR2(40),
52 CONVERT_TO_ID_FLAG VARCHAR2(1),
53 ID_USED_FLAG VARCHAR2(01),
54 CURRENCY_CODE VARCHAR2(10),
55 LOW_VALUE_CHAR_ID NUMBER
56 );
57
58
59 PROCEDURE Generate_API(ERRBUF OUT NOCOPY VARCHAR2,
60 RETCODE OUT NOCOPY VARCHAR2,
61 p_Source_Id IN NUMBER, --may want to pass the source Id to make things faster
62 p_Qualifier_Type_Id IN NUMBER,
63 p_Record_Limit IN NUMBER DEFAULT 100,
64 p_Debug_Flag IN VARCHAR2,
65 p_SQL_Trace IN VARCHAR2);
66
67 FUNCTION Build_Rule_Expression(p_Terr_Id IN NUMBER,
68 p_Start_Date IN DATE,
69 p_End_Date IN DATE)
70 return BOOLEAN;
71
72 -- Package spec
73 END JTF_TERR_ENGINE_GEN_PVT;