APPS.JTF_RS_CONC_RES_PUB dependencies on JTF_RS_SALESREPS

Line 256: l_salesperson_number jtf_rs_salesreps.salesrep_number%TYPE;

252: -- l_msg_data1 varchar2(5000);
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;

Line 276: l_salesrep_id jtf_rs_salesreps.salesrep_id%TYPE;

272: s_return_status VARCHAR2(2);
273: s_msg_count NUMBER;
274: s_msg_data VARCHAR2(2000);
275:
276: l_salesrep_id jtf_rs_salesreps.salesrep_id%TYPE;
277: m_salesrep_id jtf_rs_salesreps.salesrep_id%TYPE;
278: l_role_relate_id jtf_rs_role_relations.role_relate_id%TYPE;
279:
280: CURSOR c_salesrep_number (l_salesrep_number jtf_rs_salesreps.salesrep_number%TYPE) IS

Line 277: m_salesrep_id jtf_rs_salesreps.salesrep_id%TYPE;

273: s_msg_count NUMBER;
274: s_msg_data VARCHAR2(2000);
275:
276: l_salesrep_id jtf_rs_salesreps.salesrep_id%TYPE;
277: m_salesrep_id jtf_rs_salesreps.salesrep_id%TYPE;
278: l_role_relate_id jtf_rs_role_relations.role_relate_id%TYPE;
279:
280: CURSOR c_salesrep_number (l_salesrep_number jtf_rs_salesreps.salesrep_number%TYPE) IS
281: SELECT salesrep_id FROM jtf_rs_salesreps

Line 280: CURSOR c_salesrep_number (l_salesrep_number jtf_rs_salesreps.salesrep_number%TYPE) IS

276: l_salesrep_id jtf_rs_salesreps.salesrep_id%TYPE;
277: m_salesrep_id jtf_rs_salesreps.salesrep_id%TYPE;
278: l_role_relate_id jtf_rs_role_relations.role_relate_id%TYPE;
279:
280: CURSOR c_salesrep_number (l_salesrep_number jtf_rs_salesreps.salesrep_number%TYPE) IS
281: SELECT salesrep_id FROM jtf_rs_salesreps
282: WHERE salesrep_number = l_salesrep_number;
283:
284: CURSOR c_job_roles (l_job_id jtf_rs_job_roles.job_id%TYPE) IS

Line 281: SELECT salesrep_id FROM jtf_rs_salesreps

277: m_salesrep_id jtf_rs_salesreps.salesrep_id%TYPE;
278: l_role_relate_id jtf_rs_role_relations.role_relate_id%TYPE;
279:
280: CURSOR c_salesrep_number (l_salesrep_number jtf_rs_salesreps.salesrep_number%TYPE) IS
281: SELECT salesrep_id FROM jtf_rs_salesreps
282: WHERE salesrep_number = l_salesrep_number;
283:
284: CURSOR c_job_roles (l_job_id jtf_rs_job_roles.job_id%TYPE) IS
285: SELECT role_id

Line 763: JTF_RS_SALESREPS_PUB.CREATE_SALESREP (

759:
760:
761: IF (l_salesperson_number IS NOT NULL AND l_sales_credit_type_id IS NOT NULL) THEN
762: --Create a Salesperson for the Resource Created above
763: JTF_RS_SALESREPS_PUB.CREATE_SALESREP (
764: p_api_version => 1.0,
765: p_init_msg_list => fnd_api.g_true,
766: p_commit => fnd_api.g_false,
767: p_resource_id => l_resource_id,

Line 1080: JTF_RS_SALESREPS_PUB.CREATE_SALESREP (

1076:
1077:
1078: IF (l_salesperson_number IS NOT NULL AND l_sales_credit_type_id IS NOT NULL) THEN
1079: --Create a Salesperson for the Resource Created above
1080: JTF_RS_SALESREPS_PUB.CREATE_SALESREP (
1081: p_api_version => 1.0,
1082: p_init_msg_list => fnd_api.g_true,
1083: p_commit => fnd_api.g_false,
1084: p_resource_id => l_resource_id,

Line 1489: FROM jtf_rs_salesreps

1485: and (ppl.current_employee_flag = 'Y' OR ppl.current_npw_flag = 'Y'));
1486:
1487: CURSOR c_salesreps (c_resource_id jtf_rs_resource_extns.resource_id%TYPE) IS
1488: SELECT salesrep_id
1489: FROM jtf_rs_salesreps
1490: WHERE resource_id = c_resource_id;
1491:
1492: l_salesreps_rec c_salesreps%ROWTYPE;
1493:

Line 1770: -- Salesrep record in JTF_RS_SALESREPS.

1766:
1767: -- removed the code to check the org_id condition.
1768: -- As per bug # 4391220, JTF_RS_ROLE_RELATE_VUHK has been changed to be MOAC compliant
1769: -- The new validation check that a Resource it associated with at least one
1770: -- Salesrep record in JTF_RS_SALESREPS.
1771: CURSOR c_salesrep_check(c_resource_id number) IS
1772: select 'Y'
1773: from jtf_rs_salesreps
1774: where resource_id = c_resource_id;

Line 1773: from jtf_rs_salesreps

1769: -- The new validation check that a Resource it associated with at least one
1770: -- Salesrep record in JTF_RS_SALESREPS.
1771: CURSOR c_salesrep_check(c_resource_id number) IS
1772: select 'Y'
1773: from jtf_rs_salesreps
1774: where resource_id = c_resource_id;
1775: -- and nvl(org_id,-99) = nvl(c_org_id,-99);
1776:
1777: l_salesrep_extsts varchar2(2);

Line 2816: UPDATE jtf_rs_salesreps

2812: END IF;
2813: END IF;
2814:
2815: IF ((l_rehire_rev_emp_flag = 'Y') and (l_activate_salesreps = 'Y')) then
2816: UPDATE jtf_rs_salesreps
2817: SET end_date_active = NULL,
2818: last_update_date = l_sysdate,
2819: last_update_login = l_login,
2820: last_updated_by = l_user_id