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 DUAL

Line 786: -- from dual;

782:
783: -- To get the current operating unit. if l_org_id is NULL, then it is a single org
784: -- select to_number(decode(substrb(userenv('CLIENT_INFO'),1,1),' ',null,substrb(userenv('CLIENT_INFO'),1,10)))
785: -- into l_org_id
786: -- from dual;
787:
788: if l_org_id is NOT NULL then
789: OPEN op_units_cur(fetch_emp_rec.org_id,l_org_id);
790: FETCH op_units_cur INTO l_organization_id;

Line 808: FROM DUAL;

804: ELSIF (l_prof_srp_num = 'SEQUENCE_GENERATED') THEN
805: LOOP
806: SELECT jtf_rs_salesrep_number_s.nextval
807: INTO l_salesperson_number
808: FROM DUAL;
809:
810: OPEN c_salesrep_number(l_salesperson_number);
811: FETCH c_salesrep_number INTO m_salesrep_id;
812: EXIT WHEN c_salesrep_number%NOTFOUND;

Line 883: p_role_resource_type => 'RS_INDIVIDUAL',

879: JTF_RS_ROLE_RELATE_PVT.CREATE_RESOURCE_ROLE_RELATE(
880: p_api_version => 1.0,
881: p_init_msg_list => fnd_api.g_true,
882: p_commit => fnd_api.g_false,
883: p_role_resource_type => 'RS_INDIVIDUAL',
884: p_role_resource_id => l_resource_id,
885: p_role_id => i.role_id,
886: p_start_date_active => l_asg_start_date,
887: x_return_status => r_return_status,

Line 1125: FROM DUAL;

1121: ELSIF (l_prof_srp_num = 'SEQUENCE_GENERATED') THEN
1122: LOOP
1123: SELECT jtf_rs_salesrep_number_s.nextval
1124: INTO l_salesperson_number
1125: FROM DUAL;
1126:
1127: OPEN c_salesrep_number(l_salesperson_number);
1128: FETCH c_salesrep_number INTO m_salesrep_id;
1129: EXIT WHEN c_salesrep_number%NOTFOUND;

Line 1201: p_role_resource_type => 'RS_INDIVIDUAL',

1197: JTF_RS_ROLE_RELATE_PVT.CREATE_RESOURCE_ROLE_RELATE(
1198: p_api_version => 1.0,
1199: p_init_msg_list => fnd_api.g_true,
1200: p_commit => fnd_api.g_false,
1201: p_role_resource_type => 'RS_INDIVIDUAL',
1202: p_role_resource_id => l_resource_id,
1203: p_role_id => i.role_id,
1204: p_start_date_active => l_asg_start_date,
1205: x_return_status => r_return_status,

Line 1886: WHERE rr.role_resource_type = 'RS_INDIVIDUAL'

1882:
1883: CURSOR c_job_role_relations (l_role_id IN NUMBER, l_resource_id IN NUMBER) IS
1884: SELECT rr.role_relate_id, rr.object_version_number,start_date_active
1885: FROM jtf_rs_role_relations rr
1886: WHERE rr.role_resource_type = 'RS_INDIVIDUAL'
1887: AND rr.role_resource_id = l_resource_id
1888: AND rr.role_id = l_role_id
1889: AND nvl(rr.delete_flag,'N') <> 'Y'
1890: AND g_run_date between trunc(start_date_active) and trunc(nvl(end_date_active,g_run_date));

Line 1897: WHERE rr.role_resource_type = 'RS_INDIVIDUAL'

1893:
1894: CURSOR c_existing_role_relations (l_role_id IN NUMBER, l_resource_id IN NUMBER,l_asg_start_date IN DATE,l_asg_end_date IN DATE) IS
1895: SELECT rr.role_relate_id, rr.object_version_number,start_date_active,end_date_active
1896: FROM jtf_rs_role_relations rr
1897: WHERE rr.role_resource_type = 'RS_INDIVIDUAL'
1898: AND rr.role_resource_id = l_resource_id
1899: AND rr.role_id = l_role_id
1900: AND nvl(rr.delete_flag,'N') <> 'Y'
1901: AND (( l_asg_start_date between trunc(start_date_active) and trunc(nvl(end_date_active,g_run_date)))

Line 1921: AND rr.role_resource_type = 'RS_INDIVIDUAL'

1917: WHERE exists (select null
1918: from jtf_rs_job_roles jr
1919: where jr.role_id = rr.role_id
1920: and jr.job_id in (nvl(p_old_job_id,-99)))
1921: AND rr.role_resource_type = 'RS_INDIVIDUAL'
1922: AND rr.role_resource_id = l_resource_id
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:

Line 1972: -- from dual;

1968:
1969: -- To get the current operating unit. if l_org_id is NULL, then it is a single org
1970: -- select to_number(decode(substrb(userenv('CLIENT_INFO'),1,1),' ',null,substrb(userenv('CLIENT_INFO'),1,10)))
1971: -- into l_org_id
1972: -- from dual;
1973:
1974: l_salesrep_extsts := 'N';
1975: -- if l_org_id is NOT NULL then
1976: OPEN c_salesrep_check(p_resource_id);

Line 2339: p_role_resource_type => 'RS_INDIVIDUAL',

2335: JTF_RS_ROLE_RELATE_PVT.CREATE_RESOURCE_ROLE_RELATE(
2336: p_api_version => 1.0,
2337: p_init_msg_list => fnd_api.g_true,
2338: p_commit => fnd_api.g_false,
2339: p_role_resource_type => 'RS_INDIVIDUAL',
2340: p_role_resource_id => p_resource_id,
2341: p_role_id => l_job_roles_rec.role_id,
2342: p_start_date_active => l_asg_start_date,
2343: p_end_date_active => l_asg_new_end_date,

Line 2531: p_role_resource_type => 'RS_INDIVIDUAL',

2527: JTF_RS_ROLE_RELATE_PVT.CREATE_RESOURCE_ROLE_RELATE(
2528: p_api_version => 1.0,
2529: p_init_msg_list => fnd_api.g_true,
2530: p_commit => fnd_api.g_false,
2531: p_role_resource_type => 'RS_INDIVIDUAL',
2532: p_role_resource_id => p_resource_id,
2533: p_role_id => l_job_roles_rec.role_id,
2534: p_start_date_active => l_asg_start_date,
2535: p_end_date_active => l_asg_new_end_date,

Line 3070: from dual;

3066:
3067: ---fnd_file.put_line(fnd_file.log,'resource id:' || l_c_resource.resource_id);
3068: select jtf_rs_resource_extn_aud_s.nextval
3069: into l_resource_extn_aud_id
3070: from dual;
3071:
3072: JTF_RS_RESOURCE_EXTN_AUD_PKG.INSERT_ROW
3073: (
3074: X_ROWID => l_row_id ,