APPS.AD_FILE_SYS_SNAPSHOTS_PKG dependencies on AD_FILE_UTIL

Line 342: ad_file_util.update_timestamp('BACKFILLED_BUGS_IN_CURRENT_VIEW_SNAPSHOT',

338: end if;
339:
340: -- mark as having done this backfill
341:
342: ad_file_util.update_timestamp('BACKFILLED_BUGS_IN_CURRENT_VIEW_SNAPSHOT',
343: l_apps_sys_nm||'*'||l_at_name);
344:
345: commit;
346: end;

Line 933: ad_file_util.lock_infrastructure;

929: is
930: l_at_id number;
931: begin
932: -- obtain a lock, to ensure serialized access to temp table infrastructure
933: ad_file_util.lock_infrastructure;
934:
935: if not snapshot_maint_allowed then
936: goto return_success;
937: end if;

Line 980: ad_file_util.unlock_infrastructure;

976: -- release the lock upon successful completion
977:
978: <>
979:
980: ad_file_util.unlock_infrastructure;
981:
982: exception when others then
983: -- release the lock upon errors
984: ad_file_util.unlock_infrastructure;

Line 984: ad_file_util.unlock_infrastructure;

980: ad_file_util.unlock_infrastructure;
981:
982: exception when others then
983: -- release the lock upon errors
984: ad_file_util.unlock_infrastructure;
985:
986: -- and allow the exception (that made us land here) to propogate
987: raise;
988: end update_current_view;

Line 1038: ad_file_util.lock_infrastructure;

1034: l_inconsistent_flag := 'Y';
1035:
1036: if not p_caller_is_managing_locks then
1037: -- obtain a lock, to ensure serialized access to temp table infrastructure
1038: ad_file_util.lock_infrastructure;
1039: end if;
1040:
1041: if G_DEBUG then
1042: put_line('In update_current_view(). (the one that '||

Line 2156: ad_file_util.unlock_infrastructure;

2152:
2153: <>
2154:
2155: if not p_caller_is_managing_locks then
2156: ad_file_util.unlock_infrastructure;
2157: end if;
2158:
2159: exception when others then
2160: if not p_caller_is_managing_locks then

Line 2162: ad_file_util.unlock_infrastructure;

2158:
2159: exception when others then
2160: if not p_caller_is_managing_locks then
2161: -- release the lock upon errors
2162: ad_file_util.unlock_infrastructure;
2163: end if;
2164:
2165: -- and allow the exception (that made us land here) to propogate
2166: raise;

Line 2202: ad_file_util.lock_infrastructure;

2198: l_preseeded_snapshot_id := -1;
2199:
2200: if not p_caller_is_managing_locks then
2201: -- obtain a lock, to ensure serialized access to temp table infrastructure
2202: ad_file_util.lock_infrastructure;
2203: end if;
2204:
2205: if not snapshot_maint_allowed then
2206: p_return_code := G_SNAPSHOT_MAINT_DISALLOWED; -- snapshot maint not allowed

Line 2535: ad_file_util.unlock_infrastructure;

2531: );
2532: <>
2533:
2534: if not p_caller_is_managing_locks then
2535: ad_file_util.unlock_infrastructure;
2536: end if;
2537:
2538: exception when others then
2539: if not p_caller_is_managing_locks then

Line 2541: ad_file_util.unlock_infrastructure;

2537:
2538: exception when others then
2539: if not p_caller_is_managing_locks then
2540: -- release the lock upon errors
2541: ad_file_util.unlock_infrastructure;
2542: end if;
2543:
2544: -- and allow the exception (that made us land here) to propogate
2545: raise;