DBA Data[Home] [Help]

APPS.CN_QUOTAS_PKG dependencies on CN_PERIOD_QUOTAS_PKG

Line 119: cn_period_quotas_pkg.DELETE_RECORD (x_quota_id => x_quota_id);

115: BEGIN
116: -- delete quota rules
117: cn_quota_rules_pkg.DELETE_RECORD (x_quota_id => x_quota_id, x_quota_rule_id => NULL, x_revenue_class_id => NULL);
118: -- delete period qutoas
119: cn_period_quotas_pkg.DELETE_RECORD (x_quota_id => x_quota_id);
120: -- delete rt quota asgns id
121: cn_rt_quota_asgns_pkg.DELETE_RECORD (x_quota_id => x_quota_id, x_calc_formula_id => NULL, x_rt_quota_asgn_id => NULL);
122:
123: UPDATE cn_quotas_all

Line 608: cn_period_quotas_pkg.sync_itd_values (x_quota_id);

604:
605: --clku, we need to sync up the ITD values whenever interval type is updated
606: IF (x_interval_type_id <> recinfo.interval_type_id)
607: THEN
608: cn_period_quotas_pkg.sync_itd_values (x_quota_id);
609: cn_srp_period_quotas_pkg.sync_itd_values (x_quota_id);
610: END IF;
611: END IF;
612:

Line 870: /*cn_period_quotas_pkg.delete_record (

866: -- clku, 1/9/2002, commented out this part because we want to prevent inserting
867: -- records in cn_period_quotas with checking the formula's ytd flag. The insert of rows
868: -- will be taken care of in CN_PLAN_ELEMENT_PUB.Update_Period_Quota right after
869: -- the call of cn_period_quotas.begin_record
870: /*cn_period_quotas_pkg.delete_record (
871: x_quota_id => x_quota_id);
872: cn_period_quotas_pkg.insert_record (
873: x_quota_id => x_quota_id);*/
874: END IF;

Line 872: cn_period_quotas_pkg.insert_record (

868: -- will be taken care of in CN_PLAN_ELEMENT_PUB.Update_Period_Quota right after
869: -- the call of cn_period_quotas.begin_record
870: /*cn_period_quotas_pkg.delete_record (
871: x_quota_id => x_quota_id);
872: cn_period_quotas_pkg.insert_record (
873: x_quota_id => x_quota_id);*/
874: END IF;
875: -- The period_type_code has changed. Delete rows from
876: -- cn_period_quotas associated with x_quota_id and add the

Line 881: cn_period_quotas_pkg.delete_record (

877: -- new rows according to the new period_type_code.
878:
879: /*IF ( recinfo.period_type_code <> x_period_type_code ) THEN
880:
881: cn_period_quotas_pkg.delete_record (
882: x_quota_id => x_quota_id);
883:
884: cn_period_quotas_pkg.insert_record (
885: x_quota_id => x_quota_id);

Line 884: cn_period_quotas_pkg.insert_record (

880:
881: cn_period_quotas_pkg.delete_record (
882: x_quota_id => x_quota_id);
883:
884: cn_period_quotas_pkg.insert_record (
885: x_quota_id => x_quota_id);
886:
887: END IF;*/
888: END UPDATE_RECORD;