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_UTIL_MISC_WEB dependencies on FND_FORM_FUNCTIONS

Line 2129: l_fnd_form_function fnd_form_functions%ROWTYPE;

2125: | needs to be modified accordingly.
2126: +-----------------------------------------------------------------------------*/
2127: FUNCTION get_called_from RETURN VARCHAR2 IS
2128:
2129: l_fnd_form_function fnd_form_functions%ROWTYPE;
2130: l_function_id fnd_Form_functions.function_id%TYPE;
2131: l_called_from fnd_Form_functions.parameters%TYPE;
2132: l_proc constant varchar2(100) := g_package || ' get_called_from';
2133: CURSOR csr_icx_session(p_session_id IN NUMBER) IS

Line 2130: l_function_id fnd_Form_functions.function_id%TYPE;

2126: +-----------------------------------------------------------------------------*/
2127: FUNCTION get_called_from RETURN VARCHAR2 IS
2128:
2129: l_fnd_form_function fnd_form_functions%ROWTYPE;
2130: l_function_id fnd_Form_functions.function_id%TYPE;
2131: l_called_from fnd_Form_functions.parameters%TYPE;
2132: l_proc constant varchar2(100) := g_package || ' get_called_from';
2133: CURSOR csr_icx_session(p_session_id IN NUMBER) IS
2134: SELECT a.function_id

Line 2131: l_called_from fnd_Form_functions.parameters%TYPE;

2127: FUNCTION get_called_from RETURN VARCHAR2 IS
2128:
2129: l_fnd_form_function fnd_form_functions%ROWTYPE;
2130: l_function_id fnd_Form_functions.function_id%TYPE;
2131: l_called_from fnd_Form_functions.parameters%TYPE;
2132: l_proc constant varchar2(100) := g_package || ' get_called_from';
2133: CURSOR csr_icx_session(p_session_id IN NUMBER) IS
2134: SELECT a.function_id
2135: FROM icx_sessions a

Line 2170: RETURN fnd_form_functions%ROWTYPE IS

2166: | This function will return all the information needed for any
2167: | fnd_form_function row.
2168: +-----------------------------------------------------------------------------*/
2169: FUNCTION get_fnd_form_function(p_function_id IN NUMBER)
2170: RETURN fnd_form_functions%ROWTYPE IS
2171: CURSOR csr_fnd_form_functions IS
2172: SELECT *
2173: FROM fnd_form_functions
2174: WHERE function_id = p_function_id;

Line 2171: CURSOR csr_fnd_form_functions IS

2167: | fnd_form_function row.
2168: +-----------------------------------------------------------------------------*/
2169: FUNCTION get_fnd_form_function(p_function_id IN NUMBER)
2170: RETURN fnd_form_functions%ROWTYPE IS
2171: CURSOR csr_fnd_form_functions IS
2172: SELECT *
2173: FROM fnd_form_functions
2174: WHERE function_id = p_function_id;
2175: l_function fnd_form_functions%ROWTYPE;

Line 2173: FROM fnd_form_functions

2169: FUNCTION get_fnd_form_function(p_function_id IN NUMBER)
2170: RETURN fnd_form_functions%ROWTYPE IS
2171: CURSOR csr_fnd_form_functions IS
2172: SELECT *
2173: FROM fnd_form_functions
2174: WHERE function_id = p_function_id;
2175: l_function fnd_form_functions%ROWTYPE;
2176: l_proc constant varchar2(100) := g_package || ' get_fnd_form_function';
2177: BEGIN

Line 2175: l_function fnd_form_functions%ROWTYPE;

2171: CURSOR csr_fnd_form_functions IS
2172: SELECT *
2173: FROM fnd_form_functions
2174: WHERE function_id = p_function_id;
2175: l_function fnd_form_functions%ROWTYPE;
2176: l_proc constant varchar2(100) := g_package || ' get_fnd_form_function';
2177: BEGIN
2178: hr_utility.set_location('Entering: '|| l_proc,5);
2179: OPEN csr_fnd_form_functions;

Line 2179: OPEN csr_fnd_form_functions;

2175: l_function fnd_form_functions%ROWTYPE;
2176: l_proc constant varchar2(100) := g_package || ' get_fnd_form_function';
2177: BEGIN
2178: hr_utility.set_location('Entering: '|| l_proc,5);
2179: OPEN csr_fnd_form_functions;
2180: hr_utility.trace('Going into Fetch after (OPEN csr_fnd_form_functions ): '|| l_proc);
2181: FETCH csr_fnd_form_functions INTO l_function;
2182: CLOSE csr_fnd_form_functions;
2183: hr_utility.set_location('Leaving: '|| l_proc,15);

Line 2180: hr_utility.trace('Going into Fetch after (OPEN csr_fnd_form_functions ): '|| l_proc);

2176: l_proc constant varchar2(100) := g_package || ' get_fnd_form_function';
2177: BEGIN
2178: hr_utility.set_location('Entering: '|| l_proc,5);
2179: OPEN csr_fnd_form_functions;
2180: hr_utility.trace('Going into Fetch after (OPEN csr_fnd_form_functions ): '|| l_proc);
2181: FETCH csr_fnd_form_functions INTO l_function;
2182: CLOSE csr_fnd_form_functions;
2183: hr_utility.set_location('Leaving: '|| l_proc,15);
2184: RETURN l_function;

Line 2181: FETCH csr_fnd_form_functions INTO l_function;

2177: BEGIN
2178: hr_utility.set_location('Entering: '|| l_proc,5);
2179: OPEN csr_fnd_form_functions;
2180: hr_utility.trace('Going into Fetch after (OPEN csr_fnd_form_functions ): '|| l_proc);
2181: FETCH csr_fnd_form_functions INTO l_function;
2182: CLOSE csr_fnd_form_functions;
2183: hr_utility.set_location('Leaving: '|| l_proc,15);
2184: RETURN l_function;
2185: EXCEPTION

Line 2182: CLOSE csr_fnd_form_functions;

2178: hr_utility.set_location('Entering: '|| l_proc,5);
2179: OPEN csr_fnd_form_functions;
2180: hr_utility.trace('Going into Fetch after (OPEN csr_fnd_form_functions ): '|| l_proc);
2181: FETCH csr_fnd_form_functions INTO l_function;
2182: CLOSE csr_fnd_form_functions;
2183: hr_utility.set_location('Leaving: '|| l_proc,15);
2184: RETURN l_function;
2185: EXCEPTION
2186: WHEN OTHERS THEN

Line 2207: l_fnd_form_function fnd_form_functions%ROWTYPE;

2203: | i.e P_PROCESS_NAMEis followed by &P_ITEM_TYPE
2204: +-----------------------------------------------------------------------------*/
2205: FUNCTION get_process_name RETURN VARCHAR2 IS
2206:
2207: l_fnd_form_function fnd_form_functions%ROWTYPE;
2208: l_function_id fnd_Form_functions.function_id%TYPE;
2209: l_called_from fnd_Form_functions.parameters%TYPE;
2210: l_proc constant varchar2(100) := g_package || ' get_process_name ';
2211: CURSOR csr_icx_session(p_session_id IN NUMBER) IS

Line 2208: l_function_id fnd_Form_functions.function_id%TYPE;

2204: +-----------------------------------------------------------------------------*/
2205: FUNCTION get_process_name RETURN VARCHAR2 IS
2206:
2207: l_fnd_form_function fnd_form_functions%ROWTYPE;
2208: l_function_id fnd_Form_functions.function_id%TYPE;
2209: l_called_from fnd_Form_functions.parameters%TYPE;
2210: l_proc constant varchar2(100) := g_package || ' get_process_name ';
2211: CURSOR csr_icx_session(p_session_id IN NUMBER) IS
2212: SELECT a.function_id

Line 2209: l_called_from fnd_Form_functions.parameters%TYPE;

2205: FUNCTION get_process_name RETURN VARCHAR2 IS
2206:
2207: l_fnd_form_function fnd_form_functions%ROWTYPE;
2208: l_function_id fnd_Form_functions.function_id%TYPE;
2209: l_called_from fnd_Form_functions.parameters%TYPE;
2210: l_proc constant varchar2(100) := g_package || ' get_process_name ';
2211: CURSOR csr_icx_session(p_session_id IN NUMBER) IS
2212: SELECT a.function_id
2213: FROM icx_sessions a

Line 2254: l_fnd_form_function fnd_form_functions%ROWTYPE;

2250: | This function is used to get the item_type from FND form Function
2251: +-----------------------------------------------------------------------------*/
2252: FUNCTION get_item_type RETURN VARCHAR2 is
2253:
2254: l_fnd_form_function fnd_form_functions%ROWTYPE;
2255: l_function_id fnd_Form_functions.function_id%TYPE;
2256: l_called_from fnd_Form_functions.parameters%TYPE;
2257: l_number integer;
2258: l_proc constant varchar2(100) := g_package || ' get_item_type';

Line 2255: l_function_id fnd_Form_functions.function_id%TYPE;

2251: +-----------------------------------------------------------------------------*/
2252: FUNCTION get_item_type RETURN VARCHAR2 is
2253:
2254: l_fnd_form_function fnd_form_functions%ROWTYPE;
2255: l_function_id fnd_Form_functions.function_id%TYPE;
2256: l_called_from fnd_Form_functions.parameters%TYPE;
2257: l_number integer;
2258: l_proc constant varchar2(100) := g_package || ' get_item_type';
2259: CURSOR csr_icx_session(p_session_id IN NUMBER) IS

Line 2256: l_called_from fnd_Form_functions.parameters%TYPE;

2252: FUNCTION get_item_type RETURN VARCHAR2 is
2253:
2254: l_fnd_form_function fnd_form_functions%ROWTYPE;
2255: l_function_id fnd_Form_functions.function_id%TYPE;
2256: l_called_from fnd_Form_functions.parameters%TYPE;
2257: l_number integer;
2258: l_proc constant varchar2(100) := g_package || ' get_item_type';
2259: CURSOR csr_icx_session(p_session_id IN NUMBER) IS
2260: SELECT a.function_id