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_PATCH dependencies on AD_SNAPSHOT_BUGFIXES_S

Line 722: l_patch_succ ad_snapshot_bugfixes.success_flag%TYPE;

718: p_flag in varchar2,
719: p_reason_text in varchar2)
720: is
721: l_bug_id ad_bugs.bug_id%TYPE;
722: l_patch_succ ad_snapshot_bugfixes.success_flag%TYPE;
723:
724: begin
725:
726: -- get bug id from ad_bugs for the passed bug number and aru_release_name.

Line 845: l_snapshot_bug_id ad_snapshot_bugfixes.snapshot_bug_id%TYPE;

841: p_bug_status in varchar2)
842: is
843: l_bug_id ad_bugs.bug_id%TYPE;
844: l_snapshot_id ad_snapshots.snapshot_id%TYPE;
845: l_snapshot_bug_id ad_snapshot_bugfixes.snapshot_bug_id%TYPE;
846:
847: begin
848:
849: -- CASE I: On create, when there are no entries in AD_BUGS for the

Line 951: values (ad_snapshot_bugfixes_s.nextval,

947: creation_date,
948: last_update_date,
949: last_updated_by,
950: created_by)
951: values (ad_snapshot_bugfixes_s.nextval,
952: l_snapshot_id,
953: l_bug_id,
954: p_bug_status,
955: 'Y',