DBA Data[Home] [Help]

APPS.JTF_NOTES_VUHK dependencies on FND_API

Line 14: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

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

Line 15: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

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

Line 16: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL

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

Line 60: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

56:
57: PROCEDURE create_note_post
58: ( p_parent_note_id IN NUMBER DEFAULT NULL
59: , p_api_version IN NUMBER
60: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
61: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
62: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
63: , x_msg_count OUT NOCOPY NUMBER
64: , x_msg_data OUT NOCOPY VARCHAR2

Line 61: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

57: PROCEDURE create_note_post
58: ( p_parent_note_id IN NUMBER DEFAULT NULL
59: , p_api_version IN NUMBER
60: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
61: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
62: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
63: , x_msg_count OUT NOCOPY NUMBER
64: , x_msg_data OUT NOCOPY VARCHAR2
65: , p_org_id IN NUMBER DEFAULT NULL

Line 62: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL

58: ( p_parent_note_id IN NUMBER DEFAULT NULL
59: , p_api_version IN NUMBER
60: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
61: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
62: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
63: , x_msg_count OUT NOCOPY NUMBER
64: , x_msg_data OUT NOCOPY VARCHAR2
65: , p_org_id IN NUMBER DEFAULT NULL
66: , p_source_object_id IN NUMBER

Line 106: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

102: /* Verticals Procedure for pre processing in case of update note */
103:
104: PROCEDURE update_note_pre
105: ( p_api_version IN NUMBER
106: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
107: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
108: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
109: , x_msg_count OUT NOCOPY NUMBER
110: , x_msg_data OUT NOCOPY VARCHAR2

Line 107: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

103:
104: PROCEDURE update_note_pre
105: ( p_api_version IN NUMBER
106: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
107: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
108: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
109: , x_msg_count OUT NOCOPY NUMBER
110: , x_msg_data OUT NOCOPY VARCHAR2
111: , p_jtf_note_id IN NUMBER

Line 108: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL

104: PROCEDURE update_note_pre
105: ( p_api_version IN NUMBER
106: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
107: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
108: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
109: , x_msg_count OUT NOCOPY NUMBER
110: , x_msg_data OUT NOCOPY VARCHAR2
111: , p_jtf_note_id IN NUMBER
112: , p_entered_by IN NUMBER

Line 116: , p_notes IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR

112: , p_entered_by IN NUMBER
113: , p_last_updated_by IN NUMBER
114: , p_last_update_date IN DATE DEFAULT SYSDATE
115: , p_last_update_login IN NUMBER DEFAULT NULL
116: , p_notes IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
117: , p_notes_detail IN VARCHAR2 DEFAULT NULL
118: , p_append_flag IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
119: , p_note_status IN VARCHAR2 DEFAULT 'I'
120: , p_note_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR

Line 118: , p_append_flag IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR

114: , p_last_update_date IN DATE DEFAULT SYSDATE
115: , p_last_update_login IN NUMBER DEFAULT NULL
116: , p_notes IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
117: , p_notes_detail IN VARCHAR2 DEFAULT NULL
118: , p_append_flag IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
119: , p_note_status IN VARCHAR2 DEFAULT 'I'
120: , p_note_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
121: , p_jtf_note_contexts_tab IN jtf_notes_pub.jtf_note_contexts_tbl_type
122: DEFAULT jtf_notes_pub.jtf_note_contexts_tab_dflt

Line 120: , p_note_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR

116: , p_notes IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
117: , p_notes_detail IN VARCHAR2 DEFAULT NULL
118: , p_append_flag IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
119: , p_note_status IN VARCHAR2 DEFAULT 'I'
120: , p_note_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
121: , p_jtf_note_contexts_tab IN jtf_notes_pub.jtf_note_contexts_tbl_type
122: DEFAULT jtf_notes_pub.jtf_note_contexts_tab_dflt
123: , x_return_status OUT NOCOPY VARCHAR2
124: );

Line 131: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

127: /* Vertical Procedure for post processing in case of update note */
128:
129: PROCEDURE update_note_post
130: ( p_api_version IN NUMBER
131: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
132: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
133: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
134: , x_msg_count OUT NOCOPY NUMBER
135: , x_msg_data OUT NOCOPY VARCHAR2

Line 132: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

128:
129: PROCEDURE update_note_post
130: ( p_api_version IN NUMBER
131: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
132: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
133: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
134: , x_msg_count OUT NOCOPY NUMBER
135: , x_msg_data OUT NOCOPY VARCHAR2
136: , p_jtf_note_id IN NUMBER

Line 133: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL

129: PROCEDURE update_note_post
130: ( p_api_version IN NUMBER
131: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
132: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
133: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
134: , x_msg_count OUT NOCOPY NUMBER
135: , x_msg_data OUT NOCOPY VARCHAR2
136: , p_jtf_note_id IN NUMBER
137: , p_entered_by IN NUMBER

Line 141: , p_notes IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR

137: , p_entered_by IN NUMBER
138: , p_last_updated_by IN NUMBER
139: , p_last_update_date IN DATE DEFAULT SYSDATE
140: , p_last_update_login IN NUMBER DEFAULT NULL
141: , p_notes IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
142: , p_notes_detail IN VARCHAR2 DEFAULT NULL
143: , p_append_flag IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
144: , p_note_status IN VARCHAR2 DEFAULT 'I'
145: , p_note_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR

Line 143: , p_append_flag IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR

139: , p_last_update_date IN DATE DEFAULT SYSDATE
140: , p_last_update_login IN NUMBER DEFAULT NULL
141: , p_notes IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
142: , p_notes_detail IN VARCHAR2 DEFAULT NULL
143: , p_append_flag IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
144: , p_note_status IN VARCHAR2 DEFAULT 'I'
145: , p_note_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
146: , p_jtf_note_contexts_tab IN jtf_notes_pub.jtf_note_contexts_tbl_type DEFAULT jtf_notes_pub.jtf_note_contexts_tab_dflt
147: , x_return_status OUT NOCOPY VARCHAR2

Line 145: , p_note_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR

141: , p_notes IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
142: , p_notes_detail IN VARCHAR2 DEFAULT NULL
143: , p_append_flag IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
144: , p_note_status IN VARCHAR2 DEFAULT 'I'
145: , p_note_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
146: , p_jtf_note_contexts_tab IN jtf_notes_pub.jtf_note_contexts_tbl_type DEFAULT jtf_notes_pub.jtf_note_contexts_tab_dflt
147: , x_return_status OUT NOCOPY VARCHAR2
148: );
149:

Line 153: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

149:
150: FUNCTION Ok_to_generate_msg
151: ( p_parent_note_id IN NUMBER DEFAULT NULL
152: , p_api_version IN NUMBER
153: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
154: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
155: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
156: , x_msg_count OUT NOCOPY NUMBER
157: , x_msg_data OUT NOCOPY VARCHAR2

Line 154: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

150: FUNCTION Ok_to_generate_msg
151: ( p_parent_note_id IN NUMBER DEFAULT NULL
152: , p_api_version IN NUMBER
153: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
154: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
155: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
156: , x_msg_count OUT NOCOPY NUMBER
157: , x_msg_data OUT NOCOPY VARCHAR2
158: , p_org_id IN NUMBER DEFAULT NULL

Line 155: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL

151: ( p_parent_note_id IN NUMBER DEFAULT NULL
152: , p_api_version IN NUMBER
153: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
154: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
155: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
156: , x_msg_count OUT NOCOPY NUMBER
157: , x_msg_data OUT NOCOPY VARCHAR2
158: , p_org_id IN NUMBER DEFAULT NULL
159: , p_source_object_id IN NUMBER

Line 200: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

196:
197: -- DO NOT USE THIS VERSION OF OK_TO_GENERATE_MSG
198: FUNCTION Ok_to_generate_msg
199: ( p_api_version IN NUMBER,
200: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
201: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
202: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
203: x_msg_count OUT NOCOPY NUMBER,
204: x_msg_data OUT NOCOPY VARCHAR2,

Line 201: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

197: -- DO NOT USE THIS VERSION OF OK_TO_GENERATE_MSG
198: FUNCTION Ok_to_generate_msg
199: ( p_api_version IN NUMBER,
200: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
201: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
202: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
203: x_msg_count OUT NOCOPY NUMBER,
204: x_msg_data OUT NOCOPY VARCHAR2,
205: p_jtf_note_id IN NUMBER,

Line 202: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,

198: FUNCTION Ok_to_generate_msg
199: ( p_api_version IN NUMBER,
200: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
201: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
202: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
203: x_msg_count OUT NOCOPY NUMBER,
204: x_msg_data OUT NOCOPY VARCHAR2,
205: p_jtf_note_id IN NUMBER,
206: p_entered_by IN NUMBER ,

Line 210: p_notes IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

206: p_entered_by IN NUMBER ,
207: p_last_updated_by IN NUMBER,
208: p_last_update_date IN DATE DEFAULT Sysdate,
209: p_last_update_login IN NUMBER DEFAULT NULL,
210: p_notes IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
211: p_notes_detail IN VARCHAR2 DEFAULT NULL,
212: p_append_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
213: p_note_status IN VARCHAR2 DEFAULT 'I',
214: p_note_type IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

Line 212: p_append_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

208: p_last_update_date IN DATE DEFAULT Sysdate,
209: p_last_update_login IN NUMBER DEFAULT NULL,
210: p_notes IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
211: p_notes_detail IN VARCHAR2 DEFAULT NULL,
212: p_append_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
213: p_note_status IN VARCHAR2 DEFAULT 'I',
214: p_note_type IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
215: p_jtf_note_contexts_tab IN jtf_notes_pub.jtf_note_contexts_tbl_type
216: DEFAULT jtf_notes_pub.jtf_note_contexts_tab_dflt ,

Line 214: p_note_type IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

210: p_notes IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
211: p_notes_detail IN VARCHAR2 DEFAULT NULL,
212: p_append_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
213: p_note_status IN VARCHAR2 DEFAULT 'I',
214: p_note_type IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
215: p_jtf_note_contexts_tab IN jtf_notes_pub.jtf_note_contexts_tbl_type
216: DEFAULT jtf_notes_pub.jtf_note_contexts_tab_dflt ,
217: x_return_status OUT NOCOPY VARCHAR2
218: )RETURN BOOLEAN;

Line 224: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

220: -- DO NOT USE THIS VERSION OF CREATE_NOTE_POST
221: PROCEDURE create_note_post (
222: p_parent_note_id IN NUMBER DEFAULT NULL,
223: p_api_version IN NUMBER ,
224: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
225: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
226: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
227: x_msg_count OUT NOCOPY NUMBER ,
228: x_msg_data OUT NOCOPY VARCHAR2 ,

Line 225: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

221: PROCEDURE create_note_post (
222: p_parent_note_id IN NUMBER DEFAULT NULL,
223: p_api_version IN NUMBER ,
224: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
225: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
226: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
227: x_msg_count OUT NOCOPY NUMBER ,
228: x_msg_data OUT NOCOPY VARCHAR2 ,
229: p_org_id IN NUMBER DEFAULT NULL,

Line 226: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,

222: p_parent_note_id IN NUMBER DEFAULT NULL,
223: p_api_version IN NUMBER ,
224: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
225: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
226: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
227: x_msg_count OUT NOCOPY NUMBER ,
228: x_msg_data OUT NOCOPY VARCHAR2 ,
229: p_org_id IN NUMBER DEFAULT NULL,
230: p_source_object_id IN NUMBER ,