APPS.AP_WEB_AUDIT_UTILS dependencies on FND_USER

Line 944: from fnd_user

940: PRAGMA AUTONOMOUS_TRANSACTION;
941:
942: CURSOR emp_cur IS
943: select employee_id
944: from fnd_user
945: where user_id = FND_GLOBAL.USER_ID;
946:
947: CURSOR pref_cur(p_employee_id IN ap_web_preferences.employee_id%TYPE) IS
948: select employee_id, show_audit_header_flag

Line 1025: from ap_web_preferences pref, fnd_user usr

1021: FUNCTION get_show_audit_header_flag RETURN VARCHAR2 IS
1022:
1023: CURSOR pref_cur IS
1024: select pref.employee_id, NVL(pref.show_audit_header_flag, 'Y') show_header_flag
1025: from ap_web_preferences pref, fnd_user usr
1026: where usr.user_id = FND_GLOBAL.USER_ID
1027: and pref.employee_id = usr.employee_id;
1028:
1029: pref_rec pref_cur%ROWTYPE;

Line 1470: from fnd_user usr

1466: select DECODE(usr.user_id,
1467: -1, fnd_message.GET_STRING('SQLAP','OIE_AUD_FALLBACK_AUDITOR'),
1468: NVL(AP_WEB_AUDIT_UTILS.get_employee_info(usr.employee_id,'full_name','VARCHAR2'),
1469: usr.user_name)) auditor_name
1470: from fnd_user usr
1471: where usr.user_id = p_auditor_id;
1472:
1473: auditor_rec auditor_cur%ROWTYPE;
1474: BEGIN

Line 1676: FROM FND_USER u,

1672: FUNCTION get_default_security_profile(p_user_id IN NUMBER) RETURN NUMBER IS
1673:
1674: CURSOR profile_cur IS
1675: SELECT FND_PROFILE.VALUE_SPECIFIC('XLA_MO_SECURITY_PROFILE_LEVEL', u.user_id, r.responsibility_id, 200/*SQLAP*/) security_profile_id
1676: FROM FND_USER u,
1677: FND_USER_RESP_GROUPS g,
1678: FND_RESPONSIBILITY r,
1679: FND_FORM_FUNCTIONS f
1680: WHERE u.user_id = g.user_id

Line 1677: FND_USER_RESP_GROUPS g,

1673:
1674: CURSOR profile_cur IS
1675: SELECT FND_PROFILE.VALUE_SPECIFIC('XLA_MO_SECURITY_PROFILE_LEVEL', u.user_id, r.responsibility_id, 200/*SQLAP*/) security_profile_id
1676: FROM FND_USER u,
1677: FND_USER_RESP_GROUPS g,
1678: FND_RESPONSIBILITY r,
1679: FND_FORM_FUNCTIONS f
1680: WHERE u.user_id = g.user_id
1681: AND u.user_id = p_user_id

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

2495: /*========================================================================
2496: | PUBLIC FUNCTION get_user_name
2497: |
2498: | DESCRIPTION
2499: | This function returns the name for a given FND user.
2500: |
2501: | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
2502: |
2503: | CALLS PROCEDURES/FUNCTIONS (local to this package body)

Line 2506: | Name for a given FND user

2502: |
2503: | CALLS PROCEDURES/FUNCTIONS (local to this package body)
2504: |
2505: | RETURNS
2506: | Name for a given FND user
2507: |
2508: | PARAMETERS
2509: | FND user ID.
2510: |

Line 2509: | FND user ID.

2505: | RETURNS
2506: | Name for a given FND user
2507: |
2508: | PARAMETERS
2509: | FND user ID.
2510: |
2511: | MODIFICATION HISTORY
2512: | Date Author Description of Changes
2513: | 18-Aug-2003 J Rautiainen Created

Line 2522: FROM fnd_user usr

2518: CURSOR user_c IS
2519: SELECT DECODE(usr.employee_id,
2520: null, usr.user_name,
2521: AP_WEB_AUDIT_UTILS.get_employee_info(usr.employee_id,'full_name','VARCHAR2')) last_audited_by_name
2522: FROM fnd_user usr
2523: WHERE usr.user_id = p_user_id;
2524:
2525: user_rec user_c%ROWTYPE;
2526: BEGIN