APPS.XDP_ADAPTER_CORE_DB dependencies on XDP_ADAPTER_ADMIN_REQS

Line 119: select XDP_ADAPTER_ADMIN_REQS_S.NEXTVAL into p_RequestID from dual;

115: p_JobID OUT NOCOPY number)
116: is
117:
118: begin
119: select XDP_ADAPTER_ADMIN_REQS_S.NEXTVAL into p_RequestID from dual;
120:
121: XDP_CRON_UTIL.SubmitAdapterAdminJob(p_request => p_RequestID,
122: p_RunDate => SubmitAdapterAdminReq.p_RequestDate,
123: p_RunFreq => SubmitAdapterAdminReq.p_Freq,

Line 126: insert into xdp_adapter_admin_reqs

122: p_RunDate => SubmitAdapterAdminReq.p_RequestDate,
123: p_RunFreq => SubmitAdapterAdminReq.p_Freq,
124: p_JobNumber => p_JobID);
125:
126: insert into xdp_adapter_admin_reqs
127: (request_id,
128: channel_name,
129: request_type,
130: request_date,

Line 169: update xdp_adapter_admin_reqs set

165: p_request => p_RequestID,
166: p_ReqDate => p_RequestDate,
167: p_Freq => p_Freq);
168:
169: update xdp_adapter_admin_reqs set
170: request_date = p_RequestDate,
171: requested_by_user = p_RequestedBy,
172: request_frequency = p_Freq,
173: last_update_date = sysdate,

Line 189: delete from xdp_adapter_admin_reqs where request_id = p_RequestID;

185: l_jobID := Get_Job_Id_For_Request (p_RequestID);
186:
187: dbms_job.remove(l_jobID);
188:
189: delete from xdp_adapter_admin_reqs where request_id = p_RequestID;
190:
191: end RemoveAdapterAdminReq;
192:
193:

Line 206: from xdp_adapter_admin_reqs xar

202:
203: cursor c_GetAdapterAdmin is
204: select xar.request_type, xar.request_date, xar.requested_by_user, xar.request_frequency,
205: xar.channel_name, xar.job_id
206: from xdp_adapter_admin_reqs xar
207: where request_id = p_RequestID;
208:
209: l_Found varchar2(1) := 'N';
210: begin

Line 235: from xdp_adapter_admin_reqs

231: p_RequestDate in date) return number
232: is
233: cursor c_CheckReq is
234: select request_id, job_id
235: from xdp_adapter_admin_reqs
236: where channel_name = DoesSystemReqAlreadyExist.p_ChannelName
237: and request_type = DoesSystemReqAlreadyExist.p_RequestType
238: and requested_by_user = XDP_ADAPTER.pv_adminReqBySystem
239: and request_date <= nvl(p_RequestDate,sysdate);

Line 954: from xdp_adapter_admin_reqs

950: Function Get_Job_Id_For_Request (p_RequestId in number) return number
951: is
952: cursor c_GetJobID is
953: select job_id
954: from xdp_adapter_admin_reqs
955: where request_id = p_RequestId;
956:
957: l_JobId number := -1;
958:

Line 1039: from xdp_adapter_admin_reqs xar

1035: IS
1036:
1037: cursor c_GetAdapterAdminReqs is
1038: select xar.request_id
1039: from xdp_adapter_admin_reqs xar
1040: where channel_name = p_channel_name;
1041:
1042: BEGIN
1043: -- Cleanup XDP_ERROR_LOG

Line 1066: -- XDP_ADAPTER_ADMIN_REQS table if present

1062: NULL;
1063: END;
1064:
1065: -- Delete all occurences of the requests and dbms_jobs for the adapter from the
1066: -- XDP_ADAPTER_ADMIN_REQS table if present
1067: --
1068: for v_AdapterReq in c_GetAdapterAdminReqs loop
1069: RemoveAdapterAdminReq (p_RequestID => v_AdapterReq.request_id);
1070: END LOOP;