920: ,SYSDATE
921: ,l_interface_row.CREATED_BY
922: ,SYSDATE);
923:
924: -- Create the interface in the BNE_INTERFACES_TL table
925: INSERT INTO BNE_INTERFACES_TL
926: (APPLICATION_ID
927: ,INTERFACE_CODE
928: ,LANGUAGE
921: ,l_interface_row.CREATED_BY
922: ,SYSDATE);
923:
924: -- Create the interface in the BNE_INTERFACES_TL table
925: INSERT INTO BNE_INTERFACES_TL
926: (APPLICATION_ID
927: ,INTERFACE_CODE
928: ,LANGUAGE
929: ,SOURCE_LANG
1722: WHERE APPLICATION_ID = P_APPLICATION_ID
1723: AND INTERFACE_CODE = p_INTERFACE_CODE;
1724:
1725: DELETE
1726: FROM BNE_INTERFACES_tl
1727: WHERE APPLICATION_ID = P_APPLICATION_ID
1728: AND INTERFACE_CODE = p_INTERFACE_CODE;
1729:
1730: DELETE