[Home] [Help]
24: );
25:
26: l_rec mandatory_event_assoc_rec;
27: l_date ota_events.course_end_date%type;
28: l_conc_request_id ota_mandatory_enr_requests.conc_program_request_id%type;
29: l_event_title ota_events_tl.title%type;
30: l_proc varchar2(72) := g_package||'process_mandatory_event_assoc';
31:
32:
77: ORDER BY evt.event_id;
78:
79: FORALL i IN 1 .. l_rec.event_id.COUNT
80:
81: INSERT INTO ota_mandatory_enr_requests(
82: MANDATORY_ENR_REQUEST_ID ,
83: REQUESTOR_ID,
84: EVENT_ID,
85: ENR_PREREQ_TYPE,
90: POSITION_ID,
91: USERGROUP_ID,
92: CONC_PROGRAM_REQUEST_ID,
93: CREATION_DATE)
94: VALUES(OTA_MANDATORY_ENR_REQUESTS_S.NEXTVAL,
95: l_rec.requestor_id(i),
96: l_rec.event_id(i),
97: l_rec.enr_prereq_type(i),
98: l_rec.person_id(i),
1729: reqmembers.ORGANIZATION_ID,
1730: reqmembers.BUSINESS_GROUP_ID
1731: FROM
1732: ota_mandatory_enr_req_members reqmembers,
1733: ota_mandatory_enr_requests requests
1734: WHERE
1735: requests.conc_program_request_id = l_conc_reqId
1736: AND requests.mandatory_enr_request_id = reqmembers.mandatory_enr_request_id
1737: AND reqmembers.create_enrollment = 'Y'
2131: IS
2132:
2133: CURSOR csr_get_all_event_owners IS
2134: SELECT distinct event_id,requestor_id
2135: from ota_mandatory_enr_requests
2136: where requestor_id IS NOT NULL
2137: and conc_program_request_id = p_conc_reqId ;
2138:
2139: CURSOR csr_get_error_learners(p_event_id IN number) IS
2306:
2307:
2308:
2309: FOR i IN 1 .. l_rec.certification_id.COUNT LOOP
2310: --FND_FILE.PUT_LINE(FND_FILE.LOG,'Inserting into ota_mandatory_enr_requests');
2311:
2312: INSERT INTO OTA_MAND_MULTI_ENR_REQUESTS(
2313: MANDATORY_ENR_REQUEST_ID ,
2314: REQUESTOR_ID,