DBA Data[Home] [Help]

APPS.PQP_RIW_ENROLL_WRAPPER dependencies on HR_API

Line 72: ,p_validate in number default hr_api.g_false_num

68: ,p_booking_deal_id in number default null
69: ,p_booking_deal_type in varchar2 default null
70: ,p_finance_line_id in out nocopy number
71: ,p_enrollment_type in varchar2 default null
72: ,p_validate in number default hr_api.g_false_num
73: ,p_organization_id in number default null
74: ,p_sponsor_person_id in number default null
75: ,p_sponsor_assignment_id in number default null
76: ,p_person_address_id in number default null

Line 100: ,p_status_change_comments in varchar2 default hr_api.g_varchar2

96: ,p_is_history_flag in varchar2 default 'N'
97: ,p_override_prerequisites in varchar2 default null
98: ,p_override_learner_access in varchar2 default null
99: ,P_CRT_UPD in varchar2 default null
100: ,p_status_change_comments in varchar2 default hr_api.g_varchar2
101: ,p_update_finance_line in varchar2 default hr_api.g_varchar2
102: ,p_tfl_object_version_number in number default null
103: ) is
104:

Line 101: ,p_update_finance_line in varchar2 default hr_api.g_varchar2

97: ,p_override_prerequisites in varchar2 default null
98: ,p_override_learner_access in varchar2 default null
99: ,P_CRT_UPD in varchar2 default null
100: ,p_status_change_comments in varchar2 default hr_api.g_varchar2
101: ,p_update_finance_line in varchar2 default hr_api.g_varchar2
102: ,p_tfl_object_version_number in number default null
103: ) is
104:
105: --

Line 121: -- p_status_change_comments varchar2(30) default hr_api.g_varchar2;

117: l_create_flag number;
118: l_error_msg varchar2(4000);
119: m_validate number :=0; -- No validation
120:
121: -- p_status_change_comments varchar2(30) default hr_api.g_varchar2;
122: -- p_update_finance_line varchar2(30) default hr_api.g_varchar2;
123: l_tfl_object_version_number number;
124: l_date_booking_placed ota_delegate_bookings.date_booking_placed%TYPE;
125: l_date_status_changed ota_delegate_bookings.date_status_changed%TYPE;

Line 122: -- p_update_finance_line varchar2(30) default hr_api.g_varchar2;

118: l_error_msg varchar2(4000);
119: m_validate number :=0; -- No validation
120:
121: -- p_status_change_comments varchar2(30) default hr_api.g_varchar2;
122: -- p_update_finance_line varchar2(30) default hr_api.g_varchar2;
123: l_tfl_object_version_number number;
124: l_date_booking_placed ota_delegate_bookings.date_booking_placed%TYPE;
125: l_date_status_changed ota_delegate_bookings.date_status_changed%TYPE;
126: c_delegate_assignment_id number default null;

Line 563: ,p_validate in number default hr_api.g_false_num

559: ,p_booking_deal_id in number default null
560: ,p_booking_deal_type in varchar2 default null
561: ,p_finance_line_id in out nocopy number
562: ,p_enrollment_type in varchar2 default null
563: ,p_validate in number default hr_api.g_false_num
564: ,p_organization_id in number default null
565: ,p_sponsor_person_id in number default null
566: ,p_sponsor_assignment_id in number default null
567: ,p_person_address_id in number default null

Line 619: hr_api.constant_to_boolean

615: --
616: -- Convert constant values to their corresponding boolean value
617: --
618: l_validate :=
619: hr_api.constant_to_boolean
620: (p_constant_value => p_validate);
621: --
622: -- Register Surrogate ID or user key values
623: --

Line 777: ,p_booking_status_type_id in number default hr_api.g_number

773:
774: PROCEDURE update_delegate_booking
775: (p_effective_date in date default null
776: ,p_booking_id in number
777: ,p_booking_status_type_id in number default hr_api.g_number
778: ,p_delegate_person_id in number default hr_api.g_number
779: ,p_contact_id in number default hr_api.g_number
780: ,p_business_group_id in number default hr_api.g_number
781: ,p_event_id in number default hr_api.g_number

Line 778: ,p_delegate_person_id in number default hr_api.g_number

774: PROCEDURE update_delegate_booking
775: (p_effective_date in date default null
776: ,p_booking_id in number
777: ,p_booking_status_type_id in number default hr_api.g_number
778: ,p_delegate_person_id in number default hr_api.g_number
779: ,p_contact_id in number default hr_api.g_number
780: ,p_business_group_id in number default hr_api.g_number
781: ,p_event_id in number default hr_api.g_number
782: ,p_customer_id in number default hr_api.g_number

Line 779: ,p_contact_id in number default hr_api.g_number

775: (p_effective_date in date default null
776: ,p_booking_id in number
777: ,p_booking_status_type_id in number default hr_api.g_number
778: ,p_delegate_person_id in number default hr_api.g_number
779: ,p_contact_id in number default hr_api.g_number
780: ,p_business_group_id in number default hr_api.g_number
781: ,p_event_id in number default hr_api.g_number
782: ,p_customer_id in number default hr_api.g_number
783: ,p_authorizer_person_id in number default hr_api.g_number

Line 780: ,p_business_group_id in number default hr_api.g_number

776: ,p_booking_id in number
777: ,p_booking_status_type_id in number default hr_api.g_number
778: ,p_delegate_person_id in number default hr_api.g_number
779: ,p_contact_id in number default hr_api.g_number
780: ,p_business_group_id in number default hr_api.g_number
781: ,p_event_id in number default hr_api.g_number
782: ,p_customer_id in number default hr_api.g_number
783: ,p_authorizer_person_id in number default hr_api.g_number
784: ,p_date_booking_placed in date default hr_api.g_date

Line 781: ,p_event_id in number default hr_api.g_number

777: ,p_booking_status_type_id in number default hr_api.g_number
778: ,p_delegate_person_id in number default hr_api.g_number
779: ,p_contact_id in number default hr_api.g_number
780: ,p_business_group_id in number default hr_api.g_number
781: ,p_event_id in number default hr_api.g_number
782: ,p_customer_id in number default hr_api.g_number
783: ,p_authorizer_person_id in number default hr_api.g_number
784: ,p_date_booking_placed in date default hr_api.g_date
785: ,p_corespondent in varchar2 default hr_api.g_varchar2

Line 782: ,p_customer_id in number default hr_api.g_number

778: ,p_delegate_person_id in number default hr_api.g_number
779: ,p_contact_id in number default hr_api.g_number
780: ,p_business_group_id in number default hr_api.g_number
781: ,p_event_id in number default hr_api.g_number
782: ,p_customer_id in number default hr_api.g_number
783: ,p_authorizer_person_id in number default hr_api.g_number
784: ,p_date_booking_placed in date default hr_api.g_date
785: ,p_corespondent in varchar2 default hr_api.g_varchar2
786: ,p_internal_booking_flag in varchar2 default hr_api.g_varchar2

Line 783: ,p_authorizer_person_id in number default hr_api.g_number

779: ,p_contact_id in number default hr_api.g_number
780: ,p_business_group_id in number default hr_api.g_number
781: ,p_event_id in number default hr_api.g_number
782: ,p_customer_id in number default hr_api.g_number
783: ,p_authorizer_person_id in number default hr_api.g_number
784: ,p_date_booking_placed in date default hr_api.g_date
785: ,p_corespondent in varchar2 default hr_api.g_varchar2
786: ,p_internal_booking_flag in varchar2 default hr_api.g_varchar2
787: ,p_number_of_places in number default hr_api.g_number

Line 784: ,p_date_booking_placed in date default hr_api.g_date

780: ,p_business_group_id in number default hr_api.g_number
781: ,p_event_id in number default hr_api.g_number
782: ,p_customer_id in number default hr_api.g_number
783: ,p_authorizer_person_id in number default hr_api.g_number
784: ,p_date_booking_placed in date default hr_api.g_date
785: ,p_corespondent in varchar2 default hr_api.g_varchar2
786: ,p_internal_booking_flag in varchar2 default hr_api.g_varchar2
787: ,p_number_of_places in number default hr_api.g_number
788: ,p_object_version_number in out nocopy number

Line 785: ,p_corespondent in varchar2 default hr_api.g_varchar2

781: ,p_event_id in number default hr_api.g_number
782: ,p_customer_id in number default hr_api.g_number
783: ,p_authorizer_person_id in number default hr_api.g_number
784: ,p_date_booking_placed in date default hr_api.g_date
785: ,p_corespondent in varchar2 default hr_api.g_varchar2
786: ,p_internal_booking_flag in varchar2 default hr_api.g_varchar2
787: ,p_number_of_places in number default hr_api.g_number
788: ,p_object_version_number in out nocopy number
789: ,p_administrator in number default hr_api.g_number

Line 786: ,p_internal_booking_flag in varchar2 default hr_api.g_varchar2

782: ,p_customer_id in number default hr_api.g_number
783: ,p_authorizer_person_id in number default hr_api.g_number
784: ,p_date_booking_placed in date default hr_api.g_date
785: ,p_corespondent in varchar2 default hr_api.g_varchar2
786: ,p_internal_booking_flag in varchar2 default hr_api.g_varchar2
787: ,p_number_of_places in number default hr_api.g_number
788: ,p_object_version_number in out nocopy number
789: ,p_administrator in number default hr_api.g_number
790: ,p_booking_priority in varchar2 default hr_api.g_varchar2

Line 787: ,p_number_of_places in number default hr_api.g_number

783: ,p_authorizer_person_id in number default hr_api.g_number
784: ,p_date_booking_placed in date default hr_api.g_date
785: ,p_corespondent in varchar2 default hr_api.g_varchar2
786: ,p_internal_booking_flag in varchar2 default hr_api.g_varchar2
787: ,p_number_of_places in number default hr_api.g_number
788: ,p_object_version_number in out nocopy number
789: ,p_administrator in number default hr_api.g_number
790: ,p_booking_priority in varchar2 default hr_api.g_varchar2
791: ,p_comments in varchar2 default hr_api.g_varchar2

Line 789: ,p_administrator in number default hr_api.g_number

785: ,p_corespondent in varchar2 default hr_api.g_varchar2
786: ,p_internal_booking_flag in varchar2 default hr_api.g_varchar2
787: ,p_number_of_places in number default hr_api.g_number
788: ,p_object_version_number in out nocopy number
789: ,p_administrator in number default hr_api.g_number
790: ,p_booking_priority in varchar2 default hr_api.g_varchar2
791: ,p_comments in varchar2 default hr_api.g_varchar2
792: ,p_contact_address_id in number default hr_api.g_number
793: ,p_delegate_contact_phone in varchar2 default hr_api.g_varchar2

Line 790: ,p_booking_priority in varchar2 default hr_api.g_varchar2

786: ,p_internal_booking_flag in varchar2 default hr_api.g_varchar2
787: ,p_number_of_places in number default hr_api.g_number
788: ,p_object_version_number in out nocopy number
789: ,p_administrator in number default hr_api.g_number
790: ,p_booking_priority in varchar2 default hr_api.g_varchar2
791: ,p_comments in varchar2 default hr_api.g_varchar2
792: ,p_contact_address_id in number default hr_api.g_number
793: ,p_delegate_contact_phone in varchar2 default hr_api.g_varchar2
794: ,p_delegate_contact_fax in varchar2 default hr_api.g_varchar2

Line 791: ,p_comments in varchar2 default hr_api.g_varchar2

787: ,p_number_of_places in number default hr_api.g_number
788: ,p_object_version_number in out nocopy number
789: ,p_administrator in number default hr_api.g_number
790: ,p_booking_priority in varchar2 default hr_api.g_varchar2
791: ,p_comments in varchar2 default hr_api.g_varchar2
792: ,p_contact_address_id in number default hr_api.g_number
793: ,p_delegate_contact_phone in varchar2 default hr_api.g_varchar2
794: ,p_delegate_contact_fax in varchar2 default hr_api.g_varchar2
795: ,p_third_party_customer_id in number default hr_api.g_number

Line 792: ,p_contact_address_id in number default hr_api.g_number

788: ,p_object_version_number in out nocopy number
789: ,p_administrator in number default hr_api.g_number
790: ,p_booking_priority in varchar2 default hr_api.g_varchar2
791: ,p_comments in varchar2 default hr_api.g_varchar2
792: ,p_contact_address_id in number default hr_api.g_number
793: ,p_delegate_contact_phone in varchar2 default hr_api.g_varchar2
794: ,p_delegate_contact_fax in varchar2 default hr_api.g_varchar2
795: ,p_third_party_customer_id in number default hr_api.g_number
796: ,p_third_party_contact_id in number default hr_api.g_number

Line 793: ,p_delegate_contact_phone in varchar2 default hr_api.g_varchar2

789: ,p_administrator in number default hr_api.g_number
790: ,p_booking_priority in varchar2 default hr_api.g_varchar2
791: ,p_comments in varchar2 default hr_api.g_varchar2
792: ,p_contact_address_id in number default hr_api.g_number
793: ,p_delegate_contact_phone in varchar2 default hr_api.g_varchar2
794: ,p_delegate_contact_fax in varchar2 default hr_api.g_varchar2
795: ,p_third_party_customer_id in number default hr_api.g_number
796: ,p_third_party_contact_id in number default hr_api.g_number
797: ,p_third_party_address_id in number default hr_api.g_number

Line 794: ,p_delegate_contact_fax in varchar2 default hr_api.g_varchar2

790: ,p_booking_priority in varchar2 default hr_api.g_varchar2
791: ,p_comments in varchar2 default hr_api.g_varchar2
792: ,p_contact_address_id in number default hr_api.g_number
793: ,p_delegate_contact_phone in varchar2 default hr_api.g_varchar2
794: ,p_delegate_contact_fax in varchar2 default hr_api.g_varchar2
795: ,p_third_party_customer_id in number default hr_api.g_number
796: ,p_third_party_contact_id in number default hr_api.g_number
797: ,p_third_party_address_id in number default hr_api.g_number
798: ,p_third_party_contact_phone in varchar2 default hr_api.g_varchar2

Line 795: ,p_third_party_customer_id in number default hr_api.g_number

791: ,p_comments in varchar2 default hr_api.g_varchar2
792: ,p_contact_address_id in number default hr_api.g_number
793: ,p_delegate_contact_phone in varchar2 default hr_api.g_varchar2
794: ,p_delegate_contact_fax in varchar2 default hr_api.g_varchar2
795: ,p_third_party_customer_id in number default hr_api.g_number
796: ,p_third_party_contact_id in number default hr_api.g_number
797: ,p_third_party_address_id in number default hr_api.g_number
798: ,p_third_party_contact_phone in varchar2 default hr_api.g_varchar2
799: ,p_third_party_contact_fax in varchar2 default hr_api.g_varchar2

Line 796: ,p_third_party_contact_id in number default hr_api.g_number

792: ,p_contact_address_id in number default hr_api.g_number
793: ,p_delegate_contact_phone in varchar2 default hr_api.g_varchar2
794: ,p_delegate_contact_fax in varchar2 default hr_api.g_varchar2
795: ,p_third_party_customer_id in number default hr_api.g_number
796: ,p_third_party_contact_id in number default hr_api.g_number
797: ,p_third_party_address_id in number default hr_api.g_number
798: ,p_third_party_contact_phone in varchar2 default hr_api.g_varchar2
799: ,p_third_party_contact_fax in varchar2 default hr_api.g_varchar2
800: ,p_date_status_changed in date default hr_api.g_date

Line 797: ,p_third_party_address_id in number default hr_api.g_number

793: ,p_delegate_contact_phone in varchar2 default hr_api.g_varchar2
794: ,p_delegate_contact_fax in varchar2 default hr_api.g_varchar2
795: ,p_third_party_customer_id in number default hr_api.g_number
796: ,p_third_party_contact_id in number default hr_api.g_number
797: ,p_third_party_address_id in number default hr_api.g_number
798: ,p_third_party_contact_phone in varchar2 default hr_api.g_varchar2
799: ,p_third_party_contact_fax in varchar2 default hr_api.g_varchar2
800: ,p_date_status_changed in date default hr_api.g_date
801: ,p_status_change_comments in varchar2 default hr_api.g_varchar2

Line 798: ,p_third_party_contact_phone in varchar2 default hr_api.g_varchar2

794: ,p_delegate_contact_fax in varchar2 default hr_api.g_varchar2
795: ,p_third_party_customer_id in number default hr_api.g_number
796: ,p_third_party_contact_id in number default hr_api.g_number
797: ,p_third_party_address_id in number default hr_api.g_number
798: ,p_third_party_contact_phone in varchar2 default hr_api.g_varchar2
799: ,p_third_party_contact_fax in varchar2 default hr_api.g_varchar2
800: ,p_date_status_changed in date default hr_api.g_date
801: ,p_status_change_comments in varchar2 default hr_api.g_varchar2
802: ,p_failure_reason in varchar2 default hr_api.g_varchar2

Line 799: ,p_third_party_contact_fax in varchar2 default hr_api.g_varchar2

795: ,p_third_party_customer_id in number default hr_api.g_number
796: ,p_third_party_contact_id in number default hr_api.g_number
797: ,p_third_party_address_id in number default hr_api.g_number
798: ,p_third_party_contact_phone in varchar2 default hr_api.g_varchar2
799: ,p_third_party_contact_fax in varchar2 default hr_api.g_varchar2
800: ,p_date_status_changed in date default hr_api.g_date
801: ,p_status_change_comments in varchar2 default hr_api.g_varchar2
802: ,p_failure_reason in varchar2 default hr_api.g_varchar2
803: ,p_attendance_result in varchar2 default hr_api.g_varchar2

Line 800: ,p_date_status_changed in date default hr_api.g_date

796: ,p_third_party_contact_id in number default hr_api.g_number
797: ,p_third_party_address_id in number default hr_api.g_number
798: ,p_third_party_contact_phone in varchar2 default hr_api.g_varchar2
799: ,p_third_party_contact_fax in varchar2 default hr_api.g_varchar2
800: ,p_date_status_changed in date default hr_api.g_date
801: ,p_status_change_comments in varchar2 default hr_api.g_varchar2
802: ,p_failure_reason in varchar2 default hr_api.g_varchar2
803: ,p_attendance_result in varchar2 default hr_api.g_varchar2
804: ,p_language_id in number default hr_api.g_number

Line 801: ,p_status_change_comments in varchar2 default hr_api.g_varchar2

797: ,p_third_party_address_id in number default hr_api.g_number
798: ,p_third_party_contact_phone in varchar2 default hr_api.g_varchar2
799: ,p_third_party_contact_fax in varchar2 default hr_api.g_varchar2
800: ,p_date_status_changed in date default hr_api.g_date
801: ,p_status_change_comments in varchar2 default hr_api.g_varchar2
802: ,p_failure_reason in varchar2 default hr_api.g_varchar2
803: ,p_attendance_result in varchar2 default hr_api.g_varchar2
804: ,p_language_id in number default hr_api.g_number
805: ,p_source_of_booking in varchar2 default hr_api.g_varchar2

Line 802: ,p_failure_reason in varchar2 default hr_api.g_varchar2

798: ,p_third_party_contact_phone in varchar2 default hr_api.g_varchar2
799: ,p_third_party_contact_fax in varchar2 default hr_api.g_varchar2
800: ,p_date_status_changed in date default hr_api.g_date
801: ,p_status_change_comments in varchar2 default hr_api.g_varchar2
802: ,p_failure_reason in varchar2 default hr_api.g_varchar2
803: ,p_attendance_result in varchar2 default hr_api.g_varchar2
804: ,p_language_id in number default hr_api.g_number
805: ,p_source_of_booking in varchar2 default hr_api.g_varchar2
806: ,p_special_booking_instructions in varchar2 default hr_api.g_varchar2

Line 803: ,p_attendance_result in varchar2 default hr_api.g_varchar2

799: ,p_third_party_contact_fax in varchar2 default hr_api.g_varchar2
800: ,p_date_status_changed in date default hr_api.g_date
801: ,p_status_change_comments in varchar2 default hr_api.g_varchar2
802: ,p_failure_reason in varchar2 default hr_api.g_varchar2
803: ,p_attendance_result in varchar2 default hr_api.g_varchar2
804: ,p_language_id in number default hr_api.g_number
805: ,p_source_of_booking in varchar2 default hr_api.g_varchar2
806: ,p_special_booking_instructions in varchar2 default hr_api.g_varchar2
807: ,p_successful_attendance_flag in varchar2 default hr_api.g_varchar2

Line 804: ,p_language_id in number default hr_api.g_number

800: ,p_date_status_changed in date default hr_api.g_date
801: ,p_status_change_comments in varchar2 default hr_api.g_varchar2
802: ,p_failure_reason in varchar2 default hr_api.g_varchar2
803: ,p_attendance_result in varchar2 default hr_api.g_varchar2
804: ,p_language_id in number default hr_api.g_number
805: ,p_source_of_booking in varchar2 default hr_api.g_varchar2
806: ,p_special_booking_instructions in varchar2 default hr_api.g_varchar2
807: ,p_successful_attendance_flag in varchar2 default hr_api.g_varchar2
808: ,p_tdb_information_category in varchar2 default hr_api.g_varchar2

Line 805: ,p_source_of_booking in varchar2 default hr_api.g_varchar2

801: ,p_status_change_comments in varchar2 default hr_api.g_varchar2
802: ,p_failure_reason in varchar2 default hr_api.g_varchar2
803: ,p_attendance_result in varchar2 default hr_api.g_varchar2
804: ,p_language_id in number default hr_api.g_number
805: ,p_source_of_booking in varchar2 default hr_api.g_varchar2
806: ,p_special_booking_instructions in varchar2 default hr_api.g_varchar2
807: ,p_successful_attendance_flag in varchar2 default hr_api.g_varchar2
808: ,p_tdb_information_category in varchar2 default hr_api.g_varchar2
809: ,p_tdb_information1 in varchar2 default hr_api.g_varchar2

Line 806: ,p_special_booking_instructions in varchar2 default hr_api.g_varchar2

802: ,p_failure_reason in varchar2 default hr_api.g_varchar2
803: ,p_attendance_result in varchar2 default hr_api.g_varchar2
804: ,p_language_id in number default hr_api.g_number
805: ,p_source_of_booking in varchar2 default hr_api.g_varchar2
806: ,p_special_booking_instructions in varchar2 default hr_api.g_varchar2
807: ,p_successful_attendance_flag in varchar2 default hr_api.g_varchar2
808: ,p_tdb_information_category in varchar2 default hr_api.g_varchar2
809: ,p_tdb_information1 in varchar2 default hr_api.g_varchar2
810: ,p_tdb_information2 in varchar2 default hr_api.g_varchar2

Line 807: ,p_successful_attendance_flag in varchar2 default hr_api.g_varchar2

803: ,p_attendance_result in varchar2 default hr_api.g_varchar2
804: ,p_language_id in number default hr_api.g_number
805: ,p_source_of_booking in varchar2 default hr_api.g_varchar2
806: ,p_special_booking_instructions in varchar2 default hr_api.g_varchar2
807: ,p_successful_attendance_flag in varchar2 default hr_api.g_varchar2
808: ,p_tdb_information_category in varchar2 default hr_api.g_varchar2
809: ,p_tdb_information1 in varchar2 default hr_api.g_varchar2
810: ,p_tdb_information2 in varchar2 default hr_api.g_varchar2
811: ,p_tdb_information3 in varchar2 default hr_api.g_varchar2

Line 808: ,p_tdb_information_category in varchar2 default hr_api.g_varchar2

804: ,p_language_id in number default hr_api.g_number
805: ,p_source_of_booking in varchar2 default hr_api.g_varchar2
806: ,p_special_booking_instructions in varchar2 default hr_api.g_varchar2
807: ,p_successful_attendance_flag in varchar2 default hr_api.g_varchar2
808: ,p_tdb_information_category in varchar2 default hr_api.g_varchar2
809: ,p_tdb_information1 in varchar2 default hr_api.g_varchar2
810: ,p_tdb_information2 in varchar2 default hr_api.g_varchar2
811: ,p_tdb_information3 in varchar2 default hr_api.g_varchar2
812: ,p_tdb_information4 in varchar2 default hr_api.g_varchar2

Line 809: ,p_tdb_information1 in varchar2 default hr_api.g_varchar2

805: ,p_source_of_booking in varchar2 default hr_api.g_varchar2
806: ,p_special_booking_instructions in varchar2 default hr_api.g_varchar2
807: ,p_successful_attendance_flag in varchar2 default hr_api.g_varchar2
808: ,p_tdb_information_category in varchar2 default hr_api.g_varchar2
809: ,p_tdb_information1 in varchar2 default hr_api.g_varchar2
810: ,p_tdb_information2 in varchar2 default hr_api.g_varchar2
811: ,p_tdb_information3 in varchar2 default hr_api.g_varchar2
812: ,p_tdb_information4 in varchar2 default hr_api.g_varchar2
813: ,p_tdb_information5 in varchar2 default hr_api.g_varchar2

Line 810: ,p_tdb_information2 in varchar2 default hr_api.g_varchar2

806: ,p_special_booking_instructions in varchar2 default hr_api.g_varchar2
807: ,p_successful_attendance_flag in varchar2 default hr_api.g_varchar2
808: ,p_tdb_information_category in varchar2 default hr_api.g_varchar2
809: ,p_tdb_information1 in varchar2 default hr_api.g_varchar2
810: ,p_tdb_information2 in varchar2 default hr_api.g_varchar2
811: ,p_tdb_information3 in varchar2 default hr_api.g_varchar2
812: ,p_tdb_information4 in varchar2 default hr_api.g_varchar2
813: ,p_tdb_information5 in varchar2 default hr_api.g_varchar2
814: ,p_tdb_information6 in varchar2 default hr_api.g_varchar2

Line 811: ,p_tdb_information3 in varchar2 default hr_api.g_varchar2

807: ,p_successful_attendance_flag in varchar2 default hr_api.g_varchar2
808: ,p_tdb_information_category in varchar2 default hr_api.g_varchar2
809: ,p_tdb_information1 in varchar2 default hr_api.g_varchar2
810: ,p_tdb_information2 in varchar2 default hr_api.g_varchar2
811: ,p_tdb_information3 in varchar2 default hr_api.g_varchar2
812: ,p_tdb_information4 in varchar2 default hr_api.g_varchar2
813: ,p_tdb_information5 in varchar2 default hr_api.g_varchar2
814: ,p_tdb_information6 in varchar2 default hr_api.g_varchar2
815: ,p_tdb_information7 in varchar2 default hr_api.g_varchar2

Line 812: ,p_tdb_information4 in varchar2 default hr_api.g_varchar2

808: ,p_tdb_information_category in varchar2 default hr_api.g_varchar2
809: ,p_tdb_information1 in varchar2 default hr_api.g_varchar2
810: ,p_tdb_information2 in varchar2 default hr_api.g_varchar2
811: ,p_tdb_information3 in varchar2 default hr_api.g_varchar2
812: ,p_tdb_information4 in varchar2 default hr_api.g_varchar2
813: ,p_tdb_information5 in varchar2 default hr_api.g_varchar2
814: ,p_tdb_information6 in varchar2 default hr_api.g_varchar2
815: ,p_tdb_information7 in varchar2 default hr_api.g_varchar2
816: ,p_tdb_information8 in varchar2 default hr_api.g_varchar2

Line 813: ,p_tdb_information5 in varchar2 default hr_api.g_varchar2

809: ,p_tdb_information1 in varchar2 default hr_api.g_varchar2
810: ,p_tdb_information2 in varchar2 default hr_api.g_varchar2
811: ,p_tdb_information3 in varchar2 default hr_api.g_varchar2
812: ,p_tdb_information4 in varchar2 default hr_api.g_varchar2
813: ,p_tdb_information5 in varchar2 default hr_api.g_varchar2
814: ,p_tdb_information6 in varchar2 default hr_api.g_varchar2
815: ,p_tdb_information7 in varchar2 default hr_api.g_varchar2
816: ,p_tdb_information8 in varchar2 default hr_api.g_varchar2
817: ,p_tdb_information9 in varchar2 default hr_api.g_varchar2

Line 814: ,p_tdb_information6 in varchar2 default hr_api.g_varchar2

810: ,p_tdb_information2 in varchar2 default hr_api.g_varchar2
811: ,p_tdb_information3 in varchar2 default hr_api.g_varchar2
812: ,p_tdb_information4 in varchar2 default hr_api.g_varchar2
813: ,p_tdb_information5 in varchar2 default hr_api.g_varchar2
814: ,p_tdb_information6 in varchar2 default hr_api.g_varchar2
815: ,p_tdb_information7 in varchar2 default hr_api.g_varchar2
816: ,p_tdb_information8 in varchar2 default hr_api.g_varchar2
817: ,p_tdb_information9 in varchar2 default hr_api.g_varchar2
818: ,p_tdb_information10 in varchar2 default hr_api.g_varchar2

Line 815: ,p_tdb_information7 in varchar2 default hr_api.g_varchar2

811: ,p_tdb_information3 in varchar2 default hr_api.g_varchar2
812: ,p_tdb_information4 in varchar2 default hr_api.g_varchar2
813: ,p_tdb_information5 in varchar2 default hr_api.g_varchar2
814: ,p_tdb_information6 in varchar2 default hr_api.g_varchar2
815: ,p_tdb_information7 in varchar2 default hr_api.g_varchar2
816: ,p_tdb_information8 in varchar2 default hr_api.g_varchar2
817: ,p_tdb_information9 in varchar2 default hr_api.g_varchar2
818: ,p_tdb_information10 in varchar2 default hr_api.g_varchar2
819: ,p_tdb_information11 in varchar2 default hr_api.g_varchar2

Line 816: ,p_tdb_information8 in varchar2 default hr_api.g_varchar2

812: ,p_tdb_information4 in varchar2 default hr_api.g_varchar2
813: ,p_tdb_information5 in varchar2 default hr_api.g_varchar2
814: ,p_tdb_information6 in varchar2 default hr_api.g_varchar2
815: ,p_tdb_information7 in varchar2 default hr_api.g_varchar2
816: ,p_tdb_information8 in varchar2 default hr_api.g_varchar2
817: ,p_tdb_information9 in varchar2 default hr_api.g_varchar2
818: ,p_tdb_information10 in varchar2 default hr_api.g_varchar2
819: ,p_tdb_information11 in varchar2 default hr_api.g_varchar2
820: ,p_tdb_information12 in varchar2 default hr_api.g_varchar2

Line 817: ,p_tdb_information9 in varchar2 default hr_api.g_varchar2

813: ,p_tdb_information5 in varchar2 default hr_api.g_varchar2
814: ,p_tdb_information6 in varchar2 default hr_api.g_varchar2
815: ,p_tdb_information7 in varchar2 default hr_api.g_varchar2
816: ,p_tdb_information8 in varchar2 default hr_api.g_varchar2
817: ,p_tdb_information9 in varchar2 default hr_api.g_varchar2
818: ,p_tdb_information10 in varchar2 default hr_api.g_varchar2
819: ,p_tdb_information11 in varchar2 default hr_api.g_varchar2
820: ,p_tdb_information12 in varchar2 default hr_api.g_varchar2
821: ,p_tdb_information13 in varchar2 default hr_api.g_varchar2

Line 818: ,p_tdb_information10 in varchar2 default hr_api.g_varchar2

814: ,p_tdb_information6 in varchar2 default hr_api.g_varchar2
815: ,p_tdb_information7 in varchar2 default hr_api.g_varchar2
816: ,p_tdb_information8 in varchar2 default hr_api.g_varchar2
817: ,p_tdb_information9 in varchar2 default hr_api.g_varchar2
818: ,p_tdb_information10 in varchar2 default hr_api.g_varchar2
819: ,p_tdb_information11 in varchar2 default hr_api.g_varchar2
820: ,p_tdb_information12 in varchar2 default hr_api.g_varchar2
821: ,p_tdb_information13 in varchar2 default hr_api.g_varchar2
822: ,p_tdb_information14 in varchar2 default hr_api.g_varchar2

Line 819: ,p_tdb_information11 in varchar2 default hr_api.g_varchar2

815: ,p_tdb_information7 in varchar2 default hr_api.g_varchar2
816: ,p_tdb_information8 in varchar2 default hr_api.g_varchar2
817: ,p_tdb_information9 in varchar2 default hr_api.g_varchar2
818: ,p_tdb_information10 in varchar2 default hr_api.g_varchar2
819: ,p_tdb_information11 in varchar2 default hr_api.g_varchar2
820: ,p_tdb_information12 in varchar2 default hr_api.g_varchar2
821: ,p_tdb_information13 in varchar2 default hr_api.g_varchar2
822: ,p_tdb_information14 in varchar2 default hr_api.g_varchar2
823: ,p_tdb_information15 in varchar2 default hr_api.g_varchar2

Line 820: ,p_tdb_information12 in varchar2 default hr_api.g_varchar2

816: ,p_tdb_information8 in varchar2 default hr_api.g_varchar2
817: ,p_tdb_information9 in varchar2 default hr_api.g_varchar2
818: ,p_tdb_information10 in varchar2 default hr_api.g_varchar2
819: ,p_tdb_information11 in varchar2 default hr_api.g_varchar2
820: ,p_tdb_information12 in varchar2 default hr_api.g_varchar2
821: ,p_tdb_information13 in varchar2 default hr_api.g_varchar2
822: ,p_tdb_information14 in varchar2 default hr_api.g_varchar2
823: ,p_tdb_information15 in varchar2 default hr_api.g_varchar2
824: ,p_tdb_information16 in varchar2 default hr_api.g_varchar2

Line 821: ,p_tdb_information13 in varchar2 default hr_api.g_varchar2

817: ,p_tdb_information9 in varchar2 default hr_api.g_varchar2
818: ,p_tdb_information10 in varchar2 default hr_api.g_varchar2
819: ,p_tdb_information11 in varchar2 default hr_api.g_varchar2
820: ,p_tdb_information12 in varchar2 default hr_api.g_varchar2
821: ,p_tdb_information13 in varchar2 default hr_api.g_varchar2
822: ,p_tdb_information14 in varchar2 default hr_api.g_varchar2
823: ,p_tdb_information15 in varchar2 default hr_api.g_varchar2
824: ,p_tdb_information16 in varchar2 default hr_api.g_varchar2
825: ,p_tdb_information17 in varchar2 default hr_api.g_varchar2

Line 822: ,p_tdb_information14 in varchar2 default hr_api.g_varchar2

818: ,p_tdb_information10 in varchar2 default hr_api.g_varchar2
819: ,p_tdb_information11 in varchar2 default hr_api.g_varchar2
820: ,p_tdb_information12 in varchar2 default hr_api.g_varchar2
821: ,p_tdb_information13 in varchar2 default hr_api.g_varchar2
822: ,p_tdb_information14 in varchar2 default hr_api.g_varchar2
823: ,p_tdb_information15 in varchar2 default hr_api.g_varchar2
824: ,p_tdb_information16 in varchar2 default hr_api.g_varchar2
825: ,p_tdb_information17 in varchar2 default hr_api.g_varchar2
826: ,p_tdb_information18 in varchar2 default hr_api.g_varchar2

Line 823: ,p_tdb_information15 in varchar2 default hr_api.g_varchar2

819: ,p_tdb_information11 in varchar2 default hr_api.g_varchar2
820: ,p_tdb_information12 in varchar2 default hr_api.g_varchar2
821: ,p_tdb_information13 in varchar2 default hr_api.g_varchar2
822: ,p_tdb_information14 in varchar2 default hr_api.g_varchar2
823: ,p_tdb_information15 in varchar2 default hr_api.g_varchar2
824: ,p_tdb_information16 in varchar2 default hr_api.g_varchar2
825: ,p_tdb_information17 in varchar2 default hr_api.g_varchar2
826: ,p_tdb_information18 in varchar2 default hr_api.g_varchar2
827: ,p_tdb_information19 in varchar2 default hr_api.g_varchar2

Line 824: ,p_tdb_information16 in varchar2 default hr_api.g_varchar2

820: ,p_tdb_information12 in varchar2 default hr_api.g_varchar2
821: ,p_tdb_information13 in varchar2 default hr_api.g_varchar2
822: ,p_tdb_information14 in varchar2 default hr_api.g_varchar2
823: ,p_tdb_information15 in varchar2 default hr_api.g_varchar2
824: ,p_tdb_information16 in varchar2 default hr_api.g_varchar2
825: ,p_tdb_information17 in varchar2 default hr_api.g_varchar2
826: ,p_tdb_information18 in varchar2 default hr_api.g_varchar2
827: ,p_tdb_information19 in varchar2 default hr_api.g_varchar2
828: ,p_tdb_information20 in varchar2 default hr_api.g_varchar2

Line 825: ,p_tdb_information17 in varchar2 default hr_api.g_varchar2

821: ,p_tdb_information13 in varchar2 default hr_api.g_varchar2
822: ,p_tdb_information14 in varchar2 default hr_api.g_varchar2
823: ,p_tdb_information15 in varchar2 default hr_api.g_varchar2
824: ,p_tdb_information16 in varchar2 default hr_api.g_varchar2
825: ,p_tdb_information17 in varchar2 default hr_api.g_varchar2
826: ,p_tdb_information18 in varchar2 default hr_api.g_varchar2
827: ,p_tdb_information19 in varchar2 default hr_api.g_varchar2
828: ,p_tdb_information20 in varchar2 default hr_api.g_varchar2
829: ,p_update_finance_line in varchar2 default hr_api.g_varchar2

Line 826: ,p_tdb_information18 in varchar2 default hr_api.g_varchar2

822: ,p_tdb_information14 in varchar2 default hr_api.g_varchar2
823: ,p_tdb_information15 in varchar2 default hr_api.g_varchar2
824: ,p_tdb_information16 in varchar2 default hr_api.g_varchar2
825: ,p_tdb_information17 in varchar2 default hr_api.g_varchar2
826: ,p_tdb_information18 in varchar2 default hr_api.g_varchar2
827: ,p_tdb_information19 in varchar2 default hr_api.g_varchar2
828: ,p_tdb_information20 in varchar2 default hr_api.g_varchar2
829: ,p_update_finance_line in varchar2 default hr_api.g_varchar2
830: ,p_tfl_object_version_number in out nocopy number

Line 827: ,p_tdb_information19 in varchar2 default hr_api.g_varchar2

823: ,p_tdb_information15 in varchar2 default hr_api.g_varchar2
824: ,p_tdb_information16 in varchar2 default hr_api.g_varchar2
825: ,p_tdb_information17 in varchar2 default hr_api.g_varchar2
826: ,p_tdb_information18 in varchar2 default hr_api.g_varchar2
827: ,p_tdb_information19 in varchar2 default hr_api.g_varchar2
828: ,p_tdb_information20 in varchar2 default hr_api.g_varchar2
829: ,p_update_finance_line in varchar2 default hr_api.g_varchar2
830: ,p_tfl_object_version_number in out nocopy number
831: ,p_finance_header_id in number default hr_api.g_number

Line 828: ,p_tdb_information20 in varchar2 default hr_api.g_varchar2

824: ,p_tdb_information16 in varchar2 default hr_api.g_varchar2
825: ,p_tdb_information17 in varchar2 default hr_api.g_varchar2
826: ,p_tdb_information18 in varchar2 default hr_api.g_varchar2
827: ,p_tdb_information19 in varchar2 default hr_api.g_varchar2
828: ,p_tdb_information20 in varchar2 default hr_api.g_varchar2
829: ,p_update_finance_line in varchar2 default hr_api.g_varchar2
830: ,p_tfl_object_version_number in out nocopy number
831: ,p_finance_header_id in number default hr_api.g_number
832: ,p_finance_line_id in out nocopy number

Line 829: ,p_update_finance_line in varchar2 default hr_api.g_varchar2

825: ,p_tdb_information17 in varchar2 default hr_api.g_varchar2
826: ,p_tdb_information18 in varchar2 default hr_api.g_varchar2
827: ,p_tdb_information19 in varchar2 default hr_api.g_varchar2
828: ,p_tdb_information20 in varchar2 default hr_api.g_varchar2
829: ,p_update_finance_line in varchar2 default hr_api.g_varchar2
830: ,p_tfl_object_version_number in out nocopy number
831: ,p_finance_header_id in number default hr_api.g_number
832: ,p_finance_line_id in out nocopy number
833: ,p_standard_amount in number default hr_api.g_number

Line 831: ,p_finance_header_id in number default hr_api.g_number

827: ,p_tdb_information19 in varchar2 default hr_api.g_varchar2
828: ,p_tdb_information20 in varchar2 default hr_api.g_varchar2
829: ,p_update_finance_line in varchar2 default hr_api.g_varchar2
830: ,p_tfl_object_version_number in out nocopy number
831: ,p_finance_header_id in number default hr_api.g_number
832: ,p_finance_line_id in out nocopy number
833: ,p_standard_amount in number default hr_api.g_number
834: ,p_unitary_amount in number default hr_api.g_number
835: ,p_money_amount in number default hr_api.g_number

Line 833: ,p_standard_amount in number default hr_api.g_number

829: ,p_update_finance_line in varchar2 default hr_api.g_varchar2
830: ,p_tfl_object_version_number in out nocopy number
831: ,p_finance_header_id in number default hr_api.g_number
832: ,p_finance_line_id in out nocopy number
833: ,p_standard_amount in number default hr_api.g_number
834: ,p_unitary_amount in number default hr_api.g_number
835: ,p_money_amount in number default hr_api.g_number
836: ,p_currency_code in varchar2 default hr_api.g_varchar2
837: ,p_booking_deal_type in varchar2 default hr_api.g_varchar2

Line 834: ,p_unitary_amount in number default hr_api.g_number

830: ,p_tfl_object_version_number in out nocopy number
831: ,p_finance_header_id in number default hr_api.g_number
832: ,p_finance_line_id in out nocopy number
833: ,p_standard_amount in number default hr_api.g_number
834: ,p_unitary_amount in number default hr_api.g_number
835: ,p_money_amount in number default hr_api.g_number
836: ,p_currency_code in varchar2 default hr_api.g_varchar2
837: ,p_booking_deal_type in varchar2 default hr_api.g_varchar2
838: ,p_booking_deal_id in number default hr_api.g_number

Line 835: ,p_money_amount in number default hr_api.g_number

831: ,p_finance_header_id in number default hr_api.g_number
832: ,p_finance_line_id in out nocopy number
833: ,p_standard_amount in number default hr_api.g_number
834: ,p_unitary_amount in number default hr_api.g_number
835: ,p_money_amount in number default hr_api.g_number
836: ,p_currency_code in varchar2 default hr_api.g_varchar2
837: ,p_booking_deal_type in varchar2 default hr_api.g_varchar2
838: ,p_booking_deal_id in number default hr_api.g_number
839: ,p_enrollment_type in varchar2 default hr_api.g_varchar2

Line 836: ,p_currency_code in varchar2 default hr_api.g_varchar2

832: ,p_finance_line_id in out nocopy number
833: ,p_standard_amount in number default hr_api.g_number
834: ,p_unitary_amount in number default hr_api.g_number
835: ,p_money_amount in number default hr_api.g_number
836: ,p_currency_code in varchar2 default hr_api.g_varchar2
837: ,p_booking_deal_type in varchar2 default hr_api.g_varchar2
838: ,p_booking_deal_id in number default hr_api.g_number
839: ,p_enrollment_type in varchar2 default hr_api.g_varchar2
840: ,p_validate in number default hr_api.g_false_num

Line 837: ,p_booking_deal_type in varchar2 default hr_api.g_varchar2

833: ,p_standard_amount in number default hr_api.g_number
834: ,p_unitary_amount in number default hr_api.g_number
835: ,p_money_amount in number default hr_api.g_number
836: ,p_currency_code in varchar2 default hr_api.g_varchar2
837: ,p_booking_deal_type in varchar2 default hr_api.g_varchar2
838: ,p_booking_deal_id in number default hr_api.g_number
839: ,p_enrollment_type in varchar2 default hr_api.g_varchar2
840: ,p_validate in number default hr_api.g_false_num
841: ,p_organization_id in number default hr_api.g_number

Line 838: ,p_booking_deal_id in number default hr_api.g_number

834: ,p_unitary_amount in number default hr_api.g_number
835: ,p_money_amount in number default hr_api.g_number
836: ,p_currency_code in varchar2 default hr_api.g_varchar2
837: ,p_booking_deal_type in varchar2 default hr_api.g_varchar2
838: ,p_booking_deal_id in number default hr_api.g_number
839: ,p_enrollment_type in varchar2 default hr_api.g_varchar2
840: ,p_validate in number default hr_api.g_false_num
841: ,p_organization_id in number default hr_api.g_number
842: ,p_sponsor_person_id in number default hr_api.g_number

Line 839: ,p_enrollment_type in varchar2 default hr_api.g_varchar2

835: ,p_money_amount in number default hr_api.g_number
836: ,p_currency_code in varchar2 default hr_api.g_varchar2
837: ,p_booking_deal_type in varchar2 default hr_api.g_varchar2
838: ,p_booking_deal_id in number default hr_api.g_number
839: ,p_enrollment_type in varchar2 default hr_api.g_varchar2
840: ,p_validate in number default hr_api.g_false_num
841: ,p_organization_id in number default hr_api.g_number
842: ,p_sponsor_person_id in number default hr_api.g_number
843: ,p_sponsor_assignment_id in number default hr_api.g_number

Line 840: ,p_validate in number default hr_api.g_false_num

836: ,p_currency_code in varchar2 default hr_api.g_varchar2
837: ,p_booking_deal_type in varchar2 default hr_api.g_varchar2
838: ,p_booking_deal_id in number default hr_api.g_number
839: ,p_enrollment_type in varchar2 default hr_api.g_varchar2
840: ,p_validate in number default hr_api.g_false_num
841: ,p_organization_id in number default hr_api.g_number
842: ,p_sponsor_person_id in number default hr_api.g_number
843: ,p_sponsor_assignment_id in number default hr_api.g_number
844: ,p_person_address_id in number default hr_api.g_number

Line 841: ,p_organization_id in number default hr_api.g_number

837: ,p_booking_deal_type in varchar2 default hr_api.g_varchar2
838: ,p_booking_deal_id in number default hr_api.g_number
839: ,p_enrollment_type in varchar2 default hr_api.g_varchar2
840: ,p_validate in number default hr_api.g_false_num
841: ,p_organization_id in number default hr_api.g_number
842: ,p_sponsor_person_id in number default hr_api.g_number
843: ,p_sponsor_assignment_id in number default hr_api.g_number
844: ,p_person_address_id in number default hr_api.g_number
845: ,p_delegate_assignment_id in number default hr_api.g_number

Line 842: ,p_sponsor_person_id in number default hr_api.g_number

838: ,p_booking_deal_id in number default hr_api.g_number
839: ,p_enrollment_type in varchar2 default hr_api.g_varchar2
840: ,p_validate in number default hr_api.g_false_num
841: ,p_organization_id in number default hr_api.g_number
842: ,p_sponsor_person_id in number default hr_api.g_number
843: ,p_sponsor_assignment_id in number default hr_api.g_number
844: ,p_person_address_id in number default hr_api.g_number
845: ,p_delegate_assignment_id in number default hr_api.g_number
846: ,p_delegate_contact_id in number default hr_api.g_number

Line 843: ,p_sponsor_assignment_id in number default hr_api.g_number

839: ,p_enrollment_type in varchar2 default hr_api.g_varchar2
840: ,p_validate in number default hr_api.g_false_num
841: ,p_organization_id in number default hr_api.g_number
842: ,p_sponsor_person_id in number default hr_api.g_number
843: ,p_sponsor_assignment_id in number default hr_api.g_number
844: ,p_person_address_id in number default hr_api.g_number
845: ,p_delegate_assignment_id in number default hr_api.g_number
846: ,p_delegate_contact_id in number default hr_api.g_number
847: ,p_delegate_contact_email in varchar2 default hr_api.g_varchar2

Line 844: ,p_person_address_id in number default hr_api.g_number

840: ,p_validate in number default hr_api.g_false_num
841: ,p_organization_id in number default hr_api.g_number
842: ,p_sponsor_person_id in number default hr_api.g_number
843: ,p_sponsor_assignment_id in number default hr_api.g_number
844: ,p_person_address_id in number default hr_api.g_number
845: ,p_delegate_assignment_id in number default hr_api.g_number
846: ,p_delegate_contact_id in number default hr_api.g_number
847: ,p_delegate_contact_email in varchar2 default hr_api.g_varchar2
848: ,p_third_party_email in varchar2 default hr_api.g_varchar2

Line 845: ,p_delegate_assignment_id in number default hr_api.g_number

841: ,p_organization_id in number default hr_api.g_number
842: ,p_sponsor_person_id in number default hr_api.g_number
843: ,p_sponsor_assignment_id in number default hr_api.g_number
844: ,p_person_address_id in number default hr_api.g_number
845: ,p_delegate_assignment_id in number default hr_api.g_number
846: ,p_delegate_contact_id in number default hr_api.g_number
847: ,p_delegate_contact_email in varchar2 default hr_api.g_varchar2
848: ,p_third_party_email in varchar2 default hr_api.g_varchar2
849: ,p_person_address_type in varchar2 default hr_api.g_varchar2

Line 846: ,p_delegate_contact_id in number default hr_api.g_number

842: ,p_sponsor_person_id in number default hr_api.g_number
843: ,p_sponsor_assignment_id in number default hr_api.g_number
844: ,p_person_address_id in number default hr_api.g_number
845: ,p_delegate_assignment_id in number default hr_api.g_number
846: ,p_delegate_contact_id in number default hr_api.g_number
847: ,p_delegate_contact_email in varchar2 default hr_api.g_varchar2
848: ,p_third_party_email in varchar2 default hr_api.g_varchar2
849: ,p_person_address_type in varchar2 default hr_api.g_varchar2
850: ,p_line_id in number default hr_api.g_number

Line 847: ,p_delegate_contact_email in varchar2 default hr_api.g_varchar2

843: ,p_sponsor_assignment_id in number default hr_api.g_number
844: ,p_person_address_id in number default hr_api.g_number
845: ,p_delegate_assignment_id in number default hr_api.g_number
846: ,p_delegate_contact_id in number default hr_api.g_number
847: ,p_delegate_contact_email in varchar2 default hr_api.g_varchar2
848: ,p_third_party_email in varchar2 default hr_api.g_varchar2
849: ,p_person_address_type in varchar2 default hr_api.g_varchar2
850: ,p_line_id in number default hr_api.g_number
851: ,p_org_id in number default hr_api.g_number

Line 848: ,p_third_party_email in varchar2 default hr_api.g_varchar2

844: ,p_person_address_id in number default hr_api.g_number
845: ,p_delegate_assignment_id in number default hr_api.g_number
846: ,p_delegate_contact_id in number default hr_api.g_number
847: ,p_delegate_contact_email in varchar2 default hr_api.g_varchar2
848: ,p_third_party_email in varchar2 default hr_api.g_varchar2
849: ,p_person_address_type in varchar2 default hr_api.g_varchar2
850: ,p_line_id in number default hr_api.g_number
851: ,p_org_id in number default hr_api.g_number
852: ,p_daemon_flag in varchar2 default hr_api.g_varchar2

Line 849: ,p_person_address_type in varchar2 default hr_api.g_varchar2

845: ,p_delegate_assignment_id in number default hr_api.g_number
846: ,p_delegate_contact_id in number default hr_api.g_number
847: ,p_delegate_contact_email in varchar2 default hr_api.g_varchar2
848: ,p_third_party_email in varchar2 default hr_api.g_varchar2
849: ,p_person_address_type in varchar2 default hr_api.g_varchar2
850: ,p_line_id in number default hr_api.g_number
851: ,p_org_id in number default hr_api.g_number
852: ,p_daemon_flag in varchar2 default hr_api.g_varchar2
853: ,p_daemon_type in varchar2 default hr_api.g_varchar2

Line 850: ,p_line_id in number default hr_api.g_number

846: ,p_delegate_contact_id in number default hr_api.g_number
847: ,p_delegate_contact_email in varchar2 default hr_api.g_varchar2
848: ,p_third_party_email in varchar2 default hr_api.g_varchar2
849: ,p_person_address_type in varchar2 default hr_api.g_varchar2
850: ,p_line_id in number default hr_api.g_number
851: ,p_org_id in number default hr_api.g_number
852: ,p_daemon_flag in varchar2 default hr_api.g_varchar2
853: ,p_daemon_type in varchar2 default hr_api.g_varchar2
854: ,p_old_event_id in number default hr_api.g_number

Line 851: ,p_org_id in number default hr_api.g_number

847: ,p_delegate_contact_email in varchar2 default hr_api.g_varchar2
848: ,p_third_party_email in varchar2 default hr_api.g_varchar2
849: ,p_person_address_type in varchar2 default hr_api.g_varchar2
850: ,p_line_id in number default hr_api.g_number
851: ,p_org_id in number default hr_api.g_number
852: ,p_daemon_flag in varchar2 default hr_api.g_varchar2
853: ,p_daemon_type in varchar2 default hr_api.g_varchar2
854: ,p_old_event_id in number default hr_api.g_number
855: ,p_quote_line_id in number default hr_api.g_number

Line 852: ,p_daemon_flag in varchar2 default hr_api.g_varchar2

848: ,p_third_party_email in varchar2 default hr_api.g_varchar2
849: ,p_person_address_type in varchar2 default hr_api.g_varchar2
850: ,p_line_id in number default hr_api.g_number
851: ,p_org_id in number default hr_api.g_number
852: ,p_daemon_flag in varchar2 default hr_api.g_varchar2
853: ,p_daemon_type in varchar2 default hr_api.g_varchar2
854: ,p_old_event_id in number default hr_api.g_number
855: ,p_quote_line_id in number default hr_api.g_number
856: ,p_interface_source in varchar2 default hr_api.g_varchar2

Line 853: ,p_daemon_type in varchar2 default hr_api.g_varchar2

849: ,p_person_address_type in varchar2 default hr_api.g_varchar2
850: ,p_line_id in number default hr_api.g_number
851: ,p_org_id in number default hr_api.g_number
852: ,p_daemon_flag in varchar2 default hr_api.g_varchar2
853: ,p_daemon_type in varchar2 default hr_api.g_varchar2
854: ,p_old_event_id in number default hr_api.g_number
855: ,p_quote_line_id in number default hr_api.g_number
856: ,p_interface_source in varchar2 default hr_api.g_varchar2
857: ,p_total_training_time in varchar2 default hr_api.g_varchar2

Line 854: ,p_old_event_id in number default hr_api.g_number

850: ,p_line_id in number default hr_api.g_number
851: ,p_org_id in number default hr_api.g_number
852: ,p_daemon_flag in varchar2 default hr_api.g_varchar2
853: ,p_daemon_type in varchar2 default hr_api.g_varchar2
854: ,p_old_event_id in number default hr_api.g_number
855: ,p_quote_line_id in number default hr_api.g_number
856: ,p_interface_source in varchar2 default hr_api.g_varchar2
857: ,p_total_training_time in varchar2 default hr_api.g_varchar2
858: ,p_content_player_status in varchar2 default hr_api.g_varchar2

Line 855: ,p_quote_line_id in number default hr_api.g_number

851: ,p_org_id in number default hr_api.g_number
852: ,p_daemon_flag in varchar2 default hr_api.g_varchar2
853: ,p_daemon_type in varchar2 default hr_api.g_varchar2
854: ,p_old_event_id in number default hr_api.g_number
855: ,p_quote_line_id in number default hr_api.g_number
856: ,p_interface_source in varchar2 default hr_api.g_varchar2
857: ,p_total_training_time in varchar2 default hr_api.g_varchar2
858: ,p_content_player_status in varchar2 default hr_api.g_varchar2
859: ,p_score in number default hr_api.g_number

Line 856: ,p_interface_source in varchar2 default hr_api.g_varchar2

852: ,p_daemon_flag in varchar2 default hr_api.g_varchar2
853: ,p_daemon_type in varchar2 default hr_api.g_varchar2
854: ,p_old_event_id in number default hr_api.g_number
855: ,p_quote_line_id in number default hr_api.g_number
856: ,p_interface_source in varchar2 default hr_api.g_varchar2
857: ,p_total_training_time in varchar2 default hr_api.g_varchar2
858: ,p_content_player_status in varchar2 default hr_api.g_varchar2
859: ,p_score in number default hr_api.g_number
860: ,p_completed_content in number default hr_api.g_number

Line 857: ,p_total_training_time in varchar2 default hr_api.g_varchar2

853: ,p_daemon_type in varchar2 default hr_api.g_varchar2
854: ,p_old_event_id in number default hr_api.g_number
855: ,p_quote_line_id in number default hr_api.g_number
856: ,p_interface_source in varchar2 default hr_api.g_varchar2
857: ,p_total_training_time in varchar2 default hr_api.g_varchar2
858: ,p_content_player_status in varchar2 default hr_api.g_varchar2
859: ,p_score in number default hr_api.g_number
860: ,p_completed_content in number default hr_api.g_number
861: ,p_total_content in number default hr_api.g_number

Line 858: ,p_content_player_status in varchar2 default hr_api.g_varchar2

854: ,p_old_event_id in number default hr_api.g_number
855: ,p_quote_line_id in number default hr_api.g_number
856: ,p_interface_source in varchar2 default hr_api.g_varchar2
857: ,p_total_training_time in varchar2 default hr_api.g_varchar2
858: ,p_content_player_status in varchar2 default hr_api.g_varchar2
859: ,p_score in number default hr_api.g_number
860: ,p_completed_content in number default hr_api.g_number
861: ,p_total_content in number default hr_api.g_number
862: ,p_return_status out nocopy varchar2

Line 859: ,p_score in number default hr_api.g_number

855: ,p_quote_line_id in number default hr_api.g_number
856: ,p_interface_source in varchar2 default hr_api.g_varchar2
857: ,p_total_training_time in varchar2 default hr_api.g_varchar2
858: ,p_content_player_status in varchar2 default hr_api.g_varchar2
859: ,p_score in number default hr_api.g_number
860: ,p_completed_content in number default hr_api.g_number
861: ,p_total_content in number default hr_api.g_number
862: ,p_return_status out nocopy varchar2
863: ,p_booking_justification_id in number default hr_api.g_number

Line 860: ,p_completed_content in number default hr_api.g_number

856: ,p_interface_source in varchar2 default hr_api.g_varchar2
857: ,p_total_training_time in varchar2 default hr_api.g_varchar2
858: ,p_content_player_status in varchar2 default hr_api.g_varchar2
859: ,p_score in number default hr_api.g_number
860: ,p_completed_content in number default hr_api.g_number
861: ,p_total_content in number default hr_api.g_number
862: ,p_return_status out nocopy varchar2
863: ,p_booking_justification_id in number default hr_api.g_number
864: ,p_is_history_flag in varchar2 default hr_api.g_varchar2

Line 861: ,p_total_content in number default hr_api.g_number

857: ,p_total_training_time in varchar2 default hr_api.g_varchar2
858: ,p_content_player_status in varchar2 default hr_api.g_varchar2
859: ,p_score in number default hr_api.g_number
860: ,p_completed_content in number default hr_api.g_number
861: ,p_total_content in number default hr_api.g_number
862: ,p_return_status out nocopy varchar2
863: ,p_booking_justification_id in number default hr_api.g_number
864: ,p_is_history_flag in varchar2 default hr_api.g_varchar2
865: ,p_override_prerequisites in varchar2

Line 863: ,p_booking_justification_id in number default hr_api.g_number

859: ,p_score in number default hr_api.g_number
860: ,p_completed_content in number default hr_api.g_number
861: ,p_total_content in number default hr_api.g_number
862: ,p_return_status out nocopy varchar2
863: ,p_booking_justification_id in number default hr_api.g_number
864: ,p_is_history_flag in varchar2 default hr_api.g_varchar2
865: ,p_override_prerequisites in varchar2
866: ,p_override_learner_access in varchar2
867: ) is

Line 864: ,p_is_history_flag in varchar2 default hr_api.g_varchar2

860: ,p_completed_content in number default hr_api.g_number
861: ,p_total_content in number default hr_api.g_number
862: ,p_return_status out nocopy varchar2
863: ,p_booking_justification_id in number default hr_api.g_number
864: ,p_is_history_flag in varchar2 default hr_api.g_varchar2
865: ,p_override_prerequisites in varchar2
866: ,p_override_learner_access in varchar2
867: ) is
868: --

Line 918: hr_api.constant_to_boolean

914: --
915: -- Convert constant values to their corresponding boolean value
916: --
917: l_validate :=
918: hr_api.constant_to_boolean
919: (p_constant_value => p_validate);
920: --
921: -- Register Surrogate ID or user key values
922: --