APPS.CN_PERIOD_QUOTAS_GRP dependencies on CN_PERIOD_QUOTAS

Line 1: PACKAGE BODY cn_period_quotas_grp AS

1: PACKAGE BODY cn_period_quotas_grp AS
2: /* $Header: cnxgprdb.pls 120.4 2005/10/19 06:08:07 chanthon ship $ */
3: g_pkg_name CONSTANT VARCHAR2 (30) := 'CN_PERIOD_QUOTAS_GRP';
4: g_file_name CONSTANT VARCHAR2 (12) := 'cnxgprdb.pls';
5: g_last_update_date DATE := SYSDATE;

Line 3: g_pkg_name CONSTANT VARCHAR2 (30) := 'CN_PERIOD_QUOTAS_GRP';

1: PACKAGE BODY cn_period_quotas_grp AS
2: /* $Header: cnxgprdb.pls 120.4 2005/10/19 06:08:07 chanthon ship $ */
3: g_pkg_name CONSTANT VARCHAR2 (30) := 'CN_PERIOD_QUOTAS_GRP';
4: g_file_name CONSTANT VARCHAR2 (12) := 'cnxgprdb.pls';
5: g_last_update_date DATE := SYSDATE;
6: g_last_updated_by NUMBER := fnd_global.user_id;
7: g_creation_date DATE := SYSDATE;

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 227: FROM cn_period_quotas pq

223: IF p_period_quotas_rec.period_name_old IS NULL
224: THEN
225: SELECT COUNT (*)
226: INTO l_same_pe
227: FROM cn_period_quotas pq
228: WHERE pq.period_id = x_period_id AND pq.quota_id = x_quota_id;
229:
230: IF l_same_pe <> 0
231: THEN

Line 289: l_period_quotas_rec cn_period_quotas%ROWTYPE;

285: l_api_name CONSTANT VARCHAR2 (30) := 'Check_Valid_Update';
286: l_same_pe NUMBER;
287: l_quota_id NUMBER;
288: l_period_id NUMBER;
289: l_period_quotas_rec cn_period_quotas%ROWTYPE;
290: l_meaning cn_lookups.meaning%TYPE;
291: l_loading_status VARCHAR2 (80);
292: BEGIN
293: -- Initialize API return status to success

Line 391: FROM cn_period_quotas

387: --+
388: BEGIN
389: SELECT *
390: INTO l_period_quotas_rec
391: FROM cn_period_quotas
392: WHERE period_id = x_period_id_old AND quota_id = x_quota_id_old;
393: EXCEPTION
394: WHEN OTHERS
395: 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,

Line 782: END cn_period_quotas_grp;

778: END IF;
779:
780: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
781: END update_period_quotas;
782: END cn_period_quotas_grp;