eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OTA_TRNG_PLAN_UTIL_SS dependencies on OTA_ACTIVITY_VERSIONS

Line 209: PROCEDURE chk_valid_act_version_dates (p_activity_version_id IN ota_activity_versions.activity_version_id%TYPE,

205: --
206: -- {End Of Comments}
207: -- ---------------------------------------------------------------------------
208:
209: PROCEDURE chk_valid_act_version_dates (p_activity_version_id IN ota_activity_versions.activity_version_id%TYPE,
210: p_start_date IN ota_activity_versions.start_date%TYPE,
211: p_end_date IN ota_activity_versions.end_date%TYPE DEFAULT NULL);
212:
213: -- ---------------------------------------------------------------------------

Line 210: p_start_date IN ota_activity_versions.start_date%TYPE,

206: -- {End Of Comments}
207: -- ---------------------------------------------------------------------------
208:
209: PROCEDURE chk_valid_act_version_dates (p_activity_version_id IN ota_activity_versions.activity_version_id%TYPE,
210: p_start_date IN ota_activity_versions.start_date%TYPE,
211: p_end_date IN ota_activity_versions.end_date%TYPE DEFAULT NULL);
212:
213: -- ---------------------------------------------------------------------------
214: -- |----------------------< chk_enrollment_exist >--------------------------|

Line 211: p_end_date IN ota_activity_versions.end_date%TYPE DEFAULT NULL);

207: -- ---------------------------------------------------------------------------
208:
209: PROCEDURE chk_valid_act_version_dates (p_activity_version_id IN ota_activity_versions.activity_version_id%TYPE,
210: p_start_date IN ota_activity_versions.start_date%TYPE,
211: p_end_date IN ota_activity_versions.end_date%TYPE DEFAULT NULL);
212:
213: -- ---------------------------------------------------------------------------
214: -- |----------------------< chk_enrollment_exist >--------------------------|
215: -- ---------------------------------------------------------------------------

Line 325: p_activity_version_id IN ota_activity_versions.activity_version_id%TYPE,

321: PROCEDURE modify_tpc_status_on_create(--p_person_id IN ota_training_plans.person_id%TYPE,
322: -- Modified for Bug#3479186
323: p_earliest_start_date IN ota_training_plan_members.earliest_start_date%TYPE,
324: p_target_completion_date IN ota_training_plan_members.target_completion_date%TYPE,
325: p_activity_version_id IN ota_activity_versions.activity_version_id%TYPE,
326: p_training_plan_id IN ota_training_plans.training_plan_id%TYPE,
327: p_member_status_id OUT nocopy VARCHAR2);
328:
329: -- ---------------------------------------------------------------------------

Line 366: p_activity_version_id IN ota_activity_versions.activity_version_id%TYPE,

362: PROCEDURE modify_tpc_status_on_update(--p_person_id IN ota_training_plans.person_id%TYPE,
363: -- Modified for Bug#3479186
364: p_earliest_start_date IN ota_training_plan_members.earliest_start_date%TYPE,
365: p_target_completion_date IN ota_training_plan_members.target_completion_date%TYPE,
366: p_activity_version_id IN ota_activity_versions.activity_version_id%TYPE,
367: p_training_plan_id IN ota_training_plans.training_plan_id%TYPE,
368: p_member_status_id OUT nocopy VARCHAR2);
369:
370: -- ----------------------------------------------------------------------------