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 837: RETURN cn_salesreps.name%TYPE IS

833: --| Function Name : get_salesrep_name
834: --| Desc : Pass in salesrep id then return salesrep name
835: --| ---------------------------------------------------------------------+
836: FUNCTION get_salesrep_name( p_salesrep_id NUMBER, p_org_id NUMBER)
837: RETURN cn_salesreps.name%TYPE IS
838:
839: l_salesrep_name cn_salesreps.name%TYPE;
840:
841: BEGIN

Line 839: l_salesrep_name cn_salesreps.name%TYPE;

835: --| ---------------------------------------------------------------------+
836: FUNCTION get_salesrep_name( p_salesrep_id NUMBER, p_org_id NUMBER)
837: RETURN cn_salesreps.name%TYPE IS
838:
839: l_salesrep_name cn_salesreps.name%TYPE;
840:
841: BEGIN
842: SELECT name
843: INTO l_salesrep_name

Line 844: FROM cn_salesreps

840:
841: BEGIN
842: SELECT name
843: INTO l_salesrep_name
844: FROM cn_salesreps
845: WHERE salesrep_id = p_salesrep_id
846: AND org_id = p_org_id;
847:
848: RETURN l_salesrep_name;

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

860: PROCEDURE chk_and_get_salesrep_id
861: ( p_emp_num IN VARCHAR2,
862: p_type IN VARCHAR2,
863: p_org_id IN NUMBER,
864: x_salesrep_id OUT NOCOPY cn_salesreps.salesrep_id%TYPE,
865: x_return_status OUT NOCOPY VARCHAR2,
866: x_loading_status OUT NOCOPY VARCHAR2,
867: p_show_message IN VARCHAR2) IS
868:

Line 869: l_salesrep_id cn_salesreps.salesrep_id%TYPE;

865: x_return_status OUT NOCOPY VARCHAR2,
866: x_loading_status OUT NOCOPY VARCHAR2,
867: p_show_message IN VARCHAR2) IS
868:
869: l_salesrep_id cn_salesreps.salesrep_id%TYPE;
870: l_emp_num cn_salesreps.employee_number%TYPE;
871:
872: BEGIN
873: -- change for performance. Force to hit index on employee_number

Line 870: l_emp_num cn_salesreps.employee_number%TYPE;

866: x_loading_status OUT NOCOPY VARCHAR2,
867: p_show_message IN VARCHAR2) IS
868:
869: l_salesrep_id cn_salesreps.salesrep_id%TYPE;
870: l_emp_num cn_salesreps.employee_number%TYPE;
871:
872: BEGIN
873: -- change for performance. Force to hit index on employee_number
874: -- Bug 1508614

Line 884: FROM cn_salesreps

880:
881: /* IF p_emp_num IS NULL THEN
882: SELECT salesrep_id
883: INTO l_salesrep_id
884: FROM cn_salesreps
885: WHERE employee_number IS NULL
886: AND org_id = p_org_id
887: AND ((type = p_type) OR (type IS NULL AND p_type IS NULL));
888: ELSE

Line 892: FROM cn_salesreps

888: ELSE
889: */
890: SELECT /*+ first_rows */ salesrep_id
891: INTO l_salesrep_id
892: FROM cn_salesreps
893: WHERE upper(employee_number) = l_emp_num
894: AND org_id = p_org_id
895: AND type = p_type;
896: -- END IF;

Line 936: RETURN cn_salesreps.salesrep_id%TYPE IS

932: --| Function Name : get_salesrep_id
933: --| Desc : Pass in salesrep name and employee number then return salesrep id
934: --| ---------------------------------------------------------------------+
935: FUNCTION get_salesrep_id( p_salesrep_name VARCHAR2, p_emp_num VARCHAR2, p_org_id NUMBER)
936: RETURN cn_salesreps.salesrep_id%TYPE IS
937:
938: l_salesrep_id cn_salesreps.salesrep_id%TYPE;
939:
940: BEGIN

Line 938: l_salesrep_id cn_salesreps.salesrep_id%TYPE;

934: --| ---------------------------------------------------------------------+
935: FUNCTION get_salesrep_id( p_salesrep_name VARCHAR2, p_emp_num VARCHAR2, p_org_id NUMBER)
936: RETURN cn_salesreps.salesrep_id%TYPE IS
937:
938: l_salesrep_id cn_salesreps.salesrep_id%TYPE;
939:
940: BEGIN
941: SELECT salesrep_id
942: INTO l_salesrep_id

Line 943: FROM cn_salesreps

939:
940: BEGIN
941: SELECT salesrep_id
942: INTO l_salesrep_id
943: FROM cn_salesreps
944: WHERE name = p_salesrep_name AND employee_number = p_emp_num
945: AND org_id = p_org_id;
946:
947: RETURN l_salesrep_id;

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

1235: -- Function : get_srp_role_id
1236: -- Desc : get the srp_role_id if it exists in cn_srp_roles
1237: -- --------------------------------------------------------------------------=
1238: FUNCTION get_srp_role_id
1239: (p_emp_num IN cn_salesreps.employee_number%type,
1240: p_type IN cn_salesreps.TYPE%type,
1241: p_role_name IN cn_roles.name%type,
1242: p_start_date IN cn_srp_roles.start_date%type,
1243: p_end_date IN cn_srp_roles.end_date%TYPE,

Line 1240: p_type IN cn_salesreps.TYPE%type,

1236: -- Desc : get the srp_role_id if it exists in cn_srp_roles
1237: -- --------------------------------------------------------------------------=
1238: FUNCTION get_srp_role_id
1239: (p_emp_num IN cn_salesreps.employee_number%type,
1240: p_type IN cn_salesreps.TYPE%type,
1241: p_role_name IN cn_roles.name%type,
1242: p_start_date IN cn_srp_roles.start_date%type,
1243: p_end_date IN cn_srp_roles.end_date%TYPE,
1244: p_org_id IN cn_salesreps.org_id%type

Line 1244: p_org_id IN cn_salesreps.org_id%type

1240: p_type IN cn_salesreps.TYPE%type,
1241: p_role_name IN cn_roles.name%type,
1242: p_start_date IN cn_srp_roles.start_date%type,
1243: p_end_date IN cn_srp_roles.end_date%TYPE,
1244: p_org_id IN cn_salesreps.org_id%type
1245: ) RETURN cn_srp_roles.srp_role_id%TYPE IS
1246:
1247: CURSOR l_cur(l_salesrep_id cn_srp_roles.salesrep_id%TYPE,
1248: l_role_id cn_srp_roles.role_id%TYPE,

Line 2740: FROM cn_salesreps

2736: ) RETURN VARCHAR2 IS
2737:
2738: CURSOR get_hold_status IS
2739: SELECT hold_payment, salesrep_id
2740: FROM cn_salesreps
2741: WHERE salesrep_id = p_salesrep_id
2742: AND org_id = p_org_id;
2743:
2744: l_status cn_payruns.status%TYPE;

Line 2745: l_salesrep_id cn_salesreps.salesrep_id%TYPE;

2741: WHERE salesrep_id = p_salesrep_id
2742: AND org_id = p_org_id;
2743:
2744: l_status cn_payruns.status%TYPE;
2745: l_salesrep_id cn_salesreps.salesrep_id%TYPE;
2746:
2747: BEGIN
2748:
2749: x_loading_status := p_loading_status ;

Line 2794: FROM cn_salesreps

2790: ) RETURN VARCHAR2 IS
2791:
2792: CURSOR get_hold_status IS
2793: SELECT hold_payment, salesrep_id
2794: FROM cn_salesreps
2795: WHERE salesrep_id = p_salesrep_id
2796: AND org_id = p_org_id;
2797:
2798: l_status cn_payruns.status%TYPE;

Line 2799: l_salesrep_id cn_salesreps.salesrep_id%TYPE;

2795: WHERE salesrep_id = p_salesrep_id
2796: AND org_id = p_org_id;
2797:
2798: l_status cn_payruns.status%TYPE;
2799: l_salesrep_id cn_salesreps.salesrep_id%TYPE;
2800:
2801: BEGIN
2802:
2803: x_loading_status := p_loading_status ;