APPS.CN_CHK_PLAN_ELEMENT_PKG dependencies on CN_QUOTA_RULE_UPLIFTS

Line 2639: RETURN cn_quota_rule_uplifts.start_date%TYPE

2635: --| ---------------------------------------------------------------------+
2636: FUNCTION get_uplift_start_date (
2637: p_quota_rule_id NUMBER
2638: )
2639: RETURN cn_quota_rule_uplifts.start_date%TYPE
2640: IS
2641: l_start_date cn_quota_rule_uplifts.start_date%TYPE;
2642:
2643: CURSOR get_date

Line 2641: l_start_date cn_quota_rule_uplifts.start_date%TYPE;

2637: p_quota_rule_id NUMBER
2638: )
2639: RETURN cn_quota_rule_uplifts.start_date%TYPE
2640: IS
2641: l_start_date cn_quota_rule_uplifts.start_date%TYPE;
2642:
2643: CURSOR get_date
2644: IS
2645: SELECT end_date + 1

Line 2646: FROM cn_quota_rule_uplifts

2642:
2643: CURSOR get_date
2644: IS
2645: SELECT end_date + 1
2646: FROM cn_quota_rule_uplifts
2647: WHERE quota_rule_id = p_quota_rule_id
2648: ORDER BY end_date DESC;
2649: BEGIN
2650: OPEN get_date;

Line 2670: RETURN cn_quota_rule_uplifts.quota_rule_uplift_id%TYPE

2666: p_quota_rule_id NUMBER,
2667: p_start_date DATE,
2668: p_end_date DATE
2669: )
2670: RETURN cn_quota_rule_uplifts.quota_rule_uplift_id%TYPE
2671: IS
2672: l_quota_rule_uplift_id cn_quota_rule_uplifts.quota_rule_uplift_id%TYPE;
2673:
2674: CURSOR get_quota_rule_uplift_id_curs

Line 2672: l_quota_rule_uplift_id cn_quota_rule_uplifts.quota_rule_uplift_id%TYPE;

2668: p_end_date DATE
2669: )
2670: RETURN cn_quota_rule_uplifts.quota_rule_uplift_id%TYPE
2671: IS
2672: l_quota_rule_uplift_id cn_quota_rule_uplifts.quota_rule_uplift_id%TYPE;
2673:
2674: CURSOR get_quota_rule_uplift_id_curs
2675: IS
2676: SELECT quota_rule_uplift_id

Line 2677: FROM cn_quota_rule_uplifts

2673:
2674: CURSOR get_quota_rule_uplift_id_curs
2675: IS
2676: SELECT quota_rule_uplift_id
2677: FROM cn_quota_rule_uplifts
2678: WHERE quota_rule_id = p_quota_rule_id AND TRUNC (start_date) = TRUNC (p_start_date) AND TRUNC (end_date) = TRUNC (p_end_date);
2679:
2680: CURSOR get_quota_rule_uplift_id_curs1
2681: IS

Line 2683: FROM cn_quota_rule_uplifts

2679:
2680: CURSOR get_quota_rule_uplift_id_curs1
2681: IS
2682: SELECT quota_rule_uplift_id
2683: FROM cn_quota_rule_uplifts
2684: WHERE quota_rule_id = p_quota_rule_id AND TRUNC (start_date) = TRUNC (p_start_date) AND TRUNC (end_date) IS NULL;
2685: BEGIN
2686: IF p_end_date IS NOT NULL
2687: THEN

Line 3532: FROM cn_quota_rule_uplifts

3528: CURSOR prev
3529: IS
3530: SELECT start_date,
3531: end_date
3532: FROM cn_quota_rule_uplifts
3533: WHERE quota_rule_id = p_quota_rule_id
3534: AND quota_rule_uplift_id <> NVL (p_quota_rule_uplift_id, 0)
3535: AND TRUNC (start_date) < TRUNC (p_start_date)
3536: ORDER BY start_date DESC;

Line 3542: FROM cn_quota_rule_uplifts

3538: CURSOR NEXT
3539: IS
3540: SELECT start_date,
3541: end_date
3542: FROM cn_quota_rule_uplifts
3543: WHERE quota_rule_id = p_quota_rule_id
3544: AND quota_rule_uplift_id <> NVL (p_quota_rule_uplift_id, 0)
3545: AND TRUNC (start_date) > TRUNC (p_start_date)
3546: ORDER BY start_date ASC;

Line 3834: FROM cn_quota_rule_uplifts u,

3830:
3831: CURSOR uplift_curs
3832: IS
3833: SELECT COUNT (1)
3834: FROM cn_quota_rule_uplifts u,
3835: cn_quota_rules r
3836: WHERE r.quota_id = p_quota_id
3837: AND r.quota_rule_id = u.quota_rule_id
3838: AND (u.start_date < p_start_date OR (p_end_date IS NOT NULL AND u.end_date IS NULL) OR u.end_date > p_end_date);