ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 357A614BB651070AE06362FB0905E3B3Y select null action_, null status_, null message_, null modified_columns_, tbut.empno, tbut.name from tnpl_blitz_upload_test tbut where 1=1 U 0EF78F69BCD7104AE0630100007F95B0 A tnpl_upload_api.create_update_record US TNPL Demo: Blitz Upload Example (API) Example upload for TNPL to create new uploads using an API. Upload 1=1 1 ACTION_ Char varchar2 2 STATUS_ Char varchar2 3 MESSAGE_ Char varchar2 4 MODIFIED_COLUMNS_ Char varchar2 Y 5 EMPNO Number number 6 NAME Char varchar2 U 1 p_empno in Number EMPNO U 2 p_name in Char NAME U 3 action_ in Char ACTION_CODE_ U 4 status_ out Char STATUS_CODE_ U 5 message_ out Char MESSAGE_ Error SQL select xu.action_, xu.status_, xu.message_, xu.modified_columns_, xu.empno, xu.name from xxen_tnpl_demo_blitz_up_4510_u xu where xu.status_code_=xxen_upload.status_error Order By empno Success SQL select xu.action_, xu.status_, xu.message_, xu.modified_columns_, tbut.empno, tbut.name from xxen_tnpl_demo_blitz_up_4510_u xu, tnpl_blitz_upload_test tbut where xu.empno=tbut.empno and xu.name=tbut.name and xu.status_code_=xxen_upload.status_success