1 PACKAGE CAC_NOTES_PVT AUTHID CURRENT_USER AS
2 /* $Header: cacvnts.pls 115.2 2003/10/21 23:47:28 akaran noship $ */
3
4 PROCEDURE create_note
5 ------------------------------------------------------------------------------
6 -- Create_note
7 -- Inserts a note record in the JTF_NOTES_B, JTF_NOTES_TL tables
8 ------------------------------------------------------------------------------
9 ( p_jtf_note_id IN NUMBER := NULL
10 , p_source_object_id IN NUMBER
11 , p_source_object_code IN VARCHAR2
12 , p_notes IN VARCHAR2
13 , p_notes_detail IN CLOB := NULL
14 , p_note_status IN VARCHAR2 := NULL
15 , p_note_type IN VARCHAR2 := NULL
16 , p_attribute1 IN VARCHAR2 := NULL
17 , p_attribute2 IN VARCHAR2 := NULL
18 , p_attribute3 IN VARCHAR2 := NULL
19 , p_attribute4 IN VARCHAR2 := NULL
20 , p_attribute5 IN VARCHAR2 := NULL
21 , p_attribute6 IN VARCHAR2 := NULL
22 , p_attribute7 IN VARCHAR2 := NULL
23 , p_attribute8 IN VARCHAR2 := NULL
24 , p_attribute9 IN VARCHAR2 := NULL
25 , p_attribute10 IN VARCHAR2 := NULL
26 , p_attribute11 IN VARCHAR2 := NULL
27 , p_attribute12 IN VARCHAR2 := NULL
28 , p_attribute13 IN VARCHAR2 := NULL
29 , p_attribute14 IN VARCHAR2 := NULL
30 , p_attribute15 IN VARCHAR2 := NULL
31 , p_parent_note_id IN NUMBER := NULL
32 , p_entered_date IN DATE := NULL
33 , p_entered_by IN NUMBER := NULL
34 , p_creation_date IN DATE := NULL
35 , p_created_by IN NUMBER := NULL
36 , p_last_update_date IN DATE := NULL
37 , p_last_updated_by IN NUMBER := NULL
38 , p_last_update_login IN NUMBER := NULL
39 , x_jtf_note_id OUT NOCOPY NUMBER
40 , x_return_status OUT NOCOPY VARCHAR2
41 , x_msg_count OUT NOCOPY NUMBER
42 , x_msg_data OUT NOCOPY VARCHAR2
43 );
44
45
46 PROCEDURE update_note
47 ------------------------------------------------------------------------------
48 -- Update_note
49 -- Updates a note record in the JTF_NOTES_B, JTF_NOTES_TL tables
50 ------------------------------------------------------------------------------
51 ( p_jtf_note_id IN NUMBER
52 , p_notes IN VARCHAR2 := NULL
53 , p_notes_detail IN CLOB := NULL
54 , p_note_status IN VARCHAR2 := NULL
55 , p_note_type IN VARCHAR2 := NULL
56 , p_attribute1 IN VARCHAR2 := NULL
57 , p_attribute2 IN VARCHAR2 := NULL
58 , p_attribute3 IN VARCHAR2 := NULL
59 , p_attribute4 IN VARCHAR2 := NULL
60 , p_attribute5 IN VARCHAR2 := NULL
61 , p_attribute6 IN VARCHAR2 := NULL
62 , p_attribute7 IN VARCHAR2 := NULL
63 , p_attribute8 IN VARCHAR2 := NULL
64 , p_attribute9 IN VARCHAR2 := NULL
65 , p_attribute10 IN VARCHAR2 := NULL
66 , p_attribute11 IN VARCHAR2 := NULL
67 , p_attribute12 IN VARCHAR2 := NULL
68 , p_attribute13 IN VARCHAR2 := NULL
69 , p_attribute14 IN VARCHAR2 := NULL
70 , p_attribute15 IN VARCHAR2 := NULL
71 , p_parent_note_id IN NUMBER := NULL
72 , p_last_update_date IN DATE := NULL
73 , p_last_updated_by IN NUMBER := NULL
74 , p_last_update_login IN NUMBER := NULL
75 , x_return_status OUT NOCOPY VARCHAR2
76 , x_msg_count OUT NOCOPY NUMBER
77 , x_msg_data OUT NOCOPY VARCHAR2
78 );
79
80 PROCEDURE delete_note
81 ------------------------------------------------------------------------------
82 -- delete_note
83 -- deletes a note record in the JTF_NOTES_B, JTF_NOTES_TL tables
84 ------------------------------------------------------------------------------
85 ( p_jtf_note_id IN NUMBER
86 , x_return_status OUT NOCOPY VARCHAR2
87 , x_msg_count OUT NOCOPY NUMBER
88 , x_msg_data OUT NOCOPY VARCHAR2
89 );
90
91 PROCEDURE create_note_context
92 ------------------------------------------------------------------------------
93 -- create_note_context
94 -- creates a record in the JTF_NOTE_CONTEXTS table.
95 ------------------------------------------------------------------------------
96 ( p_note_context_id IN NUMBER
97 , p_jtf_note_id IN NUMBER
98 , p_note_context_type IN VARCHAR2
99 , p_note_context_type_id IN NUMBER
100 , p_creation_date IN DATE := NULL
101 , p_created_by IN NUMBER := NULL
102 , p_last_update_date IN DATE := NULL
103 , p_last_updated_by IN NUMBER := NULL
104 , p_last_update_login IN NUMBER := NULL
105 , x_note_context_id OUT NOCOPY NUMBER
106 , x_return_status OUT NOCOPY VARCHAR2
107 , x_msg_count OUT NOCOPY NUMBER
108 , x_msg_data OUT NOCOPY VARCHAR2
109 );
110
111 PROCEDURE update_note_context
112 ------------------------------------------------------------------------------
113 -- update_note_context
114 -- updates a record in the JTF_NOTE_CONTEXTS table.
115 ------------------------------------------------------------------------------
116 ( p_note_context_id IN NUMBER
117 , p_jtf_note_id IN NUMBER := NULL
118 , p_note_context_type IN VARCHAR2 := NULL
119 , p_note_context_type_id IN NUMBER := NULL
120 , p_last_update_date IN DATE := NULL
121 , p_last_updated_by IN NUMBER := NULL
122 , p_last_update_login IN NUMBER := NULL
123 , x_return_status OUT NOCOPY VARCHAR2
124 , x_msg_count OUT NOCOPY NUMBER
125 , x_msg_data OUT NOCOPY VARCHAR2
126 );
127
128 PROCEDURE delete_note_context
129 ------------------------------------------------------------------------------
130 -- delete_note_context
131 -- deletes a record in the JTF_NOTE_CONTEXTS table.
132 ------------------------------------------------------------------------------
133 ( p_note_context_id IN NUMBER
134 , x_return_status OUT NOCOPY VARCHAR2
135 , x_msg_count OUT NOCOPY NUMBER
136 , x_msg_data OUT NOCOPY VARCHAR2
137 );
138
139 FUNCTION GET_ENTERED_BY_NAME
140 /*******************************************************************************
141 ** Given a USER_ID the function will return the username/partyname. This
142 ** Function is used to display the CREATED_BY who column information on JTF
143 ** transaction pages.
144 *******************************************************************************/
145 (p_user_id IN NUMBER
146 )RETURN VARCHAR2;
147
148 END CAC_NOTES_PVT;