PACKAGE: APPS.JTF_TAE_GEN_PVT

Source

1 Package JTF_TAE_GEN_PVT AUTHID CURRENT_USER AS
2 /* $Header: jtfvtaes.pls 120.0 2005/06/02 18:22:35 appldev ship $ */
3 --    Start of Comments
4 --    ---------------------------------------------------
5 --    PACKAGE NAME:   JTF_TAE_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 TAE tables
11 --
12 --      Procedures:
13 --         (see below for specification)
14 --
15 --    NOTES
16 --      This package is publicly available for use
17 --
18 --    HISTORY
19 --      02/25/02    SBEHERA         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   TYPE terr_sql_typ is record (
59         terr_id     number,
60         terr_sql       varchar2(32767));
61    TYPE Terrsql_tbl_type   IS TABLE OF   terr_sql_typ
62         INDEX BY BINARY_INTEGER;
63 
64 
65 PROCEDURE Generate_API(ERRBUF                 OUT NOCOPY    VARCHAR2,
66                          RETCODE              OUT NOCOPY    VARCHAR2,
67                          p_source_id             IN       NUMBER,
68                          p_trans_object_type_id IN     NUMBER,
69                          p_target_type        IN     VARCHAR2,
70                          p_Debug_Flag         IN     VARCHAR2,
71                          p_SQL_Trace          IN     VARCHAR2);
72 
73 
74 PROCEDURE gen_details_for_terr_change (
75       p_source_id             IN       NUMBER,
76       p_qual_type_id        IN       NUMBER,
77       p_view_name           IN       VARCHAR2,
78       p_sql                 OUT  NOCOPY terrsql_tbl_type
79       );
80 
81 --ARPATEL bug#3194930 fix
82 PROCEDURE write_buffer_content(
83       l_qual_rules   VARCHAR2
84    );
85 
86 -- Package spec
87 END JTF_TAE_GEN_PVT;