16: l_access_key VARCHAR2(2000);
17: l_admin_mode VARCHAR2(2000);
18: BEGIN
19: l_region := 'My Region';
20: IF NOT icx_sec.validateSession(c_validate_only => 'Y')
21: THEN
22: x_session_id := icx_sec.createSession(
23: p_user_id => 6,
24: c_mode_code => '115X');
18: BEGIN
19: l_region := 'My Region';
20: IF NOT icx_sec.validateSession(c_validate_only => 'Y')
21: THEN
22: x_session_id := icx_sec.createSession(
23: p_user_id => 6,
24: c_mode_code => '115X');
25: l_validate := icx_sec.validateSessionPrivate(
26: c_session_id => x_session_id,
21: THEN
22: x_session_id := icx_sec.createSession(
23: p_user_id => 6,
24: c_mode_code => '115X');
25: l_validate := icx_sec.validateSessionPrivate(
26: c_session_id => x_session_id,
27: c_validate_only => 'Y');
28: -- owa_util.mime_header('text/html',FALSE);
29: -- icx_sec.sendsessioncookie(l_session_id);
25: l_validate := icx_sec.validateSessionPrivate(
26: c_session_id => x_session_id,
27: c_validate_only => 'Y');
28: -- owa_util.mime_header('text/html',FALSE);
29: -- icx_sec.sendsessioncookie(l_session_id);
30:
31: x_transaction_id := icx_sec.createTransaction(
32: p_session_id => x_session_id,
33: p_resp_appl_id => 178,
27: c_validate_only => 'Y');
28: -- owa_util.mime_header('text/html',FALSE);
29: -- icx_sec.sendsessioncookie(l_session_id);
30:
31: x_transaction_id := icx_sec.createTransaction(
32: p_session_id => x_session_id,
33: p_resp_appl_id => 178,
34: p_responsibility_id => 20873,
35: p_security_group_id => 0);
33: p_resp_appl_id => 178,
34: p_responsibility_id => 20873,
35: p_security_group_id => 0);
36:
37: icx_sec.updateSessionContext(
38: p_application_id =>178,
39: p_responsibility_id =>20873,
40: p_security_group_id => 0,
41: p_session_id => x_session_id,
46:
47: SELECT max(transaction_id)
48: INTO x_transaction_id
49: FROM icx_transactions
50: WHERE session_id = icx_sec.g_session_id
51: AND responsibility_id = icx_sec.g_responsibility_id
52: AND security_group_id = icx_sec.g_security_group_id
53: AND function_id = icx_sec.g_function_id
54: GROUP BY transaction_id;
47: SELECT max(transaction_id)
48: INTO x_transaction_id
49: FROM icx_transactions
50: WHERE session_id = icx_sec.g_session_id
51: AND responsibility_id = icx_sec.g_responsibility_id
52: AND security_group_id = icx_sec.g_security_group_id
53: AND function_id = icx_sec.g_function_id
54: GROUP BY transaction_id;
55:
48: INTO x_transaction_id
49: FROM icx_transactions
50: WHERE session_id = icx_sec.g_session_id
51: AND responsibility_id = icx_sec.g_responsibility_id
52: AND security_group_id = icx_sec.g_security_group_id
53: AND function_id = icx_sec.g_function_id
54: GROUP BY transaction_id;
55:
56: EXCEPTION
49: FROM icx_transactions
50: WHERE session_id = icx_sec.g_session_id
51: AND responsibility_id = icx_sec.g_responsibility_id
52: AND security_group_id = icx_sec.g_security_group_id
53: AND function_id = icx_sec.g_function_id
54: GROUP BY transaction_id;
55:
56: EXCEPTION
57: WHEN NO_DATA_FOUND THEN