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 1424: from CSF_DEBRIEF_LINES

1420: l_debrief_line_id := p_debrief_line_rec.debrief_line_id;
1421: if (l_debrief_line_id<>FND_API.G_MISS_NUM) and (l_debrief_line_id is not NULL) then
1422: begin
1423: select 1 into x
1424: from CSF_DEBRIEF_LINES
1425: where DEBRIEF_LINE_ID = l_DEBRIEF_LINE_ID ;
1426:
1427: fnd_message.set_name('CSF', 'CSF_DEBRIEF_INVALID_LINE_ID');
1428: fnd_msg_pub.add;

Line 1442: SELECT CSF_DEBRIEF_LINES_S.nextval

1438: RAISE fnd_api.g_exc_unexpected_error;
1439: end ;
1440: ELSE
1441:
1442: SELECT CSF_DEBRIEF_LINES_S.nextval
1443: INTO l_debrief_line_id
1444: FROM dual;
1445: END IF;
1446:

Line 1448: csf_debrief_lines_pkg.INSERT_ROW(

1444: FROM dual;
1445: END IF;
1446:
1447: -- Invoke table handler(debrief_Line_Insert_Row)
1448: csf_debrief_lines_pkg.INSERT_ROW(
1449: px_DEBRIEF_LINE_ID => l_debrief_line_id,
1450: p_DEBRIEF_HEADER_ID => p_DEBRIEF_LINE_rec.DEBRIEF_HEADER_ID,
1451: p_DEBRIEF_LINE_NUMBER => p_DEBRIEF_LINE_rec.DEBRIEF_LINE_NUMBER,
1452: p_SERVICE_DATE => p_DEBRIEF_LINE_rec.SERVICE_DATE ,

Line 1570: from csf_debrief_lines cdl,

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

Line 1830: from CSF_DEBRIEF_LINES

1826: select CHARGE_UPLOAD_STATUS,
1827: IB_UPDATE_STATUS,
1828: SPARE_UPDATE_STATUS,
1829: labor_start_date
1830: from CSF_DEBRIEF_LINES
1831: where DEBRIEF_LINE_ID=P_DEBRIEF_LINE_ID;
1832:
1833:
1834: cursor c_cp_status(p_transaction_type_id number) is

Line 1890: from csf_debrief_lines cdl

1886: where inventory_item_id = p_inventory_item_id;
1887:
1888: cursor c_uom_code is
1889: select uom_code
1890: from csf_debrief_lines cdl
1891: where debrief_line_id = P_DEBRIEF_LINE_Rec.debrief_line_id;
1892:
1893: BEGIN
1894: l_debrief_type := debrief_type(p_debrief_line_rec);

Line 2132: csf_debrief_lines_pkg.update_ROW(

2128: end if;
2129: end if;
2130:
2131: ----
2132: csf_debrief_lines_pkg.update_ROW(
2133: p_DEBRIEF_LINE_ID => p_DEBRIEF_LINE_rec.debrief_line_id,
2134: p_DEBRIEF_HEADER_ID => p_DEBRIEF_LINE_rec.DEBRIEF_HEADER_ID,
2135: p_DEBRIEF_LINE_NUMBER => p_DEBRIEF_LINE_rec.DEBRIEF_LINE_NUMBER,
2136: p_SERVICE_DATE => p_DEBRIEF_LINE_rec.SERVICE_DATE ,

Line 2218: from csf_debrief_lines cdl,

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

Line 2950: csf_debrief_lines cdl

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

Line 3181: from csf_debrief_lines cdl,

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

Line 3257: csf_debrief_lines cdl

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

Line 3375: from csf_debrief_lines cdl,

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

Line 3390: from csf_debrief_lines cdl,

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

Line 3413: csf_debrief_lines cdl,

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

Line 3432: csf_debrief_lines cdl,

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

Line 3450: from csf_debrief_lines cdl,

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

Line 3471: from csf_debrief_lines cdl,

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

Line 3493: from csf_debrief_lines cdl,

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

Line 3514: from csf_debrief_lines cdl,

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