APPS.JTF_DIAGNOSTIC_COREAPI dependencies on ALL_SOURCE

Line 1860: from all_source z

1856: hold_version varchar2(50);
1857: begin
1858: select substr(z.text, instr(z.text,'$Header')+10, 40)
1859: into hold_version
1860: from all_source z
1861: where z.name = p_package
1862: and z.type = p_type
1863: and z.owner = p_schema
1864: and z.text like '%$Header%';

Line 2360: from all_source s

2356: , c_obj_type varchar2
2357: , c_obj_owner varchar2) is
2358: select substr(substr(s.text,instr(s.text,'$Header')+9),1,
2359: instr(substr(s.text,instr(s.text,'$Header')+9),' ',1,2)-1) file_vers
2360: from all_source s
2361: where s.name = c_obj_name
2362: and s.type = c_obj_type
2363: and s.owner = c_obj_owner
2364: and s.text like '%$Header%';

Line 3968: from all_source z

3964: hold_version varchar2(50);
3965: begin
3966: select substr(z.text, instr(z.text,'$Header')+10, 40)
3967: into hold_version
3968: from all_source z
3969: where z.name = p_package
3970: and z.type = p_type
3971: and z.owner = p_schema
3972: and z.text like '%$Header%';

Line 4628: from all_source s

4624: , c_obj_type varchar2
4625: , c_obj_owner varchar2) is
4626: select substr(substr(s.text,instr(s.text,'$Header')+9),1,
4627: instr(substr(s.text,instr(s.text,'$Header')+9),' ',1,2)-1) file_vers
4628: from all_source s
4629: where name = c_obj_name
4630: and type = c_obj_type
4631: and owner = c_obj_owner
4632: and text like '%$Header%';