DBA Data[Home] [Help]

APPS.IEX_LOAD_FILE_PVT dependencies on FND_LOBS

Line 107: FROM fnd_lobs

103: (p_file_id IN NUMBER )
104: IS
105: CURSOR C_GET_FileName (IN_ID NUMBER) IS
106: SELECT substr(file_name, instr(file_name, '/IEXFm')+1, length(file_name)-instr(file_name,'/IEXFm') )
107: FROM fnd_lobs
108: WHERE file_id = IN_ID;
109: --
110: l_file_name VARCHAR2(1000);
111:

Line 123: Update fnd_lobs

119: null;
120: END IF;
121: CLOSE C_GET_FileName;
122:
123: Update fnd_lobs
124: set file_name = l_file_name
125: where file_id = p_file_id;
126:
127: END UPDATE_FILE_NAME;