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 1258: -- Desc : get the srp_role_id if it exists in cn_srp_roles

1254: END get_role_name;
1255:
1256: -- --------------------------------------------------------------------------=
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,

Line 1264: p_start_date IN cn_srp_roles.start_date%type,

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

Line 1265: p_end_date IN cn_srp_roles.end_date%TYPE,

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
1267: ) RETURN cn_srp_roles.srp_role_id%TYPE IS
1268:
1269: CURSOR l_cur(l_salesrep_id cn_srp_roles.salesrep_id%TYPE,

Line 1267: ) RETURN cn_srp_roles.srp_role_id%TYPE IS

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

Line 1269: CURSOR l_cur(l_salesrep_id cn_srp_roles.salesrep_id%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,
1271: l_start_date cn_srp_roles.start_date%TYPE,
1272: l_end_date cn_srp_roles.end_date%TYPE) IS
1273: SELECT srp_role_id

Line 1270: l_role_id cn_srp_roles.role_id%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,
1271: l_start_date cn_srp_roles.start_date%TYPE,
1272: l_end_date cn_srp_roles.end_date%TYPE) IS
1273: SELECT srp_role_id
1274: FROM cn_srp_roles

Line 1271: l_start_date cn_srp_roles.start_date%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,
1271: l_start_date cn_srp_roles.start_date%TYPE,
1272: l_end_date cn_srp_roles.end_date%TYPE) IS
1273: SELECT srp_role_id
1274: FROM cn_srp_roles
1275: WHERE role_id = l_role_id AND

Line 1272: l_end_date cn_srp_roles.end_date%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,
1271: l_start_date cn_srp_roles.start_date%TYPE,
1272: l_end_date cn_srp_roles.end_date%TYPE) IS
1273: SELECT srp_role_id
1274: FROM cn_srp_roles
1275: WHERE role_id = l_role_id AND
1276: salesrep_id = l_salesrep_id AND

Line 1274: FROM cn_srp_roles

1270: l_role_id cn_srp_roles.role_id%TYPE,
1271: l_start_date cn_srp_roles.start_date%TYPE,
1272: l_end_date cn_srp_roles.end_date%TYPE) IS
1273: SELECT srp_role_id
1274: FROM cn_srp_roles
1275: WHERE role_id = l_role_id AND
1276: salesrep_id = l_salesrep_id AND
1277: start_date = l_start_date AND
1278: org_id = p_org_id AND

Line 1283: l_role_id cn_srp_roles.role_id%TYPE;

1279: ((end_date = l_end_date) OR
1280: (end_date IS NULL AND l_end_date IS NULL));
1281:
1282: l_rec l_cur%ROWTYPE;
1283: l_role_id cn_srp_roles.role_id%TYPE;
1284: l_salesrep_id cn_srp_roles.salesrep_id%TYPE;
1285: l_return_status VARCHAR2(2000);
1286: l_loading_status VARCHAR2(2000);
1287:

Line 1284: l_salesrep_id cn_srp_roles.salesrep_id%TYPE;

1280: (end_date IS NULL AND l_end_date IS NULL));
1281:
1282: l_rec l_cur%ROWTYPE;
1283: l_role_id cn_srp_roles.role_id%TYPE;
1284: l_salesrep_id cn_srp_roles.salesrep_id%TYPE;
1285: l_return_status VARCHAR2(2000);
1286: l_loading_status VARCHAR2(2000);
1287:
1288: BEGIN

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

3082: l_exist := 0;
3083: BEGIN
3084: -- isPayee if have Payee role in this period
3085: SELECT 1 INTO l_exist FROM dual WHERE EXISTS
3086: (SELECT 1 FROM cn_srp_roles sr, cn_period_statuses cnps
3087: WHERE sr.salesrep_id = p_salesrep_id
3088: AND sr.role_id = 54
3089: AND sr.org_id = p_org_id
3090: AND cnps.org_id = p_org_id