1: PACKAGE BODY cn_rollup_pvt AS
2: --$Header: cnvrollb.pls 120.4 2010/08/04 22:08:38 rnagired ship $
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):='cn_rollup_pvt';
5:
1: PACKAGE BODY cn_rollup_pvt AS
2: --$Header: cnvrollb.pls 120.4 2010/08/04 22:08:38 rnagired ship $
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):='cn_rollup_pvt';
5:
6: -- API name : get_active_role
7: -- Type : Private.
8: -- Pre-reqs : None
111: p_data => x_msg_data );
112:
113: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
114: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
115: 'cn.plsql.cn_rollup_pvt.get_active_role.exception',
116: sqlerrm);
117: end if;
118:
119: END get_active_role;
229: p_data => x_msg_data );
230:
231: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
232: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
233: 'cn.plsql.cn_rollup_pvt.get_active_group_member.exception',
234: sqlerrm);
235: end if;
236: END get_active_group_member;
237:
270: l_api_version CONSTANT NUMBER := 1.0;
271:
272: l_counter NUMBER(15);
273:
274: l_group_member cn_rollup_pvt.group_mem_tbl_type;
275: BEGIN
276: -- Standard call to check for call compatibility.
277: IF NOT FND_API.Compatible_API_Call
278: (l_api_version ,
348: p_data => x_msg_data );
349:
350: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
351: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
352: 'cn.plsql.cn_rollup_pvt.get_active_group_member.exception',
353: sqlerrm);
354: end if;
355: END get_active_group_member;
356:
466: p_data => x_msg_data );
467:
468: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
469: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
470: 'cn.plsql.cn_rollup_pvt.get_active_group.exception',
471: sqlerrm);
472: end if;
473:
474: END get_active_group;
580: p_data => x_msg_data );
581:
582: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
583: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
584: 'cn.plsql.cn_rollup_pvt.get_ancestor_group.exception',
585: sqlerrm);
586: end if;
587:
588: END get_ancestor_group;
693: p_data => x_msg_data );
694:
695: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
696: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
697: 'cn.plsql.cn_rollup_pvt.get_descendant_group.exception',
698: sqlerrm);
699: end if;
700:
701: END get_descendant_group;
898: p_data => x_msg_data );
899:
900: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
901: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
902: 'cn.plsql.cn_rollup_pvt.get_ancestor_salesrep.exception',
903: sqlerrm);
904: end if;
905:
906: END get_ancestor_salesrep;
1067: p_data => x_msg_data );
1068:
1069: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1070: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
1071: 'cn.plsql.cn_rollup_pvt.get_descendant_salesrep.exception',
1072: sqlerrm);
1073: end if;
1074:
1075: END get_descendant_salesrep;
1218: p_data => x_msg_data );
1219:
1220: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1221: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
1222: 'cn.plsql.cn_rollup_pvt.get_descendant_salesrep.exception',
1223: sqlerrm);
1224: end if;
1225:
1226: END get_descendant_salesrep;
1224: end if;
1225:
1226: END get_descendant_salesrep;
1227:
1228: END cn_rollup_pvt;