APPS.CN_SRP_HIER_PROC_PVT dependencies on FND_API

Line 78: -- Default = FND_API.G_FALSE

74: -- Pre-reqs : None.
75: -- Parameters :
76: -- IN : p_api_version IN NUMBER Required
77: -- p_init_msg_list IN VARCHAR2 Optional
78: -- Default = FND_API.G_FALSE
79: -- p_commit IN VARCHAR2 Optional
80: -- Default = FND_API.G_FALSE
81: -- p_validation_level IN NUMBER Optional
82: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 80: -- Default = FND_API.G_FALSE

76: -- IN : p_api_version IN NUMBER Required
77: -- p_init_msg_list IN VARCHAR2 Optional
78: -- Default = FND_API.G_FALSE
79: -- p_commit IN VARCHAR2 Optional
80: -- Default = FND_API.G_FALSE
81: -- p_validation_level IN NUMBER Optional
82: -- Default = FND_API.G_VALID_LEVEL_FULL
83: -- p_salesrep_id IN NUMBER Required
84: -- p_comp_group_id IN NUMBER Required

Line 82: -- Default = FND_API.G_VALID_LEVEL_FULL

78: -- Default = FND_API.G_FALSE
79: -- p_commit IN VARCHAR2 Optional
80: -- Default = FND_API.G_FALSE
81: -- p_validation_level IN NUMBER Optional
82: -- Default = FND_API.G_VALID_LEVEL_FULL
83: -- p_salesrep_id IN NUMBER Required
84: -- p_comp_group_id IN NUMBER Required
85: -- p_effective_date IN DATE Required
86: -- OUT : x_return_status OUT VARCHAR2(1)

Line 99: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,

95: --
96: -- End of comments
97: PROCEDURE Get_Managers
98: (p_api_version IN NUMBER ,
99: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
100: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
101: p_validation_level IN NUMBER :=
102: FND_API.G_VALID_LEVEL_FULL ,
103: p_salesrep_id IN number ,

Line 100: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

96: -- End of comments
97: PROCEDURE Get_Managers
98: (p_api_version IN NUMBER ,
99: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
100: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
101: p_validation_level IN NUMBER :=
102: FND_API.G_VALID_LEVEL_FULL ,
103: p_salesrep_id IN number ,
104: p_comp_group_id IN number ,

Line 102: FND_API.G_VALID_LEVEL_FULL ,

98: (p_api_version IN NUMBER ,
99: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
100: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
101: p_validation_level IN NUMBER :=
102: FND_API.G_VALID_LEVEL_FULL ,
103: p_salesrep_id IN number ,
104: p_comp_group_id IN number ,
105: p_effective_date IN date ,
106: x_return_status OUT NOCOPY VARCHAR2 ,

Line 120: -- Default = FND_API.G_FALSE

116: -- Pre-reqs : None.
117: -- Parameters :
118: -- IN : p_api_version IN NUMBER Required
119: -- p_init_msg_list IN VARCHAR2 Optional
120: -- Default = FND_API.G_FALSE
121: -- p_commit IN VARCHAR2 Optional
122: -- Default = FND_API.G_FALSE
123: -- p_validation_level IN NUMBER Optional
124: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 122: -- Default = FND_API.G_FALSE

118: -- IN : p_api_version IN NUMBER Required
119: -- p_init_msg_list IN VARCHAR2 Optional
120: -- Default = FND_API.G_FALSE
121: -- p_commit IN VARCHAR2 Optional
122: -- Default = FND_API.G_FALSE
123: -- p_validation_level IN NUMBER Optional
124: -- Default = FND_API.G_VALID_LEVEL_FULL
125: -- p_salesrep_id IN NUMBER Required
126: -- p_comp_group_id IN NUMBER Required

Line 124: -- Default = FND_API.G_VALID_LEVEL_FULL

120: -- Default = FND_API.G_FALSE
121: -- p_commit IN VARCHAR2 Optional
122: -- Default = FND_API.G_FALSE
123: -- p_validation_level IN NUMBER Optional
124: -- Default = FND_API.G_VALID_LEVEL_FULL
125: -- p_salesrep_id IN NUMBER Required
126: -- p_comp_group_id IN NUMBER Required
127: -- p_effective_date IN DATE Required
128: -- OUT : x_return_status OUT VARCHAR2(1)

Line 141: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,

137: --
138: -- End of comments
139: PROCEDURE Get_Salesreps
140: (p_api_version IN NUMBER ,
141: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
142: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
143: p_validation_level IN NUMBER :=
144: FND_API.G_VALID_LEVEL_FULL ,
145: p_salesrep_id IN number ,

Line 142: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

138: -- End of comments
139: PROCEDURE Get_Salesreps
140: (p_api_version IN NUMBER ,
141: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
142: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
143: p_validation_level IN NUMBER :=
144: FND_API.G_VALID_LEVEL_FULL ,
145: p_salesrep_id IN number ,
146: p_comp_group_id IN number ,

Line 144: FND_API.G_VALID_LEVEL_FULL ,

140: (p_api_version IN NUMBER ,
141: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
142: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
143: p_validation_level IN NUMBER :=
144: FND_API.G_VALID_LEVEL_FULL ,
145: p_salesrep_id IN number ,
146: p_comp_group_id IN number ,
147: p_effective_date IN date ,
148: p_return_current IN varchar2 := 'N' ,

Line 163: -- Default = FND_API.G_FALSE

159: -- Pre-reqs : None.
160: -- Parameters :
161: -- IN : p_api_version IN NUMBER Required
162: -- p_init_msg_list IN VARCHAR2 Optional
163: -- Default = FND_API.G_FALSE
164: -- p_commit IN VARCHAR2 Optional
165: -- Default = FND_API.G_FALSE
166: -- p_validation_level IN NUMBER Optional
167: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 165: -- Default = FND_API.G_FALSE

161: -- IN : p_api_version IN NUMBER Required
162: -- p_init_msg_list IN VARCHAR2 Optional
163: -- Default = FND_API.G_FALSE
164: -- p_commit IN VARCHAR2 Optional
165: -- Default = FND_API.G_FALSE
166: -- p_validation_level IN NUMBER Optional
167: -- Default = FND_API.G_VALID_LEVEL_FULL
168: -- p_srp IN srp_group_rec_type Required
169: -- p_effective_date IN DATE Required

Line 167: -- Default = FND_API.G_VALID_LEVEL_FULL

163: -- Default = FND_API.G_FALSE
164: -- p_commit IN VARCHAR2 Optional
165: -- Default = FND_API.G_FALSE
166: -- p_validation_level IN NUMBER Optional
167: -- Default = FND_API.G_VALID_LEVEL_FULL
168: -- p_srp IN srp_group_rec_type Required
169: -- p_effective_date IN DATE Required
170: -- OUT : x_return_status OUT VARCHAR2(1)
171: -- x_msg_count OUT NUMBER

Line 183: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

179: --
180: -- End of comments
181: PROCEDURE Get_Ancestor_Salesreps
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 number := FND_API.G_VALID_LEVEL_FULL,
186: p_srp IN srp_group_rec_type,
187: x_return_status OUT NOCOPY VARCHAR2,

Line 184: p_commit IN VARCHAR2 := FND_API.G_FALSE,

180: -- End of comments
181: PROCEDURE Get_Ancestor_Salesreps
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 number := FND_API.G_VALID_LEVEL_FULL,
186: p_srp IN srp_group_rec_type,
187: x_return_status OUT NOCOPY VARCHAR2,
188: x_msg_count OUT NOCOPY NUMBER,

Line 185: p_validation_level IN number := FND_API.G_VALID_LEVEL_FULL,

181: PROCEDURE Get_Ancestor_Salesreps
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 number := FND_API.G_VALID_LEVEL_FULL,
186: p_srp IN srp_group_rec_type,
187: x_return_status OUT NOCOPY VARCHAR2,
188: x_msg_count OUT NOCOPY NUMBER,
189: x_msg_data OUT NOCOPY VARCHAR2,

Line 201: -- Default = FND_API.G_FALSE

197: -- Pre-reqs : None.
198: -- Parameters :
199: -- IN : p_api_version IN NUMBER Required
200: -- p_init_msg_list IN VARCHAR2 Optional
201: -- Default = FND_API.G_FALSE
202: -- p_commit IN VARCHAR2 Optional
203: -- Default = FND_API.G_FALSE
204: -- p_validation_level IN NUMBER Optional
205: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 203: -- Default = FND_API.G_FALSE

199: -- IN : p_api_version IN NUMBER Required
200: -- p_init_msg_list IN VARCHAR2 Optional
201: -- Default = FND_API.G_FALSE
202: -- p_commit IN VARCHAR2 Optional
203: -- Default = FND_API.G_FALSE
204: -- p_validation_level IN NUMBER Optional
205: -- Default = FND_API.G_VALID_LEVEL_FULL
206: -- p_srp IN srp_group_rec_type Required
207: -- p_effective_date IN DATE Required

Line 205: -- Default = FND_API.G_VALID_LEVEL_FULL

201: -- Default = FND_API.G_FALSE
202: -- p_commit IN VARCHAR2 Optional
203: -- Default = FND_API.G_FALSE
204: -- p_validation_level IN NUMBER Optional
205: -- Default = FND_API.G_VALID_LEVEL_FULL
206: -- p_srp IN srp_group_rec_type Required
207: -- p_effective_date IN DATE Required
208: -- OUT : x_return_status OUT VARCHAR2(1)
209: -- x_msg_count OUT NUMBER

Line 221: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

217: --
218: -- End of comments
219: PROCEDURE Get_Descendant_Salesreps
220: (p_api_version IN NUMBER,
221: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
222: p_commit IN VARCHAR2 := FND_API.G_FALSE,
223: p_validation_level IN number := FND_API.G_VALID_LEVEL_FULL,
224: p_srp IN srp_group_rec_type,
225: p_return_current IN varchar2 := 'Y',

Line 222: p_commit IN VARCHAR2 := FND_API.G_FALSE,

218: -- End of comments
219: PROCEDURE Get_Descendant_Salesreps
220: (p_api_version IN NUMBER,
221: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
222: p_commit IN VARCHAR2 := FND_API.G_FALSE,
223: p_validation_level IN number := FND_API.G_VALID_LEVEL_FULL,
224: p_srp IN srp_group_rec_type,
225: p_return_current IN varchar2 := 'Y',
226: x_return_status OUT NOCOPY VARCHAR2,

Line 223: p_validation_level IN number := FND_API.G_VALID_LEVEL_FULL,

219: PROCEDURE Get_Descendant_Salesreps
220: (p_api_version IN NUMBER,
221: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
222: p_commit IN VARCHAR2 := FND_API.G_FALSE,
223: p_validation_level IN number := FND_API.G_VALID_LEVEL_FULL,
224: p_srp IN srp_group_rec_type,
225: p_return_current IN varchar2 := 'Y',
226: x_return_status OUT NOCOPY VARCHAR2,
227: x_msg_count OUT NOCOPY NUMBER,

Line 241: -- Default = FND_API.G_FALSE

237: -- Pre-reqs : None.
238: -- Parameters :
239: -- IN : p_api_version IN NUMBER Required
240: -- p_init_msg_list IN VARCHAR2 Optional
241: -- Default = FND_API.G_FALSE
242: -- p_commit IN VARCHAR2 Optional
243: -- Default = FND_API.G_FALSE
244: -- p_validation_level IN NUMBER Optional
245: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 243: -- Default = FND_API.G_FALSE

239: -- IN : p_api_version IN NUMBER Required
240: -- p_init_msg_list IN VARCHAR2 Optional
241: -- Default = FND_API.G_FALSE
242: -- p_commit IN VARCHAR2 Optional
243: -- Default = FND_API.G_FALSE
244: -- p_validation_level IN NUMBER Optional
245: -- Default = FND_API.G_VALID_LEVEL_FULL
246: -- p_srp IN srp_group_rec_type Required
247: -- p_effective_date IN DATE Required

Line 245: -- Default = FND_API.G_VALID_LEVEL_FULL

241: -- Default = FND_API.G_FALSE
242: -- p_commit IN VARCHAR2 Optional
243: -- Default = FND_API.G_FALSE
244: -- p_validation_level IN NUMBER Optional
245: -- Default = FND_API.G_VALID_LEVEL_FULL
246: -- p_srp IN srp_group_rec_type Required
247: -- p_effective_date IN DATE Required
248: -- OUT : x_return_status OUT VARCHAR2(1)
249: -- x_msg_count OUT NUMBER

Line 261: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

257: --
258: -- End of comments
259: PROCEDURE Get_desc_role_info
260: (p_api_version IN NUMBER,
261: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
262: p_commit IN VARCHAR2 := FND_API.G_FALSE,
263: p_validation_level IN number := FND_API.G_VALID_LEVEL_FULL,
264: p_srp IN srp_group_rec_type,
265: p_return_current IN varchar2 := 'Y',

Line 262: p_commit IN VARCHAR2 := FND_API.G_FALSE,

258: -- End of comments
259: PROCEDURE Get_desc_role_info
260: (p_api_version IN NUMBER,
261: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
262: p_commit IN VARCHAR2 := FND_API.G_FALSE,
263: p_validation_level IN number := FND_API.G_VALID_LEVEL_FULL,
264: p_srp IN srp_group_rec_type,
265: p_return_current IN varchar2 := 'Y',
266: x_return_status OUT NOCOPY VARCHAR2,

Line 263: p_validation_level IN number := FND_API.G_VALID_LEVEL_FULL,

259: PROCEDURE Get_desc_role_info
260: (p_api_version IN NUMBER,
261: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
262: p_commit IN VARCHAR2 := FND_API.G_FALSE,
263: p_validation_level IN number := FND_API.G_VALID_LEVEL_FULL,
264: p_srp IN srp_group_rec_type,
265: p_return_current IN varchar2 := 'Y',
266: x_return_status OUT NOCOPY VARCHAR2,
267: x_msg_count OUT NOCOPY NUMBER,

Line 277: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

273: -- TBD : MO
274: -- ***********************************
275: PROCEDURE Get_MO_desc_role_info
276: (p_api_version IN NUMBER,
277: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
278: p_commit IN VARCHAR2 := FND_API.G_FALSE,
279: p_validation_level IN number := FND_API.G_VALID_LEVEL_FULL,
280: p_srp IN srp_group_rec_type,
281: p_return_current IN varchar2 := 'Y',

Line 278: p_commit IN VARCHAR2 := FND_API.G_FALSE,

274: -- ***********************************
275: PROCEDURE Get_MO_desc_role_info
276: (p_api_version IN NUMBER,
277: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
278: p_commit IN VARCHAR2 := FND_API.G_FALSE,
279: p_validation_level IN number := FND_API.G_VALID_LEVEL_FULL,
280: p_srp IN srp_group_rec_type,
281: p_return_current IN varchar2 := 'Y',
282: p_is_multiorg IN VARCHAR2 := 'N',

Line 279: p_validation_level IN number := FND_API.G_VALID_LEVEL_FULL,

275: PROCEDURE Get_MO_desc_role_info
276: (p_api_version IN NUMBER,
277: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
278: p_commit IN VARCHAR2 := FND_API.G_FALSE,
279: p_validation_level IN number := FND_API.G_VALID_LEVEL_FULL,
280: p_srp IN srp_group_rec_type,
281: p_return_current IN varchar2 := 'Y',
282: p_is_multiorg IN VARCHAR2 := 'N',
283: x_return_status OUT NOCOPY VARCHAR2,

Line 297: -- Default = FND_API.G_FALSE

293: -- Pre-reqs : None.
294: -- Parameters :
295: -- IN : p_api_version IN NUMBER Required
296: -- p_init_msg_list IN VARCHAR2 Optional
297: -- Default = FND_API.G_FALSE
298: -- p_commit IN VARCHAR2 Optional
299: -- Default = FND_API.G_FALSE
300: -- p_validation_level IN NUMBER Optional
301: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 299: -- Default = FND_API.G_FALSE

295: -- IN : p_api_version IN NUMBER Required
296: -- p_init_msg_list IN VARCHAR2 Optional
297: -- Default = FND_API.G_FALSE
298: -- p_commit IN VARCHAR2 Optional
299: -- Default = FND_API.G_FALSE
300: -- p_validation_level IN NUMBER Optional
301: -- Default = FND_API.G_VALID_LEVEL_FULL
302: -- p_srp IN srp_group_rec_type Required
303: -- p_effective_date IN DATE Required

Line 301: -- Default = FND_API.G_VALID_LEVEL_FULL

297: -- Default = FND_API.G_FALSE
298: -- p_commit IN VARCHAR2 Optional
299: -- Default = FND_API.G_FALSE
300: -- p_validation_level IN NUMBER Optional
301: -- Default = FND_API.G_VALID_LEVEL_FULL
302: -- p_srp IN srp_group_rec_type Required
303: -- p_effective_date IN DATE Required
304: -- OUT : x_return_status OUT VARCHAR2(1)
305: -- x_msg_count OUT NUMBER

Line 317: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

313: --
314: -- End of comments
315: PROCEDURE Get_descendant_group_mbrs
316: (p_api_version IN NUMBER,
317: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
318: p_commit IN VARCHAR2 := FND_API.G_FALSE,
319: p_validation_level IN number := FND_API.G_VALID_LEVEL_FULL,
320: p_srp IN srp_group_rec_type,
321: p_return_current IN varchar2 := 'Y',

Line 318: p_commit IN VARCHAR2 := FND_API.G_FALSE,

314: -- End of comments
315: PROCEDURE Get_descendant_group_mbrs
316: (p_api_version IN NUMBER,
317: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
318: p_commit IN VARCHAR2 := FND_API.G_FALSE,
319: p_validation_level IN number := FND_API.G_VALID_LEVEL_FULL,
320: p_srp IN srp_group_rec_type,
321: p_return_current IN varchar2 := 'Y',
322: p_level IN number := 0,

Line 319: p_validation_level IN number := FND_API.G_VALID_LEVEL_FULL,

315: PROCEDURE Get_descendant_group_mbrs
316: (p_api_version IN NUMBER,
317: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
318: p_commit IN VARCHAR2 := FND_API.G_FALSE,
319: p_validation_level IN number := FND_API.G_VALID_LEVEL_FULL,
320: p_srp IN srp_group_rec_type,
321: p_return_current IN varchar2 := 'Y',
322: p_level IN number := 0,
323: p_first_level_only IN varchar2 := 'N',

Line 336: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

332: -- ***********************************
333:
334: PROCEDURE Get_MO_descendant_group_mbrs
335: (p_api_version IN NUMBER,
336: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
337: p_commit IN VARCHAR2 := FND_API.G_FALSE,
338: p_validation_level IN number := FND_API.G_VALID_LEVEL_FULL,
339: p_srp IN srp_group_rec_type,
340: p_return_current IN varchar2 := 'Y',

Line 337: p_commit IN VARCHAR2 := FND_API.G_FALSE,

333:
334: PROCEDURE Get_MO_descendant_group_mbrs
335: (p_api_version IN NUMBER,
336: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
337: p_commit IN VARCHAR2 := FND_API.G_FALSE,
338: p_validation_level IN number := FND_API.G_VALID_LEVEL_FULL,
339: p_srp IN srp_group_rec_type,
340: p_return_current IN varchar2 := 'Y',
341: p_level IN number := 0,

Line 338: p_validation_level IN number := FND_API.G_VALID_LEVEL_FULL,

334: PROCEDURE Get_MO_descendant_group_mbrs
335: (p_api_version IN NUMBER,
336: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
337: p_commit IN VARCHAR2 := FND_API.G_FALSE,
338: p_validation_level IN number := FND_API.G_VALID_LEVEL_FULL,
339: p_srp IN srp_group_rec_type,
340: p_return_current IN varchar2 := 'Y',
341: p_level IN number := 0,
342: p_first_level_only IN varchar2 := 'N',

Line 362: -- Default = FND_API.G_FALSE

358: --
359: -- Parameters :
360: -- IN : p_api_version IN NUMBER Required
361: -- p_init_msg_list IN VARCHAR2 Optional
362: -- Default = FND_API.G_FALSE
363: -- p_commit IN VARCHAR2 Optional
364: -- Default = FND_API.G_FALSE
365: -- p_validation_level IN NUMBER Optional
366: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 364: -- Default = FND_API.G_FALSE

360: -- IN : p_api_version IN NUMBER Required
361: -- p_init_msg_list IN VARCHAR2 Optional
362: -- Default = FND_API.G_FALSE
363: -- p_commit IN VARCHAR2 Optional
364: -- Default = FND_API.G_FALSE
365: -- p_validation_level IN NUMBER Optional
366: -- Default = FND_API.G_VALID_LEVEL_FULL
367: -- p_group IN input_group_type Required
368: -- OUT : x_return_status OUT VARCHAR2(1)

Line 366: -- Default = FND_API.G_VALID_LEVEL_FULL

362: -- Default = FND_API.G_FALSE
363: -- p_commit IN VARCHAR2 Optional
364: -- Default = FND_API.G_FALSE
365: -- p_validation_level IN NUMBER Optional
366: -- Default = FND_API.G_VALID_LEVEL_FULL
367: -- p_group IN input_group_type Required
368: -- OUT : x_return_status OUT VARCHAR2(1)
369: -- x_msg_count OUT NUMBER
370: -- x_msg_data OUT VARCHAR2(2000)

Line 383: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

379:
380:
381: PROCEDURE get_ancestor_group
382: (p_api_version IN NUMBER,
383: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
384: p_commit IN VARCHAR2 := FND_API.G_FALSE,
385: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
386: x_return_status OUT NOCOPY VARCHAR2,
387: x_msg_count OUT NOCOPY NUMBER,

Line 384: p_commit IN VARCHAR2 := FND_API.G_FALSE,

380:
381: PROCEDURE get_ancestor_group
382: (p_api_version IN NUMBER,
383: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
384: p_commit IN VARCHAR2 := FND_API.G_FALSE,
385: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
386: x_return_status OUT NOCOPY VARCHAR2,
387: x_msg_count OUT NOCOPY NUMBER,
388: x_msg_data OUT NOCOPY VARCHAR2,

Line 385: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,

381: PROCEDURE get_ancestor_group
382: (p_api_version IN NUMBER,
383: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
384: p_commit IN VARCHAR2 := FND_API.G_FALSE,
385: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
386: x_return_status OUT NOCOPY VARCHAR2,
387: x_msg_count OUT NOCOPY NUMBER,
388: x_msg_data OUT NOCOPY VARCHAR2,
389: p_group IN input_group_type,

Line 405: -- Default = FND_API.G_FALSE

401: --
402: -- Parameters :
403: -- IN : p_api_version IN NUMBER Required
404: -- p_init_msg_list IN VARCHAR2 Optional
405: -- Default = FND_API.G_FALSE
406: -- p_commit IN VARCHAR2 Optional
407: -- Default = FND_API.G_FALSE
408: -- p_validation_level IN NUMBER Optional
409: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 407: -- Default = FND_API.G_FALSE

403: -- IN : p_api_version IN NUMBER Required
404: -- p_init_msg_list IN VARCHAR2 Optional
405: -- Default = FND_API.G_FALSE
406: -- p_commit IN VARCHAR2 Optional
407: -- Default = FND_API.G_FALSE
408: -- p_validation_level IN NUMBER Optional
409: -- Default = FND_API.G_VALID_LEVEL_FULL
410: -- p_group IN input_group_type Required
411: -- OUT : x_return_status OUT VARCHAR2(1)

Line 409: -- Default = FND_API.G_VALID_LEVEL_FULL

405: -- Default = FND_API.G_FALSE
406: -- p_commit IN VARCHAR2 Optional
407: -- Default = FND_API.G_FALSE
408: -- p_validation_level IN NUMBER Optional
409: -- Default = FND_API.G_VALID_LEVEL_FULL
410: -- p_group IN input_group_type Required
411: -- OUT : x_return_status OUT VARCHAR2(1)
412: -- x_msg_count OUT NUMBER
413: -- x_msg_data OUT VARCHAR2(2000)

Line 424: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

420: -- End of comments
421:
422: PROCEDURE get_descendant_group
423: (p_api_version IN NUMBER,
424: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
425: p_commit IN VARCHAR2 := FND_API.G_FALSE,
426: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
427: x_return_status OUT NOCOPY VARCHAR2,
428: x_msg_count OUT NOCOPY NUMBER,

Line 425: p_commit IN VARCHAR2 := FND_API.G_FALSE,

421:
422: PROCEDURE get_descendant_group
423: (p_api_version IN NUMBER,
424: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
425: p_commit IN VARCHAR2 := FND_API.G_FALSE,
426: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
427: x_return_status OUT NOCOPY VARCHAR2,
428: x_msg_count OUT NOCOPY NUMBER,
429: x_msg_data OUT NOCOPY VARCHAR2,

Line 426: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,

422: PROCEDURE get_descendant_group
423: (p_api_version IN NUMBER,
424: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
425: p_commit IN VARCHAR2 := FND_API.G_FALSE,
426: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
427: x_return_status OUT NOCOPY VARCHAR2,
428: x_msg_count OUT NOCOPY NUMBER,
429: x_msg_data OUT NOCOPY VARCHAR2,
430: p_group IN input_group_type,

Line 442: -- Default = FND_API.G_FALSE

438: -- Pre-reqs : None.
439: -- Parameters :
440: -- IN : p_api_version IN NUMBER Required
441: -- p_init_msg_list IN VARCHAR2 Optional
442: -- Default = FND_API.G_FALSE
443: -- p_commit IN VARCHAR2 Optional
444: -- Default = FND_API.G_FALSE
445: -- p_validation_level IN NUMBER Optional
446: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 444: -- Default = FND_API.G_FALSE

440: -- IN : p_api_version IN NUMBER Required
441: -- p_init_msg_list IN VARCHAR2 Optional
442: -- Default = FND_API.G_FALSE
443: -- p_commit IN VARCHAR2 Optional
444: -- Default = FND_API.G_FALSE
445: -- p_validation_level IN NUMBER Optional
446: -- Default = FND_API.G_VALID_LEVEL_FULL
447: -- p_srp IN srp_group_rec_type Required
448: -- p_effective_date IN DATE Required

Line 446: -- Default = FND_API.G_VALID_LEVEL_FULL

442: -- Default = FND_API.G_FALSE
443: -- p_commit IN VARCHAR2 Optional
444: -- Default = FND_API.G_FALSE
445: -- p_validation_level IN NUMBER Optional
446: -- Default = FND_API.G_VALID_LEVEL_FULL
447: -- p_srp IN srp_group_rec_type Required
448: -- p_effective_date IN DATE Required
449: -- OUT : x_return_status OUT VARCHAR2(1)
450: -- x_msg_count OUT NUMBER

Line 462: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

458: --
459: -- End of comments
460: PROCEDURE Get_All_Managers
461: (p_api_version IN NUMBER,
462: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
463: p_commit IN VARCHAR2 := FND_API.G_FALSE,
464: p_validation_level IN number := FND_API.G_VALID_LEVEL_FULL,
465: p_srp IN srp_group_rec_type,
466: x_return_status OUT NOCOPY VARCHAR2,

Line 463: p_commit IN VARCHAR2 := FND_API.G_FALSE,

459: -- End of comments
460: PROCEDURE Get_All_Managers
461: (p_api_version IN NUMBER,
462: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
463: p_commit IN VARCHAR2 := FND_API.G_FALSE,
464: p_validation_level IN number := FND_API.G_VALID_LEVEL_FULL,
465: p_srp IN srp_group_rec_type,
466: x_return_status OUT NOCOPY VARCHAR2,
467: x_msg_count OUT NOCOPY NUMBER,

Line 464: p_validation_level IN number := FND_API.G_VALID_LEVEL_FULL,

460: PROCEDURE Get_All_Managers
461: (p_api_version IN NUMBER,
462: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
463: p_commit IN VARCHAR2 := FND_API.G_FALSE,
464: p_validation_level IN number := FND_API.G_VALID_LEVEL_FULL,
465: p_srp IN srp_group_rec_type,
466: x_return_status OUT NOCOPY VARCHAR2,
467: x_msg_count OUT NOCOPY NUMBER,
468: x_msg_data OUT NOCOPY VARCHAR2,