[Home] [Help]
471: l_Charges_Rec.estimate_detail_id <> FND_API.G_MISS_NUM) then
472: BEGIN
473: select invoice_to_org_id, ship_to_org_id
474: into l_invoice_to_org_id, l_ship_to_org_id
475: from cs_estimate_details
476: where estimate_detail_id = l_Charges_Rec.estimate_detail_id;
477: EXCEPTION
478: WHEN NO_DATA_FOUND THEN
479: debug('No existing Charges record',l_mod_name,1);
590: THEN
591: BEGIN
592: SELECT business_process_id
593: INTO l_Charges_Rec.business_process_id
594: FROM cs_estimate_details
595: WHERE estimate_detail_id =
596: l_Charges_Rec.estimate_detail_id;
597: EXCEPTION
598: WHEN NO_DATA_FOUND THEN
893: wdd.requested_quantity,
894: mtl.serial_number_control_code
895: FROM csd_repairs cr,
896: mtl_system_items_b mtl,
897: cs_estimate_details ced,
898: wsh_delivery_details wdd,
899: --Changed to view from table, bug: 4341784
900: wsh_delivery_assignments_v wda
901: WHERE cr.repair_line_id = ced.original_source_id
2401: WHERE incident_id = p_incident_id;
2402:
2403: CURSOR estimate(p_rep_line_id IN NUMBER) IS
2404: SELECT estimate_detail_id, object_version_number
2405: FROM cs_estimate_details
2406: WHERE source_id = p_rep_line_id
2407: AND source_code = 'DR'
2408: AND interface_to_oe_flag = 'N'
2409: AND order_header_id IS NULL
2416: WHERE project_id = l_project_id and inventory_organization_id = l_p_ship_from_org_id;
2417:
2418: CURSOR order_line_cu(l_est_detail_id NUMBER) is
2419: SELECT b.order_line_id, a.ship_from_org_id
2420: FROM oe_order_lines_all a, cs_estimate_details b
2421: WHERE a.line_id = b.order_line_id
2422: AND b.estimate_detail_id = l_est_detail_id;
2423:
2424: -- swai: bug 6001057
3345: BEGIN
3346: -- Get the order header id from the charge line
3347: SELECT a.order_header_id, a.order_line_id
3348: INTO l_order_header_id, l_order_line_id
3349: FROM cs_estimate_details a
3350: WHERE a.estimate_detail_id = x_estimate_detail_id
3351: AND a.order_header_id IS NOT NULL
3352: AND a.order_line_id IS NOT NULL;
3353:
4167: WHERE incident_id = p_incident_id;
4168:
4169: CURSOR estimate(p_rep_line_id IN NUMBER) IS
4170: SELECT estimate_detail_id, object_version_number
4171: FROM cs_estimate_details
4172: WHERE source_id = p_rep_line_id
4173: AND source_code = 'DR'
4174: AND interface_to_oe_flag = 'N'
4175: AND order_header_id IS NULL
4685:
4686:
4687: CURSOR estimate(p_rep_line_id IN NUMBER) IS
4688: SELECT estimate_detail_id, object_version_number
4689: FROM cs_estimate_details
4690: WHERE source_id = p_rep_line_id
4691: AND source_code = 'DR'
4692: AND interface_to_oe_flag = 'N'
4693: AND order_header_id IS NULL
4833: Begin
4834: Select ship_from_org_id, header_id
4835: into l_ship_from_org_id, l_order_header_id
4836: from oe_order_lines_all oel,
4837: cs_estimate_details ced
4838: where oel.line_id = ced.order_line_id
4839: and ced.estimate_detail_id = x_product_txn_rec.estimate_detail_id;
4840: Exception
4841: When no_data_found then
5111: -- only if it is not interfaced
5112: BEGIN
5113: SELECT a.estimate_detail_id
5114: INTO l_est_detail_id
5115: FROM csd_product_transactions a, cs_estimate_details b
5116: WHERE a.estimate_detail_id = b.estimate_detail_id
5117: AND a.product_transaction_id = p_product_txn_id
5118: AND b.order_header_id IS NULL;
5119:
8145: x_msg_count OUT NOCOPY NUMBER,
8146: x_msg_data OUT NOCOPY VARCHAR2) IS
8147: BEGIN
8148:
8149: UPDATE CS_ESTIMATE_DETAILS
8150: SET SOURCE_CODE = 'DR', SOURCE_ID = p_repair_line_id
8151: WHERE INCIDENT_ID = p_incident_id
8152: AND ESTIMATE_DETAIL_ID = p_estimate_detail_line_id;
8153:
9158: SELECT cpt.product_Transaction_Id,
9159: ced.Estimate_Detail_Id,
9160: ced.order_header_Id,
9161: ced.order_Line_Id
9162: FROM csd_product_Transactions cpt, cs_estimate_Details ced
9163: WHERE cpt.repair_line_id = p_Repair_Line_Id
9164: AND cpt.estimate_detail_id = ced.estimate_detail_id;
9165: BEGIN
9166: -- Standard call to check for call compatibility.