[Home] [Help]
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)
84: and s.appl_top_id = a.appl_top_id
85: and a.name = 'GLOBAL'
86: and a.appl_top_type = 'G'
87: and a.applications_system_name = fpg.applications_system_name
96: from AD_SNAPSHOTS
97: where appl_top_id = p_appl_top_id
98: and snapshot_name = CURRENT_VIEW_SNP_NAME
99: and snapshot_type =
100: ad_file_sys_snapshots_pkg.get_snapshot_type(CURRENT_VIEW_SNP_NAME);
101: exception
102: when no_data_found then
103: return(NOT_APPLIED);
104: end;
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)
183: and s.appl_top_id = a.appl_top_id
184: and a.name = 'GLOBAL'
185: and a.appl_top_type = 'G'
186: and a.applications_system_name = fpg.applications_system_name
195: from AD_SNAPSHOTS
196: where appl_top_id = p_appl_top_id
197: and snapshot_name = CURRENT_VIEW_SNP_NAME
198: and snapshot_type =
199: ad_file_sys_snapshots_pkg.get_snapshot_type(CURRENT_VIEW_SNP_NAME);
200: exception
201: when no_data_found then
202: return(NOT_APPLIED);
203: end;
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)
385: and s.appl_top_id = a.appl_top_id
386: and a.name = 'GLOBAL'
387: and a.appl_top_type = 'G'
388: and a.applications_system_name = fpg.applications_system_name
398: from AD_SNAPSHOTS
399: where appl_top_id = p_appl_top_id
400: and snapshot_name = CURRENT_VIEW_SNP_NAME
401: and snapshot_type =
402: ad_file_sys_snapshots_pkg.get_snapshot_type(CURRENT_VIEW_SNP_NAME);
403: exception
404: /*bug 2770858 Do not rollback and do not raise exception*/
405: when no_data_found then
406: return(NOT_APPLIED);
478: from AD_SNAPSHOTS
479: where appl_top_id = p_appl_top_id
480: and snapshot_name = CURRENT_VIEW_SNP_NAME
481: and snapshot_type =
482: ad_file_sys_snapshots_pkg.get_snapshot_type(CURRENT_VIEW_SNP_NAME);
483: exception
484: when no_data_found then
485: /* bug 2770858 Do not rollback */
486: return;
567: from AD_SNAPSHOTS
568: where appl_top_id = p_appl_top_id
569: and snapshot_name = CURRENT_VIEW_SNP_NAME
570: and snapshot_type =
571: ad_file_sys_snapshots_pkg.get_snapshot_type(CURRENT_VIEW_SNP_NAME);
572: exception
573: when no_data_found then
574: /* bug 2770858 Do not rollback */
575: return;
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)
864: and s.appl_top_id = a.appl_top_id
865: and a.name = 'GLOBAL'
866: and a.appl_top_type = 'G'
867: and a.applications_system_name = fpg.applications_system_name
877: from AD_SNAPSHOTS
878: where appl_top_id = p_appl_top_id
879: and snapshot_name = CURRENT_VIEW_SNP_NAME
880: and snapshot_type =
881: ad_file_sys_snapshots_pkg.get_snapshot_type(CURRENT_VIEW_SNP_NAME);
882: exception
883: when no_data_found then
884: /* bug 2770858 Do not rollback */
885: return;