[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select lower(bic.interface_col_name) interface_col_name
from bne_interface_cols_b bic
where bic.interface_code = c_interface_code
and bic.display_flag ='Y';
select lower(bic.interface_col_name) interface_col_name
from bne_interface_cols_b bic
where bic.interface_code = c_interface_code
and bic.display_flag ='N';
,p_update_finance_line in varchar2 default hr_api.g_varchar2
,p_tfl_object_version_number in number default null
) is
--
-- Variables for API Boolean parameters
l_validate boolean;
e_crt_not_allowed exception; -- when mode is 'Update Only'
SELECT b.date_booking_placed
FROM ota_delegate_bookings b
WHERE b.booking_id = p_booking_id;
SELECT asg.assignment_id
FROM per_assignments_f asg,per_people_f per,PER_PERSON_TYPES PPT
WHERE per.person_id = asg.person_id
and ((asg.primary_flag = 'Y' and ppt.system_person_type in ('EMP','CWK','OTHER'))
OR (asg.assignment_type = 'A' and ppt.system_person_type ='APL'))
and (SYSDATE BETWEEN ASG.EFFECTIVE_START_DATE and ASG.EFFECTIVE_END_DATE)
and (SYSDATE BETWEEN per.EFFECTIVE_START_DATE AND per.EFFECTIVE_END_DATE)
and ppt.person_type_id = per.person_type_id and ppt.business_group_id = per.business_group_id
and per.person_id =p_delegate_person_id;
SELECT asg.assignment_id
FROM per_assignments_f asg,per_people_f per,PER_PERSON_TYPES PPT
WHERE per.person_id = asg.person_id
and ((asg.primary_flag = 'Y' and ppt.system_person_type in ('EMP','CWK','OTHER'))
OR (asg.assignment_type = 'A' and ppt.system_person_type ='APL'))
and (SYSDATE BETWEEN ASG.EFFECTIVE_START_DATE and ASG.EFFECTIVE_END_DATE)
and (SYSDATE BETWEEN per.EFFECTIVE_START_DATE AND per.EFFECTIVE_END_DATE)
and ppt.person_type_id = per.person_type_id and ppt.business_group_id = per.business_group_id
and per.person_id =p_sponsor_person_id;
l_create_flag := 2; --update booking
raise e_crt_not_allowed; -- Update only flag is enabled but Trying to Create
hr_utility.trace('SRK in wrapper_proc before update p_object_version_number '|| p_object_version_number);
select object_version_number into l_object_version_number
from ota_delegate_bookings where
booking_id = l_booking_id;
update_delegate_booking
(p_effective_date => p_effective_date
,p_booking_id => l_booking_id
,p_booking_status_type_id => l_enroll_rec.booking_status_type_id
,p_delegate_person_id => l_enroll_rec.delegate_person_id
,p_contact_id => l_enroll_rec.sponsor_contact_id
,p_business_group_id => l_enroll_rec.business_group_id
,p_event_id => l_enroll_rec.event_id
,p_customer_id => l_enroll_rec.customer_id
,p_authorizer_person_id => l_enroll_rec.authorizer_person_id
,p_date_booking_placed => l_enroll_rec.date_booking_placed
,p_corespondent => l_enroll_rec.correspondent
,p_internal_booking_flag => l_enroll_rec.internal_booking_flag
,p_number_of_places => l_enroll_rec.number_of_places
,p_object_version_number => l_object_version_number
,p_administrator => l_enroll_rec.administrator
,p_booking_priority => l_enroll_rec.booking_priority
,p_comments => l_enroll_rec.comments
,p_contact_address_id => l_enroll_rec.contact_address_id
,p_delegate_contact_phone => l_enroll_rec.correspondent_phone
,p_delegate_contact_fax => l_enroll_rec.correspondent_fax
,p_third_party_customer_id => l_enroll_rec.third_party_customer_id
,p_third_party_contact_id => l_enroll_rec.third_party_contact_id
,p_third_party_address_id => l_enroll_rec.third_party_address_id
,p_third_party_contact_phone => l_enroll_rec.third_party_contact_phone
,p_third_party_contact_fax => l_enroll_rec.third_party_contact_fax
,p_date_status_changed => l_enroll_rec.date_status_changed
-- ,p_status_change_comments => l_enroll_rec.status_change_comments
,p_failure_reason => l_enroll_rec.failure_reason
,p_attendance_result => l_enroll_rec.attendance_result
,p_language_id => l_enroll_rec.language_id
,p_source_of_booking => l_enroll_rec.source_of_booking
,p_special_booking_instructions => l_enroll_rec.special_booking_instructions
,p_successful_attendance_flag => l_enroll_rec.successful_attendance_flag
,p_tdb_information_category => l_enroll_rec.tdb_information_category
,p_tdb_information1 => l_enroll_rec.tdb_information1
,p_tdb_information2 => l_enroll_rec.tdb_information2
,p_tdb_information3 => l_enroll_rec.tdb_information3
,p_tdb_information4 => l_enroll_rec.tdb_information4
,p_tdb_information5 => l_enroll_rec.tdb_information5
,p_tdb_information6 => l_enroll_rec.tdb_information6
,p_tdb_information7 => l_enroll_rec.tdb_information7
,p_tdb_information8 => l_enroll_rec.tdb_information8
,p_tdb_information9 => l_enroll_rec.tdb_information9
,p_tdb_information10 => l_enroll_rec.tdb_information10
,p_tdb_information11 => l_enroll_rec.tdb_information11
,p_tdb_information12 => l_enroll_rec.tdb_information12
,p_tdb_information13 => l_enroll_rec.tdb_information13
,p_tdb_information14 => l_enroll_rec.tdb_information14
,p_tdb_information15 => l_enroll_rec.tdb_information15
,p_tdb_information16 => l_enroll_rec.tdb_information16
,p_tdb_information17 => l_enroll_rec.tdb_information17
,p_tdb_information18 => l_enroll_rec.tdb_information18
,p_tdb_information19 => l_enroll_rec.tdb_information19
,p_tdb_information20 => l_enroll_rec.tdb_information20
,p_update_finance_line => l_enroll_rec.finance_header_id
,p_tfl_object_version_number => l_tfl_object_version_number
,p_finance_header_id => l_enroll_rec.finance_header_id
,p_finance_line_id => p_finance_line_id
,p_standard_amount => l_enroll_rec.standard_amount
,p_unitary_amount => p_unitary_amount
,p_money_amount => l_enroll_rec.money_amount
,p_currency_code => l_enroll_rec.currency_code
,p_booking_deal_type => l_enroll_rec.booking_deal_type
,p_booking_deal_id => l_enroll_rec.booking_deal_id
,p_enrollment_type => p_enrollment_type
,p_validate => m_validate
,p_organization_id => l_enroll_rec.organization_id
,p_sponsor_person_id => l_enroll_rec.sponsor_person_id
,p_sponsor_assignment_id => l_enroll_rec.sponsor_assignment_id
,p_person_address_id => l_enroll_rec.person_address_id
,p_delegate_assignment_id => l_enroll_rec.delegate_assignment_id
,p_delegate_contact_id => l_enroll_rec.delegate_contact_id
,p_delegate_contact_email => l_enroll_rec.correspondent_email
,p_third_party_email => l_enroll_rec.third_party_email
,p_person_address_type => l_enroll_rec.correspondent_address_type
,p_line_id => l_enroll_rec.line_id
,p_org_id => l_enroll_rec.org_id
,p_daemon_flag => p_daemon_flag
,p_daemon_type => p_daemon_type
,p_old_event_id => l_enroll_rec.old_event_id
,p_quote_line_id => l_enroll_rec.quote_line_id
,p_interface_source => l_enroll_rec.interface_source
,p_total_training_time => l_enroll_rec.total_training_time
,p_content_player_status => l_enroll_rec.content_player_status
,p_score => l_enroll_rec.score
,p_completed_content => l_enroll_rec.completed_content
,p_total_content => l_enroll_rec.total_content
,p_return_status => p_return_status
,p_booking_justification_id => l_enroll_rec.booking_justification_id
,p_is_history_flag => p_is_history_flag
,p_override_prerequisites => p_override_prerequisites
,p_override_learner_access => p_override_learner_access
);
PROCEDURE update_delegate_booking
(p_effective_date in date default null
,p_booking_id in number
,p_booking_status_type_id in number default hr_api.g_number
,p_delegate_person_id in number default hr_api.g_number
,p_contact_id in number default hr_api.g_number
,p_business_group_id in number default hr_api.g_number
,p_event_id in number default hr_api.g_number
,p_customer_id in number default hr_api.g_number
,p_authorizer_person_id in number default hr_api.g_number
,p_date_booking_placed in date default hr_api.g_date
,p_corespondent in varchar2 default hr_api.g_varchar2
,p_internal_booking_flag in varchar2 default hr_api.g_varchar2
,p_number_of_places in number default hr_api.g_number
,p_object_version_number in out nocopy number
,p_administrator in number default hr_api.g_number
,p_booking_priority in varchar2 default hr_api.g_varchar2
,p_comments in varchar2 default hr_api.g_varchar2
,p_contact_address_id in number default hr_api.g_number
,p_delegate_contact_phone in varchar2 default hr_api.g_varchar2
,p_delegate_contact_fax in varchar2 default hr_api.g_varchar2
,p_third_party_customer_id in number default hr_api.g_number
,p_third_party_contact_id in number default hr_api.g_number
,p_third_party_address_id in number default hr_api.g_number
,p_third_party_contact_phone in varchar2 default hr_api.g_varchar2
,p_third_party_contact_fax in varchar2 default hr_api.g_varchar2
,p_date_status_changed in date default hr_api.g_date
,p_status_change_comments in varchar2 default hr_api.g_varchar2
,p_failure_reason in varchar2 default hr_api.g_varchar2
,p_attendance_result in varchar2 default hr_api.g_varchar2
,p_language_id in number default hr_api.g_number
,p_source_of_booking in varchar2 default hr_api.g_varchar2
,p_special_booking_instructions in varchar2 default hr_api.g_varchar2
,p_successful_attendance_flag in varchar2 default hr_api.g_varchar2
,p_tdb_information_category in varchar2 default hr_api.g_varchar2
,p_tdb_information1 in varchar2 default hr_api.g_varchar2
,p_tdb_information2 in varchar2 default hr_api.g_varchar2
,p_tdb_information3 in varchar2 default hr_api.g_varchar2
,p_tdb_information4 in varchar2 default hr_api.g_varchar2
,p_tdb_information5 in varchar2 default hr_api.g_varchar2
,p_tdb_information6 in varchar2 default hr_api.g_varchar2
,p_tdb_information7 in varchar2 default hr_api.g_varchar2
,p_tdb_information8 in varchar2 default hr_api.g_varchar2
,p_tdb_information9 in varchar2 default hr_api.g_varchar2
,p_tdb_information10 in varchar2 default hr_api.g_varchar2
,p_tdb_information11 in varchar2 default hr_api.g_varchar2
,p_tdb_information12 in varchar2 default hr_api.g_varchar2
,p_tdb_information13 in varchar2 default hr_api.g_varchar2
,p_tdb_information14 in varchar2 default hr_api.g_varchar2
,p_tdb_information15 in varchar2 default hr_api.g_varchar2
,p_tdb_information16 in varchar2 default hr_api.g_varchar2
,p_tdb_information17 in varchar2 default hr_api.g_varchar2
,p_tdb_information18 in varchar2 default hr_api.g_varchar2
,p_tdb_information19 in varchar2 default hr_api.g_varchar2
,p_tdb_information20 in varchar2 default hr_api.g_varchar2
,p_update_finance_line in varchar2 default hr_api.g_varchar2
,p_tfl_object_version_number in out nocopy number
,p_finance_header_id in number default hr_api.g_number
,p_finance_line_id in out nocopy number
,p_standard_amount in number default hr_api.g_number
,p_unitary_amount in number default hr_api.g_number
,p_money_amount in number default hr_api.g_number
,p_currency_code in varchar2 default hr_api.g_varchar2
,p_booking_deal_type in varchar2 default hr_api.g_varchar2
,p_booking_deal_id in number default hr_api.g_number
,p_enrollment_type in varchar2 default hr_api.g_varchar2
,p_validate in number default hr_api.g_false_num
,p_organization_id in number default hr_api.g_number
,p_sponsor_person_id in number default hr_api.g_number
,p_sponsor_assignment_id in number default hr_api.g_number
,p_person_address_id in number default hr_api.g_number
,p_delegate_assignment_id in number default hr_api.g_number
,p_delegate_contact_id in number default hr_api.g_number
,p_delegate_contact_email in varchar2 default hr_api.g_varchar2
,p_third_party_email in varchar2 default hr_api.g_varchar2
,p_person_address_type in varchar2 default hr_api.g_varchar2
,p_line_id in number default hr_api.g_number
,p_org_id in number default hr_api.g_number
,p_daemon_flag in varchar2 default hr_api.g_varchar2
,p_daemon_type in varchar2 default hr_api.g_varchar2
,p_old_event_id in number default hr_api.g_number
,p_quote_line_id in number default hr_api.g_number
,p_interface_source in varchar2 default hr_api.g_varchar2
,p_total_training_time in varchar2 default hr_api.g_varchar2
,p_content_player_status in varchar2 default hr_api.g_varchar2
,p_score in number default hr_api.g_number
,p_completed_content in number default hr_api.g_number
,p_total_content in number default hr_api.g_number
,p_return_status out nocopy varchar2
,p_booking_justification_id in number default hr_api.g_number
,p_is_history_flag in varchar2 default hr_api.g_varchar2
,p_override_prerequisites in varchar2
,p_override_learner_access in varchar2
) is
--
-- Variables for API Boolean parameters
l_validate boolean;
SELECT b.date_booking_placed
FROM ota_delegate_bookings b
WHERE b.booking_id = p_booking_id;
l_proc varchar2(72) := g_package ||'update_delegate_booking';
savepoint update_delegate_booking;
hr_utility.trace('SRK in update_deleg_booki booking p_booking_id '|| p_booking_id);
hr_utility.trace('SRK in update_deleg_booki before the api call p_booking_id '|| p_booking_id);
ota_delegate_booking_api.update_delegate_booking
(p_effective_date => p_effective_date
,p_booking_id => p_booking_id
,p_booking_status_type_id => p_booking_status_type_id
,p_delegate_person_id => p_delegate_person_id
,p_contact_id => p_contact_id
,p_business_group_id => p_business_group_id
,p_event_id => p_event_id
,p_customer_id => p_customer_id
,p_authorizer_person_id => p_authorizer_person_id
,p_date_booking_placed => l_date_booking_placed
,p_corespondent => p_corespondent
,p_internal_booking_flag => p_internal_booking_flag
,p_number_of_places => p_number_of_places
,p_object_version_number => p_object_version_number
,p_administrator => p_administrator
,p_booking_priority => p_booking_priority
,p_comments => p_comments
,p_contact_address_id => p_contact_address_id
,p_delegate_contact_phone => p_delegate_contact_phone
,p_delegate_contact_fax => p_delegate_contact_fax
,p_third_party_customer_id => p_third_party_customer_id
,p_third_party_contact_id => p_third_party_contact_id
,p_third_party_address_id => p_third_party_address_id
,p_third_party_contact_phone => p_third_party_contact_phone
,p_third_party_contact_fax => p_third_party_contact_fax
,p_date_status_changed => l_date_status_changed
,p_status_change_comments => p_status_change_comments
,p_failure_reason => p_failure_reason
,p_attendance_result => p_attendance_result
,p_language_id => p_language_id
,p_source_of_booking => p_source_of_booking
,p_special_booking_instructions => p_special_booking_instructions
,p_successful_attendance_flag => p_successful_attendance_flag
,p_tdb_information_category => p_tdb_information_category
,p_tdb_information1 => p_tdb_information1
,p_tdb_information2 => p_tdb_information2
,p_tdb_information3 => p_tdb_information3
,p_tdb_information4 => p_tdb_information4
,p_tdb_information5 => p_tdb_information5
,p_tdb_information6 => p_tdb_information6
,p_tdb_information7 => p_tdb_information7
,p_tdb_information8 => p_tdb_information8
,p_tdb_information9 => p_tdb_information9
,p_tdb_information10 => p_tdb_information10
,p_tdb_information11 => p_tdb_information11
,p_tdb_information12 => p_tdb_information12
,p_tdb_information13 => p_tdb_information13
,p_tdb_information14 => p_tdb_information14
,p_tdb_information15 => p_tdb_information15
,p_tdb_information16 => p_tdb_information16
,p_tdb_information17 => p_tdb_information17
,p_tdb_information18 => p_tdb_information18
,p_tdb_information19 => p_tdb_information19
,p_tdb_information20 => p_tdb_information20
,p_update_finance_line => p_update_finance_line
,p_tfl_object_version_number => l_tfl_object_version_number
,p_finance_header_id => p_finance_header_id
,p_finance_line_id => p_finance_line_id
,p_standard_amount => p_standard_amount
,p_unitary_amount => p_unitary_amount
,p_money_amount => p_money_amount
,p_currency_code => p_currency_code
,p_booking_deal_type => p_booking_deal_type
,p_booking_deal_id => p_booking_deal_id
,p_enrollment_type => p_enrollment_type
,p_validate => l_validate
,p_organization_id => p_organization_id
,p_sponsor_person_id => p_sponsor_person_id
,p_sponsor_assignment_id => p_sponsor_assignment_id
,p_person_address_id => p_person_address_id
,p_delegate_assignment_id => p_delegate_assignment_id
,p_delegate_contact_id => p_delegate_contact_id
,p_delegate_contact_email => p_delegate_contact_email
,p_third_party_email => p_third_party_email
,p_person_address_type => p_person_address_type
,p_line_id => p_line_id
,p_org_id => p_org_id
,p_daemon_flag => p_daemon_flag
,p_daemon_type => p_daemon_type
,p_old_event_id => p_old_event_id
,p_quote_line_id => p_quote_line_id
,p_interface_source => p_interface_source
,p_total_training_time => p_total_training_time
,p_content_player_status => p_content_player_status
,p_score => p_score
,p_completed_content => p_completed_content
,p_total_content => p_total_content
,p_booking_justification_id => p_booking_justification_id
,p_is_history_flag => p_is_history_flag
,p_override_prerequisites => p_override_prerequisites
,p_override_learner_access => p_override_learner_access
);
end update_delegate_booking;