DBA Data[Home] [Help]

APPS.DPP_EXECUTIONDETAILS_PVT dependencies on XMLTYPE

Line 102: ,output_xml = DECODE(execution_status,'WARNING',NVL(output_xml, XMLType(l_exe_update_rec.Output_XML)),XMLType(l_exe_update_rec.Output_XML))

98: ,last_update_date = sysdate
99: ,last_updated_by = l_exe_update_rec.Last_Updated_By
100: ,provider_process_id = l_exe_update_rec.Provider_Process_Id
101: ,provider_process_instance_id = l_exe_update_rec.Provider_Process_Instance_id
102: ,output_xml = DECODE(execution_status,'WARNING',NVL(output_xml, XMLType(l_exe_update_rec.Output_XML)),XMLType(l_exe_update_rec.Output_XML))
103: ,object_version_number = object_version_number + 1
104: WHERE transaction_header_id = l_exe_update_rec.transaction_header_id
105: AND execution_detail_id = l_exe_update_rec.Execution_Detail_ID;
106: l_update_count := SQL%ROWCOUNT;