APPS.WMS_TASK_DISPATCH_ENGINE dependencies on DUAL

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

11429: EXIT WHEN task_list%NOTFOUND;
11430: END IF;
11431:
11432: l_parent_task_count := l_parent_task_count + 1;
11433: --SELECT mtl_material_transactions_s.NEXTVAL INTO l_new_txn_temp_id FROM DUAL;
11434:
11435: IF (l_debug = 1) THEN
11436: print_debug('Creating a Parent Line with the values...', 4);
11437: print_debug(' --> Txn Header ID => ' || l_transaction_header_id, 4);

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

12171: END IF;
12172: end if;
12173:
12174: l_parent_task_count := l_parent_task_count + 1;
12175: -- SELECT mtl_material_transactions_s.NEXTVAL INTO l_new_txn_temp_id FROM DUAL;
12176:
12177: IF (l_debug = 1) THEN
12178: print_debug('Creating a Parent Line with the values...', 4);
12179: print_debug(' --> Txn Header ID => ' || l_transaction_header_id, 4);

Line 12966: FROM DUAL;

12962:
12963: -- generate new transaction_temp_id primary key
12964: SELECT mtl_material_transactions_s.NEXTVAL
12965: INTO l_new_temp_id
12966: FROM DUAL;
12967:
12968: l_progress := '140';
12969: /* Is it necessary to change transaction UOM to locator UOM here ???*/
12970: IF G_CURRENT_RELEASE_LEVEL >= G_J_RELEASE_LEVEL AND

Line 13060: FROM DUAL;

13056: -- split the child task
13057: -- generate new transaction_temp_id primary key
13058: SELECT mtl_material_transactions_s.NEXTVAL
13059: INTO l_new_child_temp_id
13060: FROM DUAL;
13061:
13062: l_progress := '140.1';
13063: select *
13064: into