[Home] [Help]
PACKAGE: APPS.AP_NOTES_PUB
Source
1 PACKAGE AP_NOTES_PUB AUTHID CURRENT_USER AS
2 /* $Header: apwnotps.pls 115.0 2003/11/11 19:26:35 vnama noship $ */
3
4 G_ALL_NOTE_TYPES CONSTANT VARCHAR2(30):='ALL_NOTE_TYPES';
5
6 /*===========================================================================*/
7 -- Start of comments
8 --
9 -- API NAME : Create_Note
10 -- TYPE : Public
11 -- PURPOSE : This creates a note
12 -- PRE_REQS : None
13 --
14 -- PARAMETERS :
15 -- IN -
16 -- p_api_version NUMBER Required
17 -- p_init_msg_list VARCHAR2 Optional default = FND_API.G_FALSE
18 -- p_commit VARCHAR2 Optional default = FND_API.G_FALSE
19 -- p_source_object_code VARCHAR2 Required
20 -- p_source_object_id NUMBER Required
21 -- p_note_type VARCHAR2 Required
22 -- p_notes_detail VARCHAR2 Required
23 -- p_entered_by NUMBER Optional default = fnd_global.user_id
24 -- p_entered_date DATE Optional default = sysdate
25 -- p_source_lang VARCHAR2 Optional default = userenv('LANG')
26 -- p_creation_date DATE Optional default = sysdate
27 -- p_created_by NUMBER Optional default = fnd_global.user_id
28 -- p_last_update_date DATE Optional default = sysdate
29 -- p_last_updated_by NUMBER Optional default = fnd_global.user_id
30 -- p_last_update_login NUMBER Optional default = fnd_global.login_id
31 -- OUT -
32 -- x_return_status VARCHAR2(1)
33 -- x_msg_count NUMBER
34 -- x_return_status VARCHAR2(2000)
35 -- IN OUT NO COPY -
36 --
37 -- VERSION :
38 -- Initial version 1.0
39 --
40 -- MODIFICATION HISTORY :
41 -- Date Author Description of Changes
42 -- 11-Nov-2003 V Nama Created
43 --
44 -- NOTES :
45 --
46 -- End of comments
47 /*===========================================================================*/
48 procedure Create_Note (
49 p_api_version IN NUMBER ,
50 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
51 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
52 x_return_status OUT NOCOPY VARCHAR2 ,
53 x_msg_count OUT NOCOPY NUMBER ,
54 x_msg_data OUT NOCOPY VARCHAR2 ,
55 p_source_object_code IN VARCHAR2 ,
56 p_source_object_id IN NUMBER ,
57 p_note_type IN VARCHAR2 ,
58 p_notes_detail IN VARCHAR2 ,
59 p_entered_by IN NUMBER := fnd_global.user_id ,
60 p_entered_date IN DATE := sysdate ,
61 p_source_lang IN VARCHAR2 := userenv('LANG') ,
62 p_creation_date IN DATE := sysdate ,
63 p_created_by IN NUMBER := fnd_global.user_id ,
64 p_last_update_date IN DATE := sysdate ,
65 p_last_updated_by IN NUMBER := fnd_global.user_id ,
66 p_last_update_login IN NUMBER := fnd_global.login_id
67 );
68
69
70
71 /*===========================================================================*/
72 -- Start of comments
73 --
74 -- API NAME : Delete_Notes
75 -- TYPE : Public
76 -- PURPOSE : This deletes all notes associated to a particular
77 -- source object and note type. If the note type value
78 -- isnt passed the default action is to delete all
79 -- notes irrespective of their note types.
80 -- PRE_REQS : None
81 --
82 -- PARAMETERS :
83 -- IN -
84 -- p_api_version NUMBER Required
85 -- p_init_msg_list VARCHAR2 Optional default = FND_API.G_FALSE
86 -- p_commit VARCHAR2 Optional default = FND_API.G_FALSE
87 -- p_source_object_code VARCHAR2 Required
88 -- p_source_object_id NUMBER Required
89 -- p_note_type VARCHAR2 Optional default = G_ALL_NOTE_TYPES
90 -- OUT -
91 -- x_return_status VARCHAR2(1)
92 -- x_msg_count NUMBER
93 -- x_return_status VARCHAR2(2000)
94 -- IN OUT NO COPY -
95 --
96 -- VERSION :
97 -- Initial version 1.0
98 --
99 -- MODIFICATION HISTORY :
100 -- Date Author Description of Changes
101 -- 11-Nov-2003 V Nama Created
102 --
103 -- NOTES :
104 --
105 -- End of comments
106 /*===========================================================================*/
107 procedure Delete_Notes (
108 p_api_version IN NUMBER ,
109 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
110 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
111 x_return_status OUT NOCOPY VARCHAR2 ,
112 x_msg_count OUT NOCOPY NUMBER ,
113 x_msg_data OUT NOCOPY VARCHAR2 ,
114 p_source_object_code IN VARCHAR2 ,
115 p_source_object_id IN NUMBER ,
116 p_note_type IN VARCHAR2 := G_ALL_NOTE_TYPES
117 );
118
119
120
121 /*===========================================================================*/
122 -- Start of comments
123 --
124 -- API NAME : Copy_Notes
125 -- TYPE : Public
126 -- PURPOSE : This copies all notes associated to a particular
127 -- source object into new notes associated to another
128 -- source object.
129 -- PRE_REQS : None
130 --
131 -- PARAMETERS :
132 -- IN -
133 -- p_api_version NUMBER Required
134 -- p_init_msg_list VARCHAR2 Optional default = FND_API.G_FALSE
135 -- p_commit VARCHAR2 Optional default = FND_API.G_FALSE
136 -- p_old_source_object_code VARCHAR2 Required
137 -- p_old_source_object_id NUMBER Required
138 -- p_new_source_object_code VARCHAR2 Required
139 -- p_new_source_object_id NUMBER Required
140 -- OUT -
141 -- x_return_status VARCHAR2(1)
142 -- x_msg_count NUMBER
143 -- x_return_status VARCHAR2(2000)
144 -- IN OUT NO COPY -
145 --
146 -- VERSION :
147 -- Initial version 1.0
148 --
149 -- MODIFICATION HISTORY :
150 -- Date Author Description of Changes
151 -- 11-Nov-2003 V Nama Created
152 --
153 -- NOTES : If the source and destination source objects are
154 -- same, API returns after adding error message
155 -- OIE_NOTES_COPY_ON_ITSELF_ERR to the message list.
156 --
157 -- End of comments
158 /*===========================================================================*/
159 procedure Copy_Notes (
160 p_api_version IN NUMBER ,
161 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
162 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
163 x_return_status OUT NOCOPY VARCHAR2 ,
164 x_msg_count OUT NOCOPY NUMBER ,
165 x_msg_data OUT NOCOPY VARCHAR2 ,
166 p_old_source_object_code IN VARCHAR2 ,
167 p_old_source_object_id IN NUMBER ,
168 p_new_source_object_code IN VARCHAR2 ,
169 p_new_source_object_id IN NUMBER
170 );
171
172
173
174 END AP_NOTES_PUB;