DBA Data[Home] [Help]

APPS.CSM_HA_AUDIT_PKG dependencies on XMLTYPE

Line 105: VALUES(l_audit_id,l_session_id,p_ha_payload_id,p_audit_type,systimestamp,DECODE(p_audit_type,'APPLY',xmltype(l_xml_payload)),sysdate,1,sysdate,1,1);

101: END IF;
102:
103: INSERT INTO CSM_HA_AUDIT(HA_AUDIT_ID,SESSION_ID,HA_PAYLOAD_ID, AUDIT_TYPE, AUDIT_TIMESTAMP,OLD_PAYLOAD,
104: CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN)
105: VALUES(l_audit_id,l_session_id,p_ha_payload_id,p_audit_type,systimestamp,DECODE(p_audit_type,'APPLY',xmltype(l_xml_payload)),sysdate,1,sysdate,1,1);
106:
107: COMMIT;
108: EXCEPTION
109: WHEN OTHERS THEN