APPS.AD_FILE_SYS_SNAPSHOTS_PKG dependencies on AD_FILE_UTIL

Line 369: ad_file_util.update_timestamp('BACKFILLED_BUGS_IN_CURRENT_VIEW_SNAPSHOT',

365: end if;
366:
367: -- mark as having done this backfill
368:
369: ad_file_util.update_timestamp('BACKFILLED_BUGS_IN_CURRENT_VIEW_SNAPSHOT',
370: l_apps_sys_nm||'*'||l_at_name);
371:
372: commit;
373: end;

Line 994: ad_file_util.lock_infrastructure;

990: is
991: l_at_id number;
992: begin
993: -- obtain a lock, to ensure serialized access to temp table infrastructure
994: ad_file_util.lock_infrastructure;
995:
996: if not snapshot_maint_allowed then
997: goto return_success;
998: end if;

Line 1041: ad_file_util.unlock_infrastructure;

1037: -- release the lock upon successful completion
1038:
1039: <>
1040:
1041: ad_file_util.unlock_infrastructure;
1042:
1043: exception when others then
1044: -- release the lock upon errors
1045: ad_file_util.unlock_infrastructure;

Line 1045: ad_file_util.unlock_infrastructure;

1041: ad_file_util.unlock_infrastructure;
1042:
1043: exception when others then
1044: -- release the lock upon errors
1045: ad_file_util.unlock_infrastructure;
1046:
1047: -- and allow the exception (that made us land here) to propogate
1048: raise;
1049: end update_current_view;

Line 1115: ad_file_util.lock_infrastructure;

1111: end if;
1112:
1113: if not p_caller_is_managing_locks then
1114: -- obtain a lock, to ensure serialized access to temp table infrastructure
1115: ad_file_util.lock_infrastructure;
1116: end if;
1117:
1118: if G_DEBUG then
1119: put_line('In update_current_view(). (the one that '||

Line 2234: ad_file_util.unlock_infrastructure;

2230:
2231: <>
2232:
2233: if not p_caller_is_managing_locks then
2234: ad_file_util.unlock_infrastructure;
2235: end if;
2236:
2237: exception when others then
2238: if not p_caller_is_managing_locks then

Line 2240: ad_file_util.unlock_infrastructure;

2236:
2237: exception when others then
2238: if not p_caller_is_managing_locks then
2239: -- release the lock upon errors
2240: ad_file_util.unlock_infrastructure;
2241: end if;
2242:
2243: -- and allow the exception (that made us land here) to propogate
2244: raise;

Line 2282: ad_file_util.lock_infrastructure;

2278: l_preseeded_snapshot_id := -1;
2279:
2280: if not p_caller_is_managing_locks then
2281: -- obtain a lock, to ensure serialized access to temp table infrastructure
2282: ad_file_util.lock_infrastructure;
2283: end if;
2284:
2285: if not snapshot_maint_allowed then
2286: p_return_code := G_SNAPSHOT_MAINT_DISALLOWED; -- snapshot maint not allowed

Line 2626: ad_file_util.unlock_infrastructure;

2622: );
2623: <>
2624:
2625: if not p_caller_is_managing_locks then
2626: ad_file_util.unlock_infrastructure;
2627: end if;
2628:
2629: exception when others then
2630: if not p_caller_is_managing_locks then

Line 2632: ad_file_util.unlock_infrastructure;

2628:
2629: exception when others then
2630: if not p_caller_is_managing_locks then
2631: -- release the lock upon errors
2632: ad_file_util.unlock_infrastructure;
2633: end if;
2634:
2635: -- and allow the exception (that made us land here) to propogate
2636: raise;