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_REQ_MEMBERS

Line 88: OTA_MAND_MULTI_ENR_REQ_MEMBERS reqm,

84: reqm.completed_competence_prereq completed_competence_prereq,
85: reqm.create_enrollment create_enrollment,
86: reqm.error_message error_message
87: FROM
88: OTA_MAND_MULTI_ENR_REQ_MEMBERS reqm,
89: OTA_MAND_MULTI_ENR_REQUESTS requests,
90: ota_events_tl evt_tl
91: WHERE
92: evt_tl.event_id = reqm.event_id

Line 106: OTA_MAND_MULTI_ENR_REQ_MEMBERS reqm,

102: reqm.person_id person_id,
103: reqm.create_enrollment create_enrollment,
104: reqm.error_message error_message
105: FROM
106: OTA_MAND_MULTI_ENR_REQ_MEMBERS reqm,
107: OTA_MAND_MULTI_ENR_REQUESTS requests,
108: ota_certifications_tl cert_tl
109: WHERE
110: cert_tl.certification_id = reqm.certification_id

Line 195: PROCEDURE create_cert_req_member_record(l_person_id IN OTA_MAND_MULTI_ENR_REQ_MEMBERS.person_id%type,

191: ,p_learner_id IN NUMBER
192: ,l_return_status OUT NOCOPY NUMBER
193: ,l_cert_enr_id OUT NOCOPY NUMBER);
194:
195: PROCEDURE create_cert_req_member_record(l_person_id IN OTA_MAND_MULTI_ENR_REQ_MEMBERS.person_id%type,
196: req_mandatory_enr_request_id IN OTA_MAND_MULTI_ENR_REQ_MEMBERS.mandatory_enr_request_id%type,
197: req_cert_id IN ota_cert_enrollments.certification_id%type,
198: l_numberof_records_processed IN OUT NOCOPY NUMBER,
199: l_create_enrollment IN varchar2 default 'Y',

Line 196: req_mandatory_enr_request_id IN OTA_MAND_MULTI_ENR_REQ_MEMBERS.mandatory_enr_request_id%type,

192: ,l_return_status OUT NOCOPY NUMBER
193: ,l_cert_enr_id OUT NOCOPY NUMBER);
194:
195: PROCEDURE create_cert_req_member_record(l_person_id IN OTA_MAND_MULTI_ENR_REQ_MEMBERS.person_id%type,
196: req_mandatory_enr_request_id IN OTA_MAND_MULTI_ENR_REQ_MEMBERS.mandatory_enr_request_id%type,
197: req_cert_id IN ota_cert_enrollments.certification_id%type,
198: l_numberof_records_processed IN OUT NOCOPY NUMBER,
199: l_create_enrollment IN varchar2 default 'Y',
200: p_person_action_id OUT NOCOPY OTA_MAND_MULTI_ENR_REQ_MEMBERS.PERSON_ACTION_ID%type);

Line 200: p_person_action_id OUT NOCOPY OTA_MAND_MULTI_ENR_REQ_MEMBERS.PERSON_ACTION_ID%type);

196: req_mandatory_enr_request_id IN OTA_MAND_MULTI_ENR_REQ_MEMBERS.mandatory_enr_request_id%type,
197: req_cert_id IN ota_cert_enrollments.certification_id%type,
198: l_numberof_records_processed IN OUT NOCOPY NUMBER,
199: l_create_enrollment IN varchar2 default 'Y',
200: p_person_action_id OUT NOCOPY OTA_MAND_MULTI_ENR_REQ_MEMBERS.PERSON_ACTION_ID%type);
201:
202: FUNCTION learner_is_notSelected_inCert(p_person_id IN per_all_people_f.person_id%type
203: ,p_assignment_id per_all_assignments_f.assignment_id%type
204: ,p_certification_id IN ota_certifications_b.certification_id%type default NULL)