APPS.OTA_CPE_UTIL dependencies on OTA_UTILITY

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

944: RETURN varchar2 is
945:
946: Cursor get_cert_mbr_status is
947: Select member_status_code
948: ,ota_utility.get_lookup_meaning('OTA_CERT_MBR_ENROLL_STATUS', member_status_code, 810) member_status
949: From ota_cert_mbr_enrollments
950: where
951: cert_member_id = p_cert_mbr_id
952: and cert_prd_enrollment_id = p_cert_prd_enrollment_id;

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

1003: Cursor csr_cre_status is
1004: Select cre.certification_status_code,
1005: cre.completion_date,
1006: crt.validity_duration,
1007: ota_utility.get_lookup_meaning('OTA_CERT_ENROLL_STATUS', cre.certification_status_code, 810) cre_status,
1008: crt.renewable_flag,
1009: cre.expiration_date,
1010: nvl(crt.end_date_active,to_date('4712/12/31','YYYY/MM/DD')) end_date_active
1011: From ota_cert_enrollments cre,

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

1035: or rec_cre_status.certification_status_code = 'CANCELLED')) then
1036: --l_old_exp_date := rec_cre_status.completion_date + rec_cre_status.validity_duration;
1037: -- this could happen only for certs whose reenrl type is immed after compl.
1038: if (l_curr_date > rec_cre_status.expiration_date) then --
1039: l_cre_status := ota_utility.get_lookup_meaning('OTA_CERT_ENROLL_STATUS', 'EXPIRED', 810);
1040: l_cre_status_code := 'EXPIRED';
1041: --return l_cre_status;
1042: else
1043: --return rec_cre_status.cre_status;

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

1055: l_cre_status_code := rec_cre_status.certification_status_code;
1056: end if;
1057: else
1058: --concluded
1059: l_cre_status := ota_utility.get_lookup_meaning('OTA_CERT_ENROLL_STATUS', 'CONCLUDED', 810);
1060: l_cre_status_code := 'CONCLUDED';
1061:
1062: end if;
1063:

Line 1366: ota_utility.Get_Default_Value_Dff(

1362: elsif (l_cert_rec.initial_completion_duration is not null) then
1363: l_period_end_date := trunc(sysdate) + l_cert_rec.initial_completion_duration - 1;
1364: end if;
1365: */
1366: ota_utility.Get_Default_Value_Dff(
1367: appl_short_name => 'OTA'
1368: ,flex_field_name => 'OTA_CERT_PRD_ENROLLMENTS'
1369: ,p_attribute_category => l_attribute_category
1370: ,p_attribute1 => l_attribute1

Line 1446: ota_utility.Get_Default_Value_Dff(

1442: l_attribute18 := NULL;
1443: l_attribute19 := NULL;
1444: l_attribute20 := NULL;
1445:
1446: ota_utility.Get_Default_Value_Dff(
1447: appl_short_name => 'OTA'
1448: ,flex_field_name => 'OTA_CERT_MBR_ENROLLMENTS'
1449: ,p_attribute_category => l_attribute_category
1450: ,p_attribute1 => l_attribute1

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

2096: RETURN varchar2 is
2097:
2098: Cursor csr_latest_cpe is
2099: Select cpe.period_status_code Period_Status_Code,
2100: ota_utility.get_lookup_meaning('OTA_CERT_PRD_ENROLL_STATUS', cpe.period_status_code, 810) Period_Status_Meaning,
2101: cpe.cert_prd_enrollment_id
2102: From ota_cert_prd_enrollments cpe
2103: where cpe.cert_enrollment_id = p_cert_enrollment_id
2104: -- and rownum = 1 --Bug#6356854