[Home] [Help]
53: jta.resource_id,
54: jta.resource_type_code,
55: jta.assignment_status_id
56: FROM jtf_tasks_b jtb,
57: jtf_task_assignments jta,
58: jtf_task_priorities_vl jp_vl,
59: jtf_task_types_vl jtt_vl
60: WHERE jta.task_assignment_id = v_task_assgn_id
61: and jta.task_id = jtb.task_id
102: jtb.scheduled_end_date,
103: jta.resource_id,
104: jta.resource_type_code
105: FROM jtf_tasks_b jtb,
106: jtf_task_assignments jta,
107: jtf_task_priorities_vl jp_vl,
108: jtf_task_types_vl jtt_vl
109: WHERE jta.task_assignment_id = v_task_assgn_id
110: and jta.task_id = jtb.task_id
217: cursor c_get_all_assignments (v_task_id number) is
218: select
219: task_assignment_Id
220: from
221: jtf_task_assignments
222: where task_id = v_task_id;
223:
224: cursor c_priority_test (v_task_id number,
225: v_task_audit_id number,
662: jt.resource_id,
663: jt.resource_type_code,
664: jt.assignment_status_id
665: from
666: jtf_task_assignments jt,
667: jtf_rs_resource_extns jr
668: where
669: jt.task_assignment_id = v_task_asgn_id
670: and jt.resource_id = jr.resource_id
911: jta.resource_id,
912: jta.resource_type_code,
913: jta.assignment_status_id
914: FROM jtf_tasks_b jtb,
915: jtf_task_assignments jta,
916: jtf_task_priorities_vl jp_vl,
917: jtf_task_types_vl jtt_vl
918: WHERE jta.task_assignment_id = v_task_assgn_id
919: and jta.task_id = jtb.task_id
1045:
1046: cursor c_task_assgn_detail (v_task_assgn_id number) is
1047: SELECT jta.object_version_number, jta.assignment_status_id
1048: FROM
1049: jtf_task_assignments jta
1050: WHERE jta.task_assignment_id = v_task_assgn_id;
1051: begin
1052: l_task_assgn_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
1053: itemkey => itemkey,
1148:
1149: cursor c_task_assgn_detail (v_task_assgn_id number) is
1150: SELECT jta.object_version_number, jta.assignment_status_id
1151: FROM
1152: jtf_task_assignments jta
1153: WHERE jta.task_assignment_id = v_task_assgn_id;
1154:
1155: -- bug # 5220702
1156: l_auto_reject varchar2(1);
1162: l_document_id varchar2(250);
1163:
1164: cursor c_get_task_id (v_task_asgn_id number) is
1165: select task_id
1166: from jtf_task_assignments
1167: where task_assignment_id = v_task_asgn_id;
1168: begin
1169: l_task_assgn_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
1170: itemkey => itemkey,
1492: select
1493: n.notes
1494: from
1495: jtf_notes_vl n,
1496: jtf_task_assignments a
1497: where
1498: n.source_object_code = 'TASK'
1499: and n.source_object_id = a.task_id
1500: and a.task_assignment_id = v_task_asgn_id
1501: union select
1502: n.notes
1503: from
1504: jtf_notes_vl n,
1505: jtf_task_assignments a,
1506: jtf_tasks_b t
1507: where
1508: n.source_object_code = 'SR'
1509: and n.source_object_id = t.source_object_id
1731: select
1732: n.notes
1733: from
1734: jtf_notes_vl n,
1735: jtf_task_assignments a
1736: where
1737: n.source_object_code = 'TASK'
1738: and n.source_object_id = a.task_id
1739: and a.task_assignment_id = v_task_asgn_id
1740: union select
1741: n.notes
1742: from
1743: jtf_notes_vl n,
1744: jtf_task_assignments a,
1745: jtf_tasks_b t
1746: where
1747: n.source_object_code = 'SR'
1748: and n.source_object_id = t.source_object_id
2568: chscp.contact_type contact_type,
2569: chscp.party_id contact_party_id
2570: FROM
2571: jtf_tasks_b jtb,
2572: jtf_task_assignments jta,
2573: jtf_tasks_vl j_vl,
2574: jtf_task_priorities_vl jp_vl,
2575: jtf_task_statuses_vl js_vl,
2576: cs_incidents_all c_b,