APPS.CN_PROC_BATCHES_PKG dependencies on CN_ROLLUP_PVT

Line 595: l_srp_rec cn_rollup_pvt.srp_rec_type;

591: l_login_id NUMBER(15) := fnd_global.login_id;
592: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
593: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;
594: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id;
595: l_srp_rec cn_rollup_pvt.srp_rec_type;
596: l_descendant_tbl cn_rollup_pvt.srp_tbl_type;
597: l_counter NUMBER;
598: l_msg_count NUMBER;
599: l_msg_data VARCHAR2(2000);

Line 596: l_descendant_tbl cn_rollup_pvt.srp_tbl_type;

592: l_conc_prog_id NUMBER(15) := fnd_global.conc_program_id;
593: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;
594: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id;
595: l_srp_rec cn_rollup_pvt.srp_rec_type;
596: l_descendant_tbl cn_rollup_pvt.srp_tbl_type;
597: l_counter NUMBER;
598: l_msg_count NUMBER;
599: l_msg_data VARCHAR2(2000);
600: l_return_status VARCHAR2(30);

Line 613: cn_rollup_pvt.get_descendant_salesrep(

609: IF p_entire_hierarchy = 'Y' THEN
610: l_srp_rec.salesrep_id := p_salesrep_id;
611: l_srp_rec.start_date := p_start_date;
612: l_srp_rec.end_date := p_end_date;
613: cn_rollup_pvt.get_descendant_salesrep(
614: p_api_version => 1.0
615: , p_init_msg_list => fnd_api.g_true
616: , p_commit => fnd_api.g_false
617: , x_return_status => l_return_status

Line 1368: l_srp cn_rollup_pvt.srp_rec_type;

1364: -- the existence of a complete compensation plan
1365: l_return_status VARCHAR2(30);
1366: l_msg_count NUMBER;
1367: l_msg_data VARCHAR2(2000);
1368: l_srp cn_rollup_pvt.srp_rec_type;
1369: l_active_group cn_rollup_pvt.active_group_tbl_type;
1370: l_srp_group cn_rollup_pvt.srp_group_rec_type;
1371: l_srp_group_ancestor cn_rollup_pvt.srp_group_tbl_type;
1372: l_system_rollup_flag VARCHAR2(1);

Line 1369: l_active_group cn_rollup_pvt.active_group_tbl_type;

1365: l_return_status VARCHAR2(30);
1366: l_msg_count NUMBER;
1367: l_msg_data VARCHAR2(2000);
1368: l_srp cn_rollup_pvt.srp_rec_type;
1369: l_active_group cn_rollup_pvt.active_group_tbl_type;
1370: l_srp_group cn_rollup_pvt.srp_group_rec_type;
1371: l_srp_group_ancestor cn_rollup_pvt.srp_group_tbl_type;
1372: l_system_rollup_flag VARCHAR2(1);
1373:

Line 1370: l_srp_group cn_rollup_pvt.srp_group_rec_type;

1366: l_msg_count NUMBER;
1367: l_msg_data VARCHAR2(2000);
1368: l_srp cn_rollup_pvt.srp_rec_type;
1369: l_active_group cn_rollup_pvt.active_group_tbl_type;
1370: l_srp_group cn_rollup_pvt.srp_group_rec_type;
1371: l_srp_group_ancestor cn_rollup_pvt.srp_group_tbl_type;
1372: l_system_rollup_flag VARCHAR2(1);
1373:
1374: CURSOR missed_reps IS

Line 1371: l_srp_group_ancestor cn_rollup_pvt.srp_group_tbl_type;

1367: l_msg_data VARCHAR2(2000);
1368: l_srp cn_rollup_pvt.srp_rec_type;
1369: l_active_group cn_rollup_pvt.active_group_tbl_type;
1370: l_srp_group cn_rollup_pvt.srp_group_rec_type;
1371: l_srp_group_ancestor cn_rollup_pvt.srp_group_tbl_type;
1372: l_system_rollup_flag VARCHAR2(1);
1373:
1374: CURSOR missed_reps IS
1375: SELECT DISTINCT ch.direct_salesrep_id

Line 1469: cn_rollup_pvt.get_active_group(

1465: l_srp.salesrep_id := missed_rep.direct_salesrep_id;
1466: l_srp.start_date := missed_rep.rollup_date;
1467: l_srp.end_date := missed_rep.rollup_date;
1468: l_active_group.DELETE;
1469: cn_rollup_pvt.get_active_group(
1470: p_api_version => 1.0
1471: , x_return_status => l_return_status
1472: , x_msg_count => l_msg_count
1473: , x_msg_data => l_msg_data

Line 1486: cn_rollup_pvt.get_ancestor_salesrep(

1482: l_srp_group.salesrep_id := l_srp.salesrep_id;
1483: l_srp_group.GROUP_ID := l_active_group(i).GROUP_ID;
1484: l_srp_group.start_date := l_active_group(i).start_date;
1485: l_srp_group.end_date := l_active_group(i).end_date;
1486: cn_rollup_pvt.get_ancestor_salesrep(
1487: p_api_version => 1.0
1488: , x_return_status => l_return_status
1489: , x_msg_count => l_msg_count
1490: , x_msg_data => l_msg_data