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.

[Home] [Help]

APPS.CSF_DEBRIEF_PVT dependencies on CSF_DEBRIEF_HEADERS

Line 42: csf_debrief_headers cdh

38:
39: Cursor get_service_request_date IS
40: select nvl(incident_occurred_date,incident_date)
41: from jtf_task_assignments jta , cs_incidents_all cia, jtf_tasks_b jtb,
42: csf_debrief_headers cdh
43: where jta.task_assignment_id = cdh.task_assignment_id
44: and jtb.task_id = jta.task_id
45: and cia.incident_id = jtb.source_object_id
46: and jtb.source_object_type_code = 'SR'

Line 301: from CSF_DEBRIEF_HEADERS

297:
298: if (l_debrief_header_id<>FND_API.G_MISS_NUM) and (l_debrief_header_id is not NULL) then
299: begin
300: select 1 into x
301: from CSF_DEBRIEF_HEADERS
302: where DEBRIEF_HEADER_ID = l_DEBRIEF_HEADER_ID ;
303:
304: fnd_message.set_name('CSF', 'CSF_DEBRIEF_INVALID_HEADER');
305: fnd_msg_pub.add;

Line 322: SELECT CSF_DEBRIEF_HEADERS_S2.nextval

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

Line 327: SELECT CSF_DEBRIEF_HEADERS_S1.nextval

323: INTO l_debrief_number
324: FROM dual;
325: end if;
326: ELSE
327: SELECT CSF_DEBRIEF_HEADERS_S1.nextval
328: INTO l_debrief_header_id
329: FROM dual;
330: if (l_debrief_number <>FND_API.G_MISS_CHAR) and (l_debrief_number is not null) then
331: null;

Line 333: SELECT CSF_DEBRIEF_HEADERS_S2.nextval

329: FROM dual;
330: if (l_debrief_number <>FND_API.G_MISS_CHAR) and (l_debrief_number is not null) then
331: null;
332: else
333: SELECT CSF_DEBRIEF_HEADERS_S2.nextval
334: INTO l_debrief_number
335: FROM dual;
336: end if;
337: END IF;

Line 382: csf_debrief_headers_pkg.Insert_Row(

378: x_return_status := fnd_api.g_ret_sts_unexp_error;
379: RAISE fnd_api.g_exc_unexpected_error;
380: END IF;
381: END IF;
382: csf_debrief_headers_pkg.Insert_Row(
383: PX_DEBRIEF_HEADER_ID => l_debrief_header_id,
384: P_DEBRIEF_NUMBER => l_debrief_number,
385: P_DEBRIEF_DATE => p_debrief_rec.debrief_date,
386: P_DEBRIEF_STATUS_ID => p_debrief_rec.DEBRIEF_STATUS_ID,

Line 671: CSF_DEBRIEF_HEADERS_PKG.Update_Row(

667: END IF;
668: END IF;
669:
670:
671: CSF_DEBRIEF_HEADERS_PKG.Update_Row(
672: P_DEBRIEF_HEADER_ID => p_debrief_rec.DEBRIEF_HEADER_ID,
673: P_DEBRIEF_NUMBER => p_debrief_rec.DEBRIEF_NUMBER ,
674: P_DEBRIEF_DATE => p_debrief_rec.DEBRIEF_DATE,
675: P_DEBRIEF_STATUS_ID => p_debrief_rec.DEBRIEF_STATUS_ID ,

Line 1005: csf_debrief_headers cdh

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

Line 1575: FROM jtf_task_Assignments jta, csf_Debrief_headers cdh

1571: jta.task_id
1572: INTO l_resource_type,
1573: l_resource_id,
1574: l_task_id
1575: FROM jtf_task_Assignments jta, csf_Debrief_headers cdh
1576: WHERE jta.task_Assignment_id = cdh.task_assignment_id
1577: AND cdh.debrief_header_id = p_debrief_line_rec.DEBRIEF_HEADER_ID;
1578: EXCEPTION
1579: when no_data_found then

Line 1621: csf_debrief_headers csf,

1617: loc.geometry
1618: into z_resource_id,
1619: z_location
1620: from csf_debrief_lines cdl,
1621: csf_debrief_headers csf,
1622: jtf_task_assignments jta,
1623: jtf_tasks_b jtb,
1624: hz_party_sites p,
1625: hz_locations loc

Line 1691: csf_debrief_headers csf

1687: into l_task_assignment_id,
1688: l_object_version_number,
1689: l_task_id
1690: from jtf_task_assignments jta,
1691: csf_debrief_headers csf
1692: where csf.task_assignment_id = jta.task_assignment_id
1693: and csf.debrief_header_id = p_debrief_line_rec.debrief_header_id;
1694:
1695:

Line 1871: csf_debrief_headers cdh

1867: nvl(closed_flag,'N'),
1868: nvl(cancelled_flag,'N'))
1869: from jtf_task_statuses_b jtsb,
1870: jtf_task_assignments jta,
1871: csf_debrief_headers cdh
1872: where cdh.debrief_header_id = p_debrief_header_id
1873: and jta.task_assignment_id = cdh.task_assignment_id
1874: and jtsb.task_status_id = jta.assignment_status_id;
1875:

Line 2286: csf_debrief_headers csf,

2282: loc.geometry
2283: into z_resource_id,
2284: z_location
2285: from csf_debrief_lines cdl,
2286: csf_debrief_headers csf,
2287: jtf_task_assignments jta,
2288: jtf_tasks_b jtb,
2289: hz_party_sites p,
2290: hz_locations loc

Line 2358: csf_debrief_headers csf

2354: into l_task_assignment_id,
2355: l_object_version_number,
2356: l_task_id
2357: from jtf_task_assignments jta,
2358: csf_debrief_headers csf
2359: where csf.task_assignment_id = jta.task_assignment_id
2360: and csf.debrief_header_id = p_debrief_line_rec.debrief_header_id;
2361:
2362:

Line 2641: from csf_debrief_headers

2637: IS
2638: l_dummy number;
2639: cursor validate_header_id is
2640: select 1
2641: from csf_debrief_headers
2642: where debrief_header_id=p_debrief_header_id;
2643: BEGIN
2644:
2645: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 3017: from csf_debrief_headers cdh,

3013: cursor c_actual_times is
3014: select max(cdh.debrief_header_id),
3015: min(cdl.labor_start_date),
3016: max(cdl.labor_end_date)
3017: from csf_debrief_headers cdh,
3018: csf_debrief_lines cdl
3019: where cdh.task_assignment_id = p_task_assignment_id
3020: and cdl.debrief_header_id = cdh.debrief_header_id
3021: and cdl.labor_start_date is not null

Line 3026: from csf_debrief_headers cdh,jtf_task_assignments jta

3022: and cdl.labor_end_date is not null;
3023:
3024: cursor c_Debrief_header_for_cleanup is
3025: select cdh.debrief_header_id
3026: from csf_debrief_headers cdh,jtf_task_assignments jta
3027: where cdh.task_assignment_id = jta.task_assignment_id
3028: and jta.task_assignment_id =p_task_assignment_id
3029: and (jta.actual_start_date is not null
3030: or jta.actual_end_date is not null

Line 3088: csf_debrief_headers cdh

3084: jta.object_version_number,
3085: jta.resource_type_code,
3086: jta.resource_id
3087: from jtf_task_assignments jta,
3088: csf_debrief_headers cdh
3089: where debrief_header_id = p_debrief_header_id
3090: and jta.task_assignment_id = cdh.task_assignment_id
3091: and (nvl(actual_start_date,p_start_date) >=
3092: nvl(p_start_date,actual_start_date)

Line 3231: csf_debrief_headers cdh,

3227: cdl.labor_start_date,
3228: cdl.labor_end_date,
3229: jtb.task_number
3230: from csf_debrief_lines cdl,
3231: csf_debrief_headers cdh,
3232: jtf_task_assignments jta ,
3233: jtf_tasks_b jtb
3234: where cdh.debrief_header_id = cdl.debrief_header_id
3235: and jta.task_assignment_id = cdh.task_assignment_id

Line 3292: from csf_debrief_headers cdh,jtf_task_assignments jta,csf_debrief_lines cdl

3288: JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.resource_type_code;
3289:
3290: select cdh.debrief_header_id,resource_type_code,resource_id
3291: into l_debrief_header_id,l_old_resource_type,l_old_resource_id
3292: from csf_debrief_headers cdh,jtf_task_assignments jta,csf_debrief_lines cdl
3293: where jta.task_assignment_id = l_task_assignment_id
3294: and cdl.debrief_header_id = cdh.debrief_header_id
3295: and cdh.task_assignment_id = jta.task_assignment_id
3296: and rownum = 1;

Line 3320: from csf_debrief_headers

3316: x_return_status := FND_API.G_RET_STS_SUCCESS;
3317: l_task_assignment_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.task_assignment_id;
3318: select debrief_header_id
3319: into l_debrief_header_id
3320: from csf_debrief_headers
3321: where task_assignment_id = l_task_assignment_id;
3322:
3323: if l_debrief_header_id is not null then
3324: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3363: from csf_debrief_headers

3359: l_debrief_line csf_debrief_pub.debrief_line_tbl_type;
3360:
3361: cursor c_header_id(p_task_assignment_id number) is
3362: select debrief_header_id
3363: from csf_debrief_headers
3364: where task_assignment_id = p_task_assignment_id;
3365:
3366: cursor c_travel_exists(p_task_assignment_id number) is
3367: select 'Y'

Line 3368: from csf_debrief_headers cdh,

3364: where task_assignment_id = p_task_assignment_id;
3365:
3366: cursor c_travel_exists(p_task_assignment_id number) is
3367: select 'Y'
3368: from csf_debrief_headers cdh,
3369: csf_debrief_lines cdl,
3370: cs_transaction_types ctt,
3371: cs_txn_billing_types ctbt
3372: where cdh.task_assignment_id = p_task_assignment_id

Line 3381: from csf_debrief_headers cdh,

3377: and ctt.travel_flag = 'Y';
3378:
3379: cursor c_working_exists(p_task_assignment_id number) is
3380: select 'Y'
3381: from csf_debrief_headers cdh,
3382: csf_debrief_lines cdl,
3383: cs_transaction_types ctt,
3384: cs_txn_billing_types ctbt
3385: where cdh.task_assignment_id = p_task_assignment_id

Line 3696: l_processed_flag csf_debrief_headers.processed_flag%type;

3692: x_return_status out nocopy varchar2,
3693: x_msg_count out nocopy number,
3694: x_msg_data out nocopy varchar2) IS
3695:
3696: l_processed_flag csf_debrief_headers.processed_flag%type;
3697:
3698: cursor get_debrief_status is
3699: select nvl(cdh.processed_flag,'PENDING')
3700: from csf_debrief_headers cdh,

Line 3700: from csf_debrief_headers cdh,

3696: l_processed_flag csf_debrief_headers.processed_flag%type;
3697:
3698: cursor get_debrief_status is
3699: select nvl(cdh.processed_flag,'PENDING')
3700: from csf_debrief_headers cdh,
3701: csf_debrief_lines cdl
3702: where cdh.task_assignment_id = p_task_assignment_id
3703: and cdh.debrief_header_id = cdl.debrief_header_id;
3704:

Line 3750: csf_debrief_headers cdh

3746: cursor c_task_assgin_object_version is
3747: select task_id, jta.task_assignment_id, jta.object_version_number,
3748: jta.resource_type_code, jta.resource_id
3749: from jtf_task_assignments jta,
3750: csf_debrief_headers cdh
3751: where jta.task_assignment_id = cdh.task_assignment_id
3752: and cdh.debrief_header_id = p_debrief_header_id;
3753:
3754: cursor c_task_object_version is

Line 3791: csf_debrief_headers cdh,

3787: select min(labor_start_date),
3788: max(labor_end_date),
3789: min(debrief_line_id)
3790: from csf_debrief_lines cdl,
3791: csf_debrief_headers cdh,
3792: jtf_task_assignments jta,
3793: cs_transaction_types ctt
3794: where jta.task_id = l_task_id
3795: and jta.task_assignment_id = cdh.task_assignment_id

Line 3805: csf_debrief_headers cdh,

3801: select min(labor_start_date),
3802: max(labor_end_date),
3803: min(debrief_line_id)
3804: from csf_debrief_lines cdl,
3805: csf_debrief_headers cdh,
3806: jtf_task_assignments jta,
3807: cs_transaction_types ctt
3808: where jta.task_id = l_task_id
3809: and jta.task_assignment_id = cdh.task_assignment_id

Line 3820: csf_debrief_headers cdh,

3816: cursor c_parent_task is
3817: select min(labor_start_date),
3818: max(labor_end_date)
3819: from csf_debrief_lines cdl,
3820: csf_debrief_headers cdh,
3821: jtf_task_assignments jta,
3822: jtf_tasks_b jtb,
3823: cs_transaction_types ctt
3824: where jtb.parent_task_id = l_parent_task_id

Line 3835: csf_debrief_headers cdh,

3831: cursor c_parent_task_return (p_start_date_order IN date, p_end_date_order IN date) is
3832: select min(labor_start_date),
3833: max(labor_end_date)
3834: from csf_debrief_lines cdl,
3835: csf_debrief_headers cdh,
3836: jtf_task_assignments jta,
3837: jtf_tasks_b jtb,
3838: cs_transaction_types ctt
3839: where jtb.parent_task_id = l_parent_task_id

Line 3856: csf_debrief_headers cdh,

3852: -- substract RETURN type line's duration from total
3853: cursor c_task_assignment_dur is
3854: select uom_code, quantity
3855: from jtf_task_assignments jta,
3856: csf_debrief_headers cdh,
3857: csf_debrief_lines cdl,
3858: cs_transaction_types ctt
3859: where cdh.debrief_header_id = cdl.debrief_header_id
3860: and jta.task_assignment_id = cdh.task_assignment_id

Line 3875: csf_debrief_headers cdh,

3871: cdl.inventory_item_id is null)
3872: union all
3873: select uom_code, (quantity * -1)
3874: from jtf_task_assignments jta,
3875: csf_debrief_headers cdh,
3876: csf_debrief_lines cdl,
3877: cs_transaction_types ctt
3878: where cdh.debrief_header_id = cdl.debrief_header_id
3879: and jta.task_assignment_id = cdh.task_assignment_id

Line 3895: csf_debrief_headers cdh,

3891:
3892: cursor c_task_dur is
3893: select uom_code, quantity
3894: from csf_debrief_lines cdl,
3895: csf_debrief_headers cdh,
3896: jtf_task_assignments jta,
3897: jtf_tasks_b jtb,
3898: cs_transaction_types ctt
3899: where cdh.debrief_header_id = cdl.debrief_header_id

Line 3916: csf_debrief_headers cdh,

3912: cdl.inventory_item_id is null)
3913: union all
3914: select uom_code, (quantity * -1)
3915: from csf_debrief_lines cdl,
3916: csf_debrief_headers cdh,
3917: jtf_task_assignments jta,
3918: jtf_tasks_b jtb,
3919: cs_transaction_types ctt
3920: where cdh.debrief_header_id = cdl.debrief_header_id

Line 3938: csf_debrief_headers cdh,

3934:
3935: cursor c_parent_task_dur is
3936: select uom_code, quantity
3937: from csf_debrief_lines cdl,
3938: csf_debrief_headers cdh,
3939: jtf_task_assignments jta,
3940: jtf_tasks_b jtb,
3941: cs_transaction_types ctt
3942: where cdh.debrief_header_id = cdl.debrief_header_id

Line 3959: csf_debrief_headers cdh,

3955: cdl.inventory_item_id is null)
3956: union all
3957: select uom_code, (quantity * -1)
3958: from csf_debrief_lines cdl,
3959: csf_debrief_headers cdh,
3960: jtf_task_assignments jta,
3961: jtf_tasks_b jtb,
3962: cs_transaction_types ctt
3963: where cdh.debrief_header_id = cdl.debrief_header_id