DBA Data[Home] [Help]

APPS.PO_AME_SETUP_PVT dependencies on FND_USER

Line 69: l_user_id fnd_user.user_id%TYPE;

65: --End of Comments
66: -------------------------------------------------------------------------------
67: FUNCTION get_rate_type(reqHeaderId IN NUMBER)
68: RETURN VARCHAR2 IS
69: l_user_id fnd_user.user_id%TYPE;
70: l_rate_type fnd_profile_option_values.profile_option_value%TYPE;
71:
72: BEGIN
73: BEGIN

Line 76: FROM fnd_user fu, po_requisition_headers_all prh

72: BEGIN
73: BEGIN
74: SELECT fu.user_id
75: INTO l_user_id
76: FROM fnd_user fu, po_requisition_headers_all prh
77: WHERE prh.requisition_header_id = reqHeaderId and
78: prh.preparer_id = fu.employee_id;
79: EXCEPTION
80: when others then

Line 307: l_user_id fnd_user.user_id%TYPE;

303: --End of Comments
304: -------------------------------------------------------------------------------
305: FUNCTION is_system_approver_mandatory(reqHeaderId IN NUMBER)
306: RETURN VARCHAR2 IS
307: l_user_id fnd_user.user_id%TYPE;
308: l_option_value fnd_profile_option_values.profile_option_value%TYPE;
309:
310: BEGIN
311: BEGIN

Line 314: FROM fnd_user fu, po_requisition_headers_all prh

310: BEGIN
311: BEGIN
312: SELECT fu.user_id
313: INTO l_user_id
314: FROM fnd_user fu, po_requisition_headers_all prh
315: WHERE prh.requisition_header_id = reqHeaderId and
316: prh.preparer_id = fu.employee_id;
317: EXCEPTION
318: when others then