APPS.FND_REQUEST dependencies on FND_CONCURRENT_REQUESTS

Line 490: Select Fnd_Concurrent_Requests_S.nextval

486: -- Get next request ID from sequence
487: -- only if it is a normal call without P_DEFERRED_MODE or its deferred call
488: if ( (P_DEFERRED_MODE) OR (P_DEF_REQUEST_ID = 0)) then
489: begin
490: Select Fnd_Concurrent_Requests_S.nextval
491: Into cur_request_id
492: From Sys.Dual;
493: exception
494: when no_data_found then

Line 721: -- If it is a Periodic schedule, populate the correct fields in FND_CONCURRENT_REQUESTS.

717:
718:
719: -- Someone specified a schedule to use.
720: -- If it is a Specific schedule, figure out the correct start date to use.
721: -- If it is a Periodic schedule, populate the correct fields in FND_CONCURRENT_REQUESTS.
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

Line 932: from fnd_concurrent_requests

928: -- definition of pending: phase_code in P and hold_flag in N and
929: -- requested_start_date lessthan sysdate
930: begin
931: select count(*) into no_pending_req
932: from fnd_concurrent_requests
933: where program_application_id = prog_appl_id
934: And concurrent_program_id = conc_prog_id
935: And phase_code = 'P'
936: and hold_flag='N' and requested_start_date <= sysdate;

Line 1694: Into Fnd_Concurrent_Requests (

1690: end;
1691: end if;
1692:
1693: Insert
1694: Into Fnd_Concurrent_Requests (
1695: Request_Id, security_group_id,
1696: Phase_Code, Status_Code,
1697: Priority, Parent_Request_ID, Priority_Request_ID,
1698: Description, Req_Information,

Line 1968: From Fnd_Concurrent_Requests

1964: Decode(P_REPEAT_INTERVAL_TYPE,
1965: 'START', 'S', 'C')),
1966: null, null,
1967: Requested_start_date, resubmit_end_date
1968: From Fnd_Concurrent_Requests
1969: Where Request_ID = cur_request_id;
1970:
1971: if (sql%rowcount = 0) then
1972: raise relclass_insert_error;

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 2038: update fnd_concurrent_requests fcr

2034: adv_sch_ri := null;
2035: adv_sch_riuc := null;
2036: adv_sch_ritc := null;
2037: end;
2038: update fnd_concurrent_requests fcr
2039: set fcr.resubmit_interval = nvl(adv_sch_ri,1),
2040: fcr.resubmit_interval_unit_code = nvl(adv_sch_riuc,'DAYS'),
2041: fcr.resubmit_interval_type_code = nvl(adv_sch_ritc,'START'),
2042: fcr.status_code = 'P'