DBA Data[Home] [Help]

APPS.HR_UTIL_MISC_WEB dependencies on ICX_SEC

Line 134: RETURN(icx_sec.getID(icx_sec.PV_LANGUAGE_CODE));

130: l_proc constant varchar2(100) := g_package || ' get_language_code';
131: BEGIN
132: hr_utility.set_location('Entering: '|| l_proc,5);
133: hr_utility.set_location('Leaving: '|| l_proc,10);
134: RETURN(icx_sec.getID(icx_sec.PV_LANGUAGE_CODE));
135:
136: END get_language_code;
137:
138: -- ------------------------------------------------------------------------

Line 374: l_date_fmt := icx_sec.getID(icx_sec.PV_DATE_FORMAT);

370: begin
371: hr_utility.set_location('Entering: '|| l_proc,5);
372: validate_session(p_person_id => l_person_id
373: ,p_icx_update => false);
374: l_date_fmt := icx_sec.getID(icx_sec.PV_DATE_FORMAT);
375: --
376: hr_utility.set_location('Leaving: '|| l_proc,10);
377: return l_date_fmt;
378: --

Line 1084: IF NOT(icx_sec.validateSession(c_update => p_icx_update

1080: l_proc constant varchar2(100) := g_package || ' validate_session';
1081:
1082: BEGIN
1083: hr_utility.set_location('Entering: '|| l_proc,5);
1084: IF NOT(icx_sec.validateSession(c_update => p_icx_update
1085: ,c_commit => p_icx_commit)) THEN
1086: RAISE g_error_handled;
1087: ELSE
1088: -- ensure HR is fully installed

Line 1150: l_web_user_id := icx_sec.getID(n_param => 10);

1146: -- also returns a -1 into the web user id if we are in
1147: -- a psuedo session situation: this we do need to know
1148: -- so that we can manually get the person information when
1149: -- there is a psuedo session.
1150: l_web_user_id := icx_sec.getID(n_param => 10);
1151: --
1152: -- determine if the web user is -1 (pseudo session)
1153: IF l_web_user_id = -1 THEN
1154: hr_utility.trace('In if( IF l_web_user_id = -1 ) ): '|| l_proc);

Line 1166: l_person_id := icx_sec.getID(n_param => 9);

1162: l_web_username := wf_notification.accesscheck
1163: (l_cookie.vals(l_cookie.num_vals));
1164: --
1165: -- getid with a parm of 9 returns the internal-contact-id,
1166: l_person_id := icx_sec.getID(n_param => 9);
1167: --
1168: ELSE
1169: -- the WF_SESSION cookie does not exist. a serious error
1170: -- has ocurred which must be reported

Line 1178: l_person_id := icx_sec.getID(n_param => 9);

1174: RAISE g_error_handled;
1175: END IF;
1176: ELSE
1177: hr_utility.trace('In else of if( IF l_web_user_id = -1 ) ): '|| l_proc);
1178: l_person_id := icx_sec.getID(n_param => 9);
1179: --
1180: -- getid with a parm of 99 returns the web user name.
1181: l_web_username := icx_sec.getID(n_param => 99);
1182: END IF;

Line 1181: l_web_username := icx_sec.getID(n_param => 99);

1177: hr_utility.trace('In else of if( IF l_web_user_id = -1 ) ): '|| l_proc);
1178: l_person_id := icx_sec.getID(n_param => 9);
1179: --
1180: -- getid with a parm of 99 returns the web user name.
1181: l_web_username := icx_sec.getID(n_param => 99);
1182: END IF;
1183: END IF;
1184: p_person_id := l_person_id;
1185: p_web_username := l_web_username;

Line 2142: OPEN csr_icx_session( icx_sec.getID(n_param => icx_sec.PV_SESSION_ID));

2138: hr_utility.set_location('Entering: '|| l_proc,5);
2139: -- --------------------------------------------------------
2140: -- Get the Function ID
2141: -- --------------------------------------------------------
2142: OPEN csr_icx_session( icx_sec.getID(n_param => icx_sec.PV_SESSION_ID));
2143: hr_utility.trace('Going into Fetch after (csr_icx_session( icx_sec.getID(n_param => icx_sec.PV_SESSION_ID)) ): '|| l_proc);
2144: FETCH csr_icx_session INTO l_function_id;
2145: CLOSE csr_icx_session;
2146:

Line 2143: hr_utility.trace('Going into Fetch after (csr_icx_session( icx_sec.getID(n_param => icx_sec.PV_SESSION_ID)) ): '|| l_proc);

2139: -- --------------------------------------------------------
2140: -- Get the Function ID
2141: -- --------------------------------------------------------
2142: OPEN csr_icx_session( icx_sec.getID(n_param => icx_sec.PV_SESSION_ID));
2143: hr_utility.trace('Going into Fetch after (csr_icx_session( icx_sec.getID(n_param => icx_sec.PV_SESSION_ID)) ): '|| l_proc);
2144: FETCH csr_icx_session INTO l_function_id;
2145: CLOSE csr_icx_session;
2146:
2147: -- --------------------------------------------------------

Line 2220: OPEN csr_icx_session( icx_sec.getID(n_param => icx_sec.PV_SESSION_ID));

2216: hr_utility.set_location('Entering: '|| l_proc,5);
2217: -- --------------------------------------------------------
2218: -- Get the Function ID
2219: -- --------------------------------------------------------
2220: OPEN csr_icx_session( icx_sec.getID(n_param => icx_sec.PV_SESSION_ID));
2221: hr_utility.trace('Going into Fetch after (OPEN csr_icx_session( icx_sec.getID(n_param => icx_sec.PV_SESSION_ID))): '|| l_proc);
2222: FETCH csr_icx_session INTO l_function_id;
2223: CLOSE csr_icx_session;
2224:

Line 2221: hr_utility.trace('Going into Fetch after (OPEN csr_icx_session( icx_sec.getID(n_param => icx_sec.PV_SESSION_ID))): '|| l_proc);

2217: -- --------------------------------------------------------
2218: -- Get the Function ID
2219: -- --------------------------------------------------------
2220: OPEN csr_icx_session( icx_sec.getID(n_param => icx_sec.PV_SESSION_ID));
2221: hr_utility.trace('Going into Fetch after (OPEN csr_icx_session( icx_sec.getID(n_param => icx_sec.PV_SESSION_ID))): '|| l_proc);
2222: FETCH csr_icx_session INTO l_function_id;
2223: CLOSE csr_icx_session;
2224:
2225: -- --------------------------------------------------------

Line 2269: OPEN csr_icx_session( icx_sec.getID(n_param => icx_sec.PV_SESSION_ID));

2265:
2266: -- --------------------------------------------------------
2267: -- Get the Function ID
2268: -- --------------------------------------------------------
2269: OPEN csr_icx_session( icx_sec.getID(n_param => icx_sec.PV_SESSION_ID));
2270: hr_utility.trace('Going into Fetch after ( OPEN csr_icx_session( icx_sec.getID(n_param => icx_sec.PV_SESSION_ID))): '|| l_proc);
2271: FETCH csr_icx_session INTO l_function_id;
2272: CLOSE csr_icx_session;
2273:

Line 2270: hr_utility.trace('Going into Fetch after ( OPEN csr_icx_session( icx_sec.getID(n_param => icx_sec.PV_SESSION_ID))): '|| l_proc);

2266: -- --------------------------------------------------------
2267: -- Get the Function ID
2268: -- --------------------------------------------------------
2269: OPEN csr_icx_session( icx_sec.getID(n_param => icx_sec.PV_SESSION_ID));
2270: hr_utility.trace('Going into Fetch after ( OPEN csr_icx_session( icx_sec.getID(n_param => icx_sec.PV_SESSION_ID))): '|| l_proc);
2271: FETCH csr_icx_session INTO l_function_id;
2272: CLOSE csr_icx_session;
2273:
2274: -- --------------------------------------------------------