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_HISTORY

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

1308:
1309:
1310: /**
1311: *

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

1313: * @param p_task_id - Task Id of WMS_DISPATCHED_TASKS
1314: * @param p_source_task_id - Document Id for the Parent document record
1315: * @param p_activity_type_id - Activity Type Id
1316: * @param p_op_plan_instance_id - Operation Plan Id for the Parent Record

Line 1342: FROM wms_dispatched_tasks_history

1338: l_parent_txn_id NUMBER; --5523365
1339:
1340: CURSOR c_last_task IS
1341: SELECT dest_subinventory_code, dest_locator_id, drop_off_time, source_document_id
1342: FROM wms_dispatched_tasks_history
1343: WHERE parent_transaction_id = p_source_task_id
1344: ORDER BY task_id DESC;
1345:
1346: BEGIN

Line 1377: INSERT INTO WMS_DISPATCHED_TASKS_HISTORY

1373: l_progress:=30;
1374:
1375:
1376:
1377: INSERT INTO WMS_DISPATCHED_TASKS_HISTORY
1378: ( TASK_ID
1379: ,TRANSACTION_ID
1380: ,ORGANIZATION_ID
1381: ,USER_TASK_TYPE

Line 1570: INSERT INTO WMS_DISPATCHED_TASKS_HISTORY

1566: print_debug('l_parent_txn_id = '||l_parent_txn_id,l_module_name,9);
1567: print_debug('Inserting Records for Parent with source_task_id'||p_source_task_id,l_module_name,9);
1568: END IF;
1569:
1570: INSERT INTO WMS_DISPATCHED_TASKS_HISTORY
1571: ( TASK_ID
1572: ,TRANSACTION_ID
1573: ,ORGANIZATION_ID
1574: ,USER_TASK_TYPE