[Home] [Help]
1310: p_inventory_item_id);
1311: END IF;
1312:
1313: IF p_mode in (RESOFF, NONTRANS) THEN
1314: INSERT INTO SO_PICKING_LINE_DETAILS (
1315: PICKING_LINE_DETAIL_ID,
1316: PICK_SLIP_NUMBER,
1317: CREATED_BY,
1318: CREATION_DATE,
1342: TRANSACTABLE_FLAG,
1343: WAREHOUSE_ID,
1344: MVT_STAT_STATUS)
1345: VALUES (
1346: SO_PICKING_LINE_DETAILS_S.NEXTVAL,
1347: p_ps_number,
1348: g_user_id,
1349: SYSDATE,
1350: g_user_id,
1378:
1379: rows_inserted := SQL%ROWCOUNT;
1380:
1381: ELSIF p_mode = RESERVABLE THEN
1382: INSERT INTO SO_PICKING_LINE_DETAILS (
1383: PICKING_LINE_DETAIL_ID,
1384: PICK_SLIP_NUMBER,
1385: CREATED_BY,
1386: CREATION_DATE,
1417: TRANSACTABLE_FLAG,
1418: WAREHOUSE_ID,
1419: MVT_STAT_STATUS)
1420: SELECT
1421: SO_PICKING_LINE_DETAILS_S.NEXTVAL,
1422: p_ps_number,
1423: g_user_id,
1424: SYSDATE,
1425: g_user_id,
1470:
1471: rows_inserted := SQL%ROWCOUNT;
1472:
1473: ELSIF p_mode = TRANSNONRES THEN
1474: INSERT INTO SO_PICKING_LINE_DETAILS (
1475: PICKING_LINE_DETAIL_ID,
1476: PICK_SLIP_NUMBER,
1477: CREATED_BY,
1478: CREATION_DATE,
1509: TRANSACTABLE_FLAG,
1510: WAREHOUSE_ID,
1511: MVT_STAT_STATUS)
1512: SELECT
1513: SO_PICKING_LINE_DETAILS_S.NEXTVAL,
1514: p_ps_number,
1515: g_user_id,
1516: SYSDATE,
1517: g_user_id,
1561:
1562: rows_inserted := SQL%ROWCOUNT;
1563:
1564: ELSIF p_mode = BACKORDER THEN
1565: INSERT INTO SO_PICKING_LINE_DETAILS (
1566: PICKING_LINE_DETAIL_ID,
1567: CREATED_BY,
1568: CREATION_DATE,
1569: LAST_UPDATED_BY,
1587: TRANSACTABLE_FLAG,
1588: WAREHOUSE_ID,
1589: MVT_STAT_STATUS)
1590: VALUES (
1591: SO_PICKING_LINE_DETAILS_S.NEXTVAL,
1592: g_user_id,
1593: SYSDATE,
1594: g_user_id,
1595: SYSDATE,