APPS.CSF_DEBRIEF_UPDATE_PKG dependencies on CSF_DEBRIEF_HEADERS

Line 206: CSF_DEBRIEF_HEADERS cdh,

202: jtsb.completed_flag,
203: jtsb.closed_flag
204: from
205: JTF_TASK_STATUSES_B jtsb,
206: CSF_DEBRIEF_HEADERS cdh,
207: JTF_TASKS_B jtb,
208: JTF_TASK_ASSIGNMENTS jta,
209: cs_incidents_all_b ciab
210: WHERE cdh.task_assignment_id = jta.task_assignment_id

Line 233: CSF_DEBRIEF_HEADERS cdh,

229: jtsb.completed_flag,
230: jtsb.closed_flag
231: from
232: JTF_TASK_STATUSES_B jtsb,
233: CSF_DEBRIEF_HEADERS cdh,
234: JTF_TASKS_B jtb,
235: JTF_TASK_ASSIGNMENTS jta,
236: csd_repairs cr
237: WHERE cdh.task_assignment_id = jta.task_assignment_id

Line 261: CSF_DEBRIEF_HEADERS cdh,

257: jtsb.completed_flag,
258: jtsb.closed_flag
259: from
260: JTF_TASK_STATUSES_B jtsb,
261: CSF_DEBRIEF_HEADERS cdh,
262: JTF_TASKS_B jtb,
263: JTF_TASK_ASSIGNMENTS jta,
264: cs_incidents_all_b ciab
265: WHERE cdh.task_assignment_id = jta.task_assignment_id

Line 289: CSF_DEBRIEF_HEADERS cdh,

285: jtsb.completed_flag,
286: jtsb.closed_flag
287: from
288: JTF_TASK_STATUSES_B jtsb,
289: CSF_DEBRIEF_HEADERS cdh,
290: JTF_TASKS_B jtb,
291: JTF_TASK_ASSIGNMENTS jta,
292: csd_repairs cr
293: WHERE cdh.task_assignment_id = jta.task_assignment_id

Line 307: From csf_debrief_headers

303: -- changed above cursor for the bug 3264030
304:
305: Cursor c_headers is
306: Select debrief_header_id
307: From csf_debrief_headers
308: Where processed_flag is null or processed_flag <> 'COMPLETED';
309:
310: /* cursor c_header is
311: select cdtv.debrief_header_id,

Line 1173: update csf_debrief_headers

1169:
1170: end loop;
1171: close c_lines;
1172:
1173: update csf_debrief_headers
1174: set processed_flag = nvl(l_processed_flag,'UNPROCESSED')
1175: where debrief_header_id = l_debrief_header_id;
1176: commit;
1177:

Line 1315: from csf_debrief_headers

1311: p_task_assignment_id IN NUMBER
1312: ) is
1313: cursor get_debrief_header is
1314: select debrief_header_id
1315: from csf_debrief_headers
1316: where task_assignment_id = p_task_assignment_id;
1317:
1318: l_debrief_header_id NUMBER;
1319: l_request_id NUMBER;

Line 1325: update csf_debrief_headers

1321: begin
1322: for gdh In get_debrief_header LOOP
1323: l_debrief_header_id := gdh.debrief_header_id;
1324: --
1325: update csf_debrief_headers
1326: set processed_flag = 'PENDING'
1327: where debrief_header_id = l_debrief_header_id;
1328: --
1329: END LOOP;

Line 1351: l_processed_flag csf_debrief_headers.processed_flag%type;

1347: x_return_status out nocopy varchar2,
1348: x_msg_count out nocopy number,
1349: x_msg_data out nocopy varchar2) IS
1350:
1351: l_processed_flag csf_debrief_headers.processed_flag%type;
1352: l_task_number jtf_tasks_b.task_number%type;
1353: l_debrief_status_rec debrief_status_rec_type;
1354: l_debrief_status_tbl debrief_status_tbl_type;
1355:

Line 1362: from csf_debrief_headers cdh,

1358: jtb.task_number,
1359: cdh.debrief_header_id,
1360: cdh.debrief_number,
1361: decode(processed_flag,'PENDING','P','E') debrief_status
1362: from csf_debrief_headers cdh,
1363: jtf_task_assignments jta,
1364: jtf_tasks_b jtb
1365: where processed_flag in ('PENDING','COMPLETED W/ERRORS')
1366: and jta.task_assignment_id = cdh.task_assignment_id

Line 1379: csf_debrief_headers cdh

1375: decode(processed_flag,'PENDING','P','E') debrief_status
1376: from csd_repairs cr,
1377: jtf_tasks_b jtb,
1378: jtf_task_assignments jta,
1379: csf_debrief_headers cdh
1380: where jtb.source_object_id = cr.repair_line_id
1381: and jtb.source_object_type_code = 'DR'
1382: and jta.task_id = jtb.task_id
1383: and cdh.task_assignment_id = jta.task_assignment_id