APPS.PO_PALT_ASSIGNMENTS dependencies on PO_LINES_DRAFT_ALL

Line 327: l_par_query := 'UPDATE po_lines_draft_all ' ||

323:
324: -- IF assignmnet Type is PAR, the remove corresponding 'ASSIGNED'
325: -- from PAR lINE and set it back to 'COMPLETED'
326:
327: l_par_query := 'UPDATE po_lines_draft_all ' ||
328: ' SET draft_line_status = ''COMPLETED''' ||
329: ' WHERE (po_line_id, draft_id) IN (SELECT par_line_id, par_draft_id' ||
330: ' FROM po_requisition_lines_all ' ||
331: ' WHERE assignment_number = ''' || pAssignmentNums(i) || '''' ||

Line 545: UPDATE po_lines_draft_all

541: last_update_login = fnd_global.login_id
542: WHERE requisition_header_id = p_par_req_header_id;
543:
544: --Set PAR line status to 'ASSIGNED'
545: UPDATE po_lines_draft_all
546: SET draft_line_status = 'ASSIGNED'
547: WHERE draft_id = p_draft_id;
548:
549: COMMIT;