APPS.FND_CONC_RELEASE_CLASS_UTILS dependencies on FND_CONC_RELEASE_CLASSES

Line 130: from fnd_conc_release_classes c, fnd_application a

126: p_start_date := null;
127:
128: select a.application_id, c.release_class_id
129: into p_rel_class_app_id, p_rel_class_id
130: from fnd_conc_release_classes c, fnd_application a
131: where upper(release_class_name) = upper(p_class_name)
132: and c.application_id = a.application_id
133: and a.application_short_name = upper(p_application);
134:

Line 182: from fnd_conc_release_classes

178: p_start_date := null;
179:
180: select class_info, class_type, date1, date2
181: into curr_info, sch_type, req_date, p_repeat_end
182: from fnd_conc_release_classes
183: where application_id = p_rel_class_app_id
184: and release_class_id = p_rel_class_id;
185:
186: if sch_type <> 'P' then

Line 271: Select Fnd_Conc_Release_Classes_S.nextval

267:
268: begin
269:
270: begin
271: Select Fnd_Conc_Release_Classes_S.nextval
272: Into relseqno
273: From Sys.Dual;
274:
275: exception

Line 286: Insert Into fnd_conc_release_classes (application_id, release_class_id, release_class_name, owner_req_id, enabled_flag,

282: end;
283:
284: relclassname := 'RSRUN:0-' || TO_CHAR(relseqno);
285:
286: Insert Into fnd_conc_release_classes (application_id, release_class_id, release_class_name, owner_req_id, enabled_flag,
287: creation_date, created_by, last_update_date, last_updated_by, last_update_login, updated_flag, date1, date2, class_type,
288: class_info)
289: Values (0 , relseqno, relclassname, req_id, 'Y', Sysdate, FND_GLOBAL.conc_login_id, Sysdate,
290: FND_GLOBAL.conc_login_id, FND_GLOBAL.conc_login_id, 'N', start_date, end_date, 'S', class_info);

Line 296: INSERT INTO Fnd_Conc_Release_Classes_TL (application_id, release_class_id, language, source_lang,

292: if (sql%rowcount = 0) then
293: raise relclass_insert_error;
294: end if;
295:
296: INSERT INTO Fnd_Conc_Release_Classes_TL (application_id, release_class_id, language, source_lang,
297: user_release_class_name,last_update_date, last_updated_by, last_update_login, creation_date, created_by)
298: Select 0, relseqno, L.LANGUAGE_CODE, userenv('LANG'), relclassname,
299: Sysdate, FND_GLOBAL.conc_login_id, FND_GLOBAL.conc_login_id, Sysdate, FND_GLOBAL.conc_login_id from FND_LANGUAGES L
300: where L.INSTALLED_FLAG in ('I', 'B');