DBA Data[Home] [Help]

APPS.CSI_ACCT_MERGE_PKG dependencies on CSI_DATASTRUCTURES_PUB

Line 189: l_g_instance_rec csi_datastructures_pub.instance_header_rec;

185: l_msg_data VARCHAR2(2000);
186:
187: -- Variables for 'GET ITEM INSTANCE DETAILS' API call
188:
189: l_g_instance_rec csi_datastructures_pub.instance_header_rec;
190: l_g_ph_tbl csi_datastructures_pub.party_header_tbl;
191: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
192: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
193: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 190: l_g_ph_tbl csi_datastructures_pub.party_header_tbl;

186:
187: -- Variables for 'GET ITEM INSTANCE DETAILS' API call
188:
189: l_g_instance_rec csi_datastructures_pub.instance_header_rec;
190: l_g_ph_tbl csi_datastructures_pub.party_header_tbl;
191: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
192: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
193: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
194: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;

Line 191: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;

187: -- Variables for 'GET ITEM INSTANCE DETAILS' API call
188:
189: l_g_instance_rec csi_datastructures_pub.instance_header_rec;
190: l_g_ph_tbl csi_datastructures_pub.party_header_tbl;
191: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
192: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
193: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
194: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
195: l_g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;

Line 192: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;

188:
189: l_g_instance_rec csi_datastructures_pub.instance_header_rec;
190: l_g_ph_tbl csi_datastructures_pub.party_header_tbl;
191: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
192: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
193: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
194: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
195: l_g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;
196: l_g_iah_tbl csi_datastructures_pub.instance_asset_header_tbl;

Line 193: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;

189: l_g_instance_rec csi_datastructures_pub.instance_header_rec;
190: l_g_ph_tbl csi_datastructures_pub.party_header_tbl;
191: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
192: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
193: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
194: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
195: l_g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;
196: l_g_iah_tbl csi_datastructures_pub.instance_asset_header_tbl;
197: l_g_time_stamp date;

Line 194: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;

190: l_g_ph_tbl csi_datastructures_pub.party_header_tbl;
191: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
192: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
193: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
194: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
195: l_g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;
196: l_g_iah_tbl csi_datastructures_pub.instance_asset_header_tbl;
197: l_g_time_stamp date;
198:

Line 195: l_g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;

191: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
192: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
193: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
194: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
195: l_g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;
196: l_g_iah_tbl csi_datastructures_pub.instance_asset_header_tbl;
197: l_g_time_stamp date;
198:
199: -- Variables for 'UPDATE ITEM INSTANCE' API call

Line 196: l_g_iah_tbl csi_datastructures_pub.instance_asset_header_tbl;

192: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
193: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
194: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
195: l_g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;
196: l_g_iah_tbl csi_datastructures_pub.instance_asset_header_tbl;
197: l_g_time_stamp date;
198:
199: -- Variables for 'UPDATE ITEM INSTANCE' API call
200:

Line 201: p_u_instance_rec csi_datastructures_pub.instance_rec;

197: l_g_time_stamp date;
198:
199: -- Variables for 'UPDATE ITEM INSTANCE' API call
200:
201: p_u_instance_rec csi_datastructures_pub.instance_rec;
202: p_u_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
203: p_u_party_tbl csi_datastructures_pub.party_tbl;
204: p_u_party_account_tbl csi_datastructures_pub.party_account_tbl;
205: p_u_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 202: p_u_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;

198:
199: -- Variables for 'UPDATE ITEM INSTANCE' API call
200:
201: p_u_instance_rec csi_datastructures_pub.instance_rec;
202: p_u_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
203: p_u_party_tbl csi_datastructures_pub.party_tbl;
204: p_u_party_account_tbl csi_datastructures_pub.party_account_tbl;
205: p_u_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
206: p_u_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;

Line 203: p_u_party_tbl csi_datastructures_pub.party_tbl;

199: -- Variables for 'UPDATE ITEM INSTANCE' API call
200:
201: p_u_instance_rec csi_datastructures_pub.instance_rec;
202: p_u_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
203: p_u_party_tbl csi_datastructures_pub.party_tbl;
204: p_u_party_account_tbl csi_datastructures_pub.party_account_tbl;
205: p_u_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
206: p_u_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
207: p_u_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;

Line 204: p_u_party_account_tbl csi_datastructures_pub.party_account_tbl;

200:
201: p_u_instance_rec csi_datastructures_pub.instance_rec;
202: p_u_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
203: p_u_party_tbl csi_datastructures_pub.party_tbl;
204: p_u_party_account_tbl csi_datastructures_pub.party_account_tbl;
205: p_u_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
206: p_u_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
207: p_u_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
208: p_txn_rec csi_datastructures_pub.transaction_rec;

Line 205: p_u_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;

201: p_u_instance_rec csi_datastructures_pub.instance_rec;
202: p_u_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
203: p_u_party_tbl csi_datastructures_pub.party_tbl;
204: p_u_party_account_tbl csi_datastructures_pub.party_account_tbl;
205: p_u_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
206: p_u_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
207: p_u_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
208: p_txn_rec csi_datastructures_pub.transaction_rec;
209: x_instance_id_lst csi_datastructures_pub.id_tbl;

Line 206: p_u_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;

202: p_u_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
203: p_u_party_tbl csi_datastructures_pub.party_tbl;
204: p_u_party_account_tbl csi_datastructures_pub.party_account_tbl;
205: p_u_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
206: p_u_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
207: p_u_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
208: p_txn_rec csi_datastructures_pub.transaction_rec;
209: x_instance_id_lst csi_datastructures_pub.id_tbl;
210:

Line 207: p_u_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;

203: p_u_party_tbl csi_datastructures_pub.party_tbl;
204: p_u_party_account_tbl csi_datastructures_pub.party_account_tbl;
205: p_u_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
206: p_u_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
207: p_u_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
208: p_txn_rec csi_datastructures_pub.transaction_rec;
209: x_instance_id_lst csi_datastructures_pub.id_tbl;
210:
211: -- local

Line 208: p_txn_rec csi_datastructures_pub.transaction_rec;

204: p_u_party_account_tbl csi_datastructures_pub.party_account_tbl;
205: p_u_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
206: p_u_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
207: p_u_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
208: p_txn_rec csi_datastructures_pub.transaction_rec;
209: x_instance_id_lst csi_datastructures_pub.id_tbl;
210:
211: -- local
212: l_merge_excep EXCEPTION;

Line 209: x_instance_id_lst csi_datastructures_pub.id_tbl;

205: p_u_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
206: p_u_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
207: p_u_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
208: p_txn_rec csi_datastructures_pub.transaction_rec;
209: x_instance_id_lst csi_datastructures_pub.id_tbl;
210:
211: -- local
212: l_merge_excep EXCEPTION;
213: l_install_location_type_code VARCHAR2(30);