APPS.CN_CALC_SUBMISSION_PUB dependencies on CN_SALESREPS

Line 42: TYPE salesrep_id_tbl_type IS TABLE OF cn_salesreps.salesrep_id%TYPE

38: := cn_api.get_lkup_meaning('USER_NAME', 'CALC_SUBMISSION_OBJECT_TYPE');
39: g_calc_sub_resp_name CONSTANT VARCHAR2(80)
40: := cn_api.get_lkup_meaning('RESPONSIBILITY_NAME', 'CALC_SUBMISSION_OBJECT_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;

Line 421: x_salesrep_id OUT NOCOPY cn_salesreps.salesrep_id%TYPE,

417:
418: END validate_calc_sub_batch;
419:
420: FUNCTION validate_salesrep ( p_salesrep_rec salesrep_rec_type,
421: x_salesrep_id OUT NOCOPY cn_salesreps.salesrep_id%TYPE,
422: x_loading_status OUT NOCOPY VARCHAR2 ) RETURN BOOLEAN IS
423:
424: CURSOR l_has_had_comp_plan_csr ( l_salesrep_id cn_salesreps.salesrep_id%TYPE) IS
425: SELECT 1

Line 424: CURSOR l_has_had_comp_plan_csr ( l_salesrep_id cn_salesreps.salesrep_id%TYPE) IS

420: FUNCTION validate_salesrep ( p_salesrep_rec salesrep_rec_type,
421: x_salesrep_id OUT NOCOPY cn_salesreps.salesrep_id%TYPE,
422: x_loading_status OUT NOCOPY VARCHAR2 ) RETURN BOOLEAN IS
423:
424: CURSOR l_has_had_comp_plan_csr ( l_salesrep_id cn_salesreps.salesrep_id%TYPE) IS
425: SELECT 1
426: FROM cn_srp_intel_periods_all
427: WHERE salesrep_id = l_salesrep_id
428: AND org_id = g_org_id;

Line 472: -- in cn_salesreps

468: return false;
469: end if;
470:
471: -- (employee_number + type) must uniquely identify one salesrep
472: -- in cn_salesreps
473: cn_api.chk_and_get_salesrep_id( p_emp_num => p_salesrep_rec.employee_number,
474: p_type => p_salesrep_rec.TYPE,
475: p_org_id => g_org_id,
476: x_salesrep_id => l_salesrep_id,