eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OTA_MANDATORY_ENROLL_UTIL dependencies on OTA_MAND_MULTI_ENR_REQUESTS

Line 147: l_conc_request_id OTA_MAND_MULTI_ENR_REQUESTS.conc_program_request_id%type;

143: and fcr.REQUEST_ID <> c_conc_req_id;
144:
145: l_rec mandatory_event_assoc_rec;
146: l_date ota_events.course_end_date%type;
147: l_conc_request_id OTA_MAND_MULTI_ENR_REQUESTS.conc_program_request_id%type;
148: l_event_title ota_events_tl.title%type;
149: l_request_id number;
150: l_person_name per_all_people_f.full_name%type;
151: l_mand_multi_conc_exist number;

Line 226: INSERT INTO OTA_MAND_MULTI_ENR_REQUESTS(

222: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_rec.event_id.COUNT:'||l_rec.event_id.COUNT);
223:
224: FORALL i IN 1 .. l_rec.event_id.COUNT
225:
226: INSERT INTO OTA_MAND_MULTI_ENR_REQUESTS(
227: MANDATORY_ENR_REQUEST_ID ,
228: REQUESTOR_ID,
229: EVENT_ID,
230: ENR_PREREQ_TYPE,

Line 238: VALUES(OTA_MAND_MULTI_ENR_REQUESTS_S.NEXTVAL,

234: JOB_ID,
235: POSITION_ID,
236: USERGROUP_ID,
237: CONC_PROGRAM_REQUEST_ID)
238: VALUES(OTA_MAND_MULTI_ENR_REQUESTS_S.NEXTVAL,
239: l_rec.requestor_id(i),
240: l_rec.event_id(i),
241: l_rec.enr_prereq_type(i),
242: l_rec.person_id(i),

Line 2181: from OTA_MAND_MULTI_ENR_REQUESTS

2177: IS
2178:
2179: CURSOR csr_get_all_event_owners IS
2180: SELECT distinct event_id,requestor_id
2181: from OTA_MAND_MULTI_ENR_REQUESTS
2182: where requestor_id IS NOT NULL
2183: and conc_program_request_id = p_conc_reqId ;
2184:
2185: CURSOR csr_get_error_learners(p_event_id IN number) IS

Line 2245: l_conc_request_id OTA_MAND_MULTI_ENR_REQUESTS.conc_program_request_id%type;

2241: );
2242:
2243: l_rec auto_cert_subscr_rec;
2244: l_date ota_events.course_end_date%type;
2245: l_conc_request_id OTA_MAND_MULTI_ENR_REQUESTS.conc_program_request_id%type;
2246: l_cert_name ota_certifications_tl.name%type;
2247: l_chunk_size number := nvl(p_chunk_size,1000);
2248: l_threads number := nvl(p_thread_count,3);
2249: l_request_id number;

Line 2312: INSERT INTO OTA_MAND_MULTI_ENR_REQUESTS(

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,
2315: EVENT_ID,
2316: ENR_PREREQ_TYPE,

Line 2325: VALUES(OTA_MAND_MULTI_ENR_REQUESTS_S.NEXTVAL,

2321: POSITION_ID,
2322: USERGROUP_ID,
2323: CONC_PROGRAM_REQUEST_ID,
2324: CERTIFICATION_ID)
2325: VALUES(OTA_MAND_MULTI_ENR_REQUESTS_S.NEXTVAL,
2326: l_rec.requestor_id(i),
2327: NULL,
2328: 'N',
2329: l_rec.person_id(i),

Line 2554: --FND_FILE.PUT_LINE(FND_FILE.LOG,'Looping through OTA_MAND_MULTI_ENR_REQUESTS');

2550: FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name Certification ');
2551: FND_FILE.PUT_LINE(FND_FILE.LOG,'-----------------------------------------------------------');
2552:
2553: FOR request IN get_all_mand_multi_enr_reqs(p_conc_request_id) LOOP
2554: --FND_FILE.PUT_LINE(FND_FILE.LOG,'Looping through OTA_MAND_MULTI_ENR_REQUESTS');
2555: l_cert_status_code :=0;
2556: l_cert_enrollment_id :=0;
2557:
2558: IF request.usergroup_id IS NULL THEN

Line 3109: --OTA_MAND_MULTI_ENR_REQUESTS requests

3105: reqmembers.CERTIFICATION_ID,
3106: reqmembers.CREATE_ENROLLMENT
3107: FROM
3108: OTA_MAND_MULTI_ENR_REQ_MEMBERS reqmembers--,
3109: --OTA_MAND_MULTI_ENR_REQUESTS requests
3110: WHERE
3111: -- requests.conc_program_request_id = l_conc_reqId
3112: -- AND requests.mandatory_enr_request_id = reqmembers.mandatory_enr_request_id
3113: -- AND

Line 3308: TYPE mand_rec IS RECORD (conc_req_id OTA_MAND_MULTI_ENR_REQUESTS.CONC_PROGRAM_REQUEST_ID%TYPE

3304:
3305: Procedure purge_mand_enroll_data(ERRBUF OUT NOCOPY VARCHAR2,
3306: RETCODE OUT NOCOPY VARCHAR2) is
3307:
3308: TYPE mand_rec IS RECORD (conc_req_id OTA_MAND_MULTI_ENR_REQUESTS.CONC_PROGRAM_REQUEST_ID%TYPE
3309: ,mandatory_enr_req_id OTA_MAND_MULTI_ENR_REQUESTS.MANDATORY_ENR_REQUEST_ID%TYPE);
3310:
3311: TYPE t_mand_rec IS TABLE OF mand_rec INDEX BY binary_integer;
3312: mand_enr_req_rec t_mand_rec;

Line 3309: ,mandatory_enr_req_id OTA_MAND_MULTI_ENR_REQUESTS.MANDATORY_ENR_REQUEST_ID%TYPE);

3305: Procedure purge_mand_enroll_data(ERRBUF OUT NOCOPY VARCHAR2,
3306: RETCODE OUT NOCOPY VARCHAR2) is
3307:
3308: TYPE mand_rec IS RECORD (conc_req_id OTA_MAND_MULTI_ENR_REQUESTS.CONC_PROGRAM_REQUEST_ID%TYPE
3309: ,mandatory_enr_req_id OTA_MAND_MULTI_ENR_REQUESTS.MANDATORY_ENR_REQUEST_ID%TYPE);
3310:
3311: TYPE t_mand_rec IS TABLE OF mand_rec INDEX BY binary_integer;
3312: mand_enr_req_rec t_mand_rec;
3313: l_proc varchar2(80) := g_package||'.purge_mand_enroll_data';

Line 3319: from OTA_MAND_MULTI_ENR_REQUESTS omr, fnd_concurrent_requests fcr

3315: hr_utility.set_location ('Entering '||l_proc,5);
3316: dbms_lock.sleep(5);
3317: select omr.CONC_PROGRAM_REQUEST_ID, omr.MANDATORY_ENR_REQUEST_ID
3318: bulk collect into mand_enr_req_rec
3319: from OTA_MAND_MULTI_ENR_REQUESTS omr, fnd_concurrent_requests fcr
3320: where fcr.REQUEST_ID (+) = omr.CONC_PROGRAM_REQUEST_ID
3321: and nvl(fcr.STATUS_CODE,'C') in ('C','E');
3322:
3323: if mand_enr_req_rec.count <= 0 then

Line 3344: delete from ota_mand_multi_enr_requests

3340: if sql%rowcount > 0 then
3341: commit;
3342: end if;
3343:
3344: delete from ota_mand_multi_enr_requests
3345: where mandatory_enr_request_id = mand_enr_req_rec(l_conc_req).mandatory_enr_req_id;
3346:
3347: end loop;
3348: