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.JTF_RS_CONC_RES_PUB dependencies on JTF_RS_ROLES_VL

Line 257: l_role_id jtf_rs_roles_vl.role_id%TYPE;

253:
254: -- Variables and Cursors added for Enh/Bug 2828368
255:
256: l_salesperson_number jtf_rs_salesreps.salesrep_number%TYPE;
257: l_role_id jtf_rs_roles_vl.role_id%TYPE;
258: l_role_name jtf_rs_roles_vl.role_name%TYPE;
259: /* Moved the initial assignment of below variable to inside begin */
260: l_sales_credit_type oe_sales_credit_types.name%TYPE;
261: l_sales_credit_type_id oe_sales_credit_types.sales_credit_type_id%TYPE;

Line 258: l_role_name jtf_rs_roles_vl.role_name%TYPE;

254: -- Variables and Cursors added for Enh/Bug 2828368
255:
256: l_salesperson_number jtf_rs_salesreps.salesrep_number%TYPE;
257: l_role_id jtf_rs_roles_vl.role_id%TYPE;
258: l_role_name jtf_rs_roles_vl.role_name%TYPE;
259: /* Moved the initial assignment of below variable to inside begin */
260: l_sales_credit_type oe_sales_credit_types.name%TYPE;
261: l_sales_credit_type_id oe_sales_credit_types.sales_credit_type_id%TYPE;
262:

Line 289: CURSOR c_role_name (l_role_id jtf_rs_roles_vl.role_id%TYPE) IS

285: SELECT role_id
286: FROM jtf_rs_job_roles
287: WHERE job_id = l_job_id;
288:
289: CURSOR c_role_name (l_role_id jtf_rs_roles_vl.role_id%TYPE) IS
290: SELECT role_name
291: FROM jtf_rs_roles_vl
292: WHERE role_id = l_role_id;
293:

Line 291: FROM jtf_rs_roles_vl

287: WHERE job_id = l_job_id;
288:
289: CURSOR c_role_name (l_role_id jtf_rs_roles_vl.role_id%TYPE) IS
290: SELECT role_name
291: FROM jtf_rs_roles_vl
292: WHERE role_id = l_role_id;
293:
294: -- Added the below cursor to get the role type for a role id.
295: CURSOR c_get_role_type (l_role_id jtf_rs_roles_vl.role_id%TYPE) IS

Line 295: CURSOR c_get_role_type (l_role_id jtf_rs_roles_vl.role_id%TYPE) IS

291: FROM jtf_rs_roles_vl
292: WHERE role_id = l_role_id;
293:
294: -- Added the below cursor to get the role type for a role id.
295: CURSOR c_get_role_type (l_role_id jtf_rs_roles_vl.role_id%TYPE) IS
296: SELECT role_type_code
297: FROM jtf_rs_roles_b
298: WHERE role_id = l_role_id;
299:

Line 1707: l_role_name jtf_rs_roles_vl.role_name%TYPE;

1703:
1704: l_job_id NUMBER;
1705: l_party_id NUMBER;
1706: -- l_role_relate_id NUMBER;
1707: l_role_name jtf_rs_roles_vl.role_name%TYPE;
1708: l_role_id NUMBER;
1709:
1710: l_new_job_title VARCHAR2(240);
1711: l_new_job_id NUMBER;

Line 1757: CURSOR c_get_role_type (l_role_id jtf_rs_roles_vl.role_id%TYPE) IS

1753:
1754: l_job_roles_rec c_job_roles%ROWTYPE;
1755:
1756: -- Added the below cursor to get the role type for a role id.
1757: CURSOR c_get_role_type (l_role_id jtf_rs_roles_vl.role_id%TYPE) IS
1758: SELECT role_type_code
1759: FROM jtf_rs_roles_b
1760: WHERE role_id = l_role_id;
1761:

Line 1811: CURSOR c_role_name (l_role_id IN jtf_rs_roles_vl.role_id%TYPE) IS

1807: AND rr.role_resource_id = l_resource_id
1808: AND nvl(rr.delete_flag,'N') <> 'Y'
1809: AND trunc(nvl(end_date_active,g_run_date)) >= trunc(l_new_role_st_dt);
1810:
1811: CURSOR c_role_name (l_role_id IN jtf_rs_roles_vl.role_id%TYPE) IS
1812: SELECT role_name
1813: FROM jtf_rs_roles_vl
1814: WHERE role_id = l_role_id;
1815:

Line 1813: FROM jtf_rs_roles_vl

1809: AND trunc(nvl(end_date_active,g_run_date)) >= trunc(l_new_role_st_dt);
1810:
1811: CURSOR c_role_name (l_role_id IN jtf_rs_roles_vl.role_id%TYPE) IS
1812: SELECT role_name
1813: FROM jtf_rs_roles_vl
1814: WHERE role_id = l_role_id;
1815:
1816: CURSOR c_get_assignment_id(p_job_id IN NUMBER, p_person_id IN NUMBER) IS
1817: SELECT assignment_id