51: order by demand_plan_name;
52:
53: begin
54:
55: if (icx_sec.validateSession()) then
56: n_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);
57: v_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
58: n_web_user := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
59: n_responsibility_id := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);
52:
53: begin
54:
55: if (icx_sec.validateSession()) then
56: n_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);
57: v_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
58: n_web_user := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
59: n_responsibility_id := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);
60: n_function_id := icx_sec.getID(icx_sec.PV_FUNCTION_ID);
53: begin
54:
55: if (icx_sec.validateSession()) then
56: n_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);
57: v_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
58: n_web_user := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
59: n_responsibility_id := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);
60: n_function_id := icx_sec.getID(icx_sec.PV_FUNCTION_ID);
61:
54:
55: if (icx_sec.validateSession()) then
56: n_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);
57: v_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
58: n_web_user := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
59: n_responsibility_id := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);
60: n_function_id := icx_sec.getID(icx_sec.PV_FUNCTION_ID);
61:
62: select APPLICATION_ID
55: if (icx_sec.validateSession()) then
56: n_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);
57: v_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
58: n_web_user := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
59: n_responsibility_id := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);
60: n_function_id := icx_sec.getID(icx_sec.PV_FUNCTION_ID);
61:
62: select APPLICATION_ID
63: into n_application_id
56: n_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);
57: v_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
58: n_web_user := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
59: n_responsibility_id := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);
60: n_function_id := icx_sec.getID(icx_sec.PV_FUNCTION_ID);
61:
62: select APPLICATION_ID
63: into n_application_id
64: from FND_RESPONSIBILITY