APPS.MSC_WS_OTM_BPEL dependencies on MSC_TRANSPORTATION_UPDATES_S

Line 1389: select MSC_TRANSPORTATION_UPDATES_s.nextval into key from dual;

1385: where OTM_RELEASE_LINE_GID = ReleaseLineGid;
1386:
1387: if ( nCount =0 ) then
1388:
1389: select MSC_TRANSPORTATION_UPDATES_s.nextval into key from dual;
1390:
1391: insert into MSC_TRANSPORTATION_UPDATES (TRANS_UPDATE_ID, ORDER_TYPE, PO_LINE_LOCATION_ID, PO_LINE_ID, UPDATED_ARRIVAL_DATE, EBS_SR_INSTANCE_ID,
1392: OTM_RELEASE_GID, OTM_RELEASE_LINE_GID,
1393: LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY)

Line 1458: select MSC_TRANSPORTATION_UPDATES_s.nextval into key from dual;

1454:
1455: srInstanceId := fnd_profile.value('MSC_EBS_INSTANCE_FOR_OTM');
1456:
1457: if ( nCount =0 ) then
1458: select MSC_TRANSPORTATION_UPDATES_s.nextval into key from dual;
1459:
1460: insert into MSC_TRANSPORTATION_UPDATES (TRANS_UPDATE_ID, ORDER_TYPE, UPDATED_ARRIVAL_DATE,EBS_SR_INSTANCE_ID,
1461: OTM_RELEASE_GID,OTM_RELEASE_LINE_GID,WSH_DELIVERY_DETAIL_ID,
1462: LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY)