eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_API dependencies on CN_SALESREPS

Line 859: RETURN cn_salesreps.name%TYPE IS

855: --| Function Name : get_salesrep_name
856: --| Desc : Pass in salesrep id then return salesrep name
857: --| ---------------------------------------------------------------------+
858: FUNCTION get_salesrep_name( p_salesrep_id NUMBER, p_org_id NUMBER)
859: RETURN cn_salesreps.name%TYPE IS
860:
861: l_salesrep_name cn_salesreps.name%TYPE;
862:
863: BEGIN

Line 861: l_salesrep_name cn_salesreps.name%TYPE;

857: --| ---------------------------------------------------------------------+
858: FUNCTION get_salesrep_name( p_salesrep_id NUMBER, p_org_id NUMBER)
859: RETURN cn_salesreps.name%TYPE IS
860:
861: l_salesrep_name cn_salesreps.name%TYPE;
862:
863: BEGIN
864: SELECT name
865: INTO l_salesrep_name

Line 866: FROM cn_salesreps

862:
863: BEGIN
864: SELECT name
865: INTO l_salesrep_name
866: FROM cn_salesreps
867: WHERE salesrep_id = p_salesrep_id
868: AND org_id = p_org_id;
869:
870: RETURN l_salesrep_name;

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

882: PROCEDURE chk_and_get_salesrep_id
883: ( p_emp_num IN VARCHAR2,
884: p_type IN VARCHAR2,
885: p_org_id IN NUMBER,
886: x_salesrep_id OUT NOCOPY cn_salesreps.salesrep_id%TYPE,
887: x_return_status OUT NOCOPY VARCHAR2,
888: x_loading_status OUT NOCOPY VARCHAR2,
889: p_show_message IN VARCHAR2) IS
890:

Line 891: l_salesrep_id cn_salesreps.salesrep_id%TYPE;

887: x_return_status OUT NOCOPY VARCHAR2,
888: x_loading_status OUT NOCOPY VARCHAR2,
889: p_show_message IN VARCHAR2) IS
890:
891: l_salesrep_id cn_salesreps.salesrep_id%TYPE;
892: l_emp_num cn_salesreps.employee_number%TYPE;
893:
894: BEGIN
895: -- change for performance. Force to hit index on employee_number

Line 892: l_emp_num cn_salesreps.employee_number%TYPE;

888: x_loading_status OUT NOCOPY VARCHAR2,
889: p_show_message IN VARCHAR2) IS
890:
891: l_salesrep_id cn_salesreps.salesrep_id%TYPE;
892: l_emp_num cn_salesreps.employee_number%TYPE;
893:
894: BEGIN
895: -- change for performance. Force to hit index on employee_number
896: -- Bug 1508614

Line 906: FROM cn_salesreps

902:
903: /* IF p_emp_num IS NULL THEN
904: SELECT salesrep_id
905: INTO l_salesrep_id
906: FROM cn_salesreps
907: WHERE employee_number IS NULL
908: AND org_id = p_org_id
909: AND ((type = p_type) OR (type IS NULL AND p_type IS NULL));
910: ELSE

Line 914: FROM cn_salesreps

910: ELSE
911: */
912: SELECT /*+ first_rows */ salesrep_id
913: INTO l_salesrep_id
914: FROM cn_salesreps
915: WHERE upper(employee_number) = l_emp_num
916: AND org_id = p_org_id
917: AND type = p_type;
918: -- END IF;

Line 958: RETURN cn_salesreps.salesrep_id%TYPE IS

954: --| Function Name : get_salesrep_id
955: --| Desc : Pass in salesrep name and employee number then return salesrep id
956: --| ---------------------------------------------------------------------+
957: FUNCTION get_salesrep_id( p_salesrep_name VARCHAR2, p_emp_num VARCHAR2, p_org_id NUMBER)
958: RETURN cn_salesreps.salesrep_id%TYPE IS
959:
960: l_salesrep_id cn_salesreps.salesrep_id%TYPE;
961:
962: BEGIN

Line 960: l_salesrep_id cn_salesreps.salesrep_id%TYPE;

956: --| ---------------------------------------------------------------------+
957: FUNCTION get_salesrep_id( p_salesrep_name VARCHAR2, p_emp_num VARCHAR2, p_org_id NUMBER)
958: RETURN cn_salesreps.salesrep_id%TYPE IS
959:
960: l_salesrep_id cn_salesreps.salesrep_id%TYPE;
961:
962: BEGIN
963: SELECT salesrep_id
964: INTO l_salesrep_id

Line 965: FROM cn_salesreps

961:
962: BEGIN
963: SELECT salesrep_id
964: INTO l_salesrep_id
965: FROM cn_salesreps
966: WHERE name = p_salesrep_name AND employee_number = p_emp_num
967: AND org_id = p_org_id;
968:
969: RETURN l_salesrep_id;

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

1257: -- Function : get_srp_role_id
1258: -- Desc : get the srp_role_id if it exists in cn_srp_roles
1259: -- --------------------------------------------------------------------------=
1260: FUNCTION get_srp_role_id
1261: (p_emp_num IN cn_salesreps.employee_number%type,
1262: p_type IN cn_salesreps.TYPE%type,
1263: p_role_name IN cn_roles.name%type,
1264: p_start_date IN cn_srp_roles.start_date%type,
1265: p_end_date IN cn_srp_roles.end_date%TYPE,

Line 1262: p_type IN cn_salesreps.TYPE%type,

1258: -- Desc : get the srp_role_id if it exists in cn_srp_roles
1259: -- --------------------------------------------------------------------------=
1260: FUNCTION get_srp_role_id
1261: (p_emp_num IN cn_salesreps.employee_number%type,
1262: p_type IN cn_salesreps.TYPE%type,
1263: p_role_name IN cn_roles.name%type,
1264: p_start_date IN cn_srp_roles.start_date%type,
1265: p_end_date IN cn_srp_roles.end_date%TYPE,
1266: p_org_id IN cn_salesreps.org_id%type

Line 1266: p_org_id IN cn_salesreps.org_id%type

1262: p_type IN cn_salesreps.TYPE%type,
1263: p_role_name IN cn_roles.name%type,
1264: p_start_date IN cn_srp_roles.start_date%type,
1265: p_end_date IN cn_srp_roles.end_date%TYPE,
1266: p_org_id IN cn_salesreps.org_id%type
1267: ) RETURN cn_srp_roles.srp_role_id%TYPE IS
1268:
1269: CURSOR l_cur(l_salesrep_id cn_srp_roles.salesrep_id%TYPE,
1270: l_role_id cn_srp_roles.role_id%TYPE,

Line 2762: FROM cn_salesreps

2758: ) RETURN VARCHAR2 IS
2759:
2760: CURSOR get_hold_status IS
2761: SELECT hold_payment, salesrep_id
2762: FROM cn_salesreps
2763: WHERE salesrep_id = p_salesrep_id
2764: AND org_id = p_org_id;
2765:
2766: l_status cn_payruns.status%TYPE;

Line 2767: l_salesrep_id cn_salesreps.salesrep_id%TYPE;

2763: WHERE salesrep_id = p_salesrep_id
2764: AND org_id = p_org_id;
2765:
2766: l_status cn_payruns.status%TYPE;
2767: l_salesrep_id cn_salesreps.salesrep_id%TYPE;
2768:
2769: BEGIN
2770:
2771: x_loading_status := p_loading_status ;

Line 2816: FROM cn_salesreps

2812: ) RETURN VARCHAR2 IS
2813:
2814: CURSOR get_hold_status IS
2815: SELECT hold_payment, salesrep_id
2816: FROM cn_salesreps
2817: WHERE salesrep_id = p_salesrep_id
2818: AND org_id = p_org_id;
2819:
2820: l_status cn_payruns.status%TYPE;

Line 2821: l_salesrep_id cn_salesreps.salesrep_id%TYPE;

2817: WHERE salesrep_id = p_salesrep_id
2818: AND org_id = p_org_id;
2819:
2820: l_status cn_payruns.status%TYPE;
2821: l_salesrep_id cn_salesreps.salesrep_id%TYPE;
2822:
2823: BEGIN
2824:
2825: x_loading_status := p_loading_status ;