APPS.MSC_WS_OTM_BPEL dependencies on DUAL

Line 182: from dual;

178:
179: if (v_order_type = 1) then
180: select decode(instr(v_order_Number,'('), 0, v_order_Number, substr(v_order_Number, 1, instr(v_order_Number,'(') - 1))
181: into orderNumber
182: from dual;
183:
184: select decode(v_order_type, 1, nvl(substr(v_order_number,instr(v_order_number,'(')+1,instr(v_order_number,'(',1,2)-2
185: - instr(v_order_number,'(')),' ') , decode(instr(v_order_number,'('), 0, to_char(null),
186: substr(v_order_number, instr(v_order_number,'('))))

Line 188: from dual;

184: select decode(v_order_type, 1, nvl(substr(v_order_number,instr(v_order_number,'(')+1,instr(v_order_number,'(',1,2)-2
185: - instr(v_order_number,'(')),' ') , decode(instr(v_order_number,'('), 0, to_char(null),
186: substr(v_order_number, instr(v_order_number,'('))))
187: into releaseNumber
188: from dual;
189:
190: else
191:
192: orderNumber :=v_order_Number;

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)