eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSF_DEBRIEF_PVT dependencies on CSF_DEBRIEF_HEADERS

Line 33: csf_debrief_headers cdh

29:
30: Cursor get_service_request_date IS
31: select nvl(incident_occurred_date,incident_date)
32: from jtf_task_assignments jta , cs_incidents_all cia, jtf_tasks_b jtb,
33: csf_debrief_headers cdh
34: where jta.task_assignment_id = cdh.task_assignment_id
35: and jtb.task_id = jta.task_id
36: and cia.incident_id = jtb.source_object_id
37: and jtb.source_object_type_code = 'SR'

Line 288: from CSF_DEBRIEF_HEADERS

284:
285: if (l_debrief_header_id<>FND_API.G_MISS_NUM) and (l_debrief_header_id is not NULL) then
286: begin
287: select 1 into x
288: from CSF_DEBRIEF_HEADERS
289: where DEBRIEF_HEADER_ID = l_DEBRIEF_HEADER_ID ;
290:
291: fnd_message.set_name('CSF', 'CSF_DEBRIEF_INVALID_HEADER');
292: fnd_msg_pub.add;

Line 309: SELECT CSF_DEBRIEF_HEADERS_S2.nextval

305:
306: if (l_debrief_number <>FND_API.G_MISS_CHAR) and (l_debrief_number is not null) then
307: null;
308: else
309: SELECT CSF_DEBRIEF_HEADERS_S2.nextval
310: INTO l_debrief_number
311: FROM dual;
312: end if;
313: ELSE

Line 314: SELECT CSF_DEBRIEF_HEADERS_S1.nextval

310: INTO l_debrief_number
311: FROM dual;
312: end if;
313: ELSE
314: SELECT CSF_DEBRIEF_HEADERS_S1.nextval
315: INTO l_debrief_header_id
316: FROM dual;
317: if (l_debrief_number <>FND_API.G_MISS_CHAR) and (l_debrief_number is not null) then
318: null;

Line 320: SELECT CSF_DEBRIEF_HEADERS_S2.nextval

316: FROM dual;
317: if (l_debrief_number <>FND_API.G_MISS_CHAR) and (l_debrief_number is not null) then
318: null;
319: else
320: SELECT CSF_DEBRIEF_HEADERS_S2.nextval
321: INTO l_debrief_number
322: FROM dual;
323: end if;
324: END IF;

Line 369: csf_debrief_headers_pkg.Insert_Row(

365: x_return_status := fnd_api.g_ret_sts_unexp_error;
366: RAISE fnd_api.g_exc_unexpected_error;
367: END IF;
368: END IF;
369: csf_debrief_headers_pkg.Insert_Row(
370: PX_DEBRIEF_HEADER_ID => l_debrief_header_id,
371: P_DEBRIEF_NUMBER => l_debrief_number,
372: P_DEBRIEF_DATE => p_debrief_rec.debrief_date,
373: P_DEBRIEF_STATUS_ID => p_debrief_rec.DEBRIEF_STATUS_ID,

Line 658: CSF_DEBRIEF_HEADERS_PKG.Update_Row(

654: END IF;
655: END IF;
656:
657:
658: CSF_DEBRIEF_HEADERS_PKG.Update_Row(
659: P_DEBRIEF_HEADER_ID => p_debrief_rec.DEBRIEF_HEADER_ID,
660: P_DEBRIEF_NUMBER => p_debrief_rec.DEBRIEF_NUMBER ,
661: P_DEBRIEF_DATE => p_debrief_rec.DEBRIEF_DATE,
662: P_DEBRIEF_STATUS_ID => p_debrief_rec.DEBRIEF_STATUS_ID ,

Line 1003: csf_debrief_headers cdh

999: nvl(closed_flag,'N'),
1000: nvl(cancelled_flag,'N'))
1001: from jtf_task_statuses_b jtsb,
1002: jtf_task_assignments jta,
1003: csf_debrief_headers cdh
1004: where cdh.debrief_header_id = p_debrief_header_id
1005: and jta.task_assignment_id = cdh.task_assignment_id
1006: and jtsb.task_status_id = jta.assignment_status_id;
1007:

Line 1527: FROM jtf_task_Assignments jta, csf_Debrief_headers cdh

1523: SELECT jta.resource_type_code,
1524: jta.resource_id
1525: INTO l_resource_type,
1526: l_resource_id
1527: FROM jtf_task_Assignments jta, csf_Debrief_headers cdh
1528: WHERE jta.task_Assignment_id = cdh.task_assignment_id
1529: AND cdh.debrief_header_id = p_debrief_line_rec.DEBRIEF_HEADER_ID;
1530: EXCEPTION
1531: when no_data_found then

Line 1571: csf_debrief_headers csf,

1567: loc.geometry
1568: into z_resource_id,
1569: z_location
1570: from csf_debrief_lines cdl,
1571: csf_debrief_headers csf,
1572: jtf_task_assignments jta,
1573: jtf_tasks_b jtb,
1574: hz_party_sites p,
1575: hz_locations loc

Line 1641: csf_debrief_headers csf

1637: into l_task_assignment_id,
1638: l_object_version_number,
1639: l_task_id
1640: from jtf_task_assignments jta,
1641: csf_debrief_headers csf
1642: where csf.task_assignment_id = jta.task_assignment_id
1643: and csf.debrief_header_id = p_debrief_line_rec.debrief_header_id;
1644:
1645:

Line 1818: csf_debrief_headers cdh

1814: nvl(closed_flag,'N'),
1815: nvl(cancelled_flag,'N'))
1816: from jtf_task_statuses_b jtsb,
1817: jtf_task_assignments jta,
1818: csf_debrief_headers cdh
1819: where cdh.debrief_header_id = p_debrief_header_id
1820: and jta.task_assignment_id = cdh.task_assignment_id
1821: and jtsb.task_status_id = jta.assignment_status_id;
1822:

Line 2219: csf_debrief_headers csf,

2215: loc.geometry
2216: into z_resource_id,
2217: z_location
2218: from csf_debrief_lines cdl,
2219: csf_debrief_headers csf,
2220: jtf_task_assignments jta,
2221: jtf_tasks_b jtb,
2222: hz_party_sites p,
2223: hz_locations loc

Line 2291: csf_debrief_headers csf

2287: into l_task_assignment_id,
2288: l_object_version_number,
2289: l_task_id
2290: from jtf_task_assignments jta,
2291: csf_debrief_headers csf
2292: where csf.task_assignment_id = jta.task_assignment_id
2293: and csf.debrief_header_id = p_debrief_line_rec.debrief_header_id;
2294:
2295:

Line 2573: from csf_debrief_headers

2569: IS
2570: l_dummy number;
2571: cursor validate_header_id is
2572: select 1
2573: from csf_debrief_headers
2574: where debrief_header_id=p_debrief_header_id;
2575: BEGIN
2576:
2577: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 2949: from csf_debrief_headers cdh,

2945: cursor c_actual_times is
2946: select max(cdh.debrief_header_id),
2947: min(cdl.labor_start_date),
2948: max(cdl.labor_end_date)
2949: from csf_debrief_headers cdh,
2950: csf_debrief_lines cdl
2951: where cdh.task_assignment_id = p_task_assignment_id
2952: and cdl.debrief_header_id = cdh.debrief_header_id
2953: and cdl.labor_start_date is not null

Line 2958: from csf_debrief_headers cdh,jtf_task_assignments jta

2954: and cdl.labor_end_date is not null;
2955:
2956: cursor c_Debrief_header_for_cleanup is
2957: select cdh.debrief_header_id
2958: from csf_debrief_headers cdh,jtf_task_assignments jta
2959: where cdh.task_assignment_id = jta.task_assignment_id
2960: and jta.task_assignment_id =p_task_assignment_id
2961: and (jta.actual_start_date is not null
2962: or jta.actual_end_date is not null

Line 3020: csf_debrief_headers cdh

3016: jta.object_version_number,
3017: jta.resource_type_code,
3018: jta.resource_id
3019: from jtf_task_assignments jta,
3020: csf_debrief_headers cdh
3021: where debrief_header_id = p_debrief_header_id
3022: and jta.task_assignment_id = cdh.task_assignment_id
3023: and (nvl(actual_start_date,p_start_date) >=
3024: nvl(p_start_date,actual_start_date)

Line 3182: csf_debrief_headers cdh,

3178: cdl.labor_start_date,
3179: cdl.labor_end_date,
3180: jtb.task_number
3181: from csf_debrief_lines cdl,
3182: csf_debrief_headers cdh,
3183: jtf_task_assignments jta ,
3184: jtf_tasks_b jtb
3185: where cdh.debrief_header_id = cdl.debrief_header_id
3186: and jta.task_assignment_id = cdh.task_assignment_id

Line 3232: from csf_debrief_headers

3228: x_return_status := FND_API.G_RET_STS_SUCCESS;
3229: l_task_assignment_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.task_assignment_id;
3230: select debrief_header_id
3231: into l_debrief_header_id
3232: from csf_debrief_headers
3233: where task_assignment_id = l_task_assignment_id;
3234:
3235: if l_debrief_header_id is not null then
3236: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3252: l_processed_flag csf_debrief_headers.processed_flag%type;

3248: x_return_status out nocopy varchar2,
3249: x_msg_count out nocopy number,
3250: x_msg_data out nocopy varchar2) IS
3251:
3252: l_processed_flag csf_debrief_headers.processed_flag%type;
3253:
3254: cursor get_debrief_status is
3255: select nvl(cdh.processed_flag,'PENDING')
3256: from csf_debrief_headers cdh,

Line 3256: from csf_debrief_headers cdh,

3252: l_processed_flag csf_debrief_headers.processed_flag%type;
3253:
3254: cursor get_debrief_status is
3255: select nvl(cdh.processed_flag,'PENDING')
3256: from csf_debrief_headers cdh,
3257: csf_debrief_lines cdl
3258: where cdh.task_assignment_id = p_task_assignment_id
3259: and cdh.debrief_header_id = cdl.debrief_header_id;
3260:

Line 3306: csf_debrief_headers cdh

3302: cursor c_task_assgin_object_version is
3303: select task_id, jta.task_assignment_id, jta.object_version_number,
3304: jta.resource_type_code, jta.resource_id
3305: from jtf_task_assignments jta,
3306: csf_debrief_headers cdh
3307: where jta.task_assignment_id = cdh.task_assignment_id
3308: and cdh.debrief_header_id = p_debrief_header_id;
3309:
3310: cursor c_task_object_version is

Line 3347: csf_debrief_headers cdh,

3343: select min(labor_start_date),
3344: max(labor_end_date),
3345: min(debrief_line_id)
3346: from csf_debrief_lab_lines_v cdl,
3347: csf_debrief_headers cdh,
3348: jtf_task_assignments jta,
3349: cs_transaction_types ctt
3350: where jta.task_id = l_task_id
3351: and jta.task_assignment_id = cdh.task_assignment_id

Line 3361: csf_debrief_headers cdh,

3357: select min(labor_start_date),
3358: max(labor_end_date),
3359: min(debrief_line_id)
3360: from csf_debrief_lab_lines_v cdl,
3361: csf_debrief_headers cdh,
3362: jtf_task_assignments jta,
3363: cs_transaction_types ctt
3364: where jta.task_id = l_task_id
3365: and jta.task_assignment_id = cdh.task_assignment_id

Line 3376: csf_debrief_headers cdh,

3372: cursor c_parent_task is
3373: select min(labor_start_date),
3374: max(labor_end_date)
3375: from csf_debrief_lines cdl,
3376: csf_debrief_headers cdh,
3377: jtf_task_assignments jta,
3378: jtf_tasks_b jtb,
3379: cs_transaction_types ctt
3380: where jtb.parent_task_id = l_parent_task_id

Line 3391: csf_debrief_headers cdh,

3387: cursor c_parent_task_return (p_start_date_order IN date, p_end_date_order IN date) is
3388: select min(labor_start_date),
3389: max(labor_end_date)
3390: from csf_debrief_lines cdl,
3391: csf_debrief_headers cdh,
3392: jtf_task_assignments jta,
3393: jtf_tasks_b jtb,
3394: cs_transaction_types ctt
3395: where jtb.parent_task_id = l_parent_task_id

Line 3412: csf_debrief_headers cdh,

3408: -- substract RETURN type line's duration from total
3409: cursor c_task_assignment_dur is
3410: select uom_code, quantity
3411: from jtf_task_assignments jta,
3412: csf_debrief_headers cdh,
3413: csf_debrief_lines cdl,
3414: cs_transaction_types ctt
3415: where cdh.debrief_header_id = cdl.debrief_header_id
3416: and jta.task_assignment_id = cdh.task_assignment_id

Line 3431: csf_debrief_headers cdh,

3427: cdl.inventory_item_id is null)
3428: union all
3429: select uom_code, (quantity * -1)
3430: from jtf_task_assignments jta,
3431: csf_debrief_headers cdh,
3432: csf_debrief_lines cdl,
3433: cs_transaction_types ctt
3434: where cdh.debrief_header_id = cdl.debrief_header_id
3435: and jta.task_assignment_id = cdh.task_assignment_id

Line 3451: csf_debrief_headers cdh,

3447:
3448: cursor c_task_dur is
3449: select uom_code, quantity
3450: from csf_debrief_lines cdl,
3451: csf_debrief_headers cdh,
3452: jtf_task_assignments jta,
3453: jtf_tasks_b jtb,
3454: cs_transaction_types ctt
3455: where cdh.debrief_header_id = cdl.debrief_header_id

Line 3472: csf_debrief_headers cdh,

3468: cdl.inventory_item_id is null)
3469: union all
3470: select uom_code, (quantity * -1)
3471: from csf_debrief_lines cdl,
3472: csf_debrief_headers cdh,
3473: jtf_task_assignments jta,
3474: jtf_tasks_b jtb,
3475: cs_transaction_types ctt
3476: where cdh.debrief_header_id = cdl.debrief_header_id

Line 3494: csf_debrief_headers cdh,

3490:
3491: cursor c_parent_task_dur is
3492: select uom_code, quantity
3493: from csf_debrief_lines cdl,
3494: csf_debrief_headers cdh,
3495: jtf_task_assignments jta,
3496: jtf_tasks_b jtb,
3497: cs_transaction_types ctt
3498: where cdh.debrief_header_id = cdl.debrief_header_id

Line 3515: csf_debrief_headers cdh,

3511: cdl.inventory_item_id is null)
3512: union all
3513: select uom_code, (quantity * -1)
3514: from csf_debrief_lines cdl,
3515: csf_debrief_headers cdh,
3516: jtf_task_assignments jta,
3517: jtf_tasks_b jtb,
3518: cs_transaction_types ctt
3519: where cdh.debrief_header_id = cdl.debrief_header_id