[Home] [Help]
23: * extended attributes, pricing attributes and asset assignments.
24: * The child entities are optional except for the owner party and owner account if the
25: * instance is owned by an external party.
26: * @param p_api_version Current API version
27: * @param p_commit API commits if set to fnd_api.g_true
28: * @param p_init_msg_list Initializes the message stack if set to fnd_api.g_true
29: * @param p_validation_level API validation level
30: * @param p_instance_rec Instance Record containing the attributes of the instance to be created
31: * @param p_ext_attrib_values_tbl Extended Attributes to be associated with the item instance
24: * The child entities are optional except for the owner party and owner account if the
25: * instance is owned by an external party.
26: * @param p_api_version Current API version
27: * @param p_commit API commits if set to fnd_api.g_true
28: * @param p_init_msg_list Initializes the message stack if set to fnd_api.g_true
29: * @param p_validation_level API validation level
30: * @param p_instance_rec Instance Record containing the attributes of the instance to be created
31: * @param p_ext_attrib_values_tbl Extended Attributes to be associated with the item instance
32: * @param p_party_tbl Parties to be associated with the item instance
44: */
45: PROCEDURE create_item_instance
46: (
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
45: PROCEDURE create_item_instance
46: (
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
46: (
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
69:
70: /*#
71: * This procedure updates an existing item instance and its child entities in Install Base.
72: * @param p_api_version API version
73: * @param p_commit API commits if set to fnd_api.g_true
74: * @param p_init_msg_list Initializes the message stack if set to fnd_api.g_true
75: * @param p_validation_level API validation level
76: * @param p_instance_rec Instance Record structure containing the instance that needs to be updated
77: * @param p_ext_attrib_values_tbl Extended Attributes to be updated
70: /*#
71: * This procedure updates an existing item instance and its child entities in Install Base.
72: * @param p_api_version API version
73: * @param p_commit API commits if set to fnd_api.g_true
74: * @param p_init_msg_list Initializes the message stack if set to fnd_api.g_true
75: * @param p_validation_level API validation level
76: * @param p_instance_rec Instance Record structure containing the instance that needs to be updated
77: * @param p_ext_attrib_values_tbl Extended Attributes to be updated
78: * @param p_party_tbl Parties to be updated
91: */
92: PROCEDURE update_item_instance
93: (
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
92: PROCEDURE update_item_instance
93: (
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
93: (
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
117:
118: PROCEDURE expire_item_instance
119: (
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
118: PROCEDURE expire_item_instance
119: (
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
119: (
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
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
129: ,x_msg_count OUT NOCOPY NUMBER
139: /*#
140: * This procedure gets a list of item instances in Oracle Install Base satisfying the
141: * query criteria provided by the calling application.
142: * @param p_api_version API version
143: * @param p_commit API commits if set to fnd_api.g_true
144: * @param p_init_msg_list Initializes the message stack if set to fnd_api.g_true
145: * @param p_validation_level API validation level
146: * @param p_instance_query_rec Instance query criteria record structure
147: * @param p_party_query_rec Party query criteria record structure
140: * This procedure gets a list of item instances in Oracle Install Base satisfying the
141: * query criteria provided by the calling application.
142: * @param p_api_version API version
143: * @param p_commit API commits if set to fnd_api.g_true
144: * @param p_init_msg_list Initializes the message stack if set to fnd_api.g_true
145: * @param p_validation_level API validation level
146: * @param p_instance_query_rec Instance query criteria record structure
147: * @param p_party_query_rec Party query criteria record structure
148: * @param p_account_query_rec Party Account query criteria record structure
159: */
160: PROCEDURE get_item_instances
161: (
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
160: PROCEDURE get_item_instances
161: (
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
161: (
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
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
173: ,x_return_status OUT NOCOPY VARCHAR2
174: ,x_msg_count OUT NOCOPY NUMBER
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
173: ,x_return_status OUT NOCOPY VARCHAR2
174: ,x_msg_count OUT NOCOPY NUMBER
175: ,x_msg_data OUT NOCOPY VARCHAR2
179: * This procedure gets the details of an Item Instance at a given point of time along with other
180: * entities if needed. It uses only the instance query criteria to get the instances and the
181: * information is constructed from history if a time stamp is passed. If the time stamp is not
182: * passed then the current information would be retreived. The other entities are retreived if the
183: * corresponding p_get's are set to fnd_api.g_true.
184: * @param p_api_version API version
185: * @param p_commit API commits if set to fnd_api.g_true
186: * @param p_init_msg_list Initializes the message stack if set to fnd_api.g_true
187: * @param p_validation_level API validation level
181: * information is constructed from history if a time stamp is passed. If the time stamp is not
182: * passed then the current information would be retreived. The other entities are retreived if the
183: * corresponding p_get's are set to fnd_api.g_true.
184: * @param p_api_version API version
185: * @param p_commit API commits if set to fnd_api.g_true
186: * @param p_init_msg_list Initializes the message stack if set to fnd_api.g_true
187: * @param p_validation_level API validation level
188: * @param p_instance_rec Instance record structure containing the instance_id to be queried and the output
189: * @param p_get_parties Decides whether to get Party information
182: * passed then the current information would be retreived. The other entities are retreived if the
183: * corresponding p_get's are set to fnd_api.g_true.
184: * @param p_api_version API version
185: * @param p_commit API commits if set to fnd_api.g_true
186: * @param p_init_msg_list Initializes the message stack if set to fnd_api.g_true
187: * @param p_validation_level API validation level
188: * @param p_instance_rec Instance record structure containing the instance_id to be queried and the output
189: * @param p_get_parties Decides whether to get Party information
190: * @param p_party_header_tbl Contains the output of Party for the instance
216:
217: PROCEDURE get_item_instance_details
218: (
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
217: PROCEDURE get_item_instance_details
218: (
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
218: (
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
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
228: ,p_get_org_assignments 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
230: ,p_get_pricing_attribs IN VARCHAR2 := fnd_api.g_false
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
232: ,p_get_ext_attribs IN VARCHAR2 := fnd_api.g_false
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
234: ,p_ext_attrib_def_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_tbl --added
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
236: ,p_asset_header_tbl OUT NOCOPY csi_datastructures_pub.instance_asset_header_tbl
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
239: ,x_return_status OUT NOCOPY VARCHAR2
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
241: ,x_msg_data OUT NOCOPY VARCHAR2
249: /*----------------------------------------------------*/
250:
251: PROCEDURE get_version_labels
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
250:
251: PROCEDURE get_version_labels
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
251: PROCEDURE get_version_labels
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
268: /*----------------------------------------------------*/
269:
270: PROCEDURE create_version_label
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
269:
270: PROCEDURE create_version_label
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
270: PROCEDURE create_version_label
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
286: /*----------------------------------------------------*/
287:
288: PROCEDURE update_version_label
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
287:
288: PROCEDURE update_version_label
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
288: PROCEDURE update_version_label
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
304: /*----------------------------------------------------*/
305:
306: PROCEDURE expire_version_label
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
305:
306: PROCEDURE expire_version_label
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
306: PROCEDURE expire_version_label
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
321: /*----------------------------------------------------*/
322:
323: PROCEDURE get_extended_attrib_values
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
322:
323: PROCEDURE get_extended_attrib_values
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
323: PROCEDURE get_extended_attrib_values
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
341: /*----------------------------------------------------*/
342:
343: PROCEDURE create_extended_attrib_values
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
342:
343: PROCEDURE create_extended_attrib_values
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
343: PROCEDURE create_extended_attrib_values
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
359: /*----------------------------------------------------*/
360:
361: PROCEDURE update_extended_attrib_values
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
360:
361: PROCEDURE update_extended_attrib_values
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
361: PROCEDURE update_extended_attrib_values
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
377: /*----------------------------------------------------*/
378:
379: PROCEDURE expire_extended_attrib_values
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
378:
379: PROCEDURE expire_extended_attrib_values
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
379: PROCEDURE expire_extended_attrib_values
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
398: /*#
399: * This procedure creates a new item instance and its child entities by copying an existing
400: * item instance in Oracle Install Base.
401: * The child instances underneath the source instance would be copied if the parameter p_copy_inst_children
402: * is set to fnd_api.g_true.
403: * @param p_api_version API version
404: * @param p_commit API commits if set to fnd_api.g_true
405: * @param p_init_msg_list Initializes the message stack if set to fnd_api.g_true
406: * @param p_validation_level API validation level
400: * item instance in Oracle Install Base.
401: * The child instances underneath the source instance would be copied if the parameter p_copy_inst_children
402: * is set to fnd_api.g_true.
403: * @param p_api_version API version
404: * @param p_commit API commits if set to fnd_api.g_true
405: * @param p_init_msg_list Initializes the message stack if set to fnd_api.g_true
406: * @param p_validation_level API validation level
407: * @param p_source_instance_rec Contains the source instance record that needs to be copied
408: * @param p_copy_ext_attribs Determines whether to copy Extended Attributes for the instance
401: * The child instances underneath the source instance would be copied if the parameter p_copy_inst_children
402: * is set to fnd_api.g_true.
403: * @param p_api_version API version
404: * @param p_commit API commits if set to fnd_api.g_true
405: * @param p_init_msg_list Initializes the message stack if set to fnd_api.g_true
406: * @param p_validation_level API validation level
407: * @param p_source_instance_rec Contains the source instance record that needs to be copied
408: * @param p_copy_ext_attribs Determines whether to copy Extended Attributes for the instance
409: * @param p_copy_org_assignments Determines whether to copy Org Assignments for the instance
424: */
425: PROCEDURE copy_item_instance
426: (
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
425: PROCEDURE copy_item_instance
426: (
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
426: (
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
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
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
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
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
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
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
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
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