18: last_update_login
19: )VALUES(
20: p_party_site_id,
21: p_note,
22: fnd_global.user_id,
23: SYSDATE,
24: SYSDATE,
25: fnd_global.user_id,
26: fnd_global.login_id
21: p_note,
22: fnd_global.user_id,
23: SYSDATE,
24: SYSDATE,
25: fnd_global.user_id,
26: fnd_global.login_id
27: );
28:
29: x_status := 'S';
22: fnd_global.user_id,
23: SYSDATE,
24: SYSDATE,
25: fnd_global.user_id,
26: fnd_global.login_id
27: );
28:
29: x_status := 'S';
30:
50: END IF;
51:
52: UPDATE pos_address_notes
53: SET notes = p_note,
54: last_updated_by = fnd_global.user_id,
55: last_update_date = SYSDATE,
56: last_update_login = fnd_global.login_id
57: WHERE party_site_id = p_party_site_id;
58:
52: UPDATE pos_address_notes
53: SET notes = p_note,
54: last_updated_by = fnd_global.user_id,
55: last_update_date = SYSDATE,
56: last_update_login = fnd_global.login_id
57: WHERE party_site_id = p_party_site_id;
58:
59: x_status := 'S';
60: