25: p_proceeds_of_sale IN number,
26: p_cost_of_removal IN number,
27: p_operational_flag IN varchar2 default 'N',
28: p_financial_flag IN varchar2 default 'N',
29: px_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
30: x_return_status OUT nocopy varchar2)
31: IS
32:
33: CURSOR inst_asset_cur IS
53: l_last_vld_organization_id number;
54: l_object_version_number number;
55:
56:
57: l_source_instance_rec csi_datastructures_pub.instance_rec;
58: l_new_instance_rec csi_datastructures_pub.instance_rec;
59: l_source_instance_qty number;
60: l_new_instance_qty number;
61:
54: l_object_version_number number;
55:
56:
57: l_source_instance_rec csi_datastructures_pub.instance_rec;
58: l_new_instance_rec csi_datastructures_pub.instance_rec;
59: l_source_instance_qty number;
60: l_new_instance_qty number;
61:
62: l_u_instance_rec csi_datastructures_pub.instance_rec;
58: l_new_instance_rec csi_datastructures_pub.instance_rec;
59: l_source_instance_qty number;
60: l_new_instance_qty number;
61:
62: l_u_instance_rec csi_datastructures_pub.instance_rec;
63: l_u_parties_tbl csi_datastructures_pub.party_tbl;
64: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
65: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
66: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
59: l_source_instance_qty number;
60: l_new_instance_qty number;
61:
62: l_u_instance_rec csi_datastructures_pub.instance_rec;
63: l_u_parties_tbl csi_datastructures_pub.party_tbl;
64: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
65: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
66: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
67: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
60: l_new_instance_qty number;
61:
62: l_u_instance_rec csi_datastructures_pub.instance_rec;
63: l_u_parties_tbl csi_datastructures_pub.party_tbl;
64: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
65: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
66: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
67: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
68: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
61:
62: l_u_instance_rec csi_datastructures_pub.instance_rec;
63: l_u_parties_tbl csi_datastructures_pub.party_tbl;
64: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
65: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
66: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
67: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
68: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
69: l_instance_ids_list csi_datastructures_pub.id_tbl;
62: l_u_instance_rec csi_datastructures_pub.instance_rec;
63: l_u_parties_tbl csi_datastructures_pub.party_tbl;
64: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
65: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
66: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
67: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
68: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
69: l_instance_ids_list csi_datastructures_pub.id_tbl;
70:
63: l_u_parties_tbl csi_datastructures_pub.party_tbl;
64: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
65: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
66: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
67: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
68: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
69: l_instance_ids_list csi_datastructures_pub.id_tbl;
70:
71: l_msg_data varchar2(2000);
64: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
65: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
66: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
67: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
68: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
69: l_instance_ids_list csi_datastructures_pub.id_tbl;
70:
71: l_msg_data varchar2(2000);
72: l_msg_count number;
65: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
66: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
67: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
68: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
69: l_instance_ids_list csi_datastructures_pub.id_tbl;
70:
71: l_msg_data varchar2(2000);
72: l_msg_count number;
73: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
282: x_return_status OUT nocopy varchar2)
283: IS
284:
285: -- giid variables
286: l_inst_rec csi_datastructures_pub.instance_header_rec ;
287: l_pty_tbl csi_datastructures_pub.party_header_tbl ;
288: l_pty_acct_tbl csi_datastructures_pub.party_account_header_tbl ;
289: l_org_tbl csi_datastructures_pub.org_units_header_tbl ;
290: l_price_tbl csi_datastructures_pub.pricing_attribs_tbl ;
283: IS
284:
285: -- giid variables
286: l_inst_rec csi_datastructures_pub.instance_header_rec ;
287: l_pty_tbl csi_datastructures_pub.party_header_tbl ;
288: l_pty_acct_tbl csi_datastructures_pub.party_account_header_tbl ;
289: l_org_tbl csi_datastructures_pub.org_units_header_tbl ;
290: l_price_tbl csi_datastructures_pub.pricing_attribs_tbl ;
291: l_ea_tbl csi_datastructures_pub.extend_attrib_tbl ;
284:
285: -- giid variables
286: l_inst_rec csi_datastructures_pub.instance_header_rec ;
287: l_pty_tbl csi_datastructures_pub.party_header_tbl ;
288: l_pty_acct_tbl csi_datastructures_pub.party_account_header_tbl ;
289: l_org_tbl csi_datastructures_pub.org_units_header_tbl ;
290: l_price_tbl csi_datastructures_pub.pricing_attribs_tbl ;
291: l_ea_tbl csi_datastructures_pub.extend_attrib_tbl ;
292: l_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl ;
285: -- giid variables
286: l_inst_rec csi_datastructures_pub.instance_header_rec ;
287: l_pty_tbl csi_datastructures_pub.party_header_tbl ;
288: l_pty_acct_tbl csi_datastructures_pub.party_account_header_tbl ;
289: l_org_tbl csi_datastructures_pub.org_units_header_tbl ;
290: l_price_tbl csi_datastructures_pub.pricing_attribs_tbl ;
291: l_ea_tbl csi_datastructures_pub.extend_attrib_tbl ;
292: l_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl ;
293: l_ia_tbl csi_datastructures_pub.instance_asset_header_tbl;
286: l_inst_rec csi_datastructures_pub.instance_header_rec ;
287: l_pty_tbl csi_datastructures_pub.party_header_tbl ;
288: l_pty_acct_tbl csi_datastructures_pub.party_account_header_tbl ;
289: l_org_tbl csi_datastructures_pub.org_units_header_tbl ;
290: l_price_tbl csi_datastructures_pub.pricing_attribs_tbl ;
291: l_ea_tbl csi_datastructures_pub.extend_attrib_tbl ;
292: l_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl ;
293: l_ia_tbl csi_datastructures_pub.instance_asset_header_tbl;
294: l_time_stamp date := null;
287: l_pty_tbl csi_datastructures_pub.party_header_tbl ;
288: l_pty_acct_tbl csi_datastructures_pub.party_account_header_tbl ;
289: l_org_tbl csi_datastructures_pub.org_units_header_tbl ;
290: l_price_tbl csi_datastructures_pub.pricing_attribs_tbl ;
291: l_ea_tbl csi_datastructures_pub.extend_attrib_tbl ;
292: l_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl ;
293: l_ia_tbl csi_datastructures_pub.instance_asset_header_tbl;
294: l_time_stamp date := null;
295:
288: l_pty_acct_tbl csi_datastructures_pub.party_account_header_tbl ;
289: l_org_tbl csi_datastructures_pub.org_units_header_tbl ;
290: l_price_tbl csi_datastructures_pub.pricing_attribs_tbl ;
291: l_ea_tbl csi_datastructures_pub.extend_attrib_tbl ;
292: l_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl ;
293: l_ia_tbl csi_datastructures_pub.instance_asset_header_tbl;
294: l_time_stamp date := null;
295:
296: -- out variables build
289: l_org_tbl csi_datastructures_pub.org_units_header_tbl ;
290: l_price_tbl csi_datastructures_pub.pricing_attribs_tbl ;
291: l_ea_tbl csi_datastructures_pub.extend_attrib_tbl ;
292: l_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl ;
293: l_ia_tbl csi_datastructures_pub.instance_asset_header_tbl;
294: l_time_stamp date := null;
295:
296: -- out variables build
297: l_t_pty_tbl csi_process_txn_grp.txn_i_parties_tbl ;
488: p_txn_tbl IN OUT NOCOPY transaction_tbl,
489: x_return_status OUT NOCOPY VARCHAR2,
490: x_error_msg OUT NOCOPY VARCHAR2 )
491: IS
492: l_txn_error_rec csi_datastructures_pub.transaction_error_rec ;
493: l_txn_rec csi_datastructures_pub.transaction_rec ;
494: l_t_inst_tbl csi_process_txn_grp.txn_instances_tbl ;
495: l_t_party_tbl csi_process_txn_grp.txn_i_parties_tbl ;
496: l_t_pty_acct_tbl csi_process_txn_grp.txn_ip_accounts_tbl ;
489: x_return_status OUT NOCOPY VARCHAR2,
490: x_error_msg OUT NOCOPY VARCHAR2 )
491: IS
492: l_txn_error_rec csi_datastructures_pub.transaction_error_rec ;
493: l_txn_rec csi_datastructures_pub.transaction_rec ;
494: l_t_inst_tbl csi_process_txn_grp.txn_instances_tbl ;
495: l_t_party_tbl csi_process_txn_grp.txn_i_parties_tbl ;
496: l_t_pty_acct_tbl csi_process_txn_grp.txn_ip_accounts_tbl ;
497: l_t_ou_tbl csi_process_txn_grp.txn_org_units_tbl ;