1 PACKAGE JTF_TTY_NA_TERRGP AUTHID CURRENT_USER AS
2 /* $Header: jtfttgps.pls 120.2 2005/08/21 23:22:48 spai ship $ */
3 -- Start of Comments
4 -- PURPOSE
5 -- Custom Assignment API
6 --
7 -- NOTES
8 -- ORACLE INTERNAL USE ONLY: NOT for customer use
9 --
10 -- HISTORY
11 -- 03/18/02 SGKUMAR Created
12 -- 03/20/02 SGKUMAR Created procedure insert_qualifiers
13 -- 03/20/02 SGKUMAR Created procedure set_winners
14 -- 07/08/03 SGKUMAR Created procedure log_event
15 -- 04/19/05 JRADHAKR Added procedure create_acct_mappings
16 -- to fix bug 3981210
17 -- End of Comments
18 ----
19 TYPE mytabletype IS TABLE OF NUMBER;
20 TYPE mytabletypev IS TABLE OF VARCHAR2(60);
21
22
23 PROCEDURE delete_terrgp(p_terr_gp_id IN NUMBER);
24 PROCEDURE delete_terrgp_owners_roles(p_terr_gp_id IN NUMBER);
25 PROCEDURE terrgp_define_role(p_terr_gp_id IN NUMBER,
26 p_terr_gp_role_id IN NUMBER,
27 p_user_id IN NUMBER,
28 p_role_code IN VARCHAR2);
29 PROCEDURE terrgp_create_access(p_terr_gp_id IN NUMBER,
30 p_terr_gp_role_id IN NUMBER,
31 p_access_type IN VARCHAR2,
32 p_access_code IN VARCHAR2,
33 p_user_id IN NUMBER);
34 PROCEDURE terrgp_define_interest(p_terr_gp_role_id IN NUMBER,
35 p_interest_type_id IN NUMBER,
36 p_cat_set_id IN NUMBER,
37 p_cat_enabled_flag IN VARCHAR2,
38 p_user_id IN NUMBER);
39 PROCEDURE enter_terrgp_details(p_terr_gp_id IN NUMBER,
40 p_terr_gp_name IN VARCHAR2,
41 p_description IN VARCHAR2,
42 p_rank IN NUMBER,
43 p_from_date IN DATE,
44 p_end_date IN DATE,
45 p_terr_id IN NUMBER,
46 p_user_id IN NUMBER,
47 p_matching_rule_code IN VARCHAR2 DEFAULT '1',
48 p_workflow_item_type IN VARCHAR2 DEFAULT NULL,
49 p_action_type IN VARCHAR2 DEFAULT 'INSERT',
50 p_catch_all_user_id IN NUMBER,
51 p_num_winners IN NUMBER,
52 p_generate_na_flag IN VARCHAR2,
53 p_group_type IN VARCHAR2 DEFAULT 'NAMED_ACCOUNT');
54 PROCEDURE add_orgs_to_terrgp(p_terr_gp_id IN NUMBER,
55 p_party_id IN NUMBER,
56 p_resource_id IN NUMBER,
57 p_role_id IN NUMBER,
58 p_user_id IN NUMBER,
59 p_rsc_group_id IN NUMBER);
60 PROCEDURE terrgp_define_access(p_terr_gp_id IN NUMBER,
61 p_terr_gp_role_id IN NUMBER,
62 p_role_code IN VARCHAR2,
63 p_access_type IN VARCHAR2,
64 p_user_id IN NUMBER,
65 p_interest_type_id IN NUMBER DEFAULT NULL);
66 PROCEDURE terrgp_assign_owners(p_terr_gp_id IN NUMBER,
67 p_rsc_gp_id IN NUMBER,
68 p_resource_id IN NUMBER,
69 p_role_code IN VARCHAR2,
70 p_user_id IN NUMBER,
71 p_resource_type IN VARCHAR2 DEFAULT 'RS_EMPLOYEE');
72 PROCEDURE get_site_type(p_party_id IN NUMBER,
73 x_party_type OUT NOCOPY VARCHAR2);
74 PROCEDURE create_tgp_named_account(p_terr_gp_id IN NUMBER,
75 p_party_id IN NUMBER,
76 p_user_id IN NUMBER,
77 x_gp_acct_id OUT NOCOPY NUMBER);
78 PROCEDURE delete_tgp_named_account(p_terr_gp_id IN NUMBER,
79 p_party_id IN NUMBER,
80 p_tga_id IN NUMBER);
81 PROCEDURE delete_assign_accts(p_terr_gp_id IN NUMBER,
82 p_resource_id IN NUMBER,
83 p_group_id IN NUMBER,
84 p_role_code IN VARCHAR2);
85 PROCEDURE assign_accts(p_terr_gp_id IN NUMBER,
86 p_resource_id IN NUMBER,
87 p_group_id IN NUMBER,
88 p_role_code IN VARCHAR2,
89 p_action_type IN VARCHAR2,
90 p_user_id IN NUMBER);
91 PROCEDURE assign_acct(p_terr_gp_id IN NUMBER,
92 p_terr_gp_acct_id IN NUMBER,
93 p_resource_id IN NUMBER,
94 p_group_id IN NUMBER,
95 p_role_code IN VARCHAR2,
96 p_action_type IN VARCHAR2,
97 p_user_id IN NUMBER);
98
99 PROCEDURE sum_accts(p_user_id IN NUMBER);
100 PROCEDURE sum_owner_accts(p_user_id IN NUMBER,
101 p_terr_gp_id IN NUMBER,
102 p_action_type IN VARCHAR2);
103 PROCEDURE sum_res_gp_accts(p_user_id IN NUMBER,
104 p_resource_id IN NUMBER,
105 p_rsc_group_id IN NUMBER);
106 PROCEDURE process_assign_accts(p_terr_gp_id IN NUMBER,
107 p_DownerRsc IN VARCHAR2,
108 p_NownerRsc IN VARCHAR2,
109 p_DownerGrp IN VARCHAR2,
110 p_NownerGrp IN VARCHAR2,
111 p_DownerRole IN VARCHAR2,
112 p_NownerRole IN VARCHAR2
113 );
114 PROCEDURE generateNumList(
115 SourceStr IN VARCHAR2,
116 TargetTab OUT NOCOPY mytabletype
117 );
118
119 PROCEDURE generateStrList(
120 SourceStr IN VARCHAR2,
121 TargetTab OUT NOCOPY mytabletypev
122 );
123
124 PROCEDURE check_hierarchy(x_hierarchy_status OUT NOCOPY VARCHAR2,
125 p_group_id1 IN VARCHAR2,
126 p_group_id2 IN VARCHAR2);
127 PROCEDURE sum_rm_bin(x_return_status OUT NOCOPY VARCHAR2,
128 x_error_message OUT NOCOPY VARCHAR2);
129
130 PROCEDURE create_acct_mappings(p_acct_id IN NUMBER,
131 p_party_id IN NUMBER,
132 p_user_id IN NUMBER);
133
134 PROCEDURE log_event(p_object_id IN NUMBER,
135 p_action_type IN VARCHAR2,
136 p_from_where IN VARCHAR2,
137 p_object_type IN VARCHAR2,
138 p_user_id IN NUMBER);
139
140 PROCEDURE delete_bulk_TGA(p_tga_id_str IN VARCHAR2,
141 p_terr_gp_id_str IN VARCHAR2,
142 p_named_acct_id_str IN VARCHAR2,
143 p_change_type IN VARCHAR2,
144 x_return_status OUT NOCOPY VARCHAR2,
145 x_msg_count OUT NOCOPY NUMBER,
146 x_msg_data OUT NOCOPY VARCHAR2);
147
148 END JTF_TTY_NA_TERRGP;