APPS.WMS_TASK_MGMT_PUB dependencies on DUAL

Line 1186: LOOP --Validate each task record individually.

1182: ELSE
1183: l_task_table := p_task_table ;
1184: END IF;
1185: FOR i IN 1..l_task_table.count
1186: LOOP --Validate each task record individually.
1187: validate_task_id ( p_transaction_number => l_task_table(i).TRANSACTION_NUMBER,
1188: x_validation_status => l_validate_task_ret ,
1189: p_action=>p_action,--6850212
1190: x_error_msg => l_error_msg ,

Line 2267: FROM dual;

2263:
2264: IF mtlt.serial_transaction_temp_id IS NOT NULL THEN
2265: SELECT mtl_material_transactions_s.NEXTVAL
2266: INTO l_new_serial_txn_temp_id
2267: FROM dual;
2268: UPDATE mtl_transaction_lots_temp
2269: SET serial_transaction_temp_id = l_new_serial_txn_temp_id ,
2270: last_updated_by = FND_GLOBAL.USER_ID
2271: WHERE transaction_temp_id = p_new_transaction_temp_id

Line 3774: FROM DUAL

3770: exc_not_deleted EXCEPTION;
3771: CURSOR c_allow_backordering
3772: IS
3773: SELECT 'N'
3774: FROM DUAL
3775: WHERE EXISTS
3776: (SELECT 1
3777: FROM wms_dispatched_tasks wdt,
3778: mtl_material_transactions_temp mmtt

Line 6760: FROM dual;

6756: FOR i IN l_split_uom_quantities.FIRST .. l_split_uom_quantities.LAST
6757: LOOP
6758: SELECT mtl_material_transactions_s.NEXTVAL
6759: INTO l_new_transaction_header_id
6760: FROM dual;
6761: SELECT mtl_material_transactions_s.NEXTVAL
6762: INTO l_new_transaction_temp_id
6763: FROM dual;
6764: SELECT wms_dispatched_tasks_s.NEXTVAL INTO l_new_task_id FROM dual;

Line 6763: FROM dual;

6759: INTO l_new_transaction_header_id
6760: FROM dual;
6761: SELECT mtl_material_transactions_s.NEXTVAL
6762: INTO l_new_transaction_temp_id
6763: FROM dual;
6764: SELECT wms_dispatched_tasks_s.NEXTVAL INTO l_new_task_id FROM dual;
6765: IF g_debug = 1 THEN
6766: print_msg(l_procedure_name, ' Calling split_mmtt for Txn. temp id : '||p_source_transaction_number);
6767: END IF;

Line 6764: SELECT wms_dispatched_tasks_s.NEXTVAL INTO l_new_task_id FROM dual;

6760: FROM dual;
6761: SELECT mtl_material_transactions_s.NEXTVAL
6762: INTO l_new_transaction_temp_id
6763: FROM dual;
6764: SELECT wms_dispatched_tasks_s.NEXTVAL INTO l_new_task_id FROM dual;
6765: IF g_debug = 1 THEN
6766: print_msg(l_procedure_name, ' Calling split_mmtt for Txn. temp id : '||p_source_transaction_number);
6767: END IF;
6768: split_mmtt( p_orig_transaction_temp_id => p_source_transaction_number ,