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_APPL_TOPS

Line 79: from AD_SNAPSHOTS s, AD_APPL_TOPS a,

75: if (p_appl_top_id = -1)
76: then
77: begin
78: select s.snapshot_id into l_snapshot_id
79: from AD_SNAPSHOTS s, AD_APPL_TOPS a,
80: FND_PRODUCT_GROUPS fpg
81: where s.snapshot_name = GLOBAL_VIEW_SNP_NAME
82: and s.snapshot_type =
83: ad_file_sys_snapshots_pkg.get_snapshot_type(GLOBAL_VIEW_SNP_NAME)

Line 178: from AD_SNAPSHOTS s, AD_APPL_TOPS a,

174: if (p_appl_top_id = -1)
175: then
176: begin
177: select s.snapshot_id into l_snapshot_id
178: from AD_SNAPSHOTS s, AD_APPL_TOPS a,
179: FND_PRODUCT_GROUPS fpg
180: where s.snapshot_name = GLOBAL_VIEW_SNP_NAME
181: and s.snapshot_type =
182: ad_file_sys_snapshots_pkg.get_snapshot_type(GLOBAL_VIEW_SNP_NAME)

Line 380: from AD_SNAPSHOTS s, AD_APPL_TOPS a,

376: if (p_appl_top_id = -1)
377: then
378: begin
379: select s.snapshot_id into l_snapshot_id
380: from AD_SNAPSHOTS s, AD_APPL_TOPS a,
381: FND_PRODUCT_GROUPS fpg
382: where s.snapshot_name = GLOBAL_VIEW_SNP_NAME
383: and s.snapshot_type =
384: ad_file_sys_snapshots_pkg.get_snapshot_type(GLOBAL_VIEW_SNP_NAME)

Line 859: from AD_SNAPSHOTS s, AD_APPL_TOPS a,

855: if (p_appl_top_id = -1)
856: then
857: begin
858: select s.snapshot_id into l_snapshot_id
859: from AD_SNAPSHOTS s, AD_APPL_TOPS a,
860: FND_PRODUCT_GROUPS fpg
861: where s.snapshot_name = GLOBAL_VIEW_SNP_NAME
862: and s.snapshot_type =
863: ad_file_sys_snapshots_pkg.get_snapshot_type(GLOBAL_VIEW_SNP_NAME)

Line 1024: l_app_sys_name ad_appl_tops.applications_system_name%TYPE;

1020: p_app_sys_name in varchar2,
1021: p_appl_top_type in varchar2)
1022: return number
1023: is
1024: l_app_sys_name ad_appl_tops.applications_system_name%TYPE;
1025: l_appl_top_type ad_appl_tops.appl_top_type%TYPE;
1026: l_appl_top_id ad_appl_tops.appl_top_id%TYPE;
1027: begin
1028:

Line 1025: l_appl_top_type ad_appl_tops.appl_top_type%TYPE;

1021: p_appl_top_type in varchar2)
1022: return number
1023: is
1024: l_app_sys_name ad_appl_tops.applications_system_name%TYPE;
1025: l_appl_top_type ad_appl_tops.appl_top_type%TYPE;
1026: l_appl_top_id ad_appl_tops.appl_top_id%TYPE;
1027: begin
1028:
1029: select decode(upper(p_appl_top_type),'','R',

Line 1026: l_appl_top_id ad_appl_tops.appl_top_id%TYPE;

1022: return number
1023: is
1024: l_app_sys_name ad_appl_tops.applications_system_name%TYPE;
1025: l_appl_top_type ad_appl_tops.appl_top_type%TYPE;
1026: l_appl_top_id ad_appl_tops.appl_top_id%TYPE;
1027: begin
1028:
1029: select decode(upper(p_appl_top_type),'','R',
1030: upper(p_appl_top_type))

Line 1043: from AD_APPL_TOPS

1039: end if;
1040:
1041: begin
1042: select appl_top_id into l_appl_top_id
1043: from AD_APPL_TOPS
1044: where name = p_appl_top_name
1045: and appl_top_type = l_appl_top_type
1046: and applications_system_name = l_app_sys_name;
1047: exception

Line 1050: 'No rows in AD_APPL_TOPS table for appl_top_name '||

1046: and applications_system_name = l_app_sys_name;
1047: exception
1048: when no_data_found then
1049: raise_application_error(-20001,
1050: 'No rows in AD_APPL_TOPS table for appl_top_name '||
1051: '''' || p_appl_top_name || ''''||
1052: 'and applications system name '||
1053: '''' || l_app_sys_name || ''''||
1054: ' and appl_top type '||

Line 1059: 'Too many rows in AD_APPL_TOPS table for appl_top_name '||

1055: '''' || l_appl_top_type || '''');
1056: return(0);
1057: when too_many_rows then
1058: raise_application_error(-20001,
1059: 'Too many rows in AD_APPL_TOPS table for appl_top_name '||
1060: '''' || p_appl_top_name || ''''||
1061: 'and applications system name '||
1062: '''' || l_app_sys_name || '''');
1063: return(0);