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 837: UPDATE cn_srp_period_quotas_all

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

Line 912: from cn_srp_period_quotas_all

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

Line 930: FROM cn_srp_period_quotas_all spq

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

Line 962: update cn_srp_period_quotas_all

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

Line 971: update cn_srp_period_quotas_all

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

Line 1030: update cn_srp_period_quotas_all

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

Line 1065: FROM cn_srp_period_quotas_all

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

Line 1083: cn_srp_period_quotas_all cspq

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

Line 1092: FROM cn_srp_period_quotas_all

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

Line 1099: cn_srp_period_quotas_all cspq2

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

Line 1102: FROM cn_srp_period_quotas_all

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

Line 1118: UPDATE cn_srp_period_quotas_all

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

Line 1181: FROM cn_srp_period_quotas_all quota

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

Line 1263: FROM cn_srp_period_quotas_all quota

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

Line 1326: from cn_srp_period_quotas_all

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

Line 1744: FROM cn_srp_period_quotas_all spq,

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

Line 3843: FROM cn_srp_period_quotas_all spq

3839: p_period_id NUMBER,
3840: p_quota_id NUMBER ) RETURN NUMBER IS
3841: CURSOR l_itd_target_csr IS
3842: SELECT spq.itd_target
3843: FROM cn_srp_period_quotas_all spq
3844: WHERE spq.period_id = p_period_id
3845: AND spq.quota_id = p_quota_id
3846: AND spq.salesrep_id = p_salesrep_id
3847: AND spq.srp_plan_assign_id = p_srp_plan_assign_id;

Line 3883: FROM cn_srp_period_quotas_all spq

3879: p_period_id NUMBER,
3880: p_quota_id NUMBER ) RETURN NUMBER IS
3881: CURSOR l_itd_payment_csr IS
3882: SELECT spq.itd_payment
3883: FROM cn_srp_period_quotas_all spq
3884: WHERE spq.period_id = p_period_id
3885: AND spq.quota_id = p_quota_id
3886: AND spq.salesrep_id = p_salesrep_id
3887: AND spq.srp_plan_assign_id = p_srp_plan_assign_id;