APPS.INL_INTERFACE_PVT dependencies on DBMS_LOCK

Line 14565: DBMS_LOCK.Allocate_Unique(

14561: p_procedure_name => l_program_name,
14562: p_debug_info => 'Acquiring lock (Allocate_Unique) on: ' || l_lock_name
14563: );
14564:
14565: DBMS_LOCK.Allocate_Unique(
14566: lockname => l_lock_name,
14567: lockhandle => l_lock_handle
14568: );
14569:

Line 14576: l_lock_status := DBMS_LOCK.Request(

14572: p_procedure_name => l_program_name,
14573: p_debug_info => 'Acquiring lock (Request)'
14574: );
14575:
14576: l_lock_status := DBMS_LOCK.Request(
14577: lockhandle => l_lock_handle,
14578: lockmode => DBMS_LOCK.x_mode
14579: );
14580:

Line 14578: lockmode => DBMS_LOCK.x_mode

14574: );
14575:
14576: l_lock_status := DBMS_LOCK.Request(
14577: lockhandle => l_lock_handle,
14578: lockmode => DBMS_LOCK.x_mode
14579: );
14580:
14581: IF l_lock_status <> 0 THEN
14582: INL_LOGGING_PVT.Log_Statement (

Line 14722: l_lock_status := DBMS_LOCK.RELEASE(l_lock_handle);

14718: COMMIT WORK;
14719: END IF;
14720:
14721: -- Release the lock
14722: l_lock_status := DBMS_LOCK.RELEASE(l_lock_handle);
14723: l_lock_handle := NULL;
14724:
14725: RETURN l_return_value;
14726:

Line 14736: l_lock_status := DBMS_LOCK.Release(l_lock_handle);

14732: p_procedure_name => l_program_name
14733: );
14734: x_return_status := L_FND_RET_STS_ERROR;
14735: IF l_lock_handle IS NOT NULL THEN
14736: l_lock_status := DBMS_LOCK.Release(l_lock_handle);
14737: END IF;
14738: RETURN 0;
14739: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
14740: -- Standard Unexpected Error Logging

Line 14747: l_lock_status := DBMS_LOCK.Release(l_lock_handle);

14743: p_procedure_name => l_program_name
14744: );
14745: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
14746: IF l_lock_handle IS NOT NULL THEN
14747: l_lock_status := DBMS_LOCK.Release(l_lock_handle);
14748: END IF;
14749: RETURN 0;
14750: WHEN OTHERS THEN
14751: -- Standard Unexpected Error Logging

Line 14766: l_lock_status := DBMS_LOCK.Release(l_lock_handle);

14762: );
14763: END IF;
14764: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
14765: IF l_lock_handle IS NOT NULL THEN
14766: l_lock_status := DBMS_LOCK.Release(l_lock_handle);
14767: END IF;
14768: RETURN 0;
14769: END Select_MatchesToProc;
14770:

Line 16090: DBMS_LOCK.Allocate_Unique(

16086: p_procedure_name => l_program_name,
16087: p_debug_info => 'Acquiring lock (Allocate_Unique) on: ' || l_lock_name
16088: );
16089:
16090: DBMS_LOCK.Allocate_Unique(
16091: lockname => l_lock_name,
16092: lockhandle => l_lock_handle
16093: );
16094:

Line 16101: l_lock_status := DBMS_LOCK.Request(

16097: p_procedure_name => l_program_name,
16098: p_debug_info => 'Acquiring lock (Request)'
16099: );
16100:
16101: l_lock_status := DBMS_LOCK.Request(
16102: lockhandle => l_lock_handle,
16103: lockmode => DBMS_LOCK.x_mode
16104: );
16105:

Line 16103: lockmode => DBMS_LOCK.x_mode

16099: );
16100:
16101: l_lock_status := DBMS_LOCK.Request(
16102: lockhandle => l_lock_handle,
16103: lockmode => DBMS_LOCK.x_mode
16104: );
16105:
16106: IF l_lock_status <> 0 THEN
16107: INL_LOGGING_PVT.Log_Statement (

Line 16130: l_lock_status := DBMS_LOCK.RELEASE(l_lock_handle);

16126: p_procedure_name => l_program_name,
16127: p_debug_info => l_return_value||' selected records');
16128:
16129: -- Release the lock
16130: l_lock_status := DBMS_LOCK.RELEASE(l_lock_handle);
16131: l_lock_handle := NULL;
16132:
16133: RETURN l_return_value;
16134:

Line 16144: l_lock_status := DBMS_LOCK.Release(l_lock_handle);

16140: p_procedure_name => l_program_name
16141: );
16142: x_return_status := L_FND_RET_STS_ERROR;
16143: IF l_lock_handle IS NOT NULL THEN
16144: l_lock_status := DBMS_LOCK.Release(l_lock_handle);
16145: END IF;
16146: RETURN 0;
16147: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
16148: -- Standard Unexpected Error Logging

Line 16155: l_lock_status := DBMS_LOCK.Release(l_lock_handle);

16151: p_procedure_name => l_program_name
16152: );
16153: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
16154: IF l_lock_handle IS NOT NULL THEN
16155: l_lock_status := DBMS_LOCK.Release(l_lock_handle);
16156: END IF;
16157: RETURN 0;
16158: WHEN OTHERS THEN
16159: -- Standard Unexpected Error Logging

Line 16174: l_lock_status := DBMS_LOCK.Release(l_lock_handle);

16170: );
16171: END IF;
16172: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
16173: IF l_lock_handle IS NOT NULL THEN
16174: l_lock_status := DBMS_LOCK.Release(l_lock_handle);
16175: END IF;
16176: RETURN 0;
16177: END Select_LCMShipToProc;
16178: