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 577: l_resource_id jtf_rs_resource_extns.resource_id%TYPE;

573: l_sqlerrno VARCHAR2(20);
574: l_sqlerrmsg VARCHAR2(4000);
575: l_error_msg VARCHAR2(4000);
576: l_return_status VARCHAR2(2000);
577: l_resource_id jtf_rs_resource_extns.resource_id%TYPE;
578: l_party_id hz_parties.party_id%TYPE;
579:
580: CURSOR l_srcontpts_csr (p_incident_id cs_incidents_all_b.incident_id%TYPE,
581: p_sr_contact_point_id NUMBER)

Line 594: FROM jtf_rs_resource_extns jtrs

590:
591: CURSOR l_emp_resource_csr (p_party_id hz_parties.party_id%TYPE)
592: IS
593: SELECT jtrs.resource_id
594: FROM jtf_rs_resource_extns jtrs
595: WHERE jtrs.source_id = p_party_id
596: AND jtrs.CATEGORY = 'EMPLOYEE'
597: AND SYSDATE BETWEEN jtrs.start_date_active AND nvl(jtrs.end_date_active, SYSDATE)
598: ;

Line 936: FROM JTF_RS_RESOURCE_EXTNS

932: WHERE TASK_ID=b_task_id;
933:
934: CURSOR c_resource_id(b_user_id NUMBER) IS
935: SELECT RESOURCE_ID
936: FROM JTF_RS_RESOURCE_EXTNS
937: WHERE USER_ID=b_user_id;
938:
939: --assignee bug
940: CURSOR c_user_id(b_resource_id NUMBER) IS

Line 942: FROM JTF_RS_RESOURCE_EXTNS

938:
939: --assignee bug
940: CURSOR c_user_id(b_resource_id NUMBER) IS
941: SELECT USER_ID
942: FROM JTF_RS_RESOURCE_EXTNS
943: WHERE RESOURCE_ID=b_resource_id;
944:
945: l_assignee_user_id NUMBER;
946:

Line 1175: FROM JTF_RS_RESOURCE_EXTNS

1171: WHERE TASK_ID=b_task_id;
1172:
1173: CURSOR c_resource_id(b_user_id NUMBER) IS
1174: SELECT RESOURCE_ID
1175: FROM JTF_RS_RESOURCE_EXTNS
1176: WHERE USER_ID=b_user_id;
1177:
1178: --assignee bug
1179: CURSOR c_user_id(b_resource_id NUMBER) IS

Line 1181: FROM JTF_RS_RESOURCE_EXTNS

1177:
1178: --assignee bug
1179: CURSOR c_user_id(b_resource_id NUMBER) IS
1180: SELECT USER_ID
1181: FROM JTF_RS_RESOURCE_EXTNS
1182: WHERE RESOURCE_ID=b_resource_id;
1183:
1184: l_assignee_user_id NUMBER;
1185: