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.BIS_RL_PKG dependencies on FND_FORM_FUNCTIONS

Line 170: from fnd_form_functions_vl a,

166: b.function_id,
167: b.entry_sequence,
168: a.type,
169: a.web_html_call
170: from fnd_form_functions_vl a,
171: fnd_menu_entries_vl b
172: where b.menu_id = p_object.parent_menu_id
173: and a.function_id = b.function_id
174: --jprabhud - 03/04/03 - Refresh Portal Page - Remove the filter based on the type

Line 191: from fnd_form_functions_vl a,

187: b.function_id,
188: b.entry_sequence,
189: a.type,
190: a.web_html_call
191: from fnd_form_functions_vl a,
192: fnd_menu_entries_vl b
193: where b.menu_id = p_object.parent_menu_id
194: and a.function_id = b.function_id
195: and a.type in ('WEBPORTLET')

Line 279: from fnd_form_functions a,

275: then
276:
277: select count(*)
278: into l_count
279: from fnd_form_functions a,
280: fnd_menu_entries b
281: where b.menu_id = p_object.parent_menu_id
282: and a.function_id = b.function_id
283: --jprabhud - 03/04/03 - Refresh Portal Page - Remove the filter based on the type

Line 294: from fnd_form_functions_vl a,

290:
291: --ansingh -Preseed Related Links Enhancement -Start
292: select count(*)
293: into l_rl_portlet_count
294: from fnd_form_functions_vl a,
295: fnd_menu_entries_vl b
296: where b.menu_id = p_object.parent_menu_id
297: and a.function_id = b.function_id
298: and a.type in ('WEBPORTLET')

Line 925: from fnd_form_functions

921:
922: BEGIN
923:
924: select function_id into l_function_id
925: from fnd_form_functions
926: where function_name = pFunction_name;
927:
928: copyLinksFromPrevLevel (
929: l_function_id,

Line 959: l_param fnd_form_functions.parameters%TYPE;

955: FUNCTION getFuncIdFromParams (
956: pFunctionId IN VARCHAR2
957:
958: ) RETURN VARCHAR2 IS
959: l_param fnd_form_functions.parameters%TYPE;
960: l_func_id fnd_form_functions.function_id%TYPE;
961: l_retr_func VARCHAR2(32000);
962:
963: BEGIN

Line 960: l_func_id fnd_form_functions.function_id%TYPE;

956: pFunctionId IN VARCHAR2
957:
958: ) RETURN VARCHAR2 IS
959: l_param fnd_form_functions.parameters%TYPE;
960: l_func_id fnd_form_functions.function_id%TYPE;
961: l_retr_func VARCHAR2(32000);
962:
963: BEGIN
964:

Line 968: FROM fnd_form_functions

964:
965: l_func_id := NULL;
966:
967: SELECT parameters INTO l_param
968: FROM fnd_form_functions
969: WHERE function_id = pFunctionId;
970:
971: IF(l_param IS NOT NULL) THEN
972: l_retr_func := BIS_PMV_UTIL.getParameterValue(l_param, 'pFunctionName');

Line 978: FROM fnd_form_functions

974:
975: IF (l_retr_func IS NOT NULL) THEN
976:
977: SELECT function_id INTO l_func_id
978: FROM fnd_form_functions
979: WHERE function_name = l_retr_func;
980:
981: END IF;
982:

Line 2311: FND_MENU_ENTRIES_VL mev, FND_FORM_FUNCTIONS_VL fff

2307: nvl(fff.description, nvl(mev.description, mev.prompt)) AS Description,
2308: ''N'' as DummySelect,
2309: NULL as ReportUrl
2310: FROM
2311: FND_MENU_ENTRIES_VL mev, FND_FORM_FUNCTIONS_VL fff
2312: WHERE
2313: mev.function_id=fff.function_id
2314: AND mev.function_id in (';
2315: --function criteria

Line 2359: FND_MENU_ENTRIES_VL mev, FND_FORM_FUNCTIONS_VL fff

2355: nvl(fff.description, nvl(mev.description, mev.prompt)) as Description,
2356: ''N'' as DummySelect,
2357: NULL as ReportUrl
2358: FROM
2359: FND_MENU_ENTRIES_VL mev, FND_FORM_FUNCTIONS_VL fff
2360: where
2361: mev.function_id=fff.function_id
2362: AND mev.function_id in (';
2363:

Line 2518: from FND_MENU_ENTRIES_VL mev, FND_FORM_FUNCTIONS_VL fff

2514: fff.user_function_name AS Prompt,
2515: nvl(fff.description, nvl(mev.description, mev.prompt)) as Description,
2516: ''N'' as DummySelect,
2517: null as ReportUrl
2518: from FND_MENU_ENTRIES_VL mev, FND_FORM_FUNCTIONS_VL fff
2519: where mev.function_id=fff.function_id
2520: AND mev.function_id in (';
2521: l_function_bindstring := '';
2522: for i in 1..l_function_count loop

Line 2574: from FND_MENU_ENTRIES_VL mev, FND_FORM_FUNCTIONS_VL fff

2570: fff.user_function_name AS Prompt,
2571: nvl(fff.description, nvl(mev.description, mev.prompt)) as Description,
2572: ''N'' as DummySelect,
2573: null as ReportUrl
2574: from FND_MENU_ENTRIES_VL mev, FND_FORM_FUNCTIONS_VL fff
2575: where mev.function_id=fff.function_id
2576: and mev.function_id in (';
2577: l_function_bindstring := '';
2578: for i in 1..l_function_count loop

Line 2726: FROM FND_MENU_ENTRIES_VL mev, FND_FORM_FUNCTIONS_VL fff

2722: NVL(mev.prompt, fff.function_name) AS Prompt,
2723: nvl(fff.description, nvl(mev.description, mev.prompt)) AS Description,
2724: ''N'' AS DummySelect,
2725: NULL AS ReportUrl
2726: FROM FND_MENU_ENTRIES_VL mev, FND_FORM_FUNCTIONS_VL fff
2727: WHERE mev.function_id IN (';
2728: l_function_bindstring := '';
2729: for i in 1..l_function_count loop
2730: if (i <> 1) then

Line 2779: FROM FND_MENU_ENTRIES_VL mev, FND_FORM_FUNCTIONS_VL fff

2775: NVL(mev.prompt, fff.function_name) AS Prompt,
2776: nvl(fff.description, nvl(mev.description, mev.prompt)) AS Description,
2777: ''N'' AS DummySelect,
2778: NULL AS ReportUrl
2779: FROM FND_MENU_ENTRIES_VL mev, FND_FORM_FUNCTIONS_VL fff
2780: WHERE mev.function_id IN (';
2781: l_function_bindstring := '';
2782: for i in 1..l_function_count loop
2783: if (i <> 1) then

Line 2925: from FND_MENU_ENTRIES_VL mev, FND_FORM_FUNCTIONS_VL fff

2921: fff.user_function_name AS Prompt,
2922: nvl(fff.description, nvl(mev.description, mev.prompt)) as Description,
2923: ''N'' as DummySelect,
2924: null as ReportUrl
2925: from FND_MENU_ENTRIES_VL mev, FND_FORM_FUNCTIONS_VL fff
2926: where mev.function_id=fff.function_id
2927: and mev.function_id in (';
2928: l_function_bindstring := '';
2929: for i in 1..l_function_count loop

Line 2980: from FND_MENU_ENTRIES_VL mev, FND_FORM_FUNCTIONS_VL fff

2976: fff.user_function_name AS Prompt,
2977: nvl(fff.description, nvl(mev.description, mev.prompt)) as Description,
2978: ''N'' as DummySelect,
2979: null as ReportUrl
2980: from FND_MENU_ENTRIES_VL mev, FND_FORM_FUNCTIONS_VL fff
2981: where mev.function_id=fff.function_id
2982: and mev.function_id in (';
2983: l_function_bindstring := '';
2984: for i in 1..l_function_count loop