12277: and req_line_id = p_req_line_id;
12278:
12279: l_mtl_quantity := l_mtl_quantity +p_delta_quantity;
12280:
12281: l_bool_ret_sts := po_supply.po_req_supply(
12282: p_docid => NULL
12283: , p_lineid => p_req_line_id
12284: , p_shipid => NULL
12285: , p_action => 'Update_Req_Line_Qty'
12341: SET need_by_date = p_need_by_date
12342: WHERE requisition_line_id = p_req_line_id ;
12343:
12344:
12345: l_bool_ret_sts := po_supply.po_req_supply(
12346: p_docid => NULL
12347: , p_lineid => p_req_line_id
12348: , p_shipid => NULL
12349: , p_action => 'Update_Req_Line_Date'
12414: -- delete the record in mtl_supply
12415:
12416: x_progress := '002';
12417:
12418: l_bool_ret_sts := po_supply.po_req_supply(
12419: p_docid => NULL
12420: , p_lineid => p_req_line_id
12421: , p_shipid => NULL
12422: , p_action => 'Remove_Req_Line_Supply'