DBA Data[Home] [Help]

APPS.WMS_OP_INBOUND_PVT dependencies on DUAL

Line 231: p_subsequent_op_plan_id IS NOT NULL) -- this is necessary because this file is dual maintained for 11.5.10

227: }}
228:
229: */
230: IF (p_operation_type_id = g_op_type_crossdock AND
231: p_subsequent_op_plan_id IS NOT NULL) -- this is necessary because this file is dual maintained for 11.5.10
232: THEN
233:
234: IF (l_debug=1) THEN
235: print_debug('Stamp subsequent OP plan ID '||p_subsequent_op_plan_id||' to child task. ',l_module_name,9);

Line 1931: p_subsequent_op_plan_id IS NOT NULL) -- this is necessary because this file is dual maintained for 11.5.10

1927: }}
1928:
1929: */
1930: IF (p_next_operation_type_id = g_op_type_crossdock AND
1931: p_subsequent_op_plan_id IS NOT NULL) -- this is necessary because this file is dual maintained for 11.5.10
1932: THEN
1933:
1934: INV_TRX_UTIL_PUB.copy_insert_line_trx
1935: (

Line 2875: FROM dual

2871: p_mmtt_error_code,
2872: p_mmtt_error_explanation,
2873: NULL,
2874: NULL
2875: FROM dual
2876: )
2877: WHERE mmtt.transaction_temp_id = p_source_task_id;
2878: ELSE
2879: IF l_debug = 1 THEN