[Home] [Help]
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)
84: and s.appl_top_id = a.appl_top_id
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)
183: and s.appl_top_id = a.appl_top_id
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)
385: and s.appl_top_id = a.appl_top_id
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)
864: and s.appl_top_id = a.appl_top_id
1011: and optionally an Applications System name and/or APPL_TOP type.
1012: 1. If APPL_TOP type not specified, it defaults to a normal APPL_TOP
1013: i.e 'R'
1014: 2. If Applications Sytem name not specified, it defaults to the value in
1015: FND_PRODUCT_GROUPS.
1016:
1017: *******************************************************************************/
1018:
1019: function getAppltopID(p_appl_top_name in varchar2,
1032: from dual;
1033:
1034: if ((upper(p_app_sys_name)) is null) then
1035: select applications_system_name into l_app_sys_name
1036: from FND_PRODUCT_GROUPS;
1037: else
1038: l_app_sys_name := p_app_sys_name;
1039: end if;
1040: