DBA Data[Home] [Help]

APPS.PO_AME_SETUP_PVT dependencies on FND_PROFILE_OPTION_VALUES

Line 70: l_rate_type fnd_profile_option_values.profile_option_value%TYPE;

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
74: SELECT fu.user_id

Line 410: l_option_value fnd_profile_option_values.profile_option_value%TYPE;

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');
414:

Line 569: l_option_value fnd_profile_option_values.profile_option_value%TYPE;

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:
573: -- AME Project

Line 665: l_rate_type fnd_profile_option_values.profile_option_value%TYPE;

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
669: SELECT fu.user_id