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_SRP_ROLES

Line 1236: -- Desc : get the srp_role_id if it exists in cn_srp_roles

1232: END get_role_name;
1233:
1234: -- --------------------------------------------------------------------------=
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,

Line 1242: p_start_date IN cn_srp_roles.start_date%type,

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
1245: ) RETURN cn_srp_roles.srp_role_id%TYPE IS
1246:

Line 1243: p_end_date IN cn_srp_roles.end_date%TYPE,

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
1245: ) RETURN cn_srp_roles.srp_role_id%TYPE IS
1246:
1247: CURSOR l_cur(l_salesrep_id cn_srp_roles.salesrep_id%TYPE,

Line 1245: ) RETURN cn_srp_roles.srp_role_id%TYPE IS

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,
1249: l_start_date cn_srp_roles.start_date%TYPE,

Line 1247: CURSOR l_cur(l_salesrep_id cn_srp_roles.salesrep_id%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,
1249: l_start_date cn_srp_roles.start_date%TYPE,
1250: l_end_date cn_srp_roles.end_date%TYPE) IS
1251: SELECT srp_role_id

Line 1248: l_role_id cn_srp_roles.role_id%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,
1249: l_start_date cn_srp_roles.start_date%TYPE,
1250: l_end_date cn_srp_roles.end_date%TYPE) IS
1251: SELECT srp_role_id
1252: FROM cn_srp_roles

Line 1249: l_start_date cn_srp_roles.start_date%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,
1249: l_start_date cn_srp_roles.start_date%TYPE,
1250: l_end_date cn_srp_roles.end_date%TYPE) IS
1251: SELECT srp_role_id
1252: FROM cn_srp_roles
1253: WHERE role_id = l_role_id AND

Line 1250: l_end_date cn_srp_roles.end_date%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,
1249: l_start_date cn_srp_roles.start_date%TYPE,
1250: l_end_date cn_srp_roles.end_date%TYPE) IS
1251: SELECT srp_role_id
1252: FROM cn_srp_roles
1253: WHERE role_id = l_role_id AND
1254: salesrep_id = l_salesrep_id AND

Line 1252: FROM cn_srp_roles

1248: l_role_id cn_srp_roles.role_id%TYPE,
1249: l_start_date cn_srp_roles.start_date%TYPE,
1250: l_end_date cn_srp_roles.end_date%TYPE) IS
1251: SELECT srp_role_id
1252: FROM cn_srp_roles
1253: WHERE role_id = l_role_id AND
1254: salesrep_id = l_salesrep_id AND
1255: start_date = l_start_date AND
1256: org_id = p_org_id AND

Line 1261: l_role_id cn_srp_roles.role_id%TYPE;

1257: ((end_date = l_end_date) OR
1258: (end_date IS NULL AND l_end_date IS NULL));
1259:
1260: l_rec l_cur%ROWTYPE;
1261: l_role_id cn_srp_roles.role_id%TYPE;
1262: l_salesrep_id cn_srp_roles.salesrep_id%TYPE;
1263: l_return_status VARCHAR2(2000);
1264: l_loading_status VARCHAR2(2000);
1265:

Line 1262: l_salesrep_id cn_srp_roles.salesrep_id%TYPE;

1258: (end_date IS NULL AND l_end_date IS NULL));
1259:
1260: l_rec l_cur%ROWTYPE;
1261: l_role_id cn_srp_roles.role_id%TYPE;
1262: l_salesrep_id cn_srp_roles.salesrep_id%TYPE;
1263: l_return_status VARCHAR2(2000);
1264: l_loading_status VARCHAR2(2000);
1265:
1266: BEGIN

Line 3064: (SELECT 1 FROM cn_srp_roles sr, cn_period_statuses cnps

3060: l_exist := 0;
3061: BEGIN
3062: -- isPayee if have Payee role in this period
3063: SELECT 1 INTO l_exist FROM dual WHERE EXISTS
3064: (SELECT 1 FROM cn_srp_roles sr, cn_period_statuses cnps
3065: WHERE sr.salesrep_id = p_salesrep_id
3066: AND sr.role_id = 54
3067: AND sr.org_id = p_org_id
3068: AND cnps.org_id = p_org_id