DBA Data[Home] [Help]

APPS.WMS_CARTNZN_PUB dependencies on WMS_DEVICE_INTEGRATION_PVT

Line 5403: IF wms_device_integration_pvt.wms_call_device_request = 1 THEN

5399:
5400: BEGIN
5401:
5402:
5403: IF wms_device_integration_pvt.wms_call_device_request = 1 THEN
5404: --set in INVPPICB.pls through call to is_device_set_up()
5405:
5406: l_bus_event_id :=
5407: WMS_Device_Integration_PVT.wms_be_pick_release;

Line 5407: WMS_Device_Integration_PVT.wms_be_pick_release;

5403: IF wms_device_integration_pvt.wms_call_device_request = 1 THEN
5404: --set in INVPPICB.pls through call to is_device_set_up()
5405:
5406: l_bus_event_id :=
5407: WMS_Device_Integration_PVT.wms_be_pick_release;
5408:
5409: ELSIF wms_device_integration_pvt.wms_call_device_request = 2 THEN
5410: --set in INVUTILB.pls/WMSTSKUB.pls through call to is_device_set_up()
5411:

Line 5409: ELSIF wms_device_integration_pvt.wms_call_device_request = 2 THEN

5405:
5406: l_bus_event_id :=
5407: WMS_Device_Integration_PVT.wms_be_pick_release;
5408:
5409: ELSIF wms_device_integration_pvt.wms_call_device_request = 2 THEN
5410: --set in INVUTILB.pls/WMSTSKUB.pls through call to is_device_set_up()
5411:
5412: l_bus_event_id :=
5413: WMS_Device_Integration_PVT.wms_be_mo_task_alloc;

Line 5413: WMS_Device_Integration_PVT.wms_be_mo_task_alloc;

5409: ELSIF wms_device_integration_pvt.wms_call_device_request = 2 THEN
5410: --set in INVUTILB.pls/WMSTSKUB.pls through call to is_device_set_up()
5411:
5412: l_bus_event_id :=
5413: WMS_Device_Integration_PVT.wms_be_mo_task_alloc;
5414: END IF;
5415:
5416:
5417: IF wms_device_integration_pvt.wms_call_device_request IS NOT NULL THEN

Line 5417: IF wms_device_integration_pvt.wms_call_device_request IS NOT NULL THEN

5413: WMS_Device_Integration_PVT.wms_be_mo_task_alloc;
5414: END IF;
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,

Line 5439: ( WMS_Device_Integration_PVT.wms_pkRel_dev_req_id, --global var so that for all lines in a pick release, it remains same

5435: transaction_quantity,
5436: last_update_date,
5437: last_updated_by) VALUES
5438:
5439: ( WMS_Device_Integration_PVT.wms_pkRel_dev_req_id, --global var so that for all lines in a pick release, it remains same
5440: p_mmtt_row.transaction_temp_id,
5441: 'Y',
5442: 1, --"LOAD"
5443: l_bus_event_id,

Line 5481: ( WMS_Device_Integration_PVT.wms_pkRel_dev_req_id, --global var so that for all lines in a pick release, it remains same

5477: transaction_quantity,
5478: last_update_date,
5479: last_updated_by) VALUES
5480:
5481: ( WMS_Device_Integration_PVT.wms_pkRel_dev_req_id, --global var so that for all lines in a pick release, it remains same
5482: p_mmtt_row.transaction_temp_id,
5483: 'Y',
5484: 2, --"DROP"
5485: l_bus_event_id,

Line 5501: wdrdata.request_id := WMS_Device_Integration_PVT.wms_pkrel_dev_req_id;

5497: p_mmtt_row.transaction_quantity,
5498: Sysdate,
5499: FND_GLOBAL.USER_ID);
5500:
5501: wdrdata.request_id := WMS_Device_Integration_PVT.wms_pkrel_dev_req_id;
5502: wdrData.organization_id := p_mmtt_row.organization_id;
5503: wdrData.subinventory_code := p_mmtt_row.subinventory_code ;
5504: wdrData.business_event_id := l_bus_event_id;
5505: wdrData.locator_id := p_mmtt_row.locator_id;

Line 5515: l_device_id := WMS_Device_Integration_PVT.SELECT_DEVICE(wdrData,'Y',NULL);

5511:
5512:
5513: --Call an api to get the device, this API also updates above
5514: --inserted records WITH found matching device id
5515: l_device_id := WMS_Device_Integration_PVT.SELECT_DEVICE(wdrData,'Y',NULL);
5516:
5517:
5518:
5519: IF l_device_id <> 0 THEN --process further only if device IS found

Line 5536: IF wms_device_integration_pvt.wms_insert_lotSer_rec_WDR = 1 THEN

5532:
5533: IF (l_lot_code >1 OR l_serial_code >1) THEN --LOT OR/AND SERIAL ITEMS
5534:
5535: --check to see whether need to insert lot/ser record
5536: IF wms_device_integration_pvt.wms_insert_lotSer_rec_WDR = 1 THEN
5537:
5538: FOR l_rec IN lot_ser_cursor(p_mmtt_row.transaction_temp_id) LOOP
5539: IF (l_rec.lot_num IS NOT NULL OR l_rec.ser_num IS NOT NULL) THEN
5540: IF (l_rec.ser_num IS NOT NULL) THEN

Line 5575: (WMS_Device_Integration_PVT.wms_pkRel_dev_req_id,

5571: last_update_date,
5572: last_updated_by,
5573: last_update_login)
5574: VALUES
5575: (WMS_Device_Integration_PVT.wms_pkRel_dev_req_id,
5576: p_mmtt_row.transaction_temp_id,
5577: NULL,
5578: NULL,
5579: 'N',