APPS.POS_ADDRESS_NOTES_PKG dependencies on POS_ADDRESS_NOTES

Line 1: package body POS_ADDRESS_NOTES_PKG as

1: package body POS_ADDRESS_NOTES_PKG as
2: /* $Header: POSANOTB.pls 120.1 2005/07/28 18:03:22 bitang noship $ */
3:
4: procedure insert_note(
5: p_party_site_id IN NUMBER,

Line 11: INSERT INTO pos_address_notes(

7: x_status OUT NOCOPY VARCHAR2,
8: x_exception_msg OUT NOCOPY VARCHAR2)
9: IS
10: BEGIN
11: INSERT INTO pos_address_notes(
12: party_site_id,
13: notes,
14: created_by,
15: creation_date,

Line 43: FROM pos_address_notes

39: l_count_dup NUMBER;
40: BEGIN
41: SELECT count(*)
42: INTO l_count_dup
43: FROM pos_address_notes
44: WHERE party_site_id = p_party_site_id
45: AND ROWNUM < 2;
46:
47: IF (l_count_dup = 0) THEN

Line 52: UPDATE pos_address_notes

48: insert_note(p_party_site_id, p_note, x_status, x_exception_msg);
49: RETURN;
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

Line 70: DELETE FROM pos_address_notes

66: x_status OUT NOCOPY VARCHAR2,
67: x_exception_msg OUT NOCOPY VARCHAR2)
68: IS
69: BEGIN
70: DELETE FROM pos_address_notes
71: WHERE party_site_id = p_party_site_id;
72:
73: x_status := 'S';
74:

Line 77: END POS_ADDRESS_NOTES_PKG;

73: x_status := 'S';
74:
75: END delete_note;
76:
77: END POS_ADDRESS_NOTES_PKG;