76: --
77: --
78: -- Parameters :
79: -- IN : p_api_version NUMBER Required
80: -- p_init_msg_list VARCHAR2 Optional (FND_API.G_FALSE)
81: -- p_commit VARCHAR2 Optional (FND_API.G_FALSE)
82: -- p_validation_level NUMBER Optional (FND_API.G_VALID_LEVEL_FULL)
83: -- OUT : x_return_status VARCHAR2(1)
84: -- x_msg_count NUMBER
77: --
78: -- Parameters :
79: -- IN : p_api_version NUMBER Required
80: -- p_init_msg_list VARCHAR2 Optional (FND_API.G_FALSE)
81: -- p_commit VARCHAR2 Optional (FND_API.G_FALSE)
82: -- p_validation_level NUMBER Optional (FND_API.G_VALID_LEVEL_FULL)
83: -- OUT : x_return_status VARCHAR2(1)
84: -- x_msg_count NUMBER
85: -- x_msg_data VARCHAR2(2000)
78: -- Parameters :
79: -- IN : p_api_version NUMBER Required
80: -- p_init_msg_list VARCHAR2 Optional (FND_API.G_FALSE)
81: -- p_commit VARCHAR2 Optional (FND_API.G_FALSE)
82: -- p_validation_level NUMBER Optional (FND_API.G_VALID_LEVEL_FULL)
83: -- OUT : x_return_status VARCHAR2(1)
84: -- x_msg_count NUMBER
85: -- x_msg_data VARCHAR2(2000)
86: -- IN :
97: -- End of comments
98:
99: PROCEDURE get_active_role
100: ( p_api_version IN NUMBER,
101: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
102: p_commit IN VARCHAR2 := FND_API.G_FALSE,
103: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
104: x_return_status OUT NOCOPY VARCHAR2,
105: x_msg_count OUT NOCOPY NUMBER,
98:
99: PROCEDURE get_active_role
100: ( p_api_version IN NUMBER,
101: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
102: p_commit IN VARCHAR2 := FND_API.G_FALSE,
103: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
104: x_return_status OUT NOCOPY VARCHAR2,
105: x_msg_count OUT NOCOPY NUMBER,
106: x_msg_data OUT NOCOPY VARCHAR2,
99: PROCEDURE get_active_role
100: ( p_api_version IN NUMBER,
101: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
102: p_commit IN VARCHAR2 := FND_API.G_FALSE,
103: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
104: x_return_status OUT NOCOPY VARCHAR2,
105: x_msg_count OUT NOCOPY NUMBER,
106: x_msg_data OUT NOCOPY VARCHAR2,
107: p_org_id IN NUMBER,
109: x_role OUT NOCOPY role_tbl_type);
110:
111: PROCEDURE get_active_group_member
112: ( p_api_version IN NUMBER,
113: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
114: p_commit IN VARCHAR2 := FND_API.G_FALSE,
115: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
116: x_return_status OUT NOCOPY VARCHAR2,
117: x_msg_count OUT NOCOPY NUMBER,
110:
111: PROCEDURE get_active_group_member
112: ( p_api_version IN NUMBER,
113: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
114: p_commit IN VARCHAR2 := FND_API.G_FALSE,
115: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
116: x_return_status OUT NOCOPY VARCHAR2,
117: x_msg_count OUT NOCOPY NUMBER,
118: x_msg_data OUT NOCOPY VARCHAR2,
111: PROCEDURE get_active_group_member
112: ( p_api_version IN NUMBER,
113: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
114: p_commit IN VARCHAR2 := FND_API.G_FALSE,
115: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
116: x_return_status OUT NOCOPY VARCHAR2,
117: x_msg_count OUT NOCOPY NUMBER,
118: x_msg_data OUT NOCOPY VARCHAR2,
119: p_org_id IN NUMBER,
121: x_group_mem OUT NOCOPY group_mem_tbl_type);
122:
123: PROCEDURE get_active_group_member
124: ( p_api_version IN NUMBER,
125: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
126: p_commit IN VARCHAR2 := FND_API.G_FALSE,
127: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
128: x_return_status OUT NOCOPY VARCHAR2,
129: x_msg_count OUT NOCOPY NUMBER,
122:
123: PROCEDURE get_active_group_member
124: ( p_api_version IN NUMBER,
125: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
126: p_commit IN VARCHAR2 := FND_API.G_FALSE,
127: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
128: x_return_status OUT NOCOPY VARCHAR2,
129: x_msg_count OUT NOCOPY NUMBER,
130: x_msg_data OUT NOCOPY VARCHAR2,
123: PROCEDURE get_active_group_member
124: ( p_api_version IN NUMBER,
125: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
126: p_commit IN VARCHAR2 := FND_API.G_FALSE,
127: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
128: x_return_status OUT NOCOPY VARCHAR2,
129: x_msg_count OUT NOCOPY NUMBER,
130: x_msg_data OUT NOCOPY VARCHAR2,
131: p_org_id IN NUMBER,
133: x_group_mem OUT NOCOPY srp_group_tbl_type);
134:
135: PROCEDURE get_active_group
136: ( p_api_version IN NUMBER,
137: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
138: p_commit IN VARCHAR2 := FND_API.G_FALSE,
139: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
140: x_return_status OUT NOCOPY VARCHAR2,
141: x_msg_count OUT NOCOPY NUMBER,
134:
135: PROCEDURE get_active_group
136: ( p_api_version IN NUMBER,
137: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
138: p_commit IN VARCHAR2 := FND_API.G_FALSE,
139: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
140: x_return_status OUT NOCOPY VARCHAR2,
141: x_msg_count OUT NOCOPY NUMBER,
142: x_msg_data OUT NOCOPY VARCHAR2,
135: PROCEDURE get_active_group
136: ( p_api_version IN NUMBER,
137: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
138: p_commit IN VARCHAR2 := FND_API.G_FALSE,
139: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
140: x_return_status OUT NOCOPY VARCHAR2,
141: x_msg_count OUT NOCOPY NUMBER,
142: x_msg_data OUT NOCOPY VARCHAR2,
143: p_org_id IN NUMBER,
145: x_active_group OUT NOCOPY active_group_tbl_type);
146:
147: PROCEDURE get_ancestor_group
148: ( p_api_version IN NUMBER,
149: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
150: p_commit IN VARCHAR2 := FND_API.G_FALSE,
151: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
152: x_return_status OUT NOCOPY VARCHAR2,
153: x_msg_count OUT NOCOPY NUMBER,
146:
147: PROCEDURE get_ancestor_group
148: ( p_api_version IN NUMBER,
149: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
150: p_commit IN VARCHAR2 := FND_API.G_FALSE,
151: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
152: x_return_status OUT NOCOPY VARCHAR2,
153: x_msg_count OUT NOCOPY NUMBER,
154: x_msg_data OUT NOCOPY VARCHAR2,
147: PROCEDURE get_ancestor_group
148: ( p_api_version IN NUMBER,
149: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
150: p_commit IN VARCHAR2 := FND_API.G_FALSE,
151: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
152: x_return_status OUT NOCOPY VARCHAR2,
153: x_msg_count OUT NOCOPY NUMBER,
154: x_msg_data OUT NOCOPY VARCHAR2,
155: p_group IN group_rec_type,
156: x_group OUT NOCOPY group_tbl_type);
157:
158: PROCEDURE get_descendant_group
159: ( p_api_version IN NUMBER,
160: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
161: p_commit IN VARCHAR2 := FND_API.G_FALSE,
162: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
163: x_return_status OUT NOCOPY VARCHAR2,
164: x_msg_count OUT NOCOPY NUMBER,
157:
158: PROCEDURE get_descendant_group
159: ( p_api_version IN NUMBER,
160: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
161: p_commit IN VARCHAR2 := FND_API.G_FALSE,
162: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
163: x_return_status OUT NOCOPY VARCHAR2,
164: x_msg_count OUT NOCOPY NUMBER,
165: x_msg_data OUT NOCOPY VARCHAR2,
158: PROCEDURE get_descendant_group
159: ( p_api_version IN NUMBER,
160: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
161: p_commit IN VARCHAR2 := FND_API.G_FALSE,
162: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
163: x_return_status OUT NOCOPY VARCHAR2,
164: x_msg_count OUT NOCOPY NUMBER,
165: x_msg_data OUT NOCOPY VARCHAR2,
166: p_group IN group_rec_type,
167: x_group OUT NOCOPY group_tbl_type);
168:
169: PROCEDURE get_ancestor_salesrep
170: ( p_api_version IN NUMBER,
171: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
172: p_commit IN VARCHAR2 := FND_API.G_FALSE,
173: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
174: x_return_status OUT NOCOPY VARCHAR2,
175: x_msg_count OUT NOCOPY NUMBER,
168:
169: PROCEDURE get_ancestor_salesrep
170: ( p_api_version IN NUMBER,
171: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
172: p_commit IN VARCHAR2 := FND_API.G_FALSE,
173: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
174: x_return_status OUT NOCOPY VARCHAR2,
175: x_msg_count OUT NOCOPY NUMBER,
176: x_msg_data OUT NOCOPY VARCHAR2,
169: PROCEDURE get_ancestor_salesrep
170: ( p_api_version IN NUMBER,
171: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
172: p_commit IN VARCHAR2 := FND_API.G_FALSE,
173: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
174: x_return_status OUT NOCOPY VARCHAR2,
175: x_msg_count OUT NOCOPY NUMBER,
176: x_msg_data OUT NOCOPY VARCHAR2,
177: p_org_id IN NUMBER,
179: x_srp OUT NOCOPY srp_group_tbl_type);
180:
181: PROCEDURE get_descendant_salesrep
182: ( p_api_version IN NUMBER,
183: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
184: p_commit IN VARCHAR2 := FND_API.G_FALSE,
185: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
186: x_return_status OUT NOCOPY VARCHAR2,
187: x_msg_count OUT NOCOPY NUMBER,
180:
181: PROCEDURE get_descendant_salesrep
182: ( p_api_version IN NUMBER,
183: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
184: p_commit IN VARCHAR2 := FND_API.G_FALSE,
185: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
186: x_return_status OUT NOCOPY VARCHAR2,
187: x_msg_count OUT NOCOPY NUMBER,
188: x_msg_data OUT NOCOPY VARCHAR2,
181: PROCEDURE get_descendant_salesrep
182: ( p_api_version IN NUMBER,
183: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
184: p_commit IN VARCHAR2 := FND_API.G_FALSE,
185: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
186: x_return_status OUT NOCOPY VARCHAR2,
187: x_msg_count OUT NOCOPY NUMBER,
188: x_msg_data OUT NOCOPY VARCHAR2,
189: p_org_id IN NUMBER,
191: x_srp OUT NOCOPY srp_group_tbl_type);
192:
193: PROCEDURE get_descendant_salesrep
194: ( p_api_version IN NUMBER,
195: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
196: p_commit IN VARCHAR2 := FND_API.G_FALSE,
197: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
198: x_return_status OUT NOCOPY VARCHAR2,
199: x_msg_count OUT NOCOPY NUMBER,
192:
193: PROCEDURE get_descendant_salesrep
194: ( p_api_version IN NUMBER,
195: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
196: p_commit IN VARCHAR2 := FND_API.G_FALSE,
197: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
198: x_return_status OUT NOCOPY VARCHAR2,
199: x_msg_count OUT NOCOPY NUMBER,
200: x_msg_data OUT NOCOPY VARCHAR2,
193: PROCEDURE get_descendant_salesrep
194: ( p_api_version IN NUMBER,
195: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
196: p_commit IN VARCHAR2 := FND_API.G_FALSE,
197: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
198: x_return_status OUT NOCOPY VARCHAR2,
199: x_msg_count OUT NOCOPY NUMBER,
200: x_msg_data OUT NOCOPY VARCHAR2,
201: p_org_id IN NUMBER,