[Home] [Help]
724:
725: -- To get the current operating unit. if l_org_id is NULL, then it is a single org
726: -- select to_number(decode(substrb(userenv('CLIENT_INFO'),1,1),' ',null,substrb(userenv('CLIENT_INFO'),1,10)))
727: -- into l_org_id
728: -- from dual;
729:
730: if l_org_id is NOT NULL then
731: OPEN op_units_cur(fetch_emp_rec.org_id,l_org_id);
732: FETCH op_units_cur INTO l_organization_id;
746: ELSIF (l_prof_srp_num = 'SEQUENCE_GENERATED') THEN
747: LOOP
748: SELECT jtf_rs_salesrep_number_s.nextval
749: INTO l_salesperson_number
750: FROM DUAL;
751:
752: OPEN c_salesrep_number(l_salesperson_number);
753: FETCH c_salesrep_number INTO m_salesrep_id;
754: EXIT WHEN c_salesrep_number%NOTFOUND;
821: JTF_RS_ROLE_RELATE_PVT.CREATE_RESOURCE_ROLE_RELATE(
822: p_api_version => 1.0,
823: p_init_msg_list => fnd_api.g_true,
824: p_commit => fnd_api.g_false,
825: p_role_resource_type => 'RS_INDIVIDUAL',
826: p_role_resource_id => l_resource_id,
827: p_role_id => i.role_id,
828: p_start_date_active => l_asg_start_date,
829: x_return_status => r_return_status,
1063: ELSIF (l_prof_srp_num = 'SEQUENCE_GENERATED') THEN
1064: LOOP
1065: SELECT jtf_rs_salesrep_number_s.nextval
1066: INTO l_salesperson_number
1067: FROM DUAL;
1068:
1069: OPEN c_salesrep_number(l_salesperson_number);
1070: FETCH c_salesrep_number INTO m_salesrep_id;
1071: EXIT WHEN c_salesrep_number%NOTFOUND;
1139: JTF_RS_ROLE_RELATE_PVT.CREATE_RESOURCE_ROLE_RELATE(
1140: p_api_version => 1.0,
1141: p_init_msg_list => fnd_api.g_true,
1142: p_commit => fnd_api.g_false,
1143: p_role_resource_type => 'RS_INDIVIDUAL',
1144: p_role_resource_id => l_resource_id,
1145: p_role_id => i.role_id,
1146: p_start_date_active => l_asg_start_date,
1147: x_return_status => r_return_status,
1784:
1785: CURSOR c_job_role_relations (l_role_id IN NUMBER, l_resource_id IN NUMBER) IS
1786: SELECT rr.role_relate_id, rr.object_version_number
1787: FROM jtf_rs_role_relations rr
1788: WHERE rr.role_resource_type = 'RS_INDIVIDUAL'
1789: AND rr.role_resource_id = l_resource_id
1790: AND rr.role_id = l_role_id
1791: AND nvl(rr.delete_flag,'N') <> 'Y'
1792: AND g_run_date between trunc(start_date_active) and trunc(nvl(end_date_active,g_run_date));
1802: WHERE exists (select null
1803: from jtf_rs_job_roles jr
1804: where jr.role_id = rr.role_id
1805: and jr.job_id not in (nvl(p_old_job_id,-99)))
1806: AND rr.role_resource_type = 'RS_INDIVIDUAL'
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:
1838:
1839: -- To get the current operating unit. if l_org_id is NULL, then it is a single org
1840: -- select to_number(decode(substrb(userenv('CLIENT_INFO'),1,1),' ',null,substrb(userenv('CLIENT_INFO'),1,10)))
1841: -- into l_org_id
1842: -- from dual;
1843:
1844: l_salesrep_extsts := 'N';
1845: -- if l_org_id is NOT NULL then
1846: OPEN c_salesrep_check(p_resource_id);
2003: JTF_RS_ROLE_RELATE_PVT.CREATE_RESOURCE_ROLE_RELATE(
2004: p_api_version => 1.0,
2005: p_init_msg_list => fnd_api.g_true,
2006: p_commit => fnd_api.g_false,
2007: p_role_resource_type => 'RS_INDIVIDUAL',
2008: p_role_resource_id => p_resource_id,
2009: p_role_id => l_job_roles_rec.role_id,
2010: p_start_date_active => l_asg_start_date,
2011: p_end_date_active => l_asg_new_end_date,
2116: JTF_RS_ROLE_RELATE_PVT.CREATE_RESOURCE_ROLE_RELATE(
2117: p_api_version => 1.0,
2118: p_init_msg_list => fnd_api.g_true,
2119: p_commit => fnd_api.g_false,
2120: p_role_resource_type => 'RS_INDIVIDUAL',
2121: p_role_resource_id => p_resource_id,
2122: p_role_id => l_job_roles_rec.role_id,
2123: p_start_date_active => l_asg_start_date,
2124: p_end_date_active => l_asg_new_end_date,
2615:
2616: ---fnd_file.put_line(fnd_file.log,'resource id:' || l_c_resource.resource_id);
2617: select jtf_rs_resource_extn_aud_s.nextval
2618: into l_resource_extn_aud_id
2619: from dual;
2620:
2621: JTF_RS_RESOURCE_EXTN_AUD_PKG.INSERT_ROW
2622: (
2623: X_ROWID => l_row_id ,