38: v_login := fnd_global.user_id;
39:
40: SELECT fv_ye_groups_id_s.NEXTVAL
41: INTO v_new_group_id
42: FROM dual;
43: --pkpatel:Added code to fix Bug.1575992
44:
45: --Bug 2374153: Add If to check if new_treasury_symbol is null
46: IF v_treasury_symbol_new IS NOT NULL THEN
90: 'SEQUENCE = '||C_SEQUENCES_REC.SEQUENCE);
91: END IF;
92: SELECT fv_ye_group_sequences_s.NEXTVAL
93: INTO v_sequence_id
94: FROM dual;
95:
96: INSERT INTO fv_ye_group_sequences
97: (sequence_id,
98: group_id,