APPS.OTA_CPE_UTIL dependencies on OTA_UTILITY

Line 940: ,ota_utility.get_lookup_meaning('OTA_CERT_MBR_ENROLL_STATUS', member_status_code, 810) member_status

936: RETURN varchar2 is
937:
938: Cursor get_cert_mbr_status is
939: Select member_status_code
940: ,ota_utility.get_lookup_meaning('OTA_CERT_MBR_ENROLL_STATUS', member_status_code, 810) member_status
941: From ota_cert_mbr_enrollments
942: where
943: cert_member_id = p_cert_mbr_id
944: and cert_prd_enrollment_id = p_cert_prd_enrollment_id;

Line 999: ota_utility.get_lookup_meaning('OTA_CERT_ENROLL_STATUS', cre.certification_status_code, 810) cre_status,

995: Cursor csr_cre_status is
996: Select cre.certification_status_code,
997: cre.completion_date,
998: crt.validity_duration,
999: ota_utility.get_lookup_meaning('OTA_CERT_ENROLL_STATUS', cre.certification_status_code, 810) cre_status,
1000: crt.renewable_flag,
1001: cre.expiration_date,
1002: nvl(crt.end_date_active,to_date('4712/12/31','YYYY/MM/DD')) end_date_active
1003: From ota_cert_enrollments cre,

Line 1031: l_cre_status := ota_utility.get_lookup_meaning('OTA_CERT_ENROLL_STATUS', 'EXPIRED', 810);

1027: or rec_cre_status.certification_status_code = 'CANCELLED')) then
1028: --l_old_exp_date := rec_cre_status.completion_date + rec_cre_status.validity_duration;
1029: -- this could happen only for certs whose reenrl type is immed after compl.
1030: if (l_curr_date > rec_cre_status.expiration_date) then --
1031: l_cre_status := ota_utility.get_lookup_meaning('OTA_CERT_ENROLL_STATUS', 'EXPIRED', 810);
1032: l_cre_status_code := 'EXPIRED';
1033: --return l_cre_status;
1034: else
1035: --return rec_cre_status.cre_status;

Line 1051: l_cre_status := ota_utility.get_lookup_meaning('OTA_CERT_ENROLL_STATUS', 'CONCLUDED', 810);

1047: l_cre_status_code := rec_cre_status.certification_status_code;
1048: end if;
1049: else
1050: --concluded
1051: l_cre_status := ota_utility.get_lookup_meaning('OTA_CERT_ENROLL_STATUS', 'CONCLUDED', 810);
1052: l_cre_status_code := 'CONCLUDED';
1053:
1054: end if;
1055:

Line 1355: ota_utility.Get_Default_Value_Dff(

1351: elsif (l_cert_rec.initial_completion_duration is not null) then
1352: l_period_end_date := trunc(sysdate) + l_cert_rec.initial_completion_duration - 1;
1353: end if;
1354: */
1355: ota_utility.Get_Default_Value_Dff(
1356: appl_short_name => 'OTA'
1357: ,flex_field_name => 'OTA_CERT_PRD_ENROLLMENTS'
1358: ,p_attribute_category => l_attribute_category
1359: ,p_attribute1 => l_attribute1

Line 1435: ota_utility.Get_Default_Value_Dff(

1431: l_attribute18 := NULL;
1432: l_attribute19 := NULL;
1433: l_attribute20 := NULL;
1434:
1435: ota_utility.Get_Default_Value_Dff(
1436: appl_short_name => 'OTA'
1437: ,flex_field_name => 'OTA_CERT_MBR_ENROLLMENTS'
1438: ,p_attribute_category => l_attribute_category
1439: ,p_attribute1 => l_attribute1

Line 2061: ota_utility.get_lookup_meaning('OTA_CERT_PRD_ENROLL_STATUS', cpe.period_status_code, 810) Period_Status_Meaning,

2057: RETURN varchar2 is
2058:
2059: Cursor csr_latest_cpe is
2060: Select cpe.period_status_code Period_Status_Code,
2061: ota_utility.get_lookup_meaning('OTA_CERT_PRD_ENROLL_STATUS', cpe.period_status_code, 810) Period_Status_Meaning,
2062: cpe.cert_prd_enrollment_id
2063: From ota_cert_prd_enrollments cpe
2064: where cpe.cert_enrollment_id = p_cert_enrollment_id
2065: -- and rownum = 1 --Bug#6356854