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_ACC_PERIOD_STATUSES_V

Line 35: RETURN cn_acc_period_statuses_v.start_date%TYPE

31: FUNCTION previous_period (
32: p_start_date DATE,
33: p_org_id NUMBER
34: )
35: RETURN cn_acc_period_statuses_v.start_date%TYPE
36: IS
37: l_previous_start_date cn_acc_period_statuses_v.start_date%TYPE;
38: BEGIN
39: SELECT MAX (start_date)

Line 37: l_previous_start_date cn_acc_period_statuses_v.start_date%TYPE;

33: p_org_id NUMBER
34: )
35: RETURN cn_acc_period_statuses_v.start_date%TYPE
36: IS
37: l_previous_start_date cn_acc_period_statuses_v.start_date%TYPE;
38: BEGIN
39: SELECT MAX (start_date)
40: INTO l_previous_start_date
41: FROM cn_acc_period_statuses_v

Line 41: FROM cn_acc_period_statuses_v

37: l_previous_start_date cn_acc_period_statuses_v.start_date%TYPE;
38: BEGIN
39: SELECT MAX (start_date)
40: INTO l_previous_start_date
41: FROM cn_acc_period_statuses_v
42: WHERE TRUNC (start_date) <= TRUNC (p_start_date)
43: AND period_status IN ('F', 'O')
44: AND org_id = p_org_id;
45:

Line 51: FROM cn_acc_period_statuses_v

47: IF (l_previous_start_date IS NULL)
48: THEN
49: SELECT MIN (start_date)
50: INTO l_previous_start_date
51: FROM cn_acc_period_statuses_v
52: WHERE period_status IN ('F', 'O')
53: AND org_id = p_org_id;
54: END IF;
55:

Line 192: FROM cn_acc_period_statuses_v p, cn_quotas q

188: p_last_update_login c12,
189: p_last_updated_by c13,
190: p_created_by c14,
191: q.org_id org_id
192: FROM cn_acc_period_statuses_v p, cn_quotas q
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'

Line 286: cn_acc_period_statuses_v p

282: l_user_id c13,
283: l_user_id c14,
284: 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

Line 298: FROM cn_acc_period_statuses_v r1

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
297: AND EXISTS (SELECT r1.end_date
298: FROM cn_acc_period_statuses_v r1
299: WHERE r1.end_date > q.start_date
300: AND r1.org_id = q.org_id);
301:
302: l_period_quota l_period_quotas_cr%ROWTYPE;

Line 305: l_min_date cn_acc_period_statuses_v.start_date%TYPE;

301:
302: l_period_quota l_period_quotas_cr%ROWTYPE;
303: l_pqs NUMBER;
304:
305: l_min_date cn_acc_period_statuses_v.start_date%TYPE;
306: l_insert_flag VARCHAR2(1);
307: l_end_date DATE;
308: l_org_id NUMBER;
309:

Line 320: select min(start_date) into l_min_date from cn_acc_period_statuses_v

316:
317: select end_date, org_id into l_end_date, l_org_id from
318: cn_quotas_v where quota_id = x_quota_id;
319:
320: select min(start_date) into l_min_date from cn_acc_period_statuses_v
321: where period_status IN ('F', 'O') and org_id = l_org_id;
322:
323:
324: IF (l_end_date IS NOT NULL AND trunc(l_end_date) < trunc(l_min_date)) THEN

Line 422: cn_acc_period_statuses_v cp,

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
426: AND p.quota_id = cq.quota_id

Line 444: cn_acc_period_statuses_v cp,

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
448: AND p.quota_id = cq.quota_id

Line 578: l_max_date cn_acc_period_statuses_v.end_date%TYPE;

574: l_start_date DATE;
575: l_end_date DATE;
576: l_start_period_id NUMBER;
577: l_end_period_id NUMBER;
578: l_max_date cn_acc_period_statuses_v.end_date%TYPE;
579: l_min_date cn_acc_period_statuses_v.start_date%TYPE;
580: l_delete_all_flag CHAR(1);
581: l_org_id cn_quotas.org_id%TYPE;
582: BEGIN

Line 579: l_min_date cn_acc_period_statuses_v.start_date%TYPE;

575: l_end_date DATE;
576: l_start_period_id NUMBER;
577: l_end_period_id NUMBER;
578: l_max_date cn_acc_period_statuses_v.end_date%TYPE;
579: l_min_date cn_acc_period_statuses_v.start_date%TYPE;
580: l_delete_all_flag CHAR(1);
581: l_org_id cn_quotas.org_id%TYPE;
582: BEGIN
583: -- get start date, end date for the pe

Line 589: select max(end_date) into l_max_date from cn_acc_period_statuses_v

585: select start_date, end_date, org_id
586: into l_start_date, l_end_date, l_org_id from
587: cn_quotas_v where quota_id = x_quota_id;
588: -- max date of open or future entry periods
589: select max(end_date) into l_max_date from cn_acc_period_statuses_v
590: where period_status IN ('F', 'O') and org_id = l_org_id;
591: -- min date of open or future entry periods
592: select min(start_date) into l_min_date from cn_acc_period_statuses_v
593: where period_status IN ('F', 'O') and org_id = l_org_id;

Line 592: select min(start_date) into l_min_date from cn_acc_period_statuses_v

588: -- max date of open or future entry periods
589: select max(end_date) into l_max_date from cn_acc_period_statuses_v
590: where period_status IN ('F', 'O') and org_id = l_org_id;
591: -- min date of open or future entry periods
592: select min(start_date) into l_min_date from cn_acc_period_statuses_v
593: where period_status IN ('F', 'O') and org_id = l_org_id;
594:
595:
596: IF (trunc(l_start_date) < trunc(l_min_date)) THEN

Line 598: from cn_acc_period_statuses_v

594:
595:
596: IF (trunc(l_start_date) < trunc(l_min_date)) THEN
597: select min(period_id) into l_start_period_id
598: from cn_acc_period_statuses_v
599: where period_status IN ('F', 'O') and org_id = l_org_id;
600: ELSIF (trunc(l_start_date) > trunc(l_max_date)) THEN
601: -- select max(period_id) into l_start_period_id
602: -- from cn_acc_period_statuses_v

Line 602: -- from cn_acc_period_statuses_v

598: from cn_acc_period_statuses_v
599: where period_status IN ('F', 'O') and org_id = l_org_id;
600: ELSIF (trunc(l_start_date) > trunc(l_max_date)) THEN
601: -- select max(period_id) into l_start_period_id
602: -- from cn_acc_period_statuses_v
603: -- where period_status IN ('F', 'O');
604: -- delete all records
605: l_delete_all_flag := 'Y';
606: ELSE

Line 609: FROM cn_acc_period_statuses_v

605: l_delete_all_flag := 'Y';
606: ELSE
607: SELECT period_id
608: INTO l_start_period_id
609: FROM cn_acc_period_statuses_v
610: WHERE l_start_date BETWEEN start_date and end_date
611: AND period_status IN ('F', 'O') and org_id = l_org_id;
612: END IF;
613:

Line 617: -- from cn_acc_period_statuses_v

613:
614: IF (l_end_date IS NOT NULL) THEN
615: IF (trunc(l_end_date) < trunc(l_min_date)) THEN
616: -- select min(period_id) into l_end_period_id
617: -- from cn_acc_period_statuses_v
618: -- where period_status IN ('F', 'O');
619: -- delete all records
620: l_delete_all_flag := 'Y';
621: ELSIF (trunc(l_end_date) > trunc(l_max_date)) THEN

Line 623: from cn_acc_period_statuses_v

619: -- delete all records
620: l_delete_all_flag := 'Y';
621: ELSIF (trunc(l_end_date) > trunc(l_max_date)) THEN
622: select max(period_id) into l_end_period_id
623: from cn_acc_period_statuses_v
624: where period_status IN ('F', 'O') and org_id = l_org_id;
625: ELSE
626: SELECT period_id
627: INTO l_end_period_id

Line 628: FROM cn_acc_period_statuses_v

624: where period_status IN ('F', 'O') and org_id = l_org_id;
625: ELSE
626: SELECT period_id
627: INTO l_end_period_id
628: FROM cn_acc_period_statuses_v
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;

Line 772: cn_acc_period_statuses_v cp,

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
776: AND p.quota_id = cq.quota_id

Line 797: cn_acc_period_statuses_v cp,

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
801: AND p.quota_id = cq.quota_id