APPS.PO_DOCUMENT_ACTION_HOLD dependencies on PO_LINE_LOCATIONS

Line 324: UPDATE po_line_locations poll

320: THEN
321:
322: d_progress := 80;
323:
324: UPDATE po_line_locations poll
325: SET poll.approved_flag = DECODE(p_action_ctl_rec.action,
326: PO_DOCUMENT_ACTION_PVT.g_doc_action_HOLD,
327: DECODE(poll.approved_flag, 'Y', 'R', poll.approved_flag),
328: PO_DOCUMENT_ACTION_PVT.g_doc_action_RELEASE_HOLD, poll.approved_flag)

Line 364: UPDATE po_line_locations poll

360: WHERE por.po_release_id = p_action_ctl_rec.document_id;
361:
362: d_progress := 100;
363:
364: UPDATE po_line_locations poll
365: SET poll.approved_flag = DECODE(p_action_ctl_rec.action,
366: PO_DOCUMENT_ACTION_PVT.g_doc_action_HOLD,
367: DECODE(poll.approved_flag, 'Y', 'R', poll.approved_flag),
368: PO_DOCUMENT_ACTION_PVT.g_doc_action_RELEASE_HOLD, poll.approved_flag)