eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_NONRUN_ASACT dependencies on DBMS_LOCK

Line 95: p_lckhandle in varchar2, -- dbms_lock id

91: procedure get_next_pop_chunk_seq
92: (
93: pactid in number, -- payroll_action_id.
94: atype in varchar2, -- action type.
95: p_lckhandle in varchar2, -- dbms_lock id
96: lub in varchar2, -- last_updated_by.
97: lul in varchar2, -- last_update_login.
98: stperson out nocopy number, -- starting_person_id.
99: endperson out nocopy number, -- ending_person_id.

Line 117: ret := dbms_lock.request(

113:
114: /* First thing to do is get a lock before entering the
115: critical section
116: */
117: ret := dbms_lock.request(
118: lockhandle => p_lckhandle,
119: lockmode => dbms_lock.x_mode,
120: release_on_commit => TRUE);
121: --

Line 119: lockmode => dbms_lock.x_mode,

115: critical section
116: */
117: ret := dbms_lock.request(
118: lockhandle => p_lckhandle,
119: lockmode => dbms_lock.x_mode,
120: release_on_commit => TRUE);
121: --
122: if (ret <> 0) then
123: hr_utility.set_message(801,'HR_289135_NO_LOCK_GAINED');

Line 196: /* Release dbms_lock */

192: commit;
193: chunk := NULL;
194: else
195: chunk := NULL;
196: /* Release dbms_lock */
197: commit;
198: end if;
199: end if;
200: else

Line 214: /* Release dbms_lock */

210:
211: else
212: chunk := NULL; -- nothing left to process.
213: found := TRUE;
214: /* Release dbms_lock */
215: commit;
216: end if;
217: end if;
218: end loop;

Line 249: dbms_lock.allocate_unique(

245: /* OK we have the next chunk lets lock it and confirm that its
246: unprocessed
247: */
248: --
249: dbms_lock.allocate_unique(
250: lockname => 'PAY_CHUNK_STATUS'||pactid||'_'||p_next_chunk,
251: lockhandle => l_lckhandle);
252: --
253: ret := dbms_lock.request(

Line 253: ret := dbms_lock.request(

249: dbms_lock.allocate_unique(
250: lockname => 'PAY_CHUNK_STATUS'||pactid||'_'||p_next_chunk,
251: lockhandle => l_lckhandle);
252: --
253: ret := dbms_lock.request(
254: lockhandle => l_lckhandle,
255: lockmode => dbms_lock.x_mode,
256: release_on_commit => TRUE);
257: if (ret <> 0) then

Line 255: lockmode => dbms_lock.x_mode,

251: lockhandle => l_lckhandle);
252: --
253: ret := dbms_lock.request(
254: lockhandle => l_lckhandle,
255: lockmode => dbms_lock.x_mode,
256: release_on_commit => TRUE);
257: if (ret <> 0) then
258: hr_utility.set_message(801,'HR_289135_NO_LOCK_GAINED');
259: hr_utility.set_message_token('LOCKNAME',

Line 316: /* Release dbms_lock */

312: --
313: /* Another thread must have processed the chunk */
314: --
315: chunk := NULL;
316: /* Release dbms_lock */
317: commit;
318: end if;
319: --
320: else

Line 333: /* Release dbms_lock */

329:
330: else
331: chunk := NULL; -- nothing left to process.
332: p_found := TRUE;
333: /* Release dbms_lock */
334: commit;
335: end if;
336: end if;
337: end lock_pop_chunk;

Line 353: p_lckhandle in varchar2, -- dbms_lock id for pactid

349: procedure get_next_pop_chunk_unalloc
350: (
351: pactid in number, -- payroll_action_id.
352: atype in varchar2, -- action type.
353: p_lckhandle in varchar2, -- dbms_lock id for pactid
354: lub in varchar2, -- last_updated_by.
355: lul in varchar2, -- last_update_login.
356: stperson out nocopy number, -- starting_person_id.
357: endperson out nocopy number, -- ending_person_id.

Line 388: ret := dbms_lock.request(

384: --
385: /* First thing to do is get a lock before entering the
386: critical section
387: */
388: ret := dbms_lock.request(
389: lockhandle => p_lckhandle,
390: lockmode => dbms_lock.x_mode,
391: release_on_commit => TRUE);
392: --

Line 390: lockmode => dbms_lock.x_mode,

386: critical section
387: */
388: ret := dbms_lock.request(
389: lockhandle => p_lckhandle,
390: lockmode => dbms_lock.x_mode,
391: release_on_commit => TRUE);
392: --
393: if (ret <> 0) then
394: hr_utility.set_message(801,'HR_289135_NO_LOCK_GAINED');

Line 442: /* Release dbms_lock */

438: commit;
439: chunk := NULL;
440: else
441: chunk := NULL;
442: /* Release dbms_lock */
443: commit;
444: end if;
445: --
446: else

Line 459: /* Release dbms_lock */

455:
456: else
457: chunk := NULL; -- nothing left to process.
458: found := TRUE;
459: /* Release dbms_lock */
460: commit;
461: end if;
462: end if;
463: --

Line 496: p_lckhandle in varchar2, -- dbms_lock id for pact

492: procedure get_next_pop_chunk_prealloc
493: (
494: pactid in number, -- payroll_action_id.
495: atype in varchar2, -- action type.
496: p_lckhandle in varchar2, -- dbms_lock id for pact
497: lub in varchar2, -- last_updated_by.
498: lul in varchar2, -- last_update_login.
499: chunk_type in out nocopy varchar2, -- method for allocating chunk
500: threads in number default 1, -- Number of Threads

Line 602: p_lckhandle in varchar2, -- dbms_lock id

598: procedure get_next_pop_chunk
599: (
600: pactid in number, -- payroll_action_id.
601: atype in varchar2, -- action type.
602: p_lckhandle in varchar2, -- dbms_lock id
603: lub in varchar2, -- last_updated_by.
604: lul in varchar2, -- last_update_login.
605: chunk_type in out nocopy varchar2, -- method for allocating chunk
606: threads in number default 1, -- Number of Threads

Line 5142: dbms_lock.allocate_unique(

5138: g_many_procs_in_period <> 'N') then
5139: g_many_procs_in_period := 'Y';
5140: end if;
5141: --
5142: dbms_lock.allocate_unique(
5143: lockname => 'PAY_PAYROLL_ACTIONS_'||pactid,
5144: lockhandle => g_lckhandle);
5145: --
5146: loop