eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_PSUM_PVT dependencies on CN_SRP_HIER_PROC_PVT

Line 62: l_srp_group_rec CN_SRP_HIER_PROC_PVT.SRP_GROUP_REC_TYPE;

58: IS
59:
60: l_api_name CONSTANT VARCHAR2(30) := 'Get_Psum_Data';
61: l_api_version CONSTANT NUMBER := 1.0;
62: l_srp_group_rec CN_SRP_HIER_PROC_PVT.SRP_GROUP_REC_TYPE;
63: l_return_status VARCHAR2(1);
64: l_msg_count NUMBER;
65: l_msg_data VARCHAR2(2000);
66: l_srp_role_info_tbl CN_SRP_HIER_PROC_PVT.SRP_ROLE_INFO_TBL_TYPE;

Line 66: l_srp_role_info_tbl CN_SRP_HIER_PROC_PVT.SRP_ROLE_INFO_TBL_TYPE;

62: l_srp_group_rec CN_SRP_HIER_PROC_PVT.SRP_GROUP_REC_TYPE;
63: l_return_status VARCHAR2(1);
64: l_msg_count NUMBER;
65: l_msg_data VARCHAR2(2000);
66: l_srp_role_info_tbl CN_SRP_HIER_PROC_PVT.SRP_ROLE_INFO_TBL_TYPE;
67: l_returned_rows NUMBER;
68: l_mgr_name VARCHAR2(360);
69: l_srp CN_SRP_HIER_PROC_PVT.group_mbr_tbl_type;
70: l_agg_counter NUMBER := 0;

Line 69: l_srp CN_SRP_HIER_PROC_PVT.group_mbr_tbl_type;

65: l_msg_data VARCHAR2(2000);
66: l_srp_role_info_tbl CN_SRP_HIER_PROC_PVT.SRP_ROLE_INFO_TBL_TYPE;
67: l_returned_rows NUMBER;
68: l_mgr_name VARCHAR2(360);
69: l_srp CN_SRP_HIER_PROC_PVT.group_mbr_tbl_type;
70: l_agg_counter NUMBER := 0;
71:
72: BEGIN
73: -- Standard Start of API savepoint

Line 98: CN_SRP_HIER_PROC_PVT.Get_desc_role_info

94: l_srp_group_rec.group_id := p_comp_group_id;
95: l_srp_group_rec.effective_date := p_effective_date;
96:
97:
98: CN_SRP_HIER_PROC_PVT.Get_desc_role_info
99: ( p_api_version => 1.0,
100: p_init_msg_list => FND_API.G_FALSE,
101: p_commit => FND_API.G_FALSE,
102: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 161: CN_SRP_HIER_PROC_PVT.Get_Descendant_group_mbrs(

157: l_srp_group_rec.salesrep_id := p_mgr_id;
158: l_srp_group_rec.group_id := p_comp_group_id;
159: l_srp_group_rec.effective_date := p_effective_date;
160:
161: CN_SRP_HIER_PROC_PVT.Get_Descendant_group_mbrs(
162: p_api_version => 1.0,
163: p_init_msg_list => FND_API.G_FALSE,
164: p_commit => FND_API.G_FALSE,
165: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 191: CN_SRP_HIER_PROC_PVT.Get_desc_role_info

187: l_srp_group_rec.group_id := l_srp(i).group_id;
188: l_srp_group_rec.effective_date := p_effective_date;
189:
190: IF p_mgr_id <> l_srp(i).salesrep_id THEN
191: CN_SRP_HIER_PROC_PVT.Get_desc_role_info
192: (p_api_version => 1.0,
193: p_init_msg_list => FND_API.G_FALSE,
194: p_commit => FND_API.G_FALSE,
195: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 324: l_srp_group_rec CN_SRP_HIER_PROC_PVT.SRP_GROUP_REC_TYPE;

320: IS
321:
322: l_api_name CONSTANT VARCHAR2(30) := 'Get_Psum_Data';
323: l_api_version CONSTANT NUMBER := 1.0;
324: l_srp_group_rec CN_SRP_HIER_PROC_PVT.SRP_GROUP_REC_TYPE;
325: l_return_status VARCHAR2(1);
326: l_msg_count NUMBER;
327: l_msg_data VARCHAR2(2000);
328: l_srp_role_info_tbl CN_SRP_HIER_PROC_PVT.SRP_ROLE_INFO_TBL_TYPE;

Line 328: l_srp_role_info_tbl CN_SRP_HIER_PROC_PVT.SRP_ROLE_INFO_TBL_TYPE;

324: l_srp_group_rec CN_SRP_HIER_PROC_PVT.SRP_GROUP_REC_TYPE;
325: l_return_status VARCHAR2(1);
326: l_msg_count NUMBER;
327: l_msg_data VARCHAR2(2000);
328: l_srp_role_info_tbl CN_SRP_HIER_PROC_PVT.SRP_ROLE_INFO_TBL_TYPE;
329: l_returned_rows NUMBER;
330: l_mgr_name VARCHAR2(360);
331: l_srp CN_SRP_HIER_PROC_PVT.group_mbr_tbl_type;
332: l_agg_counter NUMBER := 0;

Line 331: l_srp CN_SRP_HIER_PROC_PVT.group_mbr_tbl_type;

327: l_msg_data VARCHAR2(2000);
328: l_srp_role_info_tbl CN_SRP_HIER_PROC_PVT.SRP_ROLE_INFO_TBL_TYPE;
329: l_returned_rows NUMBER;
330: l_mgr_name VARCHAR2(360);
331: l_srp CN_SRP_HIER_PROC_PVT.group_mbr_tbl_type;
332: l_agg_counter NUMBER := 0;
333:
334: BEGIN
335: -- Standard Start of API savepoint

Line 360: CN_SRP_HIER_PROC_PVT.Get_MO_desc_role_info

356: l_srp_group_rec.group_id := p_comp_group_id;
357: l_srp_group_rec.effective_date := p_effective_date;
358:
359:
360: CN_SRP_HIER_PROC_PVT.Get_MO_desc_role_info
361: ( p_api_version => 1.0,
362: p_init_msg_list => FND_API.G_FALSE,
363: p_commit => FND_API.G_FALSE,
364: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 428: CN_SRP_HIER_PROC_PVT.Get_MO_Descendant_group_mbrs(

424: l_srp_group_rec.salesrep_id := p_mgr_id;
425: l_srp_group_rec.group_id := p_comp_group_id;
426: l_srp_group_rec.effective_date := p_effective_date;
427:
428: CN_SRP_HIER_PROC_PVT.Get_MO_Descendant_group_mbrs(
429: p_api_version => 1.0,
430: p_init_msg_list => FND_API.G_FALSE,
431: p_commit => FND_API.G_FALSE,
432: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 459: CN_SRP_HIER_PROC_PVT.Get_MO_desc_role_info

455: l_srp_group_rec.group_id := l_srp(i).group_id;
456: l_srp_group_rec.effective_date := p_effective_date;
457:
458: IF p_mgr_id <> l_srp(i).salesrep_id THEN
459: CN_SRP_HIER_PROC_PVT.Get_MO_desc_role_info
460: (p_api_version => 1.0,
461: p_init_msg_list => FND_API.G_FALSE,
462: p_commit => FND_API.G_FALSE,
463: p_validation_level => FND_API.G_VALID_LEVEL_FULL,