APPS.AMS_IMPORTCLIENT_PVT dependencies on DUAL

Line 892: FROM dual;

888:
889: FOR i IN 1 .. l_import_source_line_id.COUNT
890: LOOP
891: SELECT as_import_interface_s.NEXTVAL INTO l_interface_id(i)
892: FROM dual;
893: END LOOP;
894:
895: FORALL i IN 1 .. l_import_source_line_id.COUNT
896: INSERT INTO as_import_interface

Line 2204: 'SELECT ' || l_seq_name || '.NEXTVAL FROM DUAL' INTO l_start_seq_num;

2200: --
2201: FOR seq_index IN 1 .. p_row_count
2202: LOOP
2203: EXECUTE IMMEDIATE
2204: 'SELECT ' || l_seq_name || '.NEXTVAL FROM DUAL' INTO l_start_seq_num;
2205: l_source_line_keys(seq_index) := l_start_seq_num;
2206: END LOOP;
2207:
2208: l_col_clause1 := l_col_clause1 || p_prim_key_name || ',';

Line 2513: FROM DUAL;

2509: x_return_status := FND_API.G_RET_STS_SUCCESS;
2510:
2511: LOOP
2512: SELECT AMS_LIST_IMPORT_ERRORS_S.NEXTVAL INTO l_list_imp_id
2513: FROM DUAL;
2514:
2515: l_flag := NULL;
2516:
2517: OPEN c_list_imp_error (l_list_imp_id);