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_SRP_PERIOD_QUOTAS_PKG dependencies on CN_SRP_PERIODS_PVT

Line 1119: l_srp_prd_rec cn_srp_periods_pvt.delta_srp_period_rec_type := cn_srp_periods_pvt.g_miss_delta_srp_period_rec;

1115: AND p.period_status IN ('O', 'F')
1116: AND cn_srp_period_quotas_all.org_id = p.org_id
1117: );
1118:
1119: l_srp_prd_rec cn_srp_periods_pvt.delta_srp_period_rec_type := cn_srp_periods_pvt.g_miss_delta_srp_period_rec;
1120: CURSOR l_bal_id
1121: IS
1122: SELECT salesrep_id,
1123: period_id ,

Line 1252: cn_srp_periods_pvt.Update_Delta_Srp_Pds_No_Sync (p_api_version => 1.0, x_return_status => l_return_status, x_msg_count => l_msg_count, x_msg_data => l_msg_data, p_del_srp_prd_rec => l_srp_prd_rec, x_loading_status => l_loading_status);

1248: LOOP
1249: l_srp_prd_rec.srp_period_id := l_bal_rec.srp_period_id;
1250: l_srp_prd_rec.del_balance2_dtd := l_bal_rec.balance2_dtd*(-1);
1251: l_srp_prd_rec.del_balance3_ctd := l_bal_rec.balance3_ctd*(-1);
1252: cn_srp_periods_pvt.Update_Delta_Srp_Pds_No_Sync (p_api_version => 1.0, x_return_status => l_return_status, x_msg_count => l_msg_count, x_msg_data => l_msg_data, p_del_srp_prd_rec => l_srp_prd_rec, x_loading_status => l_loading_status);
1253: IF l_bal_rec.salesrep_id <> l_last_salesrep_id OR l_bal_rec.role_id <> l_last_role_id OR l_bal_rec.credit_type_id <> l_last_ct_id THEN
1254: IF l_last_salesrep_id <> -1 THEN
1255: cn_srp_periods_pvt.sync_accum_balances_start_pd (p_salesrep_id => l_last_salesrep_id, p_org_id => l_org_id, p_credit_type_id => l_last_ct_id, p_role_id => l_last_role_id, p_start_period_id => l_last_period_id);
1256: END IF;

Line 1255: cn_srp_periods_pvt.sync_accum_balances_start_pd (p_salesrep_id => l_last_salesrep_id, p_org_id => l_org_id, p_credit_type_id => l_last_ct_id, p_role_id => l_last_role_id, p_start_period_id => l_last_period_id);

1251: l_srp_prd_rec.del_balance3_ctd := l_bal_rec.balance3_ctd*(-1);
1252: cn_srp_periods_pvt.Update_Delta_Srp_Pds_No_Sync (p_api_version => 1.0, x_return_status => l_return_status, x_msg_count => l_msg_count, x_msg_data => l_msg_data, p_del_srp_prd_rec => l_srp_prd_rec, x_loading_status => l_loading_status);
1253: IF l_bal_rec.salesrep_id <> l_last_salesrep_id OR l_bal_rec.role_id <> l_last_role_id OR l_bal_rec.credit_type_id <> l_last_ct_id THEN
1254: IF l_last_salesrep_id <> -1 THEN
1255: cn_srp_periods_pvt.sync_accum_balances_start_pd (p_salesrep_id => l_last_salesrep_id, p_org_id => l_org_id, p_credit_type_id => l_last_ct_id, p_role_id => l_last_role_id, p_start_period_id => l_last_period_id);
1256: END IF;
1257: l_last_salesrep_id := l_bal_rec.salesrep_id;
1258: l_last_role_id := l_bal_rec.role_id;
1259: l_last_ct_id := l_bal_rec.credit_type_id;

Line 1264: cn_srp_periods_pvt.sync_accum_balances_start_pd (p_salesrep_id => l_last_salesrep_id, p_org_id => l_org_id, p_credit_type_id => l_last_ct_id, p_role_id => l_last_role_id, p_start_period_id => l_last_period_id);

1260: l_last_period_id := l_bal_rec.period_id;
1261: END IF;
1262: END LOOP;
1263: IF l_last_salesrep_id <> -1 THEN
1264: cn_srp_periods_pvt.sync_accum_balances_start_pd (p_salesrep_id => l_last_salesrep_id, p_org_id => l_org_id, p_credit_type_id => l_last_ct_id, p_role_id => l_last_role_id, p_start_period_id => l_last_period_id);
1265: END IF;
1266: -- done with changes for bug 4019235
1267: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1268: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;