APPS.CSD_REPAIR_ACTUAL_LINES_PVT dependencies on CS_ESTIMATE_DETAILS

Line 308: -- in CS_ESTIMATE_DETAILS and will send in estimate_detail_id

304: IF (px_CSD_ACTUAL_LINES_REC.actual_source_code = 'ESTIMATE' ) THEN
305:
306: -- Copy from Estimate API will create a Charge line in the table by
307: -- Calling charges API copy actual from estimate to create the record
308: -- in CS_ESTIMATE_DETAILS and will send in estimate_detail_id
309: -- which is the estimate_detail_id of the Actual line
310:
311: -- Raise FND_API.G_EXC_ERROR if the estimate_detail_id is null
312: IF (px_CSD_ACTUAL_LINES_REC.ESTIMATE_DETAIL_ID is null) THEN

Line 425: -- Debrief would have created a Charge line in the cs_estimate_details table

421: -- Check if the Repair_Actual_Lines_Rec.actual_source_code = TASK
422: -- --------------------------------------------------------------------
423: ELSIF (px_CSD_ACTUAL_LINES_REC.actual_source_code = 'TASK' ) THEN
424:
425: -- Debrief would have created a Charge line in the cs_estimate_details table
426: -- which is the estimate_detail_id of the Actual line
427: -- we link the Debrief createsd charge line to our Actual Line
428:
429: -- Raise FND_API.G_EXC_ERROR if the estimate_detail_id is null

Line 746: -- which calls charges API to update the record in CS_ESTIMATE_DETAILS

742: END IF;
743:
744: -- For WIP we will have charge record as input but we create charge record for MANUAL
745: -- Call table handler CSD_REPAIR_ESTIMATE_PVT.Process_Estimate_Lines in create mode
746: -- which calls charges API to update the record in CS_ESTIMATE_DETAILS
747: CSD_REPAIR_ESTIMATE_PVT.PROCESS_ESTIMATE_LINES
748: ( p_api_version => 1.0 ,
749: p_commit => fnd_api.g_false,
750: p_init_msg_list => fnd_api.g_true,

Line 983: FROM cs_estimate_details

979: l_cs_cost_flag VARCHAR2(1) := 'Y';
980:
981: CURSOR charge_lines(p_est_det_id IN NUMBER) IS
982: SELECT object_version_number
983: FROM cs_estimate_details
984: WHERE estimate_detail_id = p_est_det_id;
985:
986: CURSOR repair_actual_lines(p_actual_line_id IN NUMBER) IS
987: SELECT a.object_version_number

Line 1091: -- Validate the estimate detail id against cs_estimate_details

1087: IF repair_actual_lines%ISOPEN THEN
1088: CLOSE repair_actual_lines;
1089: END IF;
1090:
1091: -- Validate the estimate detail id against cs_estimate_details
1092: -- If it is invalid then raise FND_API.G_EXC_ERROR
1093: OPEN charge_lines(px_Charges_Rec.estimate_detail_id);
1094: FETCH charge_lines
1095: INTO l_est_obj_ver_num;

Line 1167: from cs_estimate_details ced,

1163: IF l_line_order_category_code ='ORDER' then
1164: begin
1165: Select max(ced.order_header_id)
1166: into l_add_actual_to_id
1167: from cs_estimate_details ced,
1168: oe_order_headers_all ooh,
1169: oe_order_types_v oot
1170: where
1171: ced.estimate_detail_id in

Line 1197: from cs_estimate_details ced,

1193: ELSIF l_line_order_category_code ='RETURN' then
1194: begin
1195: Select max(ced.order_header_id)
1196: into l_add_actual_to_id
1197: from cs_estimate_details ced,
1198: oe_order_headers_all ooh,
1199: oe_order_types_v oot
1200: where
1201: ced.estimate_detail_id in

Line 1282: -- which calls charges API to update the record in CS_ESTIMATE_DETAILS

1278: -- Api body
1279: --
1280: BEGIN
1281: -- Call table handler CSD_REPAIR_ESTIMATE_PVT.Process_Estimate_Lines in update mode
1282: -- which calls charges API to update the record in CS_ESTIMATE_DETAILS
1283: CSD_REPAIR_ESTIMATE_PVT.PROCESS_ESTIMATE_LINES
1284: ( p_api_version => 1.0 ,
1285: p_commit => fnd_api.g_false,
1286: p_init_msg_list => fnd_api.g_true,

Line 1651: -- delete the record in CS_ESTIMATE_DETAILS

1647: RAISE FND_API.G_EXC_ERROR;
1648: END IF;
1649:
1650: -- Call table handler CSD_REPAIR_ESTIMATE_PVT.Process_Estimate_Lines to
1651: -- delete the record in CS_ESTIMATE_DETAILS
1652: IF ( Fnd_Log.Level_Procedure >= G_debug_level) THEN
1653: FND_LOG.STRING(Fnd_Log.Level_Procedure,l_mod_name,'Call process_estimate_lines to delete charge line');
1654: END IF;
1655: