APPS.OTA_TSR_DEL dependencies on OTA_RESOURCE_DEFINITIONS

Line 54: l_resDefId ota_resource_definitions.resource_definition_id%type;

50: -- ----------------------------------------------------------------------------
51: Procedure delete_dml(p_rec in ota_tsr_shd.g_rec_type) is
52: --
53: l_proc varchar2(72) := g_package||'delete_dml';
54: l_resDefId ota_resource_definitions.resource_definition_id%type;
55: --
56: Begin
57: hr_utility.set_location('Entering:'||l_proc, 5);
58: --

Line 78: delete from ota_resource_definitions

74:
75: begin
76:
77:
78: delete from ota_resource_definitions
79: where resource_definition_id = l_resDefId;
80:
81: Exception
82: When Others Then