DBA Data[Home] [Help]

APPS.CN_SRP_PERIOD_QUOTAS_PKG dependencies on CN_SRP_PERIOD_QUOTAS_PKG

Line 1: PACKAGE BODY CN_SRP_PERIOD_QUOTAS_PKG AS

1: PACKAGE BODY CN_SRP_PERIOD_QUOTAS_PKG AS
2: /* $Header: cnsrpqob.pls 120.14.12020000.2 2012/07/25 09:34:19 scannane ship $ */
3: --Date Name Description
4: ---------------------------------------------------------------------------+
5: -- 25-JUL-95 P Cook Split the inserts into 3 statements for performance

Line 1628: cn_srp_period_quotas_pkg.delete_record ( x_srp_plan_assign_id => x_srp_plan_assign_id ,x_quota_id => x_quota_id ,x_start_period_id => NULL ,x_end_period_id => NULL);

1624: x_srp_plan_assign_id NUMBER,
1625: x_quota_id NUMBER)
1626: IS
1627: BEGIN
1628: cn_srp_period_quotas_pkg.delete_record ( x_srp_plan_assign_id => x_srp_plan_assign_id ,x_quota_id => x_quota_id ,x_start_period_id => NULL ,x_end_period_id => NULL);
1629: cn_srp_period_quotas_pkg.insert_record ( x_srp_plan_assign_id => x_srp_plan_assign_id ,x_quota_id => x_quota_id ,x_start_period_id => NULL ,x_end_period_id => NULL);
1630: END synch_target;
1631: END CN_SRP_PERIOD_QUOTAS_PKG;

Line 1629: cn_srp_period_quotas_pkg.insert_record ( x_srp_plan_assign_id => x_srp_plan_assign_id ,x_quota_id => x_quota_id ,x_start_period_id => NULL ,x_end_period_id => NULL);

1625: x_quota_id NUMBER)
1626: IS
1627: BEGIN
1628: cn_srp_period_quotas_pkg.delete_record ( x_srp_plan_assign_id => x_srp_plan_assign_id ,x_quota_id => x_quota_id ,x_start_period_id => NULL ,x_end_period_id => NULL);
1629: cn_srp_period_quotas_pkg.insert_record ( x_srp_plan_assign_id => x_srp_plan_assign_id ,x_quota_id => x_quota_id ,x_start_period_id => NULL ,x_end_period_id => NULL);
1630: END synch_target;
1631: END CN_SRP_PERIOD_QUOTAS_PKG;

Line 1631: END CN_SRP_PERIOD_QUOTAS_PKG;

1627: BEGIN
1628: cn_srp_period_quotas_pkg.delete_record ( x_srp_plan_assign_id => x_srp_plan_assign_id ,x_quota_id => x_quota_id ,x_start_period_id => NULL ,x_end_period_id => NULL);
1629: cn_srp_period_quotas_pkg.insert_record ( x_srp_plan_assign_id => x_srp_plan_assign_id ,x_quota_id => x_quota_id ,x_start_period_id => NULL ,x_end_period_id => NULL);
1630: END synch_target;
1631: END CN_SRP_PERIOD_QUOTAS_PKG;