APPS.AD_FILE_SYS_SNAPSHOTS_PKG dependencies on FND_PRODUCT_GROUPS

Line 443: from fnd_product_groups

439: select release_id into l_release_id from ad_releases
440: where to_char(major_version) || '.' ||
441: to_char(minor_version) || '.' ||
442: to_char(tape_version) = (select release_name
443: from fnd_product_groups
444: where applications_system_name =
445: p_apps_system_name);
446: insert into ad_snapshots
447: (

Line 726: -- release_name from FND_PRODUCT_GROUPS. This caused

722:
723: -- Caller ensures that preseeded info is present
724:
725: -- Bug 4143940: Earlier this query used to use the
726: -- release_name from FND_PRODUCT_GROUPS. This caused
727: -- a few problems because instantiate_current_view()
728: -- ended up using a different release_name (l_rlse_nm)
729: -- and this function was using another one (like
730: -- 11.5.10 in instantiate_current_view() and 11.5.10.1

Line 1206: from fnd_product_groups;

1202: -- that, first get the onsite rlse.
1203:
1204: select release_name
1205: into l_curr_rlse_nm
1206: from fnd_product_groups;
1207:
1208: -- Then get its rlse-id
1209:
1210: declare

Line 2296: from fnd_product_groups;

2292: -- First, abort if PRIMARY apps-sys-nm has not been set by bootstrap code
2293:
2294: select nvl(applications_system_name, '1 UNKNOWN 1')
2295: into l_prim_apps_sys_nm
2296: from fnd_product_groups;
2297:
2298: if l_prim_apps_sys_nm = '1 UNKNOWN 1' then
2299: raise_application_error(-20000,
2300: 'Primary Applications System has not been initialized yet.');

Line 2647: from fnd_product_groups;

2643: ret_status boolean;
2644: begin
2645: select release_name
2646: into G_CURRENT_RELEASE
2647: from fnd_product_groups;
2648:
2649: ret_status:=system.ad_apps_private.compare_releases(G_CURRENT_RELEASE, rel_name);
2650: --Compare and update ONLY if the rel_name is greater than the value in db.
2651: if ret_status = TRUE then

Line 2652: update fnd_product_groups

2648:
2649: ret_status:=system.ad_apps_private.compare_releases(G_CURRENT_RELEASE, rel_name);
2650: --Compare and update ONLY if the rel_name is greater than the value in db.
2651: if ret_status = TRUE then
2652: update fnd_product_groups
2653: set release_name = rel_name,
2654: last_update_date = sysdate,
2655: last_updated_by = 1
2656: where product_group_id = 1;