DBA Data[Home] [Help]

APPS.HR_API dependencies on DBMS_LOCK

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

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

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

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