DBA Data[Home] [Help]

APPS.BSC_PORTLET_KPILISTCUST dependencies on ICX_SEC

Line 87: IF icx_sec.validateSessionPrivate(p_session_id) THEN

83:
84:
85: BEGIN
86:
87: IF icx_sec.validateSessionPrivate(p_session_id) THEN
88:
89: OPEN c_kg_p;
90: FETCH c_kg_p INTO l_resp_id;
91:

Line 94: END IF; -- icx_sec.validateSessionPrivate(p_session_id)

90: FETCH c_kg_p INTO l_resp_id;
91:
92: CLOSE c_kg_p;
93:
94: END IF; -- icx_sec.validateSessionPrivate(p_session_id)
95:
96: RETURN l_resp_id;
97: END get_resp_id;
98: */

Line 647: IF icx_sec.validateSessionPrivate(l_session_id) THEN

643: bsc_portlet_util.decrypt_plug_info(p_cookie_value,
644: p_encrypted_plug_id, l_session_id, p_plug_id);
645:
646:
647: IF icx_sec.validateSessionPrivate(l_session_id) THEN
648: p_user_id := icx_sec.getID(icx_sec.PV_USER_ID,'', l_session_id);
649:
650:
651: OPEN c_kg_p;

Line 648: p_user_id := icx_sec.getID(icx_sec.PV_USER_ID,'', l_session_id);

644: p_encrypted_plug_id, l_session_id, p_plug_id);
645:
646:
647: IF icx_sec.validateSessionPrivate(l_session_id) THEN
648: p_user_id := icx_sec.getID(icx_sec.PV_USER_ID,'', l_session_id);
649:
650:
651: OPEN c_kg_p;
652: FETCH c_kg_p INTO p_resp_id, p_details_flag, p_group_flag, p_display_name, p_kpi_measure_details_flag;

Line 686: END IF; -- icx_sec.validateSessionPrivate(l_session_id)

682: END IF; -- c_kg_p%FOUND
683:
684: ELSE -- session expires
685: RETURN bsc_portlet_util.CODE_RET_SESSION_EXP;
686: END IF; -- icx_sec.validateSessionPrivate(l_session_id)
687: EXCEPTION
688: WHEN OTHERS THEN
689: --close the open cursors if any.
690: IF(c_kg_p%ISOPEN) THEN