DBA Data[Home] [Help]

APPS.OTA_TAV_UPD dependencies on HR_API

Line 50: -- by raising and handling the exception hr_api.validate_enabled. We use

46: -- default is false. The validation is controlled by a savepoint and
47: -- rollback mechanism. The savepoint is issued at the beginning of the
48: -- business process and is rollbacked at the end of the business process
49: -- when all the processing has been completed. The rollback is controlled
50: -- by raising and handling the exception hr_api.validate_enabled. We use
51: -- the exception because, by raising the exception with the business
52: -- process, we can exit successfully without having any of the 'OUT'
53: -- arguments being set.
54: --

Line 124: p_activity_id in number default hr_api.g_number,

120: -- ----------------------------------------------------------------------------
121: Procedure upd
122: (
123: p_activity_version_id in number,
124: p_activity_id in number default hr_api.g_number,
125: p_superseded_by_act_version_id in number default hr_api.g_number,
126: p_developer_organization_id in number default hr_api.g_number,
127: p_controlling_person_id in number default hr_api.g_number,
128: p_object_version_number in out nocopy number,

Line 125: p_superseded_by_act_version_id in number default hr_api.g_number,

121: Procedure upd
122: (
123: p_activity_version_id in number,
124: p_activity_id in number default hr_api.g_number,
125: p_superseded_by_act_version_id in number default hr_api.g_number,
126: p_developer_organization_id in number default hr_api.g_number,
127: p_controlling_person_id in number default hr_api.g_number,
128: p_object_version_number in out nocopy number,
129: p_version_name in varchar2 default hr_api.g_varchar2,

Line 126: p_developer_organization_id in number default hr_api.g_number,

122: (
123: p_activity_version_id in number,
124: p_activity_id in number default hr_api.g_number,
125: p_superseded_by_act_version_id in number default hr_api.g_number,
126: p_developer_organization_id in number default hr_api.g_number,
127: p_controlling_person_id in number default hr_api.g_number,
128: p_object_version_number in out nocopy number,
129: p_version_name in varchar2 default hr_api.g_varchar2,
130: p_comments in varchar2 default hr_api.g_varchar2,

Line 127: p_controlling_person_id in number default hr_api.g_number,

123: p_activity_version_id in number,
124: p_activity_id in number default hr_api.g_number,
125: p_superseded_by_act_version_id in number default hr_api.g_number,
126: p_developer_organization_id in number default hr_api.g_number,
127: p_controlling_person_id in number default hr_api.g_number,
128: p_object_version_number in out nocopy number,
129: p_version_name in varchar2 default hr_api.g_varchar2,
130: p_comments in varchar2 default hr_api.g_varchar2,
131: p_description in varchar2 default hr_api.g_varchar2,

Line 129: p_version_name in varchar2 default hr_api.g_varchar2,

125: p_superseded_by_act_version_id in number default hr_api.g_number,
126: p_developer_organization_id in number default hr_api.g_number,
127: p_controlling_person_id in number default hr_api.g_number,
128: p_object_version_number in out nocopy number,
129: p_version_name in varchar2 default hr_api.g_varchar2,
130: p_comments in varchar2 default hr_api.g_varchar2,
131: p_description in varchar2 default hr_api.g_varchar2,
132: p_duration in number default hr_api.g_number,
133: p_duration_units in varchar2 default hr_api.g_varchar2,

Line 130: p_comments in varchar2 default hr_api.g_varchar2,

126: p_developer_organization_id in number default hr_api.g_number,
127: p_controlling_person_id in number default hr_api.g_number,
128: p_object_version_number in out nocopy number,
129: p_version_name in varchar2 default hr_api.g_varchar2,
130: p_comments in varchar2 default hr_api.g_varchar2,
131: p_description in varchar2 default hr_api.g_varchar2,
132: p_duration in number default hr_api.g_number,
133: p_duration_units in varchar2 default hr_api.g_varchar2,
134: p_end_date in date default hr_api.g_date,

Line 131: p_description in varchar2 default hr_api.g_varchar2,

127: p_controlling_person_id in number default hr_api.g_number,
128: p_object_version_number in out nocopy number,
129: p_version_name in varchar2 default hr_api.g_varchar2,
130: p_comments in varchar2 default hr_api.g_varchar2,
131: p_description in varchar2 default hr_api.g_varchar2,
132: p_duration in number default hr_api.g_number,
133: p_duration_units in varchar2 default hr_api.g_varchar2,
134: p_end_date in date default hr_api.g_date,
135: p_intended_audience in varchar2 default hr_api.g_varchar2,

Line 132: p_duration in number default hr_api.g_number,

128: p_object_version_number in out nocopy number,
129: p_version_name in varchar2 default hr_api.g_varchar2,
130: p_comments in varchar2 default hr_api.g_varchar2,
131: p_description in varchar2 default hr_api.g_varchar2,
132: p_duration in number default hr_api.g_number,
133: p_duration_units in varchar2 default hr_api.g_varchar2,
134: p_end_date in date default hr_api.g_date,
135: p_intended_audience in varchar2 default hr_api.g_varchar2,
136: p_language_id in number default hr_api.g_number,

Line 133: p_duration_units in varchar2 default hr_api.g_varchar2,

129: p_version_name in varchar2 default hr_api.g_varchar2,
130: p_comments in varchar2 default hr_api.g_varchar2,
131: p_description in varchar2 default hr_api.g_varchar2,
132: p_duration in number default hr_api.g_number,
133: p_duration_units in varchar2 default hr_api.g_varchar2,
134: p_end_date in date default hr_api.g_date,
135: p_intended_audience in varchar2 default hr_api.g_varchar2,
136: p_language_id in number default hr_api.g_number,
137: p_maximum_attendees in number default hr_api.g_number,

Line 134: p_end_date in date default hr_api.g_date,

130: p_comments in varchar2 default hr_api.g_varchar2,
131: p_description in varchar2 default hr_api.g_varchar2,
132: p_duration in number default hr_api.g_number,
133: p_duration_units in varchar2 default hr_api.g_varchar2,
134: p_end_date in date default hr_api.g_date,
135: p_intended_audience in varchar2 default hr_api.g_varchar2,
136: p_language_id in number default hr_api.g_number,
137: p_maximum_attendees in number default hr_api.g_number,
138: p_minimum_attendees in number default hr_api.g_number,

Line 135: p_intended_audience in varchar2 default hr_api.g_varchar2,

131: p_description in varchar2 default hr_api.g_varchar2,
132: p_duration in number default hr_api.g_number,
133: p_duration_units in varchar2 default hr_api.g_varchar2,
134: p_end_date in date default hr_api.g_date,
135: p_intended_audience in varchar2 default hr_api.g_varchar2,
136: p_language_id in number default hr_api.g_number,
137: p_maximum_attendees in number default hr_api.g_number,
138: p_minimum_attendees in number default hr_api.g_number,
139: p_objectives in varchar2 default hr_api.g_varchar2,

Line 136: p_language_id in number default hr_api.g_number,

132: p_duration in number default hr_api.g_number,
133: p_duration_units in varchar2 default hr_api.g_varchar2,
134: p_end_date in date default hr_api.g_date,
135: p_intended_audience in varchar2 default hr_api.g_varchar2,
136: p_language_id in number default hr_api.g_number,
137: p_maximum_attendees in number default hr_api.g_number,
138: p_minimum_attendees in number default hr_api.g_number,
139: p_objectives in varchar2 default hr_api.g_varchar2,
140: p_start_date in date default hr_api.g_date,

Line 137: p_maximum_attendees in number default hr_api.g_number,

133: p_duration_units in varchar2 default hr_api.g_varchar2,
134: p_end_date in date default hr_api.g_date,
135: p_intended_audience in varchar2 default hr_api.g_varchar2,
136: p_language_id in number default hr_api.g_number,
137: p_maximum_attendees in number default hr_api.g_number,
138: p_minimum_attendees in number default hr_api.g_number,
139: p_objectives in varchar2 default hr_api.g_varchar2,
140: p_start_date in date default hr_api.g_date,
141: p_success_criteria in varchar2 default hr_api.g_varchar2,

Line 138: p_minimum_attendees in number default hr_api.g_number,

134: p_end_date in date default hr_api.g_date,
135: p_intended_audience in varchar2 default hr_api.g_varchar2,
136: p_language_id in number default hr_api.g_number,
137: p_maximum_attendees in number default hr_api.g_number,
138: p_minimum_attendees in number default hr_api.g_number,
139: p_objectives in varchar2 default hr_api.g_varchar2,
140: p_start_date in date default hr_api.g_date,
141: p_success_criteria in varchar2 default hr_api.g_varchar2,
142: p_user_status in varchar2 default hr_api.g_varchar2,

Line 139: p_objectives in varchar2 default hr_api.g_varchar2,

135: p_intended_audience in varchar2 default hr_api.g_varchar2,
136: p_language_id in number default hr_api.g_number,
137: p_maximum_attendees in number default hr_api.g_number,
138: p_minimum_attendees in number default hr_api.g_number,
139: p_objectives in varchar2 default hr_api.g_varchar2,
140: p_start_date in date default hr_api.g_date,
141: p_success_criteria in varchar2 default hr_api.g_varchar2,
142: p_user_status in varchar2 default hr_api.g_varchar2,
143: p_vendor_id in number default hr_api.g_number,

Line 140: p_start_date in date default hr_api.g_date,

136: p_language_id in number default hr_api.g_number,
137: p_maximum_attendees in number default hr_api.g_number,
138: p_minimum_attendees in number default hr_api.g_number,
139: p_objectives in varchar2 default hr_api.g_varchar2,
140: p_start_date in date default hr_api.g_date,
141: p_success_criteria in varchar2 default hr_api.g_varchar2,
142: p_user_status in varchar2 default hr_api.g_varchar2,
143: p_vendor_id in number default hr_api.g_number,
144: p_actual_cost in number default hr_api.g_number,

Line 141: p_success_criteria in varchar2 default hr_api.g_varchar2,

137: p_maximum_attendees in number default hr_api.g_number,
138: p_minimum_attendees in number default hr_api.g_number,
139: p_objectives in varchar2 default hr_api.g_varchar2,
140: p_start_date in date default hr_api.g_date,
141: p_success_criteria in varchar2 default hr_api.g_varchar2,
142: p_user_status in varchar2 default hr_api.g_varchar2,
143: p_vendor_id in number default hr_api.g_number,
144: p_actual_cost in number default hr_api.g_number,
145: p_budget_cost in number default hr_api.g_number,

Line 142: p_user_status in varchar2 default hr_api.g_varchar2,

138: p_minimum_attendees in number default hr_api.g_number,
139: p_objectives in varchar2 default hr_api.g_varchar2,
140: p_start_date in date default hr_api.g_date,
141: p_success_criteria in varchar2 default hr_api.g_varchar2,
142: p_user_status in varchar2 default hr_api.g_varchar2,
143: p_vendor_id in number default hr_api.g_number,
144: p_actual_cost in number default hr_api.g_number,
145: p_budget_cost in number default hr_api.g_number,
146: p_budget_currency_code in varchar2 default hr_api.g_varchar2,

Line 143: p_vendor_id in number default hr_api.g_number,

139: p_objectives in varchar2 default hr_api.g_varchar2,
140: p_start_date in date default hr_api.g_date,
141: p_success_criteria in varchar2 default hr_api.g_varchar2,
142: p_user_status in varchar2 default hr_api.g_varchar2,
143: p_vendor_id in number default hr_api.g_number,
144: p_actual_cost in number default hr_api.g_number,
145: p_budget_cost in number default hr_api.g_number,
146: p_budget_currency_code in varchar2 default hr_api.g_varchar2,
147: p_expenses_allowed in varchar2 default hr_api.g_varchar2,

Line 144: p_actual_cost in number default hr_api.g_number,

140: p_start_date in date default hr_api.g_date,
141: p_success_criteria in varchar2 default hr_api.g_varchar2,
142: p_user_status in varchar2 default hr_api.g_varchar2,
143: p_vendor_id in number default hr_api.g_number,
144: p_actual_cost in number default hr_api.g_number,
145: p_budget_cost in number default hr_api.g_number,
146: p_budget_currency_code in varchar2 default hr_api.g_varchar2,
147: p_expenses_allowed in varchar2 default hr_api.g_varchar2,
148: p_professional_credit_type in varchar2 default hr_api.g_varchar2,

Line 145: p_budget_cost in number default hr_api.g_number,

141: p_success_criteria in varchar2 default hr_api.g_varchar2,
142: p_user_status in varchar2 default hr_api.g_varchar2,
143: p_vendor_id in number default hr_api.g_number,
144: p_actual_cost in number default hr_api.g_number,
145: p_budget_cost in number default hr_api.g_number,
146: p_budget_currency_code in varchar2 default hr_api.g_varchar2,
147: p_expenses_allowed in varchar2 default hr_api.g_varchar2,
148: p_professional_credit_type in varchar2 default hr_api.g_varchar2,
149: p_professional_credits in number default hr_api.g_number,

Line 146: p_budget_currency_code in varchar2 default hr_api.g_varchar2,

142: p_user_status in varchar2 default hr_api.g_varchar2,
143: p_vendor_id in number default hr_api.g_number,
144: p_actual_cost in number default hr_api.g_number,
145: p_budget_cost in number default hr_api.g_number,
146: p_budget_currency_code in varchar2 default hr_api.g_varchar2,
147: p_expenses_allowed in varchar2 default hr_api.g_varchar2,
148: p_professional_credit_type in varchar2 default hr_api.g_varchar2,
149: p_professional_credits in number default hr_api.g_number,
150: p_maximum_internal_attendees in number default hr_api.g_number,

Line 147: p_expenses_allowed in varchar2 default hr_api.g_varchar2,

143: p_vendor_id in number default hr_api.g_number,
144: p_actual_cost in number default hr_api.g_number,
145: p_budget_cost in number default hr_api.g_number,
146: p_budget_currency_code in varchar2 default hr_api.g_varchar2,
147: p_expenses_allowed in varchar2 default hr_api.g_varchar2,
148: p_professional_credit_type in varchar2 default hr_api.g_varchar2,
149: p_professional_credits in number default hr_api.g_number,
150: p_maximum_internal_attendees in number default hr_api.g_number,
151: p_tav_information_category in varchar2 default hr_api.g_varchar2,

Line 148: p_professional_credit_type in varchar2 default hr_api.g_varchar2,

144: p_actual_cost in number default hr_api.g_number,
145: p_budget_cost in number default hr_api.g_number,
146: p_budget_currency_code in varchar2 default hr_api.g_varchar2,
147: p_expenses_allowed in varchar2 default hr_api.g_varchar2,
148: p_professional_credit_type in varchar2 default hr_api.g_varchar2,
149: p_professional_credits in number default hr_api.g_number,
150: p_maximum_internal_attendees in number default hr_api.g_number,
151: p_tav_information_category in varchar2 default hr_api.g_varchar2,
152: p_tav_information1 in varchar2 default hr_api.g_varchar2,

Line 149: p_professional_credits in number default hr_api.g_number,

145: p_budget_cost in number default hr_api.g_number,
146: p_budget_currency_code in varchar2 default hr_api.g_varchar2,
147: p_expenses_allowed in varchar2 default hr_api.g_varchar2,
148: p_professional_credit_type in varchar2 default hr_api.g_varchar2,
149: p_professional_credits in number default hr_api.g_number,
150: p_maximum_internal_attendees in number default hr_api.g_number,
151: p_tav_information_category in varchar2 default hr_api.g_varchar2,
152: p_tav_information1 in varchar2 default hr_api.g_varchar2,
153: p_tav_information2 in varchar2 default hr_api.g_varchar2,

Line 150: p_maximum_internal_attendees in number default hr_api.g_number,

146: p_budget_currency_code in varchar2 default hr_api.g_varchar2,
147: p_expenses_allowed in varchar2 default hr_api.g_varchar2,
148: p_professional_credit_type in varchar2 default hr_api.g_varchar2,
149: p_professional_credits in number default hr_api.g_number,
150: p_maximum_internal_attendees in number default hr_api.g_number,
151: p_tav_information_category in varchar2 default hr_api.g_varchar2,
152: p_tav_information1 in varchar2 default hr_api.g_varchar2,
153: p_tav_information2 in varchar2 default hr_api.g_varchar2,
154: p_tav_information3 in varchar2 default hr_api.g_varchar2,

Line 151: p_tav_information_category in varchar2 default hr_api.g_varchar2,

147: p_expenses_allowed in varchar2 default hr_api.g_varchar2,
148: p_professional_credit_type in varchar2 default hr_api.g_varchar2,
149: p_professional_credits in number default hr_api.g_number,
150: p_maximum_internal_attendees in number default hr_api.g_number,
151: p_tav_information_category in varchar2 default hr_api.g_varchar2,
152: p_tav_information1 in varchar2 default hr_api.g_varchar2,
153: p_tav_information2 in varchar2 default hr_api.g_varchar2,
154: p_tav_information3 in varchar2 default hr_api.g_varchar2,
155: p_tav_information4 in varchar2 default hr_api.g_varchar2,

Line 152: p_tav_information1 in varchar2 default hr_api.g_varchar2,

148: p_professional_credit_type in varchar2 default hr_api.g_varchar2,
149: p_professional_credits in number default hr_api.g_number,
150: p_maximum_internal_attendees in number default hr_api.g_number,
151: p_tav_information_category in varchar2 default hr_api.g_varchar2,
152: p_tav_information1 in varchar2 default hr_api.g_varchar2,
153: p_tav_information2 in varchar2 default hr_api.g_varchar2,
154: p_tav_information3 in varchar2 default hr_api.g_varchar2,
155: p_tav_information4 in varchar2 default hr_api.g_varchar2,
156: p_tav_information5 in varchar2 default hr_api.g_varchar2,

Line 153: p_tav_information2 in varchar2 default hr_api.g_varchar2,

149: p_professional_credits in number default hr_api.g_number,
150: p_maximum_internal_attendees in number default hr_api.g_number,
151: p_tav_information_category in varchar2 default hr_api.g_varchar2,
152: p_tav_information1 in varchar2 default hr_api.g_varchar2,
153: p_tav_information2 in varchar2 default hr_api.g_varchar2,
154: p_tav_information3 in varchar2 default hr_api.g_varchar2,
155: p_tav_information4 in varchar2 default hr_api.g_varchar2,
156: p_tav_information5 in varchar2 default hr_api.g_varchar2,
157: p_tav_information6 in varchar2 default hr_api.g_varchar2,

Line 154: p_tav_information3 in varchar2 default hr_api.g_varchar2,

150: p_maximum_internal_attendees in number default hr_api.g_number,
151: p_tav_information_category in varchar2 default hr_api.g_varchar2,
152: p_tav_information1 in varchar2 default hr_api.g_varchar2,
153: p_tav_information2 in varchar2 default hr_api.g_varchar2,
154: p_tav_information3 in varchar2 default hr_api.g_varchar2,
155: p_tav_information4 in varchar2 default hr_api.g_varchar2,
156: p_tav_information5 in varchar2 default hr_api.g_varchar2,
157: p_tav_information6 in varchar2 default hr_api.g_varchar2,
158: p_tav_information7 in varchar2 default hr_api.g_varchar2,

Line 155: p_tav_information4 in varchar2 default hr_api.g_varchar2,

151: p_tav_information_category in varchar2 default hr_api.g_varchar2,
152: p_tav_information1 in varchar2 default hr_api.g_varchar2,
153: p_tav_information2 in varchar2 default hr_api.g_varchar2,
154: p_tav_information3 in varchar2 default hr_api.g_varchar2,
155: p_tav_information4 in varchar2 default hr_api.g_varchar2,
156: p_tav_information5 in varchar2 default hr_api.g_varchar2,
157: p_tav_information6 in varchar2 default hr_api.g_varchar2,
158: p_tav_information7 in varchar2 default hr_api.g_varchar2,
159: p_tav_information8 in varchar2 default hr_api.g_varchar2,

Line 156: p_tav_information5 in varchar2 default hr_api.g_varchar2,

152: p_tav_information1 in varchar2 default hr_api.g_varchar2,
153: p_tav_information2 in varchar2 default hr_api.g_varchar2,
154: p_tav_information3 in varchar2 default hr_api.g_varchar2,
155: p_tav_information4 in varchar2 default hr_api.g_varchar2,
156: p_tav_information5 in varchar2 default hr_api.g_varchar2,
157: p_tav_information6 in varchar2 default hr_api.g_varchar2,
158: p_tav_information7 in varchar2 default hr_api.g_varchar2,
159: p_tav_information8 in varchar2 default hr_api.g_varchar2,
160: p_tav_information9 in varchar2 default hr_api.g_varchar2,

Line 157: p_tav_information6 in varchar2 default hr_api.g_varchar2,

153: p_tav_information2 in varchar2 default hr_api.g_varchar2,
154: p_tav_information3 in varchar2 default hr_api.g_varchar2,
155: p_tav_information4 in varchar2 default hr_api.g_varchar2,
156: p_tav_information5 in varchar2 default hr_api.g_varchar2,
157: p_tav_information6 in varchar2 default hr_api.g_varchar2,
158: p_tav_information7 in varchar2 default hr_api.g_varchar2,
159: p_tav_information8 in varchar2 default hr_api.g_varchar2,
160: p_tav_information9 in varchar2 default hr_api.g_varchar2,
161: p_tav_information10 in varchar2 default hr_api.g_varchar2,

Line 158: p_tav_information7 in varchar2 default hr_api.g_varchar2,

154: p_tav_information3 in varchar2 default hr_api.g_varchar2,
155: p_tav_information4 in varchar2 default hr_api.g_varchar2,
156: p_tav_information5 in varchar2 default hr_api.g_varchar2,
157: p_tav_information6 in varchar2 default hr_api.g_varchar2,
158: p_tav_information7 in varchar2 default hr_api.g_varchar2,
159: p_tav_information8 in varchar2 default hr_api.g_varchar2,
160: p_tav_information9 in varchar2 default hr_api.g_varchar2,
161: p_tav_information10 in varchar2 default hr_api.g_varchar2,
162: p_tav_information11 in varchar2 default hr_api.g_varchar2,

Line 159: p_tav_information8 in varchar2 default hr_api.g_varchar2,

155: p_tav_information4 in varchar2 default hr_api.g_varchar2,
156: p_tav_information5 in varchar2 default hr_api.g_varchar2,
157: p_tav_information6 in varchar2 default hr_api.g_varchar2,
158: p_tav_information7 in varchar2 default hr_api.g_varchar2,
159: p_tav_information8 in varchar2 default hr_api.g_varchar2,
160: p_tav_information9 in varchar2 default hr_api.g_varchar2,
161: p_tav_information10 in varchar2 default hr_api.g_varchar2,
162: p_tav_information11 in varchar2 default hr_api.g_varchar2,
163: p_tav_information12 in varchar2 default hr_api.g_varchar2,

Line 160: p_tav_information9 in varchar2 default hr_api.g_varchar2,

156: p_tav_information5 in varchar2 default hr_api.g_varchar2,
157: p_tav_information6 in varchar2 default hr_api.g_varchar2,
158: p_tav_information7 in varchar2 default hr_api.g_varchar2,
159: p_tav_information8 in varchar2 default hr_api.g_varchar2,
160: p_tav_information9 in varchar2 default hr_api.g_varchar2,
161: p_tav_information10 in varchar2 default hr_api.g_varchar2,
162: p_tav_information11 in varchar2 default hr_api.g_varchar2,
163: p_tav_information12 in varchar2 default hr_api.g_varchar2,
164: p_tav_information13 in varchar2 default hr_api.g_varchar2,

Line 161: p_tav_information10 in varchar2 default hr_api.g_varchar2,

157: p_tav_information6 in varchar2 default hr_api.g_varchar2,
158: p_tav_information7 in varchar2 default hr_api.g_varchar2,
159: p_tav_information8 in varchar2 default hr_api.g_varchar2,
160: p_tav_information9 in varchar2 default hr_api.g_varchar2,
161: p_tav_information10 in varchar2 default hr_api.g_varchar2,
162: p_tav_information11 in varchar2 default hr_api.g_varchar2,
163: p_tav_information12 in varchar2 default hr_api.g_varchar2,
164: p_tav_information13 in varchar2 default hr_api.g_varchar2,
165: p_tav_information14 in varchar2 default hr_api.g_varchar2,

Line 162: p_tav_information11 in varchar2 default hr_api.g_varchar2,

158: p_tav_information7 in varchar2 default hr_api.g_varchar2,
159: p_tav_information8 in varchar2 default hr_api.g_varchar2,
160: p_tav_information9 in varchar2 default hr_api.g_varchar2,
161: p_tav_information10 in varchar2 default hr_api.g_varchar2,
162: p_tav_information11 in varchar2 default hr_api.g_varchar2,
163: p_tav_information12 in varchar2 default hr_api.g_varchar2,
164: p_tav_information13 in varchar2 default hr_api.g_varchar2,
165: p_tav_information14 in varchar2 default hr_api.g_varchar2,
166: p_tav_information15 in varchar2 default hr_api.g_varchar2,

Line 163: p_tav_information12 in varchar2 default hr_api.g_varchar2,

159: p_tav_information8 in varchar2 default hr_api.g_varchar2,
160: p_tav_information9 in varchar2 default hr_api.g_varchar2,
161: p_tav_information10 in varchar2 default hr_api.g_varchar2,
162: p_tav_information11 in varchar2 default hr_api.g_varchar2,
163: p_tav_information12 in varchar2 default hr_api.g_varchar2,
164: p_tav_information13 in varchar2 default hr_api.g_varchar2,
165: p_tav_information14 in varchar2 default hr_api.g_varchar2,
166: p_tav_information15 in varchar2 default hr_api.g_varchar2,
167: p_tav_information16 in varchar2 default hr_api.g_varchar2,

Line 164: p_tav_information13 in varchar2 default hr_api.g_varchar2,

160: p_tav_information9 in varchar2 default hr_api.g_varchar2,
161: p_tav_information10 in varchar2 default hr_api.g_varchar2,
162: p_tav_information11 in varchar2 default hr_api.g_varchar2,
163: p_tav_information12 in varchar2 default hr_api.g_varchar2,
164: p_tav_information13 in varchar2 default hr_api.g_varchar2,
165: p_tav_information14 in varchar2 default hr_api.g_varchar2,
166: p_tav_information15 in varchar2 default hr_api.g_varchar2,
167: p_tav_information16 in varchar2 default hr_api.g_varchar2,
168: p_tav_information17 in varchar2 default hr_api.g_varchar2,

Line 165: p_tav_information14 in varchar2 default hr_api.g_varchar2,

161: p_tav_information10 in varchar2 default hr_api.g_varchar2,
162: p_tav_information11 in varchar2 default hr_api.g_varchar2,
163: p_tav_information12 in varchar2 default hr_api.g_varchar2,
164: p_tav_information13 in varchar2 default hr_api.g_varchar2,
165: p_tav_information14 in varchar2 default hr_api.g_varchar2,
166: p_tav_information15 in varchar2 default hr_api.g_varchar2,
167: p_tav_information16 in varchar2 default hr_api.g_varchar2,
168: p_tav_information17 in varchar2 default hr_api.g_varchar2,
169: p_tav_information18 in varchar2 default hr_api.g_varchar2,

Line 166: p_tav_information15 in varchar2 default hr_api.g_varchar2,

162: p_tav_information11 in varchar2 default hr_api.g_varchar2,
163: p_tav_information12 in varchar2 default hr_api.g_varchar2,
164: p_tav_information13 in varchar2 default hr_api.g_varchar2,
165: p_tav_information14 in varchar2 default hr_api.g_varchar2,
166: p_tav_information15 in varchar2 default hr_api.g_varchar2,
167: p_tav_information16 in varchar2 default hr_api.g_varchar2,
168: p_tav_information17 in varchar2 default hr_api.g_varchar2,
169: p_tav_information18 in varchar2 default hr_api.g_varchar2,
170: p_tav_information19 in varchar2 default hr_api.g_varchar2,

Line 167: p_tav_information16 in varchar2 default hr_api.g_varchar2,

163: p_tav_information12 in varchar2 default hr_api.g_varchar2,
164: p_tav_information13 in varchar2 default hr_api.g_varchar2,
165: p_tav_information14 in varchar2 default hr_api.g_varchar2,
166: p_tav_information15 in varchar2 default hr_api.g_varchar2,
167: p_tav_information16 in varchar2 default hr_api.g_varchar2,
168: p_tav_information17 in varchar2 default hr_api.g_varchar2,
169: p_tav_information18 in varchar2 default hr_api.g_varchar2,
170: p_tav_information19 in varchar2 default hr_api.g_varchar2,
171: p_tav_information20 in varchar2 default hr_api.g_varchar2,

Line 168: p_tav_information17 in varchar2 default hr_api.g_varchar2,

164: p_tav_information13 in varchar2 default hr_api.g_varchar2,
165: p_tav_information14 in varchar2 default hr_api.g_varchar2,
166: p_tav_information15 in varchar2 default hr_api.g_varchar2,
167: p_tav_information16 in varchar2 default hr_api.g_varchar2,
168: p_tav_information17 in varchar2 default hr_api.g_varchar2,
169: p_tav_information18 in varchar2 default hr_api.g_varchar2,
170: p_tav_information19 in varchar2 default hr_api.g_varchar2,
171: p_tav_information20 in varchar2 default hr_api.g_varchar2,
172: p_inventory_item_id in number default hr_api.g_number,

Line 169: p_tav_information18 in varchar2 default hr_api.g_varchar2,

165: p_tav_information14 in varchar2 default hr_api.g_varchar2,
166: p_tav_information15 in varchar2 default hr_api.g_varchar2,
167: p_tav_information16 in varchar2 default hr_api.g_varchar2,
168: p_tav_information17 in varchar2 default hr_api.g_varchar2,
169: p_tav_information18 in varchar2 default hr_api.g_varchar2,
170: p_tav_information19 in varchar2 default hr_api.g_varchar2,
171: p_tav_information20 in varchar2 default hr_api.g_varchar2,
172: p_inventory_item_id in number default hr_api.g_number,
173: p_organization_id in number default hr_api.g_number,

Line 170: p_tav_information19 in varchar2 default hr_api.g_varchar2,

166: p_tav_information15 in varchar2 default hr_api.g_varchar2,
167: p_tav_information16 in varchar2 default hr_api.g_varchar2,
168: p_tav_information17 in varchar2 default hr_api.g_varchar2,
169: p_tav_information18 in varchar2 default hr_api.g_varchar2,
170: p_tav_information19 in varchar2 default hr_api.g_varchar2,
171: p_tav_information20 in varchar2 default hr_api.g_varchar2,
172: p_inventory_item_id in number default hr_api.g_number,
173: p_organization_id in number default hr_api.g_number,
174: p_rco_id in number default hr_api.g_number,

Line 171: p_tav_information20 in varchar2 default hr_api.g_varchar2,

167: p_tav_information16 in varchar2 default hr_api.g_varchar2,
168: p_tav_information17 in varchar2 default hr_api.g_varchar2,
169: p_tav_information18 in varchar2 default hr_api.g_varchar2,
170: p_tav_information19 in varchar2 default hr_api.g_varchar2,
171: p_tav_information20 in varchar2 default hr_api.g_varchar2,
172: p_inventory_item_id in number default hr_api.g_number,
173: p_organization_id in number default hr_api.g_number,
174: p_rco_id in number default hr_api.g_number,
175: -- p_rco_id in number default null,

Line 172: p_inventory_item_id in number default hr_api.g_number,

168: p_tav_information17 in varchar2 default hr_api.g_varchar2,
169: p_tav_information18 in varchar2 default hr_api.g_varchar2,
170: p_tav_information19 in varchar2 default hr_api.g_varchar2,
171: p_tav_information20 in varchar2 default hr_api.g_varchar2,
172: p_inventory_item_id in number default hr_api.g_number,
173: p_organization_id in number default hr_api.g_number,
174: p_rco_id in number default hr_api.g_number,
175: -- p_rco_id in number default null,
176: p_version_code in varchar2 default hr_api.g_varchar2,

Line 173: p_organization_id in number default hr_api.g_number,

169: p_tav_information18 in varchar2 default hr_api.g_varchar2,
170: p_tav_information19 in varchar2 default hr_api.g_varchar2,
171: p_tav_information20 in varchar2 default hr_api.g_varchar2,
172: p_inventory_item_id in number default hr_api.g_number,
173: p_organization_id in number default hr_api.g_number,
174: p_rco_id in number default hr_api.g_number,
175: -- p_rco_id in number default null,
176: p_version_code in varchar2 default hr_api.g_varchar2,
177: p_business_group_id in number default hr_api.g_number,

Line 174: p_rco_id in number default hr_api.g_number,

170: p_tav_information19 in varchar2 default hr_api.g_varchar2,
171: p_tav_information20 in varchar2 default hr_api.g_varchar2,
172: p_inventory_item_id in number default hr_api.g_number,
173: p_organization_id in number default hr_api.g_number,
174: p_rco_id in number default hr_api.g_number,
175: -- p_rco_id in number default null,
176: p_version_code in varchar2 default hr_api.g_varchar2,
177: p_business_group_id in number default hr_api.g_number,
178: p_validate in boolean default false,

Line 176: p_version_code in varchar2 default hr_api.g_varchar2,

172: p_inventory_item_id in number default hr_api.g_number,
173: p_organization_id in number default hr_api.g_number,
174: p_rco_id in number default hr_api.g_number,
175: -- p_rco_id in number default null,
176: p_version_code in varchar2 default hr_api.g_varchar2,
177: p_business_group_id in number default hr_api.g_number,
178: p_validate in boolean default false,
179: p_data_source in varchar2 default hr_api.g_varchar2
180: ,p_competency_update_level in varchar2 default hr_api.g_varchar2,

Line 177: p_business_group_id in number default hr_api.g_number,

173: p_organization_id in number default hr_api.g_number,
174: p_rco_id in number default hr_api.g_number,
175: -- p_rco_id in number default null,
176: p_version_code in varchar2 default hr_api.g_varchar2,
177: p_business_group_id in number default hr_api.g_number,
178: p_validate in boolean default false,
179: p_data_source in varchar2 default hr_api.g_varchar2
180: ,p_competency_update_level in varchar2 default hr_api.g_varchar2,
181: p_eres_enabled in varchar2 default hr_api.g_varchar2

Line 179: p_data_source in varchar2 default hr_api.g_varchar2

175: -- p_rco_id in number default null,
176: p_version_code in varchar2 default hr_api.g_varchar2,
177: p_business_group_id in number default hr_api.g_number,
178: p_validate in boolean default false,
179: p_data_source in varchar2 default hr_api.g_varchar2
180: ,p_competency_update_level in varchar2 default hr_api.g_varchar2,
181: p_eres_enabled in varchar2 default hr_api.g_varchar2
182:
183: );

Line 180: ,p_competency_update_level in varchar2 default hr_api.g_varchar2,

176: p_version_code in varchar2 default hr_api.g_varchar2,
177: p_business_group_id in number default hr_api.g_number,
178: p_validate in boolean default false,
179: p_data_source in varchar2 default hr_api.g_varchar2
180: ,p_competency_update_level in varchar2 default hr_api.g_varchar2,
181: p_eres_enabled in varchar2 default hr_api.g_varchar2
182:
183: );
184: --

Line 181: p_eres_enabled in varchar2 default hr_api.g_varchar2

177: p_business_group_id in number default hr_api.g_number,
178: p_validate in boolean default false,
179: p_data_source in varchar2 default hr_api.g_varchar2
180: ,p_competency_update_level in varchar2 default hr_api.g_varchar2,
181: p_eres_enabled in varchar2 default hr_api.g_varchar2
182:
183: );
184: --
185: end ota_tav_upd;