1 PACKAGE JTF_TTY_GEO_TERRGP AUTHID CURRENT_USER AS
2 /* $Header: jtftggps.pls 120.2 2005/09/23 16:24:21 jradhakr ship $ */
3 -- Start of Comments
4 -- PURPOSE
5 -- For handling Geography Territor Groups, like delete,create,update
6 --
7 -- NOTES
8 -- ORACLE INTERNAL USE ONLY: NOT for customer use
9 --
10 -- HISTORY
11 -- 06/02/02 SGKUMAR Created
12 -- 11/09/04 SGKUMAR Added procedure replace_geo_terr_rsc for 3889970
13 -- End of Comments
14 ----
15
16 PROCEDURE POPULATE_SELF_SRV_SCHEMA (p_terr_id IN NUMBER
17 , x_return_status OUT NOCOPY VARCHAR2
18 , x_msg_count OUT NOCOPY VARCHAR2
19 , x_msg_data OUT NOCOPY VARCHAR2);
20
21 PROCEDURE delete_terrgp(p_terr_gp_id IN NUMBER);
22 PROCEDURE add_geo_to_grp(p_terr_gp_id IN NUMBER,
23 p_geo_id_from IN NUMBER,
24 p_geo_id_to IN NUMBER,
25 p_operator IN VARCHAR2,
26 p_geo_type IN VARCHAR2,
27 p_user_id IN NUMBER);
28 PROCEDURE create_grp_geo_terr(p_terr_gp_id IN NUMBER,
29 p_user_id IN NUMBER);
30 PROCEDURE delete_geos_from_terrs(p_terr_gp_id IN NUMBER);
31 PROCEDURE delete_geo_from_grp(p_terr_gp_id IN NUMBER);
32 PROCEDURE update_geo_grp_assignments (p_terr_gp_id IN NUMBER);
33 PROCEDURE assign_geo_terr(p_territory_id IN NUMBER,
34 p_resource_id IN NUMBER,
35 p_rsc_group_id IN NUMBER,
36 p_rsc_role_code IN VARCHAR2);
37 PROCEDURE delete_geo_terr_rsc (p_territory_id IN NUMBER,
38 p_resource_id IN NUMBER,
39 p_rsc_group_id IN NUMBER,
40 p_rsc_role_code IN VARCHAR2);
41
42 PROCEDURE replace_geo_terr_rsc(p_territory_id IN NUMBER,
43 p_new_owner_resource_id IN NUMBER,
44 p_rsc_group_id IN NUMBER,
45 p_rsc_role_code IN VARCHAR2,
46 p_replaced_owner_resource_id IN NUMBER);
47 end JTF_TTY_GEO_TERRGP;