APPS.PO_AME_SETUP_PVT dependencies on FND_PROFILE

Line 4: g_fnd_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');

1: PACKAGE BODY PO_AME_SETUP_PVT AS
2: /* $Header: POXAMESB.pls 120.1 2005/06/29 18:28:33 shsiung noship $*/
3:
4: g_fnd_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
5:
6: --------------------------------------------------------------------------------
7: --Start of Comments
8: --Name: get_function_currency

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 81: fnd_profile.get('POR_DEFAULT_RATE_TYPE', l_rate_type);

77: WHERE prh.requisition_header_id = reqHeaderId and
78: prh.preparer_id = fu.employee_id;
79: EXCEPTION
80: when others then
81: fnd_profile.get('POR_DEFAULT_RATE_TYPE', l_rate_type);
82: RETURN l_rate_type;
83: END;
84: l_rate_type := fnd_profile.value_specific('POR_DEFAULT_RATE_TYPE', l_user_id);
85: RETURN l_rate_type;

Line 84: l_rate_type := fnd_profile.value_specific('POR_DEFAULT_RATE_TYPE', l_user_id);

80: when others then
81: fnd_profile.get('POR_DEFAULT_RATE_TYPE', l_rate_type);
82: RETURN l_rate_type;
83: END;
84: l_rate_type := fnd_profile.value_specific('POR_DEFAULT_RATE_TYPE', l_user_id);
85: RETURN l_rate_type;
86: EXCEPTION
87: when others then
88: raise;

Line 308: l_option_value fnd_profile_option_values.profile_option_value%TYPE;

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

Line 319: fnd_profile.get('POR_SYS_GENERATED_APPROVERS_MANDATORY', l_option_value);

315: WHERE prh.requisition_header_id = reqHeaderId and
316: prh.preparer_id = fu.employee_id;
317: EXCEPTION
318: when others then
319: fnd_profile.get('POR_SYS_GENERATED_APPROVERS_MANDATORY', l_option_value);
320: RETURN l_option_value;
321:
322: END;
323: l_option_value := fnd_profile.value_specific('POR_SYS_GENERATED_APPROVERS_MANDATORY', l_user_id);

Line 323: l_option_value := fnd_profile.value_specific('POR_SYS_GENERATED_APPROVERS_MANDATORY', l_user_id);

319: fnd_profile.get('POR_SYS_GENERATED_APPROVERS_MANDATORY', l_option_value);
320: RETURN l_option_value;
321:
322: END;
323: l_option_value := fnd_profile.value_specific('POR_SYS_GENERATED_APPROVERS_MANDATORY', l_user_id);
324:
325: RETURN l_option_value;
326:
327: EXCEPTION