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 2351: FROM dual;

2347:
2348: IF mtlt.serial_transaction_temp_id IS NOT NULL THEN
2349: SELECT mtl_material_transactions_s.NEXTVAL
2350: INTO l_new_serial_txn_temp_id
2351: FROM dual;
2352: UPDATE mtl_transaction_lots_temp
2353: SET serial_transaction_temp_id = l_new_serial_txn_temp_id ,
2354: last_updated_by = FND_GLOBAL.USER_ID
2355: WHERE transaction_temp_id = p_new_transaction_temp_id

Line 3863: FROM DUAL

3859: exc_not_deleted EXCEPTION;
3860: CURSOR c_allow_backordering
3861: IS
3862: SELECT 'N'
3863: FROM DUAL
3864: WHERE EXISTS
3865: (SELECT 1
3866: FROM wms_dispatched_tasks wdt,
3867: mtl_material_transactions_temp mmtt

Line 6855: FROM dual;

6851: FOR i IN l_split_uom_quantities.FIRST .. l_split_uom_quantities.LAST
6852: LOOP
6853: SELECT mtl_material_transactions_s.NEXTVAL
6854: INTO l_new_transaction_header_id
6855: FROM dual;
6856: SELECT mtl_material_transactions_s.NEXTVAL
6857: INTO l_new_transaction_temp_id
6858: FROM dual;
6859: SELECT wms_dispatched_tasks_s.NEXTVAL INTO l_new_task_id FROM dual;

Line 6858: FROM dual;

6854: INTO l_new_transaction_header_id
6855: FROM dual;
6856: SELECT mtl_material_transactions_s.NEXTVAL
6857: INTO l_new_transaction_temp_id
6858: FROM dual;
6859: SELECT wms_dispatched_tasks_s.NEXTVAL INTO l_new_task_id FROM dual;
6860: IF g_debug = 1 THEN
6861: print_msg(l_procedure_name, ' Calling split_mmtt for Txn. temp id : '||p_source_transaction_number);
6862: END IF;

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

6855: FROM dual;
6856: SELECT mtl_material_transactions_s.NEXTVAL
6857: INTO l_new_transaction_temp_id
6858: FROM dual;
6859: SELECT wms_dispatched_tasks_s.NEXTVAL INTO l_new_task_id FROM dual;
6860: IF g_debug = 1 THEN
6861: print_msg(l_procedure_name, ' Calling split_mmtt for Txn. temp id : '||p_source_transaction_number);
6862: END IF;
6863: split_mmtt( p_orig_transaction_temp_id => p_source_transaction_number ,