APPS.CN_API dependencies on CN_SRP_ROLES

Line 410: -- Desc : get the srp_role_plan_id if it exists in cn_srp_roles

406: p_org_id IN NUMBER
407: ) RETURN cn_role_pmt_plans.role_pmt_plan_id%TYPE;
408: -- --------------------------------------------------------------------------+
409: -- Function : get_srp_role_plan_id
410: -- Desc : get the srp_role_plan_id if it exists in cn_srp_roles
411: -- --------------------------------------------------------------------------+
412: FUNCTION get_srp_role_id
413: (p_emp_num IN cn_salesreps.employee_number%type,
414: p_type IN cn_salesreps.TYPE%type,

Line 416: p_start_date IN cn_srp_roles.start_date%type,

412: FUNCTION get_srp_role_id
413: (p_emp_num IN cn_salesreps.employee_number%type,
414: p_type IN cn_salesreps.TYPE%type,
415: p_role_name IN cn_roles.name%type,
416: p_start_date IN cn_srp_roles.start_date%type,
417: p_end_date IN cn_srp_roles.end_date%TYPE,
418: p_org_id IN cn_salesreps.org_id%type
419: ) RETURN cn_srp_roles.srp_role_id%TYPE;
420: --| ---------------------------------------------------------------------+

Line 417: p_end_date IN cn_srp_roles.end_date%TYPE,

413: (p_emp_num IN cn_salesreps.employee_number%type,
414: p_type IN cn_salesreps.TYPE%type,
415: p_role_name IN cn_roles.name%type,
416: p_start_date IN cn_srp_roles.start_date%type,
417: p_end_date IN cn_srp_roles.end_date%TYPE,
418: p_org_id IN cn_salesreps.org_id%type
419: ) RETURN cn_srp_roles.srp_role_id%TYPE;
420: --| ---------------------------------------------------------------------+
421: --| Function Name : get_srp_payee_assign_id

Line 419: ) RETURN cn_srp_roles.srp_role_id%TYPE;

415: p_role_name IN cn_roles.name%type,
416: p_start_date IN cn_srp_roles.start_date%type,
417: p_end_date IN cn_srp_roles.end_date%TYPE,
418: p_org_id IN cn_salesreps.org_id%type
419: ) RETURN cn_srp_roles.srp_role_id%TYPE;
420: --| ---------------------------------------------------------------------+
421: --| Function Name : get_srp_payee_assign_id
422: --| Desc : Get the srp_payee_assign_id using the
423: --| payee_id, salesrep_id, quota_id, start_date, end_date