APPS.PER_FR_TEMPLATE dependencies on FND_LOBS

Line 13: FROM fnd_lobs

9:
10:
11: SELECT substr(substr(file_name,instr(translate(file_name,'/\','//'),'/',-1)+1),1,20)
12: INTO l_file_name
13: FROM fnd_lobs
14: WHERE file_id = p_file_id;
15:
16:
17:

Line 20: UPDATE fnd_lobs set program_name='BIAF_FR_XML_O'

16:
17:
18: if( l_file_name <>'BIAF2005.rtf') then
19:
20: UPDATE fnd_lobs set program_name='BIAF_FR_XML_O'
21: where file_name like '%BIAF2005.rtf'
22: and program_name='BIAF_FR_XML';
23: end if;
24:

Line 39: FROM fnd_lobs

35: effective_start_date,
36: effective_end_date)
37: SELECT p_file_id, l_file_name, 'Template Uploaded on '||to_char(sysdate,'dd-MON-yyyy'),
38: sysdate, to_date('31-12-4000','dd-MM-yyyy')
39: FROM fnd_lobs
40: WHERE file_id = p_file_id;
41: END insert_data;
42: end PER_FR_TEMPLATE;