82: l_operating_unit VARCHAR2(60) := null;
83:
84: BEGIN
85:
86: IF NOT icx_sec.validatesession THEN
87: RETURN;
88: END IF;
89:
90: l_org_id := icx_sec.getID(icx_sec.PV_ORG_ID);
86: IF NOT icx_sec.validatesession THEN
87: RETURN;
88: END IF;
89:
90: l_org_id := icx_sec.getID(icx_sec.PV_ORG_ID);
91: l_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
92: l_script_name := owa_util.get_cgi_env('SCRIPT_NAME');
93: l_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
94:
87: RETURN;
88: END IF;
89:
90: l_org_id := icx_sec.getID(icx_sec.PV_ORG_ID);
91: l_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
92: l_script_name := owa_util.get_cgi_env('SCRIPT_NAME');
93: l_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
94:
95: BEGIN
89:
90: l_org_id := icx_sec.getID(icx_sec.PV_ORG_ID);
91: l_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
92: l_script_name := owa_util.get_cgi_env('SCRIPT_NAME');
93: l_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
94:
95: BEGIN
96:
97: select
701: temp VARCHAR2(30);
702: BEGIN
703: ak_query_pkg.exec_query(p_parent_region_appl_id=>201,
704: p_parent_region_code=>'POA_CM_EVALUATION_R',
705: p_responsibility_id=>icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),
706: p_user_id=>icx_sec.getID(icx_sec.PV_WEB_USER_ID),
707: p_return_parents=>'F',
708: p_return_children=>'F');
709:
702: BEGIN
703: ak_query_pkg.exec_query(p_parent_region_appl_id=>201,
704: p_parent_region_code=>'POA_CM_EVALUATION_R',
705: p_responsibility_id=>icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),
706: p_user_id=>icx_sec.getID(icx_sec.PV_WEB_USER_ID),
707: p_return_parents=>'F',
708: p_return_children=>'F');
709:
710: l_count := 0;