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.OTA_UTILITY dependencies on OTA_LO_FOLDERS

Line 2454: parent_obj_id ota_lo_folders.folder_id%TYPE;

2450: -- --------------------------------------
2451: -- ----------------------------------------------------------------
2452: Procedure get_content_object_path (p_obj_id varchar2,p_obj_type varchar2, p_path OUT NOCOPY varchar2)
2453: IS
2454: parent_obj_id ota_lo_folders.folder_id%TYPE;
2455: full_path varchar2(1000) :=null;
2456: current_obj_id ota_lo_folders.folder_id%TYPE := p_obj_id;
2457: l_proc VARCHAR2(72) := g_package||'get_content_object_path';
2458:

Line 2456: current_obj_id ota_lo_folders.folder_id%TYPE := p_obj_id;

2452: Procedure get_content_object_path (p_obj_id varchar2,p_obj_type varchar2, p_path OUT NOCOPY varchar2)
2453: IS
2454: parent_obj_id ota_lo_folders.folder_id%TYPE;
2455: full_path varchar2(1000) :=null;
2456: current_obj_id ota_lo_folders.folder_id%TYPE := p_obj_id;
2457: l_proc VARCHAR2(72) := g_package||'get_content_object_path';
2458:
2459: Cursor c_parent_lo_id(current_lo_id IN VARCHAR2)
2460: IS

Line 2474: from ota_lo_folders

2470:
2471: Cursor c_parent_folder_id(current_folder_id IN VARCHAR2)
2472: IS
2473: select nvl(parent_folder_id,-1)
2474: from ota_lo_folders
2475: where folder_id = current_folder_id;
2476:
2477: Begin
2478: if (p_obj_type = 'L') then