APPS.OTA_CPE_UTIL dependencies on OTA_CPE_UTIL

Line 1: PACKAGE BODY OTA_CPE_UTIL as

1: PACKAGE BODY OTA_CPE_UTIL as
2: /* $Header: otcpewrs.pkb 120.40.12010000.8 2008/11/10 09:53:41 pekasi ship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

Line 8: g_package VARCHAR2(33) := 'OTA_CPE_UTIL.'; -- Global package name

4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package VARCHAR2(33) := 'OTA_CPE_UTIL.'; -- Global package name
9:
10: -- ---------------------------------------------------------------------------
11: -- |----------------------< crt_comp_upd_succ_att >-----------------------------|
12: -- ---------------------------------------------------------------------------

Line 60: if ('Y' = ota_cpe_util.is_cert_success_complete(p_cert_prd_enrollment_id => rec.cert_prd_enrollment_id,

56: hr_utility.set_location('Entering:'|| l_proc, 10);
57:
58: for rec in get_crt_prd_enrollments
59: Loop
60: if ('Y' = ota_cpe_util.is_cert_success_complete(p_cert_prd_enrollment_id => rec.cert_prd_enrollment_id,
61: p_cert_period_start_date => rec.cert_period_start_date
62: ,p_cert_period_end_date => rec.cert_period_end_date,
63: p_person_id => p_person_id)) then
64: ota_competence_ss.create_wf_process(p_process =>'OTA_COMPETENCE_UPDATE_JSP_PRC',

Line 306: l_complete_cert_prd_ok := ota_cpe_util.chk_cert_prd_compl(p_cert_prd_enrollment_id => p_cert_prd_enrollment_id);

302: end if;
303:
304: --check for period completion
305: -- verify the period cert enrol eligibility for marking complete
306: l_complete_cert_prd_ok := ota_cpe_util.chk_cert_prd_compl(p_cert_prd_enrollment_id => p_cert_prd_enrollment_id);
307:
308: IF l_complete_cert_prd_ok = 'S' THEN
309: -- The Plan can be completed
310: n_period_status_code := 'COMPLETED';

Line 1788: --//re-populate the prd status by calling ota_cpe_util.update_cpe_status

1784: ,p_cert_period_end_date => l_cert_period_end_date
1785: ,p_completion_date => l_cert_period_completion_date);
1786: end if;
1787: elsif (p_certification_status_code is not null and p_certification_status_code = 'ENROLLED') then
1788: --//re-populate the prd status by calling ota_cpe_util.update_cpe_status
1789: --//which also sets the cre status
1790: --rePopulateCertStatuses(certPrdEnrollmentId);
1791: if l_is_period_update then
1792: update_cpe_status(p_cert_prd_enrollment_id, l_certification_status_code, null, p_cert_period_end_date);

Line 2409: ota_cpe_util.calc_cre_dates(rec_cert_details.cert_enrollment_id,

2405: l_cert_period_end_date := l_cert_period_start_date + rec_cert_details.initial_completion_duration;
2406: l_cert_completion_date := trunc(l_date_status_changed);
2407: l_cert_prd_completion_date := trunc(l_date_status_changed);
2408:
2409: ota_cpe_util.calc_cre_dates(rec_cert_details.cert_enrollment_id,
2410: rec_cert_details.certification_id,
2411: null,
2412: l_earliest_enroll_date,
2413: l_expiration_date,

Line 2482: END OTA_CPE_UTIL;

2478: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error occured in ' || l_proc ||','||SUBSTR(SQLERRM, 1, 500));
2479: end sync_late_subsc_to_class;
2480: --
2481:
2482: END OTA_CPE_UTIL;
2483: