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

Line 803: if (DBMS_LOCK.REQUEST(C_MENU_LOCK_ID, DBMS_LOCK.S_MODE) = 0) then

799: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
800: c_log_head || l_api_name || '.begin',
801: c_pkg_name || '.' ||l_api_name);
802: end if;
803: if (DBMS_LOCK.REQUEST(C_MENU_LOCK_ID, DBMS_LOCK.S_MODE) = 0) then
804: begin
805: for i in 1..TBL_QUEUED_MENU_ID_MAX loop
806: MARK_MENU_I(TBL_QUEUED_MENU_ID(TBL_QUEUED_MENU_ID_MAX));
807: end loop;

Line 813: RSTATUS := DBMS_LOCK.RELEASE(C_MENU_LOCK_ID);

809: TBL_QUEUED_MENU_ID_MAX := 0;
810: exception when OTHERS then
811: null;
812: end;
813: RSTATUS := DBMS_LOCK.RELEASE(C_MENU_LOCK_ID);
814: end if;
815: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
816: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
817: c_log_head || l_api_name || '.end',

Line 875: if (DBMS_LOCK.REQUEST(C_MENU_LOCK_ID, DBMS_LOCK.S_MODE) = 0) then

871: --
872: procedure MARK_MENU(p_menu_id in number) is
873: RSTATUS number;
874: begin
875: if (DBMS_LOCK.REQUEST(C_MENU_LOCK_ID, DBMS_LOCK.S_MODE) = 0) then
876: begin
877: MARK_MENU_I(p_menu_id);
878: -- Commit;
879: exception when OTHERS then

Line 882: RSTATUS := DBMS_LOCK.RELEASE(C_MENU_LOCK_ID);

878: -- Commit;
879: exception when OTHERS then
880: null;
881: end;
882: RSTATUS := DBMS_LOCK.RELEASE(C_MENU_LOCK_ID);
883: end if;
884: end MARK_MENU;
885:
886:

Line 1812: if (DBMS_LOCK.REQUEST(C_MENU_LOCK_ID, DBMS_LOCK.X_MODE) = 0) then

1808: everything in varchar2 /* 'Y'= from scratch*/) is
1809: pragma autonomous_transaction;
1810: RSTATUS number;
1811: begin
1812: if (DBMS_LOCK.REQUEST(C_MENU_LOCK_ID, DBMS_LOCK.X_MODE) = 0) then
1813: begin
1814: COMPILE_I(errbuf, retcode, everything);
1815: exception when OTHERS then
1816: null;

Line 1818: RSTATUS := DBMS_LOCK.RELEASE(C_MENU_LOCK_ID);

1814: COMPILE_I(errbuf, retcode, everything);
1815: exception when OTHERS then
1816: null;
1817: end;
1818: RSTATUS := DBMS_LOCK.RELEASE(C_MENU_LOCK_ID);
1819: end if;
1820: end;
1821:
1822:

Line 1838: if (DBMS_LOCK.REQUEST(C_MENU_LOCK_ID, DBMS_LOCK.X_MODE) = 0) then

1834: c_log_head || l_api_name || '.begin',
1835: c_pkg_name || '.' ||l_api_name ||';');
1836: end if;
1837:
1838: if (DBMS_LOCK.REQUEST(C_MENU_LOCK_ID, DBMS_LOCK.X_MODE) = 0) then
1839: begin
1840: numrows := COMPILE_ALL_MARKED_I('Y');
1841: exception when OTHERS then
1842: null;

Line 1844: RSTATUS := DBMS_LOCK.RELEASE(C_MENU_LOCK_ID);

1840: numrows := COMPILE_ALL_MARKED_I('Y');
1841: exception when OTHERS then
1842: null;
1843: end;
1844: RSTATUS := DBMS_LOCK.RELEASE(C_MENU_LOCK_ID);
1845: end if;
1846:
1847: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
1848: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

Line 1891: if (DBMS_LOCK.REQUEST(C_MENU_LOCK_ID, DBMS_LOCK.X_MODE) = 0) then

1887: pragma autonomous_transaction;
1888: RESULT_COUNT number;
1889: RSTATUS number;
1890: begin
1891: if (DBMS_LOCK.REQUEST(C_MENU_LOCK_ID, DBMS_LOCK.X_MODE) = 0) then
1892: begin
1893: RESULT_COUNT := COMPILE_ALL_FROM_SCRATCH_I;
1894: exception when OTHERS then
1895: null;

Line 1897: RSTATUS := DBMS_LOCK.RELEASE(C_MENU_LOCK_ID);

1893: RESULT_COUNT := COMPILE_ALL_FROM_SCRATCH_I;
1894: exception when OTHERS then
1895: null;
1896: end;
1897: RSTATUS := DBMS_LOCK.RELEASE(C_MENU_LOCK_ID);
1898: end if;
1899: return RESULT_COUNT;
1900: end;
1901:

Line 2093: if (DBMS_LOCK.REQUEST(C_MENU_LOCK_ID, DBMS_LOCK.X_MODE) = 0) then

2089: pragma autonomous_transaction;
2090: RESULT_COUNT number;
2091: RSTATUS number;
2092: begin
2093: if (DBMS_LOCK.REQUEST(C_MENU_LOCK_ID, DBMS_LOCK.X_MODE) = 0) then
2094: begin
2095: RESULT_COUNT := COMPILE_ALL_MARKED_I(compile_missing);
2096: exception when OTHERS then
2097: null;

Line 2099: RSTATUS := DBMS_LOCK.RELEASE(C_MENU_LOCK_ID);

2095: RESULT_COUNT := COMPILE_ALL_MARKED_I(compile_missing);
2096: exception when OTHERS then
2097: null;
2098: end;
2099: RSTATUS := DBMS_LOCK.RELEASE(C_MENU_LOCK_ID);
2100: end if;
2101: return RESULT_COUNT;
2102: end;
2103:

Line 2146: if (DBMS_LOCK.REQUEST(C_MENU_LOCK_ID, DBMS_LOCK.X_MODE) = 0) then

2142: return;
2143: when OTHERS then
2144: null;
2145: end;
2146: if (DBMS_LOCK.REQUEST(C_MENU_LOCK_ID, DBMS_LOCK.X_MODE) = 0) then
2147: begin
2148: RESULT_COUNT := COMPILE_ALL_MARKED_I('N');
2149: exception when OTHERS then
2150: null;

Line 2152: RSTATUS := DBMS_LOCK.RELEASE(C_MENU_LOCK_ID);

2148: RESULT_COUNT := COMPILE_ALL_MARKED_I('N');
2149: exception when OTHERS then
2150: null;
2151: end;
2152: RSTATUS := DBMS_LOCK.RELEASE(C_MENU_LOCK_ID);
2153: end if;
2154: end if;
2155: end;
2156:

Line 2534: if (DBMS_LOCK.REQUEST(C_MENU_LOCK_ID, DBMS_LOCK.X_MODE) = 0) then

2530: pragma autonomous_transaction;
2531: RESULT_COUNT number;
2532: RSTATUS number;
2533: begin
2534: if (DBMS_LOCK.REQUEST(C_MENU_LOCK_ID, DBMS_LOCK.X_MODE) = 0) then
2535: begin
2536: RESULT_COUNT := COMPILE_MENU_MARKED_I(p_menu_id, p_force);
2537: exception when OTHERS then
2538: null;

Line 2540: RSTATUS := DBMS_LOCK.RELEASE(C_MENU_LOCK_ID);

2536: RESULT_COUNT := COMPILE_MENU_MARKED_I(p_menu_id, p_force);
2537: exception when OTHERS then
2538: null;
2539: end;
2540: RSTATUS := DBMS_LOCK.RELEASE(C_MENU_LOCK_ID);
2541: end if;
2542: return RESULT_COUNT;
2543: end;
2544:

Line 2674: if (DBMS_LOCK.REQUEST(C_MENU_LOCK_ID, DBMS_LOCK.S_MODE) = 0) then

2670: procedure MARK_ALL is
2671: pragma autonomous_transaction;
2672: RSTATUS number;
2673: begin
2674: if (DBMS_LOCK.REQUEST(C_MENU_LOCK_ID, DBMS_LOCK.S_MODE) = 0) then
2675: begin
2676: MARK_ALL_I;
2677: exception when OTHERS then
2678: null;

Line 2680: RSTATUS := DBMS_LOCK.RELEASE(C_MENU_LOCK_ID);

2676: MARK_ALL_I;
2677: exception when OTHERS then
2678: null;
2679: end;
2680: RSTATUS := DBMS_LOCK.RELEASE(C_MENU_LOCK_ID);
2681: end if;
2682: end;
2683:
2684: