APPS.AP_WEB_AUDIT_UTILS dependencies on FND_USER

Line 983: from fnd_user

979: PRAGMA AUTONOMOUS_TRANSACTION;
980:
981: CURSOR emp_cur IS
982: select employee_id
983: from fnd_user
984: where user_id = FND_GLOBAL.USER_ID;
985:
986: CURSOR pref_cur(p_employee_id IN ap_web_preferences.employee_id%TYPE) IS
987: select employee_id, show_audit_header_flag

Line 1064: from ap_web_preferences pref, fnd_user usr

1060: FUNCTION get_show_audit_header_flag RETURN VARCHAR2 IS
1061:
1062: CURSOR pref_cur IS
1063: select pref.employee_id, NVL(pref.show_audit_header_flag, 'Y') show_header_flag
1064: from ap_web_preferences pref, fnd_user usr
1065: where usr.user_id = FND_GLOBAL.USER_ID
1066: and pref.employee_id = usr.employee_id;
1067:
1068: pref_rec pref_cur%ROWTYPE;

Line 1509: from fnd_user usr

1505: select DECODE(usr.user_id,
1506: -1, fnd_message.GET_STRING('SQLAP','OIE_AUD_FALLBACK_AUDITOR'),
1507: NVL(AP_WEB_AUDIT_UTILS.get_employee_info(usr.employee_id,'full_name','VARCHAR2'),
1508: usr.user_name)) auditor_name
1509: from fnd_user usr
1510: where usr.user_id = p_auditor_id;
1511:
1512: auditor_rec auditor_cur%ROWTYPE;
1513: BEGIN

Line 1718: FROM FND_USER u,

1714: FUNCTION get_default_security_profile(p_user_id IN NUMBER) RETURN NUMBER IS
1715:
1716: CURSOR profile_cur IS
1717: SELECT FND_PROFILE.VALUE_SPECIFIC('XLA_MO_SECURITY_PROFILE_LEVEL', u.user_id, r.responsibility_id, 200/*SQLAP*/) security_profile_id
1718: FROM FND_USER u,
1719: FND_USER_RESP_GROUPS g,
1720: FND_RESPONSIBILITY r,
1721: FND_FORM_FUNCTIONS f
1722: WHERE u.user_id = g.user_id

Line 1719: FND_USER_RESP_GROUPS g,

1715:
1716: CURSOR profile_cur IS
1717: SELECT FND_PROFILE.VALUE_SPECIFIC('XLA_MO_SECURITY_PROFILE_LEVEL', u.user_id, r.responsibility_id, 200/*SQLAP*/) security_profile_id
1718: FROM FND_USER u,
1719: FND_USER_RESP_GROUPS g,
1720: FND_RESPONSIBILITY r,
1721: FND_FORM_FUNCTIONS f
1722: WHERE u.user_id = g.user_id
1723: AND u.user_id = p_user_id

Line 2541: | This function returns the name for a given FND user.

2537: /*========================================================================
2538: | PUBLIC FUNCTION get_user_name
2539: |
2540: | DESCRIPTION
2541: | This function returns the name for a given FND user.
2542: |
2543: | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
2544: |
2545: | CALLS PROCEDURES/FUNCTIONS (local to this package body)

Line 2548: | Name for a given FND user

2544: |
2545: | CALLS PROCEDURES/FUNCTIONS (local to this package body)
2546: |
2547: | RETURNS
2548: | Name for a given FND user
2549: |
2550: | PARAMETERS
2551: | FND user ID.
2552: |

Line 2551: | FND user ID.

2547: | RETURNS
2548: | Name for a given FND user
2549: |
2550: | PARAMETERS
2551: | FND user ID.
2552: |
2553: | MODIFICATION HISTORY
2554: | Date Author Description of Changes
2555: | 18-Aug-2003 J Rautiainen Created

Line 2564: FROM fnd_user usr

2560: CURSOR user_c IS
2561: SELECT DECODE(usr.employee_id,
2562: null, usr.user_name,
2563: AP_WEB_AUDIT_UTILS.get_employee_info(usr.employee_id,'full_name','VARCHAR2')) last_audited_by_name
2564: FROM fnd_user usr
2565: WHERE usr.user_id = p_user_id;
2566:
2567: user_rec user_c%ROWTYPE;
2568: BEGIN