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_TRAINING_PLAN_MEMBERS

Line 112: p_training_plan_member_id IN ota_training_plan_members.training_plan_member_id%TYPE)

108:
109: FUNCTION get_enroll_status(p_person_id IN ota_training_plans.person_id%TYPE,
110: -- Modified for Bug#3479186
111: p_contact_id IN ota_training_plans.contact_id%TYPE,
112: p_training_plan_member_id IN ota_training_plan_members.training_plan_member_id%TYPE)
113: RETURN VARCHAR2;
114:
115: -- ---------------------------------------------------------------------------
116: -- |----------------------< chk_login_person >--------------------------|

Line 175: p_earliest_start_date IN ota_training_plan_members.earliest_start_date%TYPE,

171: -- {End Of Comments}
172: -- ---------------------------------------------------------------------------
173:
174: FUNCTION chk_src_func_tlntmgt(p_person_id IN ota_training_plans.person_id%TYPE,
175: p_earliest_start_date IN ota_training_plan_members.earliest_start_date%TYPE,
176: p_target_completion_date IN ota_training_plan_members.target_completion_date%TYPE,
177: --Added for Bug#3108246
178: p_business_group_id IN number)
179: RETURN number ;

Line 176: p_target_completion_date IN ota_training_plan_members.target_completion_date%TYPE,

172: -- ---------------------------------------------------------------------------
173:
174: FUNCTION chk_src_func_tlntmgt(p_person_id IN ota_training_plans.person_id%TYPE,
175: p_earliest_start_date IN ota_training_plan_members.earliest_start_date%TYPE,
176: p_target_completion_date IN ota_training_plan_members.target_completion_date%TYPE,
177: --Added for Bug#3108246
178: p_business_group_id IN number)
179: RETURN number ;
180:

Line 242: p_training_plan_member_id IN ota_training_plan_members.training_plan_member_id%TYPE)

238: -- ---------------------------------------------------------------------------
239: FUNCTION chk_enrollment_exist ( p_person_id IN ota_training_plans.person_id%TYPE,
240: -- Modified for Bug#3479186
241: p_contact_id IN ota_training_plans.contact_id%TYPE,
242: p_training_plan_member_id IN ota_training_plan_members.training_plan_member_id%TYPE)
243: RETURN boolean;
244:
245: -- ---------------------------------------------------------------------------
246: -- |----------------------< get_enroll_status >--------------------------|

Line 281: p_earliest_start_date IN ota_training_plan_members.earliest_start_date%TYPE,

277:
278: FUNCTION get_enroll_status(p_person_id IN ota_training_plans.person_id%TYPE,
279: -- Modified for Bug#3479186
280: p_contact_id IN ota_training_plans.contact_id%TYPE,
281: p_earliest_start_date IN ota_training_plan_members.earliest_start_date%TYPE,
282: p_target_completion_date IN ota_training_plan_members.target_completion_date%TYPE,
283: p_activity_version_id IN ota_training_plan_members.activity_version_id%TYPE,
284: p_training_plan_id IN ota_training_plans.training_plan_id%TYPE,
285: p_action IN VARCHAR2)

Line 282: p_target_completion_date IN ota_training_plan_members.target_completion_date%TYPE,

278: FUNCTION get_enroll_status(p_person_id IN ota_training_plans.person_id%TYPE,
279: -- Modified for Bug#3479186
280: p_contact_id IN ota_training_plans.contact_id%TYPE,
281: p_earliest_start_date IN ota_training_plan_members.earliest_start_date%TYPE,
282: p_target_completion_date IN ota_training_plan_members.target_completion_date%TYPE,
283: p_activity_version_id IN ota_training_plan_members.activity_version_id%TYPE,
284: p_training_plan_id IN ota_training_plans.training_plan_id%TYPE,
285: p_action IN VARCHAR2)
286: RETURN varchar2 ;

Line 283: p_activity_version_id IN ota_training_plan_members.activity_version_id%TYPE,

279: -- Modified for Bug#3479186
280: p_contact_id IN ota_training_plans.contact_id%TYPE,
281: p_earliest_start_date IN ota_training_plan_members.earliest_start_date%TYPE,
282: p_target_completion_date IN ota_training_plan_members.target_completion_date%TYPE,
283: p_activity_version_id IN ota_training_plan_members.activity_version_id%TYPE,
284: p_training_plan_id IN ota_training_plans.training_plan_id%TYPE,
285: p_action IN VARCHAR2)
286: RETURN varchar2 ;
287:

Line 323: p_earliest_start_date IN ota_training_plan_members.earliest_start_date%TYPE,

319: -- ---------------------------------------------------------------------------
320:
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);

Line 324: p_target_completion_date IN ota_training_plan_members.target_completion_date%TYPE,

320:
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:

Line 364: p_earliest_start_date IN ota_training_plan_members.earliest_start_date%TYPE,

360: -- ---------------------------------------------------------------------------
361:
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);

Line 365: p_target_completion_date IN ota_training_plan_members.target_completion_date%TYPE,

361:
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:

Line 411: ,p_training_plan_member_id IN ota_training_plan_members.training_plan_member_id%TYPE

407:
408: PROCEDURE get_valid_enroll(p_person_id IN ota_training_plans.person_id%TYPE
409: -- Modified for Bug#3479186
410: ,p_contact_id IN ota_training_plans.contact_id%TYPE
411: ,p_training_plan_member_id IN ota_training_plan_members.training_plan_member_id%TYPE
412: ,p_return_status OUT nocopy varchar2);
413:
414:
415: -- ---------------------------------------------------------------------------