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 315: l_role_id jtf_rs_roles_vl.role_id%TYPE;

311:
312: -- Variables and Cursors added for Enh/Bug 2828368
313:
314: l_salesperson_number jtf_rs_salesreps.salesrep_number%TYPE;
315: l_role_id jtf_rs_roles_vl.role_id%TYPE;
316: l_role_name jtf_rs_roles_vl.role_name%TYPE;
317: /* Moved the initial assignment of below variable to inside begin */
318: l_sales_credit_type oe_sales_credit_types.name%TYPE;
319: l_sales_credit_type_id oe_sales_credit_types.sales_credit_type_id%TYPE;

Line 316: l_role_name jtf_rs_roles_vl.role_name%TYPE;

312: -- Variables and Cursors added for Enh/Bug 2828368
313:
314: l_salesperson_number jtf_rs_salesreps.salesrep_number%TYPE;
315: l_role_id jtf_rs_roles_vl.role_id%TYPE;
316: l_role_name jtf_rs_roles_vl.role_name%TYPE;
317: /* Moved the initial assignment of below variable to inside begin */
318: l_sales_credit_type oe_sales_credit_types.name%TYPE;
319: l_sales_credit_type_id oe_sales_credit_types.sales_credit_type_id%TYPE;
320:

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

343: SELECT role_id
344: FROM jtf_rs_job_roles
345: WHERE job_id = l_job_id;
346:
347: CURSOR c_role_name (l_role_id jtf_rs_roles_vl.role_id%TYPE) IS
348: SELECT role_name
349: FROM jtf_rs_roles_vl
350: WHERE role_id = l_role_id;
351:

Line 349: FROM jtf_rs_roles_vl

345: WHERE job_id = l_job_id;
346:
347: CURSOR c_role_name (l_role_id jtf_rs_roles_vl.role_id%TYPE) IS
348: SELECT role_name
349: FROM jtf_rs_roles_vl
350: WHERE role_id = l_role_id;
351:
352: -- Added the below cursor to get the role type for a role id.
353: CURSOR c_get_role_type (l_role_id jtf_rs_roles_vl.role_id%TYPE) IS

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

349: FROM jtf_rs_roles_vl
350: WHERE role_id = l_role_id;
351:
352: -- Added the below cursor to get the role type for a role id.
353: CURSOR c_get_role_type (l_role_id jtf_rs_roles_vl.role_id%TYPE) IS
354: SELECT role_type_code
355: FROM jtf_rs_roles_b
356: WHERE role_id = l_role_id;
357:

Line 1777: l_role_name jtf_rs_roles_vl.role_name%TYPE;

1773:
1774: l_job_id NUMBER;
1775: l_party_id NUMBER;
1776: -- l_role_relate_id NUMBER;
1777: l_role_name jtf_rs_roles_vl.role_name%TYPE;
1778: l_role_id NUMBER;
1779:
1780: l_new_job_title VARCHAR2(240);
1781: l_new_job_id NUMBER;

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

1851:
1852: l_job_roles_rec c_job_roles%ROWTYPE;
1853:
1854: -- Added the below cursor to get the role type for a role id.
1855: CURSOR c_get_role_type (l_role_id jtf_rs_roles_vl.role_id%TYPE) IS
1856: SELECT role_type_code
1857: FROM jtf_rs_roles_b
1858: WHERE role_id = l_role_id;
1859:

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

1923: AND nvl(rr.delete_flag,'N') <> 'Y'
1924: AND trunc(nvl(end_date_active,g_run_date)) >= trunc(l_new_role_st_dt);
1925:
1926:
1927: CURSOR c_role_name (l_role_id IN jtf_rs_roles_vl.role_id%TYPE) IS
1928: SELECT role_name
1929: FROM jtf_rs_roles_vl
1930: WHERE role_id = l_role_id;
1931:

Line 1929: FROM jtf_rs_roles_vl

1925:
1926:
1927: CURSOR c_role_name (l_role_id IN jtf_rs_roles_vl.role_id%TYPE) IS
1928: SELECT role_name
1929: FROM jtf_rs_roles_vl
1930: WHERE role_id = l_role_id;
1931:
1932: CURSOR c_get_assignment_id(p_job_id IN NUMBER, p_person_id IN NUMBER) IS
1933: SELECT assignment_id