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 409: l_user_id fnd_user.user_id%TYPE;

405: --End of Comments
406: -------------------------------------------------------------------------------
407: FUNCTION is_system_approver_mandatory(reqHeaderId IN NUMBER)
408: RETURN VARCHAR2 IS
409: l_user_id fnd_user.user_id%TYPE;
410: l_option_value fnd_profile_option_values.profile_option_value%TYPE;
411: BEGIN
412:
413: l_option_value:= fnd_profile.VALUE_SPECIFIC('POR_SYS_GENERATED_APPROVERS_SUPPRESS');

Line 429: FROM fnd_user fu, po_requisition_headers_all prh

425:
426: BEGIN
427: SELECT fu.user_id
428: INTO l_user_id
429: FROM fnd_user fu, po_requisition_headers_all prh
430: WHERE prh.requisition_header_id = reqHeaderId and
431: prh.preparer_id = fu.employee_id;
432: EXCEPTION
433: when others then

Line 568: l_user_id fnd_user.user_id%TYPE;

564: --End of Comments
565: -------------------------------------------------------------------------------
566: FUNCTION is_system_app_mandatory_po(ameApprovalId IN NUMBER)
567: RETURN VARCHAR2 IS
568: l_user_id fnd_user.user_id%TYPE;
569: l_option_value fnd_profile_option_values.profile_option_value%TYPE;
570:
571: BEGIN
572:

Line 583: FROM fnd_user fu, po_headers_merge_v phm

579:
580: BEGIN
581: SELECT fu.user_id
582: INTO l_user_id
583: FROM fnd_user fu, po_headers_merge_v phm
584: WHERE phm.ame_approval_id = ameApprovalId and
585: phm.agent_id = fu.employee_id;
586: EXCEPTION
587: when others then

Line 664: l_user_id fnd_user.user_id%TYPE;

660: --End of Comments
661: -------------------------------------------------------------------------------
662: FUNCTION get_rate_type_po(ameApprovalId IN NUMBER)
663: RETURN VARCHAR2 IS
664: l_user_id fnd_user.user_id%TYPE;
665: l_rate_type fnd_profile_option_values.profile_option_value%TYPE;
666:
667: BEGIN
668: BEGIN

Line 671: FROM fnd_user fu, po_headers_merge_v phm

667: BEGIN
668: BEGIN
669: SELECT fu.user_id
670: INTO l_user_id
671: FROM fnd_user fu, po_headers_merge_v phm
672: WHERE phm.ame_approval_id = ameApprovalId and
673: phm.agent_id = fu.employee_id;
674: EXCEPTION
675: when others then