APPS.INV_QUANTITY_TREE_PVT dependencies on DBMS_LOCK

Line 1847: dbms_lock.allocate_unique(

1843: l_lock_name VARCHAR2(30);
1844: BEGIN
1845:
1846: l_lock_name := 'INV_QT_' || p_organization_id || '_' || p_inventory_item_id;
1847: dbms_lock.allocate_unique(
1848: lockname => l_lock_name
1849: , lockhandle => l_lock_handle);
1850: return l_lock_handle;
1851: END get_lock_handle;

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

1876: l_lock_handle VARCHAR2(128);
1877: l_status INTEGER;
1878:
1879: BEGIN
1880: print_debug('... in lock_tree... will create a dbms_lock...');
1881: -- Standard call to check for call compatibility
1882: IF NOT fnd_api.compatible_api_call( l_api_version_number
1883: , p_api_version_number
1884: , l_api_name

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

1900: RAISE fnd_api.g_exc_error;
1901: END IF;
1902:
1903: IF g_lock_timeout IS NULL THEN
1904: g_lock_timeout := nvl(to_number(fnd_profile.value('INV_QTY_TREE_TIMEOUT')),dbms_lock.maxwait);
1905: END IF;
1906: --get lock handle by calling helper function
1907: l_lock_handle := get_lock_handle(
1908: p_organization_id => p_organization_id

Line 1912: l_status := dbms_lock.request(

1908: p_organization_id => p_organization_id
1909: , p_inventory_item_id => p_inventory_item_id);
1910:
1911: --request lock
1912: l_status := dbms_lock.request(
1913: lockhandle => l_lock_handle
1914: , lockmode => dbms_lock.x_mode
1915: , timeout => nvl(g_lock_timeout,dbms_lock.maxwait)
1916: , release_on_commit => TRUE);

Line 1914: , lockmode => dbms_lock.x_mode

1910:
1911: --request lock
1912: l_status := dbms_lock.request(
1913: lockhandle => l_lock_handle
1914: , lockmode => dbms_lock.x_mode
1915: , timeout => nvl(g_lock_timeout,dbms_lock.maxwait)
1916: , release_on_commit => TRUE);
1917:
1918: --check for error cases

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

1911: --request lock
1912: l_status := dbms_lock.request(
1913: lockhandle => l_lock_handle
1914: , lockmode => dbms_lock.x_mode
1915: , timeout => nvl(g_lock_timeout,dbms_lock.maxwait)
1916: , release_on_commit => TRUE);
1917:
1918: --check for error cases
1919: IF (l_status NOT IN (0,4)) THEN

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

2011: p_organization_id => p_organization_id
2012: , p_inventory_item_id => p_inventory_item_id);
2013:
2014:
2015: l_status := dbms_lock.release(l_lock_handle);
2016:
2017: --if success (status = 0) or session does not own lock (status=4), do nothing
2018: --if parameter error or illegal lock handle (internal error)
2019: if l_status IN (3,5) THEN