8: -- ----------------------------------------------------------------------------
9: -- |----------------------------< delete_tkt_dtls >---------------------------|
10: -- ----------------------------------------------------------------------------
11: PROCEDURE delete_tkt_dtls
12: (p_validate in number default hr_api.g_false_num
13: ,p_tatigkeit_detail_id in number
14: ,p_object_version_number in number
15: ,p_return_status out nocopy varchar2
16: ) is
38: --
39: -- Convert constant values to their corresponding boolean value
40: --
41: l_validate :=
42: hr_api.constant_to_boolean
43: (p_constant_value => p_validate);
44: --
45: -- Register Surrogate ID or user key values
46: --
102: -- ----------------------------------------------------------------------------
103: -- |----------------------------< insert_tkt_dtls >---------------------------|
104: -- ----------------------------------------------------------------------------
105: PROCEDURE insert_tkt_dtls
106: (p_validate in number default hr_api.g_false_num
107: ,p_effective_date in date
108: ,p_tatigkeit_number in varchar2 default hr_api.g_varchar2
109: ,p_description in varchar2
110: ,p_tatigkeit_detail_id out nocopy number
104: -- ----------------------------------------------------------------------------
105: PROCEDURE insert_tkt_dtls
106: (p_validate in number default hr_api.g_false_num
107: ,p_effective_date in date
108: ,p_tatigkeit_number in varchar2 default hr_api.g_varchar2
109: ,p_description in varchar2
110: ,p_tatigkeit_detail_id out nocopy number
111: ,p_object_version_number out nocopy number
112: ,p_return_status out nocopy varchar2
135: --
136: -- Convert constant values to their corresponding boolean value
137: --
138: l_validate :=
139: hr_api.constant_to_boolean
140: (p_constant_value => p_validate);
141: --
142: -- Register Surrogate ID or user key values
143: --
209: -- ----------------------------------------------------------------------------
210: -- |----------------------------< update_tkt_dtls >---------------------------|
211: -- ----------------------------------------------------------------------------
212: PROCEDURE update_tkt_dtls
213: (p_validate in number default hr_api.g_false_num
214: ,p_effective_date in date
215: ,p_tatigkeit_number in varchar2 default hr_api.g_varchar2
216: ,p_description in varchar2 default hr_api.g_varchar2
217: ,p_tatigkeit_detail_id in number
211: -- ----------------------------------------------------------------------------
212: PROCEDURE update_tkt_dtls
213: (p_validate in number default hr_api.g_false_num
214: ,p_effective_date in date
215: ,p_tatigkeit_number in varchar2 default hr_api.g_varchar2
216: ,p_description in varchar2 default hr_api.g_varchar2
217: ,p_tatigkeit_detail_id in number
218: ,p_object_version_number in out nocopy number
219: ,p_return_status out nocopy varchar2
212: PROCEDURE update_tkt_dtls
213: (p_validate in number default hr_api.g_false_num
214: ,p_effective_date in date
215: ,p_tatigkeit_number in varchar2 default hr_api.g_varchar2
216: ,p_description in varchar2 default hr_api.g_varchar2
217: ,p_tatigkeit_detail_id in number
218: ,p_object_version_number in out nocopy number
219: ,p_return_status out nocopy varchar2
220: ) is
242: --
243: -- Convert constant values to their corresponding boolean value
244: --
245: l_validate :=
246: hr_api.constant_to_boolean
247: (p_constant_value => p_validate);
248: --
249: -- Register Surrogate ID or user key values
250: --