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.51.12020000.6 2013/01/18 09:30:53 jaysridh 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 307: l_complete_cert_prd_ok := ota_cpe_util.chk_cert_prd_compl(p_cert_prd_enrollment_id => p_cert_prd_enrollment_id);

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

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

1822: p_certification_id => l_cert_enrl_rec.certification_id ,
1823: p_itemkey =>l_item_key);
1824: end if;
1825: elsif (p_certification_status_code is not null and p_certification_status_code = 'ENROLLED') then
1826: --//re-populate the prd status by calling ota_cpe_util.update_cpe_status
1827: --//which also sets the cre status
1828: --rePopulateCertStatuses(certPrdEnrollmentId);
1829: if l_is_period_update then
1830: update_cpe_status(p_cert_prd_enrollment_id, l_certification_status_code, null, p_cert_period_end_date);

Line 2448: ota_cpe_util.calc_cre_dates(rec_cert_details.cert_enrollment_id,

2444: l_cert_period_end_date := l_cert_period_start_date + rec_cert_details.initial_completion_duration;
2445: l_cert_completion_date := trunc(l_date_status_changed);
2446: l_cert_prd_completion_date := trunc(l_date_status_changed);
2447:
2448: ota_cpe_util.calc_cre_dates(rec_cert_details.cert_enrollment_id,
2449: rec_cert_details.certification_id,
2450: null,
2451: l_earliest_enroll_date,
2452: l_expiration_date,

Line 2521: END OTA_CPE_UTIL;

2517: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error occured in ' || l_proc ||','||SUBSTR(SQLERRM, 1, 500));
2518: end sync_late_subsc_to_class;
2519: --
2520:
2521: END OTA_CPE_UTIL;
2522: