APPS.PO_BUYER_WORKLOAD_SV dependencies on PO_REQUISITION_LINES

Line 83: FROM po_requisition_lines_v PORL,

79: INTO x_unassigned_reqs,
80: x_unassigned_urgent,
81: x_unassigned_late,
82: x_unassigned_needed
83: FROM po_requisition_lines_v PORL,
84: mtl_system_items MSI,
85: financials_system_parameters FSP,
86: gl_sets_of_books GSB
87: WHERE PORL.suggested_buyer_id is NULL

Line 249: FROM po_requisition_lines_v PORL,

245: INTO x_num_reqs,
246: x_num_urgent,
247: x_num_late,
248: x_num_needed
249: FROM po_requisition_lines_v PORL,
250: mtl_system_items MSI,
251: financials_system_parameters FSP,
252: gl_sets_of_books GSB
253: WHERE PORL.suggested_buyer_id = x_buyer_id

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 418: FROM po_requisition_lines PORL,

414: * sql query and use it in the cursor.
415: */
416: CURSOR C(x_inventory_organization_id number,x_sob_currency_code number) is
417: SELECT PORL.rowid
418: FROM po_requisition_lines PORL,
419: mtl_system_items MSI
420: WHERE
421: NVL(PORL.LINE_LOCATION_ID, -999) = -999
422: -- PORL.line_location_id IS NULL

Line 508: UPDATE po_requisition_lines PRL

504: x_progress := '020';
505: FETCH C into x_rowid;
506: EXIT WHEN C%NOTFOUND;
507:
508: UPDATE po_requisition_lines PRL
509: SET PRL.suggested_buyer_id = x_new_buyer_id,
510: PRL.last_update_date = sysdate,
511: PRL.last_updated_by = x_user_id,
512: PRL.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