eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_CHANGEORDERWF_PVT dependencies on FND_USER

Line 115: l_supplier_username fnd_user.user_name%type;

111: l_progress varchar2(5) := '000';
112: l_seq number;
113: l_item_key varchar2(2000);
114:
115: l_supplier_username fnd_user.user_name%type;
116: l_requestor_username fnd_user.user_name%type;
117: l_requestor_disp_name varchar2(2000);
118:
119: n_varname Wf_Engine.NameTabTyp;

Line 116: l_requestor_username fnd_user.user_name%type;

112: l_seq number;
113: l_item_key varchar2(2000);
114:
115: l_supplier_username fnd_user.user_name%type;
116: l_requestor_username fnd_user.user_name%type;
117: l_requestor_disp_name varchar2(2000);
118:
119: n_varname Wf_Engine.NameTabTyp;
120: n_varval Wf_Engine.NumTabTyp;

Line 153: from fnd_user

149: l_progress := '003';
150: -- Get Supplier User Name
151: select user_name
152: into l_supplier_username
153: from fnd_user
154: where user_id = fnd_global.user_id;
155:
156: n_varname(1) := 'PO_HEADER_ID';
157: n_varval(1) := p_header_id;

Line 207: l_supplier_username fnd_user.user_name%type;

203: l_progress varchar2(5) := '000';
204: l_seq number;
205: l_item_key varchar2(2000);
206:
207: l_supplier_username fnd_user.user_name%type;
208: l_planner_username fnd_user.user_name%type;
209: l_planner_disp_name varchar2(2000);
210: l_type_lookup_code po_headers_all.type_lookup_code%type;
211:

Line 208: l_planner_username fnd_user.user_name%type;

204: l_seq number;
205: l_item_key varchar2(2000);
206:
207: l_supplier_username fnd_user.user_name%type;
208: l_planner_username fnd_user.user_name%type;
209: l_planner_disp_name varchar2(2000);
210: l_type_lookup_code po_headers_all.type_lookup_code%type;
211:
212: n_varname Wf_Engine.NameTabTyp;

Line 247: from fnd_user

243: l_progress := '003';
244: -- Get Supplier User Name
245: select user_name
246: into l_supplier_username
247: from fnd_user
248: where user_id = fnd_global.user_id;
249:
250:
251: n_varname(1) := 'PO_HEADER_ID';

Line 937: l_rspndr_usr_name fnd_user.user_name%TYPE := '';

933: -- l_Acceptance_Lookup_Code varchar2(25);
934: l_document_id number;
935: l_document_type_code po_document_types_all.DOCUMENT_TYPE_CODE%TYPE;
936: l_acceptance_note PO_ACCEPTANCES.note%TYPE; --bug 2178922
937: l_rspndr_usr_name fnd_user.user_name%TYPE := '';
938: l_accepting_party varchar2(1);
939: begin
940:
941: SELECT po_acceptances_s.nextval into l_Acceptance_id FROM sys.dual;

Line 1017: from fnd_user

1013: aname => 'SUPPLIER_USER_NAME');
1014:
1015: begin
1016: select user_id into l_Last_Updated_By
1017: from fnd_user
1018: where user_name = upper(l_rspndr_usr_name);
1019: l_accepting_party := 'S';
1020: exception when others then
1021: --in case of non-isp users there wont be any suppliers

Line 6179: l_supplier_username fnd_user.user_name%TYPE;

6175: l_authorization_status po_headers_all.authorization_status%TYPE;
6176: l_acceptance_required_flag po_headers_all.acceptance_required_flag%TYPE; -- fix for bug 4946410
6177: l_supplier_user_id number;
6178: l_change_request_group_id number;
6179: l_supplier_username fnd_user.user_name%TYPE;
6180: l_blanket_num po_headers_all.segment1%TYPE;
6181: --l_release_num number;
6182: l_release_num po_releases_all.release_num%TYPE;
6183: l_buyer_name hr_all_organization_units_tl.name%TYPE;

Line 6192: l_buyer_username fnd_user.user_name%TYPE;

6188: l_type_lookup_code po_headers_all.type_lookup_code%TYPE;
6189: l_doc_hdr_info varchar2(1000);
6190: l_buyer_agent_id number;
6191: l_responded_by_id number;
6192: l_buyer_username fnd_user.user_name%TYPE;
6193: l_buyer_disp_name varchar2(2000);
6194: l_po_style varchar2(10);
6195: x_return_status varchar2(1);
6196: x_complex_flag varchar2(1);

Line 6273: fnd_user fndu

6269: /* Curosr to get the change_responded by*/
6270: CURSOR getChangeRespBy(l_chg_req_grp_id_csr IN NUMBER) IS
6271: SELECT distinct fndu.employee_id
6272: FROM po_change_requests pcr,
6273: fnd_user fndu
6274: WHERE pcr.change_request_group_id = l_chg_req_grp_id_csr
6275: AND fndu.user_id = pcr.responded_by;
6276:
6277: BEGIN

Line 6509: from fnd_user

6505: l_change_request_group_id;
6506: exit when l_get_user_list_csr%NOTFOUND;
6507: select user_name
6508: INTO l_user_name
6509: from fnd_user
6510: where user_id = l_supplier_user_id;
6511: l_users(u1) := l_user_name;
6512: u1 := u1 + 1;
6513: end loop;

Line 6580: from fnd_user

6576:
6577: /*
6578: select user_name
6579: into l_supplier_username
6580: from fnd_user
6581: where user_id = l_supplier_user_id;
6582: */
6583:
6584: /*Following code creates and Adhoc role for all the supplier users who have done

Line 7000: l_supplier_username fnd_user.user_name%TYPE;

6996: l_api_name varchar2(50) := 'NotifySupAllChgRpdWF';
6997: l_progress varchar2(100) := '000';
6998: l_item_key varchar2(2000);
6999: l_seq number;
7000: l_supplier_username fnd_user.user_name%TYPE;
7001: l_notification_subject varchar2(2000);
7002:
7003: --l_po_num po_headers_all.segment1%TYPE;
7004: --l_blanket_num po_headers_all.segment1%TYPE;

Line 7011: l_buyer_username fnd_user.user_name%TYPE;

7007: --l_type_lookup_code po_headers_all.type_lookup_code%TYPE;
7008: --l_document_type varchar2(2000);
7009: l_buyer_agent_id number;
7010: l_responded_by_id number;
7011: l_buyer_username fnd_user.user_name%TYPE;
7012: l_buyer_disp_name varchar2(2000);
7013: --l_doc_type po_document_types_all.document_type_code%TYPE;
7014: l_document_id number;
7015: l_po_style varchar2(10);

Line 7040: fnd_user fndu

7036: /* Curosr to get the change_responded by*/
7037: CURSOR getChangeRespBy(l_chg_req_grp_id_csr IN NUMBER) IS
7038: SELECT distinct fndu.employee_id
7039: FROM po_change_requests pcr,
7040: fnd_user fndu
7041: WHERE pcr.change_request_group_id = l_chg_req_grp_id_csr
7042: AND fndu.user_id = pcr.responded_by;
7043:
7044:

Line 7085: from fnd_user

7081: where change_request_group_id = p_chg_req_grp_id;
7082:
7083: select user_name
7084: into l_supplier_username
7085: from fnd_user
7086: where user_id = l_supplier_user_id;
7087: end if;
7088:
7089: /* Bug 4949617 get the reponded_by id from po_change_requests table */

Line 7427: select employee_id into l_employee_id from fnd_user where user_id = p_user_id;

7423:
7424: l_employee_id := l_agent_id;
7425: if (p_user_id is not null) then
7426: begin
7427: select employee_id into l_employee_id from fnd_user where user_id = p_user_id;
7428: exception when others then
7429: null;
7430: end;
7431: end if;

Line 7874: l_buyer_username fnd_user.user_name%TYPE;

7870: l_item_key po_change_requests.wf_item_key%TYPE;
7871: l_doc_type_code varchar2(1);
7872: l_buyer_notif_code varchar2(240);
7873: l_buyer_agent_id number;
7874: l_buyer_username fnd_user.user_name%TYPE;
7875: l_supplier_username fnd_user.user_name%TYPE;
7876: l_buyer_disp_name varchar2(2000);
7877: n_varname Wf_Engine.NameTabTyp;
7878: n_varval Wf_Engine.NumTabTyp;

Line 7875: l_supplier_username fnd_user.user_name%TYPE;

7871: l_doc_type_code varchar2(1);
7872: l_buyer_notif_code varchar2(240);
7873: l_buyer_agent_id number;
7874: l_buyer_username fnd_user.user_name%TYPE;
7875: l_supplier_username fnd_user.user_name%TYPE;
7876: l_buyer_disp_name varchar2(2000);
7877: n_varname Wf_Engine.NameTabTyp;
7878: n_varval Wf_Engine.NumTabTyp;
7879: t_varname Wf_Engine.NameTabTyp;

Line 7915: from fnd_user

7911:
7912: -- Get Supplier User Name
7913: select user_name
7914: into l_supplier_username
7915: from fnd_user
7916: where user_id = fnd_global.user_id;
7917:
7918: wf_engine.SetItemAttrText(itemtype => 'POSCHORD',
7919: itemkey => l_item_key,

Line 8069: fnd_user fu

8065: select fr.responsibility_id,fu.user_id
8066: from wf_local_user_roles wur,
8067: fnd_responsibility fr,
8068: financials_system_params_all fsp,
8069: fnd_user fu
8070: where wur.user_name = fu.user_name
8071: and wur.role_orig_system = 'FND_RESP'
8072: and wur.role_orig_system_id = fr.responsibility_id
8073: and wur.partition_id = 2

Line 8096: SELECT FND.user_id

8092: BEGIN
8093: /* bug 13915321 begin Moving the block here*/
8094: BEGIN
8095: l_progress := '001';
8096: SELECT FND.user_id
8097: INTO l_user_id
8098: FROM FND_USER FND, HR_EMPLOYEES_CURRENT_V HR
8099: WHERE HR.EMPLOYEE_ID = p_employee_id
8100: AND FND.EMPLOYEE_ID = HR.EMPLOYEE_ID

Line 8098: FROM FND_USER FND, HR_EMPLOYEES_CURRENT_V HR

8094: BEGIN
8095: l_progress := '001';
8096: SELECT FND.user_id
8097: INTO l_user_id
8098: FROM FND_USER FND, HR_EMPLOYEES_CURRENT_V HR
8099: WHERE HR.EMPLOYEE_ID = p_employee_id
8100: AND FND.EMPLOYEE_ID = HR.EMPLOYEE_ID
8101: AND ROWNUM = 1;
8102:

Line 8193: fnd_user fu

8189: into l_resp_id
8190: from wf_local_user_roles wur,
8191: fnd_responsibility fr,
8192: financials_system_params_all fsp,
8193: fnd_user fu
8194: where wur.user_name = fu.user_name
8195: and fu.user_id = l_user_id
8196: and wur.role_orig_system = 'FND_RESP'
8197: and wur.role_orig_system_id = fr.responsibility_id

Line 8232: fnd_user fu

8228: into l_resp_id,l_user_id
8229: from wf_local_user_roles wur,
8230: fnd_responsibility fr,
8231: financials_system_params_all fsp,
8232: fnd_user fu
8233: where wur.user_name = fu.user_name
8234: and wur.role_orig_system = 'FND_RESP'
8235: and wur.role_orig_system_id = fr.responsibility_id
8236: and wur.partition_id = 2

Line 8710: l_responder_id fnd_user.user_id%TYPE;

8706: l_current_recipient_id wf_roles.orig_system_id%TYPE;
8707: l_origsys wf_roles.orig_system%TYPE;
8708:
8709: -- Declare following context setting variables.
8710: l_responder_id fnd_user.user_id%TYPE;
8711: l_session_user_id NUMBER;
8712: l_session_resp_id NUMBER;
8713: l_session_appl_id NUMBER;
8714: l_preparer_resp_id NUMBER;

Line 8785: FROM fnd_user fu,

8781:
8782:
8783: SELECT fu.USER_ID
8784: INTO l_responder_id
8785: FROM fnd_user fu,
8786: wf_notifications wfn
8787: WHERE wfn.notification_id = l_notification_id
8788: AND wfn.original_recipient = fu.user_name;
8789: