APPS.POS_ACK_SEARCH dependencies on ICX_SESSIONS

Line 59: update icx_sessions

55:
56: select org_id into l_org_id
57: from po_headers_all where po_header_id = to_number(pk1);
58:
59: update icx_sessions
60: set org_id = l_org_id
61: where session_id = l_session_id;
62: commit;
63:

Line 892: select responsibility_id into g_responsibility_id from ICX_SESSIONS

888: /* bug 1361618 : setting the org context */
889: fnd_client_info.set_org_context(l_org_id);
890: fnd_global.apps_initialize(l_user_id, l_responsibility_id, 178);
891:
892: select responsibility_id into g_responsibility_id from ICX_SESSIONS
893: WHERE session_id = l_session_id;
894: select user_id into g_user_id from ICX_SESSIONS
895: WHERE session_id = l_session_id;
896: veera_debug('RESULT_PO: Org Id: ' || to_char(l_org_id) || 'User Id: ' ||

Line 894: select user_id into g_user_id from ICX_SESSIONS

890: fnd_global.apps_initialize(l_user_id, l_responsibility_id, 178);
891:
892: select responsibility_id into g_responsibility_id from ICX_SESSIONS
893: WHERE session_id = l_session_id;
894: select user_id into g_user_id from ICX_SESSIONS
895: WHERE session_id = l_session_id;
896: veera_debug('RESULT_PO: Org Id: ' || to_char(l_org_id) || 'User Id: ' ||
897: to_char(g_user_id) || 'Resp ID: ' || to_char(g_responsibility_id) ||
898: 'Session Id: ' || to_char(l_session_id));

Line 1761: l_format_mask icx_sessions.DATE_FORMAT_MASK%TYPE;

1757: l_Document_Type_Code IN VARCHAR2 default null
1758: )
1759: IS
1760:
1761: l_format_mask icx_sessions.DATE_FORMAT_MASK%TYPE;
1762: l_session_id number;
1763:
1764: CURSOR l_cursor IS
1765: select *

Line 1797: from icx_sessions

1793: -- Bug 1196968
1794:
1795: select date_format_mask
1796: into l_format_mask
1797: from icx_sessions
1798: where session_id = l_session_id;
1799:
1800: fnd_date.initialize(l_format_mask);
1801: