60: FROM fnd_svc_comp_requests
61: WHERE component_request_id = p_component_request_id;
62:
63: --
64: -- Delete DBMS_JOB
65: --
66: DBMS_Job.Remove(
67: job => l_job_id);
68:
62:
63: --
64: -- Delete DBMS_JOB
65: --
66: DBMS_Job.Remove(
67: job => l_job_id);
68:
69: --
70: -- Delete the request
101:
102: BEGIN
103:
104: --
105: -- NOTE: This is in PL/SQL because it is called by DBMS_JOB
106: --
107:
108: --
109: -- Retrieve request details