DBA Data[Home] [Help]

APPS.PO_PAR_REQ_CREATE_UTIL dependencies on PO_REQUISITION_LINES_S

Line 125: SELECT po_requisition_lines_s.NEXTVAL

121: ||l_api_name, l_progress, 'PROCESSING LINE ID: '
122: || L_po_line_id_tbl(i));
123: END IF;
124:
125: SELECT po_requisition_lines_s.NEXTVAL
126: INTO l_req_line_id
127: FROM dual;
128:
129: -- INSERTING A REQ LINE RECORD FOR EACH LINE LEVEL CHANGE

Line 399: SELECT po_requisition_lines_s.NEXTVAL,

395: vendor_id,
396: vendor_site_id,
397: vendor_contact_id)
398:
399: SELECT po_requisition_lines_s.NEXTVAL,
400: l_req_header_id,
401: (SELECT Nvl(Max(line_num), 0) + 1
402: FROM po_requisition_lines_all
403: WHERE requisition_header_id = l_req_header_id) LINE_NUM,