DBA Data[Home] [Help]

APPS.CSI_ACCT_MERGE_PKG dependencies on CSI_DATASTRUCTURES_PUB

Line 215: l_g_instance_rec csi_datastructures_pub.instance_header_rec;

211: l_msg_data VARCHAR2(2000);
212:
213: -- Variables for 'GET ITEM INSTANCE DETAILS' API call
214:
215: l_g_instance_rec csi_datastructures_pub.instance_header_rec;
216: l_g_ph_tbl csi_datastructures_pub.party_header_tbl;
217: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
218: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
219: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 216: l_g_ph_tbl csi_datastructures_pub.party_header_tbl;

212:
213: -- Variables for 'GET ITEM INSTANCE DETAILS' API call
214:
215: l_g_instance_rec csi_datastructures_pub.instance_header_rec;
216: l_g_ph_tbl csi_datastructures_pub.party_header_tbl;
217: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
218: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
219: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
220: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;

Line 217: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;

213: -- Variables for 'GET ITEM INSTANCE DETAILS' API call
214:
215: l_g_instance_rec csi_datastructures_pub.instance_header_rec;
216: l_g_ph_tbl csi_datastructures_pub.party_header_tbl;
217: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
218: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
219: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
220: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
221: l_g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;

Line 218: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;

214:
215: l_g_instance_rec csi_datastructures_pub.instance_header_rec;
216: l_g_ph_tbl csi_datastructures_pub.party_header_tbl;
217: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
218: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
219: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
220: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
221: l_g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;
222: l_g_iah_tbl csi_datastructures_pub.instance_asset_header_tbl;

Line 219: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;

215: l_g_instance_rec csi_datastructures_pub.instance_header_rec;
216: l_g_ph_tbl csi_datastructures_pub.party_header_tbl;
217: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
218: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
219: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
220: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
221: l_g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;
222: l_g_iah_tbl csi_datastructures_pub.instance_asset_header_tbl;
223: l_g_time_stamp date;

Line 220: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;

216: l_g_ph_tbl csi_datastructures_pub.party_header_tbl;
217: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
218: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
219: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
220: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
221: l_g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;
222: l_g_iah_tbl csi_datastructures_pub.instance_asset_header_tbl;
223: l_g_time_stamp date;
224:

Line 221: l_g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;

217: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
218: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
219: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
220: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
221: l_g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;
222: l_g_iah_tbl csi_datastructures_pub.instance_asset_header_tbl;
223: l_g_time_stamp date;
224:
225: -- Variables for 'UPDATE ITEM INSTANCE' API call

Line 222: l_g_iah_tbl csi_datastructures_pub.instance_asset_header_tbl;

218: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
219: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
220: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
221: l_g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;
222: l_g_iah_tbl csi_datastructures_pub.instance_asset_header_tbl;
223: l_g_time_stamp date;
224:
225: -- Variables for 'UPDATE ITEM INSTANCE' API call
226:

Line 227: p_u_instance_rec csi_datastructures_pub.instance_rec;

223: l_g_time_stamp date;
224:
225: -- Variables for 'UPDATE ITEM INSTANCE' API call
226:
227: p_u_instance_rec csi_datastructures_pub.instance_rec;
228: p_u_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
229: p_u_party_tbl csi_datastructures_pub.party_tbl;
230: p_u_party_account_tbl csi_datastructures_pub.party_account_tbl;
231: p_u_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 228: p_u_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;

224:
225: -- Variables for 'UPDATE ITEM INSTANCE' API call
226:
227: p_u_instance_rec csi_datastructures_pub.instance_rec;
228: p_u_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
229: p_u_party_tbl csi_datastructures_pub.party_tbl;
230: p_u_party_account_tbl csi_datastructures_pub.party_account_tbl;
231: p_u_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
232: p_u_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;

Line 229: p_u_party_tbl csi_datastructures_pub.party_tbl;

225: -- Variables for 'UPDATE ITEM INSTANCE' API call
226:
227: p_u_instance_rec csi_datastructures_pub.instance_rec;
228: p_u_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
229: p_u_party_tbl csi_datastructures_pub.party_tbl;
230: p_u_party_account_tbl csi_datastructures_pub.party_account_tbl;
231: p_u_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
232: p_u_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
233: p_u_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;

Line 230: p_u_party_account_tbl csi_datastructures_pub.party_account_tbl;

226:
227: p_u_instance_rec csi_datastructures_pub.instance_rec;
228: p_u_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
229: p_u_party_tbl csi_datastructures_pub.party_tbl;
230: p_u_party_account_tbl csi_datastructures_pub.party_account_tbl;
231: p_u_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
232: p_u_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
233: p_u_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
234: p_txn_rec csi_datastructures_pub.transaction_rec;

Line 231: p_u_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;

227: p_u_instance_rec csi_datastructures_pub.instance_rec;
228: p_u_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
229: p_u_party_tbl csi_datastructures_pub.party_tbl;
230: p_u_party_account_tbl csi_datastructures_pub.party_account_tbl;
231: p_u_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
232: p_u_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
233: p_u_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
234: p_txn_rec csi_datastructures_pub.transaction_rec;
235: x_instance_id_lst csi_datastructures_pub.id_tbl;

Line 232: p_u_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;

228: p_u_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
229: p_u_party_tbl csi_datastructures_pub.party_tbl;
230: p_u_party_account_tbl csi_datastructures_pub.party_account_tbl;
231: p_u_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
232: p_u_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
233: p_u_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
234: p_txn_rec csi_datastructures_pub.transaction_rec;
235: x_instance_id_lst csi_datastructures_pub.id_tbl;
236:

Line 233: p_u_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;

229: p_u_party_tbl csi_datastructures_pub.party_tbl;
230: p_u_party_account_tbl csi_datastructures_pub.party_account_tbl;
231: p_u_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
232: p_u_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
233: p_u_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
234: p_txn_rec csi_datastructures_pub.transaction_rec;
235: x_instance_id_lst csi_datastructures_pub.id_tbl;
236:
237: -- local

Line 234: p_txn_rec csi_datastructures_pub.transaction_rec;

230: p_u_party_account_tbl csi_datastructures_pub.party_account_tbl;
231: p_u_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
232: p_u_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
233: p_u_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
234: p_txn_rec csi_datastructures_pub.transaction_rec;
235: x_instance_id_lst csi_datastructures_pub.id_tbl;
236:
237: -- local
238: l_merge_excep EXCEPTION;

Line 235: x_instance_id_lst csi_datastructures_pub.id_tbl;

231: p_u_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
232: p_u_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
233: p_u_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
234: p_txn_rec csi_datastructures_pub.transaction_rec;
235: x_instance_id_lst csi_datastructures_pub.id_tbl;
236:
237: -- local
238: l_merge_excep EXCEPTION;
239: l_install_location_type_code VARCHAR2(30);