3:
4: PROCEDURE create_item_instance_pre
5: (
6: p_api_version IN NUMBER
7: ,p_commit IN VARCHAR2 := fnd_api.g_false
8: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
9: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
10: ,p_instance_rec IN csi_datastructures_pub.instance_rec
11: ,p_ext_attrib_values_tbl IN csi_datastructures_pub.extend_attrib_values_tbl
4: PROCEDURE create_item_instance_pre
5: (
6: p_api_version IN NUMBER
7: ,p_commit IN VARCHAR2 := fnd_api.g_false
8: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
9: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
10: ,p_instance_rec IN csi_datastructures_pub.instance_rec
11: ,p_ext_attrib_values_tbl IN csi_datastructures_pub.extend_attrib_values_tbl
12: ,p_party_tbl IN csi_datastructures_pub.party_tbl
5: (
6: p_api_version IN NUMBER
7: ,p_commit IN VARCHAR2 := fnd_api.g_false
8: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
9: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
10: ,p_instance_rec IN csi_datastructures_pub.instance_rec
11: ,p_ext_attrib_values_tbl IN csi_datastructures_pub.extend_attrib_values_tbl
12: ,p_party_tbl IN csi_datastructures_pub.party_tbl
13: ,p_account_tbl IN csi_datastructures_pub.party_account_tbl
20: ,x_msg_data OUT NOCOPY VARCHAR2
21: )
22: IS
23: BEGIN
24: x_return_status := FND_API.G_RET_STS_SUCCESS;
25: END;
26:
27: PROCEDURE create_item_instance_post
28: (
26:
27: PROCEDURE create_item_instance_post
28: (
29: p_api_version IN NUMBER
30: ,p_commit IN VARCHAR2 := fnd_api.g_false
31: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
32: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
33: ,p_instance_rec IN csi_datastructures_pub.instance_rec
34: ,p_ext_attrib_values_tbl IN csi_datastructures_pub.extend_attrib_values_tbl
27: PROCEDURE create_item_instance_post
28: (
29: p_api_version IN NUMBER
30: ,p_commit IN VARCHAR2 := fnd_api.g_false
31: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
32: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
33: ,p_instance_rec IN csi_datastructures_pub.instance_rec
34: ,p_ext_attrib_values_tbl IN csi_datastructures_pub.extend_attrib_values_tbl
35: ,p_party_tbl IN csi_datastructures_pub.party_tbl
28: (
29: p_api_version IN NUMBER
30: ,p_commit IN VARCHAR2 := fnd_api.g_false
31: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
32: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
33: ,p_instance_rec IN csi_datastructures_pub.instance_rec
34: ,p_ext_attrib_values_tbl IN csi_datastructures_pub.extend_attrib_values_tbl
35: ,p_party_tbl IN csi_datastructures_pub.party_tbl
36: ,p_account_tbl IN csi_datastructures_pub.party_account_tbl
57: ' exception ' ||
58: ' when others then null;' ||
59: ' end; ';
60: BEGIN
61: x_return_status := FND_API.G_RET_STS_SUCCESS;
62:
63: begin
64: EXECUTE IMMEDIATE
65: ' begin JTM_MESSAGE_LOG_PKG.log_msg(' ||
107: end if;
108:
109: EXCEPTION
110: WHEN OTHERS THEN
111: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
112: begin
113: EXECUTE IMMEDIATE l_strLogBuffer;
114: exception
115: when others then
119:
120: PROCEDURE update_item_instance_pre
121: (
122: p_api_version IN NUMBER
123: ,p_commit IN VARCHAR2 := fnd_api.g_false
124: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
125: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
126: ,p_instance_rec IN csi_datastructures_pub.instance_rec
127: ,p_ext_attrib_values_tbl IN csi_datastructures_pub.extend_attrib_values_tbl
120: PROCEDURE update_item_instance_pre
121: (
122: p_api_version IN NUMBER
123: ,p_commit IN VARCHAR2 := fnd_api.g_false
124: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
125: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
126: ,p_instance_rec IN csi_datastructures_pub.instance_rec
127: ,p_ext_attrib_values_tbl IN csi_datastructures_pub.extend_attrib_values_tbl
128: ,p_party_tbl IN csi_datastructures_pub.party_tbl
121: (
122: p_api_version IN NUMBER
123: ,p_commit IN VARCHAR2 := fnd_api.g_false
124: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
125: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
126: ,p_instance_rec IN csi_datastructures_pub.instance_rec
127: ,p_ext_attrib_values_tbl IN csi_datastructures_pub.extend_attrib_values_tbl
128: ,p_party_tbl IN csi_datastructures_pub.party_tbl
129: ,p_account_tbl IN csi_datastructures_pub.party_account_tbl
152: ' exception ' ||
153: ' when others then null;' ||
154: ' end; ';
155: BEGIN
156: x_return_status := FND_API.G_RET_STS_SUCCESS;
157:
158: begin
159: EXECUTE IMMEDIATE
160: ' begin JTM_MESSAGE_LOG_PKG.log_msg(' ||
202: end if;
203:
204: EXCEPTION
205: WHEN OTHERS THEN
206: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
207: begin
208: EXECUTE IMMEDIATE l_strLogBuffer;
209: exception
210: when others then
214:
215: PROCEDURE update_item_instance_post
216: (
217: p_api_version IN NUMBER
218: ,p_commit IN VARCHAR2 := fnd_api.g_false
219: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
220: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
221: ,p_instance_rec IN csi_datastructures_pub.instance_rec
222: ,p_ext_attrib_values_tbl IN csi_datastructures_pub.extend_attrib_values_tbl
215: PROCEDURE update_item_instance_post
216: (
217: p_api_version IN NUMBER
218: ,p_commit IN VARCHAR2 := fnd_api.g_false
219: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
220: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
221: ,p_instance_rec IN csi_datastructures_pub.instance_rec
222: ,p_ext_attrib_values_tbl IN csi_datastructures_pub.extend_attrib_values_tbl
223: ,p_party_tbl IN csi_datastructures_pub.party_tbl
216: (
217: p_api_version IN NUMBER
218: ,p_commit IN VARCHAR2 := fnd_api.g_false
219: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
220: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
221: ,p_instance_rec IN csi_datastructures_pub.instance_rec
222: ,p_ext_attrib_values_tbl IN csi_datastructures_pub.extend_attrib_values_tbl
223: ,p_party_tbl IN csi_datastructures_pub.party_tbl
224: ,p_account_tbl IN csi_datastructures_pub.party_account_tbl
247: ' when others then null;' ||
248: ' end; ';
249:
250: BEGIN
251: x_return_status := FND_API.G_RET_STS_SUCCESS;
252:
253: begin
254: EXECUTE IMMEDIATE
255: ' begin JTM_MESSAGE_LOG_PKG.log_msg(' ||
296: end if;
297:
298: EXCEPTION
299: WHEN OTHERS THEN
300: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
301: begin
302: EXECUTE IMMEDIATE l_strLogBuffer;
303: exception
304: when others then
308:
309: PROCEDURE expire_item_instance_pre
310: (
311: p_api_version IN NUMBER
312: ,p_commit IN VARCHAR2 := fnd_api.g_false
313: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
314: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
315: ,p_instance_rec IN csi_datastructures_pub.instance_rec
316: ,p_expire_children IN VARCHAR2 := fnd_api.g_false
309: PROCEDURE expire_item_instance_pre
310: (
311: p_api_version IN NUMBER
312: ,p_commit IN VARCHAR2 := fnd_api.g_false
313: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
314: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
315: ,p_instance_rec IN csi_datastructures_pub.instance_rec
316: ,p_expire_children IN VARCHAR2 := fnd_api.g_false
317: ,p_txn_rec IN csi_datastructures_pub.transaction_rec
310: (
311: p_api_version IN NUMBER
312: ,p_commit IN VARCHAR2 := fnd_api.g_false
313: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
314: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
315: ,p_instance_rec IN csi_datastructures_pub.instance_rec
316: ,p_expire_children IN VARCHAR2 := fnd_api.g_false
317: ,p_txn_rec IN csi_datastructures_pub.transaction_rec
318: ,x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl
312: ,p_commit IN VARCHAR2 := fnd_api.g_false
313: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
314: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
315: ,p_instance_rec IN csi_datastructures_pub.instance_rec
316: ,p_expire_children IN VARCHAR2 := fnd_api.g_false
317: ,p_txn_rec IN csi_datastructures_pub.transaction_rec
318: ,x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl
319: ,x_return_status OUT NOCOPY VARCHAR2
320: ,x_msg_count OUT NOCOPY NUMBER
321: ,x_msg_data OUT NOCOPY VARCHAR2
322: )
323: IS
324: BEGIN
325: x_return_status := FND_API.G_RET_STS_SUCCESS;
326: END;
327:
328: PROCEDURE expire_item_instance_post
329: (
327:
328: PROCEDURE expire_item_instance_post
329: (
330: p_api_version IN NUMBER
331: ,p_commit IN VARCHAR2 := fnd_api.g_false
332: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
333: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
334: ,p_instance_rec IN csi_datastructures_pub.instance_rec
335: ,p_expire_children IN VARCHAR2 := fnd_api.g_false
328: PROCEDURE expire_item_instance_post
329: (
330: p_api_version IN NUMBER
331: ,p_commit IN VARCHAR2 := fnd_api.g_false
332: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
333: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
334: ,p_instance_rec IN csi_datastructures_pub.instance_rec
335: ,p_expire_children IN VARCHAR2 := fnd_api.g_false
336: ,p_txn_rec IN csi_datastructures_pub.transaction_rec
329: (
330: p_api_version IN NUMBER
331: ,p_commit IN VARCHAR2 := fnd_api.g_false
332: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
333: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
334: ,p_instance_rec IN csi_datastructures_pub.instance_rec
335: ,p_expire_children IN VARCHAR2 := fnd_api.g_false
336: ,p_txn_rec IN csi_datastructures_pub.transaction_rec
337: ,x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl
331: ,p_commit IN VARCHAR2 := fnd_api.g_false
332: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
333: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
334: ,p_instance_rec IN csi_datastructures_pub.instance_rec
335: ,p_expire_children IN VARCHAR2 := fnd_api.g_false
336: ,p_txn_rec IN csi_datastructures_pub.transaction_rec
337: ,x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl
338: ,x_return_status OUT NOCOPY VARCHAR2
339: ,x_msg_count OUT NOCOPY NUMBER
340: ,x_msg_data OUT NOCOPY VARCHAR2
341: )
342: IS
343: BEGIN
344: x_return_status := FND_API.G_RET_STS_SUCCESS;
345: END;
346:
347: END CSI_ITEM_INSTANCE_VUHK;