105:
106: FUNCTION get_unique_id RETURN NUMBER IS
107: CURSOR c_getid IS
108: SELECT gl_je_categories_s.NEXTVAL
109: FROM dual;
110: id number;
111:
112: BEGIN
113: OPEN c_getid;
162: SELECT 101, sysdate, x_last_updated_by,
163: x_je_category_name, x_user_je_category_name, x_description,
164: 'GL_JE_HEADERS', x_created_by, sysdate,
165: x_last_update_login
166: FROM dual ;
167: END IF;
168:
169: CLOSE c_dup;
170:
574: /* When je_category_name is null, we assume it to be a new row. */
575: if (X_je_category_name is null) then
576: SELECT gl_je_categories_s.NEXTVAL
577: INTO X_je_category_name
578: FROM dual;
579: raise no_data_found;
580: end if;
581:
582: /* Check if the row exists in the database. If it does, retrieves