SYSTEM.AD_APPS_PRIVATE dependencies on DBA_SOURCE

Line 1438: select text from dba_source

1434: source_text varchar2(2000);
1435: row_count integer;
1436: prog_text varchar2(32760);
1437: cursor c1 is
1438: select text from dba_source
1439: where owner = upper(copy_code.from_schema)
1440: and name = copy_code.object_name
1441: and type = copy_code.object_type
1442: order by line;

Line 1450: from dba_source s

1446: select
1447: substr(s.text, instr(s.text,'$Header'||': '),
1448: ((instr(s.text,' $', instr(s.text,'$Header'||': ')) + 2)
1449: - instr(s.text,'$Header'||': ')))
1450: from dba_source s
1451: where s.owner= upper(c_owner)
1452: and s.name = upper(c_name)
1453: and s.type = upper(c_type)
1454: and s.line between 2 and 5

Line 1555: from dba_source

1551: cursor LINE_COUNT (c_owner in varchar2,
1552: c_name in varchar2,
1553: c_type in varchar2) is
1554: select count(*)
1555: from dba_source
1556: where owner = upper(c_owner)
1557: and name = upper(c_name)
1558: and type = upper(c_type);
1559: cursor LINE_AND_CHAR_COUNT (c_owner in varchar2,

Line 1563: from dba_source

1559: cursor LINE_AND_CHAR_COUNT (c_owner in varchar2,
1560: c_name in varchar2,
1561: c_type in varchar2) is
1562: select count(*), sum(length(text))
1563: from dba_source
1564: where owner = upper(c_owner)
1565: and name = upper(c_name)
1566: and type = upper(c_type);
1567: cursor SET_DIFFERENCE (s_owner in varchar2,

Line 1574: dba_source ds1,

1570: c_type in varchar2) is
1571: SELECT /*+FIRST_ROWS */
1572: 'X'
1573: FROM
1574: dba_source ds1,
1575: dba_source ds2
1576: WHERE
1577: ds1.owner = UPPER(s_owner)
1578: AND ds1.name = UPPER(c_name )

Line 1575: dba_source ds2

1571: SELECT /*+FIRST_ROWS */
1572: 'X'
1573: FROM
1574: dba_source ds1,
1575: dba_source ds2
1576: WHERE
1577: ds1.owner = UPPER(s_owner)
1578: AND ds1.name = UPPER(c_name )
1579: AND ds1.type = UPPER(c_type )

Line 2720: from dba_source s

2716: select
2717: substr(s.text, instr(s.text,'$Header'||': '),
2718: ((instr(s.text,' $', instr(s.text,'$Header'||': ')) + 2)
2719: - instr(s.text,'$Header'||': ')))
2720: from dba_source s
2721: where s.owner= upper(c_owner)
2722: and s.name = upper(c_name)
2723: and s.type = upper(c_type)
2724: and s.line between 2 and 5