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 642: when hr_api.cannot_find_prog_unit then

638: p_is_history_flag => p_is_history_flag ,
639: p_is_mandatory_enrollment => p_is_mandatory_enrollment
640: );
641: exception
642: when hr_api.cannot_find_prog_unit then
643: hr_api.cannot_find_prog_unit_error
644: (p_module_name => 'create_delegate_booking_b'
645: ,p_hook_type => 'BP'
646: );

Line 643: hr_api.cannot_find_prog_unit_error

639: p_is_mandatory_enrollment => p_is_mandatory_enrollment
640: );
641: exception
642: when hr_api.cannot_find_prog_unit then
643: hr_api.cannot_find_prog_unit_error
644: (p_module_name => 'create_delegate_booking_b'
645: ,p_hook_type => 'BP'
646: );
647: end;

Line 1055: when hr_api.cannot_find_prog_unit then

1051: p_booking_id => p_booking_id
1052: );
1053:
1054: exception
1055: when hr_api.cannot_find_prog_unit then
1056: hr_api.cannot_find_prog_unit_error
1057: (p_module_name => 'create_delegate_booking_a'
1058: ,p_hook_type => 'AP'
1059: );

Line 1056: hr_api.cannot_find_prog_unit_error

1052: );
1053:
1054: exception
1055: when hr_api.cannot_find_prog_unit then
1056: hr_api.cannot_find_prog_unit_error
1057: (p_module_name => 'create_delegate_booking_a'
1058: ,p_hook_type => 'AP'
1059: );
1060: end;

Line 1065: raise hr_api.validate_enabled;

1061: --
1062: -- When in validation only mode raise the Validate_Enabled exception
1063: --
1064: if p_validate then
1065: raise hr_api.validate_enabled;
1066: end if;
1067:
1068: --
1069: hr_utility.set_location(' Leaving:'||l_proc, 70);

Line 1071: when hr_api.validate_enabled then

1067:
1068: --
1069: hr_utility.set_location(' Leaving:'||l_proc, 70);
1070: exception
1071: when hr_api.validate_enabled then
1072: --
1073: -- As the Validate_Enabled exception has been raised
1074: -- we must rollback to the savepoint
1075: --

Line 1868: when hr_api.cannot_find_prog_unit then

1864: );
1865:
1866:
1867: exception
1868: when hr_api.cannot_find_prog_unit then
1869: hr_api.cannot_find_prog_unit_error
1870: (p_module_name => 'update_delegate_booking_b'
1871: ,p_hook_type => 'BP'
1872: );

Line 1869: hr_api.cannot_find_prog_unit_error

1865:
1866:
1867: exception
1868: when hr_api.cannot_find_prog_unit then
1869: hr_api.cannot_find_prog_unit_error
1870: (p_module_name => 'update_delegate_booking_b'
1871: ,p_hook_type => 'BP'
1872: );
1873: end;

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

1896: FETCH csr_get_enr_details INTO l_enr_details_rec;
1897: CLOSE csr_get_enr_details;
1898:
1899: -- Modified for bug#4681165
1900: IF l_new_event_id = hr_api.g_number THEN l_new_event_id := l_enr_details_rec.event_id; END IF;
1901: IF l_new_customer_id = hr_api.g_number THEN l_new_customer_id := l_enr_details_rec.customer_id; END IF;
1902: 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;
1903: IF l_new_organization_id = hr_api.g_number THEN l_new_organization_id := l_enr_details_rec.organization_id; END IF;
1904: 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 1901: IF l_new_customer_id = hr_api.g_number THEN l_new_customer_id := l_enr_details_rec.customer_id; END IF;

1897: CLOSE csr_get_enr_details;
1898:
1899: -- Modified for bug#4681165
1900: IF l_new_event_id = hr_api.g_number THEN l_new_event_id := l_enr_details_rec.event_id; END IF;
1901: IF l_new_customer_id = hr_api.g_number THEN l_new_customer_id := l_enr_details_rec.customer_id; END IF;
1902: 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;
1903: IF l_new_organization_id = hr_api.g_number THEN l_new_organization_id := l_enr_details_rec.organization_id; END IF;
1904: 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;
1905: 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 1902: 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;

1898:
1899: -- Modified for bug#4681165
1900: IF l_new_event_id = hr_api.g_number THEN l_new_event_id := l_enr_details_rec.event_id; END IF;
1901: IF l_new_customer_id = hr_api.g_number THEN l_new_customer_id := l_enr_details_rec.customer_id; END IF;
1902: 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;
1903: IF l_new_organization_id = hr_api.g_number THEN l_new_organization_id := l_enr_details_rec.organization_id; END IF;
1904: 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;
1905: 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;
1906:

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

1899: -- Modified for bug#4681165
1900: IF l_new_event_id = hr_api.g_number THEN l_new_event_id := l_enr_details_rec.event_id; END IF;
1901: IF l_new_customer_id = hr_api.g_number THEN l_new_customer_id := l_enr_details_rec.customer_id; END IF;
1902: 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;
1903: IF l_new_organization_id = hr_api.g_number THEN l_new_organization_id := l_enr_details_rec.organization_id; END IF;
1904: 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;
1905: 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;
1906:
1907:

Line 1904: 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;

1900: IF l_new_event_id = hr_api.g_number THEN l_new_event_id := l_enr_details_rec.event_id; END IF;
1901: IF l_new_customer_id = hr_api.g_number THEN l_new_customer_id := l_enr_details_rec.customer_id; END IF;
1902: 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;
1903: IF l_new_organization_id = hr_api.g_number THEN l_new_organization_id := l_enr_details_rec.organization_id; END IF;
1904: 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;
1905: 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;
1906:
1907:
1908: l_event_id_changed := ota_general.value_changed( l_enr_details_rec.event_id, l_new_event_id);

Line 1905: 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;

1901: IF l_new_customer_id = hr_api.g_number THEN l_new_customer_id := l_enr_details_rec.customer_id; END IF;
1902: 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;
1903: IF l_new_organization_id = hr_api.g_number THEN l_new_organization_id := l_enr_details_rec.organization_id; END IF;
1904: 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;
1905: 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;
1906:
1907:
1908: l_event_id_changed := ota_general.value_changed( l_enr_details_rec.event_id, l_new_event_id);
1909: l_customer_id_changed := ota_general.value_changed( l_enr_details_rec.customer_id, l_new_customer_id);

Line 1937: IF l_new_booking_status_type_id = hr_api.g_number THEN

1933: OPEN csr_get_cur_booking_status;
1934: FETCH csr_get_cur_booking_status INTO l_existing_booking_status_id;
1935: CLOSE csr_get_cur_booking_status;
1936:
1937: IF l_new_booking_status_type_id = hr_api.g_number THEN
1938: l_new_booking_status_type_id := l_existing_booking_status_id;
1939: END IF;
1940: l_booking_status_type_changed := ota_general.value_changed(l_existing_booking_status_id,l_new_booking_status_type_id);
1941:

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

1943: l_date_status_changed := trunc(sysdate);
1944: END IF;
1945:
1946: -- Added for bug#4654530
1947: IF nvl(p_status_change_comments,hr_api.g_varchar2) <> l_evt_status_chg_comments THEN
1948:
1949: OPEN get_status_info;
1950: FETCH get_status_info INTO l_old_booking_status;
1951: CLOSE get_status_info;

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

2033: --end of changes for 7046809.
2034:
2035: --
2036: --Bug 2359495
2037: IF ( p_status_change_comments IS NULL or p_status_change_comments = hr_api.g_varchar2) THEN --Bug 5586486
2038: l_status_change_comments := hr_general_utilities.get_lookup_meaning
2039: ('ENROLMENT_STATUS_REASON',
2040: 'A');
2041: ELSE

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

2247: OPEN is_contact;
2248: FETCH is_contact INTO l_contact_id,l_delegate_contact_id;
2249: CLOSE is_contact;
2250:
2251: IF (p_delegate_person_id = hr_api.g_number) THEN
2252: select delegate_person_id into l_person_id from ota_delegate_bookings
2253: where booking_id = p_booking_id;
2254: else l_person_id := p_delegate_person_id;
2255: END IF;

Line 2418: IF p_event_id <> hr_api.g_number

2414: --
2415: END IF;
2416: --
2417: --Added for Bug#4106893
2418: IF p_event_id <> hr_api.g_number
2419: AND p_event_id <> ota_tdb_shd.g_old_rec.event_id THEN
2420: l_event_id_changed:= true;
2421: END IF;
2422:

Line 2423: IF p_delegate_person_id <> hr_api.g_number

2419: AND p_event_id <> ota_tdb_shd.g_old_rec.event_id THEN
2420: l_event_id_changed:= true;
2421: END IF;
2422:
2423: IF p_delegate_person_id <> hr_api.g_number
2424: AND p_delegate_person_id <> ota_tdb_shd.g_old_rec.delegate_person_id THEN
2425: l_person_id_changed := true;
2426: END IF;
2427:

Line 2428: IF p_delegate_contact_id <> hr_api.g_number

2424: AND p_delegate_person_id <> ota_tdb_shd.g_old_rec.delegate_person_id THEN
2425: l_person_id_changed := true;
2426: END IF;
2427:
2428: IF p_delegate_contact_id <> hr_api.g_number
2429: AND p_delegate_contact_id <> ota_tdb_shd.g_old_rec.delegate_contact_id THEN
2430: l_contact_id_changed := true;
2431: END IF;
2432:

Line 2857: when hr_api.cannot_find_prog_unit then

2853: p_booking_justification_id => p_booking_justification_id,
2854: p_is_history_flag => p_is_history_flag
2855: );
2856: exception
2857: when hr_api.cannot_find_prog_unit then
2858: hr_api.cannot_find_prog_unit_error
2859: (p_module_name => 'update_delegate_booking_a'
2860: ,p_hook_type => 'AP'
2861: );

Line 2858: hr_api.cannot_find_prog_unit_error

2854: p_is_history_flag => p_is_history_flag
2855: );
2856: exception
2857: when hr_api.cannot_find_prog_unit then
2858: hr_api.cannot_find_prog_unit_error
2859: (p_module_name => 'update_delegate_booking_a'
2860: ,p_hook_type => 'AP'
2861: );
2862: end;

Line 2867: raise hr_api.validate_enabled;

2863: --
2864: -- When in validation only mode raise the Validate_Enabled exception
2865: --
2866: if p_validate then
2867: raise hr_api.validate_enabled;
2868: end if;
2869: --
2870: -- Set all output arguments
2871: --

Line 2876: when hr_api.validate_enabled then

2872: -- p_object_version_number := l_object_version_number;
2873: --
2874: hr_utility.set_location(' Leaving:'||l_proc, 70);
2875: exception
2876: when hr_api.validate_enabled then
2877: --
2878: -- As the Validate_Enabled exception has been raised
2879: -- we must rollback to the savepoint
2880: --

Line 2975: when hr_api.cannot_find_prog_unit then

2971: (p_booking_id => p_booking_id ,
2972: p_object_version_number => p_object_version_number);
2973:
2974: exception
2975: when hr_api.cannot_find_prog_unit then
2976: hr_api.cannot_find_prog_unit_error
2977: (p_module_name => 'delete_delegate_booking_b'
2978: ,p_hook_type => 'BP'
2979: );

Line 2976: hr_api.cannot_find_prog_unit_error

2972: p_object_version_number => p_object_version_number);
2973:
2974: exception
2975: when hr_api.cannot_find_prog_unit then
2976: hr_api.cannot_find_prog_unit_error
2977: (p_module_name => 'delete_delegate_booking_b'
2978: ,p_hook_type => 'BP'
2979: );
2980: end;

Line 3056: when hr_api.cannot_find_prog_unit then

3052: OTA_delegate_booking_bk3.delete_delegate_booking_a
3053: (p_booking_id => p_booking_id ,
3054: p_object_version_number => p_object_version_number);
3055: exception
3056: when hr_api.cannot_find_prog_unit then
3057: hr_api.cannot_find_prog_unit_error
3058: (p_module_name => 'delete_delegate_booking_a'
3059: ,p_hook_type => 'AP'
3060: );

Line 3057: hr_api.cannot_find_prog_unit_error

3053: (p_booking_id => p_booking_id ,
3054: p_object_version_number => p_object_version_number);
3055: exception
3056: when hr_api.cannot_find_prog_unit then
3057: hr_api.cannot_find_prog_unit_error
3058: (p_module_name => 'delete_delegate_booking_a'
3059: ,p_hook_type => 'AP'
3060: );
3061: end;

Line 3066: raise hr_api.validate_enabled;

3062: --
3063: -- When in validation only mode raise the Validate_Enabled exception
3064: --
3065: if p_validate then
3066: raise hr_api.validate_enabled;
3067: end if;
3068: --
3069: -- Set all output arguments
3070: --

Line 3074: when hr_api.validate_enabled then

3070: --
3071: --
3072: hr_utility.set_location(' Leaving:'||l_proc, 170);
3073: exception
3074: when hr_api.validate_enabled then
3075: --
3076: -- As the Validate_Enabled exception has been raised
3077: -- we must rollback to the savepoint
3078: --

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

3187: Begin
3188: -- Prerequisite Validation Code
3189: l_check_prereq := false;
3190:
3191: If ( p_delegate_person_id = hr_api.g_number ) Then
3192: l_delegate_person_id := ota_tdb_shd.g_old_rec.delegate_person_id;
3193: Else
3194: l_delegate_person_id := p_delegate_person_id;
3195: End If;

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

3193: Else
3194: l_delegate_person_id := p_delegate_person_id;
3195: End If;
3196:
3197: If ( p_delegate_contact_id = hr_api.g_number ) Then
3198: l_delegate_contact_id := ota_tdb_shd.g_old_rec.delegate_contact_id;
3199: Else
3200: l_delegate_contact_id := p_delegate_contact_id;
3201: End If;

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

3199: Else
3200: l_delegate_contact_id := p_delegate_contact_id;
3201: End If;
3202:
3203: If ( p_customer_id = hr_api.g_number ) Then
3204: l_customer_id := ota_tdb_shd.g_old_rec.customer_id;
3205: Else
3206: l_customer_id := p_customer_id;
3207: End If;

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

3205: Else
3206: l_customer_id := p_customer_id;
3207: End If;
3208:
3209: If ( p_event_id = hr_api.g_number ) Then
3210: l_event_id := ota_tdb_shd.g_old_rec.event_id;
3211: Else
3212: l_event_id := p_event_id;
3213: End If;

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

3211: Else
3212: l_event_id := p_event_id;
3213: End If;
3214:
3215: If ( p_booking_status_type_id = hr_api.g_number ) Then
3216: l_booking_status_type_id := ota_tdb_shd.g_old_rec.booking_status_type_id;
3217: Else
3218: l_booking_status_type_id := p_booking_status_type_id;
3219: End If;