DBA Data[Home] [Help]

APPS.PO_BUYER_WORKLOAD_SV dependencies on PO_REQUISITION_LINES_ALL

Line 352: UPDATE po_requisition_lines_all --

348:
349: x_progress := '010';
350: -- dbms_output.put_line('Before update');
351:
352: UPDATE po_requisition_lines_all --
353: SET suggested_buyer_id = x_new_buyer_id,
354: last_update_date = sysdate,
355: last_updated_by = x_user_id,
356: last_update_login = x_login_id

Line 573: -- po_requisition_lines_all.

569: --Name: req_reassign_action_bulk
570: --Pre-reqs:
571: -- None.
572: --Modifies:
573: -- po_requisition_lines_all.
574: --Locks:
575: -- None.
576: --Function:
577: -- It takes in an array of all the req_line_ids

Line 578: -- and performs a Bulk Update on po_requisition_lines_all

574: --Locks:
575: -- None.
576: --Function:
577: -- It takes in an array of all the req_line_ids
578: -- and performs a Bulk Update on po_requisition_lines_all
579: -- with the new buyer_id. And commits the transaction
580: --Parameters:
581: --IN:
582: -- p_api_version

Line 628: UPDATE po_requisition_lines_all

624: l_progress := '005';
625: x_return_status := FND_API.g_ret_sts_success;
626: -- update all the records with the new buyer_id
627: forall i in p_req_line_id_tbl.FIRST..p_req_line_id_tbl.LAST
628: UPDATE po_requisition_lines_all
629: SET suggested_buyer_id = p_new_buyer_id,
630: last_update_date = sysdate,
631: last_updated_by = fnd_global.user_id, --bug10315814
632: last_update_login = fnd_global.login_id