DBA Data[Home] [Help]

APPS.ICX_EXT_SUPPLIER dependencies on ICX_REQUISITIONER_INFO

Line 6: user_record icx_requisitioner_info%ROWTYPE;

2: /* $Header: ICXEXSPB.pls 115.4 2001/11/14 09:50:13 pkm ship $ */
3:
4: PROCEDURE authenticate_user(ticket in number) is
5:
6: user_record icx_requisitioner_info%ROWTYPE;
7: l_session_id number;
8: l_company varchar2(100);
9: l_url varchar2(2000);
10: l_user_name varchar2(100);

Line 18: icx_requisitioner_info iri,

14: iri.ship_to, iri.deliver_to, iri.req_token,
15: iri.http_host, ipss.callback_URL
16: FROM icx_procurement_server_setup ipss,
17: icx_sessions ics, fnd_user fu,
18: icx_requisitioner_info iri,
19: icx_por_item_sources it
20: WHERE ics.disabled_flag = 'N'
21: AND iri.session_id = ics.session_id
22: AND ics.user_id = fu.user_id