APPS.CN_CALC_SUBMISSION_PUB dependencies on CN_QUOTAS

Line 45: TYPE plan_element_id_tbl_type IS TABLE OF cn_quotas.quota_id%TYPE

41:
42: TYPE salesrep_id_tbl_type IS TABLE OF cn_salesreps.salesrep_id%TYPE
43: INDEX BY BINARY_INTEGER;
44:
45: TYPE plan_element_id_tbl_type IS TABLE OF cn_quotas.quota_id%TYPE
46: INDEX BY BINARY_INTEGER;
47:
48: -- ----------------------------------------------------------------------------+
49: -- Procedure: validate_calc_sub_batch

Line 515: FUNCTION validate_bonus_pe ( p_quota_name IN cn_quotas.name%TYPE ,

511: x_salesrep_id := l_salesrep_id;
512: RETURN TRUE;
513: END validate_salesrep;
514:
515: FUNCTION validate_bonus_pe ( p_quota_name IN cn_quotas.name%TYPE ,
516: p_interval_type IN VARCHAR2,
517: x_quota_id OUT NOCOPY cn_quotas.quota_id%TYPE,
518: x_loading_status OUT NOCOPY VARCHAR2 ) RETURN BOOLEAN IS
519:

Line 517: x_quota_id OUT NOCOPY cn_quotas.quota_id%TYPE,

513: END validate_salesrep;
514:
515: FUNCTION validate_bonus_pe ( p_quota_name IN cn_quotas.name%TYPE ,
516: p_interval_type IN VARCHAR2,
517: x_quota_id OUT NOCOPY cn_quotas.quota_id%TYPE,
518: x_loading_status OUT NOCOPY VARCHAR2 ) RETURN BOOLEAN IS
519:
520: CURSOR l_bonus_pe_csr IS
521: SELECT quota_id

Line 522: FROM cn_quotas_all

518: x_loading_status OUT NOCOPY VARCHAR2 ) RETURN BOOLEAN IS
519:
520: CURSOR l_bonus_pe_csr IS
521: SELECT quota_id
522: FROM cn_quotas_all
523: WHERE name = p_quota_name
524: AND org_id = g_org_id
525: AND incentive_type_code = 'BONUS'
526: AND ( (interval_type_id = -1000 AND p_interval_type = 'PERIOD')