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 1154: * This procedure deletes the task records into WMS_DISPATCHED_TASKS

1150: END;
1151:
1152: /**
1153: *

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

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

Line 1187: DELETE wms_dispatched_tasks

1183: END IF;
1184:
1185: x_return_status := fnd_api.g_ret_sts_success;
1186:
1187: DELETE wms_dispatched_tasks
1188: WHERE transaction_temp_id = p_source_task_id
1189: AND task_type= p_wms_task_type;
1190:
1191: COMMIT;

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

1201:
1202:
1203: /**
1204: *

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

1206: * @param p_wdt_rec - WDT record that has to be updated.
1207: * @param x_return_status - Return Status
1208: * @param x_msg_count - Returns Message Count
1209: * @param x_msg_data - Returns Error Message

Line 1212: p_wdt_rec IN wms_dispatched_tasks%ROWTYPE

1208: * @param x_msg_count - Returns Message Count
1209: * @param x_msg_data - Returns Error Message
1210: */
1211: PROCEDURE update_dipatched_tasks(
1212: p_wdt_rec IN wms_dispatched_tasks%ROWTYPE
1213: , x_return_status OUT NOCOPY VARCHAR2
1214: , x_msg_count OUT NOCOPY NUMBER
1215: , x_msg_data OUT NOCOPY fnd_new_messages.MESSAGE_TEXT%TYPE
1216: )IS

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

1233: END IF;
1234:
1235: --Updating the WDT Record
1236: IF (l_debug=1) THEN
1237: print_debug('Updating WMS_Dispatched_tasks',l_module_name,9);
1238: END IF;
1239:
1240: UPDATE WMS_DISPATCHED_TASKS
1241: SET

Line 1240: UPDATE WMS_DISPATCHED_TASKS

1236: IF (l_debug=1) THEN
1237: print_debug('Updating WMS_Dispatched_tasks',l_module_name,9);
1238: END IF;
1239:
1240: UPDATE WMS_DISPATCHED_TASKS
1241: SET
1242: TASK_ID =decode(p_wdt_rec.TASK_ID,G_MISS_NUM,NULL,NULL,TASK_ID,p_wdt_rec.TASK_ID),
1243: TRANSACTION_TEMP_ID =decode(p_wdt_rec.TRANSACTION_TEMP_ID,G_MISS_NUM,NULL,NULL,TRANSACTION_TEMP_ID,p_wdt_rec.TRANSACTION_TEMP_ID),
1244: ORGANIZATION_ID =decode(p_wdt_rec.ORGANIZATION_ID,G_MISS_NUM,NULL,NULL,ORGANIZATION_ID,p_wdt_rec.ORGANIZATION_ID),

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 1313: * @param p_task_id - Task Id of WMS_DISPATCHED_TASKS

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
1317: * @param p_op_plan_status - Operation plan status 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 1510: FROM WMS_DISPATCHED_TASKS wdt

1506: ,mmtt.transaction_source_type_id
1507: ,mmtt.transaction_type_id
1508: ,mmtt.transaction_action_id
1509: ,mmtt.transaction_temp_id
1510: FROM WMS_DISPATCHED_TASKS wdt
1511: , MTL_MATERIAL_TRANSACTIONS_TEMP MMTT
1512: , mtl_material_transactions_temp pmmtt
1513: WHERE WDT.TASK_ID=p_task_id
1514: AND WDT.transaction_temp_id=MMTT.transaction_temp_id

Line 1525: DELETE FROM wms_dispatched_tasks

1521: IF (l_debug=1) THEN
1522: print_debug('Archived WDT,now deleting the WDT record',l_module_name,9);
1523: END IF;
1524:
1525: DELETE FROM wms_dispatched_tasks
1526: WHERE task_id = p_task_id;
1527:
1528: l_progress:=50;
1529:

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

Line 1637: wms_dispatched_tasks_s.NEXTVAL

1633: ,TRANSACTION_TYPE_ID
1634: ,transaction_action_id
1635: ,transaction_temp_id)
1636: ( SELECT
1637: wms_dispatched_tasks_s.NEXTVAL
1638: ,MMTT.TRANSACTION_TEMP_ID
1639: ,MMTT.ORGANIZATION_ID
1640: ,-1
1641: ,-1