APPS.CN_SRP_PERIOD_QUOTAS_PKG dependencies on CN_SRP_PERIODS_PVT

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

1148: AND cn_srp_period_quotas_all.period_id = p.period_id
1149: AND p.period_status IN ('O', 'F')
1150: AND cn_srp_period_quotas_all.org_id = p.org_id);
1151:
1152: l_srp_prd_rec cn_srp_periods_pvt.delta_srp_period_rec_type := cn_srp_periods_pvt.g_miss_delta_srp_period_rec;
1153:
1154: CURSOR l_bal_id IS
1155: SELECT salesrep_id, period_id, credit_type_id, role_id,
1156: balance2_dtd, balance3_ctd, srp_period_id

Line 1265: cn_srp_periods_pvt.Update_Delta_Srp_Pds_No_Sync

1261: FOR l_bal_rec IN l_bal_id LOOP
1262: l_srp_prd_rec.srp_period_id := l_bal_rec.srp_period_id;
1263: l_srp_prd_rec.del_balance2_dtd := l_bal_rec.balance2_dtd*(-1);
1264: l_srp_prd_rec.del_balance3_ctd := l_bal_rec.balance3_ctd*(-1);
1265: cn_srp_periods_pvt.Update_Delta_Srp_Pds_No_Sync
1266: (p_api_version => 1.0,
1267: x_return_status => l_return_status,
1268: x_msg_count => l_msg_count,
1269: x_msg_data => l_msg_data,

Line 1276: cn_srp_periods_pvt.sync_accum_balances_start_pd

1272: if l_bal_rec.salesrep_id <> l_last_salesrep_id OR
1273: l_bal_rec.role_id <> l_last_role_id OR
1274: l_bal_rec.credit_type_id <> l_last_ct_id then
1275: if l_last_salesrep_id <> -1 then
1276: cn_srp_periods_pvt.sync_accum_balances_start_pd
1277: (p_salesrep_id => l_last_salesrep_id,
1278: p_org_id => l_org_id,
1279: p_credit_type_id => l_last_ct_id,
1280: p_role_id => l_last_role_id,

Line 1290: cn_srp_periods_pvt.sync_accum_balances_start_pd

1286: l_last_period_id := l_bal_rec.period_id;
1287: end if;
1288: END LOOP;
1289: if l_last_salesrep_id <> -1 then
1290: cn_srp_periods_pvt.sync_accum_balances_start_pd
1291: (p_salesrep_id => l_last_salesrep_id,
1292: p_org_id => l_org_id,
1293: p_credit_type_id => l_last_ct_id,
1294: p_role_id => l_last_role_id,