APPS.WMS_TASK_DISPATCH_ENGINE dependencies on DUAL

Line 11860: --SELECT mtl_material_transactions_s.NEXTVAL INTO l_new_txn_temp_id FROM DUAL;

11856: EXIT WHEN task_list%NOTFOUND;
11857: END IF;
11858:
11859: l_parent_task_count := l_parent_task_count + 1;
11860: --SELECT mtl_material_transactions_s.NEXTVAL INTO l_new_txn_temp_id FROM DUAL;
11861:
11862: IF (l_debug = 1) THEN
11863: print_debug('Creating a Parent Line with the values...', 4);
11864: print_debug(' --> Txn Header ID => ' || l_transaction_header_id, 4);

Line 12666: -- SELECT mtl_material_transactions_s.NEXTVAL INTO l_new_txn_temp_id FROM DUAL;

12662: END IF;
12663: end if;
12664:
12665: l_parent_task_count := l_parent_task_count + 1;
12666: -- SELECT mtl_material_transactions_s.NEXTVAL INTO l_new_txn_temp_id FROM DUAL;
12667:
12668: IF (l_debug = 1) THEN
12669: print_debug('Creating a Parent Line with the values...', 4);
12670: print_debug(' --> Txn Header ID => ' || l_transaction_header_id, 4);

Line 13592: FROM DUAL;

13588:
13589: -- generate new transaction_temp_id primary key
13590: SELECT mtl_material_transactions_s.NEXTVAL
13591: INTO l_new_temp_id
13592: FROM DUAL;
13593:
13594: l_progress := '140';
13595: /* Is it necessary to change transaction UOM to locator UOM here ???*/
13596: IF G_CURRENT_RELEASE_LEVEL >= G_J_RELEASE_LEVEL AND

Line 13708: FROM DUAL;

13704: -- split the child task
13705: -- generate new transaction_temp_id primary key
13706: SELECT mtl_material_transactions_s.NEXTVAL
13707: INTO l_new_child_temp_id
13708: FROM DUAL;
13709:
13710: l_progress := '140.1';
13711: select *
13712: into