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_DELEGATE_BOOKING_API dependencies on HR_API

Line 797: when hr_api.cannot_find_prog_unit then

793: p_is_history_flag => p_is_history_flag ,
794: p_is_mandatory_enrollment => p_is_mandatory_enrollment
795: );
796: exception
797: when hr_api.cannot_find_prog_unit then
798: hr_api.cannot_find_prog_unit_error
799: (p_module_name => 'create_delegate_booking_b'
800: ,p_hook_type => 'BP'
801: );

Line 798: hr_api.cannot_find_prog_unit_error

794: p_is_mandatory_enrollment => p_is_mandatory_enrollment
795: );
796: exception
797: when hr_api.cannot_find_prog_unit then
798: hr_api.cannot_find_prog_unit_error
799: (p_module_name => 'create_delegate_booking_b'
800: ,p_hook_type => 'BP'
801: );
802: end;

Line 1214: when hr_api.cannot_find_prog_unit then

1210: p_booking_id => p_booking_id
1211: );
1212:
1213: exception
1214: when hr_api.cannot_find_prog_unit then
1215: hr_api.cannot_find_prog_unit_error
1216: (p_module_name => 'create_delegate_booking_a'
1217: ,p_hook_type => 'AP'
1218: );

Line 1215: hr_api.cannot_find_prog_unit_error

1211: );
1212:
1213: exception
1214: when hr_api.cannot_find_prog_unit then
1215: hr_api.cannot_find_prog_unit_error
1216: (p_module_name => 'create_delegate_booking_a'
1217: ,p_hook_type => 'AP'
1218: );
1219: end;

Line 1224: raise hr_api.validate_enabled;

1220: --
1221: -- When in validation only mode raise the Validate_Enabled exception
1222: --
1223: if p_validate then
1224: raise hr_api.validate_enabled;
1225: end if;
1226:
1227: --
1228: hr_utility.set_location(' Leaving:'||l_proc, 70);

Line 1230: when hr_api.validate_enabled then

1226:
1227: --
1228: hr_utility.set_location(' Leaving:'||l_proc, 70);
1229: exception
1230: when hr_api.validate_enabled then
1231: --
1232: -- As the Validate_Enabled exception has been raised
1233: -- we must rollback to the savepoint
1234: --

Line 1810: l_new_booking_status_type_id ota_delegate_bookings.booking_status_type_id%TYPE := nvl(p_booking_status_type_id,hr_api.g_number);

1806:
1807: --Bug6801749:ANY CHANGE BY ADMIN TO ENROLLMENT CAUSED DATE_STATUS_CHANGED UPDATE
1808: l_booking_status_type_changed boolean := false;
1809: l_existing_booking_status_id ota_delegate_bookings.booking_status_type_id%TYPE;
1810: l_new_booking_status_type_id ota_delegate_bookings.booking_status_type_id%TYPE := nvl(p_booking_status_type_id,hr_api.g_number);
1811:
1812: CURSOR csr_get_cur_booking_status IS
1813: SELECT booking_status_type_id
1814: FROM ota_delegate_bookings

Line 2059: when hr_api.cannot_find_prog_unit then

2055: );
2056:
2057:
2058: exception
2059: when hr_api.cannot_find_prog_unit then
2060: hr_api.cannot_find_prog_unit_error
2061: (p_module_name => 'update_delegate_booking_b'
2062: ,p_hook_type => 'BP'
2063: );

Line 2060: hr_api.cannot_find_prog_unit_error

2056:
2057:
2058: exception
2059: when hr_api.cannot_find_prog_unit then
2060: hr_api.cannot_find_prog_unit_error
2061: (p_module_name => 'update_delegate_booking_b'
2062: ,p_hook_type => 'BP'
2063: );
2064: end;

Line 2091: IF l_new_event_id = hr_api.g_number THEN l_new_event_id := l_enr_details_rec.event_id; END IF;

2087: FETCH csr_get_enr_details INTO l_enr_details_rec;
2088: CLOSE csr_get_enr_details;
2089:
2090: -- Modified for bug#4681165
2091: IF l_new_event_id = hr_api.g_number THEN l_new_event_id := l_enr_details_rec.event_id; END IF;
2092: IF l_new_customer_id = hr_api.g_number THEN l_new_customer_id := l_enr_details_rec.customer_id; END IF;
2093: IF l_new_delegate_contact_id = hr_api.g_number THEN l_new_delegate_contact_id := l_enr_details_rec.delegate_contact_id; END IF;
2094: IF l_new_organization_id = hr_api.g_number THEN l_new_organization_id := l_enr_details_rec.organization_id; END IF;
2095: IF l_new_del_asg_id = hr_api.g_number THEN l_new_del_asg_id := l_enr_details_rec.delegate_assignment_id; END IF;

Line 2092: IF l_new_customer_id = hr_api.g_number THEN l_new_customer_id := l_enr_details_rec.customer_id; END IF;

2088: CLOSE csr_get_enr_details;
2089:
2090: -- Modified for bug#4681165
2091: IF l_new_event_id = hr_api.g_number THEN l_new_event_id := l_enr_details_rec.event_id; END IF;
2092: IF l_new_customer_id = hr_api.g_number THEN l_new_customer_id := l_enr_details_rec.customer_id; END IF;
2093: IF l_new_delegate_contact_id = hr_api.g_number THEN l_new_delegate_contact_id := l_enr_details_rec.delegate_contact_id; END IF;
2094: IF l_new_organization_id = hr_api.g_number THEN l_new_organization_id := l_enr_details_rec.organization_id; END IF;
2095: IF l_new_del_asg_id = hr_api.g_number THEN l_new_del_asg_id := l_enr_details_rec.delegate_assignment_id; END IF;
2096: IF l_new_delegate_person_id = hr_api.g_number THEN l_new_delegate_person_id := l_enr_details_rec.delegate_person_id; END IF;

Line 2093: IF l_new_delegate_contact_id = hr_api.g_number THEN l_new_delegate_contact_id := l_enr_details_rec.delegate_contact_id; END IF;

2089:
2090: -- Modified for bug#4681165
2091: IF l_new_event_id = hr_api.g_number THEN l_new_event_id := l_enr_details_rec.event_id; END IF;
2092: IF l_new_customer_id = hr_api.g_number THEN l_new_customer_id := l_enr_details_rec.customer_id; END IF;
2093: IF l_new_delegate_contact_id = hr_api.g_number THEN l_new_delegate_contact_id := l_enr_details_rec.delegate_contact_id; END IF;
2094: IF l_new_organization_id = hr_api.g_number THEN l_new_organization_id := l_enr_details_rec.organization_id; END IF;
2095: IF l_new_del_asg_id = hr_api.g_number THEN l_new_del_asg_id := l_enr_details_rec.delegate_assignment_id; END IF;
2096: IF l_new_delegate_person_id = hr_api.g_number THEN l_new_delegate_person_id := l_enr_details_rec.delegate_person_id; END IF;
2097:

Line 2094: IF l_new_organization_id = hr_api.g_number THEN l_new_organization_id := l_enr_details_rec.organization_id; END IF;

2090: -- Modified for bug#4681165
2091: IF l_new_event_id = hr_api.g_number THEN l_new_event_id := l_enr_details_rec.event_id; END IF;
2092: IF l_new_customer_id = hr_api.g_number THEN l_new_customer_id := l_enr_details_rec.customer_id; END IF;
2093: IF l_new_delegate_contact_id = hr_api.g_number THEN l_new_delegate_contact_id := l_enr_details_rec.delegate_contact_id; END IF;
2094: IF l_new_organization_id = hr_api.g_number THEN l_new_organization_id := l_enr_details_rec.organization_id; END IF;
2095: IF l_new_del_asg_id = hr_api.g_number THEN l_new_del_asg_id := l_enr_details_rec.delegate_assignment_id; END IF;
2096: IF l_new_delegate_person_id = hr_api.g_number THEN l_new_delegate_person_id := l_enr_details_rec.delegate_person_id; END IF;
2097:
2098:

Line 2095: IF l_new_del_asg_id = hr_api.g_number THEN l_new_del_asg_id := l_enr_details_rec.delegate_assignment_id; END IF;

2091: IF l_new_event_id = hr_api.g_number THEN l_new_event_id := l_enr_details_rec.event_id; END IF;
2092: IF l_new_customer_id = hr_api.g_number THEN l_new_customer_id := l_enr_details_rec.customer_id; END IF;
2093: IF l_new_delegate_contact_id = hr_api.g_number THEN l_new_delegate_contact_id := l_enr_details_rec.delegate_contact_id; END IF;
2094: IF l_new_organization_id = hr_api.g_number THEN l_new_organization_id := l_enr_details_rec.organization_id; END IF;
2095: IF l_new_del_asg_id = hr_api.g_number THEN l_new_del_asg_id := l_enr_details_rec.delegate_assignment_id; END IF;
2096: IF l_new_delegate_person_id = hr_api.g_number THEN l_new_delegate_person_id := l_enr_details_rec.delegate_person_id; END IF;
2097:
2098:
2099: l_event_id_changed := ota_general.value_changed( l_enr_details_rec.event_id, l_new_event_id);

Line 2096: IF l_new_delegate_person_id = hr_api.g_number THEN l_new_delegate_person_id := l_enr_details_rec.delegate_person_id; END IF;

2092: IF l_new_customer_id = hr_api.g_number THEN l_new_customer_id := l_enr_details_rec.customer_id; END IF;
2093: IF l_new_delegate_contact_id = hr_api.g_number THEN l_new_delegate_contact_id := l_enr_details_rec.delegate_contact_id; END IF;
2094: IF l_new_organization_id = hr_api.g_number THEN l_new_organization_id := l_enr_details_rec.organization_id; END IF;
2095: IF l_new_del_asg_id = hr_api.g_number THEN l_new_del_asg_id := l_enr_details_rec.delegate_assignment_id; END IF;
2096: IF l_new_delegate_person_id = hr_api.g_number THEN l_new_delegate_person_id := l_enr_details_rec.delegate_person_id; END IF;
2097:
2098:
2099: l_event_id_changed := ota_general.value_changed( l_enr_details_rec.event_id, l_new_event_id);
2100: l_customer_id_changed := ota_general.value_changed( l_enr_details_rec.customer_id, l_new_customer_id);

Line 2129: IF nvl(p_event_id,hr_api.g_number) <> hr_api.g_number THEN

2125: FETCH csr_get_cur_booking_status INTO l_existing_booking_status_id;
2126: CLOSE csr_get_cur_booking_status;
2127:
2128: --Added for Bug#4106893
2129: IF nvl(p_event_id,hr_api.g_number) <> hr_api.g_number THEN
2130: IF p_event_id <> ota_tdb_shd.g_old_rec.event_id THEN
2131: l_event_id_changed:= true;
2132: l_new_event_id := p_event_id;
2133: END IF;

Line 2138: IF l_new_booking_status_type_id = hr_api.g_number THEN

2134: ELSE -- Changed for bug 12647700
2135: l_new_event_id := ota_tdb_shd.g_old_rec.event_id;
2136: END IF;
2137:
2138: IF l_new_booking_status_type_id = hr_api.g_number THEN
2139: l_new_booking_status_type_id := l_existing_booking_status_id;
2140: END IF;
2141: l_booking_status_type_changed := ota_general.value_changed(l_existing_booking_status_id,l_new_booking_status_type_id);
2142:

Line 2148: IF nvl(p_status_change_comments,hr_api.g_varchar2) <> l_evt_status_chg_comments THEN

2144: l_date_status_changed := trunc(sysdate);
2145: END IF;
2146:
2147: -- Added for bug#4654530
2148: IF nvl(p_status_change_comments,hr_api.g_varchar2) <> l_evt_status_chg_comments THEN
2149:
2150: OPEN get_status_info;
2151: FETCH get_status_info INTO l_old_booking_status;
2152: CLOSE get_status_info;

Line 2244: IF ( p_status_change_comments IS NULL or p_status_change_comments = hr_api.g_varchar2) THEN --Bug 5586486

2240: l_new_sign_eval_status:=process_sign_eval_status(l_new_event_id,p_booking_id,p_sign_eval_status,l_new_booking_status_type_id);
2241:
2242: --
2243: --Bug 2359495
2244: IF ( p_status_change_comments IS NULL or p_status_change_comments = hr_api.g_varchar2) THEN --Bug 5586486
2245: open csr_hr_lookup('ENROLMENT_STATUS_REASON', 'A'); --Bug#7476314
2246: fetch csr_hr_lookup into l_status_change_comments;
2247: close csr_hr_lookup;
2248: /*l_status_change_comments := hr_general_utilities.get_lookup_meaning

Line 2462: IF (p_delegate_person_id = hr_api.g_number) THEN

2458: OPEN is_contact;
2459: FETCH is_contact INTO l_contact_id,l_delegate_contact_id;
2460: CLOSE is_contact;
2461:
2462: IF (p_delegate_person_id = hr_api.g_number) THEN
2463: select delegate_person_id into l_person_id from ota_delegate_bookings
2464: where booking_id = p_booking_id;
2465: else l_person_id := p_delegate_person_id;
2466: END IF;

Line 2628: IF p_delegate_person_id <> hr_api.g_number

2624: ---***Added p_delegate_person_id. Bug2791524.
2625: --
2626: END IF;
2627: --
2628: IF p_delegate_person_id <> hr_api.g_number
2629: AND p_delegate_person_id <> ota_tdb_shd.g_old_rec.delegate_person_id THEN
2630: l_person_id_changed := true;
2631: END IF;
2632:

Line 2633: IF p_delegate_contact_id <> hr_api.g_number

2629: AND p_delegate_person_id <> ota_tdb_shd.g_old_rec.delegate_person_id THEN
2630: l_person_id_changed := true;
2631: END IF;
2632:
2633: IF p_delegate_contact_id <> hr_api.g_number
2634: AND p_delegate_contact_id <> ota_tdb_shd.g_old_rec.delegate_contact_id THEN
2635: l_contact_id_changed := true;
2636: END IF;
2637:

Line 3090: when hr_api.cannot_find_prog_unit then

3086: p_booking_justification_id => p_booking_justification_id,
3087: p_is_history_flag => p_is_history_flag
3088: );
3089: exception
3090: when hr_api.cannot_find_prog_unit then
3091: hr_api.cannot_find_prog_unit_error
3092: (p_module_name => 'update_delegate_booking_a'
3093: ,p_hook_type => 'AP'
3094: );

Line 3091: hr_api.cannot_find_prog_unit_error

3087: p_is_history_flag => p_is_history_flag
3088: );
3089: exception
3090: when hr_api.cannot_find_prog_unit then
3091: hr_api.cannot_find_prog_unit_error
3092: (p_module_name => 'update_delegate_booking_a'
3093: ,p_hook_type => 'AP'
3094: );
3095: end;

Line 3100: raise hr_api.validate_enabled;

3096: --
3097: -- When in validation only mode raise the Validate_Enabled exception
3098: --
3099: if p_validate then
3100: raise hr_api.validate_enabled;
3101: end if;
3102: --
3103: -- Set all output arguments
3104: --

Line 3109: when hr_api.validate_enabled then

3105: -- p_object_version_number := l_object_version_number;
3106: --
3107: hr_utility.set_location(' Leaving:'||l_proc, 70);
3108: exception
3109: when hr_api.validate_enabled then
3110: --
3111: -- As the Validate_Enabled exception has been raised
3112: -- we must rollback to the savepoint
3113: --

Line 3220: when hr_api.cannot_find_prog_unit then

3216: (p_booking_id => p_booking_id ,
3217: p_object_version_number => p_object_version_number);
3218:
3219: exception
3220: when hr_api.cannot_find_prog_unit then
3221: hr_api.cannot_find_prog_unit_error
3222: (p_module_name => 'delete_delegate_booking_b'
3223: ,p_hook_type => 'BP'
3224: );

Line 3221: hr_api.cannot_find_prog_unit_error

3217: p_object_version_number => p_object_version_number);
3218:
3219: exception
3220: when hr_api.cannot_find_prog_unit then
3221: hr_api.cannot_find_prog_unit_error
3222: (p_module_name => 'delete_delegate_booking_b'
3223: ,p_hook_type => 'BP'
3224: );
3225: end;

Line 3302: when hr_api.cannot_find_prog_unit then

3298: (p_booking_id => p_booking_id ,
3299: p_object_version_number => p_object_version_number,
3300: p_person_id => l_person_id);
3301: exception
3302: when hr_api.cannot_find_prog_unit then
3303: hr_api.cannot_find_prog_unit_error
3304: (p_module_name => 'delete_delegate_booking_a'
3305: ,p_hook_type => 'AP'
3306: );

Line 3303: hr_api.cannot_find_prog_unit_error

3299: p_object_version_number => p_object_version_number,
3300: p_person_id => l_person_id);
3301: exception
3302: when hr_api.cannot_find_prog_unit then
3303: hr_api.cannot_find_prog_unit_error
3304: (p_module_name => 'delete_delegate_booking_a'
3305: ,p_hook_type => 'AP'
3306: );
3307: end;

Line 3312: raise hr_api.validate_enabled;

3308: --
3309: -- When in validation only mode raise the Validate_Enabled exception
3310: --
3311: if p_validate then
3312: raise hr_api.validate_enabled;
3313: end if;
3314: --
3315: -- Set all output arguments
3316: --

Line 3320: when hr_api.validate_enabled then

3316: --
3317: --
3318: hr_utility.set_location(' Leaving:'||l_proc, 170);
3319: exception
3320: when hr_api.validate_enabled then
3321: --
3322: -- As the Validate_Enabled exception has been raised
3323: -- we must rollback to the savepoint
3324: --

Line 3437: If ( p_delegate_person_id = hr_api.g_number ) Then

3433: Begin
3434: -- Prerequisite Validation Code
3435: l_check_prereq := false;
3436:
3437: If ( p_delegate_person_id = hr_api.g_number ) Then
3438: l_delegate_person_id := ota_tdb_shd.g_old_rec.delegate_person_id;
3439: Else
3440: l_delegate_person_id := p_delegate_person_id;
3441: End If;

Line 3443: If ( p_delegate_contact_id = hr_api.g_number ) Then

3439: Else
3440: l_delegate_person_id := p_delegate_person_id;
3441: End If;
3442:
3443: If ( p_delegate_contact_id = hr_api.g_number ) Then
3444: l_delegate_contact_id := ota_tdb_shd.g_old_rec.delegate_contact_id;
3445: Else
3446: l_delegate_contact_id := p_delegate_contact_id;
3447: End If;

Line 3449: If ( p_customer_id = hr_api.g_number ) Then

3445: Else
3446: l_delegate_contact_id := p_delegate_contact_id;
3447: End If;
3448:
3449: If ( p_customer_id = hr_api.g_number ) Then
3450: l_customer_id := ota_tdb_shd.g_old_rec.customer_id;
3451: Else
3452: l_customer_id := p_customer_id;
3453: End If;

Line 3455: If ( p_event_id = hr_api.g_number ) Then

3451: Else
3452: l_customer_id := p_customer_id;
3453: End If;
3454:
3455: If ( p_event_id = hr_api.g_number ) Then
3456: l_event_id := ota_tdb_shd.g_old_rec.event_id;
3457: Else
3458: l_event_id := p_event_id;
3459: End If;

Line 3461: If ( p_booking_status_type_id = hr_api.g_number ) Then

3457: Else
3458: l_event_id := p_event_id;
3459: End If;
3460:
3461: If ( p_booking_status_type_id = hr_api.g_number ) Then
3462: l_booking_status_type_id := ota_tdb_shd.g_old_rec.booking_status_type_id;
3463: Else
3464: l_booking_status_type_id := p_booking_status_type_id;
3465: End If;