DBA Data[Home] [Help]

APPS.HR_QUESTIONNAIRE_SWI dependencies on HR_API

Line 50: ,p_effective_date in date default hr_api.g_date

46: ,p_text in CLOB
47: ,p_available_flag in varchar2
48: ,p_business_group_id in number
49: ,p_object_version_number out nocopy number
50: ,p_effective_date in date default hr_api.g_date
51: ,p_validate in number default hr_api.g_false_num
52: ,p_quest_type_code in varchar2
53: ,p_return_status out nocopy varchar2) is
54:

Line 51: ,p_validate in number default hr_api.g_false_num

47: ,p_available_flag in varchar2
48: ,p_business_group_id in number
49: ,p_object_version_number out nocopy number
50: ,p_effective_date in date default hr_api.g_date
51: ,p_validate in number default hr_api.g_false_num
52: ,p_quest_type_code in varchar2
53: ,p_return_status out nocopy varchar2) is
54:
55: --

Line 81: hr_api.constant_to_boolean

77: --
78: -- Convert constant values to their corresponding boolean value
79: --
80: l_validate :=
81: hr_api.constant_to_boolean
82: (p_constant_value => p_validate);
83: --
84: -- Register Surrogate ID or user key values
85: --

Line 163: ,p_available_flag in varchar2 default hr_api.g_varchar2

159: Procedure update_questionnaire
160: (p_questionnaire_template_id in number
161: ,p_object_version_number in out nocopy number
162: ,p_text in CLOB
163: ,p_available_flag in varchar2 default hr_api.g_varchar2
164: ,p_business_group_id in number default hr_api.g_number
165: ,p_effective_date in date default hr_api.g_date
166: ,p_validate in number default hr_api.g_false_num
167: ,p_quest_type_code in varchar2

Line 164: ,p_business_group_id in number default hr_api.g_number

160: (p_questionnaire_template_id in number
161: ,p_object_version_number in out nocopy number
162: ,p_text in CLOB
163: ,p_available_flag in varchar2 default hr_api.g_varchar2
164: ,p_business_group_id in number default hr_api.g_number
165: ,p_effective_date in date default hr_api.g_date
166: ,p_validate in number default hr_api.g_false_num
167: ,p_quest_type_code in varchar2
168: ,p_return_status out nocopy varchar2

Line 165: ,p_effective_date in date default hr_api.g_date

161: ,p_object_version_number in out nocopy number
162: ,p_text in CLOB
163: ,p_available_flag in varchar2 default hr_api.g_varchar2
164: ,p_business_group_id in number default hr_api.g_number
165: ,p_effective_date in date default hr_api.g_date
166: ,p_validate in number default hr_api.g_false_num
167: ,p_quest_type_code in varchar2
168: ,p_return_status out nocopy varchar2
169: ) is

Line 166: ,p_validate in number default hr_api.g_false_num

162: ,p_text in CLOB
163: ,p_available_flag in varchar2 default hr_api.g_varchar2
164: ,p_business_group_id in number default hr_api.g_number
165: ,p_effective_date in date default hr_api.g_date
166: ,p_validate in number default hr_api.g_false_num
167: ,p_quest_type_code in varchar2
168: ,p_return_status out nocopy varchar2
169: ) is
170: --

Line 207: hr_api.constant_to_boolean

203: --
204: -- Convert constant values to their corresponding boolean value
205: --
206: l_validate :=
207: hr_api.constant_to_boolean
208: (p_constant_value => p_validate);
209: --
210: -- Register Surrogate ID or user key values
211: --

Line 239: IF NOT (p_text = hr_api.g_varchar2) THEN

235: --
236: -- Check if the Text is updated, delete all fields.
237: -- From Java Layer the Text value will Not be passed
238: -- in case the Text is not updated.
239: IF NOT (p_text = hr_api.g_varchar2) THEN
240: delete_questionnaire_fields (
241: p_questionnaire_template_id => p_questionnaire_template_id
242: );
243: END IF;

Line 286: ,p_validate in number default hr_api.g_false_num

282:
283: Procedure delete_questionnaire
284: (p_questionnaire_template_id in number
285: ,p_object_version_number in number
286: ,p_validate in number default hr_api.g_false_num
287: ,p_return_status out nocopy varchar2
288: ) is
289:
290: --

Line 317: hr_api.constant_to_boolean

313: --
314: -- Convert constant values to their corresponding boolean value
315: --
316: l_validate :=
317: hr_api.constant_to_boolean
318: (p_constant_value => p_validate);
319: --
320:
321: -- Register Surrogate ID or user key values