[Home] [Help]
2663: d_position := 40;
2664:
2665: /* bug 12584165 : During PDOI creation we need to update the
2666: clm_document_number with the value in segment1. */
2667: UPDATE po_headers_draft_all
2668: SET segment1 = l_document_num,
2669: clm_document_number = l_document_num --bug 12584165
2670: WHERE po_header_id = p_doc_rec.po_header_id;
2671:
4172:
4173: BEGIN
4174:
4175: SELECT Nvl(style_id,1),type_lookup_code INTO l_style_id, l_doc_type
4176: FROM po_headers_draft_all
4177: WHERE po_header_id = p_po_header_id
4178: AND Nvl(draft_id,-1) = p_draft_id;
4179:
4180: IF (PO_LOG.d_stmt) THEN
4203: PO_LOG.stmt(d_module, d_position,'l_template_id was null in postproc: ' || l_template_id);
4204: END IF;
4205:
4206: --Update the template_id to po_headers_all
4207: UPDATE po_headers_draft_all SET
4208: uda_template_id = l_template_id
4209: WHERE po_header_id = p_po_header_id
4210: AND Nvl(draft_id,-1) = p_draft_id;
4211: