APPS.INV_QUANTITY_TREE_PVT dependencies on DBMS_LOCK

Line 2102: dbms_lock.allocate_unique(

2098: l_lock_name VARCHAR2(30);
2099: BEGIN
2100:
2101: l_lock_name := 'INV_QT_' || p_organization_id || '_' || p_inventory_item_id;
2102: dbms_lock.allocate_unique(
2103: lockname => l_lock_name
2104: ,lockhandle => l_lock_handle);
2105: return l_lock_handle;
2106: END get_lock_handle;

Line 2135: print_debug('... in lock_tree... will create a dbms_lock...');

2131: l_lock_handle VARCHAR2(128);
2132: l_status INTEGER;
2133:
2134: BEGIN
2135: print_debug('... in lock_tree... will create a dbms_lock...');
2136: -- Standard call to check for call compatibility
2137: IF NOT fnd_api.compatible_api_call( l_api_version_number
2138: , p_api_version_number
2139: , l_api_name

Line 2159: g_lock_timeout := nvl(to_number(fnd_profile.value('INV_QTY_TREE_TIMEOUT')),dbms_lock.maxwait);

2155: RAISE fnd_api.g_exc_error;
2156: END IF;
2157:
2158: IF g_lock_timeout IS NULL THEN
2159: g_lock_timeout := nvl(to_number(fnd_profile.value('INV_QTY_TREE_TIMEOUT')),dbms_lock.maxwait);
2160: END IF;
2161: --get lock handle by calling helper function
2162: l_lock_handle := get_lock_handle(
2163: p_organization_id => p_organization_id

Line 2167: l_status := dbms_lock.request(

2163: p_organization_id => p_organization_id
2164: , p_inventory_item_id => p_inventory_item_id);
2165:
2166: --request lock
2167: l_status := dbms_lock.request(
2168: lockhandle => l_lock_handle
2169: , lockmode => dbms_lock.x_mode
2170: , timeout => nvl(g_lock_timeout,dbms_lock.maxwait)
2171: , release_on_commit => TRUE);

Line 2169: , lockmode => dbms_lock.x_mode

2165:
2166: --request lock
2167: l_status := dbms_lock.request(
2168: lockhandle => l_lock_handle
2169: , lockmode => dbms_lock.x_mode
2170: , timeout => nvl(g_lock_timeout,dbms_lock.maxwait)
2171: , release_on_commit => TRUE);
2172:
2173: --check for error cases

Line 2170: , timeout => nvl(g_lock_timeout,dbms_lock.maxwait)

2166: --request lock
2167: l_status := dbms_lock.request(
2168: lockhandle => l_lock_handle
2169: , lockmode => dbms_lock.x_mode
2170: , timeout => nvl(g_lock_timeout,dbms_lock.maxwait)
2171: , release_on_commit => TRUE);
2172:
2173: --check for error cases
2174: IF (l_status NOT IN (0,4)) THEN

Line 2270: l_status := dbms_lock.release(l_lock_handle);

2266: p_organization_id => p_organization_id
2267: , p_inventory_item_id => p_inventory_item_id);
2268:
2269:
2270: l_status := dbms_lock.release(l_lock_handle);
2271:
2272: --if success (status = 0) or session does not own lock (status=4), do nothing
2273: --if parameter error or illegal lock handle (internal error)
2274: if l_status IN (3,5) THEN