39: * database will remain unchanged. If false and all validation checks pass,
40: * then the database will be modified.
41: * @param p_language_code Specifies to which language the translation values
42: * apply. You can set to the base or any installed language. The default value
43: * of hr_api.userenv_lang is equivalent to the RDBMS userenv('LANG') function
44: * value.
45: * @param p_integration_key Unique identifier for knowledge integration record.
46: * @param p_party_type Type of trading partner.
47: * @param p_party_name Name of the party.
102: -- {End Of Comments}
103: --
104: procedure create_integration
105: (p_validate in boolean default false
106: ,p_language_code in varchar2 default hr_api.userenv_lang
107: ,p_integration_key in varchar2
108: ,p_party_type in varchar2 default null
109: ,p_party_name in varchar2 default null
110: ,p_party_site_name in varchar2 default null
220: * database will remain unchanged. If false and all validation checks pass,
221: * then the database will be modified.
222: * @param p_language_code Specifies to which language the translation values
223: * apply. You can set to the base or any installed language. The default value
224: * of hr_api.userenv_lang is equivalent to the RDBMS userenv('LANG') function
225: * value.
226: * @param p_integration_id Internal unique identifier of the knowledge
227: * integration record.
228: * @param p_source_type Source type of the integration.
284: -- {End Of Comments}
285: --
286: procedure update_integration
287: (p_validate in boolean default false
288: ,p_language_code in varchar2 default hr_api.userenv_lang
289: ,p_integration_id in number
290: ,p_source_type in varchar2
291: ,p_target_type in varchar2
292: ,p_party_type in varchar2 default hr_api.g_varchar2
288: ,p_language_code in varchar2 default hr_api.userenv_lang
289: ,p_integration_id in number
290: ,p_source_type in varchar2
291: ,p_target_type in varchar2
292: ,p_party_type in varchar2 default hr_api.g_varchar2
293: ,p_party_name in varchar2 default hr_api.g_varchar2
294: ,p_party_site_name in varchar2 default hr_api.g_varchar2
295: ,p_transaction_type in varchar2 default hr_api.g_varchar2
296: ,p_transaction_subtype in varchar2 default hr_api.g_varchar2
289: ,p_integration_id in number
290: ,p_source_type in varchar2
291: ,p_target_type in varchar2
292: ,p_party_type in varchar2 default hr_api.g_varchar2
293: ,p_party_name in varchar2 default hr_api.g_varchar2
294: ,p_party_site_name in varchar2 default hr_api.g_varchar2
295: ,p_transaction_type in varchar2 default hr_api.g_varchar2
296: ,p_transaction_subtype in varchar2 default hr_api.g_varchar2
297: ,p_standard_code in varchar2 default hr_api.g_varchar2
290: ,p_source_type in varchar2
291: ,p_target_type in varchar2
292: ,p_party_type in varchar2 default hr_api.g_varchar2
293: ,p_party_name in varchar2 default hr_api.g_varchar2
294: ,p_party_site_name in varchar2 default hr_api.g_varchar2
295: ,p_transaction_type in varchar2 default hr_api.g_varchar2
296: ,p_transaction_subtype in varchar2 default hr_api.g_varchar2
297: ,p_standard_code in varchar2 default hr_api.g_varchar2
298: ,p_ext_trans_type in varchar2 default hr_api.g_varchar2
291: ,p_target_type in varchar2
292: ,p_party_type in varchar2 default hr_api.g_varchar2
293: ,p_party_name in varchar2 default hr_api.g_varchar2
294: ,p_party_site_name in varchar2 default hr_api.g_varchar2
295: ,p_transaction_type in varchar2 default hr_api.g_varchar2
296: ,p_transaction_subtype in varchar2 default hr_api.g_varchar2
297: ,p_standard_code in varchar2 default hr_api.g_varchar2
298: ,p_ext_trans_type in varchar2 default hr_api.g_varchar2
299: ,p_ext_trans_subtype in varchar2 default hr_api.g_varchar2
292: ,p_party_type in varchar2 default hr_api.g_varchar2
293: ,p_party_name in varchar2 default hr_api.g_varchar2
294: ,p_party_site_name in varchar2 default hr_api.g_varchar2
295: ,p_transaction_type in varchar2 default hr_api.g_varchar2
296: ,p_transaction_subtype in varchar2 default hr_api.g_varchar2
297: ,p_standard_code in varchar2 default hr_api.g_varchar2
298: ,p_ext_trans_type in varchar2 default hr_api.g_varchar2
299: ,p_ext_trans_subtype in varchar2 default hr_api.g_varchar2
300: ,p_trans_direction in varchar2 default hr_api.g_varchar2
293: ,p_party_name in varchar2 default hr_api.g_varchar2
294: ,p_party_site_name in varchar2 default hr_api.g_varchar2
295: ,p_transaction_type in varchar2 default hr_api.g_varchar2
296: ,p_transaction_subtype in varchar2 default hr_api.g_varchar2
297: ,p_standard_code in varchar2 default hr_api.g_varchar2
298: ,p_ext_trans_type in varchar2 default hr_api.g_varchar2
299: ,p_ext_trans_subtype in varchar2 default hr_api.g_varchar2
300: ,p_trans_direction in varchar2 default hr_api.g_varchar2
301: ,p_url in varchar2 default hr_api.g_varchar2
294: ,p_party_site_name in varchar2 default hr_api.g_varchar2
295: ,p_transaction_type in varchar2 default hr_api.g_varchar2
296: ,p_transaction_subtype in varchar2 default hr_api.g_varchar2
297: ,p_standard_code in varchar2 default hr_api.g_varchar2
298: ,p_ext_trans_type in varchar2 default hr_api.g_varchar2
299: ,p_ext_trans_subtype in varchar2 default hr_api.g_varchar2
300: ,p_trans_direction in varchar2 default hr_api.g_varchar2
301: ,p_url in varchar2 default hr_api.g_varchar2
302: ,p_partner_name in varchar2 default hr_api.g_varchar2
295: ,p_transaction_type in varchar2 default hr_api.g_varchar2
296: ,p_transaction_subtype in varchar2 default hr_api.g_varchar2
297: ,p_standard_code in varchar2 default hr_api.g_varchar2
298: ,p_ext_trans_type in varchar2 default hr_api.g_varchar2
299: ,p_ext_trans_subtype in varchar2 default hr_api.g_varchar2
300: ,p_trans_direction in varchar2 default hr_api.g_varchar2
301: ,p_url in varchar2 default hr_api.g_varchar2
302: ,p_partner_name in varchar2 default hr_api.g_varchar2
303: ,p_service_name in varchar2 default hr_api.g_varchar2
296: ,p_transaction_subtype in varchar2 default hr_api.g_varchar2
297: ,p_standard_code in varchar2 default hr_api.g_varchar2
298: ,p_ext_trans_type in varchar2 default hr_api.g_varchar2
299: ,p_ext_trans_subtype in varchar2 default hr_api.g_varchar2
300: ,p_trans_direction in varchar2 default hr_api.g_varchar2
301: ,p_url in varchar2 default hr_api.g_varchar2
302: ,p_partner_name in varchar2 default hr_api.g_varchar2
303: ,p_service_name in varchar2 default hr_api.g_varchar2
304: ,p_application_name in varchar2 default hr_api.g_varchar2
297: ,p_standard_code in varchar2 default hr_api.g_varchar2
298: ,p_ext_trans_type in varchar2 default hr_api.g_varchar2
299: ,p_ext_trans_subtype in varchar2 default hr_api.g_varchar2
300: ,p_trans_direction in varchar2 default hr_api.g_varchar2
301: ,p_url in varchar2 default hr_api.g_varchar2
302: ,p_partner_name in varchar2 default hr_api.g_varchar2
303: ,p_service_name in varchar2 default hr_api.g_varchar2
304: ,p_application_name in varchar2 default hr_api.g_varchar2
305: ,p_application_type in varchar2 default hr_api.g_varchar2
298: ,p_ext_trans_type in varchar2 default hr_api.g_varchar2
299: ,p_ext_trans_subtype in varchar2 default hr_api.g_varchar2
300: ,p_trans_direction in varchar2 default hr_api.g_varchar2
301: ,p_url in varchar2 default hr_api.g_varchar2
302: ,p_partner_name in varchar2 default hr_api.g_varchar2
303: ,p_service_name in varchar2 default hr_api.g_varchar2
304: ,p_application_name in varchar2 default hr_api.g_varchar2
305: ,p_application_type in varchar2 default hr_api.g_varchar2
306: ,p_application_url in varchar2 default hr_api.g_varchar2
299: ,p_ext_trans_subtype in varchar2 default hr_api.g_varchar2
300: ,p_trans_direction in varchar2 default hr_api.g_varchar2
301: ,p_url in varchar2 default hr_api.g_varchar2
302: ,p_partner_name in varchar2 default hr_api.g_varchar2
303: ,p_service_name in varchar2 default hr_api.g_varchar2
304: ,p_application_name in varchar2 default hr_api.g_varchar2
305: ,p_application_type in varchar2 default hr_api.g_varchar2
306: ,p_application_url in varchar2 default hr_api.g_varchar2
307: ,p_logout_url in varchar2 default hr_api.g_varchar2
300: ,p_trans_direction in varchar2 default hr_api.g_varchar2
301: ,p_url in varchar2 default hr_api.g_varchar2
302: ,p_partner_name in varchar2 default hr_api.g_varchar2
303: ,p_service_name in varchar2 default hr_api.g_varchar2
304: ,p_application_name in varchar2 default hr_api.g_varchar2
305: ,p_application_type in varchar2 default hr_api.g_varchar2
306: ,p_application_url in varchar2 default hr_api.g_varchar2
307: ,p_logout_url in varchar2 default hr_api.g_varchar2
308: ,p_user_field in varchar2 default hr_api.g_varchar2
301: ,p_url in varchar2 default hr_api.g_varchar2
302: ,p_partner_name in varchar2 default hr_api.g_varchar2
303: ,p_service_name in varchar2 default hr_api.g_varchar2
304: ,p_application_name in varchar2 default hr_api.g_varchar2
305: ,p_application_type in varchar2 default hr_api.g_varchar2
306: ,p_application_url in varchar2 default hr_api.g_varchar2
307: ,p_logout_url in varchar2 default hr_api.g_varchar2
308: ,p_user_field in varchar2 default hr_api.g_varchar2
309: ,p_password_field in varchar2 default hr_api.g_varchar2
302: ,p_partner_name in varchar2 default hr_api.g_varchar2
303: ,p_service_name in varchar2 default hr_api.g_varchar2
304: ,p_application_name in varchar2 default hr_api.g_varchar2
305: ,p_application_type in varchar2 default hr_api.g_varchar2
306: ,p_application_url in varchar2 default hr_api.g_varchar2
307: ,p_logout_url in varchar2 default hr_api.g_varchar2
308: ,p_user_field in varchar2 default hr_api.g_varchar2
309: ,p_password_field in varchar2 default hr_api.g_varchar2
310: ,p_authentication_needed in varchar2 default hr_api.g_varchar2
303: ,p_service_name in varchar2 default hr_api.g_varchar2
304: ,p_application_name in varchar2 default hr_api.g_varchar2
305: ,p_application_type in varchar2 default hr_api.g_varchar2
306: ,p_application_url in varchar2 default hr_api.g_varchar2
307: ,p_logout_url in varchar2 default hr_api.g_varchar2
308: ,p_user_field in varchar2 default hr_api.g_varchar2
309: ,p_password_field in varchar2 default hr_api.g_varchar2
310: ,p_authentication_needed in varchar2 default hr_api.g_varchar2
311: ,p_field_name1 in varchar2 default hr_api.g_varchar2
304: ,p_application_name in varchar2 default hr_api.g_varchar2
305: ,p_application_type in varchar2 default hr_api.g_varchar2
306: ,p_application_url in varchar2 default hr_api.g_varchar2
307: ,p_logout_url in varchar2 default hr_api.g_varchar2
308: ,p_user_field in varchar2 default hr_api.g_varchar2
309: ,p_password_field in varchar2 default hr_api.g_varchar2
310: ,p_authentication_needed in varchar2 default hr_api.g_varchar2
311: ,p_field_name1 in varchar2 default hr_api.g_varchar2
312: ,p_field_value1 in varchar2 default hr_api.g_varchar2
305: ,p_application_type in varchar2 default hr_api.g_varchar2
306: ,p_application_url in varchar2 default hr_api.g_varchar2
307: ,p_logout_url in varchar2 default hr_api.g_varchar2
308: ,p_user_field in varchar2 default hr_api.g_varchar2
309: ,p_password_field in varchar2 default hr_api.g_varchar2
310: ,p_authentication_needed in varchar2 default hr_api.g_varchar2
311: ,p_field_name1 in varchar2 default hr_api.g_varchar2
312: ,p_field_value1 in varchar2 default hr_api.g_varchar2
313: ,p_field_name2 in varchar2 default hr_api.g_varchar2
306: ,p_application_url in varchar2 default hr_api.g_varchar2
307: ,p_logout_url in varchar2 default hr_api.g_varchar2
308: ,p_user_field in varchar2 default hr_api.g_varchar2
309: ,p_password_field in varchar2 default hr_api.g_varchar2
310: ,p_authentication_needed in varchar2 default hr_api.g_varchar2
311: ,p_field_name1 in varchar2 default hr_api.g_varchar2
312: ,p_field_value1 in varchar2 default hr_api.g_varchar2
313: ,p_field_name2 in varchar2 default hr_api.g_varchar2
314: ,p_field_value2 in varchar2 default hr_api.g_varchar2
307: ,p_logout_url in varchar2 default hr_api.g_varchar2
308: ,p_user_field in varchar2 default hr_api.g_varchar2
309: ,p_password_field in varchar2 default hr_api.g_varchar2
310: ,p_authentication_needed in varchar2 default hr_api.g_varchar2
311: ,p_field_name1 in varchar2 default hr_api.g_varchar2
312: ,p_field_value1 in varchar2 default hr_api.g_varchar2
313: ,p_field_name2 in varchar2 default hr_api.g_varchar2
314: ,p_field_value2 in varchar2 default hr_api.g_varchar2
315: ,p_field_name3 in varchar2 default hr_api.g_varchar2
308: ,p_user_field in varchar2 default hr_api.g_varchar2
309: ,p_password_field in varchar2 default hr_api.g_varchar2
310: ,p_authentication_needed in varchar2 default hr_api.g_varchar2
311: ,p_field_name1 in varchar2 default hr_api.g_varchar2
312: ,p_field_value1 in varchar2 default hr_api.g_varchar2
313: ,p_field_name2 in varchar2 default hr_api.g_varchar2
314: ,p_field_value2 in varchar2 default hr_api.g_varchar2
315: ,p_field_name3 in varchar2 default hr_api.g_varchar2
316: ,p_field_value3 in varchar2 default hr_api.g_varchar2
309: ,p_password_field in varchar2 default hr_api.g_varchar2
310: ,p_authentication_needed in varchar2 default hr_api.g_varchar2
311: ,p_field_name1 in varchar2 default hr_api.g_varchar2
312: ,p_field_value1 in varchar2 default hr_api.g_varchar2
313: ,p_field_name2 in varchar2 default hr_api.g_varchar2
314: ,p_field_value2 in varchar2 default hr_api.g_varchar2
315: ,p_field_name3 in varchar2 default hr_api.g_varchar2
316: ,p_field_value3 in varchar2 default hr_api.g_varchar2
317: ,p_field_name4 in varchar2 default hr_api.g_varchar2
310: ,p_authentication_needed in varchar2 default hr_api.g_varchar2
311: ,p_field_name1 in varchar2 default hr_api.g_varchar2
312: ,p_field_value1 in varchar2 default hr_api.g_varchar2
313: ,p_field_name2 in varchar2 default hr_api.g_varchar2
314: ,p_field_value2 in varchar2 default hr_api.g_varchar2
315: ,p_field_name3 in varchar2 default hr_api.g_varchar2
316: ,p_field_value3 in varchar2 default hr_api.g_varchar2
317: ,p_field_name4 in varchar2 default hr_api.g_varchar2
318: ,p_field_value4 in varchar2 default hr_api.g_varchar2
311: ,p_field_name1 in varchar2 default hr_api.g_varchar2
312: ,p_field_value1 in varchar2 default hr_api.g_varchar2
313: ,p_field_name2 in varchar2 default hr_api.g_varchar2
314: ,p_field_value2 in varchar2 default hr_api.g_varchar2
315: ,p_field_name3 in varchar2 default hr_api.g_varchar2
316: ,p_field_value3 in varchar2 default hr_api.g_varchar2
317: ,p_field_name4 in varchar2 default hr_api.g_varchar2
318: ,p_field_value4 in varchar2 default hr_api.g_varchar2
319: ,p_field_name5 in varchar2 default hr_api.g_varchar2
312: ,p_field_value1 in varchar2 default hr_api.g_varchar2
313: ,p_field_name2 in varchar2 default hr_api.g_varchar2
314: ,p_field_value2 in varchar2 default hr_api.g_varchar2
315: ,p_field_name3 in varchar2 default hr_api.g_varchar2
316: ,p_field_value3 in varchar2 default hr_api.g_varchar2
317: ,p_field_name4 in varchar2 default hr_api.g_varchar2
318: ,p_field_value4 in varchar2 default hr_api.g_varchar2
319: ,p_field_name5 in varchar2 default hr_api.g_varchar2
320: ,p_field_value5 in varchar2 default hr_api.g_varchar2
313: ,p_field_name2 in varchar2 default hr_api.g_varchar2
314: ,p_field_value2 in varchar2 default hr_api.g_varchar2
315: ,p_field_name3 in varchar2 default hr_api.g_varchar2
316: ,p_field_value3 in varchar2 default hr_api.g_varchar2
317: ,p_field_name4 in varchar2 default hr_api.g_varchar2
318: ,p_field_value4 in varchar2 default hr_api.g_varchar2
319: ,p_field_name5 in varchar2 default hr_api.g_varchar2
320: ,p_field_value5 in varchar2 default hr_api.g_varchar2
321: ,p_field_name6 in varchar2 default hr_api.g_varchar2
314: ,p_field_value2 in varchar2 default hr_api.g_varchar2
315: ,p_field_name3 in varchar2 default hr_api.g_varchar2
316: ,p_field_value3 in varchar2 default hr_api.g_varchar2
317: ,p_field_name4 in varchar2 default hr_api.g_varchar2
318: ,p_field_value4 in varchar2 default hr_api.g_varchar2
319: ,p_field_name5 in varchar2 default hr_api.g_varchar2
320: ,p_field_value5 in varchar2 default hr_api.g_varchar2
321: ,p_field_name6 in varchar2 default hr_api.g_varchar2
322: ,p_field_value6 in varchar2 default hr_api.g_varchar2
315: ,p_field_name3 in varchar2 default hr_api.g_varchar2
316: ,p_field_value3 in varchar2 default hr_api.g_varchar2
317: ,p_field_name4 in varchar2 default hr_api.g_varchar2
318: ,p_field_value4 in varchar2 default hr_api.g_varchar2
319: ,p_field_name5 in varchar2 default hr_api.g_varchar2
320: ,p_field_value5 in varchar2 default hr_api.g_varchar2
321: ,p_field_name6 in varchar2 default hr_api.g_varchar2
322: ,p_field_value6 in varchar2 default hr_api.g_varchar2
323: ,p_field_name7 in varchar2 default hr_api.g_varchar2
316: ,p_field_value3 in varchar2 default hr_api.g_varchar2
317: ,p_field_name4 in varchar2 default hr_api.g_varchar2
318: ,p_field_value4 in varchar2 default hr_api.g_varchar2
319: ,p_field_name5 in varchar2 default hr_api.g_varchar2
320: ,p_field_value5 in varchar2 default hr_api.g_varchar2
321: ,p_field_name6 in varchar2 default hr_api.g_varchar2
322: ,p_field_value6 in varchar2 default hr_api.g_varchar2
323: ,p_field_name7 in varchar2 default hr_api.g_varchar2
324: ,p_field_value7 in varchar2 default hr_api.g_varchar2
317: ,p_field_name4 in varchar2 default hr_api.g_varchar2
318: ,p_field_value4 in varchar2 default hr_api.g_varchar2
319: ,p_field_name5 in varchar2 default hr_api.g_varchar2
320: ,p_field_value5 in varchar2 default hr_api.g_varchar2
321: ,p_field_name6 in varchar2 default hr_api.g_varchar2
322: ,p_field_value6 in varchar2 default hr_api.g_varchar2
323: ,p_field_name7 in varchar2 default hr_api.g_varchar2
324: ,p_field_value7 in varchar2 default hr_api.g_varchar2
325: ,p_field_name8 in varchar2 default hr_api.g_varchar2
318: ,p_field_value4 in varchar2 default hr_api.g_varchar2
319: ,p_field_name5 in varchar2 default hr_api.g_varchar2
320: ,p_field_value5 in varchar2 default hr_api.g_varchar2
321: ,p_field_name6 in varchar2 default hr_api.g_varchar2
322: ,p_field_value6 in varchar2 default hr_api.g_varchar2
323: ,p_field_name7 in varchar2 default hr_api.g_varchar2
324: ,p_field_value7 in varchar2 default hr_api.g_varchar2
325: ,p_field_name8 in varchar2 default hr_api.g_varchar2
326: ,p_field_value8 in varchar2 default hr_api.g_varchar2
319: ,p_field_name5 in varchar2 default hr_api.g_varchar2
320: ,p_field_value5 in varchar2 default hr_api.g_varchar2
321: ,p_field_name6 in varchar2 default hr_api.g_varchar2
322: ,p_field_value6 in varchar2 default hr_api.g_varchar2
323: ,p_field_name7 in varchar2 default hr_api.g_varchar2
324: ,p_field_value7 in varchar2 default hr_api.g_varchar2
325: ,p_field_name8 in varchar2 default hr_api.g_varchar2
326: ,p_field_value8 in varchar2 default hr_api.g_varchar2
327: ,p_field_name9 in varchar2 default hr_api.g_varchar2
320: ,p_field_value5 in varchar2 default hr_api.g_varchar2
321: ,p_field_name6 in varchar2 default hr_api.g_varchar2
322: ,p_field_value6 in varchar2 default hr_api.g_varchar2
323: ,p_field_name7 in varchar2 default hr_api.g_varchar2
324: ,p_field_value7 in varchar2 default hr_api.g_varchar2
325: ,p_field_name8 in varchar2 default hr_api.g_varchar2
326: ,p_field_value8 in varchar2 default hr_api.g_varchar2
327: ,p_field_name9 in varchar2 default hr_api.g_varchar2
328: ,p_field_value9 in varchar2 default hr_api.g_varchar2
321: ,p_field_name6 in varchar2 default hr_api.g_varchar2
322: ,p_field_value6 in varchar2 default hr_api.g_varchar2
323: ,p_field_name7 in varchar2 default hr_api.g_varchar2
324: ,p_field_value7 in varchar2 default hr_api.g_varchar2
325: ,p_field_name8 in varchar2 default hr_api.g_varchar2
326: ,p_field_value8 in varchar2 default hr_api.g_varchar2
327: ,p_field_name9 in varchar2 default hr_api.g_varchar2
328: ,p_field_value9 in varchar2 default hr_api.g_varchar2
329: ,p_object_version_number in out nocopy number
322: ,p_field_value6 in varchar2 default hr_api.g_varchar2
323: ,p_field_name7 in varchar2 default hr_api.g_varchar2
324: ,p_field_value7 in varchar2 default hr_api.g_varchar2
325: ,p_field_name8 in varchar2 default hr_api.g_varchar2
326: ,p_field_value8 in varchar2 default hr_api.g_varchar2
327: ,p_field_name9 in varchar2 default hr_api.g_varchar2
328: ,p_field_value9 in varchar2 default hr_api.g_varchar2
329: ,p_object_version_number in out nocopy number
330: );
323: ,p_field_name7 in varchar2 default hr_api.g_varchar2
324: ,p_field_value7 in varchar2 default hr_api.g_varchar2
325: ,p_field_name8 in varchar2 default hr_api.g_varchar2
326: ,p_field_value8 in varchar2 default hr_api.g_varchar2
327: ,p_field_name9 in varchar2 default hr_api.g_varchar2
328: ,p_field_value9 in varchar2 default hr_api.g_varchar2
329: ,p_object_version_number in out nocopy number
330: );
331: --
324: ,p_field_value7 in varchar2 default hr_api.g_varchar2
325: ,p_field_name8 in varchar2 default hr_api.g_varchar2
326: ,p_field_value8 in varchar2 default hr_api.g_varchar2
327: ,p_field_name9 in varchar2 default hr_api.g_varchar2
328: ,p_field_value9 in varchar2 default hr_api.g_varchar2
329: ,p_object_version_number in out nocopy number
330: );
331: --
332: -- ----------------------------------------------------------------------------