APPS.CN_PERIOD_QUOTAS_PKG dependencies on CN_API

Line 289: AND p.end_date <= cn_api.next_period (NVL (q.end_date, p.end_date), q.org_id)

285: FROM cn_quotas q,
286: cn_acc_period_statuses_v p
287: WHERE q.quota_id = x_quota_id
288: AND p.start_date >= previous_period (q.start_date, q.org_id)
289: AND p.end_date <= cn_api.next_period (NVL (q.end_date, p.end_date), q.org_id)
290: AND q.org_id = p.org_id
291: AND NOT EXISTS (SELECT 'this period_quota already exists'
292: FROM cn_period_quotas pq
293: WHERE pq.period_id = p.period_id

Line 633: -- l_start_period_id := cn_api.get_acc_period_id(l_start_date);

629: WHERE l_end_date BETWEEN start_date and end_date
630: AND period_status IN ('F', 'O') and org_id = l_org_id;
631: END IF;
632: END IF;
633: -- l_start_period_id := cn_api.get_acc_period_id(l_start_date);
634: -- IF (l_end_date IS NOT NULL) THEN
635: -- l_end_period_id := cn_api.get_acc_period_id(l_end_date);
636: -- END IF;
637: IF (l_delete_all_flag = 'Y') THEN

Line 635: -- l_end_period_id := cn_api.get_acc_period_id(l_end_date);

631: END IF;
632: END IF;
633: -- l_start_period_id := cn_api.get_acc_period_id(l_start_date);
634: -- IF (l_end_date IS NOT NULL) THEN
635: -- l_end_period_id := cn_api.get_acc_period_id(l_end_date);
636: -- END IF;
637: IF (l_delete_all_flag = 'Y') THEN
638: DELETE_RECORD(x_quota_id);
639: ELSIF (l_end_date IS NOT NULL) THEN