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 1242: FROM CSD_REPAIR_ESTIMATE_LINES

1238:
1239: BEGIN
1240: SELECT COUNT(*)
1241: INTO l_est_line_count
1242: FROM CSD_REPAIR_ESTIMATE_LINES
1243: WHERE repair_estimate_id = p_estimate_id;
1244: EXCEPTION
1245: WHEN OTHERS THEN
1246: NULL;

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

1861: END IF;
1862:
1863: IF (g_debug > 0)
1864: THEN
1865: Csd_Gen_Utility_Pvt.ADD('Call csd_repair_estimate_lines_pkg.insert_row to create repair estimate lines ');
1866: END IF;
1867:
1868: -- travi forward port Bug # 2789754 fix added override_charge_flag
1869: Csd_Repair_Estimate_Lines_Pkg.Insert_Row(px_REPAIR_ESTIMATE_LINE_ID => x_estimate_line_rec.repair_estimate_line_id,

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

1865: Csd_Gen_Utility_Pvt.ADD('Call csd_repair_estimate_lines_pkg.insert_row to create repair estimate lines ');
1866: END IF;
1867:
1868: -- travi forward port Bug # 2789754 fix added override_charge_flag
1869: Csd_Repair_Estimate_Lines_Pkg.Insert_Row(px_REPAIR_ESTIMATE_LINE_ID => x_estimate_line_rec.repair_estimate_line_id,
1870: p_REPAIR_ESTIMATE_ID => x_estimate_line_rec.repair_estimate_id,
1871: p_ESTIMATE_DETAIL_ID => l_Charges_Rec.estimate_detail_id,
1872: p_LAST_UPDATE_DATE => SYSDATE,
1873: p_CREATION_DATE => SYSDATE,

Line 1987: FROM CSD_REPAIR_ESTIMATE_LINES

1983: l_serial_flag BOOLEAN := FALSE;
1984:
1985: CURSOR estimate_line(p_est_line_id IN NUMBER) IS
1986: SELECT estimate_detail_id, object_version_number
1987: FROM CSD_REPAIR_ESTIMATE_LINES
1988: WHERE repair_estimate_line_id = p_est_line_id;
1989:
1990: BEGIN
1991: -- Standard Start of API savepoint

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

2262: x_estimate_line_rec.repair_estimate_line_id);
2263: END IF;
2264:
2265: -- travi forward port Bug # 2789754 fix added override_charge_flag
2266: Csd_Repair_Estimate_Lines_Pkg.Update_Row(p_REPAIR_ESTIMATE_LINE_ID => x_estimate_line_rec.repair_estimate_line_id,
2267: p_REPAIR_ESTIMATE_ID => x_estimate_line_rec.repair_estimate_id,
2268: p_ESTIMATE_DETAIL_ID => x_estimate_line_rec.estimate_detail_id,
2269: p_LAST_UPDATE_DATE => SYSDATE,
2270: p_CREATION_DATE => SYSDATE,

Line 2426: FROM CSD_REPAIR_ESTIMATE_LINES a, cs_estimate_details b

2422: -- only if it is not interfaced
2423: BEGIN
2424: SELECT a.estimate_detail_id
2425: INTO l_est_detail_id
2426: FROM CSD_REPAIR_ESTIMATE_LINES a, cs_estimate_details b
2427: WHERE a.estimate_detail_id = b.estimate_detail_id
2428: AND a.repair_estimate_line_id = p_estimate_line_id
2429: AND b.order_header_id IS NULL;
2430: l_delete_allow := 'Y';

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

2484: THEN
2485: Csd_Gen_Utility_Pvt.ADD('Call csd_product_transactions_pkg.Delete_Row');
2486: END IF;
2487:
2488: Csd_Repair_Estimate_Lines_Pkg.Delete_Row(p_REPAIR_ESTIMATE_LINE_ID => p_estimate_line_id);
2489:
2490: END IF; --end of delete
2491:
2492: -- Api body ends here

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

2564:
2565: -- Initialize API return status to success
2566: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
2567:
2568: Csd_Repair_Estimate_Lines_Pkg.Lock_Row(p_REPAIR_ESTIMATE_LINE_ID => p_estimate_line_rec.repair_estimate_line_id,
2569: p_OBJECT_VERSION_NUMBER => p_estimate_line_rec.object_version_number);
2570:
2571: -- Standard check of p_commit.
2572: IF Fnd_Api.To_Boolean(p_commit)

Line 2828: CSD_REPAIR_ESTIMATE_LINES crel,

2824:
2825: CURSOR ESTIMATE(p_rep_line_id IN NUMBER) IS
2826: SELECT ced.estimate_detail_id, ced.purchase_order_num
2827: FROM CSD_REPAIR_ESTIMATE cre,
2828: CSD_REPAIR_ESTIMATE_LINES crel,
2829: cs_estimate_details ced
2830: WHERE cre.repair_line_id = p_rep_line_id
2831: AND cre.repair_estimate_id = crel.repair_estimate_id
2832: AND crel.estimate_detail_id = ced.estimate_detail_id

Line 3123: FROM csd_repair_estimate_lines_v

3119: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
3120:
3121: SELECT SUM(NVL(charge, 0))
3122: INTO x_estimated_charge
3123: FROM csd_repair_estimate_lines_v
3124: WHERE repair_line_id = p_repair_line_id
3125: AND billing_type IN ('M', 'L', 'E');
3126:
3127: IF (Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level)

Line 4300: from csd_repair_estimate_lines_v csd

4296: and KBSets.set_id = SetLinkTG.set_id
4297: and KBSets.status = 'PUB' -- only published solutions
4298: and not exists -- not already brought in
4299: ( select 'x'
4300: from csd_repair_estimate_lines_v csd
4301: where csd.repair_line_id = SetLinkRO.other_id
4302: and csd.est_line_source_type_code = 'SOLUTION'
4303: and csd.est_line_source_id1 = KBSets.set_id);
4304:

Line 4362: from csd_repair_estimate_lines_v csd

4358: and KBSets.set_id = SetLinkTG.set_id
4359: and KBSets.status = 'PUB' -- only published solutions
4360: and not exists -- not already brought in
4361: ( select 'x'
4362: from csd_repair_estimate_lines_v csd
4363: where csd.repair_line_id = SetLinkRO.other_id
4364: and csd.est_line_source_type_code = 'SOLUTION'
4365: and csd.est_line_source_id1 = KBSets.set_id);
4366: */

Line 4539: FROM csd_repair_estimate_lines_v csd

4535: AND KBSets.set_id = SetLinkTG.set_id
4536: AND KBSets.status = 'PUB' -- only published solutions
4537: AND NOT EXISTS -- not already brought in
4538: (SELECT 'x'
4539: FROM csd_repair_estimate_lines_v csd
4540: WHERE csd.repair_line_id = SetLinkRO.other_id
4541: AND csd.est_line_source_type_code = 'SOLUTION'
4542: AND csd.est_line_source_id1 = KBSets.set_id);
4543:

Line 4600: FROM csd_repair_estimate_lines_v csd

4596: AND KBSets.set_id = SetLinkTG.set_id
4597: AND KBSets.status = 'PUB' -- only published solutions
4598: AND NOT EXISTS -- not already brought in
4599: (SELECT 'x'
4600: FROM csd_repair_estimate_lines_v csd
4601: WHERE csd.repair_line_id = SetLinkRO.other_id
4602: AND csd.est_line_source_type_code = 'SOLUTION'
4603: AND csd.est_line_source_id1 = KBSets.set_id);
4604:

Line 4631: FROM csd_repair_estimate_lines_v csd

4627: AND KBSets.status = 'PUB' -- only published solutions
4628: AND repairs.repair_line_id = SetLinkRO.other_id
4629: AND NOT EXISTS -- not already brought in
4630: (SELECT 'x'
4631: FROM csd_repair_estimate_lines_v csd
4632: WHERE csd.repair_line_id = SetLinkRO.other_id
4633: AND csd.est_line_source_type_code = 'SOLUTION'
4634: AND csd.est_line_source_id1 = KBSets.set_id)
4635: AND NOT EXISTS -- no template for this product

Line 7578: FROM CSD_REPAIR_ESTIMATE_LINES lin

7574:
7575: -- cursor to get the estimate lines for a given estimate header
7576: CURSOR c_estimate_lines (p_estimate_header_id NUMBER)IS
7577: SELECT lin.repair_estimate_line_id
7578: FROM CSD_REPAIR_ESTIMATE_LINES lin
7579: WHERE lin.repair_estimate_id = p_estimate_header_id;
7580:
7581:
7582: -- It forms the outer most loop for the processing.