DBA Data[Home] [Help]

APPS.CN_PERIOD_QUOTAS_GRP dependencies on CN_PERIOD_QUOTAS_PKG

Line 202: IF TRUNC (l_period_start_date) < TRUNC (cn_period_quotas_pkg.previous_period (l_quota_start_date,l_org_id))

198: l_period_end_date
199: FROM cn_acc_period_statuses_v
200: WHERE period_id = x_period_id AND org_id = l_org_id;
201:
202: IF TRUNC (l_period_start_date) < TRUNC (cn_period_quotas_pkg.previous_period (l_quota_start_date,l_org_id))
203: OR TRUNC (l_period_end_date) > TRUNC (cn_api.next_period (NVL (l_quota_end_date, l_period_end_date), l_org_id))
204: THEN
205: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
206: THEN

Line 577: cn_period_quotas_pkg.begin_record (x_operation => 'INSERT',

573: THEN
574: RAISE fnd_api.g_exc_error;
575: ELSIF (x_return_status = fnd_api.g_ret_sts_success) AND (x_loading_status = 'CN_INSERTED')
576: THEN
577: cn_period_quotas_pkg.begin_record (x_operation => 'INSERT',
578: x_period_quota_id => l_period_quota_id,
579: x_period_id => l_period_id,
580: x_quota_id => l_quota_id,
581: x_period_target => p_period_quotas_rec_tbl (i).period_target,

Line 601: cn_period_quotas_pkg.sync_itd_values (x_quota_id => l_quota_id);

597:
598: -- clku, bug 3637221 , we need to sync the itd values in case of inserting
599: -- non-zero period target, payment_amount or goal, particularly in
600: -- duplicating Plan Element
601: cn_period_quotas_pkg.sync_itd_values (x_quota_id => l_quota_id);
602: END IF; -- Table Count is Not Zero
603:
604: --+
605: -- End of API body.

Line 722: cn_period_quotas_pkg.begin_record (x_operation => 'UPDATE',

718: THEN
719: RAISE fnd_api.g_exc_error;
720: ELSIF (x_return_status = fnd_api.g_ret_sts_success) AND (x_loading_status = 'CN_UPDATED')
721: THEN
722: cn_period_quotas_pkg.begin_record (x_operation => 'UPDATE',
723: x_period_quota_id => l_period_quota_id,
724: x_period_id => l_period_id,
725: x_quota_id => l_quota_id,
726: x_period_target => p_period_quotas_rec_tbl (i).period_target,