APPS.CN_CHK_PLAN_ELEMENT_PKG dependencies on CN_QUOTAS

Line 2425: l_pe_name cn_quotas.NAME%TYPE;

2421:
2422: l_factor_csr c_factors%ROWTYPE;
2423: key_factor_total NUMBER;
2424: l_api_name CONSTANT VARCHAR2 (30) := 'chk_trx_factor';
2425: l_pe_name cn_quotas.NAME%TYPE;
2426: BEGIN
2427: x_return_status := fnd_api.g_ret_sts_success;
2428: x_loading_status := p_loading_status;
2429: key_factor_total := 0;

Line 2458: FROM cn_quotas q,

2454: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2455: THEN
2456: SELECT q.NAME
2457: INTO l_pe_name
2458: FROM cn_quotas q,
2459: cn_quota_rules qr
2460: WHERE qr.quota_rule_id = p_quota_rule_id AND q.quota_id = qr.quota_id;
2461:
2462: fnd_message.set_name ('CN', 'PLN_QUOTA_RULE_FACTORS_NOT_100');

Line 2499: RETURN cn_quotas.quota_id%TYPE

2495: FUNCTION get_quota_id (
2496: p_quota_name VARCHAR2,
2497: p_org_id NUMBER
2498: )
2499: RETURN cn_quotas.quota_id%TYPE
2500: IS
2501: l_quota_id cn_quotas.quota_id%TYPE;
2502: BEGIN
2503: SELECT quota_id

Line 2501: l_quota_id cn_quotas.quota_id%TYPE;

2497: p_org_id NUMBER
2498: )
2499: RETURN cn_quotas.quota_id%TYPE
2500: IS
2501: l_quota_id cn_quotas.quota_id%TYPE;
2502: BEGIN
2503: SELECT quota_id
2504: INTO l_quota_id
2505: FROM cn_quotas_v

Line 2505: FROM cn_quotas_v

2501: l_quota_id cn_quotas.quota_id%TYPE;
2502: BEGIN
2503: SELECT quota_id
2504: INTO l_quota_id
2505: FROM cn_quotas_v
2506: WHERE NAME = p_quota_name
2507: AND org_id = p_org_id ;
2508:
2509: RETURN l_quota_id;

Line 2812: FROM cn_quotas

2808: SELECT start_date,
2809: end_date
2810: INTO l_child_start_date,
2811: l_child_end_date
2812: FROM cn_quotas
2813: WHERE quota_id = child_quota_id;
2814:
2815: -- check date range between the parent and child plan element
2816: IF (l_parent_start_date < l_child_start_date)

Line 3328: FROM cn_quotas

3324: CURSOR quota_curs
3325: IS
3326: SELECT start_date,
3327: end_date
3328: FROM cn_quotas
3329: WHERE quota_id = p_quota_id;
3330:
3331: l_record_info quota_curs%ROWTYPE;
3332: l_api_name CONSTANT VARCHAR2 (30) := 'chk_date_effective';

Line 3637: RETURN cn_quotas.quota_type_code%TYPE

3633: --| ---------------------------------------------------------------------+
3634: FUNCTION get_quota_type (
3635: p_quota_id NUMBER
3636: )
3637: RETURN cn_quotas.quota_type_code%TYPE
3638: IS
3639: l_quota_type cn_quotas.quota_type_code%TYPE;
3640: BEGIN
3641: SELECT quota_type_code

Line 3639: l_quota_type cn_quotas.quota_type_code%TYPE;

3635: p_quota_id NUMBER
3636: )
3637: RETURN cn_quotas.quota_type_code%TYPE
3638: IS
3639: l_quota_type cn_quotas.quota_type_code%TYPE;
3640: BEGIN
3641: SELECT quota_type_code
3642: INTO l_quota_type
3643: FROM cn_quotas

Line 3643: FROM cn_quotas

3639: l_quota_type cn_quotas.quota_type_code%TYPE;
3640: BEGIN
3641: SELECT quota_type_code
3642: INTO l_quota_type
3643: FROM cn_quotas
3644: WHERE quota_id = p_quota_id;
3645:
3646: RETURN l_quota_type;
3647: EXCEPTION