1 Package JTF_TTY_GEN_TERR_PVT AUTHID CURRENT_USER AS
2 /* $Header: jtftssts.pls 120.6 2006/07/11 21:24:53 mhtran ship $ */
3 -- Start of Comments
4 -- ---------------------------------------------------
5 -- PACKAGE NAME: JTF_TTY_GEN_TERR_PVT
6 -- ---------------------------------------------------
7 -- PURPOSE
8 -- This package is used to generate the territories
9 -- based on different events like create territory group
10 -- update of a named account, etc.
11 -- Procedures:
12 -- (see below for specification)
13 --
14 -- NOTES
15 -- This package is publicly available for use
16 --
17 -- HISTORY
18 -- 12/07/04 SGKUMAR Created
19 --
20 -- End of Comments
21
22 PROCEDURE generate_terr (
23 errbuf OUT NOCOPY VARCHAR2,
24 retcode OUT NOCOPY VARCHAR2,
25 p_mode IN VARCHAR2,
26 p_number_of_workers IN NUMBER,
27 p_debug_flag IN VARCHAR2,
28 p_sql_trace IN VARCHAR2);
29 /*----------------------------------------------------------
30 This procedure will create territories for territory group
31 which is updated or created. E.g. from create or update TG
32 ----------------------------------------------------------*/
33 PROCEDURE create_terr_for_TG(p_terr_group_id IN NUMBER
34 ,p_territory_type IN VARCHAR2
35 ,p_change_type IN VARCHAR2
36 ,p_terr_type_id IN VARCHAR2
37 ,p_terr_id IN VARCHAR2
38 ,p_terr_creation_flag IN VARCHAR2);
39
40 PROCEDURE delete_catch_all_terr_for_TG(p_terr_group_id IN NUMBER);
41
42
43 PROCEDURE delete_TGA(p_terr_grp_acct_id IN NUMBER
44 ,p_terr_group_id IN NUMBER
45 ,p_catchall_terr_id IN NUMBER
46 ,p_change_type IN VARCHAR2);
47
48 PROCEDURE Delete_Territory_or_tg(p_terr_Id IN VARCHAR2);
49
50 PROCEDURE delete_catchall_terrrsc_for_TG(p_terr_group_id IN NUMBER);
51
52 PROCEDURE create_catchall_terr_rsc(p_terr_group_id IN NUMBER
53 ,p_org_id IN VARCHAR2
54 ,p_resource_id IN NUMBER
55 ,p_role_code IN VARCHAR2
56 ,p_group_id IN NUMBER
57 ,p_user_id IN NUMBER);
58
59 /*----------------------------------------------------------
60 This procedure will delete territories for territory group
61 which is deleted. E.g. from Territory Groups Page
62 ----------------------------------------------------------*/
63 PROCEDURE delete_TG(p_terr_grp_id IN NUMBER,
64 p_terr_id IN VARCHAR2,
65 p_terr_creation_flag IN VARCHAR2
66 );
67 /*----------------------------------------------------------
68 This procedure will create or recreate territories for affected
69 tgas for named account
70 ----------------------------------------------------------*/
71 PROCEDURE create_terr_for_na(p_terr_grp_acct_id IN NUMBER,
72 p_terr_grp_id IN NUMBER );
73 /*----------------------------------------------------------
74 This procedure will create or recreate territories for affected
75 geography territory
76 ----------------------------------------------------------*/
77 PROCEDURE create_terr_for_gt(p_geo_terr_id IN NUMBER
78 ,p_from_where IN VARCHAR2);
79
80 /*----------------------------------------------------------
81 This procedure will delete territories from the JTF_TERR...
82 tables for the specified Terr Group Account Ids.
83 ----------------------------------------------------------*/
84 PROCEDURE delete_bulk_TGA(p_terrGrpId_tbl IN jtf_terr_number_list,
85 p_grpAcctId_tbl IN jtf_terr_number_list,
86 p_change_type IN VARCHAR2,
87 x_return_status OUT NOCOPY VARCHAR2,
88 x_msg_count OUT NOCOPY NUMBER,
89 x_msg_data OUT NOCOPY VARCHAR2);
90
91
92 /*----------------------------------------------------------
93 This procedure will update the sales team for a named account in
94 a territory group
95 ----------------------------------------------------------*/
96 PROCEDURE update_terr_rscs_for_na(p_terr_grp_acct_id IN NUMBER,
97 p_terr_group_id IN NUMBER);
98
99 PROCEDURE update_terr_for_na(p_terr_grp_acct_id IN NUMBER,
100 p_terr_group_id IN NUMBER);
101
102
103 END JTF_TTY_GEN_TERR_PVT;