47: p_api_version IN NUMBER
48: ,p_commit IN VARCHAR2 := fnd_api.g_false
49: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
50: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
51: ,p_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec
52: ,p_ext_attrib_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
53: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
54: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
55: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
48: ,p_commit IN VARCHAR2 := fnd_api.g_false
49: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
50: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
51: ,p_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec
52: ,p_ext_attrib_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
53: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
54: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
55: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
56: ,p_org_assignments_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl
49: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
50: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
51: ,p_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec
52: ,p_ext_attrib_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
53: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
54: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
55: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
56: ,p_org_assignments_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl
57: ,p_asset_assignment_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl
50: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
51: ,p_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec
52: ,p_ext_attrib_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
53: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
54: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
55: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
56: ,p_org_assignments_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl
57: ,p_asset_assignment_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl
58: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
51: ,p_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec
52: ,p_ext_attrib_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
53: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
54: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
55: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
56: ,p_org_assignments_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl
57: ,p_asset_assignment_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl
58: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
59: ,x_return_status OUT NOCOPY VARCHAR2
52: ,p_ext_attrib_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
53: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
54: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
55: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
56: ,p_org_assignments_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl
57: ,p_asset_assignment_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl
58: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
59: ,x_return_status OUT NOCOPY VARCHAR2
60: ,x_msg_count OUT NOCOPY NUMBER
53: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
54: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
55: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
56: ,p_org_assignments_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl
57: ,p_asset_assignment_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl
58: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
59: ,x_return_status OUT NOCOPY VARCHAR2
60: ,x_msg_count OUT NOCOPY NUMBER
61: ,x_msg_data OUT NOCOPY VARCHAR2
54: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
55: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
56: ,p_org_assignments_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl
57: ,p_asset_assignment_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl
58: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
59: ,x_return_status OUT NOCOPY VARCHAR2
60: ,x_msg_count OUT NOCOPY NUMBER
61: ,x_msg_data OUT NOCOPY VARCHAR2
62: );
94: p_api_version IN NUMBER
95: ,p_commit IN VARCHAR2 := fnd_api.g_false
96: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
97: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
98: ,p_instance_rec IN csi_datastructures_pub.instance_rec
99: ,p_ext_attrib_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
100: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
101: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
102: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
95: ,p_commit IN VARCHAR2 := fnd_api.g_false
96: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
97: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
98: ,p_instance_rec IN csi_datastructures_pub.instance_rec
99: ,p_ext_attrib_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
100: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
101: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
102: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
103: ,p_org_assignments_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl
96: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
97: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
98: ,p_instance_rec IN csi_datastructures_pub.instance_rec
99: ,p_ext_attrib_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
100: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
101: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
102: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
103: ,p_org_assignments_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl
104: ,p_asset_assignment_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl
97: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
98: ,p_instance_rec IN csi_datastructures_pub.instance_rec
99: ,p_ext_attrib_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
100: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
101: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
102: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
103: ,p_org_assignments_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl
104: ,p_asset_assignment_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl
105: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
98: ,p_instance_rec IN csi_datastructures_pub.instance_rec
99: ,p_ext_attrib_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
100: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
101: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
102: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
103: ,p_org_assignments_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl
104: ,p_asset_assignment_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl
105: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
106: ,x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl
99: ,p_ext_attrib_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
100: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
101: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
102: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
103: ,p_org_assignments_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl
104: ,p_asset_assignment_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl
105: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
106: ,x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl
107: ,x_return_status OUT NOCOPY VARCHAR2
100: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
101: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
102: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
103: ,p_org_assignments_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl
104: ,p_asset_assignment_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl
105: ,p_txn_rec IN OUT NOCOPY 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
101: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
102: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
103: ,p_org_assignments_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl
104: ,p_asset_assignment_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl
105: ,p_txn_rec IN OUT NOCOPY 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
109: ,x_msg_data OUT NOCOPY VARCHAR2
102: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
103: ,p_org_assignments_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl
104: ,p_asset_assignment_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl
105: ,p_txn_rec IN OUT NOCOPY 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
109: ,x_msg_data OUT NOCOPY VARCHAR2
110: );
120: p_api_version IN NUMBER
121: ,p_commit IN VARCHAR2 := fnd_api.g_false
122: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
123: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
124: ,p_instance_rec IN csi_datastructures_pub.instance_rec
125: ,p_expire_children IN VARCHAR2 := fnd_api.g_false
126: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
127: ,x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl
128: ,x_return_status OUT NOCOPY VARCHAR2
122: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
123: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
124: ,p_instance_rec IN csi_datastructures_pub.instance_rec
125: ,p_expire_children IN VARCHAR2 := fnd_api.g_false
126: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
127: ,x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl
128: ,x_return_status OUT NOCOPY VARCHAR2
129: ,x_msg_count OUT NOCOPY NUMBER
130: ,x_msg_data OUT NOCOPY VARCHAR2
123: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
124: ,p_instance_rec IN csi_datastructures_pub.instance_rec
125: ,p_expire_children IN VARCHAR2 := fnd_api.g_false
126: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
127: ,x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl
128: ,x_return_status OUT NOCOPY VARCHAR2
129: ,x_msg_count OUT NOCOPY NUMBER
130: ,x_msg_data OUT NOCOPY VARCHAR2
131: );
162: p_api_version IN NUMBER
163: ,p_commit IN VARCHAR2 := fnd_api.g_false
164: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
165: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
166: ,p_instance_query_rec IN csi_datastructures_pub.instance_query_rec
167: ,p_party_query_rec IN csi_datastructures_pub.party_query_rec
168: ,p_account_query_rec IN csi_datastructures_pub.party_account_query_rec
169: ,p_transaction_id IN NUMBER
170: ,p_resolve_id_columns IN VARCHAR2 := fnd_api.g_false
163: ,p_commit IN VARCHAR2 := fnd_api.g_false
164: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
165: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
166: ,p_instance_query_rec IN csi_datastructures_pub.instance_query_rec
167: ,p_party_query_rec IN csi_datastructures_pub.party_query_rec
168: ,p_account_query_rec IN csi_datastructures_pub.party_account_query_rec
169: ,p_transaction_id IN NUMBER
170: ,p_resolve_id_columns IN VARCHAR2 := fnd_api.g_false
171: ,p_active_instance_only IN VARCHAR2 := fnd_api.g_true
164: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
165: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
166: ,p_instance_query_rec IN csi_datastructures_pub.instance_query_rec
167: ,p_party_query_rec IN csi_datastructures_pub.party_query_rec
168: ,p_account_query_rec IN csi_datastructures_pub.party_account_query_rec
169: ,p_transaction_id IN NUMBER
170: ,p_resolve_id_columns IN VARCHAR2 := fnd_api.g_false
171: ,p_active_instance_only IN VARCHAR2 := fnd_api.g_true
172: ,x_instance_header_tbl OUT NOCOPY csi_datastructures_pub.instance_header_tbl
168: ,p_account_query_rec IN csi_datastructures_pub.party_account_query_rec
169: ,p_transaction_id IN NUMBER
170: ,p_resolve_id_columns IN VARCHAR2 := fnd_api.g_false
171: ,p_active_instance_only IN VARCHAR2 := fnd_api.g_true
172: ,x_instance_header_tbl OUT NOCOPY csi_datastructures_pub.instance_header_tbl
173: ,x_return_status OUT NOCOPY VARCHAR2
174: ,x_msg_count OUT NOCOPY NUMBER
175: ,x_msg_data OUT NOCOPY VARCHAR2
176: );
219: p_api_version IN NUMBER
220: ,p_commit IN VARCHAR2 := fnd_api.g_false
221: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
222: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
223: ,p_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_header_rec
224: ,p_get_parties IN VARCHAR2 := fnd_api.g_false
225: ,p_party_header_tbl OUT NOCOPY csi_datastructures_pub.party_header_tbl
226: ,p_get_accounts IN VARCHAR2 := fnd_api.g_false
227: ,p_account_header_tbl OUT NOCOPY csi_datastructures_pub.party_account_header_tbl
221: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
222: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
223: ,p_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_header_rec
224: ,p_get_parties IN VARCHAR2 := fnd_api.g_false
225: ,p_party_header_tbl OUT NOCOPY csi_datastructures_pub.party_header_tbl
226: ,p_get_accounts IN VARCHAR2 := fnd_api.g_false
227: ,p_account_header_tbl OUT NOCOPY csi_datastructures_pub.party_account_header_tbl
228: ,p_get_org_assignments IN VARCHAR2 := fnd_api.g_false
229: ,p_org_header_tbl OUT NOCOPY csi_datastructures_pub.org_units_header_tbl
223: ,p_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_header_rec
224: ,p_get_parties IN VARCHAR2 := fnd_api.g_false
225: ,p_party_header_tbl OUT NOCOPY csi_datastructures_pub.party_header_tbl
226: ,p_get_accounts IN VARCHAR2 := fnd_api.g_false
227: ,p_account_header_tbl OUT NOCOPY csi_datastructures_pub.party_account_header_tbl
228: ,p_get_org_assignments IN VARCHAR2 := fnd_api.g_false
229: ,p_org_header_tbl OUT NOCOPY csi_datastructures_pub.org_units_header_tbl
230: ,p_get_pricing_attribs IN VARCHAR2 := fnd_api.g_false
231: ,p_pricing_attrib_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
225: ,p_party_header_tbl OUT NOCOPY csi_datastructures_pub.party_header_tbl
226: ,p_get_accounts IN VARCHAR2 := fnd_api.g_false
227: ,p_account_header_tbl OUT NOCOPY csi_datastructures_pub.party_account_header_tbl
228: ,p_get_org_assignments IN VARCHAR2 := fnd_api.g_false
229: ,p_org_header_tbl OUT NOCOPY csi_datastructures_pub.org_units_header_tbl
230: ,p_get_pricing_attribs IN VARCHAR2 := fnd_api.g_false
231: ,p_pricing_attrib_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
232: ,p_get_ext_attribs IN VARCHAR2 := fnd_api.g_false
233: ,p_ext_attrib_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
227: ,p_account_header_tbl OUT NOCOPY csi_datastructures_pub.party_account_header_tbl
228: ,p_get_org_assignments IN VARCHAR2 := fnd_api.g_false
229: ,p_org_header_tbl OUT NOCOPY csi_datastructures_pub.org_units_header_tbl
230: ,p_get_pricing_attribs IN VARCHAR2 := fnd_api.g_false
231: ,p_pricing_attrib_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
232: ,p_get_ext_attribs IN VARCHAR2 := fnd_api.g_false
233: ,p_ext_attrib_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
234: ,p_ext_attrib_def_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_tbl --added
235: ,p_get_asset_assignments IN VARCHAR2 := fnd_api.g_false
229: ,p_org_header_tbl OUT NOCOPY csi_datastructures_pub.org_units_header_tbl
230: ,p_get_pricing_attribs IN VARCHAR2 := fnd_api.g_false
231: ,p_pricing_attrib_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
232: ,p_get_ext_attribs IN VARCHAR2 := fnd_api.g_false
233: ,p_ext_attrib_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
234: ,p_ext_attrib_def_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_tbl --added
235: ,p_get_asset_assignments IN VARCHAR2 := fnd_api.g_false
236: ,p_asset_header_tbl OUT NOCOPY csi_datastructures_pub.instance_asset_header_tbl
237: ,p_resolve_id_columns IN VARCHAR2 := fnd_api.g_false
230: ,p_get_pricing_attribs IN VARCHAR2 := fnd_api.g_false
231: ,p_pricing_attrib_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
232: ,p_get_ext_attribs IN VARCHAR2 := fnd_api.g_false
233: ,p_ext_attrib_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
234: ,p_ext_attrib_def_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_tbl --added
235: ,p_get_asset_assignments IN VARCHAR2 := fnd_api.g_false
236: ,p_asset_header_tbl OUT NOCOPY csi_datastructures_pub.instance_asset_header_tbl
237: ,p_resolve_id_columns IN VARCHAR2 := fnd_api.g_false
238: ,p_time_stamp IN DATE
232: ,p_get_ext_attribs IN VARCHAR2 := fnd_api.g_false
233: ,p_ext_attrib_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
234: ,p_ext_attrib_def_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_tbl --added
235: ,p_get_asset_assignments IN VARCHAR2 := fnd_api.g_false
236: ,p_asset_header_tbl OUT NOCOPY csi_datastructures_pub.instance_asset_header_tbl
237: ,p_resolve_id_columns IN VARCHAR2 := fnd_api.g_false
238: ,p_time_stamp IN DATE
239: ,x_return_status OUT NOCOPY VARCHAR2
240: ,x_msg_count OUT NOCOPY NUMBER
252: ( p_api_version IN NUMBER
253: ,p_commit IN VARCHAR2 := fnd_api.g_false
254: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
255: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
256: ,p_version_label_query_rec IN csi_datastructures_pub.version_label_query_rec
257: ,p_time_stamp IN DATE
258: ,x_version_label_tbl OUT NOCOPY csi_datastructures_pub.version_label_tbl
259: ,x_return_status OUT NOCOPY VARCHAR2
260: ,x_msg_count OUT NOCOPY NUMBER
254: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
255: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
256: ,p_version_label_query_rec IN csi_datastructures_pub.version_label_query_rec
257: ,p_time_stamp IN DATE
258: ,x_version_label_tbl OUT NOCOPY csi_datastructures_pub.version_label_tbl
259: ,x_return_status OUT NOCOPY VARCHAR2
260: ,x_msg_count OUT NOCOPY NUMBER
261: ,x_msg_data OUT NOCOPY VARCHAR2 );
262:
271: ( p_api_version IN NUMBER
272: ,p_commit IN VARCHAR2 := fnd_api.g_false
273: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
274: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
275: ,p_version_label_tbl IN OUT NOCOPY csi_datastructures_pub.version_label_tbl
276: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
277: ,x_return_status OUT NOCOPY VARCHAR2
278: ,x_msg_count OUT NOCOPY NUMBER
279: ,x_msg_data OUT NOCOPY VARCHAR2 );
272: ,p_commit IN VARCHAR2 := fnd_api.g_false
273: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
274: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
275: ,p_version_label_tbl IN OUT NOCOPY csi_datastructures_pub.version_label_tbl
276: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
277: ,x_return_status OUT NOCOPY VARCHAR2
278: ,x_msg_count OUT NOCOPY NUMBER
279: ,x_msg_data OUT NOCOPY VARCHAR2 );
280:
289: ( p_api_version IN NUMBER
290: ,p_commit IN VARCHAR2 := fnd_api.g_false
291: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
292: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
293: ,p_version_label_tbl IN csi_datastructures_pub.version_label_tbl
294: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
295: ,x_return_status OUT NOCOPY VARCHAR2
296: ,x_msg_count OUT NOCOPY NUMBER
297: ,x_msg_data OUT NOCOPY VARCHAR2 );
290: ,p_commit IN VARCHAR2 := fnd_api.g_false
291: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
292: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
293: ,p_version_label_tbl IN csi_datastructures_pub.version_label_tbl
294: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
295: ,x_return_status OUT NOCOPY VARCHAR2
296: ,x_msg_count OUT NOCOPY NUMBER
297: ,x_msg_data OUT NOCOPY VARCHAR2 );
298:
307: ( p_api_version IN NUMBER
308: ,p_commit IN VARCHAR2 := fnd_api.g_false
309: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
310: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
311: ,p_version_label_tbl IN csi_datastructures_pub.version_label_tbl
312: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
313: ,x_return_status OUT NOCOPY VARCHAR2
314: ,x_msg_count OUT NOCOPY NUMBER
315: ,x_msg_data OUT NOCOPY VARCHAR2 );
308: ,p_commit IN VARCHAR2 := fnd_api.g_false
309: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
310: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
311: ,p_version_label_tbl IN csi_datastructures_pub.version_label_tbl
312: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
313: ,x_return_status OUT NOCOPY VARCHAR2
314: ,x_msg_count OUT NOCOPY NUMBER
315: ,x_msg_data OUT NOCOPY VARCHAR2 );
316:
324: ( p_api_version IN NUMBER
325: ,p_commit IN VARCHAR2 := fnd_api.g_false
326: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
327: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
328: ,p_ext_attribs_query_rec IN csi_datastructures_pub.extend_attrib_query_rec
329: ,p_time_stamp IN DATE
330: ,x_ext_attrib_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
331: ,x_ext_attrib_def_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_tbl -- added
332: ,x_return_status OUT NOCOPY VARCHAR2
326: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
327: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
328: ,p_ext_attribs_query_rec IN csi_datastructures_pub.extend_attrib_query_rec
329: ,p_time_stamp IN DATE
330: ,x_ext_attrib_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
331: ,x_ext_attrib_def_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_tbl -- added
332: ,x_return_status OUT NOCOPY VARCHAR2
333: ,x_msg_count OUT NOCOPY NUMBER
334: ,x_msg_data OUT NOCOPY VARCHAR2
327: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
328: ,p_ext_attribs_query_rec IN csi_datastructures_pub.extend_attrib_query_rec
329: ,p_time_stamp IN DATE
330: ,x_ext_attrib_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
331: ,x_ext_attrib_def_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_tbl -- added
332: ,x_return_status OUT NOCOPY VARCHAR2
333: ,x_msg_count OUT NOCOPY NUMBER
334: ,x_msg_data OUT NOCOPY VARCHAR2
335: );
344: ( p_api_version IN NUMBER
345: ,p_commit IN VARCHAR2 := fnd_api.g_false
346: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
347: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
348: ,p_ext_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
349: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
350: ,x_return_status OUT NOCOPY VARCHAR2
351: ,x_msg_count OUT NOCOPY NUMBER
352: ,x_msg_data OUT NOCOPY VARCHAR2
345: ,p_commit IN VARCHAR2 := fnd_api.g_false
346: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
347: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
348: ,p_ext_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
349: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
350: ,x_return_status OUT NOCOPY VARCHAR2
351: ,x_msg_count OUT NOCOPY NUMBER
352: ,x_msg_data OUT NOCOPY VARCHAR2
353: );
362: ( p_api_version IN NUMBER
363: ,p_commit IN VARCHAR2 := fnd_api.g_false
364: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
365: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
366: ,p_ext_attrib_tbl IN csi_datastructures_pub.extend_attrib_values_tbl
367: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
368: ,x_return_status OUT NOCOPY VARCHAR2
369: ,x_msg_count OUT NOCOPY NUMBER
370: ,x_msg_data OUT NOCOPY VARCHAR2
363: ,p_commit IN VARCHAR2 := fnd_api.g_false
364: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
365: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
366: ,p_ext_attrib_tbl IN csi_datastructures_pub.extend_attrib_values_tbl
367: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
368: ,x_return_status OUT NOCOPY VARCHAR2
369: ,x_msg_count OUT NOCOPY NUMBER
370: ,x_msg_data OUT NOCOPY VARCHAR2
371: );
380: ( p_api_version IN NUMBER
381: ,p_commit IN VARCHAR2 := fnd_api.g_false
382: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
383: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
384: ,p_ext_attrib_tbl IN csi_datastructures_pub.extend_attrib_values_tbl
385: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
386: ,x_return_status OUT NOCOPY VARCHAR2
387: ,x_msg_count OUT NOCOPY NUMBER
388: ,x_msg_data OUT NOCOPY VARCHAR2
381: ,p_commit IN VARCHAR2 := fnd_api.g_false
382: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
383: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
384: ,p_ext_attrib_tbl IN csi_datastructures_pub.extend_attrib_values_tbl
385: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
386: ,x_return_status OUT NOCOPY VARCHAR2
387: ,x_msg_count OUT NOCOPY NUMBER
388: ,x_msg_data OUT NOCOPY VARCHAR2
389: );
427: p_api_version IN NUMBER
428: ,p_commit IN VARCHAR2 := fnd_api.g_false
429: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
430: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
431: ,p_source_instance_rec IN csi_datastructures_pub.instance_rec
432: ,p_copy_ext_attribs IN VARCHAR2 := fnd_api.g_false
433: ,p_copy_org_assignments IN VARCHAR2 := fnd_api.g_false
434: ,p_copy_parties IN VARCHAR2 := fnd_api.g_false
435: ,p_copy_party_contacts IN VARCHAR2 := fnd_api.g_false
436: ,p_copy_accounts IN VARCHAR2 := fnd_api.g_false
437: ,p_copy_asset_assignments IN VARCHAR2 := fnd_api.g_false
438: ,p_copy_pricing_attribs IN VARCHAR2 := fnd_api.g_false
439: ,p_copy_inst_children IN VARCHAR2 := fnd_api.g_false
440: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
441: ,x_new_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl
442: ,x_return_status OUT NOCOPY VARCHAR2
443: ,x_msg_count OUT NOCOPY NUMBER
444: ,x_msg_data OUT NOCOPY VARCHAR2
437: ,p_copy_asset_assignments IN VARCHAR2 := fnd_api.g_false
438: ,p_copy_pricing_attribs IN VARCHAR2 := fnd_api.g_false
439: ,p_copy_inst_children IN VARCHAR2 := fnd_api.g_false
440: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
441: ,x_new_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl
442: ,x_return_status OUT NOCOPY VARCHAR2
443: ,x_msg_count OUT NOCOPY NUMBER
444: ,x_msg_data OUT NOCOPY VARCHAR2
445: );
449: PROCEDURE get_oks_txn_types (
450: p_api_version IN NUMBER
451: ,p_commit IN VARCHAR2
452: ,p_init_msg_list IN VARCHAR2
453: ,p_instance_rec IN CSI_DATASTRUCTURES_PUB.INSTANCE_REC
454: ,p_check_contracts_yn IN VARCHAR2
455: ,p_txn_type IN VARCHAR2
456: ,x_txn_type_tbl OUT NOCOPY CSI_ITEM_INSTANCE_PUB.TXN_OKS_TYPE_TBL
457: ,x_configflag OUT NOCOPY VARCHAR2