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 93: l_supplier_username fnd_user.user_name%type;

89: l_progress varchar2(5) := '000';
90: l_seq number;
91: l_item_key varchar2(2000);
92:
93: l_supplier_username fnd_user.user_name%type;
94: l_requestor_username fnd_user.user_name%type;
95: l_requestor_disp_name varchar2(2000);
96:
97: n_varname Wf_Engine.NameTabTyp;

Line 94: l_requestor_username fnd_user.user_name%type;

90: l_seq number;
91: l_item_key varchar2(2000);
92:
93: l_supplier_username fnd_user.user_name%type;
94: l_requestor_username fnd_user.user_name%type;
95: l_requestor_disp_name varchar2(2000);
96:
97: n_varname Wf_Engine.NameTabTyp;
98: n_varval Wf_Engine.NumTabTyp;

Line 131: from fnd_user

127: l_progress := '003';
128: -- Get Supplier User Name
129: select user_name
130: into l_supplier_username
131: from fnd_user
132: where user_id = fnd_global.user_id;
133:
134: n_varname(1) := 'PO_HEADER_ID';
135: n_varval(1) := p_header_id;

Line 185: l_supplier_username fnd_user.user_name%type;

181: l_progress varchar2(5) := '000';
182: l_seq number;
183: l_item_key varchar2(2000);
184:
185: l_supplier_username fnd_user.user_name%type;
186: l_planner_username fnd_user.user_name%type;
187: l_planner_disp_name varchar2(2000);
188: l_type_lookup_code po_headers_all.type_lookup_code%type;
189:

Line 186: l_planner_username fnd_user.user_name%type;

182: l_seq number;
183: l_item_key varchar2(2000);
184:
185: l_supplier_username fnd_user.user_name%type;
186: l_planner_username fnd_user.user_name%type;
187: l_planner_disp_name varchar2(2000);
188: l_type_lookup_code po_headers_all.type_lookup_code%type;
189:
190: n_varname Wf_Engine.NameTabTyp;

Line 225: from fnd_user

221: l_progress := '003';
222: -- Get Supplier User Name
223: select user_name
224: into l_supplier_username
225: from fnd_user
226: where user_id = fnd_global.user_id;
227:
228:
229: n_varname(1) := 'PO_HEADER_ID';

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

838: -- l_Acceptance_Lookup_Code varchar2(25);
839: l_document_id number;
840: l_document_type_code po_document_types_all.DOCUMENT_TYPE_CODE%TYPE;
841: l_acceptance_note PO_ACCEPTANCES.note%TYPE; --bug 2178922
842: l_rspndr_usr_name fnd_user.user_name%TYPE := '';
843: l_accepting_party varchar2(1);
844: begin
845:
846: SELECT po_acceptances_s.nextval into l_Acceptance_id FROM sys.dual;

Line 922: from fnd_user

918: aname => 'SUPPLIER_USER_NAME');
919:
920: begin
921: select user_id into l_Last_Updated_By
922: from fnd_user
923: where user_name = upper(l_rspndr_usr_name);
924: l_accepting_party := 'S';
925: exception when others then
926: --in case of non-isp users there wont be any suppliers

Line 6021: l_supplier_username fnd_user.user_name%TYPE;

6017: l_authorization_status po_headers_all.authorization_status%TYPE;
6018: l_acceptance_required_flag po_headers_all.acceptance_required_flag%TYPE; -- fix for bug 4946410
6019: l_supplier_user_id number;
6020: l_change_request_group_id number;
6021: l_supplier_username fnd_user.user_name%TYPE;
6022: l_blanket_num po_headers_all.segment1%TYPE;
6023: --l_release_num number;
6024: l_release_num po_releases_all.release_num%TYPE;
6025: l_buyer_name hr_all_organization_units_tl.name%TYPE;

Line 6034: l_buyer_username fnd_user.user_name%TYPE;

6030: l_type_lookup_code po_headers_all.type_lookup_code%TYPE;
6031: l_doc_hdr_info varchar2(1000);
6032: l_buyer_agent_id number;
6033: l_responded_by_id number;
6034: l_buyer_username fnd_user.user_name%TYPE;
6035: l_buyer_disp_name varchar2(2000);
6036: l_po_style varchar2(10);
6037: x_return_status varchar2(1);
6038: x_complex_flag varchar2(1);

Line 6115: fnd_user fndu

6111: /* Curosr to get the change_responded by*/
6112: CURSOR getChangeRespBy(l_chg_req_grp_id_csr IN NUMBER) IS
6113: SELECT distinct fndu.employee_id
6114: FROM po_change_requests pcr,
6115: fnd_user fndu
6116: WHERE pcr.change_request_group_id = l_chg_req_grp_id_csr
6117: AND fndu.user_id = pcr.responded_by;
6118:
6119: BEGIN

Line 6351: from fnd_user

6347: l_change_request_group_id;
6348: exit when l_get_user_list_csr%NOTFOUND;
6349: select user_name
6350: INTO l_user_name
6351: from fnd_user
6352: where user_id = l_supplier_user_id;
6353: l_users(u1) := l_user_name;
6354: u1 := u1 + 1;
6355: end loop;

Line 6422: from fnd_user

6418:
6419: /*
6420: select user_name
6421: into l_supplier_username
6422: from fnd_user
6423: where user_id = l_supplier_user_id;
6424: */
6425:
6426: /*Following code creates and Adhoc role for all the supplier users who have done

Line 6842: l_supplier_username fnd_user.user_name%TYPE;

6838: l_api_name varchar2(50) := 'NotifySupAllChgRpdWF';
6839: l_progress varchar2(100) := '000';
6840: l_item_key varchar2(2000);
6841: l_seq number;
6842: l_supplier_username fnd_user.user_name%TYPE;
6843: l_notification_subject varchar2(2000);
6844:
6845: --l_po_num po_headers_all.segment1%TYPE;
6846: --l_blanket_num po_headers_all.segment1%TYPE;

Line 6853: l_buyer_username fnd_user.user_name%TYPE;

6849: --l_type_lookup_code po_headers_all.type_lookup_code%TYPE;
6850: --l_document_type varchar2(2000);
6851: l_buyer_agent_id number;
6852: l_responded_by_id number;
6853: l_buyer_username fnd_user.user_name%TYPE;
6854: l_buyer_disp_name varchar2(2000);
6855: --l_doc_type po_document_types_all.document_type_code%TYPE;
6856: l_document_id number;
6857: l_po_style varchar2(10);

Line 6882: fnd_user fndu

6878: /* Curosr to get the change_responded by*/
6879: CURSOR getChangeRespBy(l_chg_req_grp_id_csr IN NUMBER) IS
6880: SELECT distinct fndu.employee_id
6881: FROM po_change_requests pcr,
6882: fnd_user fndu
6883: WHERE pcr.change_request_group_id = l_chg_req_grp_id_csr
6884: AND fndu.user_id = pcr.responded_by;
6885:
6886:

Line 6927: from fnd_user

6923: where change_request_group_id = p_chg_req_grp_id;
6924:
6925: select user_name
6926: into l_supplier_username
6927: from fnd_user
6928: where user_id = l_supplier_user_id;
6929: end if;
6930:
6931: /* Bug 4949617 get the reponded_by id from po_change_requests table */

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

7265:
7266: l_employee_id := l_agent_id;
7267: if (p_user_id is not null) then
7268: begin
7269: select employee_id into l_employee_id from fnd_user where user_id = p_user_id;
7270: exception when others then
7271: null;
7272: end;
7273: end if;

Line 7716: l_buyer_username fnd_user.user_name%TYPE;

7712: l_item_key po_change_requests.wf_item_key%TYPE;
7713: l_doc_type_code varchar2(1);
7714: l_buyer_notif_code varchar2(240);
7715: l_buyer_agent_id number;
7716: l_buyer_username fnd_user.user_name%TYPE;
7717: l_supplier_username fnd_user.user_name%TYPE;
7718: l_buyer_disp_name varchar2(2000);
7719: n_varname Wf_Engine.NameTabTyp;
7720: n_varval Wf_Engine.NumTabTyp;

Line 7717: l_supplier_username fnd_user.user_name%TYPE;

7713: l_doc_type_code varchar2(1);
7714: l_buyer_notif_code varchar2(240);
7715: l_buyer_agent_id number;
7716: l_buyer_username fnd_user.user_name%TYPE;
7717: l_supplier_username fnd_user.user_name%TYPE;
7718: l_buyer_disp_name varchar2(2000);
7719: n_varname Wf_Engine.NameTabTyp;
7720: n_varval Wf_Engine.NumTabTyp;
7721: t_varname Wf_Engine.NameTabTyp;

Line 7757: from fnd_user

7753:
7754: -- Get Supplier User Name
7755: select user_name
7756: into l_supplier_username
7757: from fnd_user
7758: where user_id = fnd_global.user_id;
7759:
7760: wf_engine.SetItemAttrText(itemtype => 'POSCHORD',
7761: itemkey => l_item_key,

Line 7901: fnd_user fu

7897: select fr.responsibility_id,fu.user_id
7898: from wf_local_user_roles wur,
7899: fnd_responsibility fr,
7900: financials_system_params_all fsp,
7901: fnd_user fu
7902: where wur.user_name = fu.user_name
7903: and wur.role_orig_system = 'FND_RESP'
7904: and wur.role_orig_system_id = fr.responsibility_id
7905: and wur.partition_id = 2

Line 7926: SELECT FND.user_id

7922:
7923:
7924: BEGIN
7925: begin
7926: SELECT FND.user_id
7927: INTO l_user_id
7928: FROM FND_USER FND, HR_EMPLOYEES_CURRENT_V HR
7929: WHERE HR.EMPLOYEE_ID = p_employee_id
7930: AND FND.EMPLOYEE_ID = HR.EMPLOYEE_ID

Line 7928: FROM FND_USER FND, HR_EMPLOYEES_CURRENT_V HR

7924: BEGIN
7925: begin
7926: SELECT FND.user_id
7927: INTO l_user_id
7928: FROM FND_USER FND, HR_EMPLOYEES_CURRENT_V HR
7929: WHERE HR.EMPLOYEE_ID = p_employee_id
7930: AND FND.EMPLOYEE_ID = HR.EMPLOYEE_ID
7931: AND ROWNUM = 1;
7932:

Line 7950: fnd_user fu

7946: into l_resp_id
7947: from wf_local_user_roles wur,
7948: fnd_responsibility fr,
7949: financials_system_params_all fsp,
7950: fnd_user fu
7951: where wur.user_name = fu.user_name
7952: and fu.user_id = l_user_id
7953: and wur.role_orig_system = 'FND_RESP'
7954: and wur.role_orig_system_id = fr.responsibility_id