PACKAGE: APPS.JTF_TERR_ENGINE_GEN2_PVT

Source

1 Package JTF_TERR_ENGINE_GEN2_PVT AUTHID CURRENT_USER AS
2 /* $Header: jtfvtses.pls 120.0 2005/06/02 18:23:03 appldev ship $ */
3 --    Start of Comments
4 --    ---------------------------------------------------
5 --    PACKAGE NAME:   JTF_TERR_ENGINE_GEN2_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 --      11/13/00    JDOCHERT         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 (
60       errbuf                OUT NOCOPY      VARCHAR2,
61       retcode               OUT NOCOPY      VARCHAR2,
62       p_source_id           IN       NUMBER,
63       p_qualifier_type_id   IN       NUMBER,
64       p_debug_flag          IN       VARCHAR2,
65       p_sql_trace           IN       VARCHAR2
66    );
67 
68 -- Package spec
69 END JTF_TERR_ENGINE_GEN2_PVT;