4190:
4191: END;
4192:
4193: --Get the header_template_id
4194: l_template_id := PO_UDA_DATA_UTIL.get_template_id('PURCHASING',
4195: l_doc_type,
4196: l_style_id,
4197: 'HEADER',
4198: SYSDATE,
4209: WHERE po_header_id = p_po_header_id
4210: AND Nvl(draft_id,-1) = p_draft_id;
4211:
4212: --Get the line_template_id
4213: l_line_template_id := PO_UDA_DATA_UTIL.get_template_id('PURCHASING',
4214: l_doc_type,
4215: l_style_id,
4216: 'LINE',
4217: SYSDATE,
4227: WHERE po_header_id = p_po_header_id
4228: AND Nvl(draft_id,-1) = p_draft_id;
4229:
4230: --Get the shipment_template_id
4231: l_shipment_template_id := PO_UDA_DATA_UTIL.get_template_id('PURCHASING',
4232: l_doc_type,
4233: l_style_id,
4234: 'SHIPMENT',
4235: SYSDATE,