DBA Data[Home] [Help]

APPS.HR_API dependencies on DBMS_LOCK

Line 1196: -- Request a RDBMS lock which will be released on commit or rollback.

1192: function return_commit_unit return number is
1193: l_lock_status number;
1194: begin
1195: --
1196: -- Request a RDBMS lock which will be released on commit or rollback.
1197: --
1198: l_lock_status := dbms_lock.request(2147483647, dbms_lock.nl_mode, 0, TRUE);
1199: if l_lock_status = 0 then
1200: --

Line 1198: l_lock_status := dbms_lock.request(2147483647, dbms_lock.nl_mode, 0, TRUE);

1194: begin
1195: --
1196: -- Request a RDBMS lock which will be released on commit or rollback.
1197: --
1198: l_lock_status := dbms_lock.request(2147483647, dbms_lock.nl_mode, 0, TRUE);
1199: if l_lock_status = 0 then
1200: --
1201: -- The lock has just been obtained. As far as this function is concerned
1202: -- it is the start of the commit unit. Increment the commit unit number.