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_FORMULA_COMMON_PKG dependencies on CN_SRP_PERIOD_QUOTAS_ALL

Line 836: UPDATE cn_srp_period_quotas_all

832:
833: DELETE cn_commission_lines_all
834: WHERE commission_line_id = l_itd_trx.commission_line_id;
835:
836: UPDATE cn_srp_period_quotas_all
837: SET commission_payed_ptd = commission_payed_ptd - l_itd_trx.commission_amount,
838: commission_payed_itd = commission_payed_itd - l_itd_trx.commission_amount
839: WHERE salesrep_id = p_salesrep_id
840: AND period_id = p_period_id

Line 911: from cn_srp_period_quotas_all

907: input_achieved_itd,
908: input_achieved_ptd
909: from cn_srp_period_quotas_ext_all
910: where srp_period_quota_id = (select srp_period_quota_id
911: from cn_srp_period_quotas_all
912: where srp_plan_assign_id = p_srp_plan_assign_id
913: and quota_id = p_quota_id
914: and salesrep_id = p_salesrep_id
915: and period_id = p_period_id)

Line 929: FROM cn_srp_period_quotas_all spq

925: Nvl(spq.advance_recovered_ptd,0) advance_recovered_ptd ,
926: Nvl(spq.advance_to_rec_ptd,0) advance_to_rec_ptd,
927: Nvl(spq.recovery_amount_ptd,0) recovery_amount_ptd,
928: Nvl(spq.comm_pend_ptd,0)comm_pend_ptd
929: FROM cn_srp_period_quotas_all spq
930: WHERE salesrep_id = p_salesrep_id
931: AND period_id > l_start_period_id
932: AND quota_id = p_quota_id
933: AND srp_plan_assign_id = p_srp_plan_assign_id

Line 961: update cn_srp_period_quotas_all

957: l_end_period_id := get_end_period_id(p_quota_id, p_period_id);
958: cn_api.get_credit_info(l_credit_type_name, g_precision, g_ext_precision, l_org_id );
959:
960: if (p_calc_type = 'BONUS' and p_period_id = l_end_period_id ) then
961: update cn_srp_period_quotas_all
962: set commission_payed_itd = 0, commission_payed_ptd = 0
963: where salesrep_id = p_salesrep_id
964: and quota_id = p_quota_id
965: and period_id >= l_start_period_id

Line 970: update cn_srp_period_quotas_all

966: and period_id < l_end_period_id
967: and srp_plan_assign_id = p_srp_plan_assign_id;
968: elsif (p_calc_type = 'COMMISSION' and p_period_id = l_start_period_id) then
969: -- initialize the following values for the first period of an interval
970: update cn_srp_period_quotas_all
971: set perf_achieved_itd = perf_achieved_ptd,
972: commission_payed_itd = commission_payed_ptd,
973: input_achieved_itd = input_achieved_ptd,
974: output_achieved_itd = output_achieved_ptd,

Line 1029: update cn_srp_period_quotas_all

1025: l_advance_to_rec_itd := l_advance_to_rec_itd + period.advance_to_rec_ptd;
1026: l_recovery_amount_itd :=l_recovery_amount_itd + period.recovery_amount_ptd ;
1027: l_comm_pend_itd := l_comm_pend_itd + period.comm_pend_ptd;
1028:
1029: update cn_srp_period_quotas_all
1030: set commission_payed_itd = l_commission_payed_itd,
1031: input_achieved_itd = l_input_achieved_itd,
1032: output_achieved_itd = l_output_achieved_itd,
1033: perf_achieved_itd = l_perf_achieved_itd,

Line 1064: FROM cn_srp_period_quotas_all

1060: IF (p_rollover_flag = 'Y') THEN
1061: -- retrieve the current plan element's rollover target from the previous interval
1062: SELECT nvl(SUM(rollover), 0)
1063: INTO l_same_pe_rollover
1064: FROM cn_srp_period_quotas_all
1065: WHERE srp_plan_assign_id = p_srp_plan_assign_id
1066: AND quota_id = p_quota_id
1067: AND period_id = (SELECT MAX(cal_period_id)
1068: FROM cn_cal_per_int_types_all

Line 1082: cn_srp_period_quotas_all cspq

1078: -- retrieve source plan elements' rollover targets and compute the total amount
1079: SELECT SUM(nvl(cspq.rollover, 0) * csrq.rollover / 100)
1080: INTO l_source_pe_rollover
1081: FROM cn_srp_rollover_quotas_all csrq,
1082: cn_srp_period_quotas_all cspq
1083: WHERE csrq.quota_id = p_quota_id
1084: AND csrq.srp_quota_assign_id = (SELECT srp_quota_assign_id
1085: FROM cn_srp_quota_assigns_all
1086: WHERE srp_plan_assign_id = p_srp_plan_assign_id

Line 1091: FROM cn_srp_period_quotas_all

1087: AND quota_id = p_quota_id)
1088: AND cspq.salesrep_id = p_salesrep_id
1089: AND cspq.quota_id = csrq.source_quota_id
1090: AND cspq.period_id = (SELECT MAX(period_id)
1091: FROM cn_srp_period_quotas_all
1092: WHERE salesrep_id = p_salesrep_id
1093: AND quota_id = csrq.source_quota_id
1094: AND srp_quota_assign_id = cspq.srp_quota_assign_id)
1095: AND cspq.period_id < p_period_id

Line 1098: cn_srp_period_quotas_all cspq2

1094: AND srp_quota_assign_id = cspq.srp_quota_assign_id)
1095: AND cspq.period_id < p_period_id
1096: AND NOT exists (SELECT 1
1097: FROM cn_cal_per_int_types_all ccpit,
1098: cn_srp_period_quotas_all cspq2
1099: WHERE ccpit.org_id = l_org_id
1100: AND ccpit.cal_period_id > (SELECT MAX(period_id)
1101: FROM cn_srp_period_quotas_all
1102: WHERE salesrep_id = p_salesrep_id

Line 1101: FROM cn_srp_period_quotas_all

1097: FROM cn_cal_per_int_types_all ccpit,
1098: cn_srp_period_quotas_all cspq2
1099: WHERE ccpit.org_id = l_org_id
1100: AND ccpit.cal_period_id > (SELECT MAX(period_id)
1101: FROM cn_srp_period_quotas_all
1102: WHERE salesrep_id = p_salesrep_id
1103: AND quota_id = csrq.source_quota_id
1104: AND srp_quota_assign_id = cspq.srp_quota_assign_id)
1105: AND ccpit.cal_period_id < p_period_id

Line 1117: UPDATE cn_srp_period_quotas_all

1113: AND cal_period_id = p_period_id
1114: AND org_id = l_org_id))
1115: ;
1116:
1117: UPDATE cn_srp_period_quotas_all
1118: SET total_rollover = l_same_pe_rollover + nvl(l_source_pe_rollover, 0)
1119: WHERE srp_plan_assign_id = p_srp_plan_assign_id
1120: AND quota_id = p_quota_id
1121: AND period_id = p_period_id;

Line 1180: FROM cn_srp_period_quotas_all quota

1176: Nvl(quota.perf_achieved_itd, 0) - Nvl(quota.perf_achieved_ptd, 0),
1177: Nvl(quota.commission_payed_itd, 0) - Nvl(quota.commission_payed_ptd, 0)
1178: INTO x_input_achieved_itd(1), x_output_achieved_itd,
1179: x_perf_achieved_itd, x_commission_payed_itd
1180: FROM cn_srp_period_quotas_all quota
1181: WHERE quota.srp_plan_assign_id = p_srp_plan_assign_id
1182: AND quota.quota_id = p_quota_id
1183: AND quota.salesrep_id = p_salesrep_id
1184: AND quota.period_id = p_period_id;

Line 1262: FROM cn_srp_period_quotas_all quota

1258: INTO x_input_achieved_itd(1), x_input_achieved_ptd(1),
1259: x_output_achieved_itd, x_output_achieved_ptd,
1260: x_perf_achieved_itd, x_perf_achieved_ptd,
1261: x_commission_payed_itd, x_commission_payed_ptd
1262: FROM cn_srp_period_quotas_all quota
1263: WHERE quota.srp_plan_assign_id = p_srp_plan_assign_id
1264: AND quota.quota_id = P_quota_id
1265: AND quota.salesrep_id = P_salesrep_id
1266: AND quota.period_id = P_period_id;

Line 1325: from cn_srp_period_quotas_all

1321: l_end_period_id NUMBER(15);
1322: BEGIN
1323: select max(PERIOD_ID)
1324: INTO l_end_period_id
1325: from cn_srp_period_quotas_all
1326: where QUOTA_ID=p_quota_id
1327: and srp_plan_assign_id=p_srp_plan_assign_id;
1328:
1329: RETURN l_end_period_id;

Line 1743: FROM cn_srp_period_quotas_all spq,

1739: l_salesrep_id NUMBER,
1740: l_period_id NUMBER) IS
1741: SELECT spq.quota_id,
1742: qa.quota_sequence
1743: FROM cn_srp_period_quotas_all spq,
1744: cn_quota_assigns_all qa,
1745: cn_quotas_all q
1746: WHERE spq.srp_plan_assign_id = l_srp_plan_assign_id
1747: AND spq.salesrep_id = l_salesrep_id

Line 3814: FROM cn_srp_period_quotas_all spq

3810: p_period_id NUMBER,
3811: p_quota_id NUMBER ) RETURN NUMBER IS
3812: CURSOR l_itd_target_csr IS
3813: SELECT spq.itd_target
3814: FROM cn_srp_period_quotas_all spq
3815: WHERE spq.period_id = p_period_id
3816: AND spq.quota_id = p_quota_id
3817: AND spq.salesrep_id = p_salesrep_id
3818: AND spq.srp_plan_assign_id = p_srp_plan_assign_id;

Line 3854: FROM cn_srp_period_quotas_all spq

3850: p_period_id NUMBER,
3851: p_quota_id NUMBER ) RETURN NUMBER IS
3852: CURSOR l_itd_payment_csr IS
3853: SELECT spq.itd_payment
3854: FROM cn_srp_period_quotas_all spq
3855: WHERE spq.period_id = p_period_id
3856: AND spq.quota_id = p_quota_id
3857: AND spq.salesrep_id = p_salesrep_id
3858: AND spq.srp_plan_assign_id = p_srp_plan_assign_id;