APPS.OTA_ACI_DEL dependencies on OTA_ACT_CAT_INCLUSIONS

Line 62: -- Delete the ota_act_cat_inclusions row.

58: hr_utility.set_location('Entering:'||l_proc, 5);
59: --
60: ota_aci_shd.g_api_dml := true; -- Set the api dml status
61: --
62: -- Delete the ota_act_cat_inclusions row.
63: --
64: delete from ota_act_cat_inclusions
65: where activity_version_id = p_rec.activity_version_id
66: and category_usage_id = p_rec.category_usage_id;

Line 64: delete from ota_act_cat_inclusions

60: ota_aci_shd.g_api_dml := true; -- Set the api dml status
61: --
62: -- Delete the ota_act_cat_inclusions row.
63: --
64: delete from ota_act_cat_inclusions
65: where activity_version_id = p_rec.activity_version_id
66: and category_usage_id = p_rec.category_usage_id;
67: --
68: ota_aci_shd.g_api_dml := false; -- Unset the api dml status

Line 233: (p_module_name => 'OTA_ACT_CAT_INCLUSIONS'

229: --
230: when hr_api.cannot_find_prog_unit then
231: --
232: hr_api.cannot_find_prog_unit_error
233: (p_module_name => 'OTA_ACT_CAT_INCLUSIONS'
234: ,p_hook_type => 'AD');
235: --
236: end;
237: --