APPS.ECE_SPSO_TRANS2 dependencies on ECE_SPSO_SHIP_DET

Line 1291: FROM ece_spso_ship_det

1287: BEGIN
1288: xProgress := 'SPSO2B-10-1240';
1289: SELECT max(schedule_ship_id)
1290: INTO x_schedule_ship_id
1291: FROM ece_spso_ship_det
1292: WHERE schedule_id = rec_item.schedule_id
1293: AND schedule_item_id= rec_item.schedule_item_id
1294: AND schedule_item_detail_sequence = x_item_detail_sequence;
1295: EXCEPTION

Line 1303: INSERT INTO ECE_SPSO_SHIP_DET

1299: xProgress := 'SPSO2B-10-1250';
1300: x_schedule_ship_id := NVL(x_schedule_ship_id,0) + 1;
1301:
1302: xProgress := 'SPSO2B-10-1260';
1303: INSERT INTO ECE_SPSO_SHIP_DET
1304: (
1305: RUN_ID,
1306: SCHEDULE_SHIP_ID,
1307: SCHEDULE_ID ,

Line 1350: ece_spso_ship_det_s.nextval,

1346: rec_ship_det.ITEM_DET_ST_COUNTY,
1347: rec_ship_det.ITEM_DET_ST_STATE,
1348: rec_ship_det.ITEM_DET_ST_REGION_3,
1349: rec_ship_det.ITEM_DET_ST_PHONE,
1350: ece_spso_ship_det_s.nextval,
1351: rec_ship_det.DOCUMENT_RELEASE_NUMBER,
1352: rec_ship_det.DOCUMENT_LINE_NUMBER,
1353: rec_ship_det.LINE_LOCATION_ID,
1354: rec_ship_det.QUANTITY_RECEIVED --

Line 1359: ECE_SPSO_SHIP_DET_S.currval

1355: );
1356:
1357: xProgress := 'SPSO2B-10-1270';
1358: SELECT
1359: ECE_SPSO_SHIP_DET_S.currval
1360: INTO
1361: l_transaction_number
1362: FROM
1363: dual;