APPS.CN_SRP_PLAN_ASSIGNS_PKG dependencies on CN_SRP_PERIOD_QUOTAS_PKG

Line 515: cn_srp_period_quotas_pkg.insert_record

511: -- start_date remanin unchanged
512: IF x_start_date = oldrow.start_date THEN
513: IF x_end_date IS NULL THEN
514: -- oldrow.end_date is not null,extend end_date
515: cn_srp_period_quotas_pkg.insert_record
516: (x_srp_plan_assign_id => x_srp_plan_assign_id
517: ,x_quota_id => NULL
518: ,x_start_period_id => NULL -- obsolete
519: ,x_end_period_id => NULL -- obsolete

Line 534: cn_srp_period_quotas_pkg.delete_record

530: oldrow.org_id)
531: ,x_end_date => x_end_date);
532: ELSIF oldrow.end_date IS NULL THEN
533: -- x_end_date is not null,shorten end_date
534: cn_srp_period_quotas_pkg.delete_record
535: ( x_srp_plan_assign_id => x_srp_plan_assign_id
536: ,x_quota_id => NULL
537: ,x_start_period_id => NULL -- obsolete
538: ,x_end_period_id => NULL -- obsolete

Line 561: cn_srp_period_quotas_pkg.insert_record

557: AND org_id = oldrow.org_id;
558:
559: IF x_end_date > l_next_start_date THEN
560:
561: cn_srp_period_quotas_pkg.insert_record
562: (x_srp_plan_assign_id => x_srp_plan_assign_id
563: ,x_quota_id => NULL
564: ,x_start_period_id => NULL -- obsolete
565: ,x_end_period_id => NULL -- obsolete

Line 581: cn_srp_period_quotas_pkg.delete_record

577: ,x_end_date => x_end_date);
578: END IF;
579: ELSE
580: -- shorten end_date
581: cn_srp_period_quotas_pkg.delete_record
582: ( x_srp_plan_assign_id => x_srp_plan_assign_id
583: ,x_quota_id => NULL
584: ,x_start_period_id => NULL -- obsolete
585: ,x_end_period_id => NULL -- obsolete

Line 612: cn_srp_period_quotas_pkg.delete_record

608: ,x_start_period_id => NULL
609: ,x_end_period_id => NULL
610: ,x_start_date => oldrow.start_date
611: ,x_end_date => oldrow.end_date );
612: cn_srp_period_quotas_pkg.delete_record
613: ( x_srp_plan_assign_id => x_srp_plan_assign_id
614: ,x_quota_id => NULL
615: ,x_start_period_id => NULL -- obsolete
616: ,x_end_period_id => NULL -- obsolete

Line 620: cn_srp_period_quotas_pkg.insert_record

616: ,x_end_period_id => NULL -- obsolete
617: ,x_start_date => oldrow.start_date
618: ,x_end_date => oldrow.end_date );
619:
620: cn_srp_period_quotas_pkg.insert_record
621: (x_srp_plan_assign_id => x_srp_plan_assign_id
622: ,x_quota_id => NULL
623: ,x_start_period_id => NULL -- obsolete
624: ,x_end_period_id => NULL -- obsolete