DBA Data[Home] [Help]

APPS.BIS_TREND_PLUG dependencies on BIS_PMV_UTIL

Line 233: l_html_pieces bis_pmv_util.lob_varchar_pieces;

229: l_file_id pls_integer := null;
230: l_profile_defined boolean;
231: l_message varchar2(32000);
232: --l_html_pieces utl_http.html_pieces;
233: l_html_pieces bis_pmv_util.lob_varchar_pieces;
234: last_upd date;
235: l_report_url varchar2(32000);
236: l_parameters varchar2(32000);
237: l_customize_url varchar2(32000);

Line 321: r_region := BIS_PMV_UTIL.getReportRegion(l_function_name);

317: /*
318: r_region := substr( l_parameters, instr(l_parameters, '''')+1 );
319: r_region := substr( r_region, 1, instr(r_region,'''')-1 );
320: */
321: r_region := BIS_PMV_UTIL.getReportRegion(l_function_name);
322:
323: if r_region is null and l_function_name is null then
324: --ashgarg changed it for moving select different reports to OA.jsp
325: --ashgarg Bug Fix:3823820

Line 352: ||'&c_parameters='||BIS_PMV_UTIL.encode(l_parameters)

348:
349: /*l_CUSTOMIZE_URL := icx_plug_utilities.getPLSQLagent
350: || 'OracleApps.runFunction?c_function_id=' || l_function_id
351: ||'&n_session_id='||p_session_id
352: ||'&c_parameters='||BIS_PMV_UTIL.encode(l_parameters)
353: ||'&p_resp_appl_id='||l_application_id
354: ||'&p_responsibility_id='||l_resp_id
355: -- mdamle 01/08/2002
356: ||'&p_Security_group_id='||icx_sec.g_security_group_id;*/

Line 406: ||' target=_top>'||l_title||BIS_PMV_UTIL.getAppendTitle(r_region)||''

402: (''||l_title||BIS_PMV_UTIL.getAppendTitle(r_region)||''
407: ,l_customize_url
408: ,'FNDTREND.gif');
409:
410: setTableStyles;

Line 416: l_html_pieces := bis_pmv_util.readFndLobs(l_file_id);

412: if (l_file_id is not null) then
413:
414: -- TABLE / GRAPH IS AVAILABLE IN HTML
415: -- aleung, 7/13/01, use readFndLobs to get the html pieces
416: l_html_pieces := bis_pmv_util.readFndLobs(l_file_id);
417:
418: -- mdamle 08/27/01 - Show gif for graph or html for table
419: if l_html_pieces.count > 0 then
420: if instr(lower(l_file_content_type),'image/gif') > 0 then

Line 572: l_jsp_params := 'pMode=7&pRegionCode=' || BIS_PMV_UTIL.encode(pRegionCode) || '&pFunction=' || BIS_PMV_UTIL.encode(pFunctionName) || '&pScheduleId=' || pScheduleId;

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
574: l_jsp_params := l_jsp_params || '&pPageId=' || pPageId;
575: END IF;
576: IF (pObjectType IS NOT NULL) THEN

Line 698: vEnableForecastGraph := BIS_PMV_UTIL.getParameterValue(vParameters, 'pEnableForecastGraph');

694: FETCH cFunctionParams INTO vParameters;
695: CLOSE cFunctionParams;
696:
697: if vParameters is not null then
698: vEnableForecastGraph := BIS_PMV_UTIL.getParameterValue(vParameters, 'pEnableForecastGraph');
699: -- jprabhud - 01/27/03 - Enh 2485974 Custom Views
700: vTitleCustomView := BIS_PMV_UTIL.getParameterValue(vParameters, 'pTitleCustomView');
701:
702: vReportFunctionName := BIS_PMV_UTIL.getParameterValue(vParameters, 'pReportFunctionName');

Line 700: vTitleCustomView := BIS_PMV_UTIL.getParameterValue(vParameters, 'pTitleCustomView');

696:
697: if vParameters is not null then
698: vEnableForecastGraph := BIS_PMV_UTIL.getParameterValue(vParameters, 'pEnableForecastGraph');
699: -- jprabhud - 01/27/03 - Enh 2485974 Custom Views
700: vTitleCustomView := BIS_PMV_UTIL.getParameterValue(vParameters, 'pTitleCustomView');
701:
702: vReportFunctionName := BIS_PMV_UTIL.getParameterValue(vParameters, 'pReportFunctionName');
703: end if;
704:

Line 702: vReportFunctionName := BIS_PMV_UTIL.getParameterValue(vParameters, 'pReportFunctionName');

698: vEnableForecastGraph := BIS_PMV_UTIL.getParameterValue(vParameters, 'pEnableForecastGraph');
699: -- jprabhud - 01/27/03 - Enh 2485974 Custom Views
700: vTitleCustomView := BIS_PMV_UTIL.getParameterValue(vParameters, 'pTitleCustomView');
701:
702: vReportFunctionName := BIS_PMV_UTIL.getParameterValue(vParameters, 'pReportFunctionName');
703: end if;
704:
705: -- jprabhud - 01/27/03 - Enh 2485974 Custom Views
706: if vTitleCustomView is null then

Line 718: vCustomView := BIS_PMV_UTIL.getParameterValue(vReportFunctionParameters, 'pCustomView');

714: end if;
715: end if;
716:
717: if vReportFunctionParameters is not null then
718: vCustomView := BIS_PMV_UTIL.getParameterValue(vReportFunctionParameters, 'pCustomView');
719: vRegionCode := BIS_PMV_UTIL.getParameterValue(vReportFunctionParameters, 'pRegionCode'); --rcmuthuk 03/24/03 Bug#2856247
720: end if;
721:
722: -- rcmuthuk - 03/24/03 Bug#2856247

Line 719: vRegionCode := BIS_PMV_UTIL.getParameterValue(vReportFunctionParameters, 'pRegionCode'); --rcmuthuk 03/24/03 Bug#2856247

715: end if;
716:
717: if vReportFunctionParameters is not null then
718: vCustomView := BIS_PMV_UTIL.getParameterValue(vReportFunctionParameters, 'pCustomView');
719: vRegionCode := BIS_PMV_UTIL.getParameterValue(vReportFunctionParameters, 'pRegionCode'); --rcmuthuk 03/24/03 Bug#2856247
720: end if;
721:
722: -- rcmuthuk - 03/24/03 Bug#2856247
723: if vRegionCode is null then

Line 1012: '&pReturnURL='||NVL(bis_pmv_util.encode(pReturnURL), '');

1008: '&pShowPortletSettings='||pShowPortletSettings||
1009: '&pComponentType='||pComponentType||
1010: '&pMsrId='||pMsrId||
1011: '&pIsPrintable='||pIsPrintable||
1012: '&pReturnURL='||NVL(bis_pmv_util.encode(pReturnURL), '');
1013:
1014:
1015: OracleApps.runFunction(c_function_id => vPageFunctionId
1016: ,n_session_id => pSessionId

Line 1145: BIS_PMV_UTIL.bis_run_function( l_resp_app_id,

1141: end if;
1142: */
1143:
1144: --jprabhud - 11/13/03 - Bug 3253597
1145: BIS_PMV_UTIL.bis_run_function( l_resp_app_id,
1146: l_resp_id,
1147: l_sec_grp_id ,
1148: function_id ,
1149: jspParams );

Line 1371: lPageName := BIS_PMV_UTIL.getParameterValue(upper(lParameters), 'PAGENAME');

1367: FETCH cPageInfo INTO lParameters,lwebhtmlcall;
1368: CLOSE cPageInfo;
1369:
1370: if lParameters is not null then
1371: lPageName := BIS_PMV_UTIL.getParameterValue(upper(lParameters), 'PAGENAME');
1372: lSourceType := BIS_PMV_UTIL.getParameterValue(upper(lParameters), 'SOURCETYPE');
1373:
1374: if (lPageName is not null and lSourceType is null) then
1375: lDestPageId := BIS_PMV_UTIL.getPortalPageId(lPageName);

Line 1372: lSourceType := BIS_PMV_UTIL.getParameterValue(upper(lParameters), 'SOURCETYPE');

1368: CLOSE cPageInfo;
1369:
1370: if lParameters is not null then
1371: lPageName := BIS_PMV_UTIL.getParameterValue(upper(lParameters), 'PAGENAME');
1372: lSourceType := BIS_PMV_UTIL.getParameterValue(upper(lParameters), 'SOURCETYPE');
1373:
1374: if (lPageName is not null and lSourceType is null) then
1375: lDestPageId := BIS_PMV_UTIL.getPortalPageId(lPageName);
1376: else

Line 1375: lDestPageId := BIS_PMV_UTIL.getPortalPageId(lPageName);

1371: lPageName := BIS_PMV_UTIL.getParameterValue(upper(lParameters), 'PAGENAME');
1372: lSourceType := BIS_PMV_UTIL.getParameterValue(upper(lParameters), 'SOURCETYPE');
1373:
1374: if (lPageName is not null and lSourceType is null) then
1375: lDestPageId := BIS_PMV_UTIL.getPortalPageId(lPageName);
1376: else
1377: if lPageName is not null then
1378: lMenuName := lPageName;
1379: else

Line 1380: lMenuName := BIS_PMV_UTIL.getParameterValue(upper(lwebhtmlcall),'PAGENAME');

1376: else
1377: if lPageName is not null then
1378: lMenuName := lPageName;
1379: else
1380: lMenuName := BIS_PMV_UTIL.getParameterValue(upper(lwebhtmlcall),'PAGENAME');
1381: end if;
1382:
1383: if (lMenuName is not null) then
1384: if cMenuInfo%ISOPEN then

Line 1462: BIS_PMV_UTIL.update_portlets_bypage(xDestPageId);

1458: x_return_status,
1459: x_msg_count,
1460: x_msg_data);
1461:
1462: BIS_PMV_UTIL.update_portlets_bypage(xDestPageId);
1463:
1464: end if;
1465: else
1466: xSourcePageId := 0;

Line 1609: BIS_PMV_UTIL.update_portlets_bypage(xDestPageID);

1605: x_msg_count,
1606: x_msg_data
1607: );
1608:
1609: BIS_PMV_UTIL.update_portlets_bypage(xDestPageID);
1610: END IF;
1611:
1612: END processPageFromReport;
1613: