eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EGO_GENERIC_TEMP_DML_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 4


 PROCEDURE Insert_Row ( p_api_version       IN  NUMBER
                       --,p_commit            IN  VARCHAR2 default G_FALSE
                       ,p_generic_temp_tbl  IN  EGO_GENERIC_TEMP_TBL_TYPE
                       ,x_return_status     OUT NOCOPY VARCHAR2
                       ,x_msg_data          OUT NOCOPY VARCHAR2
                       ,x_msg_count         OUT NOCOPY NUMBER
                      )
 IS

  l_api_name     varchar2(20) := 'Insert_Row';

Line: 39


     INSERT INTO EGO_GENERIC_TEMP (
                 C_ATTRIBUTE1
                ,C_ATTRIBUTE2
                ,N_ATTRIBUTE1
                ,N_ATTRIBUTE2
                ,D_ATTRIBUTE1
                ,D_ATTRIBUTE2
                ,CREATED_BY
                ,CREATION_DATE
                ,LAST_UPDATED_BY
                ,LAST_UPDATE_DATE
                ,LAST_UPDATE_LOGIN
                ) VALUES
                (
                 l_c_attrib1
                ,l_c_attrib2
                ,l_n_attrib1
                ,l_n_attrib2
                ,l_d_attrib1
                ,l_d_attrib2
                ,G_CURRENT_USER_ID
                ,sysdate
                ,G_CURRENT_USER_ID
                ,sysdate
                ,G_CURRENT_LOGIN_ID
               );

Line: 74


       FND_MESSAGE.Set_Name('EGO', 'EGO_INSERT_ERROR');

Line: 83


 END Insert_Row;