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_TDB_BUS dependencies on OTA_UTILITY

Line 3216: /*ota_utility.get_invoice_rule (

3212: hr_utility.set_location('Entering:'||l_proc, 5);
3213: --
3214: IF p_line_id is not null THEN
3215: IF l_booking_status_changed THEN
3216: /*ota_utility.get_invoice_rule (
3217: p_line_id => p_line_id,
3218: p_invoice_rule => l_invoice_rule);*/
3219:
3220: ota_utility.get_booking_status_type(

Line 3220: ota_utility.get_booking_status_type(

3216: /*ota_utility.get_invoice_rule (
3217: p_line_id => p_line_id,
3218: p_invoice_rule => l_invoice_rule);*/
3219:
3220: ota_utility.get_booking_status_type(
3221: p_status_type_id => ota_tdb_shd.g_old_rec.booking_status_type_id,
3222: p_type => l_old_status_type) ;
3223: IF p_status_type_id is not null THEN
3224: ota_utility.get_booking_status_type(

Line 3224: ota_utility.get_booking_status_type(

3220: ota_utility.get_booking_status_type(
3221: p_status_type_id => ota_tdb_shd.g_old_rec.booking_status_type_id,
3222: p_type => l_old_status_type) ;
3223: IF p_status_type_id is not null THEN
3224: ota_utility.get_booking_status_type(
3225: p_status_type_id => p_status_type_id,
3226: p_type => l_status_type);
3227:
3228: IF l_status_type = 'C' THEN

Line 3234: ota_utility.check_invoice(

3230:
3231: BEGIN
3232: hr_utility.set_location('Entering:'||l_proc, 10);
3233:
3234: ota_utility.check_invoice(
3235: p_line_id => p_line_id,
3236: p_org_id => p_org_id,
3237: p_exist => l_exist);
3238: IF fnd_installation.get(660, 660, l_ins_status, l_industry) THEN

Line 3286: l_return := ota_utility.check_wf_status(p_line_id,'WAIT_FOR_ATTENDED');

3282: END IF;
3283: /* Fix Bug 1549427 :Remove the checked for invoicing rule */
3284: ELSIF l_status_type = 'A' THEN
3285: IF l_old_status_type in ('W','P','R') THEN
3286: l_return := ota_utility.check_wf_status(p_line_id,'WAIT_FOR_ATTENDED');
3287: IF l_return = TRUE THEN
3288: wf_engine.Completeactivity('OEOL',
3289: to_char(p_line_id),
3290: 'WAIT_FOR_ATTENDED',null);

Line 3299: l_return := ota_utility.check_wf_status(p_line_id,'WAIT_FOR_PLACED');

3295:
3296: /* ELSIF l_status_type = 'P' THEN
3297: IF l_old_status_type = 'W' THEN
3298: IF l_invoice_rule = 'ADVANCED' THEN
3299: l_return := ota_utility.check_wf_status(p_line_id,'WAIT_FOR_PLACED');
3300: IF l_return = TRUE THEN
3301: wf_engine.Completeactivity('OEOL',
3302: to_char(p_line_id),
3303: 'WAIT_FOR_PLACED',null);

Line 3309: l_return := ota_utility.check_wf_status(p_line_id,'WAIT_FOR_ATTENDED');

3305: END IF;
3306: END IF;
3307: ELSIF l_status_type = 'A' THEN
3308: IF l_invoice_rule = 'ARREARS' THEN
3309: l_return := ota_utility.check_wf_status(p_line_id,'WAIT_FOR_ATTENDED');
3310: IF l_return = TRUE THEN
3311: wf_engine.Completeactivity('OEOL',
3312: to_char(p_line_id),
3313: 'WAIT_FOR_ATTENDED',null);

Line 3326: ota_utility.get_booking_status_type(

3322:
3323: ELSIF p_line_id is null THEN
3324: IF l_booking_status_changed THEN
3325:
3326: ota_utility.get_booking_status_type(
3327: p_status_type_id => ota_tdb_shd.g_old_rec.booking_status_type_id,
3328: p_type => l_old_status_type) ;
3329:
3330: IF p_status_type_id is not null THEN

Line 3331: ota_utility.get_booking_status_type(

3327: p_status_type_id => ota_tdb_shd.g_old_rec.booking_status_type_id,
3328: p_type => l_old_status_type) ;
3329:
3330: IF p_status_type_id is not null THEN
3331: ota_utility.get_booking_status_type(
3332: p_status_type_id => p_status_type_id,
3333: p_type => l_status_type);
3334: OPEN C_RE;
3335: FETCH C_RE INTO l_line_id;

Line 3339: l_return := ota_utility.check_wf_status(l_line_id,'WAIT_FOR_ENROLLMENT_ATTENDED');

3335: FETCH C_RE INTO l_line_id;
3336: IF C_RE%FOUND THEN
3337: IF l_status_type = 'A' and l_old_status_type is not null then
3338:
3339: l_return := ota_utility.check_wf_status(l_line_id,'WAIT_FOR_ENROLLMENT_ATTENDED');
3340: IF l_return = TRUE THEN
3341: wf_engine.Completeactivity('OEOL',
3342: to_char(l_line_id),
3343: 'WAIT_FOR_ENROLLMENT_ATTENDED',null);

Line 3383: l_is_match := ota_utility.check_organization_match(p_delegate_person_id,l_organization_id);

3379: BEGIN
3380: OPEN csr_is_secure_event;
3381: FETCH csr_is_secure_event INTO l_organization_id;
3382: IF csr_is_secure_event%FOUND THEN
3383: l_is_match := ota_utility.check_organization_match(p_delegate_person_id,l_organization_id);
3384: IF l_is_match = 'N' THEN
3385: fnd_message.set_name('OTA','OTA_443939_SECURE_EVT_LRN_ERR');
3386: fnd_message.raise_error;
3387: END IF;

Line 3443: ota_utility.get_booking_status_type(p_booking_status_type_id,l_bkng_status_type);

3439: l_contact_id ota_delegate_bookings.delegate_contact_id%TYPE := p_delegate_contact_id;
3440:
3441: BEGIN
3442: IF p_booking_status_type_id <> hr_api.g_number THEN
3443: ota_utility.get_booking_status_type(p_booking_status_type_id,l_bkng_status_type);
3444: ota_utility.get_booking_status_type(ota_tdb_shd.g_old_rec.booking_status_type_id,l_old_bst);
3445:
3446: IF l_bkng_status_type = 'A'
3447: OR l_old_bst not in('A','E') THEN RETURN; END IF;--Added for 6989133.

Line 3444: ota_utility.get_booking_status_type(ota_tdb_shd.g_old_rec.booking_status_type_id,l_old_bst);

3440:
3441: BEGIN
3442: IF p_booking_status_type_id <> hr_api.g_number THEN
3443: ota_utility.get_booking_status_type(p_booking_status_type_id,l_bkng_status_type);
3444: ota_utility.get_booking_status_type(ota_tdb_shd.g_old_rec.booking_status_type_id,l_old_bst);
3445:
3446: IF l_bkng_status_type = 'A'
3447: OR l_old_bst not in('A','E') THEN RETURN; END IF;--Added for 6989133.
3448:

Line 3480: ota_utility.get_ext_lrnr_party_id(l_contact_id)

3476: IF l_person_id IS NOT NULL THEN
3477: OPEN csr_get_performance_data(l_person_id, 'E', l_lo_id);
3478: ELSIF l_contact_id IS NOT NULL THEN
3479: OPEN csr_get_performance_data(
3480: ota_utility.get_ext_lrnr_party_id(l_contact_id)
3481: ,'C'
3482: ,l_lo_id);
3483: ELSE
3484: RETURN;

Line 4245: ota_utility.get_booking_status_type( p_status_type_id =>

4241: l_delegate_person_id_changed or
4242: l_delegate_contact_id_changed or
4243: l_status_type_id_changed then
4244:
4245: ota_utility.get_booking_status_type( p_status_type_id =>
4246: p_rec.booking_status_type_id,
4247: p_type => l_booking_status_type) ;
4248:
4249: IF l_booking_status_type <> 'C' THEN --added this condition for bug 10253738

Line 4456: ota_utility.get_booking_status_type( p_status_type_id => ota_tdb_shd.g_old_rec.booking_status_type_id,

4452:
4453: -- Bug#5614187 - Enrollments can not be moved from cancelled status after enrollment
4454: -- period is over.
4455: IF l_status_type_id_changed THEN
4456: ota_utility.get_booking_status_type( p_status_type_id => ota_tdb_shd.g_old_rec.booking_status_type_id,
4457: p_type => l_status_type) ;
4458: IF l_status_type = 'C' THEN
4459: ota_utility.get_booking_status_type( p_status_type_id => p_rec.booking_status_type_id,
4460: p_type => l_status_type) ;

Line 4459: ota_utility.get_booking_status_type( p_status_type_id => p_rec.booking_status_type_id,

4455: IF l_status_type_id_changed THEN
4456: ota_utility.get_booking_status_type( p_status_type_id => ota_tdb_shd.g_old_rec.booking_status_type_id,
4457: p_type => l_status_type) ;
4458: IF l_status_type = 'C' THEN
4459: ota_utility.get_booking_status_type( p_status_type_id => p_rec.booking_status_type_id,
4460: p_type => l_status_type) ;
4461: IF l_status_type <> 'C' THEN
4462: l_status_type := ota_tdb_bus.check_enrollment_dates(p_rec.event_id, sysdate);
4463: END IF;