62: ota_srt_del.del_tl (p_supplied_resource_id => p_rec.supplied_resource_id);
63:
64:
65: select resource_definition_id into l_resDefId
66: from ota_suppliable_resources
67: where supplied_resource_id = p_rec.supplied_resource_id;
68:
69: -- Delete the ota_suppliable_resources row.
70: --
65: select resource_definition_id into l_resDefId
66: from ota_suppliable_resources
67: where supplied_resource_id = p_rec.supplied_resource_id;
68:
69: -- Delete the ota_suppliable_resources row.
70: --
71:
72: delete from ota_suppliable_resources
73: where supplied_resource_id = p_rec.supplied_resource_id;
68:
69: -- Delete the ota_suppliable_resources row.
70: --
71:
72: delete from ota_suppliable_resources
73: where supplied_resource_id = p_rec.supplied_resource_id;
74:
75: begin
76: