861: AND s.SR_INSTANCE_ID = tu.EBS_SR_INSTANCE_ID
862: AND tu.TRANS_UPDATE_ID = transId;
863:
864:
865: PO_Ids MscNumberArr := MscNumberArr();
866: --PO_Shipment_ids MscNumberArr := MscNumberArr();
867: invItemId NUMBER :=0;
868: orgId NUMBER :=0;
869: newArrivalDate DATE;
862: AND tu.TRANS_UPDATE_ID = transId;
863:
864:
865: PO_Ids MscNumberArr := MscNumberArr();
866: --PO_Shipment_ids MscNumberArr := MscNumberArr();
867: invItemId NUMBER :=0;
868: orgId NUMBER :=0;
869: newArrivalDate DATE;
870: v_new_firm_Date DATE;
992: AND sO.DEMAND_SOURCE_LINE = dd.SOURCE_LINE_ID
993: AND dd.DELIVERY_DETAIL_ID = tu.OTM_RELEASE_LINE_GID
994: AND tu.Trans_update_id = transId;*/
995:
996: /*ISO_Ids MscNumberArr := MscNumberArr();
997: IR_Ids MscNumberArr := MscNumberArr();
998: IR_Shipment_ids MscNumberArr := MscNumberArr();*/
999:
1000: ISOID1 NUMBER :=0;
993: AND dd.DELIVERY_DETAIL_ID = tu.OTM_RELEASE_LINE_GID
994: AND tu.Trans_update_id = transId;*/
995:
996: /*ISO_Ids MscNumberArr := MscNumberArr();
997: IR_Ids MscNumberArr := MscNumberArr();
998: IR_Shipment_ids MscNumberArr := MscNumberArr();*/
999:
1000: ISOID1 NUMBER :=0;
1001: IRID1 NUMBER :=0;
994: AND tu.Trans_update_id = transId;*/
995:
996: /*ISO_Ids MscNumberArr := MscNumberArr();
997: IR_Ids MscNumberArr := MscNumberArr();
998: IR_Shipment_ids MscNumberArr := MscNumberArr();*/
999:
1000: ISOID1 NUMBER :=0;
1001: IRID1 NUMBER :=0;
1002:
1167:
1168:
1169:
1170:
1171: ISO_Ids MscNumberArr := MscNumberArr();
1172: IR_Ids MscNumberArr := MscNumberArr();
1173: IR_Shipment_ids MscNumberArr := MscNumberArr();
1174: invItemId NUMBER :=0;
1175: orgId NUMBER :=0;
1168:
1169:
1170:
1171: ISO_Ids MscNumberArr := MscNumberArr();
1172: IR_Ids MscNumberArr := MscNumberArr();
1173: IR_Shipment_ids MscNumberArr := MscNumberArr();
1174: invItemId NUMBER :=0;
1175: orgId NUMBER :=0;
1176: newArrivalDate DATE;
1169:
1170:
1171: ISO_Ids MscNumberArr := MscNumberArr();
1172: IR_Ids MscNumberArr := MscNumberArr();
1173: IR_Shipment_ids MscNumberArr := MscNumberArr();
1174: invItemId NUMBER :=0;
1175: orgId NUMBER :=0;
1176: newArrivalDate DATE;
1177: v_new_firm_Date DATE;