[Home] [Help]
PACKAGE: APPS.JTY_TERR_ENGINE_GEN_PVT
Source
1 Package JTY_TERR_ENGINE_GEN_PVT AUTHID CURRENT_USER AS
2 /* $Header: jtfytegs.pls 120.2 2006/03/20 10:54:54 achanda noship $ */
3 -- Start of Comments
4 -- ---------------------------------------------------
5 -- PACKAGE NAME: JTY_TERR_ENGINE_GEN_PVT
6 -- ---------------------------------------------------
7 -- PURPOSE
8 -- This package is used to generate the complete territory
9 -- Engine based on tha data setup in the JTF territory tables
10 --
11 -- Procedures:
12 -- (see below for specification)
13 --
14 -- NOTES
15 -- This package is publicly available for use
16 --
17 -- HISTORY
18 -- 07/17/05 ACHANDA Created
19 --
20 -- End of Comments
21
22 TYPE Terr_Package_Spec IS RECORD
23 (
24 TERR_ID NUMBER,
25 PACKAGE_COUNT NUMBER
26 );
27 TYPE Terr_PkgSpec_Tbl_Type IS TABLE OF Terr_Package_Spec INDEX BY BINARY_INTEGER;
28
29
30 TYPE TERR_VALUE_REC_TYPE IS RECORD
31 (
32 COMPARISON_OPERATOR VARCHAR2(30),
33 INCLUDE_FLAG VARCHAR2(15),
34 QUAL_COL1 VARCHAR2(30),
35 QUAL_COL1_TABLE VARCHAR2(30),
36 QUAL_COL1_ALIAS VARCHAR2(60),
37 PRIM_INT_CDE_COL_ALIAS VARCHAR2(60),
38 SEC_INT_CDE_COL_ALIAS VARCHAR2(60),
39 LOW_VALUE_CHAR VARCHAR2(60),
40 HIGH_VALUE_CHAR VARCHAR2(60),
41 LOW_VALUE_NUMBER NUMBER,
42 HIGH_VALUE_NUMBER NUMBER,
43 INTEREST_TYPE_ID NUMBER,
44 PRIMARY_INTEREST_CODE_ID NUMBER,
45 SECONDARY_INTEREST_CODE_ID NUMBER,
46 DISPLAY_TYPE VARCHAR2(40),
47 CONVERT_TO_ID_FLAG VARCHAR2(1),
48 ID_USED_FLAG VARCHAR2(01),
49 CURRENCY_CODE VARCHAR2(10),
50 LOW_VALUE_CHAR_ID NUMBER
51 );
52
53 TYPE terr_change_type IS RECORD (
54 terr_id jtf_terr_number_list := jtf_terr_number_list(),
55 rank_calc_flag jtf_terr_char_360list := jtf_terr_char_360list(),
56 attr_processing_flag jtf_terr_char_360list := jtf_terr_char_360list(),
57 hier_processing_flag jtf_terr_char_360list := jtf_terr_char_360list(),
58 matching_sql_flag jtf_terr_char_360list := jtf_terr_char_360list(),
59 terr_rank jtf_terr_number_list := jtf_terr_number_list(),
60 parent_terr_id jtf_terr_number_list := jtf_terr_number_list(),
61 level_from_root jtf_terr_number_list := jtf_terr_number_list(),
62 num_winners jtf_terr_number_list := jtf_terr_number_list(),
63 org_id jtf_terr_number_list := jtf_terr_number_list(),
64 parent_num_winners jtf_terr_number_list := jtf_terr_number_list(),
65 start_date jtf_terr_date_list := jtf_terr_date_list(),
66 end_date jtf_terr_date_list := jtf_terr_date_list()
67 );
68
69 TYPE qual_prd_tbl_type IS TABLE OF jtf_terr_qtype_usgs_all.qual_relation_product%TYPE;
70
71 PROCEDURE gen_rule_engine(ERRBUF OUT NOCOPY VARCHAR2,
72 RETCODE OUT NOCOPY VARCHAR2,
73 p_Source_Id IN NUMBER,
74 p_mode IN VARCHAR2,
75 p_start_date IN VARCHAR2,
76 p_end_date IN VARCHAR2);
77
78 END JTY_TERR_ENGINE_GEN_PVT;