APPS.OTA_TRAINING_RECORD dependencies on OTA_CPE_UTIL

Line 142: ota_cpe_util.get_cre_status(cre.cert_enrollment_id) cert_status_meaning,

138: CURSOR get_certification IS
139: SELECT ctl.name cert_name,
140: cre.certification_id certification_id,
141: cre.certification_status_code certification_status_code,
142: ota_cpe_util.get_cre_status(cre.cert_enrollment_id) cert_status_meaning,
143: cpe.period_status_code period_status_code,
144: cpe_lkp.meaning period_status_meaning,
145: cpe.cert_period_start_date cert_period_start_date,
146: decode(cre.certification_status_code,'CERTIFIED', decode(crt.renewable_flag,'Y',cre.expiration_date,null), cpe.cert_period_end_date) cert_period_end_date,

Line 154: ota_cpe_util.is_period_renewable(cre.cert_enrollment_id) Is_Period_Renewable,

150: cre.cert_enrollment_id,
151: cpe.cert_prd_enrollment_id,
152: cre.is_history_flag,
153: crt.renewable_flag,
154: ota_cpe_util.is_period_renewable(cre.cert_enrollment_id) Is_Period_Renewable,
155: cre.earliest_enroll_date,
156: cpe.expiration_date,
157: crt.start_date_active,
158: crt.end_date_active

Line 226: ota_cpe_util.get_cre_status(cre.cert_enrollment_id) cert_status_meaning,

222: CURSOR get_certification IS
223: select ctl.name cert_name,
224: cre.certification_id certification_id,
225: cre.certification_status_code certification_status_code,
226: ota_cpe_util.get_cre_status(cre.cert_enrollment_id) cert_status_meaning,
227: cpe.period_status_code period_status_code,
228: cpe_lkp.meaning period_status_meaning,
229: cpe.cert_period_start_date cert_period_start_date,
230: decode(cre.certification_status_code,'CERTIFIED', decode(crt.renewable_flag,'Y',cre.expiration_date,null), cpe.cert_period_end_date) cert_period_end_date,

Line 238: ota_cpe_util.is_period_renewable(cre.cert_enrollment_id) Is_Period_Renewable,

234: cre.cert_enrollment_id,
235: cpe.cert_prd_enrollment_id,
236: cre.is_history_flag,
237: crt.renewable_flag,
238: ota_cpe_util.is_period_renewable(cre.cert_enrollment_id) Is_Period_Renewable,
239: cre.earliest_enroll_date,
240: cpe.expiration_date,
241: crt.start_date_active,
242: crt.end_date_active

Line 325: ota_cpe_util.get_cre_status(cre.cert_enrollment_id) cert_status_meaning,

321: CURSOR get_certification IS
322: select ctl.name cert_name,
323: cre.certification_id certification_id,
324: cre.certification_status_code certification_status_code,
325: ota_cpe_util.get_cre_status(cre.cert_enrollment_id) cert_status_meaning,
326: cpe.period_status_code period_status_code,
327: cpe_lkp.meaning period_status_meaning,
328: cpe.cert_period_start_date cert_period_start_date,
329: decode(cre.certification_status_code,'CERTIFIED', decode(crt.renewable_flag,'Y',cre.expiration_date,null), cpe.cert_period_end_date) cert_period_end_date,

Line 337: ota_cpe_util.is_period_renewable(cre.cert_enrollment_id) Is_Period_Renewable,

333: cre.cert_enrollment_id,
334: cpe.cert_prd_enrollment_id,
335: cre.is_history_flag,
336: crt.renewable_flag,
337: ota_cpe_util.is_period_renewable(cre.cert_enrollment_id) Is_Period_Renewable,
338: cre.earliest_enroll_date,
339: cpe.expiration_date,
340: crt.start_date_active,
341: crt.end_date_active