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_LINES

Line 1457: from CSF_DEBRIEF_LINES

1453: l_debrief_line_id := p_debrief_line_rec.debrief_line_id;
1454: if (l_debrief_line_id<>FND_API.G_MISS_NUM) and (l_debrief_line_id is not NULL) then
1455: begin
1456: select 1 into x
1457: from CSF_DEBRIEF_LINES
1458: where DEBRIEF_LINE_ID = l_DEBRIEF_LINE_ID ;
1459:
1460: fnd_message.set_name('CSF', 'CSF_DEBRIEF_INVALID_LINE_ID');
1461: fnd_msg_pub.add;

Line 1475: SELECT CSF_DEBRIEF_LINES_S.nextval

1471: RAISE fnd_api.g_exc_unexpected_error;
1472: end ;
1473: ELSE
1474:
1475: SELECT CSF_DEBRIEF_LINES_S.nextval
1476: INTO l_debrief_line_id
1477: FROM dual;
1478: END IF;
1479:

Line 1482: csf_debrief_lines_pkg.INSERT_ROW(

1478: END IF;
1479:
1480: --dbms_output.put_line('Calling INSERT_ROW...');
1481: -- Invoke table handler(debrief_Line_Insert_Row)
1482: csf_debrief_lines_pkg.INSERT_ROW(
1483: px_DEBRIEF_LINE_ID => l_debrief_line_id,
1484: p_DEBRIEF_HEADER_ID => p_DEBRIEF_LINE_rec.DEBRIEF_HEADER_ID,
1485: p_DEBRIEF_LINE_NUMBER => p_DEBRIEF_LINE_rec.DEBRIEF_LINE_NUMBER,
1486: p_SERVICE_DATE => p_DEBRIEF_LINE_rec.SERVICE_DATE ,

Line 1620: from csf_debrief_lines cdl,

1616: select jta.resource_id,
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,

Line 1883: from CSF_DEBRIEF_LINES

1879: select CHARGE_UPLOAD_STATUS,
1880: IB_UPDATE_STATUS,
1881: SPARE_UPDATE_STATUS,
1882: labor_start_date
1883: from CSF_DEBRIEF_LINES
1884: where DEBRIEF_LINE_ID=P_DEBRIEF_LINE_ID;
1885:
1886:
1887: cursor c_cp_status(p_transaction_type_id number) is

Line 1943: from csf_debrief_lines cdl

1939: where inventory_item_id = p_inventory_item_id;
1940:
1941: cursor c_uom_code is
1942: select uom_code
1943: from csf_debrief_lines cdl
1944: where debrief_line_id = P_DEBRIEF_LINE_Rec.debrief_line_id;
1945:
1946: BEGIN
1947: l_debrief_type := debrief_type(p_debrief_line_rec);

Line 2187: csf_debrief_lines_pkg.update_ROW(

2183: end if;
2184: end if;
2185:
2186: ----
2187: csf_debrief_lines_pkg.update_ROW(
2188: p_DEBRIEF_LINE_ID => p_DEBRIEF_LINE_rec.debrief_line_id,
2189: p_DEBRIEF_HEADER_ID => p_DEBRIEF_LINE_rec.DEBRIEF_HEADER_ID,
2190: p_DEBRIEF_LINE_NUMBER => p_DEBRIEF_LINE_rec.DEBRIEF_LINE_NUMBER,
2191: p_SERVICE_DATE => p_DEBRIEF_LINE_rec.SERVICE_DATE ,

Line 2285: from csf_debrief_lines cdl,

2281: select jta.resource_id,
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,

Line 3018: csf_debrief_lines cdl

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
3022: and cdl.labor_end_date is not null;

Line 3230: from csf_debrief_lines cdl,

3226: Select cdh.debrief_number,
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

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 3369: csf_debrief_lines cdl,

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
3373: and cdl.debrief_header_id = cdh.debrief_header_id

Line 3382: csf_debrief_lines cdl,

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
3386: and cdl.debrief_header_id = cdh.debrief_header_id

Line 3701: csf_debrief_lines cdl

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:
3705: BEGIN

Line 3768: from csf_debrief_lines cdl,

3764: cursor c_task_assignment is
3765: select min(labor_start_date),
3766: max(labor_end_date),
3767: min(debrief_line_id)
3768: from csf_debrief_lines cdl,
3769: cs_transaction_types ctt
3770: where cdl.debrief_header_id = p_debrief_header_id
3771: and cdl.transaction_type_id = ctt.transaction_type_id
3772: and ctt.line_order_category_code = 'ORDER';

Line 3778: from csf_debrief_lines cdl,

3774: cursor c_task_assignment_return (p_start_date_order IN date, p_end_date_order IN date) is
3775: select min(labor_start_date),
3776: max(labor_end_date),
3777: min(debrief_line_id)
3778: from csf_debrief_lines cdl,
3779: cs_transaction_types ctt
3780: where cdl.debrief_header_id = p_debrief_header_id
3781: and cdl.transaction_type_id = ctt.transaction_type_id
3782: and ctt.line_order_category_code = 'RETURN'

Line 3790: from csf_debrief_lines cdl,

3786: cursor c_task is
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

Line 3804: from csf_debrief_lines cdl,

3800: cursor c_task_return (p_start_date_order IN date, p_end_date_order IN date) is
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

Line 3819: from csf_debrief_lines cdl,

3815:
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

Line 3834: from csf_debrief_lines cdl,

3830:
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

Line 3857: csf_debrief_lines cdl,

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
3861: and cdh.debrief_header_id = p_debrief_header_id

Line 3876: csf_debrief_lines cdl,

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
3880: and cdh.debrief_header_id = p_debrief_header_id

Line 3894: from csf_debrief_lines cdl,

3890: cdl.inventory_item_id is null);
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

Line 3915: from csf_debrief_lines cdl,

3911: or
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

Line 3937: from csf_debrief_lines cdl,

3933: cdl.inventory_item_id is null);
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

Line 3958: from csf_debrief_lines cdl,

3954: or
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