DBA Data[Home] [Help]

APPS.PER_SOS_BUS dependencies on HR_API

Line 59: hr_api.mandatory_arg_error

55: hr_utility.set_location('Entering:'|| l_proc, 10);
56: --
57: -- Ensure that all the mandatory parameter are not null
58: --
59: hr_api.mandatory_arg_error
60: (p_api_name => l_proc
61: ,p_argument => 'solution_id'
62: ,p_argument_value => p_solution_id
63: );

Line 64: hr_api.mandatory_arg_error

60: (p_api_name => l_proc
61: ,p_argument => 'solution_id'
62: ,p_argument_value => p_solution_id
63: );
64: hr_api.mandatory_arg_error
65: (p_api_name => l_proc
66: ,p_argument => 'solution_set_name'
67: ,p_argument_value => p_solution_set_name
68: );

Line 69: hr_api.mandatory_arg_error

65: (p_api_name => l_proc
66: ,p_argument => 'solution_set_name'
67: ,p_argument_value => p_solution_set_name
68: );
69: hr_api.mandatory_arg_error
70: (p_api_name => l_proc
71: ,p_argument => 'user_id'
72: ,p_argument_value => p_user_id
73: );

Line 99: hr_api.set_security_group_id

95: close csr_sec_grp;
96: --
97: -- Set the security_group_id in CLIENT_INFO
98: --
99: hr_api.set_security_group_id
100: (p_security_group_id => l_security_group_id
101: );
102: end if;
103: --

Line 147: hr_api.mandatory_arg_error

143: hr_utility.set_location('Entering:'|| l_proc, 10);
144: --
145: -- Ensure that all the mandatory parameter are not null
146: --
147: hr_api.mandatory_arg_error
148: (p_api_name => l_proc
149: ,p_argument => 'solution_id'
150: ,p_argument_value => p_solution_id
151: );

Line 152: hr_api.mandatory_arg_error

148: (p_api_name => l_proc
149: ,p_argument => 'solution_id'
150: ,p_argument_value => p_solution_id
151: );
152: hr_api.mandatory_arg_error
153: (p_api_name => l_proc
154: ,p_argument => 'solution_set_name'
155: ,p_argument_value => p_solution_set_name
156: );

Line 157: hr_api.mandatory_arg_error

153: (p_api_name => l_proc
154: ,p_argument => 'solution_set_name'
155: ,p_argument_value => p_solution_set_name
156: );
157: hr_api.mandatory_arg_error
158: (p_api_name => l_proc
159: ,p_argument => 'user_id'
160: ,p_argument_value => p_user_id
161: );

Line 163: if (( nvl(per_sos_bus.g_solution_id, hr_api.g_number)

159: ,p_argument => 'user_id'
160: ,p_argument_value => p_user_id
161: );
162: --
163: if (( nvl(per_sos_bus.g_solution_id, hr_api.g_number)
164: = p_solution_id)
165: and ( nvl(per_sos_bus.g_solution_set_name, hr_api.g_varchar2)
166: = p_solution_set_name)
167: and ( nvl(per_sos_bus.g_user_id, hr_api.g_number)

Line 165: and ( nvl(per_sos_bus.g_solution_set_name, hr_api.g_varchar2)

161: );
162: --
163: if (( nvl(per_sos_bus.g_solution_id, hr_api.g_number)
164: = p_solution_id)
165: and ( nvl(per_sos_bus.g_solution_set_name, hr_api.g_varchar2)
166: = p_solution_set_name)
167: and ( nvl(per_sos_bus.g_user_id, hr_api.g_number)
168: = p_user_id)) then
169: --

Line 167: and ( nvl(per_sos_bus.g_user_id, hr_api.g_number)

163: if (( nvl(per_sos_bus.g_solution_id, hr_api.g_number)
164: = p_solution_id)
165: and ( nvl(per_sos_bus.g_solution_set_name, hr_api.g_varchar2)
166: = p_solution_set_name)
167: and ( nvl(per_sos_bus.g_user_id, hr_api.g_number)
168: = p_user_id)) then
169: --
170: -- The legislation code has already been found with a previous
171: -- call to this function. Just return the value in the global