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 1474: -- Gets the bug_id from AD_BUGS for the bugnumbers in

1470: -- Procedure
1471: -- load_preseeded_bugfixes
1472: --
1473: -- Purpose
1474: -- Gets the bug_id from AD_BUGS for the bugnumbers in
1475: -- in ad_check_file_temp table .
1476: -- Creates new rows in the AD_BUGS for the new bugnumbers
1477: -- and gets the bug_id for those bugnumbers and stores them
1478: -- ad_check_file_temp table .

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

1472: --
1473: -- Purpose
1474: -- Gets the bug_id from AD_BUGS for the bugnumbers in
1475: -- in ad_check_file_temp table .
1476: -- Creates new rows in the AD_BUGS for the new bugnumbers
1477: -- and gets the bug_id for those bugnumbers and stores them
1478: -- ad_check_file_temp table .
1479: --
1480: -- Inserts those BUG_IDs into AD_SNAPSHOT_BUGFIXES

Line 1489: -- Get the bug_id from ad_bugs

1485: procedure load_preseeded_bugfixes
1486: is
1487: begin
1488: --
1489: -- Get the bug_id from ad_bugs
1490: --
1491: -- Bug 5758908 - stangutu - 14 June, 2007
1492: ad_file_util.error_buf := 'load_preseeded_bugfixes('||
1493: 'SET t.file_id = (SELECT b.bug_id '||

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

1490: --
1491: -- Bug 5758908 - stangutu - 14 June, 2007
1492: ad_file_util.error_buf := 'load_preseeded_bugfixes('||
1493: 'SET t.file_id = (SELECT b.bug_id '||
1494: 'FROM ad_bugs b WHERE b.bug_number = t.filename '||
1495: 'AND b.aru_release_name = t.subdir '||
1496: 'AND b.trackable_entity_abbr=t.app_short_name '||
1497: 'AND b.language = t.language '||
1498: 'AND b.baseline_name = t.manifest_vers_2), '||

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

1500: 'WHERE NVL(t.active_flag,''N'') = ''Y''):(';
1501: begin
1502: -- Bug 5579901- stangutu - 9 Oct, 2006
1503: UPDATE ad_check_file_temp t
1504: SET t.file_id = (SELECT /*+ INDEX(B AD_BUGS_U2) */ b.bug_id
1505: FROM ad_bugs b
1506: WHERE b.bug_number = t.filename
1507: AND b.aru_release_name = t.subdir
1508: -- bug 6317065 diverma Thu Aug 2 04:10:21 PDT 2007

Line 1505: FROM ad_bugs b

1501: begin
1502: -- Bug 5579901- stangutu - 9 Oct, 2006
1503: UPDATE ad_check_file_temp t
1504: SET t.file_id = (SELECT /*+ INDEX(B AD_BUGS_U2) */ b.bug_id
1505: FROM ad_bugs b
1506: WHERE b.bug_number = t.filename
1507: AND b.aru_release_name = t.subdir
1508: -- bug 6317065 diverma Thu Aug 2 04:10:21 PDT 2007
1509: AND b.trackable_entity_abbr = t.app_short_name

Line 1525: -- add new entries in ad_bugs

1521: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';
1522: raise;
1523: end;
1524: --
1525: -- add new entries in ad_bugs
1526: --
1527: -- Bug 5758908 - stangutu - 14 Jun, 2007 */
1528: ad_file_util.error_buf := 'load_preseeded_bugfixes('||
1529: 'INSERT INTO ad_bugs '||

Line 1529: 'INSERT INTO ad_bugs '||

1525: -- add new entries in ad_bugs
1526: --
1527: -- Bug 5758908 - stangutu - 14 Jun, 2007 */
1528: ad_file_util.error_buf := 'load_preseeded_bugfixes('||
1529: 'INSERT INTO ad_bugs '||
1530: '(bug_id, bug_number,aru_release_name, '||
1531: 'creation_date, created_by, last_update_date, '||
1532: 'last_updated_by, baseline_name, generic_patch, '||
1533: ' trackable_entity_abbr ) SELECT '||

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

1530: '(bug_id, bug_number,aru_release_name, '||
1531: 'creation_date, created_by, last_update_date, '||
1532: 'last_updated_by, baseline_name, generic_patch, '||
1533: ' trackable_entity_abbr ) SELECT '||
1534: 'ad_bugs_s.nextval, temp.bugfix, temp.rel, '||
1535: 'temp.edate, 5, temp.edate, 5, '||
1536: 'temp.baseline_name, temp.generic_patch, '||
1537: 'temp.trackable_entity_abbr, language)' ||
1538: 'FROM (SELECT DISTINCT t.filename bugfix, '||

Line 1548: INSERT INTO ad_bugs

1544: 'FROM ad_check_file_temp t '||
1545: 'WHERE t.file_id is null '||
1546: 'AND NVL(t.active_flag,''N'') = ''Y'') temp):(';
1547: begin
1548: INSERT INTO ad_bugs
1549: (bug_id, bug_number,aru_release_name,
1550: creation_date, created_by, last_update_date, last_updated_by,
1551: -- Bug 5758908 - stangutu - 14 June, 2007
1552: baseline_name, generic_patch, trackable_entity_abbr,

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

1552: baseline_name, generic_patch, trackable_entity_abbr,
1553: -- bug 5615204 diverma Tuesday, August 07, 2007
1554: language)
1555: SELECT
1556: ad_bugs_s.nextval, temp.bugfix, temp.rel,
1557: temp.edate, 5, temp.edate, 5,
1558: -- Bug 5758908 - stangutu - 14 June, 2007
1559: temp.baseline_name, temp.generic_patch, temp.trackable_entity_abbr,
1560: -- bug 5615204 diverma Tuesday, August 07, 2007

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

1584: -- Bug 5758908 - stangutu - 14 June, 2007
1585: ad_file_util.error_buf := 'load_preseeded_bugfixes('||
1586: 'UPDATE ad_check_file_temp t '||
1587: 'SET t.file_id = (SELECT b.bug_id '||
1588: 'FROM ad_bugs b WHERE b.bug_number = t.filename '||
1589: 'AND b.aru_release_name = t.subdir, '||
1590: 'AND b.trackable_entity_abbr = t.app_short_name' ||
1591: 'AND b.language = t.language '||
1592: 'AND b.baseline_name = t.manifest_vers_2), '||

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

1594: 'WHERE NVL(t.active_flag,''N'') = ''Y''):(';
1595: begin
1596: -- Bug 5579901- stangutu - 9 Oct, 2006
1597: UPDATE ad_check_file_temp t
1598: SET t.file_id = (SELECT /*+ INDEX(B AD_BUGS_U2) */ b.bug_id
1599: FROM ad_bugs b
1600: WHERE b.bug_number = t.filename
1601: AND b.aru_release_name = t.subdir
1602: -- bug 6317065 diverma Thu Aug 2 04:10:21 PDT 2007

Line 1599: FROM ad_bugs b

1595: begin
1596: -- Bug 5579901- stangutu - 9 Oct, 2006
1597: UPDATE ad_check_file_temp t
1598: SET t.file_id = (SELECT /*+ INDEX(B AD_BUGS_U2) */ b.bug_id
1599: FROM ad_bugs b
1600: WHERE b.bug_number = t.filename
1601: AND b.aru_release_name = t.subdir
1602: -- bug 6317065 diverma Thu Aug 2 04:10:21 PDT 2007
1603: AND b.trackable_entity_abbr = t.app_short_name

Line 1704: -- Add new entries in AD_BUGS

1700: set LANGUAGE = 'US'
1701: where LANGUAGE is null;
1702:
1703: --
1704: -- Add new entries in AD_BUGS
1705: --
1706: insert into ad_bugs
1707: (
1708: BUG_ID, BUG_NUMBER, ARU_RELEASE_NAME, CREATION_DATE,

Line 1706: insert into ad_bugs

1702:
1703: --
1704: -- Add new entries in AD_BUGS
1705: --
1706: insert into ad_bugs
1707: (
1708: BUG_ID, BUG_NUMBER, ARU_RELEASE_NAME, CREATION_DATE,
1709: CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY,
1710: -- bug 5615204 diverma Tuesday, August 07, 2007

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

1711: TRACKABLE_ENTITY_ABBR, BASELINE_NAME, GENERIC_PATCH, LANGUAGE
1712: )
1713: -- bug 6332450 diverma Thu Aug 9 06:25:06 PDT 2007
1714: select
1715: ad_bugs_s.nextval, BUG_NUMBER, ARU_RELEASE_NAME, sysdate,
1716: 5, sysdate, 5, TRACKABLE_ENTITY_NAME , BASELINE_NAME,
1717: GENERIC_PATCH, LANGUAGE
1718: from
1719: (

Line 1732: ad_bugs b

1728: not exists (
1729: select
1730: 'x'
1731: from
1732: ad_bugs b
1733: where
1734: b.bug_number = tmp.BUG_NUMBER
1735: -- bug 6332450 diverma Thu Aug 9 06:25:06 PDT 2007
1736: and b.trackable_entity_abbr = tmp.TRACKABLE_ENTITY_NAME

Line 1756: b.bug_id from ad_bugs b

1752: --
1753: update AD_PATCH_HIST_TEMP t
1754: set t.bug_id = (
1755: select
1756: b.bug_id from ad_bugs b
1757: where
1758: b.bug_number = t.BUG_NUMBER
1759: -- bug 6332450 diverma Thu Aug 9 06:25:06 PDT 2007
1760: and b.trackable_entity_abbr = t.TRACKABLE_ENTITY_NAME