APPS.MSC_WS_OTM_BPEL dependencies on DUAL

Line 176: from dual;

172: --dbms_output.put_line('orderNumber=' || v_order_Number);
173:
174: select decode(instr(v_order_Number,'('), 0, v_order_Number, substr(v_order_Number, 1, instr(v_order_Number,'(') - 1))
175: into orderNumber
176: from dual;
177:
178: lineNumber := v_line_Number; -- number to chars conversion
179: --dbms_output.put_line('lineNumber=' || lineNumber);
180:

Line 185: from dual;

181: select decode(v_order_type, 1, nvl(substr(v_order_number,instr(v_order_number,'(')+1,instr(v_order_number,'(',1,2)-2
182: - instr(v_order_number,'(')),' ') , decode(instr(v_order_number,'('), 0, to_char(null),
183: substr(v_order_number, instr(v_order_number,'('))))
184: into releaseNumber
185: from dual;
186:
187: --dbms_output.put_line('releaseNumber=' || releaseNumber);
188:
189: select count(*) into v_cnt

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)