391:
392: --get next sequential number for route_id
393: SELECT IEM_TAG_KEYS_s1.nextval
394: INTO l_seq_id 395: FROM dual; 396:
397: -- G_ROUTE_ID := l_seq_id;
398:
399: INSERT INTO IEM_TAG_KEYS
Line 631: FROM dual;
627:
628: --actual API begins here
629: SELECT IEM_ACCOUNT_TAG_KEYS_s1.nextval
630: INTO l_seq_id 631: FROM dual; 632:
633: INSERT INTO IEM_ACCOUNT_TAG_KEYS
634: (
635: ACCOUNT_TAG_KEY_ID,