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

Line 218: l_function_name fnd_form_functions_vl.user_function_name%TYPE;

214: l_function_id pls_integer;
215: l_img_html varchar2(32000);
216: l_plsql_agent_URL varchar2(32000);
217: l_Graph_URL varchar2(32000);
218: l_function_name fnd_form_functions_vl.user_function_name%TYPE;
219: l_function_description fnd_form_functions_vl.description%TYPE;
220: l_Report_Run_str varchar2(32000);
221:
222: l_application_id pls_integer;

Line 219: l_function_description fnd_form_functions_vl.description%TYPE;

215: l_img_html varchar2(32000);
216: l_plsql_agent_URL varchar2(32000);
217: l_Graph_URL varchar2(32000);
218: l_function_name fnd_form_functions_vl.user_function_name%TYPE;
219: l_function_description fnd_form_functions_vl.description%TYPE;
220: l_Report_Run_str varchar2(32000);
221:
222: l_application_id pls_integer;
223:

Line 256: -- 1) Use fnd_form_functions in join instead of fnd_form_functions_vl

252:
253: begin
254:
255: -- mdamle 08/08/01 - Fix Bug#1910032 - Improve Performance
256: -- 1) Use fnd_form_functions in join instead of fnd_form_functions_vl
257: -- 2) Remove the Cursor for retrieving Application Id - not used anymore
258: -- 3) Remove r_function, use function name from query
259:
260: IF icx_sec.validatePlugSession(p_plug_id,p_session_id) THEN

Line 299: FROM bis_scheduler s, bis_schedule_preferences sp, fnd_form_functions ff, fnd_lobs l

295: , l_parameters
296: , l_fn_responsibility_id
297: , l_schedule_id
298: , l_file_content_type
299: FROM bis_scheduler s, bis_schedule_preferences sp, fnd_form_functions ff, fnd_lobs l
300: WHERE sp.USER_ID = l_user_id
301: AND sp.PLUG_ID = p_plug_id
302: AND sp.schedule_id = s.schedule_id
303: AND ff.function_name = s.function_name

Line 328: from fnd_form_functions

324: --ashgarg changed it for moving select different reports to OA.jsp
325: --ashgarg Bug Fix:3823820
326: begin
327: select function_id into l_function_id
328: from fnd_form_functions
329: where function_name = 'BIS_PMV_SELECT_DIFF_REPORT';
330: exception
331: when others then l_function_id := null;
332: end;

Line 569: FROM fnd_form_functions

565: CLOSE cFNDResp;
566:
567: SELECT function_id
568: INTO l_function_id
569: FROM fnd_form_functions
570: WHERE function_name = 'BIS_PMV_DRILL_JSP';
571:
572: l_jsp_params := 'pMode=7&pRegionCode=' || BIS_PMV_UTIL.encode(pRegionCode) || '&pFunction=' || BIS_PMV_UTIL.encode(pFunctionName) || '&pScheduleId=' || pScheduleId;
573: IF (pPageId IS NOT NULL) THEN

Line 640: from fnd_form_functions

636:
637:
638: CURSOR cFunctionParams (pFunctionName in varchar) is
639: select parameters
640: from fnd_form_functions
641: where function_name = pFunctionName;
642:
643: --BugFix 2869306
644: CURSOR cPageTimeParams (cPageId varchar2, cUserId varchar2) is

Line 662: vParameters fnd_form_functions.parameters%TYPE;

658: vUserid varchar2(80);
659: vSessionId varchar2(80);
660: vResponsibilityId varchar2(80);
661: vEnableForecastGraph varchar2(1);
662: vParameters fnd_form_functions.parameters%TYPE;
663:
664: -- jprabhud - 01/27/03 - Enh 2485974 Custom Views
665: vTitleCustomView fnd_form_functions.function_name%TYPE;
666: vReportFunctionName fnd_form_functions.function_name%TYPE;

Line 665: vTitleCustomView fnd_form_functions.function_name%TYPE;

661: vEnableForecastGraph varchar2(1);
662: vParameters fnd_form_functions.parameters%TYPE;
663:
664: -- jprabhud - 01/27/03 - Enh 2485974 Custom Views
665: vTitleCustomView fnd_form_functions.function_name%TYPE;
666: vReportFunctionName fnd_form_functions.function_name%TYPE;
667: vCustomView fnd_form_functions.function_name%TYPE;
668: vViewName fnd_form_functions.function_name%TYPE;
669: vFunctionName fnd_form_functions.function_name%TYPE;

Line 666: vReportFunctionName fnd_form_functions.function_name%TYPE;

662: vParameters fnd_form_functions.parameters%TYPE;
663:
664: -- jprabhud - 01/27/03 - Enh 2485974 Custom Views
665: vTitleCustomView fnd_form_functions.function_name%TYPE;
666: vReportFunctionName fnd_form_functions.function_name%TYPE;
667: vCustomView fnd_form_functions.function_name%TYPE;
668: vViewName fnd_form_functions.function_name%TYPE;
669: vFunctionName fnd_form_functions.function_name%TYPE;
670: vReportFunctionParameters fnd_form_functions.parameters%TYPE;

Line 667: vCustomView fnd_form_functions.function_name%TYPE;

663:
664: -- jprabhud - 01/27/03 - Enh 2485974 Custom Views
665: vTitleCustomView fnd_form_functions.function_name%TYPE;
666: vReportFunctionName fnd_form_functions.function_name%TYPE;
667: vCustomView fnd_form_functions.function_name%TYPE;
668: vViewName fnd_form_functions.function_name%TYPE;
669: vFunctionName fnd_form_functions.function_name%TYPE;
670: vReportFunctionParameters fnd_form_functions.parameters%TYPE;
671: vRegionCode varchar2(300); --rcmuthuk 03/24/03 Bug#2856247

Line 668: vViewName fnd_form_functions.function_name%TYPE;

664: -- jprabhud - 01/27/03 - Enh 2485974 Custom Views
665: vTitleCustomView fnd_form_functions.function_name%TYPE;
666: vReportFunctionName fnd_form_functions.function_name%TYPE;
667: vCustomView fnd_form_functions.function_name%TYPE;
668: vViewName fnd_form_functions.function_name%TYPE;
669: vFunctionName fnd_form_functions.function_name%TYPE;
670: vReportFunctionParameters fnd_form_functions.parameters%TYPE;
671: vRegionCode varchar2(300); --rcmuthuk 03/24/03 Bug#2856247
672: vSessionValue varchar2(240);

Line 669: vFunctionName fnd_form_functions.function_name%TYPE;

665: vTitleCustomView fnd_form_functions.function_name%TYPE;
666: vReportFunctionName fnd_form_functions.function_name%TYPE;
667: vCustomView fnd_form_functions.function_name%TYPE;
668: vViewName fnd_form_functions.function_name%TYPE;
669: vFunctionName fnd_form_functions.function_name%TYPE;
670: vReportFunctionParameters fnd_form_functions.parameters%TYPE;
671: vRegionCode varchar2(300); --rcmuthuk 03/24/03 Bug#2856247
672: vSessionValue varchar2(240);
673: vSessionDesc varchar2(240);

Line 670: vReportFunctionParameters fnd_form_functions.parameters%TYPE;

666: vReportFunctionName fnd_form_functions.function_name%TYPE;
667: vCustomView fnd_form_functions.function_name%TYPE;
668: vViewName fnd_form_functions.function_name%TYPE;
669: vFunctionName fnd_form_functions.function_name%TYPE;
670: vReportFunctionParameters fnd_form_functions.parameters%TYPE;
671: vRegionCode varchar2(300); --rcmuthuk 03/24/03 Bug#2856247
672: vSessionValue varchar2(240);
673: vSessionDesc varchar2(240);
674: --ksadagop BugFix 3265474

Line 986: from fnd_form_functions

982: vUserId := icx_sec.getID(icx_sec.PV_USER_ID,'',vSessionId);
983:
984: begin
985: select function_id into vPageFunctionId
986: from fnd_form_functions
987: where function_name = 'BIS_CUSTOMIZE_PORTLET_PAGE';
988: exception
989: when others then vPageFunctionId := null;
990: end;

Line 1177: from fnd_form_functions

1173: )
1174: IS
1175: CURSOR cFunction (pFunctionId in number) is
1176: select function_name, web_html_call
1177: from fnd_form_functions
1178: where function_id = pFunctionId;
1179:
1180: l_function_name fnd_form_functions.function_name%TYPE;
1181: lwebhtmlcall varchar2(2000);

Line 1180: l_function_name fnd_form_functions.function_name%TYPE;

1176: select function_name, web_html_call
1177: from fnd_form_functions
1178: where function_id = pFunctionId;
1179:
1180: l_function_name fnd_form_functions.function_name%TYPE;
1181: lwebhtmlcall varchar2(2000);
1182: BEGIN
1183: --aleung, fix for bug 3113469 & bug 3088087
1184: if cFunction%ISOPEN then

Line 1307: from fnd_form_functions

1303: function getFunctionId (pFunctionName varchar2) return number is
1304:
1305: CURSOR cFunction (pFunctionName in varchar2) is
1306: select function_id
1307: from fnd_form_functions
1308: where function_name = pFunctionName;
1309:
1310: l_function_id number;
1311: begin

Line 1345: from fnd_form_functions

1341: IS
1342:
1343: CURSOR cPageInfo (pFunctionId in number) is
1344: select parameters, web_html_call
1345: from fnd_form_functions
1346: where function_id = pFunctionId;
1347:
1348: cursor cMenuInfo (pMenuName varchar2) IS
1349: select menu_id

Line 1353: lParameters fnd_form_functions.parameters%TYPE;

1349: select menu_id
1350: from fnd_menus
1351: where menu_name=pMenuName;
1352:
1353: lParameters fnd_form_functions.parameters%TYPE;
1354: lPageName varchar2(240);
1355: lDestPageId number;
1356: lMenuName varchar2(2000);
1357: lwebhtmlcall varchar2(2000);

Line 1422: from fnd_form_functions

1418: , x_DrillDefaultParameters OUT NOCOPY VARCHAR2
1419: ) IS
1420: CURSOR cPageInfo (pFunctionId in number) is
1421: select parameters
1422: from fnd_form_functions
1423: where function_id = pFunctionId;
1424:
1425:
1426: lParameters fnd_form_functions.parameters%TYPE;

Line 1426: lParameters fnd_form_functions.parameters%TYPE;

1422: from fnd_form_functions
1423: where function_id = pFunctionId;
1424:
1425:
1426: lParameters fnd_form_functions.parameters%TYPE;
1427: lPageName varchar2(240);
1428:
1429: x_return_status varchar2(80);
1430: x_msg_count number;

Line 1531: from fnd_form_functions

1527: is
1528:
1529: CURSOR cFunction (pFunctionId in number) is
1530: select function_name
1531: from fnd_form_functions
1532: where function_id = pFunctionId;
1533:
1534: l_function_name fnd_form_functions.function_name%TYPE;
1535: begin

Line 1534: l_function_name fnd_form_functions.function_name%TYPE;

1530: select function_name
1531: from fnd_form_functions
1532: where function_id = pFunctionId;
1533:
1534: l_function_name fnd_form_functions.function_name%TYPE;
1535: begin
1536:
1537: if cFunction%ISOPEN then
1538: CLOSE cFunction;

Line 1554: from fnd_form_functions_tl

1550: is
1551:
1552: CURSOR cFunction (pFunctionId in number) is
1553: select user_function_name
1554: from fnd_form_functions_tl
1555: where function_id = pFunctionId;
1556:
1557: -- udua - 09.27.05 - R12 Mandatory Project - 4480009 [PMV Data-model Change].
1558: l_user_function_name varchar2(480);