APPS.JTF_RS_GROUP_USAGE_VUHK dependencies on CN_ROLLUP_PVT

Line 39: l_srp cn_rollup_pvt.srp_group_rec_type;

35: l_end_date DATE;
36: l_group_name VARCHAR2(60);
37: l_action_link_id NUMBER;
38: p_action_link_id NUMBER;
39: l_srp cn_rollup_pvt.srp_group_rec_type;
40: l_srp_tbl cn_rollup_pvt.srp_group_tbl_type;
41: l_return_status VARCHAR2(30);
42: l_msg_count NUMBER;
43: l_msg_data VARCHAR2(256);

Line 40: l_srp_tbl cn_rollup_pvt.srp_group_tbl_type;

36: l_group_name VARCHAR2(60);
37: l_action_link_id NUMBER;
38: p_action_link_id NUMBER;
39: l_srp cn_rollup_pvt.srp_group_rec_type;
40: l_srp_tbl cn_rollup_pvt.srp_group_tbl_type;
41: l_return_status VARCHAR2(30);
42: l_msg_count NUMBER;
43: l_msg_data VARCHAR2(256);
44: i NUMBER;

Line 199: cn_rollup_pvt.get_ancestor_salesrep

195: -- not that we use l_start_date and l_end_date since this date range is the super range which covers
196: -- the date effectivity of all the salesreps in this group.
197: l_srp.start_date := l_start_date;
198: l_srp.end_date := l_end_date;
199: cn_rollup_pvt.get_ancestor_salesrep
200: ( p_api_version => 1.0,
201: p_init_msg_list => FND_API.G_false,
202: p_commit => FND_API.G_false,
203: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 284: l_srp cn_rollup_pvt.srp_group_rec_type;

280: l_start_date DATE;
281: l_end_date DATE;
282: l_group_name VARCHAR2(60);
283: l_action_link_id NUMBER;
284: l_srp cn_rollup_pvt.srp_group_rec_type;
285: l_srp_tbl cn_rollup_pvt.srp_group_tbl_type;
286: l_return_status VARCHAR2(30);
287: l_msg_count NUMBER;
288: l_msg_data VARCHAR2(256);

Line 285: l_srp_tbl cn_rollup_pvt.srp_group_tbl_type;

281: l_end_date DATE;
282: l_group_name VARCHAR2(60);
283: l_action_link_id NUMBER;
284: l_srp cn_rollup_pvt.srp_group_rec_type;
285: l_srp_tbl cn_rollup_pvt.srp_group_tbl_type;
286: l_return_status VARCHAR2(30);
287: l_msg_count NUMBER;
288: l_msg_data VARCHAR2(256);
289: i NUMBER;

Line 431: cn_rollup_pvt.get_ancestor_salesrep

427: -- not that we use l_start_date and l_end_date since this date range is the super range which covers
428: -- the date effectivity of all the salesreps in this group.
429: l_srp.start_date := l_start_date;
430: l_srp.end_date := l_end_date;
431: cn_rollup_pvt.get_ancestor_salesrep
432: ( p_api_version => 1.0,
433: p_init_msg_list => FND_API.G_false,
434: p_commit => FND_API.G_false,
435: p_validation_level => FND_API.G_VALID_LEVEL_FULL,