PACKAGE: APPS.JTF_TTY_NA_GEO_TERR_PVT

Source

1 PACKAGE JTF_TTY_NA_GEO_TERR_PVT AS
2 /* $Header: jtfvnats.pls 120.0 2005/06/02 18:22:12 appldev ship $ */
3 --    Start of Comments
4 --    ---------------------------------------------------
5 --    OLD PACKAGE NAME:   JTF_TERR_ENGINE_GEN_PVT
6 --    PACKAGE NAME:   JTF_TTY_NA_GEO_TERR_PVT
7 --    ---------------------------------------------------
8 --    PURPOSE
9 --      This Package will create the physical territories for the
10 --      self-service named accounts and geography territories
11 --
12 --      Procedures:
13 --         (see below for specification)
14 --
15 --    NOTES
16 --      This package is not publicly available for use
17 --
18 --    HISTORY
19 --      08/09/03    JRADHAKR         Created by Moving the named account
20 --                                   procedure from JTF_TERR_ENGINE_GEN_PVT
21 --
22 --    End of Comments
23 --
24 -- Identifies the Package associated with
25 -- a territory with child nodes
26 --
27  TYPE Terr_Package_Spec       IS RECORD
28  (
29     TERR_ID                 NUMBER,
30     PACKAGE_COUNT           NUMBER
31  );
32  TYPE Terr_PkgSpec_Tbl_Type         IS TABLE OF  Terr_Package_Spec
33                                    INDEX BY BINARY_INTEGER;
34 
35 TYPE TERR_GRP_REC_TYPE IS RECORD
36 (
37      TERR_GROUP_ID            NUMBER,
38      TERR_GROUP_NAME          VARCHAR2(150),
39      RANK                     NUMBER,
40      ACTIVE_FROM_DATE         DATE,
41      ACTIVE_TO_DATE           DATE,
42      PARENT_TERR_ID           NUMBER,
43      MATCHING_RULE_CODE       VARCHAR2(30),
44      CREATED_BY               NUMBER(15),
45      CREATION_DATE            DATE,
46      LAST_UPDATED_BY          NUMBER(15),
47      LAST_UPDATE_DATE         DATE,
48      LAST_UPDATE_LOGIN        NUMBER,
49      Catch_all_resource_id    NUMBER,
50      catch_all_resource_type  VARCHAR2(30),
51      generate_catchall_flag   VARCHAR2(1),
52      NUM_WINNERS              NUMBER
53 );
54 
55 
56 
57  PROCEDURE generate_named_overlay_terr(p_mode VARCHAR2);
58 
59 
60 END JTF_TTY_NA_GEO_TERR_PVT;