212:
213: BEGIN
214: select validation_tmplt_id
215: into l_vtmplt_id 216: from oe_pc_vtmplts vt 217: where vt.validation_type = 'WF'
218: and vt.activity_name = 'UPG_AN_'||to_char(p_action_id)
219: and nvl(vt.activity_result_code,'NO_RESULT')
220: = decode(p_result_id,NULL,'NO_RESULT',