APPS.AP_WEB_AUDIT_UTILS dependencies on AP_WEB_PREFERENCES

Line 986: CURSOR pref_cur(p_employee_id IN ap_web_preferences.employee_id%TYPE) 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
988: from ap_web_preferences
989: where employee_id = p_employee_id
990: FOR UPDATE OF show_audit_header_flag NOWAIT;

Line 988: from ap_web_preferences

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
988: from ap_web_preferences
989: where employee_id = p_employee_id
990: FOR UPDATE OF show_audit_header_flag NOWAIT;
991:
992: pref_rec pref_cur%ROWTYPE;

Line 1007: INSERT INTO ap_web_preferences(

1003: OPEN pref_cur(emp_rec.employee_id);
1004: FETCH pref_cur INTO pref_rec;
1005:
1006: IF pref_cur%NOTFOUND THEN
1007: INSERT INTO ap_web_preferences(
1008: employee_id,
1009: show_audit_header_flag,
1010: last_update_date,
1011: last_updated_by,

Line 1026: UPDATE ap_web_preferences

1022: fnd_global.conc_login_id /* last_update_login */
1023: );
1024: CLOSE pref_cur;
1025: ELSE
1026: UPDATE ap_web_preferences
1027: SET show_audit_header_flag = NVL(p_show_header,'Y')
1028: WHERE CURRENT OF pref_cur;
1029: CLOSE pref_cur;
1030: END IF;

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;