DBA Data[Home] [Help]

APPS.CSD_REPAIR_ESTIMATE_PVT dependencies on CSD_PRODUCT_TRANSACTIONS

Line 2474: Csd_Gen_Utility_Pvt.ADD('Call csd_product_transactions_pkg.Delete_Row');

2470: END IF;
2471:
2472: IF (g_debug > 0)
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:

Line 2888: FROM CSD_PRODUCT_TRANSACTIONS cpt,

2884: -- and add to the sales order
2885: BEGIN
2886: SELECT MAX(ced.order_header_id)
2887: INTO l_order_header_id
2888: FROM CSD_PRODUCT_TRANSACTIONS cpt,
2889: cs_estimate_details ced,
2890: oe_order_headers_all ooh,
2891: oe_order_types_v oot
2892: WHERE ooh.order_type_id = oot.order_type_id

Line 2941: FROM CSD_PRODUCT_TRANSACTIONS cpt,

2937: THEN
2938: BEGIN
2939: SELECT ced.purchase_order_num
2940: INTO l_orig_po_num
2941: FROM CSD_PRODUCT_TRANSACTIONS cpt,
2942: cs_estimate_details ced
2943: WHERE cpt.estimate_detail_id =
2944: ced.estimate_detail_id
2945: AND cpt.repair_line_id = p_repair_line_id