[Home] [Help]
2481: END IF;
2482:
2483: IF (g_debug > 0)
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:
2895: -- and add to the sales order
2896: BEGIN
2897: SELECT MAX(ced.order_header_id)
2898: INTO l_order_header_id
2899: FROM CSD_PRODUCT_TRANSACTIONS cpt,
2900: cs_estimate_details ced,
2901: oe_order_headers_all ooh,
2902: oe_order_types_v oot
2903: WHERE ooh.order_type_id = oot.order_type_id
2948: THEN
2949: BEGIN
2950: SELECT ced.purchase_order_num
2951: INTO l_orig_po_num
2952: FROM CSD_PRODUCT_TRANSACTIONS cpt,
2953: cs_estimate_details ced
2954: WHERE cpt.estimate_detail_id =
2955: ced.estimate_detail_id
2956: AND cpt.repair_line_id = p_repair_line_id