DBA Data[Home] [Help]

APPS.MSC_WS_OTM_BPEL dependencies on MSC_TRANSPORTATION_UPDATES_S

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

1360: where OTM_RELEASE_LINE_GID = ReleaseLineGid;
1361:
1362: if ( nCount =0 ) then
1363:
1364: select MSC_TRANSPORTATION_UPDATES_s.nextval into key from dual;
1365:
1366: insert into MSC_TRANSPORTATION_UPDATES (TRANS_UPDATE_ID, ORDER_TYPE, PO_LINE_LOCATION_ID, PO_LINE_ID, UPDATED_ARRIVAL_DATE, EBS_SR_INSTANCE_ID,
1367: OTM_RELEASE_GID, OTM_RELEASE_LINE_GID,
1368: LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY)

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

1429:
1430: srInstanceId := fnd_profile.value('MSC_EBS_INSTANCE_FOR_OTM');
1431:
1432: if ( nCount =0 ) then
1433: select MSC_TRANSPORTATION_UPDATES_s.nextval into key from dual;
1434:
1435: insert into MSC_TRANSPORTATION_UPDATES (TRANS_UPDATE_ID, ORDER_TYPE, UPDATED_ARRIVAL_DATE,EBS_SR_INSTANCE_ID,
1436: OTM_RELEASE_GID,OTM_RELEASE_LINE_GID,WSH_DELIVERY_DETAIL_ID,
1437: LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY)