DBA Data[Home] [Help]

APPS.PO_REQ_LINES_SV1 dependencies on PO_REQUISITION_LINES

Line 418: FROM po_requisition_lines

414: BEGIN
415:
416: SELECT nvl(max(line_num), 0)
417: INTO x_max_line_num
418: FROM po_requisition_lines
419: WHERE requisition_header_id = x_header_id;
420:
421: return(x_max_line_num);
422:

Line 448: UPDATE po_requisition_lines

444: x_progress := '010';
445:
446: -- : added update of reqs_in_pool_flag and of
447: -- WHO columns.
448: UPDATE po_requisition_lines
449: SET modified_by_agent_flag = 'Y',
450: reqs_in_pool_flag = NULL,
451: purchasing_agent_id = x_agent_id,
452: last_update_date = SYSDATE,