APPS.JTF_RS_CONC_RES_PUB dependencies on JTF_RS_SALESREPS

Line 314: l_salesperson_number jtf_rs_salesreps.salesrep_number%TYPE;

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

Line 334: l_salesrep_id jtf_rs_salesreps.salesrep_id%TYPE;

330: s_return_status VARCHAR2(2);
331: s_msg_count NUMBER;
332: s_msg_data VARCHAR2(2000);
333:
334: l_salesrep_id jtf_rs_salesreps.salesrep_id%TYPE;
335: m_salesrep_id jtf_rs_salesreps.salesrep_id%TYPE;
336: l_role_relate_id jtf_rs_role_relations.role_relate_id%TYPE;
337:
338: CURSOR c_salesrep_number (l_salesrep_number jtf_rs_salesreps.salesrep_number%TYPE) IS

Line 335: m_salesrep_id jtf_rs_salesreps.salesrep_id%TYPE;

331: s_msg_count NUMBER;
332: s_msg_data VARCHAR2(2000);
333:
334: l_salesrep_id jtf_rs_salesreps.salesrep_id%TYPE;
335: m_salesrep_id jtf_rs_salesreps.salesrep_id%TYPE;
336: l_role_relate_id jtf_rs_role_relations.role_relate_id%TYPE;
337:
338: CURSOR c_salesrep_number (l_salesrep_number jtf_rs_salesreps.salesrep_number%TYPE) IS
339: SELECT salesrep_id FROM jtf_rs_salesreps

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

334: l_salesrep_id jtf_rs_salesreps.salesrep_id%TYPE;
335: m_salesrep_id jtf_rs_salesreps.salesrep_id%TYPE;
336: l_role_relate_id jtf_rs_role_relations.role_relate_id%TYPE;
337:
338: CURSOR c_salesrep_number (l_salesrep_number jtf_rs_salesreps.salesrep_number%TYPE) IS
339: SELECT salesrep_id FROM jtf_rs_salesreps
340: WHERE salesrep_number = l_salesrep_number;
341:
342: CURSOR c_job_roles (l_job_id jtf_rs_job_roles.job_id%TYPE) IS

Line 339: SELECT salesrep_id FROM jtf_rs_salesreps

335: m_salesrep_id jtf_rs_salesreps.salesrep_id%TYPE;
336: l_role_relate_id jtf_rs_role_relations.role_relate_id%TYPE;
337:
338: CURSOR c_salesrep_number (l_salesrep_number jtf_rs_salesreps.salesrep_number%TYPE) IS
339: SELECT salesrep_id FROM jtf_rs_salesreps
340: WHERE salesrep_number = l_salesrep_number;
341:
342: CURSOR c_job_roles (l_job_id jtf_rs_job_roles.job_id%TYPE) IS
343: SELECT role_id

Line 821: JTF_RS_SALESREPS_PUB.CREATE_SALESREP (

817:
818:
819: IF (l_salesperson_number IS NOT NULL AND l_sales_credit_type_id IS NOT NULL) THEN
820: --Create a Salesperson for the Resource Created above
821: JTF_RS_SALESREPS_PUB.CREATE_SALESREP (
822: p_api_version => 1.0,
823: p_init_msg_list => fnd_api.g_true,
824: p_commit => fnd_api.g_false,
825: p_resource_id => l_resource_id,

Line 1138: JTF_RS_SALESREPS_PUB.CREATE_SALESREP (

1134:
1135:
1136: IF (l_salesperson_number IS NOT NULL AND l_sales_credit_type_id IS NOT NULL) THEN
1137: --Create a Salesperson for the Resource Created above
1138: JTF_RS_SALESREPS_PUB.CREATE_SALESREP (
1139: p_api_version => 1.0,
1140: p_init_msg_list => fnd_api.g_true,
1141: p_commit => fnd_api.g_false,
1142: p_resource_id => l_resource_id,

Line 1547: FROM jtf_rs_salesreps

1543: and (ppl.current_employee_flag = 'Y' OR ppl.current_npw_flag = 'Y'));
1544:
1545: CURSOR c_salesreps (c_resource_id jtf_rs_resource_extns.resource_id%TYPE) IS
1546: SELECT salesrep_id
1547: FROM jtf_rs_salesreps
1548: WHERE resource_id = c_resource_id;
1549:
1550: l_salesreps_rec c_salesreps%ROWTYPE;
1551: --Bug11652884

Line 1868: -- Salesrep record in JTF_RS_SALESREPS.

1864:
1865: -- removed the code to check the org_id condition.
1866: -- As per bug # 4391220, JTF_RS_ROLE_RELATE_VUHK has been changed to be MOAC compliant
1867: -- The new validation check that a Resource it associated with at least one
1868: -- Salesrep record in JTF_RS_SALESREPS.
1869: CURSOR c_salesrep_check(c_resource_id number) IS
1870: select 'Y'
1871: from jtf_rs_salesreps
1872: where resource_id = c_resource_id;

Line 1871: from jtf_rs_salesreps

1867: -- The new validation check that a Resource it associated with at least one
1868: -- Salesrep record in JTF_RS_SALESREPS.
1869: CURSOR c_salesrep_check(c_resource_id number) IS
1870: select 'Y'
1871: from jtf_rs_salesreps
1872: where resource_id = c_resource_id;
1873: -- and nvl(org_id,-99) = nvl(c_org_id,-99);
1874:
1875: l_salesrep_extsts varchar2(2);

Line 3267: UPDATE jtf_rs_salesreps

3263: END IF;
3264: END IF;
3265:
3266: IF ((l_rehire_rev_emp_flag = 'Y') and (l_activate_salesreps = 'Y')) then
3267: UPDATE jtf_rs_salesreps
3268: SET end_date_active = NULL,
3269: last_update_date = l_sysdate,
3270: last_update_login = l_login,
3271: last_updated_by = l_user_id