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.PA_PROJECT_PVT dependencies on DBMS_LOCK

Line 12441: --dbms_lock.allocate_unique('CONC_PROJECT-'||to_char(p_project_id), v_lockhandle);

12437: v_result number;
12438:
12439: BEGIN
12440:
12441: --dbms_lock.allocate_unique('CONC_PROJECT-'||to_char(p_project_id), v_lockhandle);
12442:
12443: x_return_status:='S';
12444: IF p_lock_mode in ('ADD','UPDATE','PROGRESS') THEN
12445: v_result := dbms_lock.request(id => p_project_id,lockmode => dbms_lock.s_mode, timeout => 1 );

Line 12445: v_result := dbms_lock.request(id => p_project_id,lockmode => dbms_lock.s_mode, timeout => 1 );

12441: --dbms_lock.allocate_unique('CONC_PROJECT-'||to_char(p_project_id), v_lockhandle);
12442:
12443: x_return_status:='S';
12444: IF p_lock_mode in ('ADD','UPDATE','PROGRESS') THEN
12445: v_result := dbms_lock.request(id => p_project_id,lockmode => dbms_lock.s_mode, timeout => 1 );
12446: ELSIF p_lock_mode in ('DELETE','MOVE','INDENT','OUTDENT','ROLLUP','ADD_F') THEN
12447: --v_result := dbms_lock.request(lockhandle=> v_lockhandle,lockmode => dbms_lock.x_mode, timeout => 1 );
12448: v_result := dbms_lock.request(id => p_project_id,lockmode => dbms_lock.x_mode, timeout => 1 );
12449: ELSE

Line 12447: --v_result := dbms_lock.request(lockhandle=> v_lockhandle,lockmode => dbms_lock.x_mode, timeout => 1 );

12443: x_return_status:='S';
12444: IF p_lock_mode in ('ADD','UPDATE','PROGRESS') THEN
12445: v_result := dbms_lock.request(id => p_project_id,lockmode => dbms_lock.s_mode, timeout => 1 );
12446: ELSIF p_lock_mode in ('DELETE','MOVE','INDENT','OUTDENT','ROLLUP','ADD_F') THEN
12447: --v_result := dbms_lock.request(lockhandle=> v_lockhandle,lockmode => dbms_lock.x_mode, timeout => 1 );
12448: v_result := dbms_lock.request(id => p_project_id,lockmode => dbms_lock.x_mode, timeout => 1 );
12449: ELSE
12450: x_msg_data:='PA_INVALID_LOCK_MODE';
12451: x_return_status:='E';

Line 12448: v_result := dbms_lock.request(id => p_project_id,lockmode => dbms_lock.x_mode, timeout => 1 );

12444: IF p_lock_mode in ('ADD','UPDATE','PROGRESS') THEN
12445: v_result := dbms_lock.request(id => p_project_id,lockmode => dbms_lock.s_mode, timeout => 1 );
12446: ELSIF p_lock_mode in ('DELETE','MOVE','INDENT','OUTDENT','ROLLUP','ADD_F') THEN
12447: --v_result := dbms_lock.request(lockhandle=> v_lockhandle,lockmode => dbms_lock.x_mode, timeout => 1 );
12448: v_result := dbms_lock.request(id => p_project_id,lockmode => dbms_lock.x_mode, timeout => 1 );
12449: ELSE
12450: x_msg_data:='PA_INVALID_LOCK_MODE';
12451: x_return_status:='E';
12452: return;

Line 12475: --dbms_lock.allocate_unique('CONC_PROJECT-'||to_char(p_project_id), v_lockhandle);

12471: v_lockhandle varchar2(200);
12472: v_result number;
12473: begin
12474:
12475: --dbms_lock.allocate_unique('CONC_PROJECT-'||to_char(p_project_id), v_lockhandle);
12476: --v_result := dbms_lock.release(v_lockhandle);
12477: v_result := dbms_lock.release(id=> p_project_id);
12478:
12479: END CONC_RELEASE_LOCK_PROJECT;

Line 12476: --v_result := dbms_lock.release(v_lockhandle);

12472: v_result number;
12473: begin
12474:
12475: --dbms_lock.allocate_unique('CONC_PROJECT-'||to_char(p_project_id), v_lockhandle);
12476: --v_result := dbms_lock.release(v_lockhandle);
12477: v_result := dbms_lock.release(id=> p_project_id);
12478:
12479: END CONC_RELEASE_LOCK_PROJECT;
12480:

Line 12477: v_result := dbms_lock.release(id=> p_project_id);

12473: begin
12474:
12475: --dbms_lock.allocate_unique('CONC_PROJECT-'||to_char(p_project_id), v_lockhandle);
12476: --v_result := dbms_lock.release(v_lockhandle);
12477: v_result := dbms_lock.release(id=> p_project_id);
12478:
12479: END CONC_RELEASE_LOCK_PROJECT;
12480:
12481: