eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WMS_OP_RUNTIME_PVT_APIS dependencies on WMS_DISPATCHED_TASKS

Line 1007: * This procedure inserts the task records into WMS_DISPATCHED_TASKS

1003:
1004:
1005: /**
1006: *

Procedure:Insert_Dispatched_tasks
1007: * This procedure inserts the task records into WMS_DISPATCHED_TASKS

1008: * @param p_wdt_rec - WDT record that has to be inserted.
1009: * @param p_source_task_id - Transaction Temp Id of the WDT record.
1010: * @param x_return_status - Return Status
1011: * @param x_msg_count - Returns Message Count

Line 1015: p_wdt_rec IN wms_dispatched_tasks%ROWTYPE

1011: * @param x_msg_count - Returns Message Count
1012: * @param x_msg_data - Returns Error Message
1013: */
1014: PROCEDURE insert_dispatched_tasks(
1015: p_wdt_rec IN wms_dispatched_tasks%ROWTYPE
1016: , p_source_task_id IN NUMBER
1017: , x_return_status OUT NOCOPY VARCHAR2
1018: , x_msg_count OUT NOCOPY NUMBER
1019: , x_msg_data OUT NOCOPY fnd_new_messages.MESSAGE_TEXT%TYPE

Line 1035: INSERT INTO WMS_DISPATCHED_TASKS

1031: END IF;
1032:
1033: x_return_status:=fnd_api.g_ret_sts_success;
1034:
1035: INSERT INTO WMS_DISPATCHED_TASKS
1036: ( TASK_ID,
1037: TRANSACTION_TEMP_ID,
1038: ORGANIZATION_ID,
1039: USER_TASK_TYPE,

Line 1085: ( decode(p_wdt_rec.TASK_ID,NULL,wms_dispatched_tasks_s.NEXTVAL,p_wdt_rec.TASK_ID),

1081: MOVE_ORDER_LINE_ID,
1082: TRANSFER_LPN_ID,
1083: OP_PLAN_INSTANCE_ID)
1084: VALUES
1085: ( decode(p_wdt_rec.TASK_ID,NULL,wms_dispatched_tasks_s.NEXTVAL,p_wdt_rec.TASK_ID),
1086: p_wdt_rec.TRANSACTION_TEMP_ID,
1087: p_wdt_rec.ORGANIZATION_ID,
1088: p_wdt_rec.USER_TASK_TYPE,
1089: p_wdt_rec.PERSON_ID,

Line 1155: p_wdt_rec IN wms_dispatched_tasks%ROWTYPE

1151:
1152: -- non autonomous transaction -- Added for bug # 14284768
1153:
1154: PROCEDURE insert_dispatched_tasks_nauto(
1155: p_wdt_rec IN wms_dispatched_tasks%ROWTYPE
1156: , p_source_task_id IN NUMBER
1157: , x_return_status OUT NOCOPY VARCHAR2
1158: , x_msg_count OUT NOCOPY NUMBER
1159: , x_msg_data OUT NOCOPY fnd_new_messages.MESSAGE_TEXT%TYPE

Line 1175: INSERT INTO WMS_DISPATCHED_TASKS

1171: END IF;
1172:
1173: x_return_status:=fnd_api.g_ret_sts_success;
1174:
1175: INSERT INTO WMS_DISPATCHED_TASKS
1176: ( TASK_ID,
1177: TRANSACTION_TEMP_ID,
1178: ORGANIZATION_ID,
1179: USER_TASK_TYPE,

Line 1225: ( decode(p_wdt_rec.TASK_ID,NULL,wms_dispatched_tasks_s.NEXTVAL,p_wdt_rec.TASK_ID),

1221: MOVE_ORDER_LINE_ID,
1222: TRANSFER_LPN_ID,
1223: OP_PLAN_INSTANCE_ID)
1224: VALUES
1225: ( decode(p_wdt_rec.TASK_ID,NULL,wms_dispatched_tasks_s.NEXTVAL,p_wdt_rec.TASK_ID),
1226: p_wdt_rec.TRANSACTION_TEMP_ID,
1227: p_wdt_rec.ORGANIZATION_ID,
1228: p_wdt_rec.USER_TASK_TYPE,
1229: p_wdt_rec.PERSON_ID,

Line 1294: * This procedure deletes the task records into WMS_DISPATCHED_TASKS

1290: END;
1291:
1292: /**
1293: *

Procedure:Delete_Dispatched_task
1294: * This procedure deletes the task records into WMS_DISPATCHED_TASKS

1295: * AND THERE IS AN AUTOMONOUS COMMIT IN THIS DELETE!
1296: * SO IT SHOULD ONLY BE USED TO DELETE WDT CREATED BY insert_dispatched_tasks.
1297: * @param p_source_task_id - Transaction Temp Id of the WDT record.
1298: * @param x_return_status - Return Status

Line 1327: DELETE wms_dispatched_tasks

1323: END IF;
1324:
1325: x_return_status := fnd_api.g_ret_sts_success;
1326:
1327: DELETE wms_dispatched_tasks
1328: WHERE transaction_temp_id = p_source_task_id
1329: AND task_type= p_wms_task_type;
1330:
1331: COMMIT;

Line 1345: * This procedure updates the task records in WMS_DISPATCHED_TASKS

1341:
1342:
1343: /**
1344: *

Procedure:Update_Dispatched_tasks
1345: * This procedure updates the task records in WMS_DISPATCHED_TASKS

1346: * @param p_wdt_rec - WDT record that has to be updated.
1347: * @param x_return_status - Return Status
1348: * @param x_msg_count - Returns Message Count
1349: * @param x_msg_data - Returns Error Message

Line 1352: p_wdt_rec IN wms_dispatched_tasks%ROWTYPE

1348: * @param x_msg_count - Returns Message Count
1349: * @param x_msg_data - Returns Error Message
1350: */
1351: PROCEDURE update_dipatched_tasks(
1352: p_wdt_rec IN wms_dispatched_tasks%ROWTYPE
1353: , x_return_status OUT NOCOPY VARCHAR2
1354: , x_msg_count OUT NOCOPY NUMBER
1355: , x_msg_data OUT NOCOPY fnd_new_messages.MESSAGE_TEXT%TYPE
1356: )IS

Line 1377: print_debug('Updating WMS_Dispatched_tasks',l_module_name,9);

1373: END IF;
1374:
1375: --Updating the WDT Record
1376: IF (l_debug=1) THEN
1377: print_debug('Updating WMS_Dispatched_tasks',l_module_name,9);
1378: END IF;
1379:
1380: UPDATE WMS_DISPATCHED_TASKS
1381: SET

Line 1380: UPDATE WMS_DISPATCHED_TASKS

1376: IF (l_debug=1) THEN
1377: print_debug('Updating WMS_Dispatched_tasks',l_module_name,9);
1378: END IF;
1379:
1380: UPDATE WMS_DISPATCHED_TASKS
1381: SET
1382: TASK_ID =decode(p_wdt_rec.TASK_ID,G_MISS_NUM,NULL,NULL,TASK_ID,p_wdt_rec.TASK_ID),
1383: TRANSACTION_TEMP_ID =decode(p_wdt_rec.TRANSACTION_TEMP_ID,G_MISS_NUM,NULL,NULL,TRANSACTION_TEMP_ID,p_wdt_rec.TRANSACTION_TEMP_ID),
1384: ORGANIZATION_ID =decode(p_wdt_rec.ORGANIZATION_ID,G_MISS_NUM,NULL,NULL,ORGANIZATION_ID,p_wdt_rec.ORGANIZATION_ID),

Line 1452: * This procedure archives the task records into WMS_DISPATCHED_TASKS_HISTORY

1448:
1449:
1450: /**
1451: *

Procedure:Archive_Dispatched_tasks
1452: * This procedure archives the task records into WMS_DISPATCHED_TASKS_HISTORY

1453: * @param p_task_id - Task Id of WMS_DISPATCHED_TASKS
1454: * @param p_source_task_id - Document Id for the Parent document record
1455: * @param p_activity_type_id - Activity Type Id
1456: * @param p_op_plan_instance_id - Operation Plan Id for the Parent Record

Line 1453: * @param p_task_id - Task Id of WMS_DISPATCHED_TASKS

1449:
1450: /**
1451: *

Procedure:Archive_Dispatched_tasks
1452: * This procedure archives the task records into WMS_DISPATCHED_TASKS_HISTORY

1453: * @param p_task_id - Task Id of WMS_DISPATCHED_TASKS
1454: * @param p_source_task_id - Document Id for the Parent document record
1455: * @param p_activity_type_id - Activity Type Id
1456: * @param p_op_plan_instance_id - Operation Plan Id for the Parent Record
1457: * @param p_op_plan_status - Operation plan status for the Parent record

Line 1482: FROM wms_dispatched_tasks_history

1478: l_parent_txn_id NUMBER; --5523365
1479:
1480: CURSOR c_last_task IS
1481: SELECT dest_subinventory_code, dest_locator_id, drop_off_time, source_document_id
1482: FROM wms_dispatched_tasks_history
1483: WHERE parent_transaction_id = p_source_task_id
1484: ORDER BY task_id DESC;
1485:
1486: BEGIN

Line 1517: INSERT INTO WMS_DISPATCHED_TASKS_HISTORY

1513: l_progress:=30;
1514:
1515:
1516:
1517: INSERT INTO WMS_DISPATCHED_TASKS_HISTORY
1518: ( TASK_ID
1519: ,TRANSACTION_ID
1520: ,ORGANIZATION_ID
1521: ,USER_TASK_TYPE

Line 1654: FROM WMS_DISPATCHED_TASKS wdt

1650: ,mmtt.transaction_action_id
1651: ,mmtt.transaction_temp_id
1652: ,mmtt.SECONDARY_TRANSACTION_QUANTITY -- 13431255
1653: ,mmtt.SECONDARY_UOM_CODE -- 13431255
1654: FROM WMS_DISPATCHED_TASKS wdt
1655: , MTL_MATERIAL_TRANSACTIONS_TEMP MMTT
1656: , mtl_material_transactions_temp pmmtt
1657: WHERE WDT.TASK_ID=p_task_id
1658: AND WDT.transaction_temp_id=MMTT.transaction_temp_id

Line 1669: DELETE FROM wms_dispatched_tasks

1665: IF (l_debug=1) THEN
1666: print_debug('Archived WDT,now deleting the WDT record',l_module_name,9);
1667: END IF;
1668:
1669: DELETE FROM wms_dispatched_tasks
1670: WHERE task_id = p_task_id;
1671:
1672: l_progress:=50;
1673:

Line 1714: INSERT INTO WMS_DISPATCHED_TASKS_HISTORY

1710: print_debug('l_parent_txn_id = '||l_parent_txn_id,l_module_name,9);
1711: print_debug('Inserting Records for Parent with source_task_id'||p_source_task_id,l_module_name,9);
1712: END IF;
1713:
1714: INSERT INTO WMS_DISPATCHED_TASKS_HISTORY
1715: ( TASK_ID
1716: ,TRANSACTION_ID
1717: ,ORGANIZATION_ID
1718: ,USER_TASK_TYPE

Line 1784: wms_dispatched_tasks_s.NEXTVAL

1780: ,SECONDARY_TRANSACTION_QUANTITY --13431255
1781: ,SECONDARY_TRANSACTION_UOM_CODE --13431255
1782: )
1783: ( SELECT
1784: wms_dispatched_tasks_s.NEXTVAL
1785: ,MMTT.TRANSACTION_TEMP_ID
1786: ,MMTT.ORGANIZATION_ID
1787: ,-1
1788: ,-1