233:
234: FUNCTION set_session_info RETURN BOOLEAN is
235: BEGIN
236:
237: IF NOT icx_sec.validatesession THEN
238: RETURN FALSE;
239: END IF;
240:
241: POS_ASBN.g_org_id := icx_sec.getID(icx_sec.PV_ORG_ID);
237: IF NOT icx_sec.validatesession THEN
238: RETURN FALSE;
239: END IF;
240:
241: POS_ASBN.g_org_id := icx_sec.getID(icx_sec.PV_ORG_ID);
242: POS_ASBN.g_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
243: POS_ASBN.g_script_name := owa_util.get_cgi_env('SCRIPT_NAME');
244: POS_ASBN.g_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
245: POS_ASBN.g_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);
238: RETURN FALSE;
239: END IF;
240:
241: POS_ASBN.g_org_id := icx_sec.getID(icx_sec.PV_ORG_ID);
242: POS_ASBN.g_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
243: POS_ASBN.g_script_name := owa_util.get_cgi_env('SCRIPT_NAME');
244: POS_ASBN.g_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
245: POS_ASBN.g_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);
246: POS_ASBN.g_responsibility_id := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);
240:
241: POS_ASBN.g_org_id := icx_sec.getID(icx_sec.PV_ORG_ID);
242: POS_ASBN.g_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
243: POS_ASBN.g_script_name := owa_util.get_cgi_env('SCRIPT_NAME');
244: POS_ASBN.g_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
245: POS_ASBN.g_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);
246: POS_ASBN.g_responsibility_id := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);
247:
248: fnd_client_info.set_org_context(g_org_id);
241: POS_ASBN.g_org_id := icx_sec.getID(icx_sec.PV_ORG_ID);
242: POS_ASBN.g_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
243: POS_ASBN.g_script_name := owa_util.get_cgi_env('SCRIPT_NAME');
244: POS_ASBN.g_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
245: POS_ASBN.g_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);
246: POS_ASBN.g_responsibility_id := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);
247:
248: fnd_client_info.set_org_context(g_org_id);
249:
242: POS_ASBN.g_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
243: POS_ASBN.g_script_name := owa_util.get_cgi_env('SCRIPT_NAME');
244: POS_ASBN.g_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
245: POS_ASBN.g_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);
246: POS_ASBN.g_responsibility_id := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);
247:
248: fnd_client_info.set_org_context(g_org_id);
249:
250: RETURN TRUE;
466: l_attribute_index NUMBER;
467: l_result_index NUMBER;
468: l_current_col NUMBER;
469: l_current_row NUMBER;
470: l_session_id NUMBER := icx_sec.getID(icx_sec.PV_SESSION_ID);
471: l_where_clause VARCHAR2(2000) := 'SESSION_ID = ' || to_char(l_session_id);
472: BEGIN
473:
474: htp.p('