APPS.CSM_SR_EVENT_PKG dependencies on JTF_RS_RESOURCE_EXTNS

Line 302: l_resource_id jtf_rs_resource_extns.resource_id%TYPE;

298: l_sqlerrno VARCHAR2(20);
299: l_sqlerrmsg VARCHAR2(4000);
300: l_error_msg VARCHAR2(4000);
301: l_return_status VARCHAR2(2000);
302: l_resource_id jtf_rs_resource_extns.resource_id%TYPE;
303: l_party_id hz_parties.party_id%TYPE;
304:
305: CURSOR l_srcontpts_csr (p_incident_id cs_incidents_all_b.incident_id%TYPE,
306: p_sr_contact_point_id NUMBER)

Line 319: FROM jtf_rs_resource_extns jtrs

315:
316: CURSOR l_emp_resource_csr (p_party_id hz_parties.party_id%TYPE)
317: IS
318: SELECT jtrs.resource_id
319: FROM jtf_rs_resource_extns jtrs
320: WHERE jtrs.source_id = p_party_id
321: AND jtrs.CATEGORY = 'EMPLOYEE'
322: AND SYSDATE BETWEEN jtrs.start_date_active AND nvl(jtrs.end_date_active, SYSDATE)
323: ;

Line 569: l_resource_id jtf_rs_resource_extns.resource_id%TYPE;

565: l_sqlerrno VARCHAR2(20);
566: l_sqlerrmsg VARCHAR2(4000);
567: l_error_msg VARCHAR2(4000);
568: l_return_status VARCHAR2(2000);
569: l_resource_id jtf_rs_resource_extns.resource_id%TYPE;
570: l_party_id hz_parties.party_id%TYPE;
571:
572: CURSOR l_srcontpts_csr (p_incident_id cs_incidents_all_b.incident_id%TYPE,
573: p_sr_contact_point_id NUMBER)

Line 586: FROM jtf_rs_resource_extns jtrs

582:
583: CURSOR l_emp_resource_csr (p_party_id hz_parties.party_id%TYPE)
584: IS
585: SELECT jtrs.resource_id
586: FROM jtf_rs_resource_extns jtrs
587: WHERE jtrs.source_id = p_party_id
588: AND jtrs.CATEGORY = 'EMPLOYEE'
589: AND SYSDATE BETWEEN jtrs.start_date_active AND nvl(jtrs.end_date_active, SYSDATE)
590: ;

Line 920: FROM JTF_RS_RESOURCE_EXTNS

916: WHERE TASK_ID=b_task_id;
917:
918: CURSOR c_resource_id(b_user_id NUMBER) IS
919: SELECT RESOURCE_ID
920: FROM JTF_RS_RESOURCE_EXTNS
921: WHERE USER_ID=b_user_id;
922:
923: --assignee bug
924: CURSOR c_user_id(b_resource_id NUMBER) IS

Line 926: FROM JTF_RS_RESOURCE_EXTNS

922:
923: --assignee bug
924: CURSOR c_user_id(b_resource_id NUMBER) IS
925: SELECT USER_ID
926: FROM JTF_RS_RESOURCE_EXTNS
927: WHERE RESOURCE_ID=b_resource_id;
928:
929: l_assignee_user_id NUMBER;
930:

Line 1152: FROM JTF_RS_RESOURCE_EXTNS

1148: WHERE TASK_ID=b_task_id;
1149:
1150: CURSOR c_resource_id(b_user_id NUMBER) IS
1151: SELECT RESOURCE_ID
1152: FROM JTF_RS_RESOURCE_EXTNS
1153: WHERE USER_ID=b_user_id;
1154:
1155: --assignee bug
1156: CURSOR c_user_id(b_resource_id NUMBER) IS

Line 1158: FROM JTF_RS_RESOURCE_EXTNS

1154:
1155: --assignee bug
1156: CURSOR c_user_id(b_resource_id NUMBER) IS
1157: SELECT USER_ID
1158: FROM JTF_RS_RESOURCE_EXTNS
1159: WHERE RESOURCE_ID=b_resource_id;
1160:
1161: l_assignee_user_id NUMBER;
1162: