APPS.AD_FILE_SYS_SNAPSHOTS_PKG dependencies on FND_PRODUCT_GROUPS

Line 407: from fnd_product_groups

403: select release_id into l_release_id from ad_releases
404: where to_char(major_version) || '.' ||
405: to_char(minor_version) || '.' ||
406: to_char(tape_version) = (select release_name
407: from fnd_product_groups
408: where applications_system_name =
409: p_apps_system_name);
410: insert into ad_snapshots
411: (

Line 668: -- release_name from FND_PRODUCT_GROUPS. This caused

664:
665: -- Caller ensures that preseeded info is present
666:
667: -- Bug 4143940: Earlier this query used to use the
668: -- release_name from FND_PRODUCT_GROUPS. This caused
669: -- a few problems because instantiate_current_view()
670: -- ended up using a different release_name (l_rlse_nm)
671: -- and this function was using another one (like
672: -- 11.5.10 in instantiate_current_view() and 11.5.10.1

Line 1129: from fnd_product_groups;

1125: -- that, first get the onsite rlse.
1126:
1127: select release_name
1128: into l_curr_rlse_nm
1129: from fnd_product_groups;
1130:
1131: -- Then get its rlse-id
1132:
1133: declare

Line 2216: from fnd_product_groups;

2212: -- First, abort if PRIMARY apps-sys-nm has not been set by bootstrap code
2213:
2214: select nvl(applications_system_name, '1 UNKNOWN 1')
2215: into l_prim_apps_sys_nm
2216: from fnd_product_groups;
2217:
2218: if l_prim_apps_sys_nm = '1 UNKNOWN 1' then
2219: raise_application_error(-20000,
2220: 'Primary Applications System has not been initialized yet.');

Line 2556: from fnd_product_groups;

2552: ret_status boolean;
2553: begin
2554: select release_name
2555: into G_CURRENT_RELEASE
2556: from fnd_product_groups;
2557:
2558: ret_status:=system.ad_apps_private.compare_releases(G_CURRENT_RELEASE, rel_name);
2559: --Compare and update ONLY if the rel_name is greater than the value in db.
2560: if ret_status = TRUE then

Line 2561: update fnd_product_groups

2557:
2558: ret_status:=system.ad_apps_private.compare_releases(G_CURRENT_RELEASE, rel_name);
2559: --Compare and update ONLY if the rel_name is greater than the value in db.
2560: if ret_status = TRUE then
2561: update fnd_product_groups
2562: set release_name = rel_name,
2563: last_update_date = sysdate,
2564: last_updated_by = 1
2565: where product_group_id = 1;