DBA Data[Home] [Help]

APPS.AP_WEB_AUDIT_UTILS dependencies on FND_GLOBAL

Line 945: where user_id = FND_GLOBAL.USER_ID;

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
949: from ap_web_preferences

Line 980: nvl(fnd_global.user_id, -1), /* last_updated_by*/

976: ) VALUES (
977: emp_rec.employee_id,
978: NVL(p_show_header,'Y'),
979: sysdate, /* last_update_date */
980: nvl(fnd_global.user_id, -1), /* last_updated_by*/
981: sysdate, /* creation_date */
982: nvl(fnd_global.user_id, -1), /* created_by */
983: fnd_global.conc_login_id /* last_update_login */
984: );

Line 982: nvl(fnd_global.user_id, -1), /* created_by */

978: NVL(p_show_header,'Y'),
979: sysdate, /* last_update_date */
980: nvl(fnd_global.user_id, -1), /* last_updated_by*/
981: sysdate, /* creation_date */
982: nvl(fnd_global.user_id, -1), /* created_by */
983: fnd_global.conc_login_id /* last_update_login */
984: );
985: CLOSE pref_cur;
986: ELSE

Line 983: fnd_global.conc_login_id /* last_update_login */

979: sysdate, /* last_update_date */
980: nvl(fnd_global.user_id, -1), /* last_updated_by*/
981: sysdate, /* creation_date */
982: nvl(fnd_global.user_id, -1), /* created_by */
983: fnd_global.conc_login_id /* last_update_login */
984: );
985: CLOSE pref_cur;
986: ELSE
987: UPDATE ap_web_preferences

Line 1026: where usr.user_id = FND_GLOBAL.USER_ID

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;
1030: