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_CALC_POPULATE_PVT dependencies on CN_COMMISSION_LINES_ALL

Line 33: UPDATE cn_commission_lines_all cl

29: BEGIN
30: IF (p_quota_count = 1) AND (x_role_count = 1) THEN
31: x_role_count := 2;
32:
33: UPDATE cn_commission_lines_all cl
34: SET cl.srp_plan_assign_id = p_srp_plan_assign_id,
35: cl.quota_id = p_quota_id,
36: cl.quota_rule_id = p_quota_rule_id,
37: cl.status = 'POP',

Line 57: INSERT INTO cn_commission_lines_all

53: cl.direct_salesrep_id <> cl.credited_salesrep_id ) );
54: ELSE
55:
56: -- create new transaction lines for plan_quota
57: INSERT INTO cn_commission_lines_all
58: ( commission_line_id,
59: commission_header_id,
60: CREDITED_SALESREP_ID,
61: credited_comp_group_id,

Line 105: FROM cn_commission_lines_all cl

101: g_creation_date,
102: g_created_by,
103: g_org_id,
104: rollup_level
105: FROM cn_commission_lines_all cl
106: WHERE cl.credited_salesrep_id = p_salesrep_id
107: AND cl.processed_date = p_processed_date
108: AND cl.processed_period_id = p_processed_period_id
109: AND cl.credited_comp_group_id = p_comp_group_id

Line 251: from cn_commission_lines_all cl,

247: pb.end_period_id,
248: pb.start_date,
249: pb.end_date,
250: cl.revenue_class_id
251: from cn_commission_lines_all cl,
252: cn_process_batches_all pb
253: where pb.physical_batch_id = p_physical_batch_id
254: and cl.credited_salesrep_id = pb.salesrep_id
255: and cl.processed_period_id between pb.period_id AND pb.end_period_id

Line 381: FROM cn_commission_lines_all cl,

377: cl.processed_date,
378: ch.role_id,
379: ch.quota_id,
380: ch.revenue_class_id
381: FROM cn_commission_lines_all cl,
382: cn_commission_headers_all ch,
383: cn_process_batches_all pb
384: WHERE pb.physical_batch_id = p_physical_batch_id
385: AND cl.credited_salesrep_id = pb.salesrep_id

Line 470: INSERT INTO cn_commission_lines_all

466:
467: -- get credits from team members
468: FOR srp IN team_mbrs LOOP
469: FOR mbr IN other_mbrs(srp.comp_team_id, srp.salesrep_id, srp.start_date, srp.end_date) LOOP
470: INSERT INTO cn_commission_lines_all
471: (commission_line_id,
472: commission_header_id,
473: direct_salesrep_id,
474: pre_processed_code,

Line 508: from cn_commission_lines_all cl

504: fnd_global.user_id,
505: sysdate,
506: g_org_id,
507: 0
508: from cn_commission_lines_all cl
509: where cl.credited_salesrep_id = mbr.salesrep_id
510: and cl.processed_date between mbr.start_date and mbr.end_date
511: and cl.created_during = 'ROLL'
512: AND cl.status <> 'OBSOLETE'

Line 515: from cn_commission_lines_all

511: and cl.created_during = 'ROLL'
512: AND cl.status <> 'OBSOLETE'
513: and cl.org_id = g_org_id
514: and not exists (select 1
515: from cn_commission_lines_all
516: where commission_header_id = cl.commission_header_id
517: and credited_salesrep_id = srp.salesrep_id));
518: IF (SQL%found) THEN
519: cn_mark_events_pkg.mark_notify

Line 569: update cn_commission_lines_all cl

565: l_start_date := plan.start_date;
566: l_end_date := plan.end_date;
567: g_end_date := l_end_date;
568:
569: update cn_commission_lines_all cl
570: set cl.srp_plan_assign_id = plan.srp_plan_assign_id,
571: cl.quota_id = plan.quota_id,
572: cl.quota_rule_id = plan.quota_rule_id,
573: cl.status = 'POP',

Line 601: merge into cn_commission_lines_all cl

597: else
598: l_end_date := plan.end_date;
599: end if;
600:
601: merge into cn_commission_lines_all cl
602: using (select commission_line_id,
603: commission_header_id,
604: direct_salesrep_id,
605: pre_processed_code,

Line 625: from cn_commission_lines_all cl2

621: creation_date,
622: created_by,
623: org_id,
624: rollup_level
625: from cn_commission_lines_all cl2
626: where credited_salesrep_id = rep.credited_salesrep_id
627: and processed_date between l_start_date and l_end_date
628: and processed_period_id between rep.period_id and rep.end_period_id
629: and credited_comp_group_id = rep.credited_comp_group_id

Line 634: and not exists (select 1 from cn_commission_lines_all

630: and created_during in ('ROLL', 'TROLL')
631: and status <> 'OBSOLETE'
632: and org_id = g_org_id
633: and revenue_class_id = rep.revenue_class_id
634: and not exists (select 1 from cn_commission_lines_all
635: where credited_salesrep_id = cl2.credited_salesrep_id
636: and commission_header_id = cl2.commission_header_id
637: and srp_plan_assign_id = plan.srp_plan_assign_id
638: and quota_id = plan.quota_id)

Line 713: update cn_commission_lines_all cl

709: end if;
710: l_end_date := plan.end_date;
711: g_end_date := plan.end_date;
712:
713: update cn_commission_lines_all cl
714: set cl.srp_plan_assign_id = plan.srp_plan_assign_id,
715: cl.quota_id = plan.quota_id,
716: cl.quota_rule_id = plan.quota_rule_id,
717: cl.status = 'POP',

Line 751: update cn_commission_lines_all cl

747: if (i = 1) then
748: l_start_date := plan.start_date;
749: l_end_date := plan.end_date;
750: g_end_date := l_end_date;
751: update cn_commission_lines_all cl
752: set cl.srp_plan_assign_id = plan.srp_plan_assign_id,
753: cl.quota_id = plan.quota_id,
754: cl.quota_rule_id = plan.quota_rule_id,
755: cl.status = 'POP',

Line 778: merge into cn_commission_lines_all cl

774: l_end_date := g_end_date;
775: else
776: l_end_date := plan.end_date;
777: end if;
778: merge into cn_commission_lines_all cl
779: using (select commission_line_id,
780: commission_header_id,
781: direct_salesrep_id,
782: pre_processed_code,

Line 802: from cn_commission_lines_all cl2

798: creation_date,
799: created_by,
800: org_id,
801: rollup_level
802: from cn_commission_lines_all cl2
803: where credited_salesrep_id = rep.credited_salesrep_id
804: and processed_date between l_start_date and l_end_date
805: and processed_period_id between rep.period_id and rep.end_period_id
806: and credited_comp_group_id = rep.credited_comp_group_id

Line 811: and not exists (select 1 from cn_commission_lines_all

807: and created_during in ('ROLL', 'TROLL')
808: and status <> 'OBSOLETE'
809: and org_id = g_org_id
810: and revenue_class_id = rep.revenue_class_id
811: and not exists (select 1 from cn_commission_lines_all
812: where credited_salesrep_id = cl2.credited_salesrep_id
813: and commission_header_id = cl2.commission_header_id
814: and srp_plan_assign_id = plan.srp_plan_assign_id
815: and quota_id = plan.quota_id)

Line 889: update cn_commission_lines_all cl

885: l_start_date := g_end_date + 1;
886: end if;
887: l_end_date := plan.end_date;
888: g_end_date := plan.end_date;
889: update cn_commission_lines_all cl
890: set cl.srp_plan_assign_id = plan.srp_plan_assign_id,
891: cl.quota_id = plan.quota_id,
892: cl.quota_rule_id = plan.quota_rule_id,
893: cl.status = 'POP',

Line 983: UPDATE cn_commission_lines_all cl

979: END IF;
980: END IF;
981:
982: IF l_srp_plan_assign_id IS NOT NULL AND l_quota_rule_id IS NOT NULL THEN
983: UPDATE cn_commission_lines_all cl
984: SET cl.status = 'POP',
985: cl.role_id = srp.role_id,
986: cl.srp_plan_assign_id = l_srp_plan_assign_id,
987: cl.quota_id = srp.quota_id,

Line 1025: UPDATE cn_commission_lines_all cl

1021: 'cn.plsql.cn_calc_populate_pvt.populate_batch.progress',
1022: 'Updating unpopulated transactions to XPOP.');
1023: end if;
1024:
1025: UPDATE cn_commission_lines_all cl
1026: SET cl.status = 'XPOP',
1027: quota_id = NULL,
1028: quota_rule_id = NULL,
1029: role_id =NULL,

Line 1033: FROM cn_commission_lines_all line,

1029: role_id =NULL,
1030: srp_plan_assign_id = NULL
1031: WHERE cl.commission_line_id IN
1032: (SELECT line.commission_line_id
1033: FROM cn_commission_lines_all line,
1034: cn_process_batches_all pb
1035: WHERE pb.physical_batch_id = p_physical_batch_id
1036: AND line.credited_salesrep_id = pb.salesrep_id
1037: AND line.processed_period_id BETWEEN pb.period_id AND pb.end_period_id