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.CSD_REPAIR_ESTIMATE_PVT dependencies on CSD_REPAIR_ESTIMATE_LINES

Line 1231: FROM CSD_REPAIR_ESTIMATE_LINES

1227:
1228: BEGIN
1229: SELECT COUNT(*)
1230: INTO l_est_line_count
1231: FROM CSD_REPAIR_ESTIMATE_LINES
1232: WHERE repair_estimate_id = p_estimate_id;
1233: EXCEPTION
1234: WHEN OTHERS THEN
1235: NULL;

Line 1854: Csd_Gen_Utility_Pvt.ADD('Call csd_repair_estimate_lines_pkg.insert_row to create repair estimate lines ');

1850: END IF;
1851:
1852: IF (g_debug > 0)
1853: THEN
1854: Csd_Gen_Utility_Pvt.ADD('Call csd_repair_estimate_lines_pkg.insert_row to create repair estimate lines ');
1855: END IF;
1856:
1857: -- travi forward port Bug # 2789754 fix added override_charge_flag
1858: Csd_Repair_Estimate_Lines_Pkg.Insert_Row(px_REPAIR_ESTIMATE_LINE_ID => x_estimate_line_rec.repair_estimate_line_id,

Line 1858: Csd_Repair_Estimate_Lines_Pkg.Insert_Row(px_REPAIR_ESTIMATE_LINE_ID => x_estimate_line_rec.repair_estimate_line_id,

1854: Csd_Gen_Utility_Pvt.ADD('Call csd_repair_estimate_lines_pkg.insert_row to create repair estimate lines ');
1855: END IF;
1856:
1857: -- travi forward port Bug # 2789754 fix added override_charge_flag
1858: Csd_Repair_Estimate_Lines_Pkg.Insert_Row(px_REPAIR_ESTIMATE_LINE_ID => x_estimate_line_rec.repair_estimate_line_id,
1859: p_REPAIR_ESTIMATE_ID => x_estimate_line_rec.repair_estimate_id,
1860: p_ESTIMATE_DETAIL_ID => l_Charges_Rec.estimate_detail_id,
1861: p_LAST_UPDATE_DATE => SYSDATE,
1862: p_CREATION_DATE => SYSDATE,

Line 1976: FROM CSD_REPAIR_ESTIMATE_LINES

1972: l_serial_flag BOOLEAN := FALSE;
1973:
1974: CURSOR estimate_line(p_est_line_id IN NUMBER) IS
1975: SELECT estimate_detail_id, object_version_number
1976: FROM CSD_REPAIR_ESTIMATE_LINES
1977: WHERE repair_estimate_line_id = p_est_line_id;
1978:
1979: BEGIN
1980: -- Standard Start of API savepoint

Line 2255: Csd_Repair_Estimate_Lines_Pkg.Update_Row(p_REPAIR_ESTIMATE_LINE_ID => x_estimate_line_rec.repair_estimate_line_id,

2251: x_estimate_line_rec.repair_estimate_line_id);
2252: END IF;
2253:
2254: -- travi forward port Bug # 2789754 fix added override_charge_flag
2255: Csd_Repair_Estimate_Lines_Pkg.Update_Row(p_REPAIR_ESTIMATE_LINE_ID => x_estimate_line_rec.repair_estimate_line_id,
2256: p_REPAIR_ESTIMATE_ID => x_estimate_line_rec.repair_estimate_id,
2257: p_ESTIMATE_DETAIL_ID => x_estimate_line_rec.estimate_detail_id,
2258: p_LAST_UPDATE_DATE => SYSDATE,
2259: p_CREATION_DATE => SYSDATE,

Line 2415: FROM CSD_REPAIR_ESTIMATE_LINES a, cs_estimate_details b

2411: -- only if it is not interfaced
2412: BEGIN
2413: SELECT a.estimate_detail_id
2414: INTO l_est_detail_id
2415: FROM CSD_REPAIR_ESTIMATE_LINES a, cs_estimate_details b
2416: WHERE a.estimate_detail_id = b.estimate_detail_id
2417: AND a.repair_estimate_line_id = p_estimate_line_id
2418: AND b.order_header_id IS NULL;
2419: l_delete_allow := 'Y';

Line 2477: Csd_Repair_Estimate_Lines_Pkg.Delete_Row(p_REPAIR_ESTIMATE_LINE_ID => p_estimate_line_id);

2473: THEN
2474: Csd_Gen_Utility_Pvt.ADD('Call csd_product_transactions_pkg.Delete_Row');
2475: END IF;
2476:
2477: Csd_Repair_Estimate_Lines_Pkg.Delete_Row(p_REPAIR_ESTIMATE_LINE_ID => p_estimate_line_id);
2478:
2479: END IF; --end of delete
2480:
2481: -- Api body ends here

Line 2557: Csd_Repair_Estimate_Lines_Pkg.Lock_Row(p_REPAIR_ESTIMATE_LINE_ID => p_estimate_line_rec.repair_estimate_line_id,

2553:
2554: -- Initialize API return status to success
2555: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
2556:
2557: Csd_Repair_Estimate_Lines_Pkg.Lock_Row(p_REPAIR_ESTIMATE_LINE_ID => p_estimate_line_rec.repair_estimate_line_id,
2558: p_OBJECT_VERSION_NUMBER => p_estimate_line_rec.object_version_number);
2559:
2560: -- Standard check of p_commit.
2561: IF Fnd_Api.To_Boolean(p_commit)

Line 2817: CSD_REPAIR_ESTIMATE_LINES crel,

2813:
2814: CURSOR ESTIMATE(p_rep_line_id IN NUMBER) IS
2815: SELECT ced.estimate_detail_id, ced.purchase_order_num
2816: FROM CSD_REPAIR_ESTIMATE cre,
2817: CSD_REPAIR_ESTIMATE_LINES crel,
2818: cs_estimate_details ced
2819: WHERE cre.repair_line_id = p_rep_line_id
2820: AND cre.repair_estimate_id = crel.repair_estimate_id
2821: AND crel.estimate_detail_id = ced.estimate_detail_id

Line 3112: FROM csd_repair_estimate_lines_v

3108: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
3109:
3110: SELECT SUM(NVL(charge, 0))
3111: INTO x_estimated_charge
3112: FROM csd_repair_estimate_lines_v
3113: WHERE repair_line_id = p_repair_line_id
3114: AND billing_type IN ('M', 'L', 'E');
3115:
3116: IF (Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level)

Line 4266: from csd_repair_estimate_lines_v csd

4262: and KBSets.set_id = SetLinkTG.set_id
4263: and KBSets.status = 'PUB' -- only published solutions
4264: and not exists -- not already brought in
4265: ( select 'x'
4266: from csd_repair_estimate_lines_v csd
4267: where csd.repair_line_id = SetLinkRO.other_id
4268: and csd.est_line_source_type_code = 'SOLUTION'
4269: and csd.est_line_source_id1 = KBSets.set_id);
4270:

Line 4328: from csd_repair_estimate_lines_v csd

4324: and KBSets.set_id = SetLinkTG.set_id
4325: and KBSets.status = 'PUB' -- only published solutions
4326: and not exists -- not already brought in
4327: ( select 'x'
4328: from csd_repair_estimate_lines_v csd
4329: where csd.repair_line_id = SetLinkRO.other_id
4330: and csd.est_line_source_type_code = 'SOLUTION'
4331: and csd.est_line_source_id1 = KBSets.set_id);
4332: */

Line 4505: FROM csd_repair_estimate_lines_v csd

4501: AND KBSets.set_id = SetLinkTG.set_id
4502: AND KBSets.status = 'PUB' -- only published solutions
4503: AND NOT EXISTS -- not already brought in
4504: (SELECT 'x'
4505: FROM csd_repair_estimate_lines_v csd
4506: WHERE csd.repair_line_id = SetLinkRO.other_id
4507: AND csd.est_line_source_type_code = 'SOLUTION'
4508: AND csd.est_line_source_id1 = KBSets.set_id);
4509:

Line 4566: FROM csd_repair_estimate_lines_v csd

4562: AND KBSets.set_id = SetLinkTG.set_id
4563: AND KBSets.status = 'PUB' -- only published solutions
4564: AND NOT EXISTS -- not already brought in
4565: (SELECT 'x'
4566: FROM csd_repair_estimate_lines_v csd
4567: WHERE csd.repair_line_id = SetLinkRO.other_id
4568: AND csd.est_line_source_type_code = 'SOLUTION'
4569: AND csd.est_line_source_id1 = KBSets.set_id);
4570:

Line 4597: FROM csd_repair_estimate_lines_v csd

4593: AND KBSets.status = 'PUB' -- only published solutions
4594: AND repairs.repair_line_id = SetLinkRO.other_id
4595: AND NOT EXISTS -- not already brought in
4596: (SELECT 'x'
4597: FROM csd_repair_estimate_lines_v csd
4598: WHERE csd.repair_line_id = SetLinkRO.other_id
4599: AND csd.est_line_source_type_code = 'SOLUTION'
4600: AND csd.est_line_source_id1 = KBSets.set_id)
4601: AND NOT EXISTS -- no template for this product