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_PLANS

Line 64: FUNCTION is_personal_trng_plan ( p_training_plan_id IN ota_training_plans.training_plan_id%TYPE)

60: --
61: -- {End Of Comments}
62: -- ---------------------------------------------------------------------------
63:
64: FUNCTION is_personal_trng_plan ( p_training_plan_id IN ota_training_plans.training_plan_id%TYPE)
65: RETURN BOOLEAN;
66:
67: -- ---------------------------------------------------------------------------
68: -- |----------------------< chk_cancel_plan_ok >--------------------------|

Line 71: Function chk_cancel_plan_ok(p_training_plan_id in ota_training_plans.training_plan_id%type)

67: -- ---------------------------------------------------------------------------
68: -- |----------------------< chk_cancel_plan_ok >--------------------------|
69: -- ---------------------------------------------------------------------------
70: --
71: Function chk_cancel_plan_ok(p_training_plan_id in ota_training_plans.training_plan_id%type)
72: return varchar2;
73: -- ---------------------------------------------------------------------------
74: -- |----------------------< chk_complete_plan_ok >--------------------------|
75: -- ---------------------------------------------------------------------------

Line 78: Function chk_complete_plan_ok(p_training_plan_id in ota_training_plans.training_plan_id%type)

74: -- |----------------------< chk_complete_plan_ok >--------------------------|
75: -- ---------------------------------------------------------------------------
76: --
77:
78: Function chk_complete_plan_ok(p_training_plan_id in ota_training_plans.training_plan_id%type)
79: return varchar2;
80: -- ---------------------------------------------------------------------------
81: -- |----------------------< get_enroll_status >--------------------------|
82: -- ---------------------------------------------------------------------------

Line 109: FUNCTION get_enroll_status(p_person_id IN ota_training_plans.person_id%TYPE,

105: -- {End Of Comments}
106: -- ---------------------------------------------------------------------------
107:
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;

Line 111: p_contact_id IN ota_training_plans.contact_id%TYPE,

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

Line 142: FUNCTION chk_login_person ( p_training_plan_id IN ota_training_plans.training_plan_id%TYPE)

138: --
139: -- {End Of Comments}
140: -- ---------------------------------------------------------------------------
141:
142: FUNCTION chk_login_person ( p_training_plan_id IN ota_training_plans.training_plan_id%TYPE)
143: RETURN VARCHAR2;
144:
145: -- ---------------------------------------------------------------------------
146: -- |----------------------< chk_src_func_tlntmgt >--------------------------|

Line 174: FUNCTION chk_src_func_tlntmgt(p_person_id IN ota_training_plans.person_id%TYPE,

170: --
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)

Line 239: FUNCTION chk_enrollment_exist ( p_person_id IN ota_training_plans.person_id%TYPE,

235: -- Internal Development Use Only.
236: --
237: -- {End Of Comments}
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;

Line 241: p_contact_id IN ota_training_plans.contact_id%TYPE,

237: -- {End Of Comments}
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: -- ---------------------------------------------------------------------------

Line 278: FUNCTION get_enroll_status(p_person_id IN ota_training_plans.person_id%TYPE,

274: --
275: -- {End Of Comments}
276: -- ---------------------------------------------------------------------------
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,

Line 280: p_contact_id IN ota_training_plans.contact_id%TYPE,

276: -- ---------------------------------------------------------------------------
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,

Line 284: p_training_plan_id IN ota_training_plans.training_plan_id%TYPE,

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

Line 321: PROCEDURE modify_tpc_status_on_create(--p_person_id IN ota_training_plans.person_id%TYPE,

317: --
318: -- {End Of Comments}
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,

Line 326: p_training_plan_id IN ota_training_plans.training_plan_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: -- ---------------------------------------------------------------------------
330: -- |----------------------< modify_tpc_status_on_update >--------------------------|

Line 362: PROCEDURE modify_tpc_status_on_update(--p_person_id IN ota_training_plans.person_id%TYPE,

358: --
359: -- {End Of Comments}
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,

Line 367: p_training_plan_id IN ota_training_plans.training_plan_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: -- ----------------------------------------------------------------------------
371: -- |---------------------------------------------------------------|

Line 400: FUNCTION get_person_id(p_training_plan_id IN ota_training_plans.training_plan_id%TYPE)

396: --
397: -- {End Of Comments}
398: -- ----------------------------------------------------------------------------
399:
400: FUNCTION get_person_id(p_training_plan_id IN ota_training_plans.training_plan_id%TYPE)
401: RETURN number;
402:
403: -- ----------------------------------------------------------------------------
404:

Line 408: PROCEDURE get_valid_enroll(p_person_id IN ota_training_plans.person_id%TYPE

404:
405: -- ---------------------------< get_valid_enroll >-----------------------------
406: -- ----------------------------------------------------------------------------
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);

Line 410: ,p_contact_id IN ota_training_plans.contact_id%TYPE

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

Line 420: PROCEDURE complete_plan(p_training_plan_id in ota_training_plans.training_plan_id%type);

416: -- |----------------------< complete_plan >--------------------------|
417: -- ---------------------------------------------------------------------------
418: --
419:
420: PROCEDURE complete_plan(p_training_plan_id in ota_training_plans.training_plan_id%type);
421: -- ---------------------------------------------------------------------------
422:
423:
424: END ota_trng_plan_util_ss;