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 1193: l_blk_enr_request_id OTA_BULK_ENR_REQUESTS.BULK_ENR_REQUEST_ID%TYPE;

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

Line 1204: DELETE FROM OTA_BULK_ENR_REQUESTS

1200:
1201: DELETE FROM OTA_BULK_ENR_REQ_MEMBERS
1202: WHERE BULK_ENR_REQUEST_ID = l_blk_enr_request_id;
1203:
1204: DELETE FROM OTA_BULK_ENR_REQUESTS
1205: WHERE BULK_ENR_REQUEST_ID = l_blk_enr_request_id;
1206:
1207: COMMIT;
1208:

Line 1704: ota_bulk_enr_requests ber,

1700: CURSOR csr_lp_created_now(l_person_id in NUMBER,l_lp_id in NUMBER,l_conc_req_id in NUMBER) IS
1701: SELECT
1702: berm.bulk_enr_request_id
1703: from
1704: ota_bulk_enr_requests ber,
1705: ota_bulk_enr_req_members berm
1706: where berm.bulk_enr_request_id = ber.bulk_enr_request_id
1707: AND ber.conc_program_request_id = l_conc_req_id
1708: AND ber.object_id = l_lp_id

Line 1749: l_parent_object_type ota_bulk_enr_requests.object_type%TYPE;

1745: l_subscribed_now boolean;
1746: lp_created_in_this_concreq_rec csr_lp_created_now%ROWTYPE;
1747: lp_mem_enr_to_upd_rec csr_get_lp_member_to_upd%ROWTYPE;
1748:
1749: l_parent_object_type ota_bulk_enr_requests.object_type%TYPE;
1750:
1751: l_existing_booking_id ota_delegate_bookings.booking_id%TYPE;
1752: l_lp_name varchar2(80);
1753: l_class_name varchar2(80);

Line 1986: UPDATE ota_bulk_enr_requests ber

1982: -- Raise error submitting concurrent program
1983: null;
1984: END IF;
1985: END IF;
1986: UPDATE ota_bulk_enr_requests ber
1987: SET CONC_PROGRAM_REQUEST_ID = p_conc_request_id
1988: WHERE bulk_enr_request_id = p_enr_request_id;
1989:
1990: p_object_type := ota_utility.get_lookup_meaning(

Line 2007: UPDATE ota_bulk_enr_requests ber

2003: , program => 'OTBLKENR'
2004: , argument1 => p_enr_request_id
2005: , argument2 => p_enr_request_id_end);
2006:
2007: UPDATE ota_bulk_enr_requests ber
2008: SET CONC_PROGRAM_REQUEST_ID = p_conc_request_id
2009: WHERE bulk_enr_request_id between p_enr_request_id and p_enr_request_id_end;
2010:
2011: p_object_type := ota_utility.get_lookup_meaning(

Line 2363: UPDATE ota_bulk_enr_requests ber

2359: IF p_conc_request_id = 0 THEN
2360: -- Raise error submitting concurrent program
2361: null;
2362: END IF;
2363: UPDATE ota_bulk_enr_requests ber
2364: SET CONC_PROGRAM_REQUEST_ID = p_conc_request_id
2365: WHERE bulk_enr_request_id = p_enr_request_id;
2366:
2367: