[Home] [Help]
273: cdh.travel_start_time, --FOR TRAVEL LINES
274: cdh.travel_end_time, ciab.system_id system_id
275: from
276: JTF_TASK_STATUSES_B jtsb,
277: CSF_DEBRIEF_HEADERS cdh,
278: JTF_TASKS_B jtb,
279: JTF_TASK_ASSIGNMENTS jta,
280: cs_incidents_all_b ciab
281: WHERE cdh.task_assignment_id = jta.task_assignment_id
302: cdh.travel_start_time, --FOR TRAVEL LINES
303: cdh.travel_end_time, to_number(null) system_id
304: from
305: JTF_TASK_STATUSES_B jtsb,
306: CSF_DEBRIEF_HEADERS cdh,
307: JTF_TASKS_B jtb,
308: JTF_TASK_ASSIGNMENTS jta,
309: csd_repairs cr
310: WHERE cdh.task_assignment_id = jta.task_assignment_id
332: cdh.travel_start_time, --FOR TRAVEL LINES
333: cdh.travel_end_time, ciab.system_id system_id
334: from
335: JTF_TASK_STATUSES_B jtsb,
336: CSF_DEBRIEF_HEADERS cdh,
337: JTF_TASKS_B jtb,
338: JTF_TASK_ASSIGNMENTS jta,
339: cs_incidents_all_b ciab
340: WHERE cdh.task_assignment_id = jta.task_assignment_id
363: cdh.travel_start_time, --FOR TRAVEL LINES
364: cdh.travel_end_time, to_number(null) system_id
365: from
366: JTF_TASK_STATUSES_B jtsb,
367: CSF_DEBRIEF_HEADERS cdh,
368: JTF_TASKS_B jtb,
369: JTF_TASK_ASSIGNMENTS jta,
370: csd_repairs cr
371: WHERE cdh.task_assignment_id = jta.task_assignment_id
382: -- changed above cursor for the bug 3264030
383:
384: Cursor c_headers is
385: Select debrief_header_id
386: From csf_debrief_headers
387: Where processed_flag is null or processed_flag <> 'COMPLETED';
388:
389: cursor c_cost_charge_flags (p_transaction_type_id number) is
390: select create_cost_flag,
897: l_quantity,
898: l_uom_code,
899: 'KM',
900: NULL, NULL);
901: update csf_debrief_headers
902: set travel_distance_in_km = l_header_distance_in_km,
903: travel_start_time = l_header_start_time,
904: travel_end_time = l_header_end_time
905: where debrief_header_id = l_debrief_header_id;
1708: end if;
1709:
1710: end if;
1711: log('main','l_processed_flag:'||l_processed_flag);
1712: update csf_debrief_headers
1713: set processed_flag = nvl(l_processed_flag,'UNPROCESSED')
1714: where debrief_header_id = l_debrief_header_id;
1715: commit;
1716:
1924: p_task_assignment_id IN NUMBER
1925: ) is
1926: cursor get_debrief_header is
1927: select debrief_header_id
1928: from csf_debrief_headers
1929: where task_assignment_id = p_task_assignment_id;
1930:
1931: l_debrief_header_id NUMBER;
1932: l_request_id NUMBER;
1934: begin
1935: for gdh In get_debrief_header LOOP
1936: l_debrief_header_id := gdh.debrief_header_id;
1937: --
1938: update csf_debrief_headers
1939: set processed_flag = 'PENDING'
1940: where debrief_header_id = l_debrief_header_id;
1941: --
1942: END LOOP;
1960: x_return_status out nocopy varchar2,
1961: x_msg_count out nocopy number,
1962: x_msg_data out nocopy varchar2) IS
1963:
1964: l_processed_flag csf_debrief_headers.processed_flag%type;
1965: l_task_number jtf_tasks_b.task_number%type;
1966: l_debrief_status_rec debrief_status_rec_type;
1967: l_debrief_status_tbl debrief_status_tbl_type;
1968:
1971: jtb.task_number,
1972: cdh.debrief_header_id,
1973: cdh.debrief_number,
1974: decode(processed_flag,'PENDING','P','E') debrief_status
1975: from csf_debrief_headers cdh,
1976: jtf_task_assignments jta,
1977: jtf_tasks_b jtb
1978: where processed_flag in ('PENDING','COMPLETED W/ERRORS')
1979: and jta.task_assignment_id = cdh.task_assignment_id
1988: decode(processed_flag,'PENDING','P','E') debrief_status
1989: from csd_repairs cr,
1990: jtf_tasks_b jtb,
1991: jtf_task_assignments jta,
1992: csf_debrief_headers cdh
1993: where jtb.source_object_id = cr.repair_line_id
1994: and jtb.source_object_type_code = 'DR'
1995: and jta.task_id = jtb.task_id
1996: and cdh.task_assignment_id = jta.task_assignment_id