10:
11: PROCEDURE create_note_pre
12: ( p_parent_note_id IN NUMBER DEFAULT NULL
13: , p_api_version IN NUMBER
14: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
15: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
16: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
17: , x_msg_count OUT NOCOPY NUMBER
18: , x_msg_data OUT NOCOPY VARCHAR2
11: PROCEDURE create_note_pre
12: ( p_parent_note_id IN NUMBER DEFAULT NULL
13: , p_api_version IN NUMBER
14: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
15: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
16: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
17: , x_msg_count OUT NOCOPY NUMBER
18: , x_msg_data OUT NOCOPY VARCHAR2
19: , p_org_id IN NUMBER DEFAULT NULL
12: ( p_parent_note_id IN NUMBER DEFAULT NULL
13: , p_api_version IN NUMBER
14: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
15: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
16: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
17: , x_msg_count OUT NOCOPY NUMBER
18: , x_msg_data OUT NOCOPY VARCHAR2
19: , p_org_id IN NUMBER DEFAULT NULL
20: , p_source_object_id IN NUMBER
58:
59: PROCEDURE create_note_post
60: ( p_parent_note_id IN NUMBER DEFAULT NULL
61: , p_api_version IN NUMBER
62: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
63: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
64: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
65: , x_msg_count OUT NOCOPY NUMBER
66: , x_msg_data OUT NOCOPY VARCHAR2
59: PROCEDURE create_note_post
60: ( p_parent_note_id IN NUMBER DEFAULT NULL
61: , p_api_version IN NUMBER
62: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
63: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
64: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
65: , x_msg_count OUT NOCOPY NUMBER
66: , x_msg_data OUT NOCOPY VARCHAR2
67: , p_org_id IN NUMBER DEFAULT NULL
60: ( p_parent_note_id IN NUMBER DEFAULT NULL
61: , p_api_version IN NUMBER
62: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
63: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
64: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
65: , x_msg_count OUT NOCOPY NUMBER
66: , x_msg_data OUT NOCOPY VARCHAR2
67: , p_org_id IN NUMBER DEFAULT NULL
68: , p_source_object_id IN NUMBER
106: update note */
107:
108: PROCEDURE update_note_pre
109: ( p_api_version IN NUMBER
110: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
111: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
112: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
113: , x_msg_count OUT NOCOPY NUMBER
114: , x_msg_data OUT NOCOPY VARCHAR2
107:
108: PROCEDURE update_note_pre
109: ( p_api_version IN NUMBER
110: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
111: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
112: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
113: , x_msg_count OUT NOCOPY NUMBER
114: , x_msg_data OUT NOCOPY VARCHAR2
115: , p_jtf_note_id IN NUMBER
108: PROCEDURE update_note_pre
109: ( p_api_version IN NUMBER
110: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
111: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
112: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
113: , x_msg_count OUT NOCOPY NUMBER
114: , x_msg_data OUT NOCOPY VARCHAR2
115: , p_jtf_note_id IN NUMBER
116: , p_entered_by IN NUMBER
116: , p_entered_by IN NUMBER
117: , p_last_updated_by IN NUMBER
118: , p_last_update_date IN DATE DEFAULT SYSDATE
119: , p_last_update_login IN NUMBER DEFAULT NULL
120: , p_notes IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
121: , p_notes_detail IN VARCHAR2 DEFAULT NULL
122: , p_append_flag IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
123: , p_note_status IN VARCHAR2 DEFAULT 'I'
124: , p_note_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
118: , p_last_update_date IN DATE DEFAULT SYSDATE
119: , p_last_update_login IN NUMBER DEFAULT NULL
120: , p_notes IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
121: , p_notes_detail IN VARCHAR2 DEFAULT NULL
122: , p_append_flag IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
123: , p_note_status IN VARCHAR2 DEFAULT 'I'
124: , p_note_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
125: , p_jtf_note_contexts_tab IN jtf_notes_pub.jtf_note_contexts_tbl_type
126: DEFAULT jtf_notes_pub.jtf_note_contexts_tab_dflt
120: , p_notes IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
121: , p_notes_detail IN VARCHAR2 DEFAULT NULL
122: , p_append_flag IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
123: , p_note_status IN VARCHAR2 DEFAULT 'I'
124: , p_note_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
125: , p_jtf_note_contexts_tab IN jtf_notes_pub.jtf_note_contexts_tbl_type
126: DEFAULT jtf_notes_pub.jtf_note_contexts_tab_dflt
127: , x_return_status OUT NOCOPY VARCHAR2
128: );
132: update note */
133:
134: PROCEDURE update_note_post
135: ( p_api_version IN NUMBER
136: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
137: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
138: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
139: , x_msg_count OUT NOCOPY NUMBER
140: , x_msg_data OUT NOCOPY VARCHAR2
133:
134: PROCEDURE update_note_post
135: ( p_api_version IN NUMBER
136: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
137: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
138: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
139: , x_msg_count OUT NOCOPY NUMBER
140: , x_msg_data OUT NOCOPY VARCHAR2
141: , p_jtf_note_id IN NUMBER
134: PROCEDURE update_note_post
135: ( p_api_version IN NUMBER
136: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
137: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
138: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
139: , x_msg_count OUT NOCOPY NUMBER
140: , x_msg_data OUT NOCOPY VARCHAR2
141: , p_jtf_note_id IN NUMBER
142: , p_entered_by IN NUMBER
142: , p_entered_by IN NUMBER
143: , p_last_updated_by IN NUMBER
144: , p_last_update_date IN DATE DEFAULT SYSDATE
145: , p_last_update_login IN NUMBER DEFAULT NULL
146: , p_notes IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
147: , p_notes_detail IN VARCHAR2 DEFAULT NULL
148: , p_append_flag IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
149: , p_note_status IN VARCHAR2 DEFAULT 'I'
150: , p_note_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
144: , p_last_update_date IN DATE DEFAULT SYSDATE
145: , p_last_update_login IN NUMBER DEFAULT NULL
146: , p_notes IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
147: , p_notes_detail IN VARCHAR2 DEFAULT NULL
148: , p_append_flag IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
149: , p_note_status IN VARCHAR2 DEFAULT 'I'
150: , p_note_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
151: , p_jtf_note_contexts_tab IN jtf_notes_pub.jtf_note_contexts_tbl_type
152: DEFAULT jtf_notes_pub.jtf_note_contexts_tab_dflt
146: , p_notes IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
147: , p_notes_detail IN VARCHAR2 DEFAULT NULL
148: , p_append_flag IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
149: , p_note_status IN VARCHAR2 DEFAULT 'I'
150: , p_note_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
151: , p_jtf_note_contexts_tab IN jtf_notes_pub.jtf_note_contexts_tbl_type
152: DEFAULT jtf_notes_pub.jtf_note_contexts_tab_dflt
153: , x_return_status OUT NOCOPY VARCHAR2
154: );
155:
156: FUNCTION Ok_to_generate_msg
157: ( p_parent_note_id IN NUMBER DEFAULT NULL
158: , p_api_version IN NUMBER
159: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
160: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
161: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
162: , x_msg_count OUT NOCOPY NUMBER
163: , x_msg_data OUT NOCOPY VARCHAR2
156: FUNCTION Ok_to_generate_msg
157: ( p_parent_note_id IN NUMBER DEFAULT NULL
158: , p_api_version IN NUMBER
159: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
160: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
161: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
162: , x_msg_count OUT NOCOPY NUMBER
163: , x_msg_data OUT NOCOPY VARCHAR2
164: , p_org_id IN NUMBER DEFAULT NULL
157: ( p_parent_note_id IN NUMBER DEFAULT NULL
158: , p_api_version IN NUMBER
159: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
160: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
161: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
162: , x_msg_count OUT NOCOPY NUMBER
163: , x_msg_data OUT NOCOPY VARCHAR2
164: , p_org_id IN NUMBER DEFAULT NULL
165: , p_source_object_id IN NUMBER
205: -- DO NOT USE THIS VERSION OF CREATE_NOTE_POST
206: PROCEDURE create_note_post(
207: p_parent_note_id IN NUMBER DEFAULT NULL,
208: p_api_version IN NUMBER ,
209: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
210: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
211: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
212: x_msg_count OUT NOCOPY NUMBER ,
213: x_msg_data OUT NOCOPY VARCHAR2 ,
206: PROCEDURE create_note_post(
207: p_parent_note_id IN NUMBER DEFAULT NULL,
208: p_api_version IN NUMBER ,
209: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
210: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
211: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
212: x_msg_count OUT NOCOPY NUMBER ,
213: x_msg_data OUT NOCOPY VARCHAR2 ,
214: p_org_id IN NUMBER DEFAULT NULL,
207: p_parent_note_id IN NUMBER DEFAULT NULL,
208: p_api_version IN NUMBER ,
209: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
210: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
211: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
212: x_msg_count OUT NOCOPY NUMBER ,
213: x_msg_data OUT NOCOPY VARCHAR2 ,
214: p_org_id IN NUMBER DEFAULT NULL,
215: p_source_object_id IN NUMBER ,
248:
249: -- DO NOT USE THIS VERSION OF OK_TO_GENERATE_MSG
250: FUNCTION Ok_to_generate_msg
251: ( p_api_version IN NUMBER,
252: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
253: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
254: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
255: x_msg_count OUT NOCOPY NUMBER,
256: x_msg_data OUT NOCOPY VARCHAR2,
249: -- DO NOT USE THIS VERSION OF OK_TO_GENERATE_MSG
250: FUNCTION Ok_to_generate_msg
251: ( p_api_version IN NUMBER,
252: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
253: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
254: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
255: x_msg_count OUT NOCOPY NUMBER,
256: x_msg_data OUT NOCOPY VARCHAR2,
257: p_jtf_note_id IN NUMBER,
250: FUNCTION Ok_to_generate_msg
251: ( p_api_version IN NUMBER,
252: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
253: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
254: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
255: x_msg_count OUT NOCOPY NUMBER,
256: x_msg_data OUT NOCOPY VARCHAR2,
257: p_jtf_note_id IN NUMBER,
258: p_entered_by IN NUMBER ,
258: p_entered_by IN NUMBER ,
259: p_last_updated_by IN NUMBER,
260: p_last_update_date IN DATE DEFAULT Sysdate,
261: p_last_update_login IN NUMBER DEFAULT NULL,
262: p_notes IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
263: p_notes_detail IN VARCHAR2 DEFAULT NULL,
264: p_append_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
265: p_note_status IN VARCHAR2 DEFAULT 'I',
266: p_note_type IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
260: p_last_update_date IN DATE DEFAULT Sysdate,
261: p_last_update_login IN NUMBER DEFAULT NULL,
262: p_notes IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
263: p_notes_detail IN VARCHAR2 DEFAULT NULL,
264: p_append_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
265: p_note_status IN VARCHAR2 DEFAULT 'I',
266: p_note_type IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
267: p_jtf_note_contexts_tab IN jtf_notes_pub.jtf_note_contexts_tbl_type
268: DEFAULT jtf_notes_pub.jtf_note_contexts_tab_dflt ,
262: p_notes IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
263: p_notes_detail IN VARCHAR2 DEFAULT NULL,
264: p_append_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
265: p_note_status IN VARCHAR2 DEFAULT 'I',
266: p_note_type IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
267: p_jtf_note_contexts_tab IN jtf_notes_pub.jtf_note_contexts_tbl_type
268: DEFAULT jtf_notes_pub.jtf_note_contexts_tab_dflt ,
269: x_return_status OUT NOCOPY VARCHAR2
270: ) RETURN BOOLEAN;