[Home] [Help]
143: AND person_id=l_emp_id;
144: */
145: SELECT wms_dispatched_tasks_s.NEXTVAL
146: INTO l_task_id
147: FROM DUAL;
148:
149: INSERT INTO wms_dispatched_tasks
150: (
151: task_id
762: END IF;
763:
764: SELECT mtl_material_transactions_s.NEXTVAL txnhdrid
765: INTO l_txn_hdr_id
766: FROM DUAL;
767:
768: UPDATE mtl_material_transactions_temp
769: SET transaction_header_id = l_txn_hdr_id
770: WHERE transaction_temp_id = task_rec.task_id;
772: -- Insert into WMS_DISPATCHED_TASKS for this user
773:
774: SELECT wms_dispatched_tasks_s.NEXTVAL
775: INTO l_next_task_id
776: FROM DUAL;
777:
778: INSERT INTO wms_dispatched_tasks
779: (
780: task_id
1318: END IF;
1319:
1320: SELECT mtl_material_transactions_s.NEXTVAL txnhdrid
1321: INTO l_txn_hdr_id
1322: FROM DUAL;
1323:
1324: UPDATE mtl_material_transactions_temp
1325: SET transaction_header_id = l_txn_hdr_id
1326: WHERE transaction_temp_id = task_rec.task_id;
1327:
1328: -- Insert into WMS_DISPATCHED_TASKS for this user
1329: SELECT wms_dispatched_tasks_s.NEXTVAL
1330: INTO l_next_task_id
1331: FROM DUAL;
1332:
1333: INSERT INTO wms_dispatched_tasks
1334: (
1335: task_id
1774:
1775: BEGIN
1776: SELECT 1
1777: INTO l_exist_lpn
1778: FROM DUAL
1779: WHERE EXISTS(SELECT 1
1780: FROM wms_license_plate_numbers
1781: WHERE license_plate_number = l_lpn
1782: AND organization_id = p_org_id);
2175:
2176: IF l_lot_ser_seq = 0 THEN
2177: SELECT mtl_material_transactions_s.NEXTVAL
2178: INTO l_ser_seq
2179: FROM DUAL;
2180: ELSE
2181: l_ser_seq := l_lot_ser_seq;
2182: END IF;
2183:
2788:
2789:
2790: SELECT 1
2791: INTO l_loaded
2792: FROM DUAL
2793: WHERE EXISTS(SELECT 1
2794: FROM mtl_material_transactions_temp
2795: WHERE (transfer_lpn_id = p_lpn
2796: OR content_lpn_id = p_lpn));
2971:
2972: BEGIN
2973: SELECT 1
2974: INTO l_item_cnt
2975: FROM DUAL
2976: WHERE EXISTS(
2977: SELECT 1
2978: FROM wms_lpn_contents wlc
2979: WHERE wlc.parent_lpn_id = p_lpn
3000:
3001: BEGIN
3002: SELECT 1
3003: INTO l_item_cnt
3004: FROM DUAL
3005: WHERE EXISTS(
3006: SELECT 1
3007: FROM wms_lpn_contents wlc, mtl_transaction_lots_temp mtlt
3008: WHERE wlc.parent_lpn_id = p_lpn
5303: --Check whether the from LPN is loaded already
5304: BEGIN
5305: SELECT 0
5306: INTO l_loaded
5307: FROM DUAL
5308: WHERE NOT EXISTS(SELECT 1
5309: FROM mtl_material_transactions_temp
5310: WHERE content_lpn_id = p_from_lpn_id
5311: AND transaction_temp_id<>p_temp_id);
5759:
5760: BEGIN
5761: SELECT 1
5762: INTO l_bulk_pick_flag
5763: FROM DUAL
5764: WHERE EXISTS(SELECT 1
5765: FROM mtl_material_transactions_temp mmtt
5766: WHERE mmtt.parent_line_id = p_temp_id);
5767: EXCEPTION
6144: AND organization_id=l_org_id;*/
6145: BEGIN
6146: SELECT 1
6147: INTO l_exist_lpn
6148: FROM DUAL
6149: WHERE EXISTS(SELECT 1
6150: FROM wms_license_plate_numbers
6151: WHERE license_plate_number = l_lpn
6152: AND organization_id = l_org_id);
6226: END IF;
6227:
6228: SELECT mtl_material_transactions_s.NEXTVAL
6229: INTO l_new_temp_id
6230: FROM DUAL;
6231:
6232: INSERT INTO mtl_material_transactions_temp
6233: (
6234: transaction_header_id
6702: AND lpn_context<>wms_container_pub.lpn_context_packing;*/
6703: BEGIN
6704: SELECT 1
6705: INTO l_exist_lpn
6706: FROM DUAL
6707: WHERE EXISTS(
6708: SELECT 1
6709: FROM wms_license_plate_numbers
6710: WHERE license_plate_number = l_lpn_name
6731: AND w.lpn_id=c.parent_lpn_id;*/
6732: BEGIN
6733: SELECT 1
6734: INTO l_exist_lpn2
6735: FROM DUAL
6736: WHERE EXISTS(SELECT 1
6737: FROM wms_license_plate_numbers w, wms_lpn_contents c
6738: WHERE w.license_plate_number = l_sug_lpn_name
6739: AND w.organization_id = l_org_id
7001: -- Create new MMTT line with qty and primary qty in the LPN, content_lpn_id, transfer_lpn_id
7002:
7003: SELECT mtl_material_transactions_s.NEXTVAL
7004: INTO l_new_temp_id
7005: FROM DUAL;
7006:
7007: IF (l_debug = 1) THEN
7008: mydebug('multiple_lpn_pick: l_new_temp_id = ' || l_new_temp_id);
7009: END IF;
7491: -- get new serial_transaction_id
7492:
7493: SELECT mtl_material_transactions_s.NEXTVAL
7494: INTO l_new_serial_temp_id
7495: FROM DUAL;
7496:
7497: l_mtlt_rec.serial_transaction_temp_id := l_new_serial_temp_id;
7498:
7499: IF (l_debug = 1) THEN
7595: IF (l_serial_code > 1
7596: AND l_serial_code <> 6) THEN
7597: SELECT mtl_material_transactions_s.NEXTVAL
7598: INTO l_new_serial_temp_id
7599: FROM DUAL;
7600:
7601: l_mtlt_rec.serial_transaction_temp_id := l_new_serial_temp_id;
7602: ELSE
7603: l_new_serial_temp_id := NULL;
7680: IF (l_serial_code > 1
7681: AND l_serial_code <> 6) THEN
7682: SELECT mtl_material_transactions_s.NEXTVAL
7683: INTO l_new_serial_temp_id
7684: FROM DUAL;
7685: ELSE
7686: l_new_serial_temp_id := NULL;
7687: END IF;
7688:
7798:
7799: --Get value from sequence for next task id
7800: SELECT wms_dispatched_tasks_s.NEXTVAL
7801: INTO l_next_task_id
7802: FROM DUAL;
7803:
7804: IF (l_debug = 1) THEN
7805: mydebug('multiple_lpn_pick: Before Insert into WMSDT');
7806: END IF;
8294: l_count := 0;
8295: BEGIN
8296: SELECT 1
8297: INTO l_count
8298: FROM DUAL
8299: WHERE EXISTS
8300: ( SELECT 'x'
8301: FROM mtl_material_transactions_temp mmtt
8302: , mtl_secondary_inventories msi
9398: -- Create new MMTT line with qty and primary qty picked
9399:
9400: SELECT mtl_material_transactions_s.NEXTVAL
9401: INTO l_new_temp_id
9402: FROM DUAL;
9403:
9404: l_progress := '210';
9405: l_local_temp_id := l_new_temp_id;
9406:
9852: END IF;
9853:
9854: SELECT mtl_material_transactions_s.NEXTVAL
9855: INTO l_new_serial_temp_id
9856: FROM DUAL;
9857:
9858: l_progress := '310';
9859:
9860: UPDATE mtl_serial_numbers_temp
9874: END IF;
9875:
9876: SELECT mtl_material_transactions_s.NEXTVAL
9877: INTO l_new_serial_temp_id
9878: FROM DUAL;
9879:
9880: l_progress := '330';
9881: l_mtlt_rec.serial_transaction_temp_id := l_new_serial_temp_id;
9882: END IF;
9946:
9947: --Get value from sequence for next task id
9948: SELECT wms_dispatched_tasks_s.NEXTVAL
9949: INTO l_next_task_id
9950: FROM DUAL;
9951:
9952: l_progress := '410';
9953:
9954: IF (l_debug = 1) THEN
10111:
10112: IF l_lot_ser_seq = 0 THEN
10113: SELECT mtl_material_transactions_s.NEXTVAL
10114: INTO l_new_serial_temp_id
10115: FROM DUAL;
10116: ELSE
10117: l_new_serial_temp_id := l_lot_ser_seq;
10118: END IF;
10119:
10298:
10299: IF l_lot_ser_seq = 0 THEN
10300: SELECT mtl_material_transactions_s.NEXTVAL
10301: INTO l_new_serial_temp_id
10302: FROM DUAL;
10303: ELSE
10304: l_new_serial_temp_id := l_lot_ser_seq;
10305: END IF;
10306:
10523: WHERE license_plate_number=p_lpn;*/
10524: BEGIN
10525: SELECT 1
10526: INTO l_exist
10527: FROM DUAL
10528: WHERE EXISTS(SELECT 1
10529: FROM wms_license_plate_numbers
10530: WHERE license_plate_number = p_lpn);
10531: EXCEPTION
11144: THEN
11145: BEGIN
11146: SELECT 1
11147: INTO l_cnt
11148: FROM DUAL
11149: WHERE EXISTS(SELECT 1
11150: FROM mtl_material_transactions_temp
11151: WHERE parent_line_id = l_temp_id);
11152: EXCEPTION
12627: END IF;
12628:
12629: SELECT mtl_material_transactions_s.NEXTVAL txnhdrid
12630: INTO l_txn_hdr_id
12631: FROM DUAL;
12632:
12633: UPDATE mtl_material_transactions_temp
12634: SET transaction_header_id = l_txn_hdr_id
12635: WHERE transaction_temp_id = task_rec.task_id;
12638:
12639: --Get value from sequence for next task id
12640: SELECT wms_dispatched_tasks_s.NEXTVAL
12641: INTO l_next_task_id
12642: FROM DUAL;
12643:
12644: --mydebug('pick_by_label: Before Insert into WMSDT');
12645:
12646:
12876:
12877: BEGIN
12878: SELECT 1
12879: INTO l_mmtt_rowcnt
12880: FROM DUAL
12881: WHERE EXISTS(SELECT 1
12882: FROM mtl_material_transactions_temp
12883: WHERE transaction_temp_id = l_pick_slip_id
12884: AND parent_line_id is NULL);
12903:
12904: BEGIN
12905: SELECT 1
12906: INTO l_wdt_rowcnt
12907: FROM DUAL
12908: WHERE EXISTS(SELECT 1
12909: FROM wms_dispatched_tasks t
12910: WHERE t.transaction_temp_id = l_pick_slip_id);
12911: EXCEPTION
12995:
12996: --Get value from sequence for next task id
12997: SELECT wms_dispatched_tasks_s.NEXTVAL
12998: INTO l_next_task_id
12999: FROM DUAL;
13000:
13001: --mydebug('manual_pick: Before Insert into WMSDT');
13002:
13003: SELECT mtl_material_transactions_s.NEXTVAL txnhdrid
13001: --mydebug('manual_pick: Before Insert into WMSDT');
13002:
13003: SELECT mtl_material_transactions_s.NEXTVAL txnhdrid
13004: INTO l_txn_hdr_id
13005: FROM DUAL;
13006:
13007: UPDATE mtl_material_transactions_temp
13008: SET transaction_header_id = l_txn_hdr_id
13009: WHERE transaction_temp_id = l_pick_slip_id;
13364: l_msg VARCHAR2(5100);
13365: l_ts VARCHAR2(30);
13366: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
13367: BEGIN
13368: -- select to_char(sysdate,'MM/DD/YYYY HH:MM:SS') INTO l_ts from dual;
13369: -- l_msg:=l_ts||' '||msg;
13370:
13371: l_msg := msg;
13372: inv_mobile_helper_functions.tracelog(p_err_msg => l_msg, p_module => 'WMS_Task_Dispatch_Gen', p_level => 4);
14240:
14241: BEGIN
14242: SELECT 1
14243: INTO l_count
14244: FROM DUAL
14245: WHERE EXISTS(
14246: SELECT 1
14247: FROM mtl_material_transactions_temp mmtt
14248: WHERE mmtt.transaction_temp_id <> p_temp_id
14405: END IF;
14406:
14407: SELECT mtl_material_transactions_s.NEXTVAL
14408: INTO x_new_txn_hdr_id
14409: FROM DUAL;
14410:
14411: OPEN c_parent_mmtt_lines;
14412:
14413: LOOP
14471: ELSE -- Current Child Qty is greater than Parent Picked Qty
14472:
14473: select mtl_material_transactions_s.NEXTVAL
14474: into l_new_temp_id
14475: from dual; --Added bug3765153
14476:
14477: INSERT INTO mtl_material_transactions_temp
14478: (
14479: transaction_header_id