239: l_postState := xmldom.getAttribute(l_commitElement, 'PS');
240: --
241: --Get the values for in/out parameters
242: --
243: l_object_version_number := hr_transaction_swi.getNumberValue(l_CommitNode,'ObjectVersionNumber');
244: --
245: if p_effective_date is null then
246: l_effective_date := trunc(sysdate);
247: else
254: --
255: create_variable_compensation
256: (p_validate => p_validate
257: ,p_effective_date => l_effective_date
258: ,p_vacancy_id => hr_transaction_swi.getNumberValue(l_CommitNode,'VacancyId',NULL)
259: ,p_variable_comp_lookup => hr_transaction_swi.getVarchar2Value(l_CommitNode,'VariableCompLookup',NULL)
260: ,p_object_version_number => l_object_version_number
261: ,p_return_status => l_return_status
262: );
255: create_variable_compensation
256: (p_validate => p_validate
257: ,p_effective_date => l_effective_date
258: ,p_vacancy_id => hr_transaction_swi.getNumberValue(l_CommitNode,'VacancyId',NULL)
259: ,p_variable_comp_lookup => hr_transaction_swi.getVarchar2Value(l_CommitNode,'VariableCompLookup',NULL)
260: ,p_object_version_number => l_object_version_number
261: ,p_return_status => l_return_status
262: );
263: --
267: --
268: delete_variable_compensation
269: (p_validate => p_validate
270: ,p_object_version_number => l_object_version_number
271: ,p_vacancy_id => hr_transaction_swi.getNumberValue(l_CommitNode,'VacancyId',NULL)
272: ,p_variable_comp_lookup => hr_transaction_swi.getVarchar2Value(l_CommitNode,'VariableCompLookup',NULL)
273: ,p_return_status => l_return_status
274: );
275: --
268: delete_variable_compensation
269: (p_validate => p_validate
270: ,p_object_version_number => l_object_version_number
271: ,p_vacancy_id => hr_transaction_swi.getNumberValue(l_CommitNode,'VacancyId',NULL)
272: ,p_variable_comp_lookup => hr_transaction_swi.getVarchar2Value(l_CommitNode,'VariableCompLookup',NULL)
273: ,p_return_status => l_return_status
274: );
275: --
276: end if;