526: --Adithya added variables as part of fix for Bug# 6683990
527: l_matches_flag VARCHAR2(1);
528: l_root_uc_header_id NUMBER;
529: --
530: l_csi_instance_id_lst CSI_DATASTRUCTURES_PUB.Id_Tbl;
531: --
532: l_csi_instance_rec csi_datastructures_pub.instance_rec;
533: l_csi_party_rec csi_datastructures_pub.party_rec;
534: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
528: l_root_uc_header_id NUMBER;
529: --
530: l_csi_instance_id_lst CSI_DATASTRUCTURES_PUB.Id_Tbl;
531: --
532: l_csi_instance_rec csi_datastructures_pub.instance_rec;
533: l_csi_party_rec csi_datastructures_pub.party_rec;
534: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
535: l_csi_extend_attrib_rec csi_datastructures_pub.extend_attrib_values_rec;
536: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;
529: --
530: l_csi_instance_id_lst CSI_DATASTRUCTURES_PUB.Id_Tbl;
531: --
532: l_csi_instance_rec csi_datastructures_pub.instance_rec;
533: l_csi_party_rec csi_datastructures_pub.party_rec;
534: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
535: l_csi_extend_attrib_rec csi_datastructures_pub.extend_attrib_values_rec;
536: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;
537:
530: l_csi_instance_id_lst CSI_DATASTRUCTURES_PUB.Id_Tbl;
531: --
532: l_csi_instance_rec csi_datastructures_pub.instance_rec;
533: l_csi_party_rec csi_datastructures_pub.party_rec;
534: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
535: l_csi_extend_attrib_rec csi_datastructures_pub.extend_attrib_values_rec;
536: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;
537:
538: l_csi_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
531: --
532: l_csi_instance_rec csi_datastructures_pub.instance_rec;
533: l_csi_party_rec csi_datastructures_pub.party_rec;
534: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
535: l_csi_extend_attrib_rec csi_datastructures_pub.extend_attrib_values_rec;
536: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;
537:
538: l_csi_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
539: l_csi_party_tbl csi_datastructures_pub.party_tbl;
532: l_csi_instance_rec csi_datastructures_pub.instance_rec;
533: l_csi_party_rec csi_datastructures_pub.party_rec;
534: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
535: l_csi_extend_attrib_rec csi_datastructures_pub.extend_attrib_values_rec;
536: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;
537:
538: l_csi_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
539: l_csi_party_tbl csi_datastructures_pub.party_tbl;
540: l_csi_account_tbl csi_datastructures_pub.party_account_tbl;
534: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
535: l_csi_extend_attrib_rec csi_datastructures_pub.extend_attrib_values_rec;
536: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;
537:
538: l_csi_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
539: l_csi_party_tbl csi_datastructures_pub.party_tbl;
540: l_csi_account_tbl csi_datastructures_pub.party_account_tbl;
541: l_csi_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
542: l_csi_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
535: l_csi_extend_attrib_rec csi_datastructures_pub.extend_attrib_values_rec;
536: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;
537:
538: l_csi_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
539: l_csi_party_tbl csi_datastructures_pub.party_tbl;
540: l_csi_account_tbl csi_datastructures_pub.party_account_tbl;
541: l_csi_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
542: l_csi_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
543: l_csi_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
536: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;
537:
538: l_csi_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
539: l_csi_party_tbl csi_datastructures_pub.party_tbl;
540: l_csi_account_tbl csi_datastructures_pub.party_account_tbl;
541: l_csi_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
542: l_csi_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
543: l_csi_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
544: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
537:
538: l_csi_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
539: l_csi_party_tbl csi_datastructures_pub.party_tbl;
540: l_csi_account_tbl csi_datastructures_pub.party_account_tbl;
541: l_csi_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
542: l_csi_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
543: l_csi_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
544: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
545: l_csi_extend_attrib_rec1 csi_datastructures_pub.extend_attrib_values_rec;
538: l_csi_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
539: l_csi_party_tbl csi_datastructures_pub.party_tbl;
540: l_csi_account_tbl csi_datastructures_pub.party_account_tbl;
541: l_csi_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
542: l_csi_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
543: l_csi_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
544: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
545: l_csi_extend_attrib_rec1 csi_datastructures_pub.extend_attrib_values_rec;
546: l_csi_ext_attrib_values_tbl1 csi_datastructures_pub.extend_attrib_values_tbl;
539: l_csi_party_tbl csi_datastructures_pub.party_tbl;
540: l_csi_account_tbl csi_datastructures_pub.party_account_tbl;
541: l_csi_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
542: l_csi_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
543: l_csi_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
544: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
545: l_csi_extend_attrib_rec1 csi_datastructures_pub.extend_attrib_values_rec;
546: l_csi_ext_attrib_values_tbl1 csi_datastructures_pub.extend_attrib_values_tbl;
547: l_idx1 NUMBER := 0;
540: l_csi_account_tbl csi_datastructures_pub.party_account_tbl;
541: l_csi_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
542: l_csi_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
543: l_csi_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
544: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
545: l_csi_extend_attrib_rec1 csi_datastructures_pub.extend_attrib_values_rec;
546: l_csi_ext_attrib_values_tbl1 csi_datastructures_pub.extend_attrib_values_tbl;
547: l_idx1 NUMBER := 0;
548: l_osp_serialnum_change_rec AHL_OSP_SHIPMENT_PUB.Sernum_Change_Rec_Type;
541: l_csi_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
542: l_csi_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
543: l_csi_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
544: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
545: l_csi_extend_attrib_rec1 csi_datastructures_pub.extend_attrib_values_rec;
546: l_csi_ext_attrib_values_tbl1 csi_datastructures_pub.extend_attrib_values_tbl;
547: l_idx1 NUMBER := 0;
548: l_osp_serialnum_change_rec AHL_OSP_SHIPMENT_PUB.Sernum_Change_Rec_Type;
549:
542: l_csi_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
543: l_csi_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
544: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
545: l_csi_extend_attrib_rec1 csi_datastructures_pub.extend_attrib_values_rec;
546: l_csi_ext_attrib_values_tbl1 csi_datastructures_pub.extend_attrib_values_tbl;
547: l_idx1 NUMBER := 0;
548: l_osp_serialnum_change_rec AHL_OSP_SHIPMENT_PUB.Sernum_Change_Rec_Type;
549:
550: -- ARUNJK included cursor for cancel reservation for WO-WO supply WO Cancel Marshalling2