56: hr_utility.set_location('Entering:'||l_proc, 5);
57: --
58: pay_pwo_shd.g_api_dml := true; -- Set the api dml status
59: --
60: -- Delete the pay_wci_occupations row.
61: --
62: delete from pay_wci_occupations
63: where occupation_id = p_rec.occupation_id;
64: --
58: pay_pwo_shd.g_api_dml := true; -- Set the api dml status
59: --
60: -- Delete the pay_wci_occupations row.
61: --
62: delete from pay_wci_occupations
63: where occupation_id = p_rec.occupation_id;
64: --
65: pay_pwo_shd.g_api_dml := false; -- Unset the api dml status
66: --
177: --
178: when hr_api.cannot_find_prog_unit then
179: --
180: hr_api.cannot_find_prog_unit_error
181: (p_module_name => 'pay_wci_occupations'
182: ,p_hook_type => 'AD');
183: --
184: end;
185: --