509: --Adithya added variables as part of fix for Bug# 6683990
510: l_matches_flag VARCHAR2(1);
511: l_root_uc_header_id NUMBER;
512: --
513: l_csi_instance_id_lst CSI_DATASTRUCTURES_PUB.Id_Tbl;
514: --
515: l_csi_instance_rec csi_datastructures_pub.instance_rec;
516: l_csi_party_rec csi_datastructures_pub.party_rec;
517: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
511: l_root_uc_header_id NUMBER;
512: --
513: l_csi_instance_id_lst CSI_DATASTRUCTURES_PUB.Id_Tbl;
514: --
515: l_csi_instance_rec csi_datastructures_pub.instance_rec;
516: l_csi_party_rec csi_datastructures_pub.party_rec;
517: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
518: l_csi_extend_attrib_rec csi_datastructures_pub.extend_attrib_values_rec;
519: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;
512: --
513: l_csi_instance_id_lst CSI_DATASTRUCTURES_PUB.Id_Tbl;
514: --
515: l_csi_instance_rec csi_datastructures_pub.instance_rec;
516: l_csi_party_rec csi_datastructures_pub.party_rec;
517: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
518: l_csi_extend_attrib_rec csi_datastructures_pub.extend_attrib_values_rec;
519: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;
520:
513: l_csi_instance_id_lst CSI_DATASTRUCTURES_PUB.Id_Tbl;
514: --
515: l_csi_instance_rec csi_datastructures_pub.instance_rec;
516: l_csi_party_rec csi_datastructures_pub.party_rec;
517: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
518: l_csi_extend_attrib_rec csi_datastructures_pub.extend_attrib_values_rec;
519: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;
520:
521: l_csi_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
514: --
515: l_csi_instance_rec csi_datastructures_pub.instance_rec;
516: l_csi_party_rec csi_datastructures_pub.party_rec;
517: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
518: l_csi_extend_attrib_rec csi_datastructures_pub.extend_attrib_values_rec;
519: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;
520:
521: l_csi_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
522: l_csi_party_tbl csi_datastructures_pub.party_tbl;
515: l_csi_instance_rec csi_datastructures_pub.instance_rec;
516: l_csi_party_rec csi_datastructures_pub.party_rec;
517: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
518: l_csi_extend_attrib_rec csi_datastructures_pub.extend_attrib_values_rec;
519: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;
520:
521: l_csi_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
522: l_csi_party_tbl csi_datastructures_pub.party_tbl;
523: l_csi_account_tbl csi_datastructures_pub.party_account_tbl;
517: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
518: l_csi_extend_attrib_rec csi_datastructures_pub.extend_attrib_values_rec;
519: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;
520:
521: l_csi_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
522: l_csi_party_tbl csi_datastructures_pub.party_tbl;
523: l_csi_account_tbl csi_datastructures_pub.party_account_tbl;
524: l_csi_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
525: l_csi_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
518: l_csi_extend_attrib_rec csi_datastructures_pub.extend_attrib_values_rec;
519: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;
520:
521: l_csi_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
522: l_csi_party_tbl csi_datastructures_pub.party_tbl;
523: l_csi_account_tbl csi_datastructures_pub.party_account_tbl;
524: l_csi_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
525: l_csi_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
526: l_csi_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
519: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;
520:
521: l_csi_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
522: l_csi_party_tbl csi_datastructures_pub.party_tbl;
523: l_csi_account_tbl csi_datastructures_pub.party_account_tbl;
524: l_csi_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
525: l_csi_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
526: l_csi_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
527: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
520:
521: l_csi_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
522: l_csi_party_tbl csi_datastructures_pub.party_tbl;
523: l_csi_account_tbl csi_datastructures_pub.party_account_tbl;
524: l_csi_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
525: l_csi_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
526: l_csi_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
527: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
528: l_csi_extend_attrib_rec1 csi_datastructures_pub.extend_attrib_values_rec;
521: l_csi_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
522: l_csi_party_tbl csi_datastructures_pub.party_tbl;
523: l_csi_account_tbl csi_datastructures_pub.party_account_tbl;
524: l_csi_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
525: l_csi_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
526: l_csi_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
527: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
528: l_csi_extend_attrib_rec1 csi_datastructures_pub.extend_attrib_values_rec;
529: l_csi_ext_attrib_values_tbl1 csi_datastructures_pub.extend_attrib_values_tbl;
522: l_csi_party_tbl csi_datastructures_pub.party_tbl;
523: l_csi_account_tbl csi_datastructures_pub.party_account_tbl;
524: l_csi_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
525: l_csi_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
526: l_csi_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
527: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
528: l_csi_extend_attrib_rec1 csi_datastructures_pub.extend_attrib_values_rec;
529: l_csi_ext_attrib_values_tbl1 csi_datastructures_pub.extend_attrib_values_tbl;
530: l_idx1 NUMBER := 0;
523: l_csi_account_tbl csi_datastructures_pub.party_account_tbl;
524: l_csi_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
525: l_csi_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
526: l_csi_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
527: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
528: l_csi_extend_attrib_rec1 csi_datastructures_pub.extend_attrib_values_rec;
529: l_csi_ext_attrib_values_tbl1 csi_datastructures_pub.extend_attrib_values_tbl;
530: l_idx1 NUMBER := 0;
531: l_osp_serialnum_change_rec AHL_OSP_SHIPMENT_PUB.Sernum_Change_Rec_Type;
524: l_csi_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
525: l_csi_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
526: l_csi_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
527: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
528: l_csi_extend_attrib_rec1 csi_datastructures_pub.extend_attrib_values_rec;
529: l_csi_ext_attrib_values_tbl1 csi_datastructures_pub.extend_attrib_values_tbl;
530: l_idx1 NUMBER := 0;
531: l_osp_serialnum_change_rec AHL_OSP_SHIPMENT_PUB.Sernum_Change_Rec_Type;
532:
525: l_csi_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
526: l_csi_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
527: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
528: l_csi_extend_attrib_rec1 csi_datastructures_pub.extend_attrib_values_rec;
529: l_csi_ext_attrib_values_tbl1 csi_datastructures_pub.extend_attrib_values_tbl;
530: l_idx1 NUMBER := 0;
531: l_osp_serialnum_change_rec AHL_OSP_SHIPMENT_PUB.Sernum_Change_Rec_Type;
532:
533: BEGIN