Line 402: l_req_id := FND_GLOBAL.CONC_REQUEST_ID();
398: CURSOR c_get_next_seq IS
399: SELECT IGS_PE_PERSID_GROUP_GP_ID_S.NEXTVAL
400: FROM DUAL;
401: BEGIN 402: l_req_id := FND_GLOBAL.CONC_REQUEST_ID(); 403: l_group_cd := igs_ad_gen_012.ret_group_cd();
404: -- Get the current user ID
405: v_user_id := p_responsible_user;
406: -- Get the next sequence number for the primary key