DBA Data[Home] [Help]

APPS.PO_CHG_REQUEST_GRP dependencies on FND_USER

Line 1414: from fnd_user

1410: --ideally we should check if the requestor belongs to the tp_id and tp_site_id provided.
1411: begin
1412: select user_id
1413: into l_user_id
1414: from fnd_user
1415: where user_name = p_requestor; --ideally it should be 'XML_USER'
1416: exception when others then
1417: /*
1418: PO_CHN_XML_USER_INVALID = "The USERNAME is not a valid user

Line 1948: from fnd_user

1944: l_po_release_id := g_po_change_table(g_po_change_table.FIRST).PO_Release_Id;
1945: l_revision_num := g_po_change_table(g_po_change_table.FIRST).Document_Revision_Num;
1946: select user_id
1947: into l_user_id
1948: from fnd_user
1949: where user_name = g_requestor;
1950:
1951: --dbms_output.put_line('x_error_status_out inside3 : ' || x_error_status_out);
1952: PO_CHG_REQUEST_PVT.process_supplier_request (

Line 2093: from fnd_user

2089: -- Bug 7287009 - End
2090:
2091: select to_char(user_id)
2092: into l_user_id
2093: from fnd_user
2094: where user_name = p_requestor;
2095:
2096: if (p_po_type = 'RELEASE') then
2097: select to_char(po_release_id), to_char(agent_id), LAST_UPDATE_DATE