8: -- ----------------------------------------------------------------------------
9: -- |----------------------------< create_document >---------------------------|
10: -- ----------------------------------------------------------------------------
11: PROCEDURE create_document
12: (p_validate in number default hr_api.g_false_num
13: ,p_effective_date in date
14: ,p_type in varchar2
15: ,p_person_id in number
16: ,p_mime_type in varchar2
47: --
48: -- Convert constant values to their corresponding boolean value
49: --
50: l_validate :=
51: hr_api.constant_to_boolean
52: (p_constant_value => p_validate);
53: --
54: -- Register Surrogate ID or user key values
55: --
124: -- ----------------------------------------------------------------------------
125: -- |----------------------------< delete_document >---------------------------|
126: -- ----------------------------------------------------------------------------
127: PROCEDURE delete_document
128: (p_validate in number default hr_api.g_false_num
129: ,p_effective_date in date
130: ,p_document_id in number
131: ,p_object_version_number in number
132: ,p_person_id in number
161: --
162: -- Convert constant values to their corresponding boolean value
163: --
164: l_validate :=
165: hr_api.constant_to_boolean
166: (p_constant_value => p_validate);
167: --
168: -- Register Surrogate ID or user key values
169: --
234: -- ----------------------------------------------------------------------------
235: -- |----------------------------< update_document >---------------------------|
236: -- ----------------------------------------------------------------------------
237: PROCEDURE update_document
238: (p_validate in number default hr_api.g_false_num
239: ,p_effective_date in date
240: ,p_document_id in number
241: ,p_mime_type in varchar2 default hr_api.g_varchar2
242: ,p_type in varchar2 default hr_api.g_varchar2
237: PROCEDURE update_document
238: (p_validate in number default hr_api.g_false_num
239: ,p_effective_date in date
240: ,p_document_id in number
241: ,p_mime_type in varchar2 default hr_api.g_varchar2
242: ,p_type in varchar2 default hr_api.g_varchar2
243: ,p_file_name in varchar2 default hr_api.g_varchar2
244: ,p_description in varchar2 default hr_api.g_varchar2
245: ,p_person_id In number default hr_api.g_number
238: (p_validate in number default hr_api.g_false_num
239: ,p_effective_date in date
240: ,p_document_id in number
241: ,p_mime_type in varchar2 default hr_api.g_varchar2
242: ,p_type in varchar2 default hr_api.g_varchar2
243: ,p_file_name in varchar2 default hr_api.g_varchar2
244: ,p_description in varchar2 default hr_api.g_varchar2
245: ,p_person_id In number default hr_api.g_number
246: ,p_party_id in number default hr_api.g_number
239: ,p_effective_date in date
240: ,p_document_id in number
241: ,p_mime_type in varchar2 default hr_api.g_varchar2
242: ,p_type in varchar2 default hr_api.g_varchar2
243: ,p_file_name in varchar2 default hr_api.g_varchar2
244: ,p_description in varchar2 default hr_api.g_varchar2
245: ,p_person_id In number default hr_api.g_number
246: ,p_party_id in number default hr_api.g_number
247: ,p_end_date In Date default hr_api.g_date
240: ,p_document_id in number
241: ,p_mime_type in varchar2 default hr_api.g_varchar2
242: ,p_type in varchar2 default hr_api.g_varchar2
243: ,p_file_name in varchar2 default hr_api.g_varchar2
244: ,p_description in varchar2 default hr_api.g_varchar2
245: ,p_person_id In number default hr_api.g_number
246: ,p_party_id in number default hr_api.g_number
247: ,p_end_date In Date default hr_api.g_date
248: ,p_assignment_id In number default hr_api.g_number
241: ,p_mime_type in varchar2 default hr_api.g_varchar2
242: ,p_type in varchar2 default hr_api.g_varchar2
243: ,p_file_name in varchar2 default hr_api.g_varchar2
244: ,p_description in varchar2 default hr_api.g_varchar2
245: ,p_person_id In number default hr_api.g_number
246: ,p_party_id in number default hr_api.g_number
247: ,p_end_date In Date default hr_api.g_date
248: ,p_assignment_id In number default hr_api.g_number
249: ,p_object_version_number in out nocopy number
242: ,p_type in varchar2 default hr_api.g_varchar2
243: ,p_file_name in varchar2 default hr_api.g_varchar2
244: ,p_description in varchar2 default hr_api.g_varchar2
245: ,p_person_id In number default hr_api.g_number
246: ,p_party_id in number default hr_api.g_number
247: ,p_end_date In Date default hr_api.g_date
248: ,p_assignment_id In number default hr_api.g_number
249: ,p_object_version_number in out nocopy number
250: ,p_new_doc_id out nocopy number
243: ,p_file_name in varchar2 default hr_api.g_varchar2
244: ,p_description in varchar2 default hr_api.g_varchar2
245: ,p_person_id In number default hr_api.g_number
246: ,p_party_id in number default hr_api.g_number
247: ,p_end_date In Date default hr_api.g_date
248: ,p_assignment_id In number default hr_api.g_number
249: ,p_object_version_number in out nocopy number
250: ,p_new_doc_id out nocopy number
251: ,p_return_status out nocopy varchar2
244: ,p_description in varchar2 default hr_api.g_varchar2
245: ,p_person_id In number default hr_api.g_number
246: ,p_party_id in number default hr_api.g_number
247: ,p_end_date In Date default hr_api.g_date
248: ,p_assignment_id In number default hr_api.g_number
249: ,p_object_version_number in out nocopy number
250: ,p_new_doc_id out nocopy number
251: ,p_return_status out nocopy varchar2
252: ) is
277: --
278: -- Convert constant values to their corresponding boolean value
279: --
280: l_validate :=
281: hr_api.constant_to_boolean
282: (p_constant_value => p_validate);
283: --
284: -- Register Surrogate ID or user key values
285: --