eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_PERIOD_QUOTAS_PKG dependencies on CN_PERIOD_QUOTAS

Line 1: PACKAGE BODY cn_period_quotas_pkg AS

1: PACKAGE BODY cn_period_quotas_pkg AS
2: /* $Header: cnprdqob.pls 120.3 2006/03/22 05:53:28 chanthon ship $ */
3:
4: /* ------------------------------------------------------------------------+
5: | Public Routine Bodies |

Line 23: SELECT cn_period_quotas_s.NEXTVAL

19: x_period_quota_id IN OUT NOCOPY NUMBER
20: )
21: IS
22: BEGIN
23: SELECT cn_period_quotas_s.NEXTVAL
24: INTO x_period_quota_id
25: FROM DUAL;
26: END get_uid;
27:

Line 70: -- Notes: This is the table handler for the CN_Period_Quotas_Pkg

66: -- Purpose: Depending on the Operation the right procudure,
67: -- Insert_record, Delete_Records, Lock_Record or
68: -- Update_Record is called
69: --
70: -- Notes: This is the table handler for the CN_Period_Quotas_Pkg
71: --
72: --
73: PROCEDURE begin_record (
74: x_operation VARCHAR2,

Line 152: -- Notes: Insert_Record for CN_Period_Quotas

148: -- Name : Insert_record
149: --
150: -- Purpose : To insert the record with the different paras
151: --
152: -- Notes: Insert_Record for CN_Period_Quotas
153: --
154: --
155: PROCEDURE INSERT_RECORD (
156: x_period_quota_id IN OUT NOCOPY NUMBER,

Line 176: SELECT --cn_period_quotas_s.nextval,

172: )
173: IS
174: CURSOR l_period_quotas_cr
175: IS
176: SELECT --cn_period_quotas_s.nextval,
177: p_period_id c1,
178: p_quota_id c2,
179: p_period_target c3,
180: 0 c4,

Line 197: FROM cn_period_quotas pq

193: WHERE q.org_id = p.org_id
194: AND q.quota_id = p_quota_id
195: AND p.period_id = p_period_id
196: AND NOT EXISTS (SELECT 'this period_quota already exists'
197: FROM cn_period_quotas pq
198: WHERE pq.period_id = p.period_id
199: AND pq.quota_id = q.quota_id
200: AND pq.org_id = q.org_id);
201:

Line 209: SELECT cn_period_quotas_s.NEXTVAL

205: IF p_quota_id IS NOT NULL
206: THEN
207: FOR l_period_quota IN l_period_quotas_cr
208: LOOP
209: SELECT cn_period_quotas_s.NEXTVAL
210: INTO l_pqs
211: FROM DUAL;
212:
213: INSERT INTO cn_period_quotas

Line 213: INSERT INTO cn_period_quotas

209: SELECT cn_period_quotas_s.NEXTVAL
210: INTO l_pqs
211: FROM DUAL;
212:
213: INSERT INTO cn_period_quotas
214: (period_quota_id,
215: period_id,
216: quota_id,
217: period_target,

Line 258: -- Notes: Insert_Record for CN_Period_Quotas

254: END INSERT_RECORD;
255:
256: -- Name : Insert_record
257: -- Purpose : To insert the records
258: -- Notes: Insert_Record for CN_Period_Quotas
259: PROCEDURE INSERT_RECORD (
260: x_quota_id NUMBER
261: )
262: IS

Line 292: FROM cn_period_quotas pq

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
294: AND pq.quota_id = q.quota_id
295: AND pq.org_id = q.org_id)
296: -- bug 2460926, check if all the open period ends before the specified start_date

Line 332: SELECT cn_period_quotas_s.NEXTVAL

328: IF (x_quota_id IS NOT NULL AND l_insert_flag = 'Y') THEN
329:
330: FOR l_period_quota IN l_period_quotas_cr
331: LOOP
332: SELECT cn_period_quotas_s.NEXTVAL
333: INTO l_pqs
334: FROM DUAL;
335:
336: INSERT INTO cn_period_quotas

Line 336: INSERT INTO cn_period_quotas

332: SELECT cn_period_quotas_s.NEXTVAL
333: INTO l_pqs
334: FROM DUAL;
335:
336: INSERT INTO cn_period_quotas
337: (period_quota_id,
338: period_id,
339: quota_id,
340: period_target,

Line 384: -- Notes: Update record for the CN_Period_Quotas

380: END INSERT_RECORD;
381:
382: --
383: -- Name: Update Record
384: -- Notes: Update record for the CN_Period_Quotas
385: --,
386: --x_itd_payment NUMBER,
387: --x_quarter_num NUMBER,
388: --x_period_year NUMBER,

Line 421: FROM cn_period_quotas p,

417: SELECT p.period_quota_id,
418: p.period_target,
419: p.period_payment,
420: p.performance_goal
421: FROM cn_period_quotas p,
422: cn_acc_period_statuses_v cp,
423: cn_cal_per_int_types cpit,
424: cn_quotas cq
425: WHERE p.quota_id = p_quota_id

Line 443: FROM cn_period_quotas p,

439: CURSOR interval_counts
440: IS SELECT COUNT (p.period_quota_id) interval_count,
441: cpit.interval_number interval_number,
442: p.period_year period_year
443: FROM cn_period_quotas p,
444: cn_acc_period_statuses_v cp,
445: cn_cal_per_int_types cpit,
446: cn_quotas cq
447: WHERE p.quota_id = p_quota_id

Line 468: FROM cn_period_quotas

464: BEGIN
465: -- get the current ovn
466: SELECT object_version_number
467: INTO x_object_version_number
468: FROM cn_period_quotas
469: WHERE period_quota_id = p_period_quota_id
470: AND period_id = p_period_id AND quota_id = p_quota_id;
471:
472: x_object_version_number := NVL (x_object_version_number, 0) + 1;

Line 474: UPDATE cn_period_quotas

470: AND period_id = p_period_id AND quota_id = p_quota_id;
471:
472: x_object_version_number := NVL (x_object_version_number, 0) + 1;
473:
474: UPDATE cn_period_quotas
475: SET period_target = p_period_target,
476: quota_id = p_quota_id,
477: period_id = p_period_id,
478: period_payment = p_period_payment,

Line 507: UPDATE cn_period_quotas

503: l_target_total := ROUND (NVL (l_target_total, 0), g_ext_precision);
504: l_payment_total := ROUND (NVL (l_payment_total, 0), g_ext_precision);
505: l_performance_goal_total := ROUND (NVL (l_performance_goal_total, 0), g_ext_precision);
506:
507: UPDATE cn_period_quotas
508: SET itd_target = l_target_total,
509: itd_payment = l_payment_total,
510: performance_goal_itd = l_performance_goal_total
511: WHERE period_quota_id = pq_rec.period_quota_id;

Line 554: FROM cn_period_quotas pq

550: period_quotas_count NUMBER;
551: BEGIN
552: SELECT COUNT (*)
553: INTO period_quotas_count
554: FROM cn_period_quotas pq
555: WHERE pq.quota_id = x_quota_id;
556:
557: IF period_quotas_count > 0
558: THEN

Line 559: DELETE FROM cn_period_quotas

555: WHERE pq.quota_id = x_quota_id;
556:
557: IF period_quotas_count > 0
558: THEN
559: DELETE FROM cn_period_quotas
560: WHERE quota_id = x_quota_id;
561: END IF;
562: END DELETE_RECORD;
563:

Line 640: delete from cn_period_quotas where quota_id = x_quota_id

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
640: delete from cn_period_quotas where quota_id = x_quota_id
641: and (period_id < l_start_period_id OR period_id > l_end_period_id);
642: ELSE
643: delete from cn_period_quotas where quota_id = x_quota_id
644: and period_id < l_start_period_id;

Line 643: delete from cn_period_quotas where quota_id = x_quota_id

639: ELSIF (l_end_date IS NOT NULL) THEN
640: delete from cn_period_quotas where quota_id = x_quota_id
641: and (period_id < l_start_period_id OR period_id > l_end_period_id);
642: ELSE
643: delete from cn_period_quotas where quota_id = x_quota_id
644: and period_id < l_start_period_id;
645: END IF;
646:
647:

Line 707: FROM cn_period_quotas

703: AND org_id = p_org_id);
704: BEGIN
705: SELECT period_id
706: INTO l_start_period_id
707: FROM cn_period_quotas
708: WHERE quota_id = x_quota_id
709: AND period_quota_id = x_start_period_quota_id;
710:
711: SELECT interval_type_id, org_id

Line 736: FROM cn_period_quotas pq

732: NVL (pq.performance_goal_itd, 0)
733: INTO l_itd_target,
734: l_itd_payment,
735: l_performance_goal_itd
736: FROM cn_period_quotas pq
737: WHERE quota_id = x_quota_id AND period_id = l_previous_period_id;
738:
739: FOR i_period_id IN max_period_csr (l_interval_type_id, l_start_period_id, l_org_id)
740: LOOP

Line 741: UPDATE cn_period_quotas

737: WHERE quota_id = x_quota_id AND period_id = l_previous_period_id;
738:
739: FOR i_period_id IN max_period_csr (l_interval_type_id, l_start_period_id, l_org_id)
740: LOOP
741: UPDATE cn_period_quotas
742: SET itd_target = l_itd_target,
743: itd_payment = l_itd_payment,
744: performance_goal_itd = l_performance_goal_itd
745: WHERE quota_id = x_quota_id AND period_id = i_period_id.cal_period_id;

Line 757: --clku, helper procedure for synchrozing ITD values of cn_period_quotas table

753: THEN
754: NULL;
755: END populate_itd_values;
756:
757: --clku, helper procedure for synchrozing ITD values of cn_period_quotas table
758: -- called whenever there is change of interval type of PE
759: PROCEDURE sync_itd_values (
760: x_quota_id NUMBER
761: )

Line 771: FROM cn_period_quotas p,

767: SELECT p.period_quota_id,
768: p.period_target,
769: p.period_payment,
770: p.performance_goal
771: FROM cn_period_quotas p,
772: cn_acc_period_statuses_v cp,
773: cn_cal_per_int_types cpit,
774: cn_quotas cq
775: WHERE p.quota_id = x_quota_id

Line 796: FROM cn_period_quotas p,

792: IS
793: SELECT COUNT (p.period_quota_id) interval_count,
794: cpit.interval_number interval_number,
795: p.period_year period_year
796: FROM cn_period_quotas p,
797: cn_acc_period_statuses_v cp,
798: cn_cal_per_int_types cpit,
799: cn_quotas cq
800: WHERE p.quota_id = x_quota_id

Line 831: UPDATE cn_period_quotas

827: l_target_total := l_target_total + pq_rec.period_target;
828: l_payment_total := l_payment_total + pq_rec.period_payment;
829: l_performance_goal_total := l_performance_goal_total + pq_rec.performance_goal;
830:
831: UPDATE cn_period_quotas
832: SET itd_target = NVL (l_target_total, 0),
833: itd_payment = NVL (l_payment_total, 0),
834: performance_goal_itd = NVL (l_performance_goal_total, 0)
835: WHERE period_quota_id = pq_rec.period_quota_id;

Line 843: END cn_period_quotas_pkg;

839: WHEN NO_DATA_FOUND
840: THEN
841: NULL;
842: END sync_itd_values;
843: END cn_period_quotas_pkg;