DBA Data[Home] [Help]

APPS.ZX_TEST_API dependencies on DUAL

Line 397: FROM DUAL;

393: IF p_type = 'HEADER' THEN
394: --SELECT zx_trx_header_id_s.nextval
395: SELECT zx_transaction_s.nextval
396: INTO x_real_value
397: FROM DUAL;
398: --------------------------------------------------------
399: -- This value has been harcoded to test with Nilesh data
400: --------------------------------------------------------
401: ELSIF p_type = 'LINE' THEN

Line 405: FROM DUAL;

401: ELSIF p_type = 'LINE' THEN
402: --SELECT zx_trx_line_id_s.nextval
403: SELECT zx_transaction_lines_s.nextval
404: INTO x_real_value
405: FROM DUAL;
406: --------------------------------------------------------
407: -- This value has been harcoded to test with Nilesh data
408: --------------------------------------------------------
409: ELSIF p_type = 'DIST' THEN

Line 413: FROM DUAL;

409: ELSIF p_type = 'DIST' THEN
410: --SELECT zx_trx_line_dist_id_s.nextval
411: SELECT zx_sim_trx_dists_s.nextval
412: INTO x_real_value
413: FROM DUAL;
414: END IF;
415: write_message('~ Surrogate Key '||to_char(p_surrogate_key));
416: write_message('~ has been substituted for the generated key :'
417: ||to_char(x_real_value));