APPS.OTA_TRNG_PLAN_UTIL_SS dependencies on OTA_ACTIVITY_VERSIONS

Line 252: (p_activity_version_id IN ota_activity_versions.activity_version_id%TYPE

248: -- ---------------------------------------------------------------------------
249: --
250:
251: PROCEDURE chk_valid_act_version_dates
252: (p_activity_version_id IN ota_activity_versions.activity_version_id%TYPE
253: ,p_start_date IN ota_activity_versions.start_date%TYPE
254: ,p_end_date IN ota_activity_versions.end_date%TYPE)
255:
256: IS

Line 253: ,p_start_date IN ota_activity_versions.start_date%TYPE

249: --
250:
251: PROCEDURE chk_valid_act_version_dates
252: (p_activity_version_id IN ota_activity_versions.activity_version_id%TYPE
253: ,p_start_date IN ota_activity_versions.start_date%TYPE
254: ,p_end_date IN ota_activity_versions.end_date%TYPE)
255:
256: IS
257:

Line 254: ,p_end_date IN ota_activity_versions.end_date%TYPE)

250:
251: PROCEDURE chk_valid_act_version_dates
252: (p_activity_version_id IN ota_activity_versions.activity_version_id%TYPE
253: ,p_start_date IN ota_activity_versions.start_date%TYPE
254: ,p_end_date IN ota_activity_versions.end_date%TYPE)
255:
256: IS
257:
258:

Line 302: ota_activity_versions a,

298: IS
299: CURSOR chk_enr IS
300: SELECT NULL
301: FROM ota_events e,
302: ota_activity_versions a,
303: ota_delegate_bookings b,
304: ota_booking_status_types s,
305: ota_training_plan_members tpm
306: WHERE e.event_id = b.event_id

Line 456: p_activity_version_id IN ota_activity_versions.activity_version_id%TYPE,

452: PROCEDURE modify_tpc_status_on_create(--p_person_id IN ota_training_plans.person_id%TYPE,
453: -- p_contact_id IN ota_training_plans.contact_id%TYPE,
454: p_earliest_start_date IN ota_training_plan_members.earliest_start_date%TYPE,
455: p_target_completion_date IN ota_training_plan_members.target_completion_date%TYPE,
456: p_activity_version_id IN ota_activity_versions.activity_version_id%TYPE,
457: p_training_plan_id IN ota_training_plans.training_plan_id%TYPE,
458: p_member_status_id OUT nocopy VARCHAR2)
459: IS
460:

Line 519: p_activity_version_id IN ota_activity_versions.activity_version_id%TYPE,

515:
516: PROCEDURE modify_tpc_status_on_update(--p_person_id IN ota_training_plans.person_id%TYPE,
517: p_earliest_start_date IN ota_training_plan_members.earliest_start_date%TYPE,
518: p_target_completion_date IN ota_training_plan_members.target_completion_date%TYPE,
519: p_activity_version_id IN ota_activity_versions.activity_version_id%TYPE,
520: p_training_plan_id IN ota_training_plans.training_plan_id%TYPE,
521: p_member_status_id OUT nocopy VARCHAR2)
522: IS
523: