APPS.FND_REQUEST dependencies on FND_CONCURRENT_REQUESTS

Line 441: Select Fnd_Concurrent_Requests_S.nextval

437: -- Get next request ID from sequence
438: -- only if it is a normal call without P_DEFERRED_MODE or its deferred call
439: if ( (P_DEFERRED_MODE) OR (P_DEF_REQUEST_ID = 0)) then
440: begin
441: Select Fnd_Concurrent_Requests_S.nextval
442: Into cur_request_id
443: From Sys.Dual;
444: exception
445: when no_data_found then

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

673:
674:
675: -- Someone specified a schedule to use.
676: -- If it is a Specific schedule, figure out the correct start date to use.
677: -- If it is a Periodic schedule, populate the correct fields in FND_CONCURRENT_REQUESTS.
678: if (P_USES_REL_CLASS = 1) then
679: begin
680: select class_type, class_info, date1, date2
681: into schedule_type, schedule_info, sch_req_date, sch_end_date

Line 873: from fnd_concurrent_requests

869: -- definition of pending: phase_code in P and hold_flag in N and
870: -- requested_start_date lessthan sysdate
871: begin
872: select count(*) into no_pending_req
873: from fnd_concurrent_requests
874: where program_application_id = prog_appl_id
875: And concurrent_program_id = conc_prog_id
876: And phase_code = 'P'
877: and hold_flag='N' and requested_start_date <= sysdate;

Line 1589: Into Fnd_Concurrent_Requests (

1585: end;
1586: end if;
1587:
1588: Insert
1589: Into Fnd_Concurrent_Requests (
1590: Request_Id, security_group_id,
1591: Phase_Code, Status_Code,
1592: Priority, Parent_Request_ID, Priority_Request_ID,
1593: Description, Req_Information,

Line 1863: From Fnd_Concurrent_Requests

1859: Decode(P_REPEAT_INTERVAL_TYPE,
1860: 'START', 'S', 'C')),
1861: null, null,
1862: Requested_start_date, resubmit_end_date
1863: From Fnd_Concurrent_Requests
1864: Where Request_ID = cur_request_id;
1865:
1866: if (sql%rowcount = 0) then
1867: raise relclass_insert_error;

Line 1925: from fnd_conc_release_classes c, fnd_concurrent_requests r

1921: IF (P_USES_REL_CLASS = 1 AND schedule_type = 'X') THEN
1922: begin
1923: select c.resubmit_interval, c.resubmit_interval_unit_code, c.resubmit_interval_type_code
1924: into adv_sch_ri, adv_sch_riuc, adv_sch_ritc
1925: from fnd_conc_release_classes c, fnd_concurrent_requests r
1926: where r.request_id = cur_request_id and r.release_class_id = c.release_class_id
1927: and r.release_class_app_id = c.application_id;
1928: exception when others then
1929: adv_sch_ri := null;

Line 1933: update fnd_concurrent_requests fcr

1929: adv_sch_ri := null;
1930: adv_sch_riuc := null;
1931: adv_sch_ritc := null;
1932: end;
1933: update fnd_concurrent_requests fcr
1934: set fcr.resubmit_interval = nvl(adv_sch_ri,1),
1935: fcr.resubmit_interval_unit_code = nvl(adv_sch_riuc,'DAYS'),
1936: fcr.resubmit_interval_type_code = nvl(adv_sch_ritc,'START'),
1937: fcr.status_code = 'P'