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.AD_FILE_UTIL dependencies on AD_BUGS

Line 1540: -- Gets the bug_id from AD_BUGS for the bugnumbers in

1536: -- Procedure
1537: -- load_preseeded_bugfixes
1538: --
1539: -- Purpose
1540: -- Gets the bug_id from AD_BUGS for the bugnumbers in
1541: -- in ad_check_file_temp table .
1542: -- Creates new rows in the AD_BUGS for the new bugnumbers
1543: -- and gets the bug_id for those bugnumbers and stores them
1544: -- ad_check_file_temp table .

Line 1542: -- Creates new rows in the AD_BUGS for the new bugnumbers

1538: --
1539: -- Purpose
1540: -- Gets the bug_id from AD_BUGS for the bugnumbers in
1541: -- in ad_check_file_temp table .
1542: -- Creates new rows in the AD_BUGS for the new bugnumbers
1543: -- and gets the bug_id for those bugnumbers and stores them
1544: -- ad_check_file_temp table .
1545: --
1546: -- Inserts those BUG_IDs into AD_SNAPSHOT_BUGFIXES

Line 1555: -- Get the bug_id from ad_bugs

1551: procedure load_preseeded_bugfixes
1552: is
1553: begin
1554: --
1555: -- Get the bug_id from ad_bugs
1556: --
1557: -- Bug 5758908 - stangutu - 14 June, 2007
1558: ad_file_util.error_buf := 'load_preseeded_bugfixes('||
1559: 'SET t.file_id = (SELECT b.bug_id '||

Line 1560: 'FROM ad_bugs b WHERE b.bug_number = t.filename '||

1556: --
1557: -- Bug 5758908 - stangutu - 14 June, 2007
1558: ad_file_util.error_buf := 'load_preseeded_bugfixes('||
1559: 'SET t.file_id = (SELECT b.bug_id '||
1560: 'FROM ad_bugs b WHERE b.bug_number = t.filename '||
1561: 'AND b.aru_release_name = t.subdir '||
1562: 'AND b.trackable_entity_abbr=t.app_short_name '||
1563: 'AND b.language = t.language '||
1564: 'AND b.baseline_name = t.manifest_vers_2), '||

Line 1570: SET t.file_id = (SELECT /+ INDEX(B AD_BUGS_U2) / b.bug_id

1566: 'WHERE NVL(t.active_flag,''N'') = ''Y''):(';
1567: begin
1568: -- Bug 5579901- stangutu - 9 Oct, 2006
1569: UPDATE ad_check_file_temp t
1570: SET t.file_id = (SELECT /*+ INDEX(B AD_BUGS_U2) */ b.bug_id
1571: FROM ad_bugs b
1572: WHERE b.bug_number = t.filename
1573: AND b.aru_release_name = t.subdir
1574: -- bug 6317065 diverma Thu Aug 2 04:10:21 PDT 2007

Line 1571: FROM ad_bugs b

1567: begin
1568: -- Bug 5579901- stangutu - 9 Oct, 2006
1569: UPDATE ad_check_file_temp t
1570: SET t.file_id = (SELECT /*+ INDEX(B AD_BUGS_U2) */ b.bug_id
1571: FROM ad_bugs b
1572: WHERE b.bug_number = t.filename
1573: AND b.aru_release_name = t.subdir
1574: -- bug 6317065 diverma Thu Aug 2 04:10:21 PDT 2007
1575: AND b.trackable_entity_abbr = t.app_short_name

Line 1591: -- add new entries in ad_bugs

1587: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';
1588: raise;
1589: end;
1590: --
1591: -- add new entries in ad_bugs
1592: --
1593: -- Bug 5758908 - stangutu - 14 Jun, 2007 */
1594: ad_file_util.error_buf := 'load_preseeded_bugfixes('||
1595: 'INSERT INTO ad_bugs '||

Line 1595: 'INSERT INTO ad_bugs '||

1591: -- add new entries in ad_bugs
1592: --
1593: -- Bug 5758908 - stangutu - 14 Jun, 2007 */
1594: ad_file_util.error_buf := 'load_preseeded_bugfixes('||
1595: 'INSERT INTO ad_bugs '||
1596: '(bug_id, bug_number,aru_release_name, '||
1597: 'creation_date, created_by, last_update_date, '||
1598: 'last_updated_by, baseline_name, generic_patch, '||
1599: ' trackable_entity_abbr ) SELECT '||

Line 1600: 'ad_bugs_s.nextval, temp.bugfix, temp.rel, '||

1596: '(bug_id, bug_number,aru_release_name, '||
1597: 'creation_date, created_by, last_update_date, '||
1598: 'last_updated_by, baseline_name, generic_patch, '||
1599: ' trackable_entity_abbr ) SELECT '||
1600: 'ad_bugs_s.nextval, temp.bugfix, temp.rel, '||
1601: 'temp.edate, 5, temp.edate, 5, '||
1602: 'temp.baseline_name, temp.generic_patch, '||
1603: 'temp.trackable_entity_abbr, language)' ||
1604: 'FROM (SELECT DISTINCT t.filename bugfix, '||

Line 1614: INSERT INTO ad_bugs

1610: 'FROM ad_check_file_temp t '||
1611: 'WHERE t.file_id is null '||
1612: 'AND NVL(t.active_flag,''N'') = ''Y'') temp):(';
1613: begin
1614: INSERT INTO ad_bugs
1615: (bug_id, bug_number,aru_release_name,
1616: creation_date, created_by, last_update_date, last_updated_by,
1617: -- Bug 5758908 - stangutu - 14 June, 2007
1618: baseline_name, generic_patch, trackable_entity_abbr,

Line 1622: ad_bugs_s.nextval, temp.bugfix, temp.rel,

1618: baseline_name, generic_patch, trackable_entity_abbr,
1619: -- bug 5615204 diverma Tuesday, August 07, 2007
1620: language)
1621: SELECT
1622: ad_bugs_s.nextval, temp.bugfix, temp.rel,
1623: temp.edate, 5, temp.edate, 5,
1624: -- Bug 5758908 - stangutu - 14 June, 2007
1625: temp.baseline_name, temp.generic_patch, temp.trackable_entity_abbr,
1626: -- bug 5615204 diverma Tuesday, August 07, 2007

Line 1654: 'FROM ad_bugs b WHERE b.bug_number = t.filename '||

1650: -- Bug 5758908 - stangutu - 14 June, 2007
1651: ad_file_util.error_buf := 'load_preseeded_bugfixes('||
1652: 'UPDATE ad_check_file_temp t '||
1653: 'SET t.file_id = (SELECT b.bug_id '||
1654: 'FROM ad_bugs b WHERE b.bug_number = t.filename '||
1655: 'AND b.aru_release_name = t.subdir, '||
1656: 'AND b.trackable_entity_abbr = t.app_short_name' ||
1657: 'AND b.language = t.language '||
1658: 'AND b.baseline_name = t.manifest_vers_2), '||

Line 1664: SET t.file_id = (SELECT /+ INDEX(B AD_BUGS_U2) / b.bug_id

1660: 'WHERE NVL(t.active_flag,''N'') = ''Y''):(';
1661: begin
1662: -- Bug 5579901- stangutu - 9 Oct, 2006
1663: UPDATE ad_check_file_temp t
1664: SET t.file_id = (SELECT /*+ INDEX(B AD_BUGS_U2) */ b.bug_id
1665: FROM ad_bugs b
1666: WHERE b.bug_number = t.filename
1667: AND b.aru_release_name = t.subdir
1668: -- bug 6317065 diverma Thu Aug 2 04:10:21 PDT 2007

Line 1665: FROM ad_bugs b

1661: begin
1662: -- Bug 5579901- stangutu - 9 Oct, 2006
1663: UPDATE ad_check_file_temp t
1664: SET t.file_id = (SELECT /*+ INDEX(B AD_BUGS_U2) */ b.bug_id
1665: FROM ad_bugs b
1666: WHERE b.bug_number = t.filename
1667: AND b.aru_release_name = t.subdir
1668: -- bug 6317065 diverma Thu Aug 2 04:10:21 PDT 2007
1669: AND b.trackable_entity_abbr = t.app_short_name

Line 1770: -- Add new entries in AD_BUGS

1766: set LANGUAGE = 'US'
1767: where LANGUAGE is null;
1768:
1769: --
1770: -- Add new entries in AD_BUGS
1771: --
1772: insert into ad_bugs
1773: (
1774: BUG_ID, BUG_NUMBER, ARU_RELEASE_NAME, CREATION_DATE,

Line 1772: insert into ad_bugs

1768:
1769: --
1770: -- Add new entries in AD_BUGS
1771: --
1772: insert into ad_bugs
1773: (
1774: BUG_ID, BUG_NUMBER, ARU_RELEASE_NAME, CREATION_DATE,
1775: CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY,
1776: -- bug 5615204 diverma Tuesday, August 07, 2007

Line 1781: ad_bugs_s.nextval, BUG_NUMBER, ARU_RELEASE_NAME, sysdate,

1777: TRACKABLE_ENTITY_ABBR, BASELINE_NAME, GENERIC_PATCH, LANGUAGE
1778: )
1779: -- bug 6332450 diverma Thu Aug 9 06:25:06 PDT 2007
1780: select
1781: ad_bugs_s.nextval, BUG_NUMBER, ARU_RELEASE_NAME, sysdate,
1782: 5, sysdate, 5, TRACKABLE_ENTITY_NAME , BASELINE_NAME,
1783: GENERIC_PATCH, LANGUAGE
1784: from
1785: (

Line 1798: ad_bugs b

1794: not exists (
1795: select
1796: 'x'
1797: from
1798: ad_bugs b
1799: where
1800: b.bug_number = tmp.BUG_NUMBER
1801: -- bug 6332450 diverma Thu Aug 9 06:25:06 PDT 2007
1802: and b.trackable_entity_abbr = tmp.TRACKABLE_ENTITY_NAME

Line 1823: b.bug_id from ad_bugs b

1819: --
1820: update AD_PATCH_HIST_TEMP t
1821: set t.bug_id = (
1822: select
1823: b.bug_id from ad_bugs b
1824: where
1825: b.bug_number = t.BUG_NUMBER
1826: -- bug 6332450 diverma Thu Aug 9 06:25:06 PDT 2007
1827: and b.trackable_entity_abbr = t.TRACKABLE_ENTITY_NAME