APPS.CN_SRP_PMT_PLANS_PVT dependencies on CN_SRP_PMT_PLANS_PKG

Line 965: cn_srp_pmt_plans_pkg.insert_row

961: from cn_pmt_plans_all
962: where pmt_plan_id = p_pmt_plan_assign_rec.pmt_plan_id;
963:
964:
965: cn_srp_pmt_plans_pkg.insert_row
966: ( x_srp_pmt_plan_id => p_pmt_plan_assign_rec.srp_pmt_plan_id
967: ,x_pmt_plan_id => p_pmt_plan_assign_rec.pmt_plan_id
968: ,x_salesrep_id => p_pmt_plan_assign_rec.salesrep_id
969: ,x_org_id => p_pmt_plan_assign_rec.org_id

Line 1223: cn_srp_pmt_plans_pkg.delete_row

1219: RAISE FND_API.G_EXC_ERROR ;
1220: END IF;
1221: */
1222: -- Delete record
1223: cn_srp_pmt_plans_pkg.delete_row
1224: (x_srp_pmt_plan_id => l_oldrec.srp_pmt_plan_id);
1225:
1226: -- Insert new record w/ validation
1227: cn_srp_pmt_plans_pkg.insert_row

Line 1227: cn_srp_pmt_plans_pkg.insert_row

1223: cn_srp_pmt_plans_pkg.delete_row
1224: (x_srp_pmt_plan_id => l_oldrec.srp_pmt_plan_id);
1225:
1226: -- Insert new record w/ validation
1227: cn_srp_pmt_plans_pkg.insert_row
1228: ( x_srp_pmt_plan_id => p_pmt_plan_assign_rec.srp_pmt_plan_id
1229: ,x_pmt_plan_id => p_pmt_plan_assign_rec.pmt_plan_id
1230: ,x_salesrep_id => p_pmt_plan_assign_rec.salesrep_id
1231: ,x_org_id => p_pmt_plan_assign_rec.org_id

Line 1290: cn_srp_pmt_plans_pkg.update_row

1286:
1287: END IF;
1288: */
1289: -- Update pmt plan assignment into cn_srp_pmt_plans
1290: cn_srp_pmt_plans_pkg.update_row
1291: ( x_srp_pmt_plan_id => p_pmt_plan_assign_rec.srp_pmt_plan_id
1292: ,x_pmt_plan_id => p_pmt_plan_assign_rec.pmt_plan_id
1293: ,x_salesrep_id => p_pmt_plan_assign_rec.salesrep_id
1294: ,x_org_id => p_pmt_plan_assign_rec.org_id

Line 1611: cn_srp_pmt_plans_pkg.delete_row

1607: x_jtf_note_id => x_note_id -- returned
1608: );
1609:
1610: -- Delete record
1611: cn_srp_pmt_plans_pkg.delete_row
1612: (x_srp_pmt_plan_id => p_srp_pmt_plan_id);
1613:
1614: -- raise business event
1615: l_pmt_plan_assign_rec.srp_pmt_plan_id := p_srp_pmt_plan_id;