[Home] [Help]
970:
971: CURSOR c_sr(b_sr_id NUMBER,b_user_id NUMBER)
972: IS
973: SELECT 1
974: FROM jtf_task_assignments asg, csm_auto_sync_nfn nfn,
975: asg_system_dirty_queue sdq,csm_auto_sync_nfn_acc acc,
976: jtf_tasks_b tsk
977: where tsk.source_object_id=b_sr_id
978: and tsk.source_object_type_code='SR'
995: and rownum < 2;
996:
997: CURSOR c_task(b_task_id NUMBER,b_user_id NUMBER) IS
998: SELECT 1
999: FROM jtf_task_assignments asg, csm_auto_sync_nfn nfn,
1000: asg_system_dirty_queue sdq,csm_auto_sync_nfn_acc acc
1001: where task_id=b_task_id
1002: and (
1003: (nfn.object_name='TASK' and nfn.object_id=task_id)
1016:
1017:
1018: CURSOR c_task_asg(b_task_ass_id NUMBER,b_user_id NUMBER) IS
1019: SELECT 1
1020: FROM jtf_task_assignments asg, csm_auto_sync_nfn nfn,
1021: asg_system_dirty_queue sdq,csm_auto_sync_nfn_acc acc,
1022: jtf_tasks_b tsk
1023: where task_assignment_id=b_task_ass_id
1024: and tsk.task_id=asg.task_id
1068: BEGIN
1069: IF l_mode='TASK' THEN
1070: SELECT 1 INTO l_yes FROM JTF_TASKS_B WHERE TASK_ID=l_pk AND SOURCE_OBJECT_TYPE_CODE='TASK';
1071: ELSE
1072: SELECT 1 INTO l_yes FROM JTF_TASKS_B A,JTF_TASK_ASSIGNMENTS B
1073: WHERE TASK_ASSIGNMENT_ID=l_pk AND B.TASK_ID=A.TASK_ID AND A.SOURCE_OBJECT_TYPE_CODE='TASK';
1074: END IF;
1075: RETURN TRUE;
1076: EXCEPTION
1089: (select location_id from hz_party_sites where party_site_id = NVL(inc.incident_location_id, inc.install_site_id)),
1090: 'HZ_LOCATION',
1091: (select location_id from hz_locations where location_id = NVL(inc.incident_location_id, inc.install_site_id))
1092: ) location_id
1093: FROM ASG_USER AU, JTF_TASK_ASSIGNMENTS b,CSM_TASK_ASSIGNMENTS_ACC ACC,
1094: JTF_TASKS_B tsk,JTF_TASKS_TL tsk_tl,cs_incidents_all_b INC,
1095: cs_incidents_all_tl INC_TL, HZ_PARTIES hp, fnd_user usr
1096: WHERE au.RESOURCE_ID=b.RESOURCE_ID
1097: AND b.TASK_ASSIGNMENT_ID=b_task_ass_id
1154: CURSOR c_user_task_assigned2(b_task_ass_id NUMBER)
1155: IS
1156: SELECT usr.USER_ID,usr.USER_NAME,usr.email_address, b.TASK_ID,TASK_NAME,TASK_NUMBER,
1157: (select location_id from hz_party_sites where party_site_id =tsk.address_id) location_id
1158: FROM ASG_USER AU, JTF_TASK_ASSIGNMENTS b,CSM_TASK_ASSIGNMENTS_ACC ACC,
1159: JTF_TASKS_B tsk,JTF_TASKS_TL tsk_tl, fnd_user usr
1160: WHERE au.RESOURCE_ID=b.RESOURCE_ID
1161: AND b.TASK_ASSIGNMENT_ID=b_task_ass_id
1162: AND b.TASK_ID=tsk.TASK_ID