APPS.ECE_SPSO_TRANS2 dependencies on ECE_SPSO_SHIP_DET

Line 1270: FROM ece_spso_ship_det

1266: BEGIN
1267: xProgress := 'SPSO2B-10-1240';
1268: SELECT max(schedule_ship_id)
1269: INTO x_schedule_ship_id
1270: FROM ece_spso_ship_det
1271: WHERE schedule_id = rec_item.schedule_id
1272: AND schedule_item_id= rec_item.schedule_item_id
1273: AND schedule_item_detail_sequence = x_item_detail_sequence;
1274: EXCEPTION

Line 1282: INSERT INTO ECE_SPSO_SHIP_DET

1278: xProgress := 'SPSO2B-10-1250';
1279: x_schedule_ship_id := NVL(x_schedule_ship_id,0) + 1;
1280:
1281: xProgress := 'SPSO2B-10-1260';
1282: INSERT INTO ECE_SPSO_SHIP_DET
1283: (
1284: RUN_ID,
1285: SCHEDULE_SHIP_ID,
1286: SCHEDULE_ID ,

Line 1328: ece_spso_ship_det_s.nextval,

1324: rec_ship_det.ITEM_DET_ST_COUNTY,
1325: rec_ship_det.ITEM_DET_ST_STATE,
1326: rec_ship_det.ITEM_DET_ST_REGION_3,
1327: rec_ship_det.ITEM_DET_ST_PHONE,
1328: ece_spso_ship_det_s.nextval,
1329: rec_ship_det.DOCUMENT_RELEASE_NUMBER,
1330: rec_ship_det.DOCUMENT_LINE_NUMBER,
1331: rec_ship_det.LINE_LOCATION_ID
1332: );

Line 1336: ECE_SPSO_SHIP_DET_S.currval

1332: );
1333:
1334: xProgress := 'SPSO2B-10-1270';
1335: SELECT
1336: ECE_SPSO_SHIP_DET_S.currval
1337: INTO
1338: l_transaction_number
1339: FROM
1340: dual;