APPS.CN_SRP_PMT_PLANS_PVT dependencies on CN_SRP_PMT_PLANS_PKG

Line 966: cn_srp_pmt_plans_pkg.insert_row

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

Line 1224: cn_srp_pmt_plans_pkg.delete_row

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

Line 1228: cn_srp_pmt_plans_pkg.insert_row

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

Line 1291: cn_srp_pmt_plans_pkg.update_row

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

Line 1612: cn_srp_pmt_plans_pkg.delete_row

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