[Home] [Help]
1179: mod_draft_id = p_mod_draft_id
1180: WHERE draft_id = p_par_draft_id_tbl(i)
1181: AND po_line_id = p_par_line_tbl(i);
1182:
1183: UPDATE po_headers_draft_all
1184: SET document_creation_method = 'PAR_AUTOCREATE'
1185: WHERE draft_id = p_mod_draft_id;
1186:
1187: --Update po_line_id in po_requisition_lines_all after mod creation
1225:
1226: IF p_is_header_changed = 'Y' THEN
1227: FOR i IN 1..p_par_draft_id_tbl.Count loop
1228: IF p_par_line_tbl(i) IS NULL THEN
1229: UPDATE po_headers_draft_all
1230: SET mod_draft_id = p_mod_draft_id
1231: WHERE draft_id = p_par_draft_id_tbl(i);
1232: END IF;
1233: END LOOP;