eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FND_REQUEST dependencies on FND_CONC_RELEASE_CLASSES

Line 726: from fnd_conc_release_classes

722: if (P_USES_REL_CLASS = 1) then
723: begin
724: select class_type, class_info, date1, date2
725: into schedule_type, schedule_info, sch_req_date, sch_end_date
726: from fnd_conc_release_classes
727: where application_id = P_REL_CLASS_APP_ID
728: and release_class_id = P_REL_CLASS_ID;
729:
730: if schedule_type = 'S' then

Line 1681: Select FND_CONC_RELEASE_CLASSES_S.nextval, 0

1677: if (P_REL_CLASS_ID is null) and (P_REPEAT_INTERVAL is not null
1678: or P_REPEAT_TIME is not null) then
1679: new_class := TRUE;
1680: begin
1681: Select FND_CONC_RELEASE_CLASSES_S.nextval, 0
1682: into P_REL_CLASS_ID, P_REL_CLASS_APP_ID from Sys.dual;
1683: exception
1684: when no_data_found then
1685: raise dual_no_rows;

Line 1942: INSERT INTO Fnd_Conc_Release_Classes

1938:
1939:
1940: if (new_class) then
1941: begin
1942: INSERT INTO Fnd_Conc_Release_Classes
1943: (APPLICATION_ID, RELEASE_CLASS_ID,
1944: RELEASE_CLASS_NAME, OWNER_REQ_ID,
1945: ENABLED_FLAG, LAST_UPDATE_DATE,
1946: LAST_UPDATED_BY, LAST_UPDATE_LOGIN,

Line 1975: INSERT INTO Fnd_Conc_Release_Classes_TL

1971: if (sql%rowcount = 0) then
1972: raise relclass_insert_error;
1973: end if;
1974:
1975: INSERT INTO Fnd_Conc_Release_Classes_TL
1976: (APPLICATION_ID, RELEASE_CLASS_ID,
1977: LANGUAGE, SOURCE_LANG, USER_RELEASE_CLASS_NAME,
1978: LAST_UPDATE_DATE,
1979: LAST_UPDATED_BY, LAST_UPDATE_LOGIN,

Line 2030: from fnd_conc_release_classes c, fnd_concurrent_requests r

2026: IF (P_USES_REL_CLASS = 1 AND schedule_type = 'X') THEN
2027: begin
2028: select c.resubmit_interval, c.resubmit_interval_unit_code, c.resubmit_interval_type_code
2029: into adv_sch_ri, adv_sch_riuc, adv_sch_ritc
2030: from fnd_conc_release_classes c, fnd_concurrent_requests r
2031: where r.request_id = cur_request_id and r.release_class_id = c.release_class_id
2032: and r.release_class_app_id = c.application_id;
2033: exception when others then
2034: adv_sch_ri := null;

Line 2923: From Fnd_Conc_Release_Classes C, Fnd_Application A

2919: if (class_name is not null) then
2920: begin
2921: Select A.Application_ID, C.Release_Class_Id
2922: Into P_REL_CLASS_APP_ID, P_REL_CLASS_ID
2923: From Fnd_Conc_Release_Classes C, Fnd_Application A
2924: Where Upper(Release_class_Name) = upper(class_name)
2925: And C.Application_ID = A.Application_ID
2926: And A.Application_Short_Name = upper(application);
2927:

Line 4491: Select FND_CONC_RELEASE_CLASSES_S.nextval, 0

4487: else
4488: P_REPEAT_END_DATE := FND_CONC_DATE.STRING_TO_DATE(P_REQUESTED_END_DATE);
4489: end if;
4490:
4491: Select FND_CONC_RELEASE_CLASSES_S.nextval, 0
4492: into P_RELEASE_CLASS_ID, P_RELEASE_CLASS_APP_ID from Sys.dual;
4493:
4494: SELECT (DECODE(P_CLASS_TYPE, 'P', Decode(P_REPEAT_INTERVAL_UNIT, NULL, NULL,
4495: P_REPEAT_INTERVAL||':'||

Line 4506: INSERT INTO FND_CONC_RELEASE_CLASSES

4502: 'START', 'S', 'C')), NULL)) INTO P_REPEAT_VALUE FROM SYS.DUAL;
4503:
4504: -- Bug 6808926. Consider repeat start date as SYSDATE if null
4505:
4506: INSERT INTO FND_CONC_RELEASE_CLASSES
4507: (APPLICATION_ID, RELEASE_CLASS_ID, RELEASE_CLASS_NAME,
4508: ENABLED_FLAG, LAST_UPDATE_DATE, LAST_UPDATED_BY,
4509: LAST_UPDATE_LOGIN, CREATION_DATE, CREATED_BY,
4510: UPDATED_FLAG, DATE1, DATE2,

Line 4522: INSERT INTO FND_CONC_RELEASE_CLASSES_TL

4518: if (sql%rowcount = 0) then
4519: raise RELCLASS_INSERT_ERROR;
4520: end if;
4521:
4522: INSERT INTO FND_CONC_RELEASE_CLASSES_TL
4523: (APPLICATION_ID, RELEASE_CLASS_ID,
4524: LANGUAGE, SOURCE_LANG, USER_RELEASE_CLASS_NAME,
4525: LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN,
4526: CREATION_DATE, CREATED_BY, DESCRIPTION)

Line 4593: from fnd_conc_release_classes_vl rc, fnd_application_vl a

4589: end if;
4590:
4591: begin
4592: select rc.application_id, rc.release_class_id into P_RELEASE_CLASS_APP_ID, P_RELEASE_CLASS_ID
4593: from fnd_conc_release_classes_vl rc, fnd_application_vl a
4594: where rc.owner_req_id is null
4595: and rc.application_id = a.application_id
4596: and rc.user_release_class_name = P_RELEASE_CLASS_NAME;
4597: exception

Line 4612: UPDATE FND_CONC_RELEASE_CLASSES

4608: 'DAYS', 'D') || ':' ||
4609: Decode(P_REPEAT_INTERVAL_TYPE,
4610: 'START', 'S', 'C')), NULL)) INTO P_REPEAT_VALUE FROM SYS.DUAL;
4611:
4612: UPDATE FND_CONC_RELEASE_CLASSES
4613: set LAST_UPDATE_DATE = SYSDATE,
4614: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
4615: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID,
4616: DATE1 = decode(P_REPEAT_START_DATE, null, SYSDATE, P_REPEAT_START_DATE),

Line 4645: from fnd_conc_release_classes_vl rc, fnd_application_vl a

4641: begin
4642:
4643: begin
4644: select rc.application_id, rc.release_class_id into P_RELEASE_CLASS_APP_ID, P_RELEASE_CLASS_ID
4645: from fnd_conc_release_classes_vl rc, fnd_application_vl a
4646: where rc.owner_req_id is null
4647: and rc.application_id = a.application_id
4648: and rc.user_release_class_name = schName;
4649: exception

Line 4654: delete from FND_CONC_RELEASE_CLASSES

4650: when no_data_found then
4651: return false;
4652: end;
4653:
4654: delete from FND_CONC_RELEASE_CLASSES
4655: where APPLICATION_ID = P_RELEASE_CLASS_APP_ID
4656: and release_class_id = P_RELEASE_CLASS_ID;
4657:
4658: delete from FND_CONC_RELEASE_CLASSES_TL

Line 4658: delete from FND_CONC_RELEASE_CLASSES_TL

4654: delete from FND_CONC_RELEASE_CLASSES
4655: where APPLICATION_ID = P_RELEASE_CLASS_APP_ID
4656: and release_class_id = P_RELEASE_CLASS_ID;
4657:
4658: delete from FND_CONC_RELEASE_CLASSES_TL
4659: where APPLICATION_ID = P_RELEASE_CLASS_APP_ID
4660: and release_class_id = P_RELEASE_CLASS_ID;
4661:
4662: commit;