DBA Data[Home] [Help]

APPS.BIS_TREND_PLUG dependencies on ICX_SEC

Line 260: IF icx_sec.validatePlugSession(p_plug_id,p_session_id) THEN

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
261:
262: -- mdamle 01/24/01
263: l_user_id := icx_sec.getID(icx_sec.PV_USER_ID,'',p_session_id);
264:

Line 263: l_user_id := icx_sec.getID(icx_sec.PV_USER_ID,'',p_session_id);

259:
260: IF icx_sec.validatePlugSession(p_plug_id,p_session_id) THEN
261:
262: -- mdamle 01/24/01
263: l_user_id := icx_sec.getID(icx_sec.PV_USER_ID,'',p_session_id);
264:
265: IF p_delete = 'Y' THEN
266: -- mdamle 09/04/01 - Scheduling Enhancements - Phase II - Multiple Preferences per schedule
267: -- Delete Portlet data and schedule info now that portlet is deleted

Line 310: l_fn_responsibility_id := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID,'',p_Session_id);

306: when others then null;
307: end;
308:
309: if l_fn_responsibility_id is null then
310: l_fn_responsibility_id := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID,'',p_Session_id);
311: end if;
312:
313: getRespInfo(l_User_Id, l_fn_responsibility_id, l_application_id, l_sec_grp_id);
314:

Line 342: l_CUSTOMIZE_URL := icx_sec.createRFURL( p_function_id => l_function_id

338: ||'&pPlugId='||p_Plug_Id
339: ||'&pScheduleOverride=Y'
340: ||'&pMode=Y';
341:
342: l_CUSTOMIZE_URL := icx_sec.createRFURL( p_function_id => l_function_id
343: , p_session_id => p_session_id
344: , p_parameters => l_parameters
345: , p_application_id => l_application_id
346: , p_responsibility_id => l_fn_responsibility_id

Line 347: , p_security_group_id => icx_sec.g_security_group_id);

343: , p_session_id => p_session_id
344: , p_parameters => l_parameters
345: , p_application_id => l_application_id
346: , p_responsibility_id => l_fn_responsibility_id
347: , p_security_group_id => icx_sec.g_security_group_id);
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

Line 356: ||'&p_Security_group_id='||icx_sec.g_security_group_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;*/
357:
358: end if;
359: /* l_CUSTOMIZE_URL :='OA_HTML/OA.jsp?akRegionCode=BISPMVRLREPORTSWORKBOOKSPAGE&akRegionApplicationId=191&retainAM=Y'||'&Region_Code='
360: ||'&Function_Name='

Line 463: END IF; -- icx_sec.validatesession

459: ');
460: */
461: end if; -- file_id is not null
462: end if; -- p_delete
463: END IF; -- icx_sec.validatesession
464:
465: exception
466: when others then
467: htp.header(5,SQLERRM);

Line 552: IF NOT icx_sec.ValidateSession THEN

548: FROM fnd_responsibility
549: WHERE responsibility_id = pRespId;
550:
551: BEGIN
552: IF NOT icx_sec.ValidateSession THEN
553: RETURN;
554: END IF;
555:
556: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);

Line 556: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);

552: IF NOT icx_sec.ValidateSession THEN
553: RETURN;
554: END IF;
555:
556: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);
557: l_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
558: l_resp_id := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);
559:
560: IF cFNDResp%ISOPEN THEN

Line 557: l_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);

553: RETURN;
554: END IF;
555:
556: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);
557: l_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
558: l_resp_id := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);
559:
560: IF cFNDResp%ISOPEN THEN
561: CLOSE cFNDResp;

Line 558: l_resp_id := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);

554: END IF;
555:
556: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);
557: l_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
558: l_resp_id := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);
559:
560: IF cFNDResp%ISOPEN THEN
561: CLOSE cFNDResp;
562: END IF;

Line 589: , p_Security_group_id => icx_sec.g_security_group_id

585: , n_session_id => l_session_id
586: , c_parameters => l_jsp_params
587: , p_resp_appl_id => l_application_id
588: , p_responsibility_id => l_resp_id
589: , p_Security_group_id => icx_sec.g_security_group_id
590: );
591:
592: EXCEPTION
593: WHEN OTHERS THEN

Line 682: if not icx_sec.ValidateSession then

678:
679:
680: BEGIN -- validate session
681:
682: if not icx_sec.ValidateSession then
683: return;
684: end if;
685:
686: vSessionId := icx_sec.getID(icx_sec.PV_SESSION_ID);

Line 686: vSessionId := icx_sec.getID(icx_sec.PV_SESSION_ID);

682: if not icx_sec.ValidateSession then
683: return;
684: end if;
685:
686: vSessionId := icx_sec.getID(icx_sec.PV_SESSION_ID);
687: vUserId := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
688:
689: -- mdamle 11/07/2002 - Pass pEnableForecastGraph if needed.
690: if cFunctionParams%ISOPEN then

Line 687: vUserId := icx_sec.getID(icx_sec.PV_WEB_USER_ID);

683: return;
684: end if;
685:
686: vSessionId := icx_sec.getID(icx_sec.PV_SESSION_ID);
687: vUserId := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
688:
689: -- mdamle 11/07/2002 - Pass pEnableForecastGraph if needed.
690: if cFunctionParams%ISOPEN then
691: CLOSE cFunctionParams;

Line 977: if not (icx_sec.validatesession) then

973: vSessionId number;
974:
975: begin
976:
977: if not (icx_sec.validatesession) then
978: return;
979: end if;
980:
981: vSessionId := icx_sec.getid(ICX_SEC.PV_SESSION_ID);

Line 981: vSessionId := icx_sec.getid(ICX_SEC.PV_SESSION_ID);

977: if not (icx_sec.validatesession) then
978: return;
979: end if;
980:
981: vSessionId := icx_sec.getid(ICX_SEC.PV_SESSION_ID);
982: vUserId := icx_sec.getID(icx_sec.PV_USER_ID,'',vSessionId);
983:
984: begin
985: select function_id into vPageFunctionId

Line 982: vUserId := icx_sec.getID(icx_sec.PV_USER_ID,'',vSessionId);

978: return;
979: end if;
980:
981: vSessionId := icx_sec.getid(ICX_SEC.PV_SESSION_ID);
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

Line 992: vRespId := nvl(pResponsibilityId, icx_sec.getid(ICX_SEC.PV_RESPONSIBILITY_ID));

988: exception
989: when others then vPageFunctionId := null;
990: end;
991:
992: vRespId := nvl(pResponsibilityId, icx_sec.getid(ICX_SEC.PV_RESPONSIBILITY_ID));
993: getRespInfo(vUserId, vRespId, vApplicationId, vSecGrpId);
994:
995: icx_sec.updateSessionContext(function_name, null, vApplicationId, vRespId, vSecGrpId, vSessionId, null);
996:

Line 995: icx_sec.updateSessionContext(function_name, null, vApplicationId, vRespId, vSecGrpId, vSessionId, null);

991:
992: vRespId := nvl(pResponsibilityId, icx_sec.getid(ICX_SEC.PV_RESPONSIBILITY_ID));
993: getRespInfo(vUserId, vRespId, vApplicationId, vSecGrpId);
994:
995: icx_sec.updateSessionContext(function_name, null, vApplicationId, vRespId, vSecGrpId, vSessionId, null);
996:
997: if vPageFunctionId is not null then
998:
999: vParams := 'regionCode='||Region_Code||

Line 1046: l_responsibility_id := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);

1042: lFileId NUMBER;
1043: lTitle VARCHAR2(240);
1044: BEGIN
1045:
1046: l_responsibility_id := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);
1047:
1048: SELECT icx_page_plugs_s.nextval INTO x_Plug_Id FROM DUAL;
1049:
1050: -- bug 2842902 - removed user_id from where clause

Line 1086: if not (icx_sec.validatesession) then

1082: jspParams varchar2(32767);
1083:
1084: BEGIN
1085:
1086: if not (icx_sec.validatesession) then
1087: return;
1088: end if;
1089:
1090:

Line 1091: l_user_id := icx_sec.getID(icx_sec.PV_USER_ID,'',icx_sec.getid(ICX_SEC.PV_SESSION_ID));

1087: return;
1088: end if;
1089:
1090:
1091: l_user_id := icx_sec.getID(icx_sec.PV_USER_ID,'',icx_sec.getid(ICX_SEC.PV_SESSION_ID));
1092:
1093: if responsibility_id is not null then
1094: l_resp_id := responsibility_id;
1095: if responsibility_app_id is not null then

Line 1104: l_resp_id := icx_sec.getid(ICX_SEC.PV_RESPONSIBILITY_ID);

1100: end if;
1101: end if;
1102:
1103: if l_resp_id is null then
1104: l_resp_id := icx_sec.getid(ICX_SEC.PV_RESPONSIBILITY_ID);
1105: end if;
1106:
1107: if l_resp_app_id is null or l_sec_grp_id is null then
1108: getRespInfo(l_user_id, l_resp_id, l_resp_app_id,l_sec_grp_id);

Line 1152: ,n_session_id => icx_sec.getid(ICX_SEC.PV_SESSION_ID)

1148: function_id ,
1149: jspParams );
1150: /*
1151: OracleApps.runFunction(c_function_id => function_id
1152: ,n_session_id => icx_sec.getid(ICX_SEC.PV_SESSION_ID)
1153: -- jprabhud 03/04/2003 - Refresh Portal Page
1154: ,c_parameters => jspParams
1155: ,p_resp_appl_id => l_resp_app_id
1156: ,p_responsibility_id => l_resp_id

Line 1261: l_responsibility_id := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);

1257:
1258: BEGIN
1259:
1260: -- validate sessionx
1261: l_responsibility_id := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);
1262: -- add row in the bis_scheduler preferences table
1263: BIS_RG_SCHEDULES_PVT.CREATE_SCHEDULE_NO_COMMIT (
1264: p_plug_id => pPlugId,
1265: p_user_id => pUserId,

Line 1492: if not (icx_sec.validatesession) then

1488: -- nbarik - 04/20/04 - Enhancement 3378782 - Parameter Validation
1489: l_DrillDefaultParameters VARCHAR2(3000);
1490: begin
1491:
1492: if not (icx_sec.validatesession) then
1493: return;
1494: end if;
1495:
1496: lSessionId := icx_sec.getId(ICX_SEC.PV_SESSION_ID);

Line 1496: lSessionId := icx_sec.getId(ICX_SEC.PV_SESSION_ID);

1492: if not (icx_sec.validatesession) then
1493: return;
1494: end if;
1495:
1496: lSessionId := icx_sec.getId(ICX_SEC.PV_SESSION_ID);
1497: lUserId := icx_sec.getID(icx_sec.PV_USER_ID,'',lSessionId);
1498:
1499: processLinkedPage(
1500: pSourcePageId

Line 1497: lUserId := icx_sec.getID(icx_sec.PV_USER_ID,'',lSessionId);

1493: return;
1494: end if;
1495:
1496: lSessionId := icx_sec.getId(ICX_SEC.PV_SESSION_ID);
1497: lUserId := icx_sec.getID(icx_sec.PV_USER_ID,'',lSessionId);
1498:
1499: processLinkedPage(
1500: pSourcePageId
1501: ,pDestFunctionId

Line 1635: if not (icx_sec.validatesession) then

1631: -- nbarik - 04/20/04 - Enhancement 3378782 - Parameter Validation
1632: l_DrillDefaultParameters VARCHAR2(3000);
1633: BEGIN
1634:
1635: if not (icx_sec.validatesession) then
1636: return;
1637: end if;
1638:
1639: lSessionId := icx_sec.getId(ICX_SEC.PV_SESSION_ID);

Line 1639: lSessionId := icx_sec.getId(ICX_SEC.PV_SESSION_ID);

1635: if not (icx_sec.validatesession) then
1636: return;
1637: end if;
1638:
1639: lSessionId := icx_sec.getId(ICX_SEC.PV_SESSION_ID);
1640: lUserId := icx_sec.getID(icx_sec.PV_USER_ID,'',lSessionId);
1641:
1642: processPageFromReport(
1643: pFunctionName

Line 1640: lUserId := icx_sec.getID(icx_sec.PV_USER_ID,'',lSessionId);

1636: return;
1637: end if;
1638:
1639: lSessionId := icx_sec.getId(ICX_SEC.PV_SESSION_ID);
1640: lUserId := icx_sec.getID(icx_sec.PV_USER_ID,'',lSessionId);
1641:
1642: processPageFromReport(
1643: pFunctionName
1644: ,pDestFunctionId