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