APPS.OTA_BULK_ENROLL_UTIL dependencies on OTA_BULK_ENR_REQUESTS

Line 222: ota_bulk_enr_requests ber,

218: IS
219: CURSOR get_unfulfil_crs_prereq IS
220: SELECT count(person_id)
221: FROM ota_bulk_enr_req_members brm,
222: ota_bulk_enr_requests ber,
223: ota_events evt
224: WHERE ber.bulk_enr_request_id = brm.bulk_enr_request_id
225: AND ber.bulk_enr_request_id = p_bulk_enr_request_id
226: AND evt.event_id = ber.object_id

Line 237: ota_bulk_enr_requests ber,

233:
234: CURSOR get_unfulfil_comp_prereqs IS
235: SELECT count(person_id)
236: FROM ota_bulk_enr_req_members brm,
237: ota_bulk_enr_requests ber,
238: ota_events evt
239: WHERE ber.bulk_enr_request_id = brm.bulk_enr_request_id
240: AND ber.bulk_enr_request_id = p_bulk_enr_request_id
241: AND evt.event_id = ber.object_id

Line 1190: l_blk_enr_request_id OTA_BULK_ENR_REQUESTS.BULK_ENR_REQUEST_ID%TYPE;

1186: ,actid IN NUMBER
1187: ,funcmode IN VARCHAR2
1188: ,resultout OUT nocopy VARCHAR2 ) AS
1189:
1190: l_blk_enr_request_id OTA_BULK_ENR_REQUESTS.BULK_ENR_REQUEST_ID%TYPE;
1191: BEGIN
1192: IF (funcmode='RUN') THEN
1193: l_blk_enr_request_id := WF_ENGINE.getitemattrtext(itemtype => itemtype,
1194: itemkey => itemkey,

Line 1201: DELETE FROM OTA_BULK_ENR_REQUESTS

1197:
1198: DELETE FROM OTA_BULK_ENR_REQ_MEMBERS
1199: WHERE BULK_ENR_REQUEST_ID = l_blk_enr_request_id;
1200:
1201: DELETE FROM OTA_BULK_ENR_REQUESTS
1202: WHERE BULK_ENR_REQUEST_ID = l_blk_enr_request_id;
1203:
1204: COMMIT;
1205:

Line 1695: UPDATE ota_bulk_enr_requests ber

1691: -- Raise error submitting concurrent program
1692: null;
1693: END IF;
1694: END IF;
1695: UPDATE ota_bulk_enr_requests ber
1696: SET CONC_PROGRAM_REQUEST_ID = p_conc_request_id
1697: WHERE bulk_enr_request_id = p_enr_request_id;
1698:
1699: p_object_type := ota_utility.get_lookup_meaning(