1 PACKAGE JTM_NOTES_VUHK AUTHID CURRENT_USER AS
2 /* $Header: jtmhknts.pls 120.1 2005/08/24 02:13:47 saradhak noship $ */
3
4 /*****************************************************************************************
5 This is the Vertical User Hook API.
6 The verticals can add customization procedures here for Pre and Post Processing.
7 ******************************************************************************************/
8
9 /* Verticals Procedure for pre processing in case of create note */
10
11 PROCEDURE create_note_pre
12 ( p_parent_note_id IN NUMBER
13 , p_api_version IN NUMBER
14 , p_init_msg_list IN VARCHAR2
15 , p_commit IN VARCHAR2
16 , p_validation_level IN NUMBER
17 , x_msg_count OUT NOCOPY NUMBER
18 , x_msg_data OUT NOCOPY VARCHAR2
19 , p_org_id IN NUMBER
20 , p_source_object_id IN NUMBER
21 , p_source_object_code IN VARCHAR2
22 , p_notes IN VARCHAR2
23 , p_notes_detail IN VARCHAR2
24 , p_note_status IN VARCHAR2
25 , p_entered_by IN NUMBER
26 , p_entered_date IN DATE
27 , x_jtf_note_id OUT NOCOPY NUMBER
28 , p_last_update_date IN DATE
29 , p_last_updated_by IN NUMBER
30 , p_creation_date IN DATE
31 , p_created_by IN NUMBER
32 , p_last_update_login IN NUMBER
33 , p_attribute1 IN VARCHAR2
34 , p_attribute2 IN VARCHAR2
35 , p_attribute3 IN VARCHAR2
36 , p_attribute4 IN VARCHAR2
37 , p_attribute5 IN VARCHAR2
38 , p_attribute6 IN VARCHAR2
39 , p_attribute7 IN VARCHAR2
40 , p_attribute8 IN VARCHAR2
41 , p_attribute9 IN VARCHAR2
42 , p_attribute10 IN VARCHAR2
43 , p_attribute11 IN VARCHAR2
44 , p_attribute12 IN VARCHAR2
45 , p_attribute13 IN VARCHAR2
46 , p_attribute14 IN VARCHAR2
47 , p_attribute15 IN VARCHAR2
48 , p_context IN VARCHAR2
49 , p_note_type IN VARCHAR2
50 , p_jtf_note_contexts_tab IN jtf_notes_pub.jtf_note_contexts_tbl_type
51 , x_return_status OUT NOCOPY VARCHAR2
52 );
53
54 /* Verticals Procedure for post processing in case of create note */
55
56 PROCEDURE create_note_post
57 ( p_parent_note_id IN NUMBER
58 , p_api_version IN NUMBER
59 , p_init_msg_list IN VARCHAR2
60 , p_commit IN VARCHAR2
61 , p_validation_level IN NUMBER
62 , x_msg_count OUT NOCOPY NUMBER
63 , x_msg_data OUT NOCOPY VARCHAR2
64 , p_org_id IN NUMBER
65 , p_source_object_id IN NUMBER
66 , p_source_object_code IN VARCHAR2
67 , p_notes IN VARCHAR2
68 , p_notes_detail IN VARCHAR2
69 , p_note_status IN VARCHAR2
70 , p_entered_by IN NUMBER
71 , p_entered_date IN DATE
72 , x_jtf_note_id OUT NOCOPY NUMBER
73 , p_last_update_date IN DATE
74 , p_last_updated_by IN NUMBER
75 , p_creation_date IN DATE
76 , p_created_by IN NUMBER
77 , p_last_update_login IN NUMBER
78 , p_attribute1 IN VARCHAR2
79 , p_attribute2 IN VARCHAR2
80 , p_attribute3 IN VARCHAR2
81 , p_attribute4 IN VARCHAR2
82 , p_attribute5 IN VARCHAR2
83 , p_attribute6 IN VARCHAR2
84 , p_attribute7 IN VARCHAR2
85 , p_attribute8 IN VARCHAR2
86 , p_attribute9 IN VARCHAR2
87 , p_attribute10 IN VARCHAR2
88 , p_attribute11 IN VARCHAR2
89 , p_attribute12 IN VARCHAR2
90 , p_attribute13 IN VARCHAR2
91 , p_attribute14 IN VARCHAR2
92 , p_attribute15 IN VARCHAR2
93 , p_context IN VARCHAR2
94 , p_note_type IN VARCHAR2
95 --, p_jtf_note_contexts_tab IN jtf_notes_pub.jtf_note_contexts_tbl_type
96 , x_return_status OUT NOCOPY VARCHAR2
97 , p_jtf_note_id IN NUMBER
98 );
99
100 /* Verticals Procedure for pre processing in case of update note */
101
102 PROCEDURE update_note_pre
103 ( p_api_version IN NUMBER
104 , p_init_msg_list IN VARCHAR2
105 , p_commit IN VARCHAR2
106 , p_validation_level IN NUMBER
107 , x_msg_count OUT NOCOPY NUMBER
108 , x_msg_data OUT NOCOPY VARCHAR2
109 , p_jtf_note_id IN NUMBER
110 , p_entered_by IN NUMBER
111 , p_last_updated_by IN NUMBER
112 , p_last_update_date IN DATE
113 , p_last_update_login IN NUMBER
114 , p_notes IN VARCHAR2
115 , p_notes_detail IN VARCHAR2
116 , p_append_flag IN VARCHAR2
117 , p_note_status IN VARCHAR2
118 , p_note_type IN VARCHAR2
119 --, p_jtf_note_contexts_tab IN jtf_notes_pub.jtf_note_contexts_tbl_type
120 , x_return_status OUT NOCOPY VARCHAR2
121 );
122
123
124 /* Vertical Procedure for post processing in case of update note */
125
126 PROCEDURE update_note_post
127 ( p_api_version IN NUMBER
128 , p_init_msg_list IN VARCHAR2
129 , p_commit IN VARCHAR2
130 , p_validation_level IN NUMBER
131 , x_msg_count OUT NOCOPY NUMBER
132 , x_msg_data OUT NOCOPY VARCHAR2
133 , p_jtf_note_id IN NUMBER
134 , p_entered_by IN NUMBER
135 , p_last_updated_by IN NUMBER
136 , p_last_update_date IN DATE
137 , p_last_update_login IN NUMBER
138 , p_notes IN VARCHAR2
139 , p_notes_detail IN VARCHAR2
140 , p_append_flag IN VARCHAR2
141 , p_note_status IN VARCHAR2
142 , p_note_type IN VARCHAR2
143 --, p_jtf_note_contexts_tab IN jtf_notes_pub.jtf_note_contexts_tbl_type
144 , x_return_status OUT NOCOPY VARCHAR2
145 );
146
147 FUNCTION Ok_to_generate_msg
148 ( p_parent_note_id IN NUMBER
149 , p_api_version IN NUMBER
150 , p_init_msg_list IN VARCHAR2
151 , p_commit IN VARCHAR2
152 , p_validation_level IN NUMBER
153 , x_msg_count OUT NOCOPY NUMBER
154 , x_msg_data OUT NOCOPY VARCHAR2
155 , p_org_id IN NUMBER
156 , p_source_object_id IN NUMBER
157 , p_source_object_code IN VARCHAR2
158 , p_notes IN VARCHAR2
159 , p_notes_detail IN VARCHAR2
160 , p_note_status IN VARCHAR2
161 , p_entered_by IN NUMBER
162 , p_entered_date IN DATE
163 , x_jtf_note_id OUT NOCOPY NUMBER
164 , p_last_update_date IN DATE
165 , p_last_updated_by IN NUMBER
166 , p_creation_date IN DATE
167 , p_created_by IN NUMBER
168 , p_last_update_login IN NUMBER
169 , p_attribute1 IN VARCHAR2
170 , p_attribute2 IN VARCHAR2
171 , p_attribute3 IN VARCHAR2
172 , p_attribute4 IN VARCHAR2
173 , p_attribute5 IN VARCHAR2
174 , p_attribute6 IN VARCHAR2
175 , p_attribute7 IN VARCHAR2
176 , p_attribute8 IN VARCHAR2
177 , p_attribute9 IN VARCHAR2
178 , p_attribute10 IN VARCHAR2
179 , p_attribute11 IN VARCHAR2
180 , p_attribute12 IN VARCHAR2
181 , p_attribute13 IN VARCHAR2
182 , p_attribute14 IN VARCHAR2
183 , p_attribute15 IN VARCHAR2
184 , p_context IN VARCHAR2
185 , p_note_type IN VARCHAR2
186 , p_jtf_note_contexts_tab IN jtf_notes_pub.jtf_note_contexts_tbl_type
187 )RETURN BOOLEAN;
188
189 END jtm_notes_vuhk;