8: -- ----------------------------------------------------------------------------
9: -- |------------------------< create_rec_team_member >------------------------|
10: -- ----------------------------------------------------------------------------
11: PROCEDURE create_rec_team_member
12: (p_validate in number default hr_api.g_false_num
13: ,p_rec_team_member_id in number
14: ,p_person_id in number
15: ,p_vacancy_id in number
16: ,p_job_id in number default null
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_rec_team_member >------------------------|
126: -- ----------------------------------------------------------------------------
127: PROCEDURE delete_rec_team_member
128: (p_validate in number default hr_api.g_false_num
129: ,p_rec_team_member_id in number
130: ,p_object_version_number in number
131: ,p_return_status out nocopy varchar2
132: ) is
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: --
232: -- ----------------------------------------------------------------------------
233: -- |------------------------< update_rec_team_member >------------------------|
234: -- ----------------------------------------------------------------------------
235: PROCEDURE update_rec_team_member
236: (p_validate in number default hr_api.g_false_num
237: ,p_rec_team_member_id in number
238: ,p_person_id in number default hr_api.g_number
239: ,p_party_id in number default hr_api.g_number
240: ,p_vacancy_id in number default hr_api.g_number
234: -- ----------------------------------------------------------------------------
235: PROCEDURE update_rec_team_member
236: (p_validate in number default hr_api.g_false_num
237: ,p_rec_team_member_id in number
238: ,p_person_id in number default hr_api.g_number
239: ,p_party_id in number default hr_api.g_number
240: ,p_vacancy_id in number default hr_api.g_number
241: ,p_object_version_number in out nocopy number
242: ,p_job_id in number default hr_api.g_number
235: PROCEDURE update_rec_team_member
236: (p_validate in number default hr_api.g_false_num
237: ,p_rec_team_member_id in number
238: ,p_person_id in number default hr_api.g_number
239: ,p_party_id in number default hr_api.g_number
240: ,p_vacancy_id in number default hr_api.g_number
241: ,p_object_version_number in out nocopy number
242: ,p_job_id in number default hr_api.g_number
243: ,p_start_date in date default hr_api.g_date
236: (p_validate in number default hr_api.g_false_num
237: ,p_rec_team_member_id in number
238: ,p_person_id in number default hr_api.g_number
239: ,p_party_id in number default hr_api.g_number
240: ,p_vacancy_id in number default hr_api.g_number
241: ,p_object_version_number in out nocopy number
242: ,p_job_id in number default hr_api.g_number
243: ,p_start_date in date default hr_api.g_date
244: ,p_end_date in date default hr_api.g_date
238: ,p_person_id in number default hr_api.g_number
239: ,p_party_id in number default hr_api.g_number
240: ,p_vacancy_id in number default hr_api.g_number
241: ,p_object_version_number in out nocopy number
242: ,p_job_id in number default hr_api.g_number
243: ,p_start_date in date default hr_api.g_date
244: ,p_end_date in date default hr_api.g_date
245: ,p_update_allowed in varchar2 default hr_api.g_varchar2
246: ,p_delete_allowed in varchar2 default hr_api.g_varchar2
239: ,p_party_id in number default hr_api.g_number
240: ,p_vacancy_id in number default hr_api.g_number
241: ,p_object_version_number in out nocopy number
242: ,p_job_id in number default hr_api.g_number
243: ,p_start_date in date default hr_api.g_date
244: ,p_end_date in date default hr_api.g_date
245: ,p_update_allowed in varchar2 default hr_api.g_varchar2
246: ,p_delete_allowed in varchar2 default hr_api.g_varchar2
247: ,p_interview_security in varchar2 default 'SELF'
240: ,p_vacancy_id in number default hr_api.g_number
241: ,p_object_version_number in out nocopy number
242: ,p_job_id in number default hr_api.g_number
243: ,p_start_date in date default hr_api.g_date
244: ,p_end_date in date default hr_api.g_date
245: ,p_update_allowed in varchar2 default hr_api.g_varchar2
246: ,p_delete_allowed in varchar2 default hr_api.g_varchar2
247: ,p_interview_security in varchar2 default 'SELF'
248: ,p_return_status out nocopy varchar2
241: ,p_object_version_number in out nocopy number
242: ,p_job_id in number default hr_api.g_number
243: ,p_start_date in date default hr_api.g_date
244: ,p_end_date in date default hr_api.g_date
245: ,p_update_allowed in varchar2 default hr_api.g_varchar2
246: ,p_delete_allowed in varchar2 default hr_api.g_varchar2
247: ,p_interview_security in varchar2 default 'SELF'
248: ,p_return_status out nocopy varchar2
249: ) is
242: ,p_job_id in number default hr_api.g_number
243: ,p_start_date in date default hr_api.g_date
244: ,p_end_date in date default hr_api.g_date
245: ,p_update_allowed in varchar2 default hr_api.g_varchar2
246: ,p_delete_allowed in varchar2 default hr_api.g_varchar2
247: ,p_interview_security in varchar2 default 'SELF'
248: ,p_return_status out nocopy varchar2
249: ) is
250: --
273: --
274: -- Convert constant values to their corresponding boolean value
275: --
276: l_validate :=
277: hr_api.constant_to_boolean
278: (p_constant_value => p_validate);
279: --
280: -- Register Surrogate ID or user key values
281: --
353: procedure process_api
354: (
355: p_document in CLOB
356: ,p_return_status out nocopy VARCHAR2
357: ,p_validate in number default hr_api.g_false_num
358: ,p_effective_date in date default null
359: )
360: IS
361: l_postState VARCHAR2(2);