APPS.CN_API dependencies on CN_SALESREPS

Line 288: RETURN cn_salesreps.name%TYPE;

284: --| Function Name : get_salesrep_name
285: --| Desc : Pass in salesrep id then return salesrep name
286: --| ---------------------------------------------------------------------+
287: FUNCTION get_salesrep_name( p_salesrep_id NUMBER, p_org_id NUMBER)
288: RETURN cn_salesreps.name%TYPE;
289:
290: ----PRAGMA RESTRICT_REFERENCES (get_salesrep_name,WNDS,WNPS);
291:
292: --| ---------------------------------------------------------------------+

Line 297: RETURN cn_salesreps.salesrep_id%TYPE;

293: --| Function Name : get_salesrep_id
294: --| Desc : Pass in salesrep name and employee number then return salesrep id
295: --| ---------------------------------------------------------------------+
296: FUNCTION get_salesrep_id( p_salesrep_name VARCHAR2, p_emp_num VARCHAR2, p_org_id NUMBER)
297: RETURN cn_salesreps.salesrep_id%TYPE;
298:
299: --| ---------------------------------------------------------------------+
300: --| Function Name : chk_and_get_salesrep_id
301: --| Desc : Pass in employee number and salesrep type,

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

303: --| ---------------------------------------------------------------------+
304: PROCEDURE chk_and_get_salesrep_id( p_emp_num IN VARCHAR2,
305: p_type IN VARCHAR2,
306: p_org_id IN NUMBER,
307: x_salesrep_id OUT NOCOPY cn_salesreps.salesrep_id%TYPE,
308: x_return_status OUT NOCOPY VARCHAR2,
309: x_loading_status OUT NOCOPY VARCHAR2,
310: p_show_message IN VARCHAR2 := FND_API.G_TRUE);
311:

Line 413: (p_emp_num IN cn_salesreps.employee_number%type,

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,
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,

Line 414: p_type IN cn_salesreps.TYPE%type,

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,
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

Line 418: p_org_id IN cn_salesreps.org_id%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
422: --| Desc : Get the srp_payee_assign_id using the