725:
726: FOR l_rec IN l_cur
727: LOOP
728:
729: cn_srp_plan_assigns_pvt.delete_srp_plan_assigns
730: (
731: p_api_version => 1.0,
732: p_init_msg_list => fnd_api.g_false,
733: p_commit => fnd_api.g_false,
1007: (roles.start_date <= l_rec.end_date AND roles.end_date >=
1008: l_rec.end_date ) ) THEN
1009:
1010: FOR role_plans IN get_role_plans(roles.role_id,roles.org_id) LOOP
1011: cn_srp_plan_assigns_pvt.Update_Srp_Plan_Assigns
1012: (
1013: p_api_version => 1.0,
1014: p_init_msg_list => FND_API.G_FALSE,
1015: p_commit => FND_API.G_FALSE,
1324: salesrep.end_date ) ) THEN
1325:
1326: FOR role_plans IN get_role_plans(roles.role_id,roles.org_id)
1327: LOOP
1328: cn_srp_plan_assigns_pvt.Update_Srp_Plan_Assigns
1329: (
1330: p_api_version => 1.0,
1331: p_init_msg_list => FND_API.G_FALSE,
1332: p_commit => FND_API.G_FALSE,