DBA Data[Home] [Help]

APPS.OTA_TDB_API_UPD2 dependencies on OTA_DELEGATE_BOOKINGS

Line 44: * OTA_DELEGATE_BOOKINGS.AUTHORIZER_PERSON_ID}.

40: * enrolled.
41: * @param p_customer_id Identifies the customer for whom the enrollment record
42: * is being updated.
43: * @param p_authorizer_person_id {@rep:casecolumn
44: * OTA_DELEGATE_BOOKINGS.AUTHORIZER_PERSON_ID}.
45: * @param p_date_booking_placed Identifies the date on which the enrollment is
46: * updated.
47: * @param p_corespondent {@rep:casecolumn OTA_DELEGATE_BOOKINGS.CORESPONDENT}.
48: * @param p_internal_booking_flag This flag should have the value Y for

Line 47: * @param p_corespondent {@rep:casecolumn OTA_DELEGATE_BOOKINGS.CORESPONDENT}.

43: * @param p_authorizer_person_id {@rep:casecolumn
44: * OTA_DELEGATE_BOOKINGS.AUTHORIZER_PERSON_ID}.
45: * @param p_date_booking_placed Identifies the date on which the enrollment is
46: * updated.
47: * @param p_corespondent {@rep:casecolumn OTA_DELEGATE_BOOKINGS.CORESPONDENT}.
48: * @param p_internal_booking_flag This flag should have the value Y for
49: * internal enrollments and N for external enrollments.
50: * @param p_number_of_places Identifies the number of places needed in the
51: * class.

Line 56: * @param p_administrator {@rep:casecolumn OTA_DELEGATE_BOOKINGS.ADMINISTRATOR}.

52: * @param p_object_version_number Pass the current version number of the
53: * enrollment to be updated.When the API completes if p_validate is false,will
54: * be set to the new version number of the updated enrollment. If p_validate is
55: * true will be set to the same value which was passed in.
56: * @param p_administrator {@rep:casecolumn OTA_DELEGATE_BOOKINGS.ADMINISTRATOR}.
57: * @param p_booking_priority Enrollment Priority. Valid values are defined by
58: * the 'PRIORITY_LEVEL' lookup type.
59: * @param p_comments Comment text.
60: * @param p_contact_address_id {@rep:casecolumn

Line 61: * OTA_DELEGATE_BOOKINGS.CONTACT_ADDRESS_ID}.

57: * @param p_booking_priority Enrollment Priority. Valid values are defined by
58: * the 'PRIORITY_LEVEL' lookup type.
59: * @param p_comments Comment text.
60: * @param p_contact_address_id {@rep:casecolumn
61: * OTA_DELEGATE_BOOKINGS.CONTACT_ADDRESS_ID}.
62: * @param p_delegate_contact_phone {@rep:casecolumn
63: * OTA_DELEGATE_BOOKINGS.DELEGATE_CONTACT_PHONE}.
64: * @param p_delegate_contact_fax {@rep:casecolumn
65: * OTA_DELEGATE_BOOKINGS.DELEGATE_CONTACT_FAX}.

Line 63: * OTA_DELEGATE_BOOKINGS.DELEGATE_CONTACT_PHONE}.

59: * @param p_comments Comment text.
60: * @param p_contact_address_id {@rep:casecolumn
61: * OTA_DELEGATE_BOOKINGS.CONTACT_ADDRESS_ID}.
62: * @param p_delegate_contact_phone {@rep:casecolumn
63: * OTA_DELEGATE_BOOKINGS.DELEGATE_CONTACT_PHONE}.
64: * @param p_delegate_contact_fax {@rep:casecolumn
65: * OTA_DELEGATE_BOOKINGS.DELEGATE_CONTACT_FAX}.
66: * @param p_third_party_customer_id {@rep:casecolumn
67: * OTA_DELEGATE_BOOKINGS.THIRD_PARTY_CUSTOMER_ID}.

Line 65: * OTA_DELEGATE_BOOKINGS.DELEGATE_CONTACT_FAX}.

61: * OTA_DELEGATE_BOOKINGS.CONTACT_ADDRESS_ID}.
62: * @param p_delegate_contact_phone {@rep:casecolumn
63: * OTA_DELEGATE_BOOKINGS.DELEGATE_CONTACT_PHONE}.
64: * @param p_delegate_contact_fax {@rep:casecolumn
65: * OTA_DELEGATE_BOOKINGS.DELEGATE_CONTACT_FAX}.
66: * @param p_third_party_customer_id {@rep:casecolumn
67: * OTA_DELEGATE_BOOKINGS.THIRD_PARTY_CUSTOMER_ID}.
68: * @param p_third_party_contact_id {@rep:casecolumn
69: * OTA_DELEGATE_BOOKINGS.THIRD_PARTY_CONTACT_ID}.

Line 67: * OTA_DELEGATE_BOOKINGS.THIRD_PARTY_CUSTOMER_ID}.

63: * OTA_DELEGATE_BOOKINGS.DELEGATE_CONTACT_PHONE}.
64: * @param p_delegate_contact_fax {@rep:casecolumn
65: * OTA_DELEGATE_BOOKINGS.DELEGATE_CONTACT_FAX}.
66: * @param p_third_party_customer_id {@rep:casecolumn
67: * OTA_DELEGATE_BOOKINGS.THIRD_PARTY_CUSTOMER_ID}.
68: * @param p_third_party_contact_id {@rep:casecolumn
69: * OTA_DELEGATE_BOOKINGS.THIRD_PARTY_CONTACT_ID}.
70: * @param p_third_party_address_id {@rep:casecolumn
71: * OTA_DELEGATE_BOOKINGS.THIRD_PARTY_ADDRESS_ID}.

Line 69: * OTA_DELEGATE_BOOKINGS.THIRD_PARTY_CONTACT_ID}.

65: * OTA_DELEGATE_BOOKINGS.DELEGATE_CONTACT_FAX}.
66: * @param p_third_party_customer_id {@rep:casecolumn
67: * OTA_DELEGATE_BOOKINGS.THIRD_PARTY_CUSTOMER_ID}.
68: * @param p_third_party_contact_id {@rep:casecolumn
69: * OTA_DELEGATE_BOOKINGS.THIRD_PARTY_CONTACT_ID}.
70: * @param p_third_party_address_id {@rep:casecolumn
71: * OTA_DELEGATE_BOOKINGS.THIRD_PARTY_ADDRESS_ID}.
72: * @param p_third_party_contact_phone {@rep:casecolumn
73: * OTA_DELEGATE_BOOKINGS.THIRD_PARTY_CONTACT_PHONE}.

Line 71: * OTA_DELEGATE_BOOKINGS.THIRD_PARTY_ADDRESS_ID}.

67: * OTA_DELEGATE_BOOKINGS.THIRD_PARTY_CUSTOMER_ID}.
68: * @param p_third_party_contact_id {@rep:casecolumn
69: * OTA_DELEGATE_BOOKINGS.THIRD_PARTY_CONTACT_ID}.
70: * @param p_third_party_address_id {@rep:casecolumn
71: * OTA_DELEGATE_BOOKINGS.THIRD_PARTY_ADDRESS_ID}.
72: * @param p_third_party_contact_phone {@rep:casecolumn
73: * OTA_DELEGATE_BOOKINGS.THIRD_PARTY_CONTACT_PHONE}.
74: * @param p_third_party_contact_fax {@rep:casecolumn
75: * OTA_DELEGATE_BOOKINGS.THIRD_PARTY_CONTACT_FAX}.

Line 73: * OTA_DELEGATE_BOOKINGS.THIRD_PARTY_CONTACT_PHONE}.

69: * OTA_DELEGATE_BOOKINGS.THIRD_PARTY_CONTACT_ID}.
70: * @param p_third_party_address_id {@rep:casecolumn
71: * OTA_DELEGATE_BOOKINGS.THIRD_PARTY_ADDRESS_ID}.
72: * @param p_third_party_contact_phone {@rep:casecolumn
73: * OTA_DELEGATE_BOOKINGS.THIRD_PARTY_CONTACT_PHONE}.
74: * @param p_third_party_contact_fax {@rep:casecolumn
75: * OTA_DELEGATE_BOOKINGS.THIRD_PARTY_CONTACT_FAX}.
76: * @param p_date_status_changed {@rep:casecolumn
77: * OTA_DELEGATE_BOOKINGS.DATE_STATUS_CHANGED}.

Line 75: * OTA_DELEGATE_BOOKINGS.THIRD_PARTY_CONTACT_FAX}.

71: * OTA_DELEGATE_BOOKINGS.THIRD_PARTY_ADDRESS_ID}.
72: * @param p_third_party_contact_phone {@rep:casecolumn
73: * OTA_DELEGATE_BOOKINGS.THIRD_PARTY_CONTACT_PHONE}.
74: * @param p_third_party_contact_fax {@rep:casecolumn
75: * OTA_DELEGATE_BOOKINGS.THIRD_PARTY_CONTACT_FAX}.
76: * @param p_date_status_changed {@rep:casecolumn
77: * OTA_DELEGATE_BOOKINGS.DATE_STATUS_CHANGED}.
78: * @param p_status_change_comments Comments on status change.
79: * @param p_failure_reason Identifies the failure reason. Valid values are

Line 77: * OTA_DELEGATE_BOOKINGS.DATE_STATUS_CHANGED}.

73: * OTA_DELEGATE_BOOKINGS.THIRD_PARTY_CONTACT_PHONE}.
74: * @param p_third_party_contact_fax {@rep:casecolumn
75: * OTA_DELEGATE_BOOKINGS.THIRD_PARTY_CONTACT_FAX}.
76: * @param p_date_status_changed {@rep:casecolumn
77: * OTA_DELEGATE_BOOKINGS.DATE_STATUS_CHANGED}.
78: * @param p_status_change_comments Comments on status change.
79: * @param p_failure_reason Identifies the failure reason. Valid values are
80: * defined by 'DELEGATE_FAILURE_REASON' lookup type.
81: * @param p_attendance_result {@rep:casecolumn

Line 82: * OTA_DELEGATE_BOOKINGS.ATTENDANCE_RESULT}.

78: * @param p_status_change_comments Comments on status change.
79: * @param p_failure_reason Identifies the failure reason. Valid values are
80: * defined by 'DELEGATE_FAILURE_REASON' lookup type.
81: * @param p_attendance_result {@rep:casecolumn
82: * OTA_DELEGATE_BOOKINGS.ATTENDANCE_RESULT}.
83: * @param p_language_id {@rep:casecolumn OTA_DELEGATE_BOOKINGS.LANGUAGE_ID}.
84: * @param p_source_of_booking Identifies the source of enrollment. Valid values
85: * are defined by the 'BOOKING_SOURCE' lookup type.
86: * @param p_special_booking_instructions {@rep:casecolumn

Line 83: * @param p_language_id {@rep:casecolumn OTA_DELEGATE_BOOKINGS.LANGUAGE_ID}.

79: * @param p_failure_reason Identifies the failure reason. Valid values are
80: * defined by 'DELEGATE_FAILURE_REASON' lookup type.
81: * @param p_attendance_result {@rep:casecolumn
82: * OTA_DELEGATE_BOOKINGS.ATTENDANCE_RESULT}.
83: * @param p_language_id {@rep:casecolumn OTA_DELEGATE_BOOKINGS.LANGUAGE_ID}.
84: * @param p_source_of_booking Identifies the source of enrollment. Valid values
85: * are defined by the 'BOOKING_SOURCE' lookup type.
86: * @param p_special_booking_instructions {@rep:casecolumn
87: * OTA_DELEGATE_BOOKINGS.SPECIAL_BOOKING_INSTRUCTIONS}.

Line 87: * OTA_DELEGATE_BOOKINGS.SPECIAL_BOOKING_INSTRUCTIONS}.

83: * @param p_language_id {@rep:casecolumn OTA_DELEGATE_BOOKINGS.LANGUAGE_ID}.
84: * @param p_source_of_booking Identifies the source of enrollment. Valid values
85: * are defined by the 'BOOKING_SOURCE' lookup type.
86: * @param p_special_booking_instructions {@rep:casecolumn
87: * OTA_DELEGATE_BOOKINGS.SPECIAL_BOOKING_INSTRUCTIONS}.
88: * @param p_successful_attendance_flag {@rep:casecolumn
89: * OTA_DELEGATE_BOOKINGS.SUCCESSFUL_ATTENDANCE_FLAG}.
90: * @param p_tdb_information_category This context value determines which
91: * Flexfield Structure to use with the Descriptive flexfield segment

Line 89: * OTA_DELEGATE_BOOKINGS.SUCCESSFUL_ATTENDANCE_FLAG}.

85: * are defined by the 'BOOKING_SOURCE' lookup type.
86: * @param p_special_booking_instructions {@rep:casecolumn
87: * OTA_DELEGATE_BOOKINGS.SPECIAL_BOOKING_INSTRUCTIONS}.
88: * @param p_successful_attendance_flag {@rep:casecolumn
89: * OTA_DELEGATE_BOOKINGS.SUCCESSFUL_ATTENDANCE_FLAG}.
90: * @param p_tdb_information_category This context value determines which
91: * Flexfield Structure to use with the Descriptive flexfield segment
92: * @param p_tdb_information1 Descriptive flexfield segment.
93: * @param p_tdb_information2 Descriptive flexfield segment.

Line 130: * OTA_DELEGATE_BOOKINGS.ORGANIZATION_ID}.

126: * @param p_validate If true, then validation alone will be performed and the
127: * database will remain unchanged. If false and all validation checks pass,
128: * then the database will be modified.
129: * @param p_organization_id {@rep:casecolumn
130: * OTA_DELEGATE_BOOKINGS.ORGANIZATION_ID}.
131: * @param p_sponsor_person_id {@rep:casecolumn
132: * OTA_DELEGATE_BOOKINGS.SPONSOR_PERSON_ID}.
133: * @param p_sponsor_assignment_id {@rep:casecolumn
134: * OTA_DELEGATE_BOOKINGS.SPONSOR_ASSIGNMENT_ID}.

Line 132: * OTA_DELEGATE_BOOKINGS.SPONSOR_PERSON_ID}.

128: * then the database will be modified.
129: * @param p_organization_id {@rep:casecolumn
130: * OTA_DELEGATE_BOOKINGS.ORGANIZATION_ID}.
131: * @param p_sponsor_person_id {@rep:casecolumn
132: * OTA_DELEGATE_BOOKINGS.SPONSOR_PERSON_ID}.
133: * @param p_sponsor_assignment_id {@rep:casecolumn
134: * OTA_DELEGATE_BOOKINGS.SPONSOR_ASSIGNMENT_ID}.
135: * @param p_person_address_id {@rep:casecolumn
136: * OTA_DELEGATE_BOOKINGS.PERSON_ADDRESS_ID}.

Line 134: * OTA_DELEGATE_BOOKINGS.SPONSOR_ASSIGNMENT_ID}.

130: * OTA_DELEGATE_BOOKINGS.ORGANIZATION_ID}.
131: * @param p_sponsor_person_id {@rep:casecolumn
132: * OTA_DELEGATE_BOOKINGS.SPONSOR_PERSON_ID}.
133: * @param p_sponsor_assignment_id {@rep:casecolumn
134: * OTA_DELEGATE_BOOKINGS.SPONSOR_ASSIGNMENT_ID}.
135: * @param p_person_address_id {@rep:casecolumn
136: * OTA_DELEGATE_BOOKINGS.PERSON_ADDRESS_ID}.
137: * @param p_delegate_assignment_id {@rep:casecolumn
138: * OTA_DELEGATE_BOOKINGS.DELEGATE_ASSIGNMENT_ID}.

Line 136: * OTA_DELEGATE_BOOKINGS.PERSON_ADDRESS_ID}.

132: * OTA_DELEGATE_BOOKINGS.SPONSOR_PERSON_ID}.
133: * @param p_sponsor_assignment_id {@rep:casecolumn
134: * OTA_DELEGATE_BOOKINGS.SPONSOR_ASSIGNMENT_ID}.
135: * @param p_person_address_id {@rep:casecolumn
136: * OTA_DELEGATE_BOOKINGS.PERSON_ADDRESS_ID}.
137: * @param p_delegate_assignment_id {@rep:casecolumn
138: * OTA_DELEGATE_BOOKINGS.DELEGATE_ASSIGNMENT_ID}.
139: * @param p_delegate_contact_id {@rep:casecolumn
140: * OTA_DELEGATE_BOOKINGS.DELEGATE_CONTACT_ID}.

Line 138: * OTA_DELEGATE_BOOKINGS.DELEGATE_ASSIGNMENT_ID}.

134: * OTA_DELEGATE_BOOKINGS.SPONSOR_ASSIGNMENT_ID}.
135: * @param p_person_address_id {@rep:casecolumn
136: * OTA_DELEGATE_BOOKINGS.PERSON_ADDRESS_ID}.
137: * @param p_delegate_assignment_id {@rep:casecolumn
138: * OTA_DELEGATE_BOOKINGS.DELEGATE_ASSIGNMENT_ID}.
139: * @param p_delegate_contact_id {@rep:casecolumn
140: * OTA_DELEGATE_BOOKINGS.DELEGATE_CONTACT_ID}.
141: * @param p_delegate_contact_email {@rep:casecolumn
142: * OTA_DELEGATE_BOOKINGS.DELEGATE_CONTACT_EMAIL}.

Line 140: * OTA_DELEGATE_BOOKINGS.DELEGATE_CONTACT_ID}.

136: * OTA_DELEGATE_BOOKINGS.PERSON_ADDRESS_ID}.
137: * @param p_delegate_assignment_id {@rep:casecolumn
138: * OTA_DELEGATE_BOOKINGS.DELEGATE_ASSIGNMENT_ID}.
139: * @param p_delegate_contact_id {@rep:casecolumn
140: * OTA_DELEGATE_BOOKINGS.DELEGATE_CONTACT_ID}.
141: * @param p_delegate_contact_email {@rep:casecolumn
142: * OTA_DELEGATE_BOOKINGS.DELEGATE_CONTACT_EMAIL}.
143: * @param p_third_party_email {@rep:casecolumn
144: * OTA_DELEGATE_BOOKINGS.THIRD_PARTY_EMAIL}.

Line 142: * OTA_DELEGATE_BOOKINGS.DELEGATE_CONTACT_EMAIL}.

138: * OTA_DELEGATE_BOOKINGS.DELEGATE_ASSIGNMENT_ID}.
139: * @param p_delegate_contact_id {@rep:casecolumn
140: * OTA_DELEGATE_BOOKINGS.DELEGATE_CONTACT_ID}.
141: * @param p_delegate_contact_email {@rep:casecolumn
142: * OTA_DELEGATE_BOOKINGS.DELEGATE_CONTACT_EMAIL}.
143: * @param p_third_party_email {@rep:casecolumn
144: * OTA_DELEGATE_BOOKINGS.THIRD_PARTY_EMAIL}.
145: * @param p_person_address_type {@rep:casecolumn
146: * OTA_DELEGATE_BOOKINGS.PERSON_ADDRESS_TYPE}.

Line 144: * OTA_DELEGATE_BOOKINGS.THIRD_PARTY_EMAIL}.

140: * OTA_DELEGATE_BOOKINGS.DELEGATE_CONTACT_ID}.
141: * @param p_delegate_contact_email {@rep:casecolumn
142: * OTA_DELEGATE_BOOKINGS.DELEGATE_CONTACT_EMAIL}.
143: * @param p_third_party_email {@rep:casecolumn
144: * OTA_DELEGATE_BOOKINGS.THIRD_PARTY_EMAIL}.
145: * @param p_person_address_type {@rep:casecolumn
146: * OTA_DELEGATE_BOOKINGS.PERSON_ADDRESS_TYPE}.
147: * @param p_line_id {@rep:casecolumn OTA_DELEGATE_BOOKINGS.LINE_ID}.
148: * @param p_org_id {@rep:casecolumn OTA_DELEGATE_BOOKINGS.ORG_ID}.

Line 146: * OTA_DELEGATE_BOOKINGS.PERSON_ADDRESS_TYPE}.

142: * OTA_DELEGATE_BOOKINGS.DELEGATE_CONTACT_EMAIL}.
143: * @param p_third_party_email {@rep:casecolumn
144: * OTA_DELEGATE_BOOKINGS.THIRD_PARTY_EMAIL}.
145: * @param p_person_address_type {@rep:casecolumn
146: * OTA_DELEGATE_BOOKINGS.PERSON_ADDRESS_TYPE}.
147: * @param p_line_id {@rep:casecolumn OTA_DELEGATE_BOOKINGS.LINE_ID}.
148: * @param p_org_id {@rep:casecolumn OTA_DELEGATE_BOOKINGS.ORG_ID}.
149: * @param p_daemon_flag {@rep:casecolumn OTA_DELEGATE_BOOKINGS.DAEMON_FLAG}.
150: * @param p_daemon_type {@rep:casecolumn OTA_DELEGATE_BOOKINGS.DAEMON_TYPE}.

Line 147: * @param p_line_id {@rep:casecolumn OTA_DELEGATE_BOOKINGS.LINE_ID}.

143: * @param p_third_party_email {@rep:casecolumn
144: * OTA_DELEGATE_BOOKINGS.THIRD_PARTY_EMAIL}.
145: * @param p_person_address_type {@rep:casecolumn
146: * OTA_DELEGATE_BOOKINGS.PERSON_ADDRESS_TYPE}.
147: * @param p_line_id {@rep:casecolumn OTA_DELEGATE_BOOKINGS.LINE_ID}.
148: * @param p_org_id {@rep:casecolumn OTA_DELEGATE_BOOKINGS.ORG_ID}.
149: * @param p_daemon_flag {@rep:casecolumn OTA_DELEGATE_BOOKINGS.DAEMON_FLAG}.
150: * @param p_daemon_type {@rep:casecolumn OTA_DELEGATE_BOOKINGS.DAEMON_TYPE}.
151: * @param p_old_event_id {@rep:casecolumn OTA_DELEGATE_BOOKINGS.OLD_EVENT_ID}.

Line 148: * @param p_org_id {@rep:casecolumn OTA_DELEGATE_BOOKINGS.ORG_ID}.

144: * OTA_DELEGATE_BOOKINGS.THIRD_PARTY_EMAIL}.
145: * @param p_person_address_type {@rep:casecolumn
146: * OTA_DELEGATE_BOOKINGS.PERSON_ADDRESS_TYPE}.
147: * @param p_line_id {@rep:casecolumn OTA_DELEGATE_BOOKINGS.LINE_ID}.
148: * @param p_org_id {@rep:casecolumn OTA_DELEGATE_BOOKINGS.ORG_ID}.
149: * @param p_daemon_flag {@rep:casecolumn OTA_DELEGATE_BOOKINGS.DAEMON_FLAG}.
150: * @param p_daemon_type {@rep:casecolumn OTA_DELEGATE_BOOKINGS.DAEMON_TYPE}.
151: * @param p_old_event_id {@rep:casecolumn OTA_DELEGATE_BOOKINGS.OLD_EVENT_ID}.
152: * @param p_quote_line_id {@rep:casecolumn OTA_DELEGATE_BOOKINGS.QUOTE_LINE_ID}.

Line 149: * @param p_daemon_flag {@rep:casecolumn OTA_DELEGATE_BOOKINGS.DAEMON_FLAG}.

145: * @param p_person_address_type {@rep:casecolumn
146: * OTA_DELEGATE_BOOKINGS.PERSON_ADDRESS_TYPE}.
147: * @param p_line_id {@rep:casecolumn OTA_DELEGATE_BOOKINGS.LINE_ID}.
148: * @param p_org_id {@rep:casecolumn OTA_DELEGATE_BOOKINGS.ORG_ID}.
149: * @param p_daemon_flag {@rep:casecolumn OTA_DELEGATE_BOOKINGS.DAEMON_FLAG}.
150: * @param p_daemon_type {@rep:casecolumn OTA_DELEGATE_BOOKINGS.DAEMON_TYPE}.
151: * @param p_old_event_id {@rep:casecolumn OTA_DELEGATE_BOOKINGS.OLD_EVENT_ID}.
152: * @param p_quote_line_id {@rep:casecolumn OTA_DELEGATE_BOOKINGS.QUOTE_LINE_ID}.
153: * @param p_interface_source {@rep:casecolumn

Line 150: * @param p_daemon_type {@rep:casecolumn OTA_DELEGATE_BOOKINGS.DAEMON_TYPE}.

146: * OTA_DELEGATE_BOOKINGS.PERSON_ADDRESS_TYPE}.
147: * @param p_line_id {@rep:casecolumn OTA_DELEGATE_BOOKINGS.LINE_ID}.
148: * @param p_org_id {@rep:casecolumn OTA_DELEGATE_BOOKINGS.ORG_ID}.
149: * @param p_daemon_flag {@rep:casecolumn OTA_DELEGATE_BOOKINGS.DAEMON_FLAG}.
150: * @param p_daemon_type {@rep:casecolumn OTA_DELEGATE_BOOKINGS.DAEMON_TYPE}.
151: * @param p_old_event_id {@rep:casecolumn OTA_DELEGATE_BOOKINGS.OLD_EVENT_ID}.
152: * @param p_quote_line_id {@rep:casecolumn OTA_DELEGATE_BOOKINGS.QUOTE_LINE_ID}.
153: * @param p_interface_source {@rep:casecolumn
154: * OTA_DELEGATE_BOOKINGS.INTERFACE_SOURCE}.

Line 151: * @param p_old_event_id {@rep:casecolumn OTA_DELEGATE_BOOKINGS.OLD_EVENT_ID}.

147: * @param p_line_id {@rep:casecolumn OTA_DELEGATE_BOOKINGS.LINE_ID}.
148: * @param p_org_id {@rep:casecolumn OTA_DELEGATE_BOOKINGS.ORG_ID}.
149: * @param p_daemon_flag {@rep:casecolumn OTA_DELEGATE_BOOKINGS.DAEMON_FLAG}.
150: * @param p_daemon_type {@rep:casecolumn OTA_DELEGATE_BOOKINGS.DAEMON_TYPE}.
151: * @param p_old_event_id {@rep:casecolumn OTA_DELEGATE_BOOKINGS.OLD_EVENT_ID}.
152: * @param p_quote_line_id {@rep:casecolumn OTA_DELEGATE_BOOKINGS.QUOTE_LINE_ID}.
153: * @param p_interface_source {@rep:casecolumn
154: * OTA_DELEGATE_BOOKINGS.INTERFACE_SOURCE}.
155: * @param p_total_training_time {@rep:casecolumn

Line 152: * @param p_quote_line_id {@rep:casecolumn OTA_DELEGATE_BOOKINGS.QUOTE_LINE_ID}.

148: * @param p_org_id {@rep:casecolumn OTA_DELEGATE_BOOKINGS.ORG_ID}.
149: * @param p_daemon_flag {@rep:casecolumn OTA_DELEGATE_BOOKINGS.DAEMON_FLAG}.
150: * @param p_daemon_type {@rep:casecolumn OTA_DELEGATE_BOOKINGS.DAEMON_TYPE}.
151: * @param p_old_event_id {@rep:casecolumn OTA_DELEGATE_BOOKINGS.OLD_EVENT_ID}.
152: * @param p_quote_line_id {@rep:casecolumn OTA_DELEGATE_BOOKINGS.QUOTE_LINE_ID}.
153: * @param p_interface_source {@rep:casecolumn
154: * OTA_DELEGATE_BOOKINGS.INTERFACE_SOURCE}.
155: * @param p_total_training_time {@rep:casecolumn
156: * OTA_DELEGATE_BOOKINGS.TOTAL_TRAINING_TIME}.

Line 154: * OTA_DELEGATE_BOOKINGS.INTERFACE_SOURCE}.

150: * @param p_daemon_type {@rep:casecolumn OTA_DELEGATE_BOOKINGS.DAEMON_TYPE}.
151: * @param p_old_event_id {@rep:casecolumn OTA_DELEGATE_BOOKINGS.OLD_EVENT_ID}.
152: * @param p_quote_line_id {@rep:casecolumn OTA_DELEGATE_BOOKINGS.QUOTE_LINE_ID}.
153: * @param p_interface_source {@rep:casecolumn
154: * OTA_DELEGATE_BOOKINGS.INTERFACE_SOURCE}.
155: * @param p_total_training_time {@rep:casecolumn
156: * OTA_DELEGATE_BOOKINGS.TOTAL_TRAINING_TIME}.
157: * @param p_content_player_status Player status of Courses imported from
158: * iLearning.

Line 156: * OTA_DELEGATE_BOOKINGS.TOTAL_TRAINING_TIME}.

152: * @param p_quote_line_id {@rep:casecolumn OTA_DELEGATE_BOOKINGS.QUOTE_LINE_ID}.
153: * @param p_interface_source {@rep:casecolumn
154: * OTA_DELEGATE_BOOKINGS.INTERFACE_SOURCE}.
155: * @param p_total_training_time {@rep:casecolumn
156: * OTA_DELEGATE_BOOKINGS.TOTAL_TRAINING_TIME}.
157: * @param p_content_player_status Player status of Courses imported from
158: * iLearning.
159: * @param p_score Test Score of Courses imported from iLearning.
160: * @param p_completed_content {@rep:casecolumn

Line 161: * OTA_DELEGATE_BOOKINGS.COMPLETED_CONTENT}.

157: * @param p_content_player_status Player status of Courses imported from
158: * iLearning.
159: * @param p_score Test Score of Courses imported from iLearning.
160: * @param p_completed_content {@rep:casecolumn
161: * OTA_DELEGATE_BOOKINGS.COMPLETED_CONTENT}.
162: * @param p_total_content {@rep:casecolumn OTA_DELEGATE_BOOKINGS.TOTAL_CONTENT}.
163: * @param p_source_cancel Specifies whether the unenrollment originates from
164: * the learner or admin. Valid value is 'AME' when coming from the learner;
165: * otherwise it is null.

Line 162: * @param p_total_content {@rep:casecolumn OTA_DELEGATE_BOOKINGS.TOTAL_CONTENT}.

158: * iLearning.
159: * @param p_score Test Score of Courses imported from iLearning.
160: * @param p_completed_content {@rep:casecolumn
161: * OTA_DELEGATE_BOOKINGS.COMPLETED_CONTENT}.
162: * @param p_total_content {@rep:casecolumn OTA_DELEGATE_BOOKINGS.TOTAL_CONTENT}.
163: * @param p_source_cancel Specifies whether the unenrollment originates from
164: * the learner or admin. Valid value is 'AME' when coming from the learner;
165: * otherwise it is null.
166: * @param p_booking_justification_id Identifies the enrollment justification

Line 308: (p_delegate_person_id ota_delegate_bookings.delegate_person_id%TYPE,

304: -- |--------------------------< chk_mandatory_prereqs >------------------------|
305: -- ----------------------------------------------------------------------------
306: --
307: Procedure chk_mandatory_prereqs
308: (p_delegate_person_id ota_delegate_bookings.delegate_person_id%TYPE,
309: p_delegate_contact_id ota_delegate_bookings.delegate_contact_id%TYPE,
310: p_customer_id ota_delegate_bookings.customer_id%TYPE,
311: p_event_id ota_events.event_id%TYPE,
312: p_booking_status_type_id in ota_delegate_bookings.booking_status_type_id%TYPE

Line 309: p_delegate_contact_id ota_delegate_bookings.delegate_contact_id%TYPE,

305: -- ----------------------------------------------------------------------------
306: --
307: Procedure chk_mandatory_prereqs
308: (p_delegate_person_id ota_delegate_bookings.delegate_person_id%TYPE,
309: p_delegate_contact_id ota_delegate_bookings.delegate_contact_id%TYPE,
310: p_customer_id ota_delegate_bookings.customer_id%TYPE,
311: p_event_id ota_events.event_id%TYPE,
312: p_booking_status_type_id in ota_delegate_bookings.booking_status_type_id%TYPE
313: );

Line 310: p_customer_id ota_delegate_bookings.customer_id%TYPE,

306: --
307: Procedure chk_mandatory_prereqs
308: (p_delegate_person_id ota_delegate_bookings.delegate_person_id%TYPE,
309: p_delegate_contact_id ota_delegate_bookings.delegate_contact_id%TYPE,
310: p_customer_id ota_delegate_bookings.customer_id%TYPE,
311: p_event_id ota_events.event_id%TYPE,
312: p_booking_status_type_id in ota_delegate_bookings.booking_status_type_id%TYPE
313: );
314: --

Line 312: p_booking_status_type_id in ota_delegate_bookings.booking_status_type_id%TYPE

308: (p_delegate_person_id ota_delegate_bookings.delegate_person_id%TYPE,
309: p_delegate_contact_id ota_delegate_bookings.delegate_contact_id%TYPE,
310: p_customer_id ota_delegate_bookings.customer_id%TYPE,
311: p_event_id ota_events.event_id%TYPE,
312: p_booking_status_type_id in ota_delegate_bookings.booking_status_type_id%TYPE
313: );
314: --
315: end ota_tdb_api_upd2;