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.WSH_FOLDER_EXTENSIONS_PVT SQL Statements

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

Line: 6


Procedure Insert_Update_Folder_Ext(
          p_folder_ext_rec IN folder_ext_rec_type,
          x_return_status  OUT NOCOPY VARCHAR2)
IS PRAGMA AUTONOMOUS_TRANSACTION;

Line: 12


 SELECT folder_extension_id
 FROM wsh_folder_extensions
 WHERE folder_id = p_folder_id
 FOR UPDATE NOWAIT;

Line: 21


  l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'INSERT_UPDATE_FOLDER_EXT';

Line: 55


    UPDATE WSH_FOLDER_EXTENSIONS
    SET
        user_id = nvl(p_folder_ext_rec.user_id, FND_GLOBAL.USER_ID),
        application_id = nvl(p_folder_ext_rec.application_id, 665),
        display_dlvy_main = nvl(p_folder_ext_rec.display_dlvy_main,'Y'), -- always display
        display_dlvy_others = nvl(p_folder_ext_rec.display_dlvy_others,'N'),
        display_line_main = nvl(p_folder_ext_rec.display_line_main,'Y'), -- always display
        display_line_others = nvl(p_folder_ext_rec.display_line_others,'N'), -- By default is not visible
        display_trip_main = nvl(p_folder_ext_rec.display_trip_main,'Y'), -- always display
        display_trip_others = nvl(p_folder_ext_rec.display_trip_others,'N'),
        display_stop_main = nvl(p_folder_ext_rec.display_stop_main,'Y'), -- always display
        display_stop_others = nvl(p_folder_ext_rec.display_stop_others,'N'),
        display_qm_line_main = nvl(p_folder_ext_rec.display_qm_line_main,'Y'), -- always display
        display_qm_line_others = nvl(p_folder_ext_rec.display_qm_line_others,'N'), -- By default is not visible
        display_ship_conf_dialogue = nvl(p_folder_ext_rec.display_ship_conf_dialogue,'Y'), -- By default is visible
        display_trip_conf_dialogue = nvl(p_folder_ext_rec.display_trip_conf_dialogue,'Y'), -- By default is visible
        display_trip_info = nvl(p_folder_ext_rec.display_trip_info,'Y'), -- By default is visible
        last_update_date = nvl(p_folder_ext_rec.last_update_date, SYSDATE),
        last_updated_by = nvl(p_folder_ext_rec.last_updated_by, FND_GLOBAL.USER_ID),
        last_update_login = nvl(p_folder_ext_rec.last_update_login, FND_GLOBAL.LOGIN_ID)
   WHERE
          folder_id = p_folder_ext_rec.folder_id;

Line: 79


     INSERT INTO WSH_FOLDER_EXTENSIONS
           (FOLDER_EXTENSION_ID,
        OBJECT,
        USER_ID,
        FOLDER_ID,
        APPLICATION_ID,
        DISPLAY_DLVY_MAIN,
        DISPLAY_DLVY_OTHERS,
        DISPLAY_LINE_MAIN,
        DISPLAY_LINE_OTHERS,
        DISPLAY_TRIP_MAIN,
        DISPLAY_TRIP_OTHERS,
        DISPLAY_STOP_MAIN,
        DISPLAY_STOP_OTHERS,
        DISPLAY_QM_LINE_MAIN,
        DISPLAY_QM_LINE_OTHERS,
        DISPLAY_SHIP_CONF_DIALOGUE,
        DISPLAY_TRIP_CONF_DIALOGUE,
        DISPLAY_TRIP_INFO,
        CREATION_DATE,
        CREATED_BY,
        LAST_UPDATE_DATE,
        LAST_UPDATED_BY,
        LAST_UPDATE_LOGIN
        )
    VALUES
       (
        wsh_folder_extension_s.nextval,
        p_folder_ext_rec.object,
        nvl(p_folder_ext_rec.user_id,FND_GLOBAL.USER_ID),
        p_folder_ext_rec.folder_id,
        nvl(p_folder_ext_rec.application_id,665),
        nvl(p_folder_ext_rec.display_dlvy_main,'Y'), -- always display
        nvl(p_folder_ext_rec.display_dlvy_others,'N'),
        nvl(p_folder_ext_rec.display_line_main,'Y'), -- always display
        nvl(p_folder_ext_rec.display_line_others,'N'), -- By default is not visible
        nvl(p_folder_ext_rec.display_trip_main,'Y'), -- always display
        nvl(p_folder_ext_rec.display_trip_others,'N'),
        nvl(p_folder_ext_rec.display_stop_main,'Y'), -- always display
        nvl(p_folder_ext_rec.display_stop_others,'N'),
        nvl(p_folder_ext_rec.display_qm_line_main,'Y'), -- always display
        nvl(p_folder_ext_rec.display_qm_line_others,'N'), -- By default is not visible
        nvl(p_folder_ext_rec.display_ship_conf_dialogue,'Y'), -- By default is visible
        nvl(p_folder_ext_rec.display_trip_conf_dialogue,'Y'), -- By default is visible
        nvl(p_folder_ext_rec.display_trip_info,'Y'), -- By default is visible
        nvl(p_folder_ext_rec.creation_date,SYSDATE),
        nvl(p_folder_ext_rec.created_by, FND_GLOBAL.USER_ID),
        nvl(p_folder_ext_rec.last_update_date, SYSDATE),
        nvl(p_folder_ext_rec.last_updated_by, FND_GLOBAL.USER_ID),
        nvl(p_folder_ext_rec.last_update_login, FND_GLOBAL.LOGIN_ID)
        );

Line: 142


	   wsh_util_core.default_handler('WSH_FOLDER_EXTENSIONS_PVT.INSERT_UPDATE_FOLDER_EXT',l_module_name);

Line: 151


END Insert_Update_Folder_Ext;

Line: 154


Procedure Delete_Folder_Ext(
          p_folder_id           IN NUMBER,
          x_return_status       OUT NOCOPY VARCHAR2)
IS PRAGMA AUTONOMOUS_TRANSACTION;

Line: 163


  l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'DELETE_FOLDER_EXT';

Line: 185


     SELECT count(*)
       INTO l_count
       FROM fnd_folders
      WHERE folder_id = p_folder_id;

Line: 201


       DELETE FROM wsh_folder_extensions
        WHERE folder_id = p_folder_id;

Line: 205


         WSH_DEBUG_SV.log(l_module_name,'Folders Deleted-',sql%rowcount);

Line: 211


         WSH_DEBUG_SV.logmsg(l_module_name,'No Folders Deleted');

Line: 224


	   wsh_util_core.default_handler('WSH_FOLDER_EXTENSIONS_PVT.DELETE_FOLDER_EXT',l_module_name);

Line: 233


END Delete_Folder_Ext;

Line: 242


Procedure Insert_Update_Folder_Custom(
          p_folder_cust_tab IN folder_cust_tab_type,
          x_return_status  OUT NOCOPY VARCHAR2)
IS PRAGMA AUTONOMOUS_TRANSACTION;

Line: 248


 SELECT folder_id
 FROM wsh_folder_custom_actions
 WHERE folder_id = v_folder_id
   AND rownum = 1;

Line: 259


  l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'INSERT_UPDATE_FOLDER_CUSTOM';

Line: 303


      DELETE FROM wsh_folder_custom_actions
       WHERE folder_id = l_folder_id;

Line: 310


        INSERT INTO wsh_folder_custom_actions
          (ACTION_ID,
           ACTION_NAME,
           OBJECT,
           USER_ENTERED_PROMPT,
           USER_ID,
           FOLDER_ID,
           WIDTH,
           ACCESS_KEY,
           DISPLAY_AS_BUTTON_FLAG,
           DEFAULT_PROMPT,
           CREATION_DATE,
           CREATED_BY,
           LAST_UPDATE_DATE,
           LAST_UPDATED_BY,
           LAST_UPDATE_LOGIN
          )
         VALUES
          (p_folder_cust_tab(i).action_id,
           p_folder_cust_tab(i).action_name,
           p_folder_cust_tab(i).object,
           p_folder_cust_tab(i).user_entered_prompt,
           nvl(p_folder_cust_tab(i).user_id,FND_GLOBAL.USER_ID),
           p_folder_cust_tab(i).folder_id,
           p_folder_cust_tab(i).width,
           p_folder_cust_tab(i).access_key,
           p_folder_cust_tab(i).display_as_button_flag,
           p_folder_cust_tab(i).default_prompt,
           nvl(p_folder_cust_tab(i).creation_date,SYSDATE),
           nvl(p_folder_cust_tab(i).created_by, FND_GLOBAL.USER_ID),
           nvl(p_folder_cust_tab(i).last_update_date, SYSDATE),
           nvl(p_folder_cust_tab(i).last_updated_by, FND_GLOBAL.USER_ID),
           nvl(p_folder_cust_tab(i).last_update_login, FND_GLOBAL.LOGIN_ID)
          );

Line: 360


	   wsh_util_core.default_handler('WSH_FOLDER_EXTENSIONS_PVT.INSERT_UPDATE_FOLDER_CUSTOM',l_module_name);

Line: 369


END Insert_Update_Folder_Custom;

Line: 374


Procedure Delete_Folder_Custom(
          p_folder_id           IN NUMBER,
          x_return_status       OUT NOCOPY VARCHAR2)
IS PRAGMA AUTONOMOUS_TRANSACTION;

Line: 383


  l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'DELETE_FOLDER_CUSTOM';

Line: 402


       DELETE FROM wsh_folder_custom_actions
       WHERE folder_id = p_folder_id;

Line: 407


            WSH_DEBUG_SV.logmsg(l_module_name,'No custom action for Folder Deleted');

Line: 412


         WSH_DEBUG_SV.log(l_module_name,'Folders Deleted-',sql%rowcount);

Line: 425


	   wsh_util_core.default_handler('WSH_FOLDER_EXTENSIONS_PVT.DELETE_FOLDER_CUSTOM',l_module_name);

Line: 434


END Delete_Folder_Custom;