81: l_Create_Dest_Inst_Flag VARCHAR2(1);
82: l_Validation_Level NUMBER;
83: l_Active_Instance_Only VARCHAR2(1);
84: l_Resolve_Id_Column VARCHAR2(1);
85: l_Instance_Header_Tbl_Out csi_datastructures_pub.instance_header_tbl;
86: l_Instance_Rec csi_datastructures_pub.Instance_Rec;
87: l_Dest_Instance_Rec csi_datastructures_pub.Instance_Rec;
88: l_Instance_Query_Rec csi_datastructures_pub.Instance_Query_Rec;
89: l_txn_rec csi_datastructures_pub.transaction_rec;
82: l_Validation_Level NUMBER;
83: l_Active_Instance_Only VARCHAR2(1);
84: l_Resolve_Id_Column VARCHAR2(1);
85: l_Instance_Header_Tbl_Out csi_datastructures_pub.instance_header_tbl;
86: l_Instance_Rec csi_datastructures_pub.Instance_Rec;
87: l_Dest_Instance_Rec csi_datastructures_pub.Instance_Rec;
88: l_Instance_Query_Rec csi_datastructures_pub.Instance_Query_Rec;
89: l_txn_rec csi_datastructures_pub.transaction_rec;
90: l_upd_txn_rec csi_datastructures_pub.transaction_rec;
83: l_Active_Instance_Only VARCHAR2(1);
84: l_Resolve_Id_Column VARCHAR2(1);
85: l_Instance_Header_Tbl_Out csi_datastructures_pub.instance_header_tbl;
86: l_Instance_Rec csi_datastructures_pub.Instance_Rec;
87: l_Dest_Instance_Rec csi_datastructures_pub.Instance_Rec;
88: l_Instance_Query_Rec csi_datastructures_pub.Instance_Query_Rec;
89: l_txn_rec csi_datastructures_pub.transaction_rec;
90: l_upd_txn_rec csi_datastructures_pub.transaction_rec;
91: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
84: l_Resolve_Id_Column VARCHAR2(1);
85: l_Instance_Header_Tbl_Out csi_datastructures_pub.instance_header_tbl;
86: l_Instance_Rec csi_datastructures_pub.Instance_Rec;
87: l_Dest_Instance_Rec csi_datastructures_pub.Instance_Rec;
88: l_Instance_Query_Rec csi_datastructures_pub.Instance_Query_Rec;
89: l_txn_rec csi_datastructures_pub.transaction_rec;
90: l_upd_txn_rec csi_datastructures_pub.transaction_rec;
91: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
92: l_Party_Query_Rec csi_datastructures_pub.party_query_rec;
85: l_Instance_Header_Tbl_Out csi_datastructures_pub.instance_header_tbl;
86: l_Instance_Rec csi_datastructures_pub.Instance_Rec;
87: l_Dest_Instance_Rec csi_datastructures_pub.Instance_Rec;
88: l_Instance_Query_Rec csi_datastructures_pub.Instance_Query_Rec;
89: l_txn_rec csi_datastructures_pub.transaction_rec;
90: l_upd_txn_rec csi_datastructures_pub.transaction_rec;
91: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
92: l_Party_Query_Rec csi_datastructures_pub.party_query_rec;
93: l_party_tbl csi_datastructures_pub.party_tbl;
86: l_Instance_Rec csi_datastructures_pub.Instance_Rec;
87: l_Dest_Instance_Rec csi_datastructures_pub.Instance_Rec;
88: l_Instance_Query_Rec csi_datastructures_pub.Instance_Query_Rec;
89: l_txn_rec csi_datastructures_pub.transaction_rec;
90: l_upd_txn_rec csi_datastructures_pub.transaction_rec;
91: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
92: l_Party_Query_Rec csi_datastructures_pub.party_query_rec;
93: l_party_tbl csi_datastructures_pub.party_tbl;
94: l_account_tbl csi_datastructures_pub.party_account_tbl;
87: l_Dest_Instance_Rec csi_datastructures_pub.Instance_Rec;
88: l_Instance_Query_Rec csi_datastructures_pub.Instance_Query_Rec;
89: l_txn_rec csi_datastructures_pub.transaction_rec;
90: l_upd_txn_rec csi_datastructures_pub.transaction_rec;
91: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
92: l_Party_Query_Rec csi_datastructures_pub.party_query_rec;
93: l_party_tbl csi_datastructures_pub.party_tbl;
94: l_account_tbl csi_datastructures_pub.party_account_tbl;
95: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
88: l_Instance_Query_Rec csi_datastructures_pub.Instance_Query_Rec;
89: l_txn_rec csi_datastructures_pub.transaction_rec;
90: l_upd_txn_rec csi_datastructures_pub.transaction_rec;
91: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
92: l_Party_Query_Rec csi_datastructures_pub.party_query_rec;
93: l_party_tbl csi_datastructures_pub.party_tbl;
94: l_account_tbl csi_datastructures_pub.party_account_tbl;
95: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
96: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
89: l_txn_rec csi_datastructures_pub.transaction_rec;
90: l_upd_txn_rec csi_datastructures_pub.transaction_rec;
91: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
92: l_Party_Query_Rec csi_datastructures_pub.party_query_rec;
93: l_party_tbl csi_datastructures_pub.party_tbl;
94: l_account_tbl csi_datastructures_pub.party_account_tbl;
95: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
96: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
97: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
90: l_upd_txn_rec csi_datastructures_pub.transaction_rec;
91: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
92: l_Party_Query_Rec csi_datastructures_pub.party_query_rec;
93: l_party_tbl csi_datastructures_pub.party_tbl;
94: l_account_tbl csi_datastructures_pub.party_account_tbl;
95: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
96: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
97: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
98: l_Instance_Id_Lst csi_datastructures_pub.Id_Tbl;
91: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
92: l_Party_Query_Rec csi_datastructures_pub.party_query_rec;
93: l_party_tbl csi_datastructures_pub.party_tbl;
94: l_account_tbl csi_datastructures_pub.party_account_tbl;
95: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
96: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
97: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
98: l_Instance_Id_Lst csi_datastructures_pub.Id_Tbl;
99: l_msg_index NUMBER;
92: l_Party_Query_Rec csi_datastructures_pub.party_query_rec;
93: l_party_tbl csi_datastructures_pub.party_tbl;
94: l_account_tbl csi_datastructures_pub.party_account_tbl;
95: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
96: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
97: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
98: l_Instance_Id_Lst csi_datastructures_pub.Id_Tbl;
99: l_msg_index NUMBER;
100: i PLS_INTEGER;
93: l_party_tbl csi_datastructures_pub.party_tbl;
94: l_account_tbl csi_datastructures_pub.party_account_tbl;
95: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
96: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
97: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
98: l_Instance_Id_Lst csi_datastructures_pub.Id_Tbl;
99: l_msg_index NUMBER;
100: i PLS_INTEGER;
101: l_S_object_version_number NUMBER :=1;
94: l_account_tbl csi_datastructures_pub.party_account_tbl;
95: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
96: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
97: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
98: l_Instance_Id_Lst csi_datastructures_pub.Id_Tbl;
99: l_msg_index NUMBER;
100: i PLS_INTEGER;
101: l_S_object_version_number NUMBER :=1;
102: l_D_object_version_number NUMBER :=1;
103: l_object_version_number NUMBER :=1;
104: l_s_mfg_serial_number_flag VARCHAR2(1);
105: l_Msg_Count NUMBER;
106: l_Msg_Data VARCHAR2(2000);
107: l_Account_Query_Rec csi_datastructures_pub.party_account_query_rec;
108: l_s_last_vld_organization_id NUMBER;
109: l_Transaction_Id NUMBER;
110: l_transaction_type_id NUMBER;
111: l_Return_Status VARCHAR2(1);