DBA Data[Home] [Help]

APPS.AP_WEB_AUDIT_UTILS dependencies on FND_GLOBAL

Line 984: where user_id = FND_GLOBAL.USER_ID;

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

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

1015: ) VALUES (
1016: emp_rec.employee_id,
1017: NVL(p_show_header,'Y'),
1018: sysdate, /* last_update_date */
1019: nvl(fnd_global.user_id, -1), /* last_updated_by*/
1020: sysdate, /* creation_date */
1021: nvl(fnd_global.user_id, -1), /* created_by */
1022: fnd_global.conc_login_id /* last_update_login */
1023: );

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

1017: NVL(p_show_header,'Y'),
1018: sysdate, /* last_update_date */
1019: nvl(fnd_global.user_id, -1), /* last_updated_by*/
1020: sysdate, /* creation_date */
1021: nvl(fnd_global.user_id, -1), /* created_by */
1022: fnd_global.conc_login_id /* last_update_login */
1023: );
1024: CLOSE pref_cur;
1025: ELSE

Line 1022: fnd_global.conc_login_id /* last_update_login */

1018: sysdate, /* last_update_date */
1019: nvl(fnd_global.user_id, -1), /* last_updated_by*/
1020: sysdate, /* creation_date */
1021: nvl(fnd_global.user_id, -1), /* created_by */
1022: fnd_global.conc_login_id /* last_update_login */
1023: );
1024: CLOSE pref_cur;
1025: ELSE
1026: UPDATE ap_web_preferences

Line 1065: where usr.user_id = FND_GLOBAL.USER_ID

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