DBA Data[Home] [Help]

APPS.OTA_TRAINING_PLAN_UPGRADE dependencies on HR_API

Line 1693: if talent_mgmt_rec.end_date = hr_api.g_eot then

1689: l_learning_path_id := null;
1690: l_learning_path_section_id := null;
1691: l_lp_enrollment_id := null;
1692:
1693: if talent_mgmt_rec.end_date = hr_api.g_eot then
1694: l_end_date := null;
1695: else
1696: l_end_date := talent_mgmt_rec.end_date;
1697: end if;

Line 2009: if tp_rec.end_date = hr_api.g_eot then

2005: FOR tp_rec IN csr_get_tp LOOP
2006: l_lp_enrollment_id := null;
2007: l_max_date_status_changed := null;
2008: --completion_target_date := tp_rec.end_date; (if tp_rec.end_date is 31-Dec-4712 then completion_target_date is set to null)
2009: if tp_rec.end_date = hr_api.g_eot then
2010: l_end_date := null;
2011: else
2012: l_end_date := tp_rec.end_date;
2013: end if;

Line 2064: if tpm_rec.target_completion_date = hr_api.g_eot then

2060: ,p_attribute30 => tp_rec.attribute30);
2061:
2062: FOR tpm_rec IN csr_get_tpm(tp_rec.training_plan_id) LOOP
2063: l_lp_member_enrollment_id := null;
2064: if tpm_rec.target_completion_date = hr_api.g_eot then
2065: l_target_completion_date := null;
2066: else
2067: l_target_completion_date := tpm_rec.target_completion_date;
2068: end if;