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
22: --
23: PROCEDURE create_item_instance_post
24: (
25: p_api_version IN NUMBER
26: ,p_commit IN VARCHAR2 := fnd_api.g_false
27: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
28: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
29: ,p_instance_rec IN csi_datastructures_pub.instance_rec
30: ,p_ext_attrib_values_tbl IN csi_datastructures_pub.extend_attrib_values_tbl
23: PROCEDURE create_item_instance_post
24: (
25: p_api_version IN NUMBER
26: ,p_commit IN VARCHAR2 := fnd_api.g_false
27: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
28: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
29: ,p_instance_rec IN csi_datastructures_pub.instance_rec
30: ,p_ext_attrib_values_tbl IN csi_datastructures_pub.extend_attrib_values_tbl
31: ,p_party_tbl IN csi_datastructures_pub.party_tbl
24: (
25: p_api_version IN NUMBER
26: ,p_commit IN VARCHAR2 := fnd_api.g_false
27: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
28: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
29: ,p_instance_rec IN csi_datastructures_pub.instance_rec
30: ,p_ext_attrib_values_tbl IN csi_datastructures_pub.extend_attrib_values_tbl
31: ,p_party_tbl IN csi_datastructures_pub.party_tbl
32: ,p_account_tbl IN csi_datastructures_pub.party_account_tbl
41: --
42: PROCEDURE update_item_instance_pre
43: (
44: p_api_version IN NUMBER
45: ,p_commit IN VARCHAR2 := fnd_api.g_false
46: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
47: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
48: ,p_instance_rec IN csi_datastructures_pub.instance_rec
49: ,p_ext_attrib_values_tbl IN csi_datastructures_pub.extend_attrib_values_tbl
42: PROCEDURE update_item_instance_pre
43: (
44: p_api_version IN NUMBER
45: ,p_commit IN VARCHAR2 := fnd_api.g_false
46: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
47: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
48: ,p_instance_rec IN csi_datastructures_pub.instance_rec
49: ,p_ext_attrib_values_tbl IN csi_datastructures_pub.extend_attrib_values_tbl
50: ,p_party_tbl IN csi_datastructures_pub.party_tbl
43: (
44: p_api_version IN NUMBER
45: ,p_commit IN VARCHAR2 := fnd_api.g_false
46: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
47: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
48: ,p_instance_rec IN csi_datastructures_pub.instance_rec
49: ,p_ext_attrib_values_tbl IN csi_datastructures_pub.extend_attrib_values_tbl
50: ,p_party_tbl IN csi_datastructures_pub.party_tbl
51: ,p_account_tbl IN csi_datastructures_pub.party_account_tbl
61: --
62: PROCEDURE update_item_instance_post
63: (
64: p_api_version IN NUMBER
65: ,p_commit IN VARCHAR2 := fnd_api.g_false
66: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
67: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
68: ,p_instance_rec IN csi_datastructures_pub.instance_rec
69: ,p_ext_attrib_values_tbl IN csi_datastructures_pub.extend_attrib_values_tbl
62: PROCEDURE update_item_instance_post
63: (
64: p_api_version IN NUMBER
65: ,p_commit IN VARCHAR2 := fnd_api.g_false
66: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
67: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
68: ,p_instance_rec IN csi_datastructures_pub.instance_rec
69: ,p_ext_attrib_values_tbl IN csi_datastructures_pub.extend_attrib_values_tbl
70: ,p_party_tbl IN csi_datastructures_pub.party_tbl
63: (
64: p_api_version IN NUMBER
65: ,p_commit IN VARCHAR2 := fnd_api.g_false
66: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
67: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
68: ,p_instance_rec IN csi_datastructures_pub.instance_rec
69: ,p_ext_attrib_values_tbl IN csi_datastructures_pub.extend_attrib_values_tbl
70: ,p_party_tbl IN csi_datastructures_pub.party_tbl
71: ,p_account_tbl IN csi_datastructures_pub.party_account_tbl
81: --
82: PROCEDURE expire_item_instance_pre
83: (
84: p_api_version IN NUMBER
85: ,p_commit IN VARCHAR2 := fnd_api.g_false
86: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
87: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
88: ,p_instance_rec IN csi_datastructures_pub.instance_rec
89: ,p_expire_children IN VARCHAR2 := fnd_api.g_false
82: PROCEDURE expire_item_instance_pre
83: (
84: p_api_version IN NUMBER
85: ,p_commit IN VARCHAR2 := fnd_api.g_false
86: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
87: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
88: ,p_instance_rec IN csi_datastructures_pub.instance_rec
89: ,p_expire_children IN VARCHAR2 := fnd_api.g_false
90: ,p_txn_rec IN csi_datastructures_pub.transaction_rec
83: (
84: p_api_version IN NUMBER
85: ,p_commit IN VARCHAR2 := fnd_api.g_false
86: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
87: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
88: ,p_instance_rec IN csi_datastructures_pub.instance_rec
89: ,p_expire_children IN VARCHAR2 := fnd_api.g_false
90: ,p_txn_rec IN csi_datastructures_pub.transaction_rec
91: ,x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl
85: ,p_commit IN VARCHAR2 := fnd_api.g_false
86: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
87: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
88: ,p_instance_rec IN csi_datastructures_pub.instance_rec
89: ,p_expire_children IN VARCHAR2 := fnd_api.g_false
90: ,p_txn_rec IN csi_datastructures_pub.transaction_rec
91: ,x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl
92: ,x_return_status OUT NOCOPY VARCHAR2
93: ,x_msg_count OUT NOCOPY NUMBER
96: --
97: PROCEDURE expire_item_instance_post
98: (
99: p_api_version IN NUMBER
100: ,p_commit IN VARCHAR2 := fnd_api.g_false
101: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
102: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
103: ,p_instance_rec IN csi_datastructures_pub.instance_rec
104: ,p_expire_children IN VARCHAR2 := fnd_api.g_false
97: PROCEDURE expire_item_instance_post
98: (
99: p_api_version IN NUMBER
100: ,p_commit IN VARCHAR2 := fnd_api.g_false
101: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
102: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
103: ,p_instance_rec IN csi_datastructures_pub.instance_rec
104: ,p_expire_children IN VARCHAR2 := fnd_api.g_false
105: ,p_txn_rec IN csi_datastructures_pub.transaction_rec
98: (
99: p_api_version IN NUMBER
100: ,p_commit IN VARCHAR2 := fnd_api.g_false
101: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
102: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
103: ,p_instance_rec IN csi_datastructures_pub.instance_rec
104: ,p_expire_children IN VARCHAR2 := fnd_api.g_false
105: ,p_txn_rec IN csi_datastructures_pub.transaction_rec
106: ,x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl
100: ,p_commit IN VARCHAR2 := fnd_api.g_false
101: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
102: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
103: ,p_instance_rec IN csi_datastructures_pub.instance_rec
104: ,p_expire_children IN VARCHAR2 := fnd_api.g_false
105: ,p_txn_rec IN csi_datastructures_pub.transaction_rec
106: ,x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl
107: ,x_return_status OUT NOCOPY VARCHAR2
108: ,x_msg_count OUT NOCOPY NUMBER