[Home] [Help]
157: --Variable storing if log is enabled
158: g_trace_on NUMBER := NULL;
159:
160: --for device integration
161: SUBTYPE WDR_ROW IS WMS_DEVICE_REQUESTS%ROWTYPE;
162:
163: SUBTYPE MMTT_ROW_TYPE IS MTL_MATERIAL_TRANSACTIONS_TEMP%ROWTYPE;
164:
165: SUBTYPE WCT_ROW_TYPE IS WMS_CARTONIZATION_TEMP%ROWTYPE;
5365: language java name
5366: 'oracle.apps.wms.cartonization.server.Cartonization.start(java.lang.Long, java.lang.Long, java.lang.String, java.lang.String, java.lang.String) return java.lang.Long';
5367:
5368:
5369: --This procedure inserts records into wms_device_requests table for further
5370: -- processing by device integration code.This procedure is called from
5371: -- WMSCRTNB.pls and WMSTSKUB.pls
5372:
5373: PROCEDURE insert_device_request_rec(p_mmtt_row IN mmtt_row)
5415:
5416:
5417: IF wms_device_integration_pvt.wms_call_device_request IS NOT NULL THEN
5418: --insert line for load operation
5419: INSERT INTO wms_device_requests (request_id,
5420: task_id,
5421: task_summary,
5422: task_type_id,
5423: business_event_id,
5457: FND_GLOBAL.USER_ID);
5458:
5459:
5460: --insert another line for drop
5461: INSERT INTO wms_device_requests (request_id,
5462: task_id,
5463: task_summary,
5464: task_type_id,
5465: business_event_id,
5542: ELSE
5543: l_qty := l_rec.lot_qty;
5544: END IF;
5545: l_count := l_count + 1;
5546: INSERT INTO wms_device_requests
5547: (request_id,
5548: task_id,
5549: relation_id,
5550: sequence_id,
5732:
5733:
5734: IF( v1.transaction_temp_id > 0 ) then
5735:
5736: --INSERT RECORDS INTO WMS_DEVICE_REQUESTS TABLE
5737: insert_device_request_rec(v1);
5738: --/////////////////
5739:
5740: if (g_trace_on = 1) then log_event(' temp_id > 0'); END IF;