DBA Data[Home] [Help]

APPS.GL_JE_CATEGORIES_PKG dependencies on DUAL

Line 109: FROM dual;

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;

Line 166: FROM dual ;

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:

Line 585: FROM dual;

581: /* When je_category_name is null, we assume it to be a new row. */
582: if (X_je_category_name is null) then
583: SELECT gl_je_categories_s.NEXTVAL
584: INTO X_je_category_name
585: FROM dual;
586: raise no_data_found;
587: end if;
588:
589: /* Check if the row exists in the database. If it does, retrieves